whoops, the sql is select distinct product.productid from product,productdetails where product.productid=productdetails.productid and product.recordstatus='O' and product.recordstatus='O' and productdetails.price<= 1234.673264 and productdetails.price>= 0 and (product.instore = 0 or product.instore = 0) limit 0, 10
I know there are some redundant sections in the sql but the statement is being generated on the fly, and i dont think that they would account for this effect. -----Original Message----- From: Sean O'Donnell Sent: 08 April 2002 06:36 To: [EMAIL PROTECTED] Subject: help with asp/mysql this is driving me mental, I'm using asp and mysql, I'm running a query and getting back these two records when running the query manually through mysqlfront , productid 5325301445 5325301446 when the page executes the query i get back a single result 1030334149 which doesnt actually exist in the database! anyone got any ideas? I know the query is being run , and its going to the right database , as I'm writing them to the page directly before the query is run and the results are written to the page. ___________________________ Sean O'Donnell Sentia Technologies Ltd. Sentia House 104 Coolmine Business Park Dublin 15 Ireland e-mail [EMAIL PROTECTED] web http://www.sentia.ie phone + 353 1 821 9020 fax + 353 1 821 9025 mobile + 353 86 854 3389 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
