stored procedure questions (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

crosscreek -> stored procedure questions (3/21/2008 21:04:20)

I am trying to make my pages a little faster with stored procedures.

I've been reading about them & have the idea on how to make them & execute them I do have a couple of questions that I haven't been able to find the answer to.

Where to you write the Create stored procedure codess?
.....Do you create a seperate page & "include" the page where you need it (with include file) OR do you create the SP in the connection page? I am using an <!-- #include file="connections.asp" --> (or does it really matter as long as you include the file)

Can you write multiple stored procedures on one page? Is there a way to keep them seperate?

Thanks for everyones help...





ou812 -> RE: stored procedure questions (3/21/2008 21:33:16)

Normally, stored procedures are written with whatever but are stored along with the database, to be ran by the database, and you call them when needed. But maybe I'm not understanding? What DB are you using?



crosscreek -> RE: stored procedure questions (3/21/2008 21:42:32)

I'm using mysql & mysql is through my hosting company

I may not be the one understanding.



ou812 -> RE: stored procedure questions (3/21/2008 21:56:54)

I haven't worked with the MySQL engine for quite a while, but I think you should just be able to write your stored procedure while in SQL mode on while on your host (unless it has some handy stored procedure button). Of course, you can write them ahead of time with notepad, or whatever, and then just copy/paste them into the SQL window on the host. Then as you need the SP, you call it as needed in your ASP code. And you can write as many as needed while on your host in SQL mode, and then call whatever whenever in your ASP code.

If you've got down how to write them and call them, you should be good to go. Not sure if that helps.



crosscreek -> RE: stored procedure questions (3/21/2008 22:09:21)

It does, or it gives me a start. I don't see a "stored procedure" button (now wouldn't that make it easier[;)])

But will try the SQL method as suggested.

This points me in the right direction.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.09375