hi!
>>>>> "Venu" == Venu <[EMAIL PROTECTED]> writes:
Venu> Hi !
Venu> MySQL doesn't support sub-queries/selects yet, will be supported from 4.x
Venu> version onwards.
Venu> Please read the following link for more information about the missing
Venu> functionality and how you can make it up.
Venu> http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#
Venu> Missing_Sub-selects
Venu> Regards
Venu> Venu
Venu> )From: Mariusz Muszalski [mailto:[EMAIL PROTECTED]]
Venu> )Sent: Wednesday, August 15, 2001 7:48 AM
Venu> )To: [EMAIL PROTECTED]
Venu> )Subject: MySQL + VB problem
Venu> )
Venu> )
Venu> )I try to execute mySQL query from VB:
Venu> )
Venu> )strSQL = "SELECT @BF:= Date From Results Where GameID=" & GameID & " Order
Venu> )by Date ASC LIMIT 1;"
Venu> )strSQL = strSQL & "SELECT @BL:= Date From Results Where GameID=" & GameID &
Venu> )" Order by Date DESC LIMIT 1;"
Venu> )strSQL = strSQL & "SELECT @BF as BF, @BL as BL;"
Venu> )
Venu> )Set RS = Conn.GetRS(strSQL)
<cut>
The problem in this case is not subselects but executing multiple
selects in one row.
We plan to add multiple resultsets to 4.1, which will make things like
this possible to do.
Regards,
Monty
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com
---------------------------------------------------------------------
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
