> you can use PreserveSingleQuoutes(#var#)
Actually, the preserve single quotes function should only be used when you
are writing whole the SQL expression (rather than just data values). If you
do this, you must take special care to escape all single quotes in your
single quoted value strings.
>> ok, I want to enter this character into a SQL table. '
>>
>> but i get an error. how do I make it enter ' into the database?
Escaping characters in SQL is much like escaping characters in ColdFusion.
You double up the character you need to escape. In this case, you would want
to escape the quoted single quote.
>> INSERT INTO MyTABLE(Stuff)
>> VALUES = '''
The following should work:
INSERT INTO MyTABLE(Stuff)
VALUES = ''''
Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
