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_Introduction.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