Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Web Programming > Adobe Web Programming > Dreamweaver (all versions)
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 16th, 2008, 01:59 PM
Registered User
 
Join Date: Dec 2007
Location: chevy chase, maryland, USA.
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
Reply With Quote
  #2 (permalink)  
Old February 16th, 2008, 04:43 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 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.
Reply With Quote
  #3 (permalink)  
Old February 18th, 2008, 11:54 PM
Registered User
 
Join Date: Dec 2007
Location: chevy chase, maryland, USA.
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
Reply With Quote
  #4 (permalink)  
Old February 19th, 2008, 01:18 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 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.
Reply With Quote
  #5 (permalink)  
Old February 21st, 2008, 02:09 PM
Registered User
 
Join Date: Dec 2007
Location: chevy chase, maryland, USA.
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
Reply With Quote
  #6 (permalink)  
Old February 21st, 2008, 03:31 PM
Registered User
 
Join Date: Dec 2007
Location: chevy chase, maryland, USA.
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".
Reply With Quote
  #7 (permalink)  
Old February 23rd, 2008, 05:43 AM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 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.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 10:52 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.