Greetings,
I am looking for 2 SQL statements if you please:
The first would make items available on web by category, one category at a time.
The second would make items available on web by manufacturer, one manufacturer at a time.
Thanks in advance.
SQL Statement
Mar 02, 2007
1 Replies
Hi Lax, You can accomplished by following commands: Item on Web by Category: update item set WebItem=1 FROM cATEGORY where item.categoryIDÊtegory.ID and category.Code='TR' Greetings,
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required