Wrox Programmer Forums
|
Classic ASP Professional For advanced coder questions in ASP 3. 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 Professional 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 4th, 2005, 08:29 PM
Registered User
 
Join Date: Mar 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default searching function using asp code

hi..i have a problem regarding the searching data..the searching function that i want is when i search 'a' the data with start 'a' will be appear..but what i did now, when i search 'a' all the data which have 'a' in sentence will be appear..i dont want like that..anybody, please help me..

 
Old May 8th, 2005, 09:56 PM
uit uit is offline
Authorized User
 
Join Date: Jul 2003
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If searching via SQL, try:

SELECT <col_name> FROM <table_name> WHERE <search_col_name> LIKE 'A%'

or some variant of that depending on the DBMS, etc.

Hope that helps, you werent specific on where the data was located so I took a stab at helping...

Good Luck





Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching for a user in Active Directory with ASP Ricapar Classic ASP Professional 1 July 15th, 2008 11:07 PM
asp searching and recordset paging kumiko Classic ASP Basics 0 May 22nd, 2007 03:46 AM
Using SQL function MAX within ASP code TwoCoby Oracle ASP 1 December 21st, 2003 07:23 PM
Searching ASP Arrays higgsy Classic ASP Basics 0 June 24th, 2003 05:37 AM





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