HELP Kurt or Someone Start from 1st Record

Results 1 to 2 of 2

Thread: HELP Kurt or Someone Start from 1st Record

  1. #1
    Gonzalo Guest

    Default HELP Kurt or Someone Start from 1st Record

    This is my search.<BR><BR>&#060;%<BR>dim rsBrackets, sql, dMake, dYear, dModel, dBrand1, dStyle1, dNotes1, dProduct1, dPrice<BR>set rsBrackets = Server.CreateObject("ADODB.Recordset")<BR>sql = "SELECT * FROM Brackets WHERE Make=&#039" & Request.QueryString("Make") & "&#039" & " AND Model=&#039" & Request.QueryString("Model") & "&#039"<BR>rsBrackets.Open sql, db<BR>dMake = rsBrackets("Make")<BR>dYear = rsBrackets("Year")<BR>dModel = rsBrackets("Model")<BR>dBrand1 = rsBrackets("Brand1")<BR>dStyle1 = rsBrackets("Style1")<BR>dNotes1 = rsBrackets("Notes1")<BR>dProduct1 = rsBrackets("Product1")<BR>dPrice1 = rsBrackets("Price1")<BR><BR>rsBrackets.Close<BR>%& #062; <BR><BR>What do I need to do to make sure the search always starts from the first record?<BR><BR>Gonzalo - Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: HELP Kurt or Someone Start from 1st Record

    DEAR FRIENDS<BR><BR>CHECK YOUR RECORDSET DOES CONTAIN ANY RECORDS BY THE<BR>FOLLOWING WAY.<BR>&#060;%<BR>IF not rsBrackets.eof then<BR>rsbrackets.movefirst<BR>-----<BR>-----<BR>-<BR>-<BR>end if%&#062;<BR><BR>Hope I calarifed your doubt.<BR><BR>from<BR>venkatesh( m)

Posting Permissions

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