[EMAIL PROTECTED] wrote: > Hi everyone, > > I met an issue when I tried to execute the select statement with the > limit cause. I appended the offset value to the limit cause as the > parameter for the SQLiteDatabase.query(), just as "10 offset 0", but > it threw an exception on running time. I traced the source code, and > found that Android appends a character '\'' at the beginning and end > of the cause, so that the whole select statement becomes "select ..... > from table where ... limit '10 offset 0';". This caused sqlite to > return the error "SQL error: datatype mismatch". > > My question is whether Android supports the offset option for limit > cause? And how to deal this case in Android?
Try rawQuery() rather than query(). -- Mark Murphy (a Commons Guy) http://commonsware.com _The Busy Coder's Guide to Android Development_ Version 1.4 Published! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Beginners" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/android-beginners?hl=en -~----------~----~----~----~------~----~------~--~---
