Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

USE CFSEARCH FOR SEARCHING SQL DB?

Status
Not open for further replies.

lizok

Programmer
Jan 11, 2001
82
US
hi all, i'd like to know if it is possible to use CFSearch to search ALL fields in a SQL table based on input from the user?

thank you
;-(
 
Yes, it is possible, first you must have all the fields you want the user to search specified in your query, then you can format your results as you need. To help you out more post a sample of the code you are using... I used CF to build a Help database in which the user can search all fields in a specified table, This sounds similar to what you are doing.

Hope this helps, be looking for your next reply,

Good Luck,
SteelDragon
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top