Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP 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 May 26th, 2006, 10:49 AM
Registered User
Join Date: May 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Please Help...Recordset in DreamWeaver

I am trying to design a dynamic website using DW 8, with an Access Database, and coding with ASP. What I would like to do is build a search page using multiple drop-down boxes to select a value and get data that match on the results page. I have a sample site that I would like to copy their search operation exactly. If you go to this site...http://www.ogb.state.ms.us/wellsearch.php - you will be able to select a value from any of the combo boxes and get a match that is related to what was selected on the following results page. I'm looking for a search method just like that website so that I can give my clients the freedom to search for data base on what they selected in the multiple combo boxes. I need help in the code part...how to I code my master recordset in Dreamweaver using ASP to operate a search function just like the page I stated above.

Quick Sample:

 If my clients select a Operator Name from the operator combo box and select a County from the county combo box then when they press the submit button - they will only see data if there is a match shared with the Operator Name and the County together. I don't want my clients to see data that (wildcards) for the operator name and county they selected, if it is possbile to build a search engine like the site above could someone please start me off.

Any Help Greatly Appreciated,
Thank You.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Clone DAO Recordset into ADO Recordset kamrans74 VB How-To 0 March 6th, 2007 11:57 AM
Recordset error in Dreamweaver Using PHP and MySQL toosuave Dreamweaver (all versions) 1 August 25th, 2006 07:27 AM
dreamweaver(Database/recordset error ) Divya Kedia Dreamweaver (all versions) 0 March 18th, 2006 10:39 AM
ADODB.Recordset (0x800A0CB3)Current Recordset does tks_muthu Classic ASP Databases 0 June 16th, 2005 07:22 AM
Convert ADO recordset to DAO recordset andrew_taft Access 1 May 5th, 2004 02:31 PM

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