Wrox Programmer Forums
|
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Dreamweaver (all versions) section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 16th, 2008, 01:59 PM
Registered User
 
Join Date: Dec 2007
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default recordsets- displaying and conventions

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
 
Old February 16th, 2008, 04:43 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.
 
Old February 18th, 2008, 11:54 PM
Registered User
 
Join Date: Dec 2007
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old February 19th, 2008, 01:18 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.
 
Old February 21st, 2008, 02:09 PM
Registered User
 
Join Date: Dec 2007
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old February 21st, 2008, 03:31 PM
Registered User
 
Join Date: Dec 2007
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

correction on the browser error. The correct error is "page can not be displayed".
 
Old February 23rd, 2008, 05:43 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Namespace Naming Conventions For Layerd Applicatio Muhammad Zeeshan General .NET 2 September 1st, 2007 02:03 PM
Help with Recordsets voskoue Access VBA 1 January 23rd, 2007 08:36 AM
Variables in the four naming conventions FJInfante SQL Server 2000 3 May 1st, 2006 01:06 PM
Code Writing Conventions richard.york PHP FAQs 0 April 5th, 2004 08:23 PM
Naming conventions jara VS.NET 2002/2003 3 June 22nd, 2003 04:21 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.