Rick, Um... This is not going to help. You will probably need to post the error you are receiving and also the SP code. There's nothin inherently wrong with the code below at first glance.
-mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Rick Turner [mailto:[EMAIL PROTECTED] Sent: Saturday, June 21, 2008 2:27 PM To: CF-Talk Subject: Stored Procedures hi, i am trying to et my head around stored procedures (using MySQL) I can get a basic oe to work but having problems when trying to send parameters across <cfstoredproc procedure="spGetDetails" datasource=#myDatasource#> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" value="#id#" null="no"> <!--- One resultset is returned called "qGetDetails" ---> <cfprocresult name="qGetDetails"> </cfstoredproc> Any help would be most welcome ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
