What's going on with this function? (PreserveSingleQuotes)
I'm trying to set-up varaiables BEFORE inserting them into SQL table
like this:
<cfset form.foo1=PreserveSingleQuotes(form.foo1)>
<cfset form.foo2=PreserveSingleQuotes(form.foo2)>
this doesn't work, but weirdly, this works:
<cfset foo1=PreserveSingleQuotes(foo1)>
<cfset foo2=PreserveSingleQuotes(foo2)>
I also tried writing that directly into CFQUERY:
INSERT INTO groups
(<cfloop index="element" list="foo1,foo2">#element#,</cfloop>)
VALUES
(<cfloop index="element"
list="foo1,foo2">'#PreserverSingleQuotes(evaluate("form.foo#i#"))#'</cfloop>
didn't work!
Can it be that PreserveSingleQuotes just don't get something else then pure varaiable
without SCOPE?!
Thanks,
Michael Lugassy
IT/WEB Specialist
Interactive Music Ltd.
www.imvamp.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
