I'm a newbie to ASP and I'm trying to pass a variable from a form to a query. Here's my form page code:



And here's my ASP code:

<%
    Option Explicit
    Dim l_name
    Dim rsCustSurvey
    Dim raction_summary
    Dim Conn
    l_name = Request.QueryString("l_name")
    response.write(l_name)

    set Conn=Server.CreateObject("ADODB.Connection") 'create Server Database Connection Object
    set rsCustSurvey = server.CreateObject("ADODB.Recordset") 'create RecordSet Conn Obj
    set raction_summary =server.CreateObject("ADODB.Recordset") 'number of surveys received


    Conn.open "Driver={SQL Server}; Server=server01;Database=System;UID=u;PWD=p;"

    set rsCustSurvey = conn.Execute ("Select ProblemDescriptionTrunc, Action_Summary, ProblemItem, Problem_Solution002, " _
        & " Problem_Description002, RootCause, LastModifiedBy, dbo.TTS_Main.AssignedGroup, dbo.TTS_Main.Last_Name, dbo.TTS_Main.First_Name, " _
dbo.TTS_Main.AssignedGroup, AssignedTechnician, ModificationHistory "_
        & " From tts_main " _
    & " Where Last_Name LIKE '%l_name%' ")



    if rsCustSurvey.EOF then 'traps for IF recordset is empty THEN:
        Response.Write "There is no data"
        Response.End
    end if


%>

    <%do while not rsCustSurvey.EOF%></do>
    <%response.write rsCustSurvey("Last_Name")%>
    <%rsCustSurvey.MoveNext%>
    <%loop%>


<%
    set rsCustSurvey = nothing
    set conn = nothing
%>

When I hardcode the search string in the query, it returns data as it should, but with the code above, I'm getting no data.

Suggestions?

Thanks!
Dale

Try
HTH,

Chris

Thanks! That worked. I thought I had tried all various incantations of the quotes and ampersands, but evidently not.

Dale