var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Find & Replace Query - Query built, just need a minor edit for quote replacement.
I'm trying to use a template that I learned from the help I found on dBforums.com but I realized that this doesn't work for quotes. I need to edit this so that I can replace " with -.
The / that's in the code should be the only thing that I'm editing but its giving errors such as "extra expression"
I'd like it to work for double quotes and single quotes ( example " and ' )
Here's my template
Here's my edit (with a " instead of / )
UPDATE [ONE BIG TABLE] SET [ONE BIG TABLE].url_key = Replace(url_key,"/","-")
WHERE ((([ONE BIG TABLE].url_key) Like "*/*"));
UPDATE [ONE BIG TABLE] SET [ONE BIG TABLE].url_key = Replace(url_key,""","-")
WHERE ((([ONE BIG TABLE].url_key) Like "*"*"));
Last edited by RBusiness; 02-24-12 at 11:34.
Reason: Added objective
Update: I ended up doing it manually through the in table find and replace but I'd still like to know if anyone wants to chime in!