help.
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-----Original Message-----
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 7: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
<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]
