[thelist] coldfusion and stored procedures

[Joshua OIson]

Sarah, based on your code, nothing glares out to me as incorrect.  One
point, though, is you may need to check the dbvarname.  Depending on how the
sp is coded, you may need to preface each with an @, thus turning

<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER"
dbvarname="colo_site_network_id" value="#form.colo_site_network_id#"
null="No">

into

<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER"
dbvarname="@colo_site_network_id" value="#form.colo_site_network_id#"
null="No">

What sort of error is this giving, if any?

-joshua

----- Original Message -----
From: "sarah" <disaster7 at yahoo.com>
To: <thelist at lists.evolt.org>
Sent: Wednesday, May 30, 2001 11:13 AM
Subject: [thelist] coldfusion and stored procedures


: The code I'm using is at the end of this message.
: Anyhow, the problem is. I have a form being filled out
: and I need to insert the values with a stored
: procedure. I haven't done this before and I'm having