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]
