Another thing to check for will be the commas...
I assume that you are doing a loop and if all you are updating is the
displaynames then check to ensure that your commas match...
i.e.
UPDATE Foo
SET fooid = fooid
<CFLOOP FROM="1" TO="5" INDEX="idxFoo">
, DisplayName#idxFoo# = <CFQUERYPARAM VALUE="#FORM['displayName'
& idxFoo]#" CFSQLTYPE="CF_SQL_VARCHAR">
</CFLOOP>
WHERE fooid = #FORM.ID#
Or something like that...
Your error didn't seem to be included...
Hth
-----Original Message-----
From: Adams, Stephen [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 12:15
To: CF-Talk
Subject: RE: Error with a simple expression.
**********************************************************************
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**********************************************************************
I am trying to use it in a UPDATE query, the error I was getting was
this:
-----Original Message-----
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: 27 September 2002 12:09
To: CF-Talk
Subject: RE: Error with a simple expression.
What error are you getting?
Try something like...
<CFQUERYPARAM VALUE="#FORM['displayName' & UpdateLoopIdx]#"
CFSQLTYPE="CF_SQL_VARCHAR">
And see if you get the same error...
HTH
-----Original Message-----
From: Adams, Stephen [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 11:55
To: CF-Talk
Subject: Error with a simple expression.
**********************************************************************
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**********************************************************************
Can anyone tell me why this simple expression
'#PreserveSingleQuotes(Evaluate("FORM.displayName" & UpdateLoopIdx))#',
it keeps failing, but I can't see why.
Stephen
**********************************************************************
Westminster City Council switchboard:
+44 20 7641 6000
**********************************************************************
This E-Mail may contain information which is
privileged, confidential and protected from
disclosure. If you are not the intended recipient
of this E-mail or any part of it, please telephone
Westminster City Council immediately on receipt.
You should not disclose the contents to any other
person or take copies.
**********************************************************************
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
