h-bind_columns(\$MaxWSpd, \$WindDir);
while ($sth-fetch) {
print("Found result row: $MaxWSpd, $WindDir \n");
}
$sth-finish();
$dbh-disconnect();
-8-
Same as yours.
Ouput:
-----8-
Found result row: -1, -3
-8-
Cheers
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
[Mailed to individual and to list]
Paul
I have a set of Perl+MySQL tutorials at http://savage.net.au/Perl-tutorials.html
In particular, look at # 24 and # 25.
Cheers
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
= commitTest($dbh);
print $DBI-errstr, \n if ($rc 0);
Test($rc == 0);
And sub commitTest returns 1 at line 134 when it works.
I take it line 49 is wrong?
--
Ron Savage, [EMAIL PROTECTED] on 13/12/2002
Deakin University, 221 Burwood Highway, Burwood, VIC 3125, Australia
Phone: +61-3-9251 7441, Fax
finish
resetting attributes
disconnecting
disconnected
ok
I assume this rollback error is due to me using MySQL 3.23.51, and is
thus expected and harmless. Correct?
--
Ron Savage, [EMAIL PROTECTED] on 13/12/2002
Deakin University, 221 Burwood Highway, Burwood, VIC 3125, Australia
Phone: +61-3-9251
-max]Table 'perl_dbd_test' already
exists (SQL-HY000)(DBD: Execute immediate failed err=-1) at
t/ODBCTEST.pm line 96.
not ok 3
I assume this error is simply due to previous test(s) not deleting
the table at the end of the test, and is therefore harmless. Right?
--
Ron Savage, [EMAIL PROTECTED] on 13
, although I suppose
anything's possible. I assume it is due to the version of MySQL I'm
using.
Any ideas?
--
Ron Savage, [EMAIL PROTECTED] on 13/12/2002
Deakin University, 221 Burwood Highway, Burwood, VIC 3125, Australia
Phone: +61-3-9251 7441, Fax: +61-3-9251 7604
http://www.deakin.edu.au/~rons
On Mon, 16 Dec 2002 16:15:29 -0500, Kevin Diffily wrote:
Hi Kevin
I am a newbie to Perl on Windows. I have tried to do the ppm method
Just for the record, installation help is here:
http://savage.net.au/Perl-modules.html
--
Ron Savage, [EMAIL PROTECTED] on 17/12/2002
Deakin University, 221
On Mon, 16 Dec 2002 21:30:46 -0600, Moritz von Schweinitz wrote:
hi there (again)
Hi Moritz
i was just wondering whether there's any ppm of dbd-mysql flying
around
for perl 5.8 somewhere for the rest of us stuck on win32 machines
Try:
http://theoryx5.uwinnipeg.ca/ppmpackages/
--
Ron Savage
col_a, col_b from `Nathan Bailey`
I get:
Describe failed during DBI::st=HASH(0x1c9f0b8)-FETCH(ParamValues)
This problem does not arise with other 'funny' table names, eg:
`Display_ISDT_210__Digital` (note the ).
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 03/01/2003
http://savage.net.au/index.html
On Thu, 2 Jan 2003 21:13:27 -0800 (PST), Michael A Chase wrote:
Hi Michael
Just reply to the list, thanx.
On Fri, 3 Jan 2003 15:36:11 +1100 Ron Savage [EMAIL PROTECTED]
wrote:
In this, admittedly unusual, situation the above occurs:
OS: Win2K
Perl: V 5.8.0
DBI: V 1.32
ODBC: 1.01
DSN: Points
the output of $dbh - quote_identifier('X Y') you'll see
DBI has added backticks.
So, no progress I'm afraid.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 03/01/2003
http://savage.net.au/index.html
subscribed to the list, so please don't send me copies of your
posts
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 04/01/2003
http://savage.net.au/index.html
();
but of course it makes no difference in this context.
Either way, I'm convinced this is a red herring regarding the problem
I'm having with spaces in table names.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 04/01/2003
http://savage.net.au/index.html
What are the ODBC and Postgres equivalents to the MySQL command 'show
databases'?
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 06/01/2003
http://savage.net.au/index.html
on ODBC. I've roamed
around MS's site (watch wrap):
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/
htm/odbcsqltables.asp but that does not really tell me what I need to
know.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 06/01/2003
http://savage.net.au/index.html
= create $table_name (t_id int);
print SQL: $sql. \n;
# The following fails, but displays the SQL
# insert into $table_name (t_id) values (?).
# The DBI docs explicitly state (allege!) that
# ShowErrorStatement applies to do().
$dbh - do($sql);
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 07/01/2003
http
:
# tab = 4 spaces || die.
#
# Author:
# Ron Savage [EMAIL PROTECTED]
# http://savage.net.au/index.html
use strict;
use warnings;
use DBI;
use Error qw/:try/;
# ---
sub test
{
my($driver, $dbh, $input_file_name, $column_type
.
Blob file size: 16249 bytes. Expect: 16249.
Blob ram size: 16249 bytes. Expect: 16249.
Blob db size: 16197 bytes. Expect: 16249.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 20/01/2003
http://savage.net.au/index.html
if any db
server other than mysql accepts a null db.
Tested code:
-8-
#!/usr/bin/perl
#
# Name:
# connect2nulldb.pl.
#
# Purpose:
# Try connecting to a null db name.
#
# Note:
# tab = 4 spaces || die.
#
# Author:
# Ron Savage [EMAIL PROTECTED]
# http
redesigning it, in my head, to support both MySQL and
Postgres, and perhaps ODBC, so I am definitely interested in hearing
more about your project.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 21/01/2003
http://savage.net.au/index.html
is fake. Which
is it :-)?
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 28/01/2003
http://savage.net.au/index.html
On Sun, 2 Feb 2003 11:52:49 -0500, Jeff Urlwin wrote:
Hi Jeff
based upon the connection. Use $dbh-get_info(17) to get the
database
name.
Are there any on-line docs for these get_info parameters?
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 03/02/2003
http://savage.net.au/index.html
On Mon, 3 Feb 2003 09:18:51 +, Tim Bunce wrote:
See also http://search.cpan.org/src/TIMB/DBI-
1.32/lib/DBI/Const/GetInfo/ODBC.pm
:-O!
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 04/02/2003
http://savage.net.au/index.html
On Tue, 18 Feb 2003 17:57:12 -0500, Manisha Gupta wrote:
Hello
Hi Manisha
I see you've been given 3 answers. I suggest reading DBI.html.
The data you want is clearly documented in DBI.html (generate this
from DBI.pm), under the heading 'Statement Handle Attributes'
--
Cheers
Ron Savage, [EMAIL
Folks
Is there a Postgres DBI/DBD::Pg call which will retrieve the column
attributes the way show columns from $table does under MySQL?
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 19/02/2003
http://savage.net.au/index.html
Folks
Is there a DBI/DBD::mysql call which will retrieve the table type (ie
one of MyISAM/ISAM/Heap/...)?
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 19/02/2003
http://savage.net.au/index.html
with works accidently. If you think those 2
pieces of advice are really in conflict, I suggest you need to think
things though.
4)TMTOWTDI
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 20/02/2003
http://savage.net.au/index.html
On Wed, 19 Feb 2003 08:15:27 -0500, Dave K wrote:
Hi Dave
advice. If you would like to see another approach you can visit:
http://www.geocities.com/k2001evad/pindex.html
Thanx for the demo.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 20/02/2003
http://savage.net.au/index.html
-
#!/usr/bin/perl
#
# Name:
# template.pl.
#
# Purpose:
# Test MySQL $dbh - table_info().
#
# Note:
# tab = 4 spaces || die.
#
# Author:
# Ron Savage [EMAIL PROTECTED]
# http://savage.net.au/index.html
use strict;
use warnings;
use DBI;
use Error qw/:try
the sanity checks at the start of your sub.
Hey, presto! It works.
Demo:
-8-
#!/usr/bin/perl
#
# Name:
# template.pl.
#
# Purpose:
# Test MySQL $dbh - table_info().
#
# Note:
# tab = 4 spaces || die.
#
# Author:
# Ron Savage [EMAIL PROTECTED]
# http://savage.net.au
On Mon, 24 Feb 2003 09:22:09 +, Tim Bunce wrote:
On Sun, Feb 23, 2003 at 11:05:33AM +1100, Ron Savage wrote:
Hi Tim
Because I was using:
$dbh-{FetchHashKeyName} = 'NAME_lc';
OK.
5) At the end of this sub, I added code to return something :-):
\%col_info;
That's not right
On Wed, 26 Feb 2003 19:41:02 +1100, Ron Savage wrote:
On Wed, 26 Feb 2003 09:23:39 +1100, Stas Bekman wrote:
Hi Stas
Have you tried the current mod_perl cvs?
No. Being usually a Windows (shudder) user, I wait for Randy to
issue
a build.
Today I spent 4 hours failing to install Red Hat 6, Red
On Mon, 3 Mar 2003 17:56:33 +0100, Peter Schuberth wrote:
Hello,
Hi Peter
I would also like to stick to MySQL, but I have to change it, since
there is
no DB-Server available.
What do you mean? I use MySQL under Windows.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 04/03/2003
http://savage.net.au
interested in start a new project or modify an existing one
??
(just in case there's no Perl replacement for MSODSC).
Sorry for the long post, and thanks for your time and patience.
Better long than too short. You should always spell out details for
us to better grasp what you're doing.
--
Cheers
Ron
On Mon, 10 Mar 2003 08:40:39 +0200, Victor A. Rodriguez wrote:
Hi all,
Hi Victor, again
See also DBIx::Simple. It, too, is a very clever module.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 10/03/2003
http://savage.net.au/index.html
administration? If so, see tut # 35:
http://savage.net.au/Perl-tutorials.html
Could some one please tell me on the best one to use, and how to
install in
on a Red Hat Linux machine.
Copy my program to /apache2/cgi-bin, and edit the 2 lines near the
end which refer to username and password.
--
Cheers
Ron
::MakeDist. Not
happy.
[1] The indexer looks for a sub-dir in your distro called blib/, and
if it finds such a sub-dir it assumes the distro is a binary one, and
so does not index it. That's why I had to rewrite parts of
Module::MakeDist, to not create and ship a blib/.
--
Cheers
Ron Savage, [EMAIL
'},
+perl_modules.stor
);
In other words:
o I don't have $USER defined
o I don't have /tmp
o File::Spec - rootdir() leads to /C:/tmp/..., which doesn't work
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 23/03/2003
http://savage.net.au/index.html
On Sun, 23 Mar 2003 16:37:43 -0500, Scott R. Godin wrote:
Ron Savage wrote:
Hi Scott
Yes, unfortunately there's no default $ENV{TEMP} on unix..
I've been considering using File::Temp, File::MkTemp, or IO::File
instead,
but just haven't gotten around to futzing with it. :-)
OK
File::Spec would
On Tue, 25 Mar 2003 00:53:16 -0500, Scott R. Godin wrote:
Ron Savage wrote:
Hi Scott
On Sun, 23 Mar 2003 16:37:43 -0500, Scott R. Godin wrote:
Ron Savage wrote:
Hi Scott
Yes, unfortunately there's no default $ENV{TEMP} on unix..
I've been considering using File::Temp, File::MkTemp, or IO
Folks
I'm using DBI to read an MS Access file. I don't have access to
Access. For dates, I get values like:
INS_DTE: 34590.721331.
UPD_DTE: 35416.518703.
VLD_FROM: 34458.0.
VLD_TO: 73415.0.
Any ideas on how to interpret these?
TIA.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 06/04/2003
http
.
#
# Author:
# Ron Savage [EMAIL PROTECTED]
# http://savage.net.au/index.html
use strict;
use warnings;
use CGI;
use CGI::Carp qw/fatalsToBrowser/;
use Error qw/:try/;
# ---
delete @ENV{'BASH_ENV', 'CDPATH', 'ENV', 'IFS', 'SHELL
On Fri, 30 May 2003 22:51:27 -0700 (PDT), Darren Duncan wrote:
Great idea. Go for it!
I'm using DBIx::SQLEngine at the moment, as a framework manager so to
speak, but am happy to see other ways of working.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 01/06/2003
http://savage.net.au/index.html
AND on those 2 fields and 'match any' will
operate like OR.
Now, has anyone developed logic to handle building the SQL in cases
like this?
I searched CPAN for modules named 'match', and found 27 modules, but
none at first glance seemed to offer a solution.
--
Cheers
Ron Savage, [EMAIL PROTECTED
On Sat, 14 Jun 2003 15:22:31 +1000, Ron Savage wrote:
See below for my first attempt.
Hi Folks
Let's say I have search form with fields like these, for
Organizational Entities:
o Name
o Code
o Cost center
o Fund
My customer wants a search option with 2 choices:
o Match all
o Match any
meaning
entity_key like
'%'park'%']
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 15/06/2003
http://savage.net.au/index.html
design. I am planning on taking some database courses at a local
http://www.kitebird.com/mysql-perl/
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 18/06/2003
http://savage.net.au/index.html
at it. Pity.
Table design is one of the few things I find easy. If you live in
Melbourne, Australia, drop in!
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 6:05 PM
To: DBI users
Subject: RE: Database layout and query questions...
On Tue, 17 Jun
account_uid
account_gid
account_home
account_shell
and, yes, I can see 1 table and 2 table solutions.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 20/06/2003
http://savage.net.au/index.html
-fetchall_arrayref([0]);
return the same thing in the case the SQL selects 1 column.
o Well done on the set of slides. I've done a few lectures like that
and know a lot of work went into their preparation
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 12/07/2003
http://savage.net.au/index.html
Under selectrow_array, the link for fetchrow_array points to
#fetchrow_array and it should point to #item_fetchrow_array
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 12/07/2003
http://savage.net.au/index.html
http://xmlproj.com/fom-serve/cache/68.html
Is xmlproj still sick?
4 http://groups.google.com/groups?hl=enlr=ie=UTF-8group=perl.dbi.users
although I can't remember the last time I tried to use any of these references.
Please tell me your preferences.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 8/12
...
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 8/12/2004
http://savage.net.au/index.html
http://savage.net.au/Ron//html/drawing-tools.html#DbSchema
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 8/12/2004
http://savage.net.au/index.html
Hi Folks
New ones: Dico and Druid. Both require Java.
http://savage.net.au/Ron//html/drawing-tools.html
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 9/12/2004
http://savage.net.au/index.html
On Thu, 9 Dec 2004 09:50:14 +, Tim Bunce wrote:
Hi Folks
Are bind_param_array() and array_execute() fully implemented in
the DBD::Oracle driver??
Lateral thinking suggests you might try generating a data file and using
Oracle's bulk load facility to read that quickly...
--
Cheers
Ron
Hi Folks
http://savage.net.au/Ron/html/drawing-tools.html
Thanx to Remo Sanges.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 19/01/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
-lists/dbi/
3 (Find archive) http://xmlproj.com/fom-serve/cache/68.html
4 http://groups.google.com/groups?hl=enlr=ie=UTF-8group=perl.dbi.users
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 25/01/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
to a newer client (in this
case, obviously, my client being DBD-MySQL).
You've done everyone (including yourself) a disservice by not showing us the
error message, so I'll take a guess that the problem is the one documented here:
http://dev.mysql.com/doc/mysql/en/Old_client.html
--
Cheers
Ron
://dev.mysql.com/doc/mysql/en/Old_client.html
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 25/03/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
to the dev team about how to deal
What exactly does it take to compile DBD::mysql under Windows?
I run Windows (usually).
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 7/04/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
On Sun, 10 Apr 2005 00:47:02 +0200, Ing.Branislav Gerzo wrote:
Hi
IMHO data goes in databases and files go in directories.
Raving about speed is simply premature optimization, and hence is a design
fault.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 10/04/2005
http://savage.net.au/index.html
that people who put efficiency/logic/speed ahead of
good design are raving.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 11/04/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
On Mon, 11 Apr 2005 09:56:21 +0200, Peter J. Holzer wrote:
Hi Peter
On 2005-04-10 10:23:38 +1000, Ron Savage wrote:
IMHO data goes in databases and files go in directories.
Isn't that a bit a circular definition? If you store an image in a
file, it's a file and goes in a directory. If you
On Tue, 12 Apr 2005 16:28:18 -0400, Mark F. nettleingham wrote:
Hi Mark
Have you considered using DBD::ProxyServer?
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 13/04/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
On Tue, 12 Apr 2005 10:46:06 +0200, Christian Merz wrote:
Hi Folks
Well, I thought I'd better put my keyboard where my mouth is, so I wrote an
article on this:
http://savage.net.au/Ron/html/images-in-files.html
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 13/04/2005
http://savage.net.au
Hi Folks
http://savage.net.au/Ron/html/drawing-tools.html
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 13/04/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
On Mon, 18 Apr 2005 02:28:26 -0700, Michael G Schwern wrote:
Hi Michael
PS This should make an excellent FAQ.
I'll summarize something over the next week or 2, unless you've started :-).
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 19/04/2005
http://savage.net.au/index.html
Let the record
command in emails
o All that's needed now is for email client vendors to patch their parsers to
handle POD. Hmmm, even Perl may turn out to be of some relevance in the parsing
phase...
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 20/04/2005
http://savage.net.au/index.html
Let the record show: Microsoft
Hi Folks
http://savage.net.au/Perl/html/upgrade-perl-apache.html
via
http://savage.net.au/Perl.html
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
On Sat, 23 Apr 2005 18:59:50 + (UTC), Mark Stosberg wrote:
Hi Mark
It says Authcate staff only and didn't let me in without a
password
Don't you just hate that. I use browsers from inside the uni, and forgot you
need to authenticate. Sorry.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 24
.
Thanx for the comments. It sure is a complex issue. I did not pretend to cover
much of it, only to give the OP and others some things to think about.
Winter's approaching (here) so one dark night I'll collate the responses and
expand the article.
--
Ron Savage
[EMAIL PROTECTED]
http
On Wed, 27 Apr 2005 10:06:24 -0400, [EMAIL PROTECTED] wrote:
Hi
Search this page
http://savage.net.au/Perl/html/upgrade-mysql.html
for old_password.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 28/04/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian
On Fri, 13 May 2005 07:26:49 -0700 (PDT), Job Miller wrote:
Hi Job
maybe a one time schema compare to ensure that the schema the app
A CGI script giving you a color-coded diff between schemas is here:
http://savage.net.au/Perl-tuts-1-30.html#tut_26
--
Cheers
Ron Savage, [EMAIL PROTECTED
haven't heard of any problems,
and I believe there are several people using the plugin
successfully (besides me that is).
I'm sure happy to have used it in production settings.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 26/05/2005
http://savage.net.au/index.html
Let the record show: Microsoft
to be reliable.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 26/05/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
: WinXP
Perl: 5.8.6
DBI: 1.48
MySQL: 4.1.10
DBD::mysql: 2.9007
Primary keys found: 0 (wrong)
Foreign keys found: 0 (wrong)
Where exactly is the error? I assume in my code (hope not) or in DBD::mysql.
Could readers please run this code on their systems, and post their results
here?
TIA.
--
Cheers
Ron
) for
SQL_ACCESSIBLE_TABLES and - get_info(149) for SQL_INFO_SCHEMA_VIEWS
but they returned 0 and 'Y' (I think - I'm at home now) respectively.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 23/06/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
doubts as to what
the problem really is...
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 24/06/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
On Wed, 29 Jun 2005 10:56:54 -0700, Calder, Erick wrote:
Hi Erick
As a last resort, try:
http://savage.net.au/Perl-modules/html/installing-a-module.html
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 30/06/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian
http://savage.net.au/Ron/html/msaccess2rdbms.html
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 3/07/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
http://savage.net.au/Ron/html/sql-is-not-an-object.html
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 3/07/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
and SHA1 are attackable, but that's not the point
here.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 5/07/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
On Tue, 5 Jul 2005 11:33:00 -0600, Reidy, Ron wrote:
Hi Folks
Or perhaps the old version is in the path before the new version.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 6/07/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
On Thu, 07 Jul 2005 11:38:06 +1000, Daniel Kasak wrote:
Hi Daniel
my $sth = $dbh-prepate( set dateformat dmy );
What am I doing wrong?
No idea, but I'd try:
set dataformat 'dmy'
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
and maintain my own Perl, but that creates overhead
for me. And being a contractor rather than staff confuses the issue, too.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 10/07/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
On Sat, 16 Jul 2005 11:29:09 +0530, Sinha, Dipyaman \(Company IT\) wrote:
Hi Dipyaman
use DBI 1.30;
DBI is up to V 1.48. I suggest you read the change log and see when PL_dowarn
was introduced.
And upgrade.
use DBD::Sybase 0.95;
Now at 1.05. Another upgrade awaits.
--
Cheers
Ron Savage
Hi Folks
Jonathan Leffler has sent me these grammars, which I'm hosting at:
http://savage.net.au/SQL/
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 17/07/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
On Fri, 22 Jul 2005 16:40:02 -0700, Darren Duncan wrote:
Hi Darren
Just curious, but does any company fund your work?
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 23/07/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
On Wed, 03 Aug 2005 12:22:12 +0200, Bart Lateur wrote:
Hi Bart
And take a look at SQL-Fairy, a project on Sourceforge...
http://sqlfairy.sourceforge.net/
Thanx. I had that on file but could not find it amongst all my notes :-(.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 4/08/2005
http
and publish my findings to this mailing list (DBI users)?
Remember that famous maxim: Publish and Be Damned!
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
\plottest.t2 512462 4.35% 46
Failed 1/1 test scripts, 0.00% okay. 1/46 subtests failed, 97.83% okay.
NMAKE : fatal error U1077: 'C:\Perl\bin\perl.exe' : return code '0x2'
Stop.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 19/08/2005
http://savage.net.au/index.html
Let the record show
On Thu, 18 Aug 2005 08:35:54 -0700, Dean Arnold wrote:
Hi Dean
Do you have DBD::CSV installed ? The tests require that. BTW: I
built/tested on AS 5.8.3, never got any of those errors
Yes.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 19/08/2005
http://savage.net.au/index.html
Let the record show
; ..
The error message was:
Could not execute drop table IF EXISTS JGanSamples:
called with 1 bind variables when 0 are needed
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 30/09/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
On Fri, 30 Sep 2005 17:05:35 +0530, Umesh Barik wrote:
Hi Umesh
1) http://charlotte.pm.org/kwiki/index.cgi?BreadProject
2) http://search.cpan.org/ and search for CGI::Application
or DBIx::Admin
3) (Old code) http://savage.net.au/Perl-tutorials.html (# 35 or 41)
--
Cheers
Ron Savage, [EMAIL
so reluctant to download
and try it for myself. Of course, I don't question the amount of work you put
into it.
I hope you attain your new goals soon, and in that way gain further
encouragement.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 1/10/2005
http://savage.net.au/index.html
Let the record
Hi Folks
I can't get last_insert_id() to work with Oracle.
OS: GNU/Linux
DBI: V 1.48
Oracle: 9.2.0
Demo (to save you typing): http://savage.net.au/last.pl
I've tried various values for catalog and schema, including the schema for the
(test) table.
Any idea?
--
Cheers
Ron Savage, [EMAIL
On Thu, 6 Oct 2005 14:00:58 +0100, Gaul, Ken wrote:
Hi Ken
Thanx. I'll try that tomorrow, at work.
It's 11pm here now.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 6/10/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
the sequence and the table.
In Postgres, using:
id integer primary key default nextval('seq')
links them in a way Oracle does not seem to provide.
Or at least that I can't find in Oracle's on-line docs.
A 1-line comment in DBD::Oracle's POD about this would have been nice to find...
--
Cheers
Ron Savage
1 - 100 of 386 matches
Mail list logo