|
|
|
|
|
| | |
| |
Active Server Pages asp search engine active server page asp application components tutorial CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Using a Recordset to Display Records |
|
From: |
Anamika |
|
Date: |
6/7/2000 12:52:57 AM |
|
IP: |
164.164.87.180 |
You can use the same sql to get some specific fields. For ex:
if you have given your sql statement as follow:
select * from mytable;
then, give it as
select field1, field2 from mytable;
Similarly, you can also use more than one table by using the sql statment itself.
For ex:
select a.field1, b.field2 from table1 as a, table2 as b where a.commanfield1=b.commanfield2;
Try this and it will work out for u.
bye,
anamika |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
