problems with RecordSet.GetRows

Results 1 to 2 of 2

Thread: problems with RecordSet.GetRows

  1. #1
    Join Date
    Dec 1969

    Default problems with RecordSet.GetRows

    i&#039;m using a function to return a multi-dimensional array via objRec.GetRows. my problem is that sometimes the recordset is empty, thus killing the script. is there a property of a recordset that i can check before i populate the array?<BR><BR>Function inGoesSqlOutComesQuestionsAndAnswers(sqlStatement) <BR><BR> SQLQuestions = sqlStatement<BR> objRec.Open SQLQuestions, DSNConnectionString<BR> &#039;store the values<BR> arrayOfQuestions = objRec.GetRows<BR> &#039;and close the connection<BR> objRec.Close <BR> <BR> inGoesSqlOutComesQuestionsAndAnswers = arrayOfQuestions<BR><BR><BR>End Function<BR><BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Jeez.....R&D EOF and BOF <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