Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XML or ASP(ACCESS)????

Status
Not open for further replies.

qb828

Programmer
Sep 27, 2000
98
US
Hi Guys!

I am new to XML and need some guidances from anyone.
I know a little XML and afraid to start my small project with xml.

I have records like this:

Name: Mike Johnson
Sex: male
age: 45
Photo: mJohnson.gif
X-Ray: mJohnson_xray.gif.

Name: Susan Hall
Sex: female
age: 36
Photo: sHall.gif
X-Ray: sHall_xray.gif

I have 100 of these records.
I need to query name and display the information on the HTML page.
(I have to display one person in one HTML page>

I also need to query other fields and display the names.
Find all the females...and display all the names of females.

Is XML a good choice for this project?

or should I do with ASP and access database??

***********************************
another question??

Do I keep all the records in one xml file??
(100 reocords in one xml file?? what if 1,000??)
Like this:
<XML>
<root_contact>
<Person>
<name>Mike Johnson</name>
<sex>35</sex>
....
</Person>
<Person>
<name>Susan Hall</name>
<sex>26</sex>
....
100 more names
</XML>
is that right?? isn't that too big in one file??

I need your help.
THank you.


QB
 
It depends what other information you wish to store. If none, then XML will do. To convert the entries easily to HTML, I would use Data Islands. Data Islands are the easiest way to display xml in HTML. You can page through the entries one by one using straightforward buttons, such as Next / Last, etc.
For advanced queries, and if you want to store more details / relations of a record, I would use a database of some sort, eg. MSAccess.
If you think Data Islands could be an option, I can send you an example on it. (I once created an almost identical project to the one you have.)

If you want to get a job done, ask a busy person. (Sherry Conway Appel - American writer)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top