Jason, give the whole problem a miss by using cfqueryparam. Wiser people
on this list has convinced me
UPDATE
TBL_Poll_Responses
SET
Response=<cfqueryparam value="#EVALUATE(TRIM(VCurResponse))#"
cfsqltype="cf_sql_char">
WHERE
response_id=<cfqueryparam value="#EVALUATE(VCurPK)#"
cfsqltype="cf_sql_integer>
it'll also sort your dates for you (Access ## VS SQLSvr '')
WHERE myDate=<cfqueryparam value="#form.datefield#"
cfsqltype="cf_sql_date">
And provides just a little bit more error handling because of the type
checking.
Cheers
barry.b
-----Original Message-----
From: Jason Bayly [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 24 March 2004 9:11 AM
To: CFAussie Mailing List
Subject: [cfaussie] Single quote issue
Hi Guys/Gals,
For some reason my inserts are failing due to single quotes. I though CF
automatically escaped them in SQL statements.
UPDATE TBL_Poll_Responses
SET Response = '#EVALUATE(TRIM(VCurResponse))#'
WHERE response_id = #EVALUATE(VCurPK)#
I need to set my vars dyanmically as im building a quiz app (with many
variables), so i need to use the evaluate the function.. Would this be
causing my DB errors? (Line 2: Incorrect syntax near '2'.) etc..
Any thoughts?
Jason
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
