Ask a Question related to Coldfusion Database Access, Design and Development.
-
akcreative #1
passing values to stored procedure
Hello
Can some please let me know how can I pass value to the following stored
procedure from coldfusion template. It is written in different format than
those I worked before
In Cold Fusion it is like that
<cfquery name="plans" datasource="xyz">
exec get_plans
</cfquery>
In SQL Manager it looks like
Create Procedure prc_get_plans
@DEPT_ID CHAR(10)='ALL'
@FROM_DATE VARCHAR(10)
akcreative Guest
-
#40143 [NEW]: how to get parameter values of stored procedure.?
From: hd4_all at yahoo dot co dot in Operating system: windows 2000 prof. PHP version: 5.2.0 PHP Bug Type: MySQLi related... -
Passing null into a stored procedure
I have a survey form with both checkboxes and radio buttons... when storing the form, there are occassions that I need to store a NULL in the DB and... -
Stored Procedure not returning values.
There are two problems: 1. SQL Server returns the "x number of records affected" message that you see in Query Analyzer to the client as a... -
Passing arrays to a stored procedure
http://www.aspfaq.com/2248 http://www.algonet.se/~sommar/arrays-in-sql.html http://www.algonet.se/~sommar/dynamic_sql.html "Doug Eller"... -
Passing Unix Params to a Stored Procedure
need to pass Unix parameters to a stored procedure (called in proc.sql) I call proc.sql like so (I've ommited the sql logon info etc): ... -
mxstu #2 Re: passing values to stored procedure
Typically, you should [url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/00000338.htm[/url] for stored procedures.
mxstu Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
