Hi folks,
been to this site http://sqlite-ruby.rubyforge.org/sqlite3/faq.html and
printed off the hints there.
but looking for more... and coming up empty.
I like to be able to get the DB and shoes frontend talking and playing nice
within two weeks (no data validation as I want a prototype 1st).
can someone point me to some other sites (that are ruby not RoR centric)?
search google on various searches like ruby with sqlite3 but mostly it's all
RoR.
also any pointer on bindings (if no one can point me to a website)?
like to know more clearly how to inject (if that the word) a string
dynamically into a SQL select satement
e.g. from the FAQ (think the call it placeholders in an sql statement.
Have had some exposure to RDBMS's in the past but that was some time ago and
ruby /shoes are still newish to me.
what i like to be able to do is something like the #{rubyvar} within a puts
statement where value within rubyvar is displayed but have this inside a
select statement.
Oh can you do this?
stmt = "select * from A_table where table_column = " + rubyvar
db.prepare(stmt)
how much harder would active records be to the DBI interface to get up and
running with?
and any web sites that I could go to for code samples etc relating to sqlite3?
also lastly and this is off topic - sorry but where can one go for a searchable
index of this forums messages?
rgds,
dave.
