[ic] deleting additional shipping addresses

[Cameron B. Prince]

I believe that solves it then... I will look into a fix for that page within
the demo that will be compatible for all databases. The code for this
already exists in the admin pages. Almost all the main menu choices offer a
checkbox with Check to Delete or Edit in Sequence.

A work around for you should be to either "borrow" code from the admin pages
to replace the code in the default ship_address pages, or switch to a MySQL
database.

I'll take care of this in CVS soon.

Thanks,

Cameron

-----Original Message-----
From: interchange-users-admin@minivend.com
[mailto:interchange-users-admin@minivend.com]On Behalf Of Zachary
Matthews
Sent: Monday, November 27, 2000 12:36 AM
To: interchange-users@minivend.com
Subject: Re: [ic] deleting additional shipping addresses


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
>

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