Re: MySQL + VB problem

2001-08-15 Thread Doc
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 f

RE: MySQL + VB problem

2001-08-15 Thread Michael Widenius
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. Ve

RE: MySQL + VB problem

2001-08-15 Thread Mariusz Muszalski
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

RE: MySQL + VB problem

2001-08-15 Thread Venu
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