Use single quotes..
<cfset spcheck = "You last updated them on #dateformat(thedate, 'dd mm
yyyy')#>
Or concatonate the variable
<cfset spcheck = "You last updated them on " & dateformat(thedate, "dd
mm yyyy")>
HTH
Mike
-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 12, 2001 13:15
To: CF-Talk
Subject: Using "" in <Cfset>
Hi.
If I need to set a variable that includes, for example, the dateformat
function as follows - how can I alter it for use in a query? (i.e. the
var spcheck will be entered into the DB)
<cfset spcheck = "You last updated them on #dateformat(thedate, "dd mm
yyyy")#>
Using that obviously just causes a SQL error - any ideas?
Cheers, again
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
