Re: name with ' - ' character

[Xavier]

I've just found the answer to my own question, ant I put it here

because someone could find the same problem.

 

If you have a name like Artikel.ID-STC or any other with the character ' - '

you just have to put Artikel.[ID-STC], that's all !

 

Thaks to everybody who answered my question !!

-----Mensaje original-----
De: Xavier <[EMAIL PROTECTED]>
Para: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Fecha: miércoles, 24 de marzo de 1999 11:38
Asunto: 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.