[Javascript] Re: While statement array losing data

Thu May 17 08:15:22 CDT 2007

I finally found my problem.  Apparently if an array item is populated with
a numeric value, the value gets lost after leaving the While loop.  A
string is preserved.  I changed the code to change the integer to a
string:
sLineIn[iResultCount] = sTransCount+"";
It works now.

> This list is great!  I come from a VB background, and learning JS.  I have
> a routine in which I load data through DAO into an array.  My problem is
> that as soon as the program leaves my While statement, the data in the
> array disappears.  I have studied and studied my code, but I cannot find a
> reason.  I am very thankful for any help on this.
>
> Tim
> My code is:
> <html><head>
> <script language="JavaScript">
> <!--
> function Main() {
> var sDB="C:\\Temp\\LOGDB.MDB";
> var objConnection = new ActiveXObject("DAO.DBEngine.36");
> var objRecordSet = objConnection.workspaces(0).OpenDatabase(sDB);
> var iResultCount=0;iCount=0;
> var sLineIn = new Array();
> var sTransCount="";
> var SEARCHRESULT;
> sSearchCommand = "SELECT * FROM HL7_Segments WHERE SegmentLineData LIKE
> '*MSH*'";
> SEARCHRESULT = objRecordSet.OpenRecordset(sSearchCommand)
> SEARCHRESULT.MoveFirst();
> while (! SEARCHRESULT.EOF) {
>         sTransCount = SEARCHRESULT("TransactionCount");
>         sLineIn[iResultCount] = sTransCount;
>         var msg=confirm("iResultLine for "+iResultCount+" is
> "+sLineIn[iResultCount]); if (msg==false) {return;};
>         iResultCount++;
>         SEARCHRESULT.MoveNext(); }
> for (var iCount=0;iCount<iResultCount;iCount++) {
> var msg=confirm("Final iResultLine for "+iCount+" is "+sLineIn[iCount]);
> if (msg==false) {return;}; }
> objRecordSet.Close;
> objRecordSet = Nothing;
> objConnection = Nothing;
> }
> -->
> </script>
> </head><body><form>
> <input type="button" value="Click me!" onclick="Main()">
> </form></body></html>
>
>