Hello, I'm new to the list and am experiencing an issue that I hope some
of you all have dealt with previous and can lend me some advise on.. or
supply a possible fix.
Perl 5.6.1 with DBI module 1.32 operating on AIX 4.3. I'm attempting to
query an Oracle 9.0.1.0.0 database through the perl in
Hi,
I've elimminated the columns which contains commas, bu noe I'm recieving
this error:
inserting into mysql single element from an array
what does that mean?
Xaver Biton
Hi,
If he is a old time programmer, he might want to look at this:
http://dev.mysql.com/doc/mysql/en/HANDLER.html
Which is very cool and solves some problems that are just really ugly with
plain SQL.
Thanks,
Eric
At 10:10 AM 9/1/2004, you wrote:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote:
>
> Hello,
>
> I need the last entry of a table.
>
> This code interates through a list but how can I get the last
> element ?
How do you define the last entry? Is it the one with the highest/lowest
value in a certain column? The one that w
Is there a MAX() in MySQL?
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 01, 2004 11:06 AM
To: [EMAIL PROTECTED]
Subject: Last entry of a table
Hello,
I need the last entry of
Hello,
I need the last entry of a table.
This code interates through a list but how can I get the last
element ?
my $dbh = DBI->connect("dbi:mysql:$DB", $USER, $PASS) || print
"MySQL: can't connect to database.";
my $sth = $dbh-> prepare("SELECT message_id FROM $mail_folder_dbi");
$sth -
Are you sure you don't have any spaces after EOF? Also, if it
is just bugging out on you, you could rewrite as:my $sql = INSERT
INTO .. (...,...,...) VALUES(?,?,?,...);foreach my $values (@array){
$dbh->do($sql,undef,@$values);}Also, don't know if this is your actual
code, but it is a
I would, especially if you are starting from scratch. DBD::SQLite-1.04
is using SQLite 3.0, which has more features as stated below.
On Tue, 2004-08-31 at 23:49, Owen wrote:
> On Sat, 17 Jul 2004 10:51:55 +0100, Matt Sergeant wrote:
>
> > Anyone who has read my journal will know that I now have
Hi,
there's the possibility to change the field separator in "values", so I
could add a # instead, e.g.
push @{ $array[1] }, $qualification ."#";
mybe is a stupid supposition, I don't know how can i test this.
Xaver Biton
Ondrej Koala Vacha wrote:
On Wed, 1 Sep 2004, xaver biton wrote:
Hi,
I've an Array like this:
@array( ["Xaver", "Biton", "myStrasse", "1", "0725120155"],
["Xx", "Xy", "deineStrasse", "2", ],
["Robert", "sky", "seineStrasse", "2","04035210", "04035211","[EMAIL PROTECTED]" ],
...
)
foreach my $val
On Wed, 1 Sep 2004, xaver biton wrote:
> Hi,
>
> I've an Array like this:
>
> @array( ["Xaver", "Biton", "myStrasse", "1", "0725120155"],
> ["Xx", "Xy", "deineStrasse", "2", ],
> ["Robert", "sky", "seineStrasse", "2","04035210", "04035211","[EMAIL PROTECTED]" ],
> ...
> )
>
>
foreach my $values (
Hi,
I've an Array like this:
@array( ["Xaver", "Biton", "myStrasse", "1", "0725120155"],
["Xx", "Xy", "deineStrasse", "2", ],
["Robert", "sky", "seineStrasse", "2","04035210", "04035211","[EMAIL PROTECTED]" ],
...
)
I want to insert these values in a mysql DB like:
foreach my $values (@array) {
On Sat, 17 Jul 2004 10:51:55 +0100, Matt Sergeant wrote:
> Anyone who has read my journal will know that I now have DBD::SQLite
> ported to SQLite 3.0, which provides better datatypes, better concurrency,
> proper blob support, etc.
>
> Now the big problem is that sqlite 3.0 is incompatible with
13 matches
Mail list logo
