[cfaussie] RE: NEW batch style update request

[Justin Mclean]

Hi there,
Hi ifixed up the extra ,hiddenprod=<entry but still no luck.
i have some sort of data mismatch that i just can find.
Looks like you still have the same problem. If you look at the SQL you'll 
see that hiddenprod is repeated twice and in one case doesn't have a value.

SQL = "UPDATE products set unitprice = 2 , Featured=0 ,special=1 
,hiddenprod=,hiddenprod=1 WHERE productid = 1"
It should be:
UPDATE products set unitprice = 2 , Featured=0 ,special=1, hiddenprod=1 
WHERE productid = 1
Justin
=============================================
Justin Mclean                                             Class Software
Phone: (02) 93321230                                 9 Chapman St
Fax: (02) 93321032                                     Surry Hills
Mobile: 0416 119 342                                  NSW 2010
=============================================

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/