Re: name with ' - ' character

[Julie Baldwin]

try changing the double quotes around +strProducto+ to single quotes.

-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Xavier
Sent: Wednesday, March 24, 1999 3:26 AM
To: [EMAIL PROTECTED]
Subject: name with ' - ' character

Hi all !

I would like to ask you why can't I use a SQL Query like :

"SELECT ID-STC FROM artikel WHERE artikel.ID="+strProducto+";"

from a servlet ( I'm using acces and JDBC-ODBC Bridge) I always have the same

answer " Too few parameters. Expedted 1". I think that the problem is with the "-" character in the name,

but I can't change this name because it's an existing database.

how can I do it ? and if I use a "SELECT * ...." Then how can I read the value ?

Thanks in advance !

Xavier.