Hello, The following sql query works very well in version 4.0.1-alpha-nt. However it returns a null set with the data provided in aBetterLimo.sql in all later versions (the last one tried was 4.0.5-beta. I hope that this is enough information. If you would like anymore please feel free to contact me.
I have tested it under the following systems... Windows 2000 Server Windows XP Professional Windows .NET 2003 Beta I am accessing the information using MyODBC 2.50.39 ODBC.NET .NET Framework an example can be found at http://vpn.in.keslininc.com/aBetterLimoService/srs.asmx choose getBilling use the dates start 11/11/2001 end 11/11/2005 billed true The only thing I have to do to make it work is revert back to Mysql 4.0.1-alpha-nt My attempt to attach a mysqldump file failed for this list. Therefore if anyone is going to test this bug and would like a copy of the data from mysqldump that generates the data for this query please feel free to e-mail me. --Chris Keslin SELECT reservation.rsrvID as ReservationID, reservationType.display as ReservationType, customer.userName as CustomerID, paymentType.display as PaymentType, address.phone as Phone, address.street as Street, address.city as City, address.state as State, address.zip as Zip, payment.pymtID as PaymentID, payment.discount as Discount, payment.rate as Rate, payment.gratuity as Gratuity, (1 - payment.discount) * (payment.rate + payment.gratuity) as Total, payment.billingDate as BillingDate, payment.billed as Billed, payment.nameOnCard as NameOnCard, payment.acctNumber as AccountNumber, payment.cardExpiration as CardExpiration, payment.miscNumber1 as Misc1, payment.miscNumber2 as Misc2, payment.miscNumber3 as Misc3, payment.miscNumber4 as Misc4, payment.lastModTime as LastModTime, payment.lastModBy as LastModBy FROM reservation, customer, payment, paymentType, address, reservationType WHERE reservation.pymtID = payment.pymtID AND reservation.custID = customer.custID AND reservation.rtypID = reservationType.rtypID AND payment.addrID = address.addrID AND payment.ptypID = paymentType.ptypID AND payment.billingDate >= 20011101 AND payment.billingDate <= 20051101 ORDER BY payment.billingDate DESC =================================================== Christopher M. Keslin, Senior IT Consultant Keslin Engineering, Inc. 6212 W. Monee-Manhattan Road Monee, IL 60449 P. (708) 235-1150 F. (708) 235-1148 --------------------------------------------------------------------- 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
