Yeah, that, and the code that writes out the list with customers, so we can see what you pass in the querystring to the details page.

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

I see.

1st there is the list page.

Dim rsSearchResult
Dim rsSearchResult_numRows
Set rsSearchResult = Server.CreateObject("ADODB.Recordset")
rsSearchResult.ActiveConnection = MM_datab_STRING
rsSearchResult.Source =
"SELECT custname, town, description,
FROM seller
WHERE Selection LIKE '%" + Replace(rsList__MMColParam, "'", "''") + "%'
AND cattitle LIKE '%" + Replace(rsList__MMColParam2, "'", "''") + "%'
AND location LIKE '%" + Replace(rsList__MMColParam3, "'", "''") + "%'"
rssearchresult.CursorType = 0
rssearchresult.CursorLocation = 2
rssearchresult.LockType = 1
rssearchresult.Open()
rssearchresult_numRows = 0

Then the detail page

Dim rscustomerdetails
Dim rscustomerdetails_numRows
Set rscustomerdetails = Server.CreateObject("ADODB.Recordset")
rscustomerdetails.ActiveConnection = MM_datab_STRING
rscustomerdetails.Source = "SELECT * FROM seller"
rscustomerdetails.CursorType = 0
rscustomerdetails.CursorLocation = 2
rscustomerdetails.LockType = 1
rscustomerdetails.Open()
rscustomerdetails_numRows = 0

Take a look at this:

rscustomerdetails.Source = "SELECT * FROM seller"


You don't have a WHERE clause to filter the customers recordset to exactly one.... Change the SQL statement so it has a WHERE clause that gets its value from the querystring.....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

I see now. I included the WHERE clause and it worked.

Thank you.