How To Show "HINDI" words in JSP page and how to SAVE "HINDI" words in MySql...Plz Help Me.. - Database Discussion Boards

Re: OleDb?

Wendelius22-Dec-08 1:50

Wendelius

22-Dec-08 1:50

hung1984 wrote:
In program, can we write any null value in a column in Access Database

No, only System.DBNull.

The need to optimize rises from a bad design.My articles[^]

Re: OleDb?

dec8222-Dec-08 1:57

dec82

22-Dec-08 1:57

For example, is this line allowed?

sCommand.Parameters.Add("@Model", OleDbType.VarChar, 20).Value = "";

Re: OleDb?

Jay Royall22-Dec-08 2:37

Jay Royall

22-Dec-08 2:37

Yes, that is allowed but it isn't a null value, it is an empty string.

get one row from each group

R111922-Dec-08 1:09

R1119

22-Dec-08 1:09

Hi to all,

I have a problem.

Actually i have a table in a database.In which there are four rows whose first two words of a column resembles.I want one of it.

And i have around 15 such similar groups.I want one from each.

Help me out.

Re: get one row from each group

Wendelius22-Dec-08 4:49

Wendelius

22-Dec-08 4:49

Could you post a little example with the source data, example what the output should look like and the SQL you've done so far.

The need to optimize rises from a bad design.My articles[^]

How to refer dll from our Application

SelvaSR21-Dec-08 22:49

SelvaSR

21-Dec-08 22:49

i have created one dll and i refer this from my Application(Windows)
while running it is showing COMException was unhandled Unknown error (0x80005000),can anyone suggest some solution.

Re: How to refer dll from our Application

Krishnraj21-Dec-08 22:59

Krishnraj

21-Dec-08 22:59

You have to add reference to yr application's bin folder by right click on that and click "Add Rererence"

OR

If yr dll in System32 folder then use below code:
First include below namespace

using System.Runtime.InteropServices;

and then give dll reference as shown below.

[DllImport("dllName.dll")]
        public static extern (function datatype) DllFunctionName();

Hope It will help u.

Krishnraj

How To Show "HINDI" words in JSP page and how to SAVE "HINDI" words in MySql...Plz Help Me..

kumar.cergenx21-Dec-08 19:59

kumar.cergenx

21-Dec-08 19:59

I am developing one web application which needs to supports multi lamguages like english,hinsi,punjab and gujarati. I am displaying the Labels from ApplicationResource.preoperties(english,hindi..etc) for all languages. But the problem is whenever i am trying to save&edit the values from DB, its displaying wrong charecters in jsp page.plz help me regarding the same..

Your help is highly appreciated....

Regards,
Kumar
kumar.cergenx@gmail.com

is view in sql server 2000 increase performance

Krishnraj21-Dec-08 19:11

Krishnraj

21-Dec-08 19:11

Hi all,

I have one silly question - is view in sql server 2000 increase performance ?

Krishnraj

Re: is view in sql server 2000 increase performance

Vimalsoft(Pty) Ltd21-Dec-08 20:42

Vimalsoft(Pty) Ltd

21-Dec-08 20:42

indexed View increase perfomance

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/SQL7/2000/2005/2008
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@its.co.za

Re: is view in sql server 2000 increase performance

deyaert22-Dec-08 1:36

deyaert

22-Dec-08 1:36

How is this accomplished? If you put indexes, aren't they on the table and not on the view?

Re: is view in sql server 2000 increase performance

Vimalsoft(Pty) Ltd22-Dec-08 1:44

Vimalsoft(Pty) Ltd

22-Dec-08 1:44

Indexes can be added in views and in tables

see this

http://www.novicksoftware.com/Articles/Indexed-Views-Basics-in-SQL-Server.htm[^]

http://articles.techrepublic.com.com/5100-10878_11-6160148.html[^]

http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx[^]

http://www.sqlteam.com/article/indexed-views-in-sql-server-2000[^]

I think i have Supplied enough info

Hope it helps

Query Help

Saiyed Alam21-Dec-08 18:05

Saiyed Alam

21-Dec-08 18:05

Hello Friends
I have two table name Commitment & CommitmentDetail. There is a field name IsRejected in Commitment Table and another name Remarks in CommitmentDetail Table. Now I need to write a query that will select or print Remarks only if the value of IsRejected is 3. Otherwise it will not.
Any Help will be appreciated.
Ahanking in Advance
Johnny

Re: Query Help

