Reading the sections on databases and connections have gotten me pretty far. I could use explanations and more tutorials.

I get how to create a record set. What is the best method to display a record set?

Conventional wisdom questions.
Don't I want my users making the recordsets? Example: end user wants to search records in Texas.

Dreamweaver adds code to what ever page is open. Do I want a different page for each result?

thanks
jerry h

Hi Jerry,

What "sections on databases and connections" are you referring to?

End users don't make recordsets. You write the code for the recordset and end users can then provide, say, a search term that you use in your query to create a recordset.

There are different ways to get the data from a recordset, including looping through it and using GetRows. Looping is quite common and gives you a lot of flexibility.

You may also want to take a look at Beginning Dreamweaver MX 2004: http://www.wrox.com/WileyCDA/WroxTit...764555243.html

BTW: if you are about to learn ASP, you might as well start learning ASP.NET 3.5 instead.

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

I am using two books. The MX2004 book you mentioned is one of them supplemented by DreamWeaver 8 Bible.

I have a record set working and tested. I did not need to use repeat region and the test displayed all results. So I am not sure how I am really supposed to use Repeat Region.

How odd though that the advanced filter does not allow filters like AND OR.

Thanks
Jerry

It does allow you to define them; it's just that the UI is a bit limited to do so. You need to manually type OR and AND but you can use the WHERE button and the parameter dialog.

Pretty limited, I know. but you can least use it to set up some simple parameterized queries.

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

Hi Imar,

Pleasure to be talking to the author. I am re-reading chapter 12.

So when I drag columns from the bindings panel to the HTML table,
(like Figure 12-4),that is fine. But I get a "page not found" error when I preview the page in browser. The page is saved and even "put"

Note: I am using a different web and not using the events.asp or the sample project from your book.

Thanks
Jerry

all the best
jerry h

correction on the browser error. The correct error is "page can not be displayed".

That sounds like an ASP error somehow. Take a look here to see how you can get more details about the error: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=264

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.