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

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).

Problem when using stored procedure in classic asp project.

1 solution

Solution 1

Add your solution here

Preview 0

Problem when using stored procedure in classic asp project.

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us