Brainache time (for me)...
I've got a SQL statement where the "where" clause is build up
programatically, depending on the option a user seleted:
<cfswitch expression="#attributes.type#">
<cfcase case="1">
<cfset where = "otherkey = #attributes.q#">
</cfcase>
...
<cfdefaultcase>
<cfset where = "tablekey = #attributes.q# OR tablecol =
'#attributes.q#'">
</cfdefaultcase>
</cfswitch>
<cfquery name="qname" datasource="#request.dsn#">
SELECT *
FROM tablename
WHERE #where#
</cfquery>
All looks well and good, but when this is run (CF5) passing something
that fires off the "default" case and with attributes.q EQ 50000126, I
get an error "Syntax error or access violation - Incorrect syntax near
'50000126'."
If I <cfoutput> the query and then c&p into query analyser, it works
fine:
SELECT *
FROM tablename
WHERE tablekey = 50000126 OR tablecol = '50000126'
Any ideas?
Cheers,
Tim.
-------------------------------------------------------
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
-------------------------------------------------------
rawnet ltd
Atrium Court
Bracknell [EMAIL PROTECTED]
Berkshire Tel : +44 (0) 1344 393 040
RG12 1BW, UK http://www.rawnet.com
-------------------------------------------------------
This message may contain information which is legally
privileged and/or confidential. If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
-------------------------------------------------------
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
