LIMIT in query

-Log in
-Register (free)

-RSS Feeds
-New MyDesk Module
-Update to Profile

• how to do a partial string compare
• cheap kicks,cheap jordan 1 size 8-13 retro
• cheap jordan kicks,cheap nike sb dunk shoes,cheap

Forums /

LIMIT in query
fredmjf | Posted 2:55pm 31. May 2009 Server Time |

Hello,
I have the following asp-query problem:
When i used an access database i had this query:
SELECT TOP 1 * FROM TblUsers Where UserId=" & oItems("UserId")

Now i'm over to mysql but the query isn't good. It lookes like i'll have to use LIMIT 1 in place of TOP 1 but how and where must i'll put it in the query??

Fred

katy8439 | Posted 4:31am 1. June 2009 Server Time |

"SELECT * FROM `your_table` WHERE UserID = "&oItems("UserID")&" LIMIT 0, 1"

Should show only the first record

Katy

Show all replies to 'LIMIT in query'

To post a message to this discussion you need to be
a Haneng.com member. If you already are a member please log in
if not register as a member here (free).

| Info |