This is a multi-part message in MIME format.
--------------038B626790AA5924CFF82AAF
Content-Type: multipart/alternative;
boundary="------------8CB5F653C5DC7DE914071AAA"
--------------8CB5F653C5DC7DE914071AAA
Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854";
x-mac-creator="4D4F5353"
Content-Transfer-Encoding: 7bit
Could you get a copy of the Stored Procedure too?
>From memory though, you don't need to specify the VARIABLE parameters as they are
>used when the TYPE is INOUT or OUT
And I suspect that you've left the bottom part of the script off, but make sure that
the </CFSTOREDPROC> is specified!!
Avi Flax wrote:
> Sending this question in for a friend. Thanks for any replies!
>
> Do you do much with stored procedures in Cold Fusion? It's one thing I do
> little with, and I'm stuck. I keep getting an error from the SP saying it
> isn't getting @CustomerID, which it expects. Here's the code I'm using:
>
> <CFSTOREDPROC PROCEDURE="InsertOrder" DATASOURCE="#DSN#">
> <CFPROCPARAM
> TYPE="In" CFSQLTYPE="CF_SQL_INTEGER" VARIABLE="CustomerID"
> DBVARNAME="CustomerID" VALUE="#CustomerID#" NULL="No">
> <CFPROCPARAM
> TYPE="IN" CFSQLTYPE="CF_SQL_REAL" VARIABLE="NetAmount" VALUE="#NetAmount#">
> <CFPROCPARAM
> TYPE="IN" CFSQLTYPE="CF_SQL_REAL" VARIABLE="Tax" VALUE="#Tax#">
> <CFPROCPARAM
> TYPE="IN" CFSQLTYPE="CF_SQL_REAL" VARIABLE="TotalAmount" VALUE="#TotalAmount#">
>
> I just tried adding the DBVARNAME parameter but that didn't help.
>
> Help? :)
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--------------8CB5F653C5DC7DE914071AAA
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Could you get a copy of the Stored Procedure too?
<p>From memory though, you don't need to specify the VARIABLE parameters
as they are used when the TYPE is INOUT or OUT
<p>And I suspect that you've left the bottom part of the script off, but
make sure that the </CFSTOREDPROC> is specified!!
<br>
<br>
<br>
<br>
<p>Avi Flax wrote:
<blockquote TYPE=CITE>Sending this question in for a friend. Thanks for
any replies!
<p>Do you do much with stored procedures in Cold Fusion? It's one
thing I do
<br>little with, and I'm stuck. I keep getting an error from the
SP saying it
<br>isn't getting @CustomerID, which it expects. Here's the code
I'm using:
<p><CFSTOREDPROC PROCEDURE="InsertOrder" DATASOURCE="#DSN#">
<br><CFPROCPARAM
<br>TYPE="In" CFSQLTYPE="CF_SQL_INTEGER" VARIABLE="CustomerID"
<br>DBVARNAME="CustomerID" VALUE="#CustomerID#" NULL="No">
<br><CFPROCPARAM
<br>TYPE="IN" CFSQLTYPE="CF_SQL_REAL" VARIABLE="NetAmount" VALUE="#NetAmount#">
<br><CFPROCPARAM
<br>TYPE="IN" CFSQLTYPE="CF_SQL_REAL" VARIABLE="Tax" VALUE="#Tax#">
<br><CFPROCPARAM
<br>TYPE="IN" CFSQLTYPE="CF_SQL_REAL" VARIABLE="TotalAmount" VALUE="#TotalAmount#">
<p>I just tried adding the DBVARNAME parameter but that didn't help.
<p>Help? :)
<p>------------------------------------------------------------------------------
<br>Archives: <a
href="http://www.mail-archive.com/cf-talk@houseoffusion.com/">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a>
<br>To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.</blockquote>
</html>
--------------8CB5F653C5DC7DE914071AAA--
--------------038B626790AA5924CFF82AAF
Content-Type: text/x-vcard; charset=us-ascii;
name="nickslay.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Nick Slay
Content-Disposition: attachment;
filename="nickslay.vcf"
begin:vcard
n:Slay;Nick
tel;cell:0414 810284
tel;home:02 4381 0284
tel;work:02 4381 0284
x-mozilla-html:FALSE
url:http://www.webbods.com.au
org:Webbods Pty Ltd
adr:;;PO Box 4054;Copacabana;NSW;2251;Australia
version:2.1
email;internet:[EMAIL PROTECTED]
title:Technical Director
x-mozilla-cpt:;3
fn:Nick Slay
end:vcard
--------------038B626790AA5924CFF82AAF--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
