I've seen errors like this when sending a NUMERIC CF datatype to a BIGINT datatype field. I used to always use NUMERIC for any numeric data (seems like it should work, right?) but I've had the occasional problem with it (mainly in Oracle). If the field datatype is BIGINT, try switching the CFSQLTYPE to "CF_SQL_BIGINT" instead of "CF_SQL_NUMERIC".
Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -----Original Message----- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 2:04 AM To: CF-Talk Subject: RE: Access SQL stored procs In MSSQL it works fine. But when used with coldfusion somehow keep prompting me the error. I check the datatype, it matches. So i am still veri puzzled why is this so. -----Original Message----- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 11:17 AM To: CF-Talk Subject: RE: Access SQL stored procs Does it work if you run it directly in Access? -----Original Message----- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 8:00 PM To: CF-Talk Subject: RE: Access SQL stored procs hi My stored procedure works fine in Oracle but in MSSQL its not working fine. I wonder why . I get this error "Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification" Anybody knows why? My stored procedure is <CFSTOREDPROC procedure="CHRIS.SP_DECS" datasource="#Request.HR_DSN#"> <cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" value="ABCDE" > <cfprocparam type="IN" value="13354" cfsqltype="CF_SQL_NUMERIC"> <cfprocparam type="Out" variable="curr_slry" cfsqltype="CF_SQL_NUMERIC"> </CFSTOREDPROC> -----Original Message----- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 25, 2002 4:39 AM To: CF-Talk Subject: RE: Access SQL stored procs It's a normal STOREDPROC implementation: Here's a snippet: <cfstoredproc datasource="#request.edatasource#" dbtype="ODBC" procedure="ecards_dupes_2months"> <cfprocresult name="ecarddupes"> </cfstoredproc> Ian -----Original Message----- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:31 AM To: CF-Talk Subject: RE: Access SQL stored procs Ok thanks Do you know of any place I can find docs on the syntax? Shawn Regan -----Original Message----- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:12 AM To: CF-Talk Subject: RE: Access SQL stored procs Yes, we have. It works quite well: You write your query in Access, then use CFSTOREDPROC to access it. Cut the processing time on a few of our pages from over 4 seconds to just under 400 ms. You can also access a query as a table, of course, but then PROCPARAM is right out... Ian -----Original Message----- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:04 AM To: CF-Talk Subject: OT: Access SQL stored procs Hey CF people, Happy Friday!! Well I have a question about access. I thought I saw something or read something about use the access query objects as stored procs. Has anyone done this and if so can you share? TIA Shawn Regan ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
