From: unbewusst.sein@... (=?ISO-8859-1?Q?Une_B=E9v?= =?ISO-8859-1?Q?ue?=)
Date: 2007-10-12T06:15:05+09:00
Subject: Re: SQLite and ruby

Une B�vue <unbewusst.sein@weltanschauung.com.invalid> wrote:

> 
> i now how to capitalize with ruby but i've never use ruby with SQLite.

After installing sqlite3-ruby by gem i'm trying :

#! /usr/bin/env ruby

require 'sqlite3'

db = SQLite3::Database.new( "backpb.db" )
db.execute( "select distinct UID, lastName, firstName, fullLastName from
devicephonebook" ) do | row |
  p row
  db.execute( "UPDATE devicephonebook SET lastName =
'#{row[1].capitalize}', firstName = '#{row[2].capitalize}', fullLastName
= '#{row[1].capitalize}#{row[2].capitalize}' WHERE UID = #{row[0]}")
end


where i get the following error :

SQLite3::SQLException: no such function: get_zy_string
method check
in errors.rb at line 94
method initialize
in statement.rb at line 71
method new
in database.rb at line 184
method prepare
in database.rb at line 184
method execute
in database.rb at line 211
at top level
in test.rb at line 8
method execute
in database.rb at line 214
method each
in resultset.rb at line 162
method execute
in database.rb at line 214
method prepare
in database.rb at line 187
method execute
in database.rb at line 211
at top level
in test.rb at line 6
Program exited.


line 6 being db.execute( "select distinct UID, ...")
line 8 being db.execute( "UPDATE devicephonebook SET ...")
-- 
Une B�vue