How to list - ASP / Active Server Pages

Paulo Roberto

Hi, I need the following results:

NameOfExam1 NameOfExam2 NameOfExam3 ...
NamePacient

12/10/2007 01/01/2007 ...
Paul 12/12/2007 01/03/2007 ...
20/12/2007 01/03/2007 ...

.... ...
.... ...

So I have some tables:

PacientTable:
Code -AutoNumber
Name -char(50)

ExamTable:
Code -AutoNumber
NameOfExam -Char(50)

ScheduleExams:
PacientCode -Number PK
ExamCode -Number PK
DateScheduled -DateTime PK

if I feed the tables with the example showed above, we'd have:

PacientTable:
1 Paul

ExamTable:
1 NameOfExam1

ScheduleExams:
1 1 12/10/2007
1 1 12/12/2007
1 1 20/12/2007

I cannot think a logic to list the table above on <table>trs and tds

Should it be done using more than 1 recordset? What you suggest? Can you
help me ?

Thanks a lot!

Dec 14 '07 #1

Subscribe Post Reply

1239

Similar topics

Sorted Linked List

by: massimo | last post by:

Hey, I wrote this program which should take the numbers entered and sort them out. It doesn¹t matter what order, if decreasing or increasing. I guess I'm confused in the sorting part. Anyone...

C / C++

Best method to sort a linked list (in my case)?

by: Kent | last post by:

Hi! I want to store data (of enemys in a game) as a linked list, each node will look something like the following: struct node { double x,y; // x and y position coordinates struct enemy...

C / C++

Code Review (Skip List)

by: Robin Cole | last post by:

I'd like a code review if anyone has the time. The code implements a basic skip list library for generic use. I use the following header for debug macros: /* public.h - Public declarations and...

C / C++

declaring and using a linked list

by: AZRebelCowgirl73 | last post by:

This is what I have so far: My program! import java.util.*; import java.lang.*; import java.io.*; import ch06.lists.*; public class UIandDB {

Java

linked list template class doesn't compile

by: QiongZ | last post by:

Hi, I just recently started studying C++ and basically copied an example in the textbook into VS2008, but it doesn't compile. I tried to modify the code by eliminating all the templates then it...

C / C++

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

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,...

General

Changing the language in Windows 10

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...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA