search through access database

		Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.1
search through access database

ASP.NET 1.1 As of 10/6/2005, this forum is locked as part of the reorganization described here: http://p2p.wrox.com/topic.asp?TOPIC_ID=35394. No posts have been deleted. Open ongoing discussions from the last week have been moved to either ASP.NET 1.0 and 1.1 Beginners http://p2p.wrox.com/asp-net-1-0-1-1-basics-60/ or ASP.NET 1.0 and 1.1 Professional. http://p2p.wrox.com/forum.asp?FORUM_ID=50. See my sticky post inside for more.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.1 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

January 2nd, 2005, 02:47 PM

kale_tushar kale_tushar is offline

Authorized User

Join Date: Jul 2003

Posts: 20

Thanks: 0

Thanked 0 Times in 0 Posts

search through access database

i m using following query

SELECT RANK, u_id, u_title FROM Uploads FREETEXTTABLE( Uploads, *, @searchphrase ) searchTable WHERE [KEY] = uploads.u_ID ORDER BY RANK DESC

to search thru access database..it is giving me error "Syntax error in FROM clause"

what is the wrong in above statement...??

Tushar

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search button doesn't search Access DB	cbones	Visual Studio 2008	1	October 27th, 2008 07:36 PM
Multiple Parameter Search Against Access Database	stublair	Classic ASP Databases	2	July 21st, 2008 05:26 PM
Search in Database?????	Samora	C#	2	October 10th, 2007 07:41 AM
how to search in database	saif44	ASP.NET 2.0 Professional	11	March 8th, 2006 03:33 PM
need help, to Search from database	vikky17	Classic ASP Basics	1	February 5th, 2006 12:35 AM