DRW prepopulated search

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

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

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

DRW prepopulated search

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 >> DRW prepopulated search

Page: [1]


ybrown Posts: 4 Joined: 12/8/2006 Status: offline	DRW prepopulated search - 12/8/2006 15:09:06 I need to only show unique values in the drop down. I did it last week and lost the code to do it. Help, please! Thanks.


ybrown Posts: 4 Joined: 12/8/2006 Status: offline	RE: DRW prepopulated search - 12/8/2006 15:59:05 SELECT DISTINCT is not working when I add it to the custom query. Any suggestions? Thanks. (in reply to ybrown)


ybrown Posts: 4 Joined: 12/8/2006 Status: offline	RE: DRW prepopulated search - 12/11/2006 13:55:25 Anybody? Is there a condition where the DISTINCT statement will not work? I've been at this for days now and I'm completely stumped. I've tried several times with new pages and still the same thing. Any help would be greatly, greatly appreciated. Thanks. (in reply to ybrown)


BeTheBall Posts: 6385 Joined: 6/21/2002 From: West Point Utah USA Status: offline	RE: DRW prepopulated search - 12/11/2006 16:13:21 What is the full SQL you are trying? _____________________________ Duane Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs. (in reply to ybrown)


colfrancis Posts: 6 Joined: 12/13/2006 Status: offline	RE: DRW prepopulated search - 12/13/2006 13:16:28 can we see your code segment please. (in reply to ybrown)


colfrancis Posts: 6 Joined: 12/13/2006 Status: offline	RE: DRW prepopulated search - 12/13/2006 13:26:03 Remember DISTINCT looks for a totally unique record FOR ALL FIELDS that you are selecting.... the whole row must be unique and any variation of a secondary field will give you another record. (in reply to colfrancis)