Michel,
If you are going to use queries than there is no clean way to remove rows -
best bet would be to have another column with an "active" flag. To delete
you just set it to 0 and then ignore it in further processing. The only way
to actually remove a row is to copy the query except for that row (which
would not be efficient).
If you use arrays or structures (for example) then you could remove rows
easily.
--- Ben
-----Original Message-----
From: Michel Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 2:03 PM
To: CF-Talk
Subject: Removing items from the shopping basket?
Hi!
I've got a shopping basket going:
<cfset tempValue = queryAddRow(session.basket)>
<cfset tempValue = querySetCell(session.basket, "ID", form.ID)>
<cfset tempValue = querySetCell(session.basket, "Quantity", form.quantity)>
But I can't find the instructions on how to delete items
from the basket.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
