[ic] deleting additional shipping addresses

[Cameron B. Prince]

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.

Cameron

-----Original Message-----
From: interchange-users-admin@minivend.com
[mailto:interchange-users-admin@minivend.com]On Behalf Of Zachary
Matthews
Sent: Wednesday, November 22, 2000 3:46 PM
To: interchange-users@minivend.com
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
demo... <http://demo.akopia.com/cgi-bin/iccvsro/ship_addresses.html>.
You will need to login first, then try to delete multiple shipping
addresses at one time. It doesn't work.

Solutions?
Thanks


> It is most likely the ' right before the 11 that is causing the query to
> fail.
>
> -Ron
>
> -----Original Message-----
> From: Zachary Matthews <zac@mediapc.com>
> To: interchange-users@minivend.com <interchange-users@minivend.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?
>>
>>Thanks!
>>
>>_______________________________________________
>>Interchange-users mailing list
>>Interchange-users@www.minivend.com
>>http://www.minivend.com/mailman/listinfo/interchange-users
>
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users
>

_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users