Deleting records

[Amit Kela]

I am using ASP with SQL for my database.
The problem I have is that even after I have ordered certain items
from the shopping cart table on the webpage, I cannot remove them -
that is the entire list shows up the next time the table is opened.

is there any way I can delete the items once ordered so as to not let
them show in my table??

[Ray at]

Are you trying to execute a delete on the records and it's failing? When
are you doing the delete, upon completion of the transaction? Deleting
records isn't an issue as long as you execute a delete query.

Ray at home

"Amit Kela" <am*******@colorado.edu> wrote in message
news:8e**************************@posting.google.c om...

I am using ASP with SQL for my database.
The problem I have is that even after I have ordered certain items
from the shopping cart table on the webpage, I cannot remove them -
that is the entire list shows up the next time the table is opened.

is there any way I can delete the items once ordered so as to not let
them show in my table??

[Jeff Cochran]

On 28 Jan 2004 13:57:41 -0800, am*******@colorado.edu (Amit Kela)
wrote:

I am using ASP with SQL for my database.
The problem I have is that even after I have ordered certain items
from the shopping cart table on the webpage, I cannot remove them -
that is the entire list shows up the next time the table is opened.

is there any way I can delete the items once ordered so as to not let
them show in my table??

Terminology is important here, are you talking about deleting the
records from a database table or not showing those items in the HTML
table on your page?

Jeff

[Aaron Bertrand - MVP]

If the order has been placed, the cart data in the database should be
cleared out (or marked as ordered) and even the session("cartid") cleared
out - or whatever ties that specific session to that specific set of data in
the database.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Amit Kela" <am*******@colorado.edu> wrote in message
news:8e**************************@posting.google.c om...

I am using ASP with SQL for my database.
The problem I have is that even after I have ordered certain items
from the shopping cart table on the webpage, I cannot remove them -
that is the entire list shows up the next time the table is opened.

is there any way I can delete the items once ordered so as to not let
them show in my table??

[Amit Kela]

Jeff,
You're right, I wasnt too clear in my previous email.
But the problem I have is that the records are deleted from the SQL
database table but still show up on the ASP webpage even after being
ordered.
I cannot figure out where this data is stored if its not in the table

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Ray at]

Perhaps in the client's cached version of your page. Try preventing caching
for your pages.
http://www.aspfaq.com/show.asp?id=2022

Ray at work

"Amit Kela" <ke**@colorado.edu> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Jeff,
You're right, I wasnt too clear in my previous email.
But the problem I have is that the records are deleted from the SQL
database table but still show up on the ASP webpage even after being
ordered.
I cannot figure out where this data is stored if its not in the table

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Amit Kela]

Hey Ray,
Thanks for your reply on adding the code to delete the cache.
The problem seems to be partially solved. Now the cart shows empty
after I've placed an order. However, once I add any new item to the
cart, the new item shows up alongwith the list of items already ordered.
Amit

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!