Strange row id!

Suite and Optimus Suite 5
#1

I’ve used a query like this to popolate a grid.

SELECT  * FROM table WHERE  columname = 'string';

This is the result:

<?xml version='1.0' encoding='iso-8859-1' ?><rows><row id='1308237168x0'><cell><![CDATA[C]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[D]]></cell></row><row id='1308237168x1'><cell><![CDATA[M]]></cell><cell><![CDATA[R20101]]></cell><cell><![CDATA[A]]></cell></row></rows>

The real id of the row are different! Why does it happens?

#2

Please… answer me!

#3

in render_sql command you have specified invalid id name ( second parameter ), if id is invalid or empty - connector will generated random IDs for records.

#4

In mysql the field name are case insensitive. Why your framework are case sensitive?

#5

I’m not sure what do you mean by “case-sensitive”
Normally, php code will translate field names to sql query, and if they are valid - query will be executed successfully.

Anyway, it is a good practice to use correct field names, and don’t relay on automatic case resolving.