Do you see anything below that? I get the following when I use
<cfqueryparam>
| SELECT P.PID2
| FROM PAGE_LANGUAGE_XREF P
| WHERE P.PID1 = ?
|
| Query Parameter Value(s) -
| Parameter #1 = 24
and the query resolves fine.
I'm using SQL Server 7.
Thanks,
Evan
> -----Original Message-----
> From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 8:55 AM
> To: CF-Talk
> Subject: Oddness with cfqueryparam
>
>
> cfqueryparam doesnt seem to be doing as expected:
>
> <cfquery name="contacts" datasource="Contacts" >
> SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts
> WHERE
> LastName like '%<cfqueryparam value="form.what">%' ORDER BY LastName ASC
> </cfquery>
>
> Debugging shows
> Form Fields:</B>
> FIELDNAMES=WHAT
> WHAT=ch
> and the query as
> SQL =
> SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts
> WHERE
> LastName like '%?%' ORDER BY LastName ASC
>
> What gives ? Shouldnt cfqueryparam sanatise the string (for " and
> ; etc.) ?
>
> Regards,
>
> Thomas Chiverton,
> Intranet Architect and Desktop Analyst
> Office: 01565 757 909
> As a GUI, reality in useless...
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
