[flexcoders] AIR - SQL lite Question

[Robin Burrer]

Hi there,

I get a strange error in one of my sql queries.
Here is the code:

sqlQuery += "SELECT DISTINCT tLibs.libID, tLibs.libName FROM tLibs";
                                                
			sqlQuery += " LEFT JOIN tFilecards ON tLibs.libID=tFilecards.libID  
WHERE";
                        
			sqlQuery += " tLibs.userID="+selectedUserId+" AND  
tFilecards.question LIKE '%"+ mySearchString +"%' OR";
                        
			sqlQuery += " tLibs.userID="+selectedUserId+" AND tFilecards.answer  
LIKE '%"+ mySearchString +"%'";

mySqlStatement.itemClass = LibVO;

and I get the following error:

ReferenceError: Error #1056: Cannot create property tLibs_libID on  
de.brainStar.vo.LibVO.


Where does the "_" come from? The property is called libID in my value  
object.


the strange thing is that everything works fine when I get rid of the  
"DISTINCT".

But I obviously need the "DISTINCT" though.

Please help this is killing me :-(


Cheers


Robin