>
> 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..
Please post it to Macromedia, it might help somebody in the the
future who does not recognize the issue directly.
Jochem
--
Who needs virtual reality
if you can just dream?
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
