Hi everyone,
I am currently working on a shopping cart style application for our field users to order marketing and promotional items and have the following limitations:
1. The application must be web based and housed on our Intranet site (hence the need for ASP.
2. The saved order information must be stored in our new implemented DBMS (Interbase) in order to integrate with any existing or future applications.
The problem I'm having is that I would like to use stored procedures to update multiple records at once, but I can't get Interbase and ASP to play nicely together.
I've found plenty of examples of each independently, but none with any insight into using the two together.
I have managed to get simple, single command stored procedures to work via ASP forms, but anything that needs to say INSERT and then UPDATE or issue a RETURN value simply will not work.
If anyone can help it will be greatly appreciated as I am about to just try to create the ASP in Delphi 7.
I am currently working on a shopping cart style application for our field users to order marketing and promotional items and have the following limitations:
1. The application must be web based and housed on our Intranet site (hence the need for ASP.
2. The saved order information must be stored in our new implemented DBMS (Interbase) in order to integrate with any existing or future applications.
The problem I'm having is that I would like to use stored procedures to update multiple records at once, but I can't get Interbase and ASP to play nicely together.
I've found plenty of examples of each independently, but none with any insight into using the two together.
I have managed to get simple, single command stored procedures to work via ASP forms, but anything that needs to say INSERT and then UPDATE or issue a RETURN value simply will not work.
If anyone can help it will be greatly appreciated as I am about to just try to create the ASP in Delphi 7.
