It's an odd issue with the JDBC driver, you will not get the error if you change you autonumber primary key to a bigint.
Cutter _______________ http://blog.cutterscrossing.com Emil Gudmundsson wrote: >> I'm having an odd MySQL issue and was wondering if anyone knew what it's up >> to. >> >> If I run (some code obviously omitted): >> >> <cfquery> >> SELECT >> someIntField >> WHERE >> someField = <cfqueryparam /> >> </cfquery> >> >> I get odd values (like 43234534 instead of 2) for someIntField. >> >> If I run the same qry w/o the <cfqueryparam /> tag, I get the proper >> value. Anyone have any ideas? >> >> CFMX7.0.1, mysql connector / j 3.10 >> >> -Joe > > I have the same issue. Would really appreciate if someone knew how to solve > this. > > :) > Emil > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260154 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4