strange errors can be explained by using the wrong types. Even if you think
you are using a correct type, you may not be. One of group users created a
whole table with all type listing.
I see you are having some dates in there as well as numbers so things might
be tricky (for dates use CF_SQL_TIMESTAMP not date or time alternatives).
Also, what DB are you using? I didn't have to many problems myself with SQL
server 2000 except for the type translation (in fact this question prompted
me to join this mailing list). Also the version of CF you are using might be
a factor, I know it works fine under MX, didn't try it under 5.0. I know
that some DB engines don't support parameter binding.
If all else fails just shrink the query and see at what point it starts to
work, this way you find the problem. I know this is time consuming, but use
it as a last resort.
Hope this helps,
TK
-----Original Message-----
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 10:10 AM
To: CF-Talk
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]
