my question is why it isn't seen as a string?
the {ts '...'} is comming from a FORM. It is text. It is going into a text
field. This error shouldn't happen, therefore it's a bug.
... or a "feature" in MS speak...
cheers
barry.b
-----Original Message-----
From: Ricardo Russon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 8 October 2003 11:55 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: I think this is a CFMX bug. Please prove me wr
ong.
I had problems with the {ts..} and Strings when inserting inserting. After
much playing I found that I could either use Replace() to get rid of them
before processing or to use a date-time field in the db.
But I have never had a CF error putting them into the db. Don't know if that
helps you any. But it might be something to think about.
Ricardo.
"Beattie, Barry" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
>
> Ah, but I'm forced into using DWMX server behavours (yuck - don't ask!)
> which doesn't use queryparams.
>
> It's a string! work-arounds shouldn't be necessary...
>
> cheers
> barry.b
>
> -----Original Message-----
> From: Adam Chapman [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 8 October 2003 3:42 PM
> To: CFAussie Mailing List
> Subject: [cfaussie] RE: I think this is a CFMX bug. Please prove me
> wrong.
>
>
> Gidday Barry,
>
> > <cfset myTestString = "{ts it ain't 'alf 'ot, mum}">
>
> Have you tried using a cfqueryParam tag?
>
> insert into tTest1(valTest1)
> values(<cfqueryparam value="#myTestString#" cfsqltype="CF_SQL_VARCHAR">)
>
> (or perhaps there is a more suitable datatype?)
>
> Cheers,
> Adam
>
> PS: What ain't 'alf 'ot?
>
>
> -----Original Message-----
> From: Beattie, Barry [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 08, 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
>
>
> ---
> 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/
