[ic] deleting additional shipping addresses

Zachary Matthews zac@mediapc.com
Sun, 26 Nov 2000 22:36:07 -0800


Using GDBM!
----------
>From: "Cameron B. Prince" <cameron@akopia.com>
>To: <interchange-users@minivend.com>
>Subject: RE: [ic] deleting additional shipping addresses
>Date: Wed, Nov 22, 2000, 4:17 PM
>

> 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
>
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users
>