November 23rd, 2003, 09:53 AM
|
|
Registered User
|
|
Join Date: Oct 2003
Location: Florida
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
SQL Escapes
Is there a way to escape characters in the fieldnames within your SQL statements? For instance, see my example:
PHP Code:
sql = "SELECT [STRNO],[ST#REG],[STPROV],[STRCHECK],[STFRID],[STDLCI] " & _
"FROM [ABCTEST.STROPSP] " & _
"ORDER BY [STRNO] ASC"
Notice the # character? This ruins my SQL statement and forces an error when trying to connect to my DB2 datasource.
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
