So it looks like the problem is the curly brackets? Odd Darren
> -----Original Message----- > From: Beattie, Barry [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 8 October 2003 1:55 PM > To: CFAussie Mailing List > Subject: [cfaussie] I think this is a CFMX bug. Please prove me wrong. > > > wierdness inserting into a text field in a db table > (MSAccess, CFMX 6.1). > > try it out, see what you think > cheers > barry.b > > > ========================================= > this works > ------------- > <cfset myTestString = "it ain't 'alf 'ot, mum"> > <cfquery name="qTestInsertText" datasource="scratch"> > insert into tTest1(valTest1) > values('#myTestString#') > </cfquery> > > so does this > ------------- > <cfset myTestString = "{ it ain't 'alf 'ot, mum}"> > > <cfquery name="qTestInsertText" datasource="scratch"> > insert into tTest1(valTest1) > values('#myTestString#') > </cfquery> > > ========================================= > BUT... > ========================================= > this doesn't > ------------- > <cfset myTestString = "{ts '10101010101'}"> > <cfquery name="qTestInsertText" datasource="scratch"> > insert into tTest1(valTest1) > values('#myTestString#') > </cfquery> > > [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Microsoft > Access Driver] Syntax error (missing operator) in query > expression ''{ts > '10101010101'}''. > > The error occurred in C:\CFusionMX\wwwroot\test\timestamp2.cfm: line 6 > > 4 : <cfquery name="qTestInsertText" datasource="scratch"> > 5 : insert into tTest1(valTest1) > 6 : values('#myTestString#') > 7 : </cfquery> > > > and neither does this > --------------------- > <cfset myTestString = "{ts it ain't 'alf 'ot, mum}"> > > <cfquery name="qTestInsertText" datasource="scratch"> > insert into tTest1(valTest1) > values('#myTestString#') > </cfquery> > > [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Microsoft > Access Driver] Syntax error (missing operator) in query > expression ''{ts it > ain't 'alf 'ot'. > > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
