Is there a reason you wouldn't use an array here?
i.e.
formstring = ArrayNew(1);
formstring[1] = "intel's processor";
<cfoutput>#formstring[1]#</cfoutput>
-----Original Message-----
From: stephen holland chang [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 06, 2000 1:29 PM
To: [EMAIL PROTECTED]
Cc: dennis dowling; Josh Petrin; Donn Gore
Subject: PROBLEM with SingleQuote in SQL evaluate Insert
Hi Cfers!
This just seems like a lame problem i keep getting errors when trying to
insert a string with a singlequote in it (ie. Intel's Processor)
example
stringTypeID = 1
formstring1 = "intel's processor"
-----
INSERT INTO test_tbl
string = '#evaluate("formstring#stringTypeID#")#'
Isnt there a simple way to make sure that the string gets entered in
accurately (ie not removing or doubling the apostrophe) without it erroring?
stephen
:::::::: stephen.holland.chang
:::::::: chief.technology.officer
:::::::: cardinal.communications
:::::::: http://www.cardinalweb.com/
:::::::: [EMAIL PROTECTED]
:::::::: [EMAIL PROTECTED]
:::::::: vox: (510)647-1400 x.202
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.