My boss is currently trying to create a website using ASP, SQL and Dreamweaver. All works fine except when time comes to search database, the screen shows the first record entered in the database as the answer, Not the queried request. Any ideas?

Hi,

Suppose you try the Macromedia Forum:

http://www.macromedia.com/support/forums/




You may find links of interest on this page http://multifinanceit.com/it/norway/norway.htm on my site.

Now it is about ASP.NET 2.0 and C# 2.0 as far as I know. There are also some documentation in the Dreamweaver 2004 MX manual about databases. Have you read that?

KBleivik
http://multifinanceit.com/

How are you passing the search variable to the results page?

Try your sql like this on your results page:

SELECT * FROM YOUR_TABLE WHERE TABLE_COLUMN1 LIKE '%YOUR_VARIABLE%' OR TABLE_COLUMN2 LIKE '%YOUR_VARIABLE%'

You can search multiple columns in your table by adding another OR statement the column name and LIKE %variable%