hey Kodo

Discussion in 'Software' started by ICeMaN, Dec 9, 2004.

  1. ICeMaN

    ICeMaN Master Sergeant

    Dude, I'm trying to run this query but it keeps coming back saying there's a syntax error. Any chance you can look it over for me and see what's wrong? I've been staring at it for too long :rolleyes:
     

    Attached Files:

  2. Kodo

    Kodo SNATCHSQUATCH

    INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_x_successfully', '<i>{1}\'s</i> has been updates!', '9000');

    looks like the culprit.. you have an extra ' in there that is not escaped.

    You may want to run any text for the TEXT field (bad name by the way, you should give it a different name like MyText) through a replace function that replaces one apostrophe with two apostrophes.

    this asp?
     
  3. ICeMaN

    ICeMaN Master Sergeant

    nah, vBulletin hack ;) Thanks though, I was just trying something out.
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds