Re: Passing an array to DBI statement execute


#1

table. Here is my script:
values = [id]
values.concat line.chomp.split("\t")
(10…12).each {|x| values[x] = Time.parse(values[x])
unless values[x].nil? || values[x].strip == “”}
sth.execute(values)

sth.execute(*values)

You need to flatten the list here. Otherwise, you’re just passing a
single array.

Regards,

Dan

This communication is the property of Qwest and may contain confidential
or
privileged information. Unauthorized use of this communication is
strictly
prohibited and may be unlawful. If you have received this communication
in error, please immediately notify the sender by reply e-mail and
destroy
all copies of the communication and any attachments.


#2

that’s it, thanks


#3

Ok, well, now it executes and seems like it is working, except nothing
ends
up in my database. Any ideas? Is there any way to print out what sql
statement it is trying to execute? I can’t find any API docs for DBI.

Also, is DBI smart enough to figure out how to convert the Time objects
into
the correct format for the database?