I need to help out the ordering dept by populating the image field in items. I want to run a query that would use ILC and add .jpg to it and insert into the image field. I would need to be able to select by category or some filter so I can limit what is being changed. I have seen a post that used this command is this correct?
UPDATE dbo_item.image SET dbo_item.image = "C:\IMAGEPATH\" where categoryid = xxx
Also is there away to rename a current ILC in bulk? Like ILC "028" to "B028" by supplier or some other meaningful filter?
*This post is locked for comments
Hi, you need to set the path to the pictures in SO administrator. File --> Configuration --> Paths --> pictures field. No, the query in your post will not work. You could use the following, it should work.
UPDATE item SET picturename = itemlookupcode + '.jpg' where categoryid = xxx
If you know the category name and not the id, you could replace this query with the xxx in the previous query including the parenthesis. (select id from category where name = 'CategoryNameHere')
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,336 Most Valuable Professional
nmaenpaa 101,156