search DB and display results in DIV

[848lu]

hi, i am trying to do a search with my ASP webpage, and then display the results in a DIV tag of HTML, how would i do that, thanks

        strconnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & Server.MapPath("shopping.mdb"))
        strconnection.Open()
        'after creating strings where clause will look up what values the strings holds
        sql = "SELECT * FROM Customer_details WHERE Email = @Email"
 
 

i am using Access Database, i also have a FULL HTML webpage built in each ASP code, so when i link the pages up, everything is the same, but i am trying to print the results either on a new page with a list in a DIV tag or the same page in a DIV tag.


thanks

[848lu]

can anyone help?

i really need help

[idsanjeev]

hi lu
pleas show error code
i think you wants to prints all fields where email is match but how can you gett email for search in where clouse
if email feild input through form then try this and print on next page call email field in where clouse
<%
If Not IsEmpty(Request .form("Submit") ) Then
R.MoveFirst
R.Find "email = " & Request.Form("e mail") & ""
If Not R.EOF Then
Match = strComp(R("emai l"), Request.Form("e mail"))
If Match = 0 Then
vemail = Request.Form("e mail")
%>

[848lu]

ok...i kinda understand what your doing on that code, but that woudnt really allow me to print within a html div tag

[idsanjeev]

Hi
If i am wrong send your code. I think problem to print in div tag

<div style="position:absolute; left:; top:; z-index:0">
<%Response.write R("value")%>
</div>
 

[848lu]

Hi
If i am wrong send your code. I think problem to print in div tag

<div style="position:absolute; left:; top:; z-index:0">
<%Response.write R("value")%>
</div>
 

ohhh i see what your doing there, i done it like this
<div>
saksaklfj
</div>


you know you have "value", do i put my SQL in there query in there?
<%Response.writ e R("value")%>