Scott Haneda wrote:
> I have the following...
>
> tSql = "SELECT l.team, l.link, lc.category, l.age, l.date
> FROM league AS l
> INNER JOIN league_category AS lc
> ON l.category = lc.id
> WHERE lc.id = " & prepSQL(tConn, id) & " AND l.status = '1'
> ORDER BY
-
From: "Scott Haneda"
Sent: Thursday, November 13, 2003 5:34 PM
Subject: Order by a number not leading in zero
> I have the following...
>
> tSql = "SELECT l.team, l.link, lc.category, l.age, l.date
> FROM league AS l
> INNER JOIN league_catego
I have the following...
tSql = "SELECT l.team, l.link, lc.category, l.age, l.date
FROM league AS l
INNER JOIN league_category AS lc
ON l.category = lc.id
WHERE lc.id = " & prepSQL(tConn, id) & " AND l.status = '1'
ORDER BY l.age, l.date";
L.age has data in
