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 =
#
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
://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
hey Mariusz
what i usually do is like this:
Set SQL1 = conn.execute(select * from tbl_blah)
Set SQL2 = conn.execute(select count(*) as hops from tbl_pong where
row_poof='SQL1(blah)')
and so forth
- Doc
database sql query table -- as requested
I try to execute mySQL query from VB: