ASP Database Search Result Problem
$30-100 USD
Paid on delivery
I am performing a search on a single table database from an asp page. The SQL as below from is from the recordset, on returning the results it will leave out any record(s) that have a null value. The SQL is as follows: SELECT Title, FirstName, surname, CompanyName, BusinessType, JobTitle, Department, Address_1, Address_2, Address_3, Address_4, country, Postcode, WorkTel, Workfax, MobileTel, Email, EuropeanCommittee, NationalNetworkRep, EuroDefiContact, NationaNetworkManagement, WebAddress FROM tbl_Members WHERE Surname LIKE 'txtsurname%' AND country LIKE 'txtcountry%' AND CompanyName LIKE 'txtcompany%' AND Address_4 LIKE 'txttown%' ORDER BY Surname I have attached the search and results page, plus database. The database is access 2000 and Ultradev 4 is used for the web stuff. I need someone to correct the coding where as needed.
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
## Platform
The database is access 2000 and Ultradev 4 is used for the web stuff.
## Deadline information
Need the work completing urgently
Project ID: #2838519