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??
6  1478 
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*******@colo rado.edu> wrote in message
news:8e******** *************** ***@posting.goo gle.com... 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??
On 28 Jan 2004 13:57:41 -0800, am*******@color ado.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
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*******@colo rado.edu> wrote in message
news:8e******** *************** ***@posting.goo gle.com... 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,
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!
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******** ********@TK2MSF TNGP11.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!
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! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Mark |
last post by:
This question refers to a main form with a continuous form subform.
After an error occurs after entering several records in the subform, how can I
delete all the data in the main form and all the records in the subform? I have
tried undoing both the main form and the subform and I have tried deleting the
record in the main form.
Thanks!
Mark
|
by: Nathan Bloom |
last post by:
Hi,
I have a data entry form (access 2000) that also allows the user to add,
update, and delete records from the form. The Delete action is carried out
in an event procedure and has the following code:
Private Sub Command28_Click()
On Error GoTo Err_Command28_Click
|
by: uv |
last post by:
Hi!
I'm having problems submitting a new record through the form.
I'm working with the wizard and I've added a control button to my form
for entering entering a new record but for some reason it only works
for the first record I enter.
The same goes for deleting a record.
It says I can't access the records, and that goes for both making or
deleting.
I'd appreciate your help very much,
uv
|
by: Mike Turco |
last post by:
I'm working on an application that imports and exports tons of CSV data,
like 64,000 records per file, and six or seven files in a set.
First off, by the tine I import a few hundred thousand records the database
is _huge_. Like 500 meg, although the csv files are only 25 meg in total.
When I compact the database its still 100meg. How do I keep the size down?
Second, I did a manual delete of 300,000 records yesterday by doing a...
|
by: Coy Howe |
last post by:
This one seems bizarre!
We have a database consisting of a main table and 12 - 15 "sub" tables,
which are connected via cascading relationships. The database performs
many complex calculations and displays the results in both forms and
reports. In the process of developing the database we "entered" 12
sample clients. Before packaging the database we remove the sample
clients by deleting them from the main table, which cascades the...
| | |
by: KC |
last post by:
Hello,
I am using Access 2002. WinXP, Template from MS called Orders Mgmt DB.
I have tweaked this DB to work for our small co. It has worked pretty
well up until I made the mistake of deleting about 80 records from the
Orders table. 80 out of a 1000 records.
Now our data entry form shows our customer addresses, but not customer
order history. When looking at all of the tables, customer, payments,
orders, they still have all of the...
|
by: Mojtaba Faridzad |
last post by:
Hi,
with SetDataBinding( ) a DataGrid shows a DataView. user can select some
rows in the grid by holding cotrol key. when user clicks on Delete button, I
should delete all selected rows. I am trying to delete these lines from the
dataview like this:
for (int i=0; i < dataView.Count; i++)
if (dataGrid.IsSelected(i))
dataView.Delete(i);
|
by: azmiza |
last post by:
Hi everybody,
I need your help.
I want to view my sql database and its work very well which is display in my web browser
but once I want to press button yes, its not working, I check the database the specified row was nit deleted
Here I put my script for both.
<?php #script view_users.php pg 279
|
by: shriil |
last post by:
Hi
I have this database that calculates and stores the incentive amount
earned by employees of a particular department. Each record is
entered
by entering the Date, Shift (morn, eve, or night) and the 'employee
name'. There is another table which assigns an ID to the Shifts, i.e.
1,2 and 3 for morn, eve & night shifts respectively. From the mother
table, the incentive is calculated datewise for each employee as per
his shift duty. In...
|
by: padmaneha |
last post by:
Hi
I have created two tables 'TrainsMaster' & 'TransArrvlDepinfo'
Columns which I have created in 'TrainsMaster' are 'trainName,TrainNo, StartStaionId, & EndstationId'
Columns which I have created in ''TransArrvlDepinfo' are 'Stationcode, TrainNo, Arrvaltime,Depttime'
I have to delete few trains from 'TrainsMaster' for which the Startstationid or Endstationid are nulls which comes to 50 records
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
