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)
Mariusz Muszalski
---------------------------------------------------------------------
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