What steps will reproduce the problem?
1. Save the following snippetas an html file, alongside gears_init.js
<script type="text/javascript" src="gears_init.js"></script>
<script type="text/javascript">
var db = google.gears.factory.create('beta.database');
db.open('some-never-used-database-name')
db.execute('create table a (b text)')
</script>
2. Open it in safari with gears installed
3. Develop -> Start Debugging Javascript, and type this in the console:
db.execute('insert into a (b) values (?)', ['testing'])
What is the expected output? What do you see instead?
I expected it to work. It works if you write it into the script. However, if
you type it at the
console, it says "Error: Wrong number of SQL parameters." It causes similar
errors when I try to
run it with jsUnit. This is making testing quite difficult.
What version of the product are you using? On what operating system?
0.5.33.0;official;opt;osx;safari
Safari Version 4.0.4 (5531.21.10)
Mac OSX Version 10.5.8
Please provide any additional information below.
This is an issue with substituting for the question marks.
If you instead say this at the console, it works:
db.execute('insert into a (b) values ("testing")')
This is a shame, because this workaround encourages sql injection.
Original issue reported on code.google.com by nickreta...@gmail.com on 20 Jan 2010 at 12:26
Original issue reported on code.google.com by
nickreta...@gmail.comon 20 Jan 2010 at 12:26