168 IC_FILENAME, IC_SKIN_ID, IC_APP_ID, \ |
168 IC_FILENAME, IC_SKIN_ID, IC_APP_ID, \ |
169 GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION FROM CA_ENTRY " ); |
169 GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION FROM CA_ENTRY " ); |
170 |
170 |
171 _LIT( KSQLGetListByParentId2, "LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID LEFT JOIN CA_GROUP_ENTRY ON \ |
171 _LIT( KSQLGetListByParentId2, "LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID LEFT JOIN CA_GROUP_ENTRY ON \ |
172 GE_ENTRY_ID = ENTRY_ID WHERE GE_GROUP_ID = :GE_GROUP_ID %S " ); |
172 GE_ENTRY_ID = ENTRY_ID WHERE GE_GROUP_ID = :GE_GROUP_ID %S " ); |
|
173 |
|
174 _LIT( KSQLGetListByChildId, "LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID LEFT JOIN CA_GROUP_ENTRY ON \ |
|
175 GE_GROUP_ID = ENTRY_ID WHERE GE_ENTRY_ID = :GE_ENTRY_ID %S " ); |
173 |
176 |
174 //Get all attributes by entry id |
177 //Get all attributes by entry id |
175 //:Entry_Id_List is a list of Integers seperated by commas. |
178 //:Entry_Id_List is a list of Integers seperated by commas. |
176 _LIT( KSQLGetAttributesByEntryId, "SELECT \ |
179 _LIT( KSQLGetAttributesByEntryId, "SELECT \ |
177 ATTRIBUTE_ID, AT_ENTRY_ID, AT_NAME, AT_VALUE FROM CA_ATTRIBUTE \ |
180 ATTRIBUTE_ID, AT_ENTRY_ID, AT_NAME, AT_VALUE FROM CA_ATTRIBUTE \ |