Problem when using stored procedure in classic asp project.

Question

3.67/5 (2 votes)

See more:

Hi Friends !

I am new on classic asp using vbscript. I have a project with classic asp and in that project all pages use sql queries.

I have a requirement that instead of query, use the stored procedure and make the changes according to this. All pages have lots of queries and part of queries also.

Suppose search any records according to name then in a variable use half part of query(and name=$session("name")) and append it to main query.

So how to start to working this with all input and output parameters.

Please give me the appropriate solution.

Do the needful.

Is it possible to change that existing page or make a new page with existing things?

The page exists 2000 line of code and 20-30 times queries are used on that page only?

Thanks

Posted 5-Feb-14 22:33pm

Gr8AmitTiwari

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2014-02-06T04:26:00

Check these
How to call SQL Server stored procedures from ASP[^]
Executing Store Procedure (SP) in ASP[^]

Gr8AmitTiwari wrote:
Is it possible to change that existing page or make a new page with existing things?

Don't disturb existing pages. Create an another copy of existing page, do changes in new file & execute things. By this way, you could go back through existing version if you face any problems in new way(stored procedure).