It doesn't sound like a CF bug at all. If anything its going to be the behaviour of the ODBC/JDBC driver that is causing the problem.
It would appear that the {ts prefix is reserved for ODBC style date/time values. It seems reasonable that the driver should be able to make the assumption that data falling into a certain format be treated in a specific way -- ie. not as a string but as a date/time object.
-- geoff http://blog.daemon.com.au/
Beattie, Barry wrote:
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/