Wendelius21-Dec-08 18:33

Wendelius

21-Dec-08 18:33

If your logic is the same as in previous question, the query could be like:

SELECT
   Remarks =
      CASE (c.IsRejected = 1) THEN cd.Remarks
      ELSE null
   END,
FROM Commitment c 
     LEFT OUTER JOIN
     CommitmentDetail cd
     ON c.??? = cd.???

I didn't know what is the correct joining field, but you can fill that in.

The need to optimize rises from a bad design.My articles[^]

Re: Query Help

Saiyed Alam21-Dec-08 19:13

Saiyed Alam

21-Dec-08 19:13

Thank u So Much.

Re: Query Help

Wendelius22-Dec-08 4:43

Wendelius

22-Dec-08 4:43

You're welcome.

The need to optimize rises from a bad design.My articles[^]

how seacrh text from table column

amit sahu2021-Dec-08 17:38

amit sahu20

21-Dec-08 17:38

how can i search text from table column ..
i am using SQL server 2005

Re: how seacrh text from table column

Wendelius21-Dec-08 17:58

Wendelius

21-Dec-08 17:58

amit sahu20 wrote:
how can i search text from table column ..

You can use LIKE[^] operator.

The need to optimize rises from a bad design.My articles[^]

Re: how seacrh text from table column

Vimalsoft(Pty) Ltd21-Dec-08 20:44

Vimalsoft(Pty) Ltd

21-Dec-08 20:44

I Think that is what is covered in any SQL Book. And its the First chapters of the Book. If you did not buy one buy it now.

OleDb ?

dec8221-Dec-08 16:35

dec82

21-Dec-08 16:35

string cmd;
string field;
string parameter;
field = "Site,Model";
parameter = "@Site,@Model";
OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Database.mdb");
cmd = "INSERT INTO Run(" + field + ") values (" + parameter + ")";
OleDbCommand sCommand = new OleDbCommand(cmd);
sCommand.Connection = aConnection;
aConnection.Open();
sCommand.Parameters.Add("@Site", OleDbType.VarChar, 20);
sCommand.Parameters.Add("@Model", OleDbType.VarChar, 20);
sCommand.Parameters["@Site"].Value = CommunicationSettings.site;
sCommand.Parameters["@Model"].Value = CommunicationSettings.Select.ToString();
sCommand.ExecuteNonQuery();
aConnection.Close();

THat's my code, then i either get error:" Parameter @Model has no default value " or Data type mismatch ?

Thanks

Re: OleDb ?

Wendelius21-Dec-08 17:55

Wendelius

21-Dec-08 17:55

Use debugger and see what is the value of sCommand.Parameters["@Model"].Value after the assignment.

The need to optimize rises from a bad design.My articles[^]

Re: OleDb ?

dec8222-Dec-08 1:54

dec82

22-Dec-08 1:54

it's a string value, i really can not understand why there is a type- mismatch

Re: OleDb ?

Wendelius22-Dec-08 4:44

Wendelius

22-Dec-08 4:44

I can think of two possibilites. Either the value for the string is NULL or then the value is System.DBNull, but the column is defined as NOT NULL in the database.

The need to optimize rises from a bad design.My articles[^]

Re: OleDb ?

Rob Graham28-Dec-08 8:48

Rob Graham

28-Dec-08 8:48

Oledb does not support named parameters like SQL server does.
Your insert staement needs to use the question mark charcter (?) to indicate where a parameter should be substituted - it should expand to this:
"Insert into Run(Site, Model) values( ?, ?)";
The name provided for the parameter is basically irrelevant, only the order they are added to the parameters collection matters. The name can be used as a key ( as you are doing), to modify the OledbParameter properties after adding it to the collection, but it has no meaning in the insert sql statement itself; there you must use the '?' tokens to indicate a parameter.

You have asked this question before[^], and I gave you the same (correct) answer. Why are you still asking this?

how to register / config oledb provider in sql report server 2005?

YARON_PH21-Dec-08 4:45

YARON_PH

21-Dec-08 4:45

Hello,

I build a report that connect to access file with oledb provider and manage to see a preview of the report in the visual studio development environment.
But in the report server I get error massage: "An error has occurred during report processing.
An attempt has been made to use a data extension 'OLEDB' that is not registered for this report server" when I try to view the report.
(I think it has to do with security because it works fine in the visual studio development environment).

How can I solve this problem?

Thanks in advanced, yaron.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.