I think the query should be as below
SELECT Min(Col1) as Col1, Col2 FROM Table1 GROUP BY Col2
then somewhere in your page,
response.write(rs("Col1"))
Thanks
ST Ooi
Malaysia
----- Original Message -----
From: "Jimmy44 --" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 05, 2001 5:39 AM
Subject: Problem with ASP + mySQL
> Dear all,
>
> I am having the following problem with ASP + mySQL
> Actually, when executing the following Query:
> SELECT Min(Col1), Col2 FROM Table1 GROUP BY Col2
>
> I get an empty recordSet, while executing the following query doesn't
return
> an empty recordSet:
> SELECT Col1,Col FROM Table1 GROUP BY Col1
>
> I am connection using:
> RS.Open SQLQuery, Connection
>
> Can someone help?
>
> Thanks,
>
> Jimmy
>
>
>
>
>
>
____________________________________________________________________________
__
> Send a friend your Buddy Card and stay in contact always with Excite
Messenger
> http://messenger.excite.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
>
>
---------------------------------------------------------------------
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
