SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: search and display

  1. #1
    SitePoint Member
    Join Date
    May 2001
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    search and display

    hi all. i have this script where i search the dbase based on the date given thru a form.....but it keeps hanging up on me..any thoughts? Thanks!

    <% Option Explicit %>
    <!- - #include file="adovbs.inc" - ->
    <% On Error Resume Next %>


    <%
    Dim connect, Search
    set connect = server.createobject("ADODB.Connection")
    Set Search = server.createobject("ADODB.Recordset")
    connect.open "Guestbook"
    Search.Open "SELECT * FROM entries WHERE Used = True AND Datein='" & request.form("Date_search") & "'"
    do until Search.EOF
    %>

    <HTML>
    <HEAD>
    <TITLE>Submission Successful</TITLE>
    <LINK REL="StyleSheet" HREF="/stylesheet1.css" TYPE="text/css">
    </HEAD>
    <BODY>

    <p>
    <%=Search("ID")%><br>
    </P>
    <% Search.MoveNext
    loop %>


    </BODY>
    </HTML>

  2. #2
    Xbox why have you forsaken me? moospot's Avatar
    Join Date
    Feb 2001
    Location
    Clearwater, FL
    Posts
    3,614
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've had a problem using 'True' with our SQL Server database. I had to use '-1' instead. Strange.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •