jakepeg

I seem to have sorted it. I added <p>update complete</p> at the end of the page and it worked. Weird. Now I have another problem. I added a date field on the update page that is populated from the db, and it pulls it into the field fine but wont put it back into the db. If I change the date format it works. It pulls it from the db and puts it into the text field as 2/1/2003 3:39:00 PM format. But wont it go back in unless I change it to 2003-02-01 15:39:00 format manually by hand before the update is executed.

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\'

............this does return results........ SELECT images.model_id, images.group_id, images.folder, models.display_name, images.SingleSetCatRef, prices.Price, prices.image_size FROM ( ( models INNER JOIN images ON models.id = images.model_id ) INNER JOIN prices ON images.SingleSetCatRef = prices.CatRef ) WHERE images.SingleSetCatRef > \'\' LIMIT 200; .............for some reason this does not return any results............ CREATE TEMPORARY TABLE TempTable AS SELECT images.model_id, images.group_id, images.folder, models.display_name, images.SingleSetCatRef, prices.Price, prices.image_size FROM ( ( models INNER JOIN images ON models.id = images.model_id ) INNER JOIN prices ON images.SingleSetCatRef = prices.CatRef ) WHERE images.SingleSetCatRef > \'\' LIMIT 200; SELECT * FROM TempTable; DROP TABLE TempTable;[/b]

I just tried it without the distinct to see if that was still the reason for no results, but it still gave none although it said \"Your SQL-query has been executed successfully\" I am using the SQL screen on MyAdmin SELECT images.model_id AS model_id, images.group_id AS group_id, images.folder AS folder, images.spiel AS spiel, models.display_name AS display_name, images.SingleSetCatRef AS catRef, prices.Price AS price, prices.image_size AS image_size, images.dateAdded FROM ( models INNER JOIN images ON models.id = images.model_id ) INNER JOIN prices ON images.SingleSetCatRef = prices.CatRef WHERE images.SingleSetCatRef > \'\' AND images.dateAdded < \'2002-10-29 16:10:00\' LIMIT 1, 1 produces.... model_id group_id folder spiel display_name catRef price image_size dateAdded 79 0 CD7B KL CC. Bla Bla... Queen Sign 0079MCD7B 24.95 2000 x 1320 2002-09-29 16:19:00

thanks, that was run but did not return any records. let me try sum\'t else...

na MySQL said: You have an error in your SQL syntax near \' images.group_id, images.folder, models.display_name, images.SingleSetCatRef, pr\' at line 1

CREATE TEMPORARY TABLE TempTable as SELECT (images.model_id, images.group_id, images.folder, models.display_name, images.SingleSetCatRef, prices.Price, prices.image_size FROM (models INNER JOIN images ON models.id = images.model_id) INNER JOIN prices ON images.SingleSetCatRef = prices.CatRef WHERE images.SingleSetCatRef > \'\' LIMIT 200) SELECT DISTINCT * FROM TempTable DROP TABLE TempTable

If it is not in the support doc\'s / faq then I would email support as it could be anything, and you have tried the obvious with no joy.

Okily dokily, I am migrating from MS SQL to MySQL, have had no problems till now (am sure this is probly the first of many so you\'ll likely be hearing from me again). I have the following SQL Select that is not returning any rows, yet it does using SQL Server with the same data. SELECT DISTINCT images.model_id AS model_id, images.group_id AS group_id, images.folder AS folder, images.spiel AS spiel, models.display_name AS display_name, images.SingleSetCatRef AS catRef, prices.Price AS price, prices.image_size AS image_size, images.dateAdded FROM ( models INNER JOIN images ON models.id = images.model_id ) INNER JOIN prices ON images.SingleSetCatRef = prices.CatRef WHERE images.SingleSetCatRef > \'\' AND images.dateAdded < \'2002-10-29 16:10:00\' If I remove the DISTINCT it runs fine returning the rows it should - I need it to return DISTINCT results though. Any ideas??? Jake