I think its the combination of {} and "ts".
It wants to put a timestamp there, even though it is used as a string.
cheers
barry.b
-----Original Message-----
From: Darren Tracey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 8 October 2003 2:52 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: I think this is a CFMX bug. Please prove me
wrong.
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/
---
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/
