Thanks Satoshi :) one answered one to go...
On Sunday 07 June 2009 11:00:17 pm Satoshi Asakawa wrote: > Hi Dave, > > > where can one go for a searchable index of this > > forums messages? > > http://www.mail-archive.com/[email protected]/ > > Hope it helps. :) > ashbb > > On Sun, Jun 7, 2009 at 7:51 PM, dave <[email protected]> wrote: > > 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.
