|
devshb
Senior Member
United Kingdom
1904 Posts |
 Posted - March 12 2007 : 03:37:23
|
if you're on sqlserver or mysql, then first run this in the normal vpasp "Advanced Query" screen to check how many records there are and to see if it's what you're expecting:
select catalogid,ccode,cname,hide from products where upper(ccode) like '%NA%'
and if that's what you're expecting to update, then run this in the byz advanced sql execution:
update products set hide=1 where upper(ccode) like '%NA%'
or if you're on access it would be:
select catalogid,ccode,cname,hide from products where ucase(ccode) like '%NA%'
update products set hide=yes where ucase(ccode) like '%NA%'
if anyone's browsing this and wonders what we're talking about, have a look at:
Advanced SQL Execution:
http://www.bigyellowzone.com/shopexd.asp?id=114
(it's free!)
And if you like that, have a look at the Bulk Product Update Tool:
http://www.bigyellowzone.com/shopexd.asp?id=103
(not free, but very nice anway; lets you see your results before performing the actual update as a test run and lets you do updates using category criteria etc)
Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons |
Edited by - devshb on March 12 2007 04:20:07 |
 |
|
All Forums
Advanced SQL Execution
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
