I am wondering how do I display a specific record from a table on a page -

For-instance if I have an insertion page that adds lets say record id 7 to the database. How would in Dreamweaver MX - have my home page (or any page) display just that record - But that wouldn't be the only content on the page -

I tried to drag dynamic text into the layer I am using but it only gives me the first record. I also tried to make a preview page so it would create a formated .asp page... from which I would attempt to #include that .asp with the format preview.asp?id=7 and that didn't work.... HELP???

Dear Tomsca,
In the SQL for the record query:

WHERE ID = 7

Regards,
Brent

As you can tell - I am a little new to asp scripting. What I am wondering is which query page are you refering to. Basically what I wanted to do was to make the home page text of my site (www.sucasafilms.com) be able to display this recordset - and then throught an update page modify that text at will. - So there would be no searching....

Does that make any sense?

Tom

Dear Tomsca,
On the page that you want the info displayed, create a Recordset like:

SELECT *
FROM yourDB
WHERE ID = 7

Drag the appropriate field from the Recordset panel into your layer.

Regards,
Brent