On Mar 10, 3:56 pm, Mark Murphy <[email protected]> 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?
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).
If so, while it sucks, I can't really file this as a bug because it
will be considered according to spec.
Nathan
--
You received this message because you are subscribed to the Google
Groups "Android Developers" 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-developers?hl=en
