I have recently moved from MSSQL to mySQL and am sorting out all the errors. I have an asp update script that is working in that it does the update but the page does not load, it just hangs until I stop it loading and I check the db and it has updated. The only code on the page is the update sql - see below. (please excuse the rude words)
If I response.write my sql to the page and copy that to myAdmin and run it there it handles it fine.
UPDATE distinctImages SET bodyPainting=\'\',pregnant=\'\',publicNudity=\'\',shower=\'\',stockings=\'YES\',shaving=\'\',smoking=\'\',bondageRestraint=\'\',tattooPierced=\'\',toy=\'\',telephone=\'\',messy=\'\',anal=\'\',doublePenetration=\'\',pissing=\'\',toys=\'\',fingers=\'\',teen=\'\',pink=\'YES\',shaven=\'\',hairy=\'YES\',leatherPVC=\'\',SingleSetCatRef=\'\',spiel=\'hello\',photographer=\'2\',licencedOwner=\'1\',location=\'1\',strength=\'2\',sublocation=\'16\' WHERE model_id=487 AND folder=\'SI19\'