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/
