Tipu
|
| Posted: 11/03/2002, 2:55 AM |
|
I am using Codecharge (not studio)
I am sure its very simple for you guys. I can do it in access but not in ASP.
basically i have few fields in a table(link) i only want to see list in a grid between 1-4
there are 3 fields in grid (link_id ,link_name and Sponsor)
i tried typing it in and also copying sql statment from Access its not working
here is the statment from Access
=======
SELECT links.link_id, links.link_name, links.sponsor
FROM links
WHERE (((links.sponsor) Between "1" And "4"));
=======
|
|
|
 |
Ken Hardwick
|
| Posted: 11/03/2002, 4:31 AM |
|
Try...
SELECT
L.link_id,
L.link_name,
L.sponsor
FROM links L
WHERE
L.sponsor Between '1' And '4'
|
|
|
|
|
