Viewing 5 posts - 1 through 5 (of 5 total)
Missed the Sku column, will try again:
UPDATE @Products SET NEWpictureURL ='~/ProductImages/' + SUBSTRING(OldPictureURL, PATINDEX('%[0-9]%',OldPictureURL),100) SELECT * FROM @Products
UPDATE @Products SET NEWpictureURL ='~/ProductImages/' + SUBSTRING(OldPictureURL, PATINDEX('%[0-9]%',OldPictureURL),100)
SELECT * FROM @Products
Not quite sure I got that, I will provide more info:
MS...
December 10, 2007 at 6:52 am
#758566
Modification:
Now, how would I UPDATE using that query now, but on the LEFT side?
e.g.
~/Assets/ProductImages/10392351.jpg
Want to UPDATE the PRODUCTS table column, UrlImage, from the Sku column in the same table to...
December 9, 2007 at 8:29 pm
#758441
Maybe I am wrong here, but I would not upload 10,000 images to a db, but would upload to the server and put a path to the files to keep...
December 9, 2007 at 8:22 pm
#758438
PERFECT!!!
I did one row using the
WHERE Product_Id =
statement. I then made the modifications and checked my results until the desired path was created....gulped, and did it to all...
December 9, 2007 at 7:30 pm
#758434
What does the -47 do? I am trying to figure out if I wanted to modify what to remove?
December 9, 2007 at 5:45 pm
#758421