Missing operator problem

[mazdaman]

I have the following error...................
Syntax error (missing operator) in query expression 'name =
Generated by the following code .............
sec_row = sec_row & "<td align=left valign=top ><a class=greendata href='detail.asp?name=" & abc("name") & "'>" & abc("name") & " </a></td>"

The detail.asp looks like this ........
<%
Dim rs_detail
Dim rs_detail_numRows

Set rs_detail = Server.CreateObject("ADODB.Recordset")
rs_detail.ActiveConnection = MM_igd_STRING
rs_detail.Source = "SELECT * FROM plants WHERE name = " + Replace(rs_detail__abc, "'", "''") + ""
'rs_detail.Source = "SELECT * FROM plants WHERE name = " & Request("name")
rs_detail.CursorType = 0
rs_detail.CursorLocation = 2
rs_detail.LockType = 1
rs_detail.Open()

rs_detail_numRows = 0
%>

I basically want to carry the record for 'name' over to the detail.asp page to view all the details of 'name'

Can anybody help .. thanks you

 

[vbkris]

rs_detail.Source = "SELECT * FROM plants WHERE name = '" + Replace(rs_detail__abc, "'", "''") + "'"


Known is handfull, Unknown is worldfull

 

[vbkris]

rs_detail.Source = "SELECT * FROM plants WHERE name = '" + Replace(rs_detail__abc, "'", "''") + "'"


Known is handfull, Unknown is worldfull

 

[mazdaman]

Im off to buy some specs .. cheers works fine.

If anything is worth doing, its worth over doing !