Ok, I will bite, what is the strange error?
>>> [EMAIL PROTECTED] 09/06/2006 11:22 am >>>
Hi, All
I got a very strange error when i use <cfqueryparam> in <cfquery>. the
code is the following:
<cfquery name="getClient" datasource="#dsn#" >
SELECT TOP 1 *
FROM clients
WHERE client_id = <cfqueryparam cfsqltype="cf_sql_integer"
value="#session.client_id#">
</cfquery>
But the following code will run:
<cfquery name="getClient" datasource="#dsn#" maxrows="1">
SELECT *
FROM clients
WHERE client_id = <cfqueryparam cfsqltype="cf_sql_integer"
value="#session.client_id#">
</cfquery>
AND the following code will run as well
<cfquery name="getClient" datasource="#dsn#" maxrows="1">
SELECT TOP 1 *
FROM clients
WHERE client_id = <cfqueryparam cfsqltype="cf_sql_bigint"
value="#session.client_id#">
</cfquery>
in clients table, client_id column is integer.
Please does anyone have any idea about it? Thanks in advance!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
