First, create an SP like this one that only takes one input value; hardcode
all the other vars within the SP. This will make debugging easier.
Second, I would wonder about the DBVARNAME; maybe it should be
DBVARNAME="lr1" instead of "@lr1" ?
Third, perhaps SQL Server doesn't believe that what you are passing meets
the criteria for a CF_SQL_DATE? If you can verify this, you might pass it
as CF_SQL_VARCHAR and convert() to a date within the SP?
good luck!
-----Original Message-----
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 21, 2000 5:56 PM
To: CF-Talk
Subject: Unknown data access error
Hi,
I am trying to use <cfstoredproc> and I'm passing some variables to a stored
procedure via <cfprocparam>. When I run this CF page which is a simple
update statement in SQL I get an 'Unkown data access error'. My code looks
fine to me, can you see anything?
My CF code:
<CFSTOREDPROC datasource="#application.datasource#" dbname="UserPreferences"
procedure="UpdateLayout">
<CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@lr1"
value="#lr1#"
type="In">
<CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@lr2"
value="#lr2#"
type="In">
<CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@lr3"
value="#lr3#"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
