You can't do this with REALSQLDatabase.
You need SQLite3ProfessionalPlugin to do this:
http://www.sqlabs.net/sqlite3professional.php
For example with SQLite3ProfessionalPlugin:
...
vm = db3.Prepare( "select a,b,c where d = ? and e = ?" )
vm.BindText(1, "first string")
vm.BindText(2, "second string")
...
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
On Apr 15, 2006, at 6:40 PM, Jan Erik Moström wrote:
I don't know if I'm blind or ...
I'm using REALSQLDatabase and I want to have a "pre-compiled"
question where
I enter the search strings. Something like this
preCompQuestion = myDB.precompile( "select a,b,c where d = ? and e
= ?" )
result = preCompQuestion( "first string", "second string" )
But I can't figure out how to do it.
What I really want to do is to avoid to build the search question but
concatenating strings (to avoid security/syntax problems), should I
do it
some other way?
jem
--
Jan Erik Moström, www.mostrom.pp.se
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
