Displaying Query Results ....

Results 1 to 2 of 2

Thread: Displaying Query Results ....

  1. #1
    Join Date
    Dec 1969

    Default Displaying Query Results ....

    I have a simple query set up to return some results from a SQL DB. The query works fine. However, I am unsure as to how to present to results (preferably neatly) on the same page. The code of the query is below. Thanks for your help, much appreciated, Pamm ...<BR><BR>q = "SELECT*FROM tblCustomers WHERE Cust_Location = &#039;"¶mDest&"&#039; AND Cust_Num_People = &#039;"paramNum&"&#039;"<BR> objRS.Open q, "DSN=OONSQL;"<BR> <BR> if NOT objRS.EOF then<BR> while NOT objRS.EOF<BR> Response.Write objRS("Cust_Location")& " " & objRS("Cust_Name")& " " & objRS("Cust_Num_People") & "<BR>"<BR> objRS.MoveNext<BR> wend<BR> end if<BR>

  2. #2
    Join Date
    Dec 1969

    Default Another ***CROSSPOST***

    Please don&#039;t crosspost. Answered in main forum.<BR><BR>

Posting Permissions

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