Nathan wrote:
> On Mar 10, 3:56 pm, Mark Murphy <mmur...@commonsware.com> wrote:
>> Create a project that demonstrates the problem, open an issue
>> onhttp://b.android.com, and shoot me the issue number when you've done that.
>>
>
> OK. First, though, is there a way to capture what SQL is actually
> being sent to the database?
I'm not aware of any. I'm not even sure it's Android that is doing the ?
replacement -- the Ruby SQLite library has the same feature, so it might
be handled by SQLite itself.
> And what does 'bound as strings' mean in this:
>
> 'You may include ?s in where clause in the query, which will be
> replaced by the values from selectionArgs. The values will be bound as
> Strings.'
>
> At first glance, I think, well, of course they are bound as strings
> because they are strings.
>
> But if I run this code.
>
> String[] selectionArgs = {"30.0","50.0"}
>
> Cursor cursor = bdb.getDb().rawQuery("SELECT X,Y FROM BOXTABLE
> WHERE
> X < ? AND Y > ?", selectionArgs);
>
> Will the resultant SQL be the equivalent of "SELECT X,Y FROM BOXTABLE
> WHERE X < '30.0' AND Y > '50.0' " ? (notice the single quotes).
Not that I am aware of. Certainly, it does integer equality correctly
(otherwise all our _ID columns wouldn't work), but I haven't tried > or <.
--
Mark Murphy (a Commons Guy)
http://commonsware.com | http://twitter.com/commonsguy
_The Busy Coder's Guide to *Advanced* Android Development_
Version 1.3 Available!
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
