The thread Tom's referring to can be found at http://www.mail-archive.com/[EMAIL PROTECTED]/msg157166.html
Based on that, Sam Neff was good enough to put together the following page, http://www.blinex.com/~sam/CF_SQL_TYPES.cfm , that displays cfsqltypes with their corresponding datatypes in various databases.
As far as your error message, below...the obvious question to ask (and sorry to do it, but you know it has to be asked) is...you have a few empty values. does your database accept null values/empty strings for those columns?
charlie
----- Original Message -----
From: Rick Root
To: CF-Talk
Sent: Friday, December 05, 2003 8:09 AM
Subject: Re: Debugging CFQUERYPARAM
Tom Kitta wrote:
> Search the arhives of this group, we had a discussion about that some time
> ago and got a list of all known to work type translations for populard DBs.
>
I did search the archives (I'm a good mailing list user)... all I found
was http://www.houseoffusion.com/cf_lists/cache.cfm/4/23/23083.htm and
that doesn't really cover my problem. I also searched google.. for a
variety of things. Searching for merant 6053 returns no meaningful
results except one - a message on this list of a user that is having the
same problem and got no responses
(http://www.houseoffusion.com/lists.cfm/link=m:4:28384:142789)
My query is not complex... the datatypes I'm using are all varchar,
char, and numeric. So I'm using CF_SQL_VARCHAR, CF_SQL_NUMERIC, and
CF_SQL_CHAR.
I've checked and double checked the order of my parameters based on the
debugging output, which I'll include.... and the error code means nothing.
ODBC Error Code = 94 ()
[MERANT][ODBC MySql driver]6053
SQL = "INSERT INTO MEMBERS ( UNAME, PWORD, EMAIL, EMAIL_CONFIRMED,
GENDER, FNAME, LNAME, MEMBER_SINCE, LAST_LOGIN, EMAIL_ANNOUNCE, ADDRESS,
ADDRESS_HIDE, CITY, STATE, ZIP, COUNTRY, LOCATION_HIDE, PHONE,
PHONE_HIDE, EMAIL_HIDE, REFERRAL ) VALUES ( ?, ?, ?, 0, ?, ?, ?, {d
'2003-12-05'}, {d '2003-12-05'}, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )"
Query Parameter Value(s) -
Parameter #1 = rickroot
Parameter #2 = password
Parameter #3 = [EMAIL PROTECTED]
Parameter #4 = 1
Parameter #5 = Rick
Parameter #6 = Root
Parameter #7 = 1
Parameter #8 =
Parameter #9 = 0
Parameter #10 =
Parameter #11 = NC
Parameter #12 =
Parameter #13 = US
Parameter #14 = 0
Parameter #15 =
Parameter #16 = 0
Parameter #17 = 0
Parameter #18 =
> -----Original Message-----
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 04, 2003 9:46 PM
> To: CF-Talk
> Subject: Debugging CFQUERYPARAM
>
> I hate CFQUERYPARAM. Why? Because debugging it seems to be a REAL pain
> in the butt.
>
> For example, I have a fairly length query with a lot of fields that are
> being inserted. I recently attempted to convert it to use CFQUERYPARAM
> (I currently am not using it, to my own risk).
>
> Suddenly, I'm getting this error:
>
> ------------------------------------------------
> ODBC Error Code = 94 ()
> [MERANT][ODBC MySql driver]6053
> ------------------------------------------------
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
