On Tue, May 11, 2004 at 03:01:30PM -0700, Jeff Zucker wrote:
leegold wrote (off list):
So, something like:
$dbh-{csv_sep_char}='###';
would work, you think?
Hi,
First, please respond to the list rather than to an individual. The
individual might be busy :-). Also, if the answer
Howdy group!
perldoc DBI
has this:
$rv = $dbh-do($statement, \%attr, @bind_values);
So would this be a proper use of it:
$dbh-do(
'INSERT INTO Stuff (Id,Foo) VALUES (NULL,?)',
undef,
qw('foo' 'bar' 'baz')
) or die
# IE undef foro \%attr and include quoted data
That would
Tim Bunce wrote:
package AnyData::Format::ThreeSharp;
use base 'AnyData::Format::Base';
sub write_fields { shift; sprintf %s\n,join '###',@_ }
sub read_fields { split '###', $_[1] }
Should probably besplit '###', $_[1], -1
otherwise trailing empty fields will be removed.
Thanks for all the replies! Its much clearer now :)
Just to clear up the qw() issue, I included quotes so that the data
would be quote()ed for the query, not sure if that was necessary or not
since do() didn't do quote()...
IE I was passing 'data' (single quotes as part of the string) and not
no, the @bind_values is a list to bound for that statement. It could 1
or many (i.e. if you have where id = ? and date = ? ). If you have a
list of values that need to be inserted into different rows, then
iterate through the array and execute the 'do'. A word of caution, if
the list is going
JupiterHost.Net [mailto:[EMAIL PROTECTED] wrote:
perldoc DBI
has this:
$rv = $dbh-do($statement, \%attr, @bind_values);
So would this be a proper use of it:
$dbh-do(
'INSERT INTO Stuff (Id,Foo) VALUES (NULL,?)',
undef,
qw('foo' 'bar' 'baz')
) or die
# IE
JupiterHost.Net [mailto:[EMAIL PROTECTED] wrote:
Just to clear up the qw() issue, I included quotes so that the data
would be quote()ed for the query, not sure if that was necessary or not
since do() didn't do quote()...
IE I was passing 'data' (single quotes as part of the string) and
On Wed, 2004-05-12 at 10:48, JupiterHost.Net wrote:
Thanks for all the replies! Its much clearer now :)
Just to clear up the qw() issue, I included quotes so that the data
would be quote()ed for the query, not sure if that was necessary or not
since do() didn't do quote()...
IE I was
- Forwarded message from Raj Chandran [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
X-SPF-Guess: pass (seems reasonable for [EMAIL PROTECTED] to mail through
132.236.56.21)
Subject: Trouble with returning BLOB
From: Raj Chandran [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: 12 May
Someone has written a PL package that I would like to access using
dbi:Oracle. How can I do this?
Richard Freedman
Bioinformatics Scientist
Cytokinetics
(650)624-3027
JupiterHost.Net [mailto:[EMAIL PROTECTED] wrote:
I found do() and quote() in DBI.pm, prepare() in DBD::mysql, but I
couldn't find execute() - I wanted to see how it does the quoting
exactly (for binary data) -
Anyone know where execute() is?
All of these are covered in the DBI
perldoc DBD::Oracle
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Richard Freedman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 12, 2004 2:03 PM
To: [EMAIL PROTECTED]
Subject: PL/SQL
Someone has written a PL package that I would like to
Ronald J Kimball wrote:
JupiterHost.Net [mailto:[EMAIL PROTECTED] wrote:
I found do() and quote() in DBI.pm, prepare() in DBD::mysql, but I
couldn't find execute() - I wanted to see how it does the quoting
exactly (for binary data) -
Anyone know where execute() is?
All of these are covered
13 matches
Mail list logo