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
g
Venu> functionality and how you can make it up.
Venu> http://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,
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
.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 Wh
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 R
