You guys hate me yet????
ANyways, after succesfully setting up my queries etc.(with a HUGE help from you guys), I now need to dump it into textbox. I have no idea how to do it. I konw how to display it by Response.write and building table on the fly but dont know how to output it to a texbox.

Here is what i have:

<%
 Set rs = SERVER.CreateObject("ADODB.Recordset")

     strST=Request.QueryString("open")
     strSQL = "SELECT * FROM ticket WHERE PSAP = '" & strST & "'"

    ' Open Recordset Object
    rs.Open strSQL,conn,adOpenStatic


%>

<p>PSAP NAME:<input type="text" name="PSAP" size="50" value="<% rs("PSAP") %>">

nevermind, I got it

PSAP NAME:<input type="text" name="PSAP" size="50" value="<%= rs.fields("PSAP") %>"></p>

but the page does not display it...when I view source I can see there, meaning value changes to the selected item but it is invisible.???


HEEELPP

yes, I suck....but any help is appriciated

Do you see the actual text in the source, but not in the browser? Strange.
The only cause that I can think of is that rs.fields("PSAP") (or rs.fields("PSAP").Value, actually), contains a double quote. You can use Server.HTMLEncode to encode your HTML:

<input type="text" name="PSAP" size="50" value="<%=Server.HTMLEncode(rs.Fields("PSAP").Valu e %>">

If I were you, I'd get a book on this subject. Beginning Dreamweaver MX 2004 deals a lot with these kind of ASP issues. Also, Beginning ASP 3 is a good book.

Did you sort out the other issues?

Cheers,

Imar


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

Hey Imar,
 Reason why it wasnt displaying it was because my text box wasnt in the <FORM<. As soon as I wrapped it in form tags I could see it fine. Thank you once again.
I also managed to work out the other issues. I OWE A HAINEKEN. CHEERS :)

Ha, Cheers, mate.... ;)


Imar

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