Hi All,
I neeed to dispaly the data in html table tag
Query :-select comp,total,fund s from table1,
WHICH WIL RETURN 3-RECORDSETS
rs_query(0)
rs_query(1)
rs_query(2)
The 2nd row is retrived from aother query
Query :-select companies from table2 where comp='reliance'
RS_fund(0)
i need to display the recordset in a table .can some one pls help it ASAP.
pls mail me at <removed email - use PM if necessary>
fOR EX:-
Ist rOW:-Reliance
2nd ROW :-RPL
rnL
rnrl
3rRD ROW:-1000
4TH ROW:-333
Ist row ,3rd row and 4th row values are retrived from a single query
CODE:-
[html]
<tr id="COL1" colspan=7 bgcolor="<%=bgC ol%>" >
<td width=122px ><font face="" id="COL1" size="2" class="pastanda rd"><%=rs_query .fields(0)%></font></b></td>
<td width=122px ><font face="" id="COL1" size="2" class="pastanda rd"><%=rs_FUND. fields(0)%></font></b></td>
<td width=122px ><font face="" id="COL1" size="2" class="pastanda rd"><%=rs_query .fields(1)%></font></b></td>
<td width=122px ><font face="" id="COL1" size="2" class="pastanda rd"><%=rs_query .fields(2)%></font></b></td>
</tr>
[/html]
Please help me ASAP i am havng a dead line
2  1260 
which platform are you using where from you are displaying the data in a table from the data base or by taking it as a input from the user ....elaborate your question before your expect a reply
 jhardman 3,406
Recognized Expert Specialist
Hi All,
I neeed to dispaly the data in html table tag
Query :-select comp,total,fund s from table1,
WHICH WIL RETURN 3-RECORDSETS
rs_query(0)
rs_query(1)
rs_query(2)
Why does this return 3 recordset? or do you mean it returns 3 records?
The 2nd row is retrived from aother query
Query :-select companies from table2 where comp='reliance'
RS_fund(0)
...
CODE:-
[html]
<tr id="COL1" colspan=7 bgcolor="<%=bgC ol%>" >
<td width=122px ><font face="" id="COL1" size="2" class="pastanda rd"><%=rs_query .fields(0)%></font></b></td>
<td width=122px ><font face="" id="COL1" size="2" class="pastanda rd"><%=rs_FUND. fields(0)%></font></b></td>
<td width=122px ><font face="" id="COL1" size="2" class="pastanda rd"><%=rs_query .fields(1)%></font></b></td>
<td width=122px ><font face="" id="COL1" size="2" class="pastanda rd"><%=rs_query .fields(2)%></font></b></td>
</tr>
[/html]
Please help me ASAP i am havng a dead line
This looks good. What part is giving you trouble?
Jared
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: SB |
last post by:
What I want to achieve ...
Display file names from sql server database,
on click the file should open up using test.exe file.
Using the following code, I am able to display the
files and click on related link, however, I can't
get to pass on the filename. I would also like to bypass
the message 'Open/Save/Save as' and directly be able
to...
|
by: XML newbie: Urgent pls help! |
last post by:
I am working on VB.Net application. I have a GUI where the user logs on and
gets SessionId. Once, the connection is successful, the user is redirected to
another screen where he choses which table and the starttime and end time to
select the data from the database on the remote server. I create a reference
to the remote web service. How do I...
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to
communicate with a MySQL database table on a web server, from inside
of my company's Access-VBA application. I know VBA pretty well but
have never...
|
by: rajbala.3399 |
last post by:
Hai all,
I need to get multiple image buttonsand wheni click on the image
button it should display corresponding image on window and if i click
another image button it is also display on same window without
replacement of previously displayed image.
For exampe,
|
by: karizmatrix22 |
last post by:
Hi,
I need a programmer who can write 3 programs for following questions below.Programs need to be ready before nextweek.thank you. Person who help me these 3 questions will be get paid.. I am new to programming, thats why i need help..i dont understand any coding at all.
Question 1:
Write an application that accepts a user’s password...
| | |
by: cj |
last post by:
My code below gives me "SQL: Column 'BTN' is not found."
It will work if I use an inner join or just join but those two joins
don't return all the rows. BTN has 5 rows, but arcust01 has only has
matching records for 2 of them. I need the other 3 returned with nulls
in the fields from arcust01.
How can I do this?
|
by: javabeginner123 |
last post by:
i have a java prob, and i have to solve it fast, but i'm just getting to know it, so plz help me solve it with full code completed, thanks so much. the prob is to create a monter fight and there is the description:
The monsters are of a very strange kind, called "Bigmon". They have some basic characteristics, like attack and defense power, life...
|
by: kashhere |
last post by:
Hi
i am working on drop down list boxes.
My main aim is to display a table if the option is selected in the list box
i have kept the table as invisible
please guide me towards the solution
here goes the code
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
