In general, you only use PreserveSingleQuotes when you want CF to not
automagically escape single quotes.
Normally, if you do this:
INSERT INTO Foo(var)
VALUES('#Form.blah#')
and Form.blah = Ray's World, CF would automatically change it to Ray''s
World (see note at bottom for exception).
I don't remember having problem with scope before, but I have had a problem
with using a function inside preserveSingleQuotes(), I overcame it by
setting a tmp variable, then using that in preserveSingleQuotes. Annoying.
It was a time ago... it could be my own stupid fault.
Anyway, your SQL
2 matches
Mail list logo