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
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
