RE: [PHP] Maximum in SQL query?

From: Date: Mon, 12 Aug 2002 14:33:55 +0000
Subject: RE: [PHP] Maximum in SQL query?
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-112138@lists.php.net to get a copy of this message
[snip] It seems that MySQL only accepts queries that are 470 characters or smaller when I use PHP. Is this a known thing? Can I change it somehow? I printed the query: Query: REPLACE INTO foto (ID, titel, fotograaf, origineel_formaat_x, origineel_formaat_y, datum_invoering, datum_wijziging, plaats_opname, datum_opname, file_thumb, file_large, url_thumb, url_large, thumb_hoogte, thumb_breedte, large_hoogte, large_breedte, fine_art_print, digitaal_formaat) VALUES (00000001, "Eva", "Jasper", 1024, 768, now(), now(), "Brunssum", , "/ var/www/html/foto/0/0/0/0/0001.thumb.jpg", "/var/www/html/foto/0/0/0/0/0001.jpg", "/foto/0/0/0/0/0001.thumb.jpg", "/ foto/0/0/0/0/0001.jpg", 200, 150, 500, 375, "FALSE", "Array") Database error: You have an error in your SQL syntax near ' "/var/www/html/foto/0/0/0/0/0001.thumb.jpg", "/var/www/html/ foto/0/0/0/0/0001.j' at line 1 [/snip] I believe the error is a space prior to 'var' "Brunssum", , "/ var/ try "Brunssum", , "/var/ I consistantly use queries in PHP that are far longer than 470 characters (not to mention that 470 would be an odd choice for a limit of this type.). HTH! Jay

« previous php.general (#112138) next »