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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
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

Reply via email to