spaces?
- j
james curran
technical director
nylon technology
<mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
212-691-1134
-----Original Message-----
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 5:53 PM
To: CF-Talk
Subject: RE: CFQUERYPARAM bug?
I'd wager that syntactically you would be stringing your variables together
with your keywords.... as in "WHERE
the_id=?AND the_other_id=?
....no space between the q-mark and the "AND". keywords are always
delimited by spaces. When the driver does the
"prepare" task it sees a bind placeholder abutting a keyword and throws an
error.
-Mark
-----Original Message-----
From: Jim Curran [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 4:31 PM
To: CF-Talk
Subject: CFQUERYPARAM bug?
Hey All,
Just figured i'd see if anyone else has insight on this:
Using 6.1 and MSSQL Server
<CFQUERY>
SELECT *
FROM table
WHERE the_id = <cfqueryparam value="#the_ID#"
cfsqltype="CF_SQL_INTEGER">
AND the_other_id = <cfqueryparam value="#the_other_ID#"
cfsqltype="CF_SQL_INTEGER">
</CFQUERY>
If i have *no* space after the first queryparam and before the return, I
get
an "invalid datatype conversion"
Seems as if the cfqueryparam does not apply spacing and the carrage return
and tab characters are lost preceding the AND...
It's simple to prevent... But wanted to see if I should post this to MACR
or
let it be..
- j
james curran
technical director
nylon technology
[EMAIL PROTECTED]
212-691-1134
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
