Oracle and SQL Count

Results 1 to 2 of 2

Thread: Oracle and SQL Count

  1. #1
    Join Date
    Dec 1969

    Default Oracle and SQL Count

    I have successfully created SQL code that counts the number of rows in a table in my Oracle database but I do not know how to return the amount to my ASP page. How do I do this?

  2. #2
    Join Date
    Dec 1969

    Default RE: Oracle and SQL Count

    Assuming you&#039re doing a count in the SQL query like this:<BR><BR>sql = "SELECT count(*) FROM TABLE"<BR>rs.Open sql,ConnObject blah blah<BR><BR>response.write rs.Fields(0).value will return the count.

Posting Permissions

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