Deleting records

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Amit Kela
    #1

    Deleting records

    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??
    Tags: None
    • Ray at
      #2
      Re: Deleting records

      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" <amit.kela@colo rado.edu> wrote in message
      news:8e5e432b.0 401281357.46d98 544@posting.goo gle.com...[color=blue]
      > 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??[/color]


        Comment

        • Jeff Cochran
          #3
          Re: Deleting records

          On 28 Jan 2004 13:57:41 -0800, amit.kela@color ado.edu (Amit Kela)
          wrote:
          [color=blue]
          >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??[/color]

          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

            Comment

            • Aaron Bertrand - MVP
              #4
              Re: Deleting records

              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" <amit.kela@colo rado.edu> wrote in message
              news:8e5e432b.0 401281357.46d98 544@posting.goo gle.com...[color=blue]
              > 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??[/color]


                Comment

                • Amit Kela
                  #5
                  Re: Deleting records

                  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!

                    Comment

                    • Ray at
                      #6
                      Re: Deleting records

                      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" <kela@colorado. edu> wrote in message
                      news:%23$EoZtc6 DHA.2644@TK2MSF TNGP11.phx.gbl. ..[color=blue]
                      > 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![/color]


                        Comment

                        • Amit Kela
                          #7
                          Re: Deleting records

                          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!

                            Comment

                            Previous template Next
                            Working...