chr(34) is a double quote("). The ANSI SQL standard string literal
delimiter is a single quote('). MS Access and SQL Server allows use of ",
but most other databases do not. In ANSI SQL, the " is used as an escape
delimiter around names, like [] is used by MS Access and SQL Server.
HTH,
Tore.
-----Original Message-----
From: Alex Elger [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 11:53 AM
To: ActiveServerPages
Subject: ASP and Oracle
I am starting to use asp with oracle and i am having some problems.
This code used to work with Access;
txtSQL = "SELECT * FROM DocRep Where CATAGORY = " + chr(34) + Catagory +
chr(34) + " ORDER BY DOCNO;"
When i run it with oracle (After removing the trailing ;)
I get an invalid column name.
It is to do with the single/double quotes arround the variable/string.
if i run;
txtSQL = "SELECT * FROM DocRep Where CATAGORY = '3a' ORDER BY DOCNO"
It returns th proper results.
If anyone can help me i would be greatful.
Alex Elger
Micronage Ltd
[EMAIL PROTECTED]
---
You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
%%email.unsub%%
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
