New to DRW..Help?

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

New to DRW..Help?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> New to DRW..Help?

Page: [1]


A1234 Posts: 101 Joined: 10/7/2004 Status: offline	New to DRW..Help? - 10/7/2004 19:55:54 I got as far as creating 2 drop down boxes for search criteria. One is to search by "state", the other is to search by "endorsement". It seems to be performing ok, but the problem is this: Check out my page at www.nadras.com/searchtemp.asp. The first drop down box contains the states. However, it only shows the states that are currently in the database, as opposed to having a list of states to choose from. As you can see, in the state box there are 2 "AL" (alabama). This is because there are 2 people in the database that live in Alabama. Eventually i'm going to have hundreds of people from Alabama and don't want hundreds of "AL"'s to show up in that drop down box. The same goes with the second box "endorsements". There are 2 empty spaces in that drop down box because there are 2 users in the database with no endorsements. I want to be able to choose from a list of endorsements, not from what the users have selected in the database. Does anyone have a fix for this?


Spooky Posts: 26599 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: New to DRW..Help? - 10/7/2004 20:10:53 Hey there ! That record looks familiar Are you using the DRW to produce a drop down list? If so - you might like to use "DISTINCT" in your SQL string "SELECT DISTINCT x_State from Users" _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to A1234)


A1234 Posts: 101 Joined: 10/7/2004 Status: offline	RE: New to DRW..Help? - 10/7/2004 20:49:26 Howdy stranger! I'm always up for learnin something new. The query string I have right now is "fp_sQry="SELECT * FROM Users" I tried to change it to Distinct but when I hit save it converted bck to this...? (in reply to Spooky)


A1234 Posts: 101 Joined: 10/7/2004 Status: offline	RE: New to DRW..Help? - 10/7/2004 21:54:22 Oh!!! I got it now...was putting it in the wrong place...persistence pays off again. Thanks! (in reply to A1234)