Hi Ian, > Ok, solved this!
Congrats. I always feel really stupid when I spend half an hour with code I KNOW works only to miss one character on another line that's actually the cause of the problem. Oops. I just went through that this morning with this code: Function SQLFix(sValue) 1: Dim sBuild 2: sBuild = Replace(sValue, "\", "\\") 3: sBuild = Replace(sValue, "'", "\'") 4: sBuild = Replace(sBuild, Chr(160), " ") 5: SQLFix = sBuild End Function This function is being called about 30 times from another page and I juse couldn't figure out how after adding line 2 above it STILL raised an error on a SQL INSERT into a mysql db. It simply should not happen, right? Oops. Looky there, line three is still referring to sValue as the source, meaning it'll overwrite sBuild with the original data and any \ that were there are back to being \. <sigh /> Fixed it by changing 3 to use sBuild instead of sValue, so nobody try teling me how to fix it, okay? ;) I guess that's what I get for staying up until 7am on some code for my wife. What I've done is AWESOME though (now that it works without problems on dozens of random tests). Really really cool. :) > ps How's life in CA? I hope it is an improvement over > Chicago. Much. It's like heaven here. Still, I'd really like to move to Australia or New Zealand, but am struggling with the political issues over there. Hm. Looks like the US isn't the only country with no ethics in gov't. ;) Regards, Shawn K. Hall http://ReliableAnswers.com/ '// ======================================================== "In general the art of government consists in taking as much money as possible from one class of citizens to give to the other." -- Voltaire ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
