[Javascript] Re: While statement array losing data

Thu May 17 08:23:07 CDT 2007

Please ignore this post and solution, as better logic was supplied from
Nick in another email.

> 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>
>>
>>
>
>
> _______________________________________________
> Javascript mailing list
> Javascript at LaTech.edu
> https://lists.LaTech.edu/mailman/listinfo/javascript
>