my question was not about subqueries....
Mariusz Muszalski
> -----Original Message-----
> From: Venu [mailto:[EMAIL PROTECTED]]
> Sent: 15 August 2001 16:29
> To: Mariusz Muszalski; [EMAIL PROTECTED]
> Subject: RE: MySQL + VB problem
>
>
> Hi !
>
> MySQL doesn't support sub-queries/selects yet, will be supported from 4.x
> version onwards.
>
> Please read the following link for more information about the missing
> functionality and how you can make it up.
> http://www.mysql.com/documentation/mysql/bychapter/manual_Introduc
> tion.html#
> Missing_Sub-selects
>
> Regards
> Venu
> )-----Original Message-----
> )From: Mariusz Muszalski [mailto:[EMAIL PROTECTED]]
> )Sent: Wednesday, August 15, 2001 7:48 AM
> )To: [EMAIL PROTECTED]
> )Subject: MySQL + VB problem
> )
> )
> )I try to execute mySQL query from VB:
> )
> )strSQL = "SELECT @BF:= Date From Results Where GameID=" & GameID
> & " Order
> )by Date ASC LIMIT 1;"
> )strSQL = strSQL & "SELECT @BL:= Date From Results Where GameID="
> & GameID &
> )" Order by Date DESC LIMIT 1;"
> )strSQL = strSQL & "SELECT @BF as BF, @BL as BL;"
> )
> )Set RS = Conn.GetRS(strSQL)
> )...
> )
> )but there is a strange error: [TCX][MyODBC]You have an error in your SQL
> )syntax near ';SELECT '2001/12/12' as BL, 1 as BF' at line 1
> )
> )sound like I can't execute more then one query in one time...
> should I use
> )above instead ???
> )
> )strSQL = "SELECT @BF:= Date From Results Where GameID=" & GameID
> & " Order
> )by Date ASC LIMIT 1;"
> )Set RS = Conn.GetRS(strSQL)
> )strSQL = "SELECT @BL:= Date From Results Where GameID=" & GameID
> & " Order
> )by Date DESC LIMIT 1;"
> )Set RS = Conn.GetRS(strSQL)
> )strSQL = "SELECT @BF as BF, @BL as BL;"
> )Set RS = Conn.GetRS(strSQL)
> )
> --
> For technical support contracts, go to https://order.mysql.com/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
> /_/ /_/\_, /___/\___\_\___/ Woodside, California USA
> <___/ 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
