Air Compressor Bot
|
|
Home |
How it works |
Projects archive |
Contact Us Air Compressor Bot |
|
| The Career Path of Freelance Programming Jobs |
Sql Server Asp Search Form |
 |
Bidding Time: |
03/11/2004 15:28 - 05/11/2004 15:28 |
Budget: |
$30-150 |
Status: |
Closed |
|
|
|
Job Type: |
|
Description: |
this because it is not being built right. I have most of the script for the text search completed, but I need the other fields queried as well as the text file. Because I have lost 3 weeks already on this, I need the next programmer to get this finished no later that 3 days from the time I hire you. I already have most of the code, but it may just need a tweaking. I need to setup a simple query that takes a form variable, queryies a SQL server 7.0 database. The query will search a notepad text file located on the harddrive. In the database field named item_description, the name of the file is found. I will create the database on the server, but MAY need some assistance in setting up the fulltext searching on SQL server 7.0. Database table manuscript_id (int) (autonumber) man_title (nvarchar) man_type (nvarchar) call_number (nvarchar) primary_company_subject (nvarchar) summary (nvarchar) date_of_source (nvarchar) publication_info (nvarchar) author (nvarchar) added_author (nvarchar) original_format (nvarchar) notes (nvarchar) subjects (nvarchar) collection_donor (nvarchar) copyright_restrictions (nvarchar) subject_keywords (nvarchar) document_text (nvarchar) record_updated (nvarchar) The database will be setup and referenced as a DSN. I need the form variable queried against the textfiles referenced in the database and other fields, then display 1)link to the textfile, 2) the man_title 3) The man ID on a results page. Then below the results from the database query, This will need to be built with speed in mind, as there will be nearly 10,000 records with notepad files and other corresponding columns of data. I anticipate 2 ASP pages with scripting. Search form page (search.asp) Search from results (search_results.asp) Here is a sample of what I have already. Set rs = Server.CreateObject("ADODB.Recordset") Dim sStr sStr = "SELECT b.manuscript_id, b.man_title, a.FileName FROM OpenQuery(FileSystem, " sstr = sstr & "'SELECT Directory ,FileName FROM SCOPE('' ""D:\Clients\Shane\TextFiles\"" '')" sstr = sstr & " WHERE CONTAINS('' " & Session("SearchString") & "'') > 0 " sstr = sstr & " AND FileName LIKE ''%.txt%'' ') AS a inner join manuscripts as b on " sstr = sstr & " a.directory+'\'+a.Filename = lower(b.document_text)" rs.Open sstr,con,adOpenStatic This searches the text file just fine, but doesn't search the other columns. This should make your job easier, since most of it is working. Get $20 Off Panda Internet Security 2008. Coupon Code: WOWPISUSD20.
 Help Needed Please Sales Site - Interview Product Members Password-protection Redesign Of Our Company's Site Spam SystemThis project is the proprietary information of .
Click here to remove this project from OUR database.
|
Operating System: |
Windows |
Database System: |
SQL |
| <<< back |
|
| Home | Projects archive | RSS | Resources | Links | Contact Us | © 2004-2009 ProjectsList.biz /0.061 |