I have built a web site that queries an Access database for our current inventory. I built ASP pages that use SQL to query the database for images and text. I need to be able to then pull a specific record and have it displayed in a seperate page. I have been creating my XML document and an XSL document, but I am having a REALLY hard time understanding how to tie all of this together. Can anyone give some tips?
Here basically what my XML doc looks like:
<?xml version="1.0" encoding="UTF-8"?>
<trucks>
<inventory>
<Stk>2619</Stk>
<YR>1989</YR>
<Make>FORD</Make>
<Model>8000</Model>
<Body>UTILITY</Body>
<Color>WHITE</Color>
<GVW>36100</GVW>
<Engine>3208CAT</Engine>
<HP>215</HP>
<Trans>manual</Trans>
<Brks>AIR</Brks>
<Miles>15144</Miles>
<Options>A/C, P/S, P/B, RADIO/CASS</Options>
<PRICE>10900</PRICE>
<Picture><Type>CRANE</Type>
</Inventory>
My XSL sheet is a bit to be desired b/c I don't know how to pull the above information and a picture. To give a better idea of what I need to do is here:
If you click on the picture of the truck it opens a spec sheet. This is what I need to be able to do. Just not sure how to write the code. Thanks for any help.
Here basically what my XML doc looks like:
<?xml version="1.0" encoding="UTF-8"?>
<trucks>
<inventory>
<Stk>2619</Stk>
<YR>1989</YR>
<Make>FORD</Make>
<Model>8000</Model>
<Body>UTILITY</Body>
<Color>WHITE</Color>
<GVW>36100</GVW>
<Engine>3208CAT</Engine>
<HP>215</HP>
<Trans>manual</Trans>
<Brks>AIR</Brks>
<Miles>15144</Miles>
<Options>A/C, P/S, P/B, RADIO/CASS</Options>
<PRICE>10900</PRICE>
<Picture><Type>CRANE</Type>
</Inventory>
My XSL sheet is a bit to be desired b/c I don't know how to pull the above information and a picture. To give a better idea of what I need to do is here:
If you click on the picture of the truck it opens a spec sheet. This is what I need to be able to do. Just not sure how to write the code. Thanks for any help.