Connecting Tech Pros Worldwide Help | Site Map

search DB and display results in DIV

Member
 
Join Date: Dec 2006
Posts: 37
#1: Dec 27 '07
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
Expand|Select|Wrap|Line Numbers
  1.         strconnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & Server.MapPath("shopping.mdb"))
  2.         strconnection.Open()
  3.         'after creating strings where clause will look up what values the strings holds
  4.         sql = "SELECT * FROM Customer_details WHERE Email = @Email"
  5.  
  6.  
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
Member
 
Join Date: Dec 2006
Posts: 37
#2: Dec 28 '07

re: search DB and display results in DIV


can anyone help?

i really need help
idsanjeev's Avatar
Familiar Sight
 
Join Date: Oct 2007
Location:
Posts: 241
#3: Dec 29 '07

re: search DB and display results in DIV


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("email") & ""
If Not R.EOF Then
Match = strComp(R("email"), Request.Form("email"))
If Match = 0 Then
vemail = Request.Form("email")
%>
Member
 
Join Date: Dec 2006
Posts: 37
#4: Dec 29 '07

re: search DB and display results in DIV


ok...i kinda understand what your doing on that code, but that woudnt really allow me to print within a html div tag
idsanjeev's Avatar
Familiar Sight
 
Join Date: Oct 2007
Location:
Posts: 241
#5: Dec 31 '07

re: search DB and display results in DIV


Hi
If i am wrong send your code. I think problem to print in div tag
Expand|Select|Wrap|Line Numbers
  1. <div style="position:absolute; left:; top:; z-index:0">
  2. <%Response.write R("value")%>
  3. </div>
  4.  
Member
 
Join Date: Dec 2006
Posts: 37
#6: Jan 2 '08

re: search DB and display results in DIV


Quote:

Originally Posted by idsanjeev

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

Expand|Select|Wrap|Line Numbers
  1. <div style="position:absolute; left:; top:; z-index:0">
  2. <%Response.write R("value")%>
  3. </div>
  4.  


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.write R("value")%>
Reply