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:
And if you like that, have a look at the Bulk Product Update Tool:
(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)
Web Design, Online Marketing and VPASP addons
Edited by - devshb on March 12 2007 04:20:07