[ic] deleting additional shipping addresses
Cameron B. Prince
Wed, 22 Nov 2000 18:17:12 -0600
Could you tell us if you are using GDBM or Mysql for your databases?
This may be another issue with a query being to complex for the SQL
Statement module when used with GDBM.
[mailto:firstname.lastname@example.org]On Behalf Of Zachary
Sent: Wednesday, November 22, 2000 3:46 PM
Subject: Re: [ic] deleting additional shipping addresses
Oops.. that was my typo... the actual query reads:
delete from ship_addresses WHERE code = 10 or code = 11 or code = 12
Anyone know why this doesn't work? Try it for yourself in the construct
You will need to login first, then try to delete multiple shipping
addresses at one time. It doesn't work.
> It is most likely the ' right before the 11 that is causing the query to
> -----Original Message-----
> From: Zachary Matthews <email@example.com>
> To: firstname.lastname@example.org <email@example.com>
> Date: Wednesday, November 22, 2000 1:26 PM
> Subject: [ic] deleting additional shipping addresses
>>In the construct demo, there is a feature to add and remove additional
>>shipping addresses. However when you click more than one checkbox to
>>remove more than one address at a time, it fails to remove any
>>addresses. I looked at the page, 'ship_addresses_removed.html' and it
>>generates a sql query such as the following:
>>delete from ship_addresses WHERE code = 10 or code ='11 or code = 12
>>Do any of you SQL buffs out there know why this doesn't work?
>>Interchange-users mailing list
> Interchange-users mailing list
Interchange-users mailing list