Stored Procedures / Forms

[MattLloyd]

Hi

Have got a stored procedure which allows submission of data to multiple SQL tables. This appears to work.

Have set up a valid connection to the database and have designed a form to collect all of the required data. In addition have set up command stored procedure and used test button to check valid.

However I cannot get the data from the form into the stored procedure/sql tables when the user clicks on submit.

Any ideas?

Thanks

Matt

 

[lebisol]

try:

http://www.stardeveloper.com/articles/display.html?article=2001050101&page=1

or:

http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=stored+procedures+stardeveloper

> need more info?
:: don't click HERE ::

 

[martiros]

Since it is DW MX forum I'd recommend trying to create StoredProc inside a DWMX itself. It has a StoredProcs wizard inside SQL wizard (as I recall).
Most of the times it works & if it will for you - adjust it to your needs.

 

[lebisol]

Hi maritos!
IMHP:

"It has a StoredProcs wizard inside SQL wizard (as I recall)"
-- it will only work with MS SQL not MS Access and it is far from being a wizard (nice an dquick interface but not a click-through thing though)

http://www.princeton.edu/~rcurtis/ultradev/tutorial2.html

"I'd recommend trying to create StoredProc inside a DWMX itself"
--> I would recoemmend u create the procedure inside the DB itslef that way it gets executed faster & u free resources faster. also your Page.asp does not have to process almost anything but simply call the procedure and "feed it" with variables from forms..

choices choices....are yours ;-)
All the best!

> need more info?
:: don't click HERE ::