[ic] deleting additional shipping addresses

Zachary Matthews zac@mediapc.com
Wed, 22 Nov 2000 13:46:18 -0800


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
>