Servoy Forum

by **akalehzan** » Fri Oct 28, 2005 7:14 pm

Hi all,

Im testing Servoy Developer Version 3.0a9-build 357
Java version 1.5.0_04-b05 (Windows XP)

I have a method with the following content:
var household_id = "id_to_persons_in_household.household_id"

if (household_id != null)
{

var household_id = "id_to_persons_in_household.household_id"
var query5 = "select Subj_num, household_id, cast (date_info_acquired as char(12)) from persons_in_household where household_id = " + id_to_persons_in_household.household_id + "";
var dataset = databaseManager.getDataSetByQuery(controller.getServerName(), query5, null, 999999999);
var col_count = 0;

globals.txt90 = '<html><table border="1" bgcolor="00FFFF"style="color:black" style="font-size:100% row 1, cell"><tr>' // starts the html string

for ( var i = 1 ; i <= dataset.getMaxRowIndex() ; i++ )
{
dataset.rowIndex = i;
globals.txt90 += '<td>' + dataset[1] + ' '+dataset[2]+ ' '+dataset[3]+ ' '+dataset[4]+ ' '+dataset[5]+ ' '+dataset[6]+ ' '+dataset[7]+ ' '+dataset[8] + ' '+dataset[9]+ ' '+dataset[10] + ' '+dataset[11] + ' '+dataset[12]+ ' '+dataset[13]+' '+dataset[14] + ' '+dataset[15]+ ' '+dataset[16] + ' '+dataset[17]+'</td>'; // displays field_one,field_two, three, four, and five
if (++col_count == 12)// max 12 values for each row of data
{
globals.txt90 += '</tr><tr>';
col_count = 0;// new row of data
}

}
globals.txt90 += '</tr></table></html>' // closes the html string

}

///////////////////////
When I call the above method in the Servoy Webclient "http://localhost:8080/servoy-webclient" I see the following in the servoy form:

<html><table border="1" bgcolor="00FFFF"style="color:black" style="font-size:100% row 1, cell"><tr><td>3131 63 May 23 1999 </td><td>3132 63 May 23 1999 </td><td>3133 63 May 23 1999 </td><td>3135 63 May 23 1999 </td></tr></table></html>

///////////////////////////////
However, if I call the method in the Servoy developer I see the following:

May 23 1999 3132 63
May 23 1999 3133 63
May 23 1999 3135 63

/////////////////////

I was wondering if anyone having the same problem that Im having.

Please let me know.

Thanks in advance,

Abrahim

Servoy Forum

Viewing html in the Servoy Version 3.0a9-build 357 Web clien

Viewing html in the Servoy Version 3.0a9-build 357 Web clien

Who is online