Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases 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 August 3rd, 2005, 08:40 AM
Registered User
 
Join Date: Aug 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

OK, I'll give you two.

 1. Chinn Center
 2. Community Pools

Remember that I dynamically create the dropdown from the database, but that's two of the items I pull in.

Mark Gordon
 
Old August 3rd, 2005, 08:50 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Mark,

Is your site field in the db a text field? If so, you need to surround the value in your where clause with quotes:
Code:
site='Chinn Center'
instead of
Code:
site=Chinn Center
HTH,

Chris
 
Old August 3rd, 2005, 12:27 PM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default

How about if you let your selections have an include file:
<%If something then%>

<%End If%>

Martial Law 9/11 Rise of the Police State is now available! Visit our Martial Law movie section for complete info (click here), or order now by clicking the button below or by calling 888-253-3139
http://www.infowars.com/martial_law_911.htm





Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem in Displaying preselected data in dropdown deb_kareng ASP.NET 2.0 Professional 2 August 14th, 2007 05:00 AM
Displaying values in dropdown list from mysql db scoobie Beginning PHP 3 January 25th, 2005 12:09 PM
select value of a dropdown in a datagrid Sbartis ASP.NET 1.0 and 1.1 Professional 2 January 14th, 2005 05:19 PM
Problem displaying one of the records. mAdg3rr Classic ASP Databases 5 June 24th, 2003 08:56 PM





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