Do not eof???

Results 1 to 3 of 3

Thread: Do not eof???

  1. #1
    Join Date
    Dec 1969

    Default Do not eof???

    I need to display all information based on a condition. I have a business id and need to display all account numbers for a user to pick from in a drop down box. I assume I would use a select statement and some type of loop? My sql would be <BR><BR>"Select * "<BR>"from ..."<BR>"where account.business_id = " & session("business_id")<BR><BR>Then I cannot find a example of how to display all of the account numbers on a add screen. Can someone give me some direction?? Thanks alot!!!

  2. #2
    Join Date
    Dec 1969

    Default RE: Do not eof???

    After executing the sql:<BR>&#060;% if not rsobj.eof then &#039; rsobj is the recordset object<BR>%&#062;<BR>&#060;select name="account_info" size="3"&#062;<BR>&#060;% do while not rsobj.eof %&#062;<BR>&#060;option&#062;&#060;%=rsobj("accoun tfieldname")%&#062;<BR>&#060;% rsobj.movenext<BR> loop<BR>end if<BR>%&#062;

  3. #3
    Join Date
    Dec 1969

    Default FAQ's top o' the page <eop>


Posting Permissions

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