 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ASP / Database Access / December 2007How to show the table desired on asp?
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 Is it possible to show the table desired above? How can I make a SQL statment? Should it be done using more than 1 recordset? What you suggest? Thanks a lot! google: recordset to table asp -.net lots of samples to choose from > Hi, I need the following results: > [quoted text clipped - 27 lines] > > Thanks a lot! > Hi, I need the following results: > [quoted text clipped - 27 lines] > > Thanks a lot! Lookup "crosstab" queries. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.