sage
> Available drivers: DBM, ExampleP, File, Pg, Proxy, Sponge, mysql.
And this one.
In short - change 'pg' to 'Pg' in your connection script.
Happy perling ;)
Waldemar
--
Waldemar Zurowski <[EMAIL PROTECTED]>
--
Waldemar Zurowski <[EMAIL PROTECTED]>
W liście z wto, 16-03-2004, godz. 03:52, Hendra Kusnandar pisze:
> hai, i have change with :
>
> my ($nik, $password, $scode) = @_;
>
> when i execute the scripts, the scripts can't execute
> and the error of scripts is :
>
> DBD::mysql::st execute failed: Column 'nik' cannot b
W liście z sob, 13-03-2004, godz. 16:23, Hendra Kusnandar pisze:
> but i can't insert any data to mysql if i change the variabel on top with this :
>
> my $nik = @_; # 8 digit
> my $password = @_; # 8 digit
> my $scode = @_; # 1 digit
This is wrong, because that way all of your
W liście z pią, 07-11-2003, godz. 00:47, Kenneth Webber pisze:
> Friends.
Just a guess, but is
$ test -d /home/timbo/dbi
hang as well?
Waldemar
> my $sql = "
> use eggsupp;
> select *
> from filesupp
> where owner like 'Adam%'
> ";
>
Why don't you do:
$dbh->do('use eggsupp');
and then:
normally run your query, with that first 'use eggsupp' removed.
Waldemar
W liście z pon, 16-12-2002, godz. 10:32, Brien Pirkle pisze:
> my $st_create_trigger = $dbh->do(qq{
> });
Are there any reasons, you are using 'qq' instead of 'q'?
BTW - escaping can be done using '\' (backslash) character, as qq(some
string) is equivalent to "some string".
Waldemar
W liście z pon, 16-12-2002, godz. 10:32, Brien Pirkle pisze:
> my $st_create_trigger = $dbh->do(qq{
> });
Are there any reasons, you are using 'qq' instead of 'q'?
BTW - escaping can be done using '\' (backslash) character, as qq(some
string) is equivalent to "some string".
Waldemar
-
W liście z czw, 28-11-2002, godz. 15:48, Vikram N pisze:
> Hi ,
> I am using DBI perl to connect to Oracle database. I am using "qq" against all
>queries submitted through prepare statement.
> I wanted to know if this is a good practice. Will this cause a problem in any
>situation ?
I would p
> my $sth = $dbh->prepare("select sid from v_$session");
Your problem is that you enclosed your SQL statement with double qoutes.
This way, your table name becomes just 'v_' (as there is not any defined
variable $session in your program.) See perl's error message and find
what it is tring to tell
On Tue, 22 Oct 2002 13:43:49 -0600
"Powell, Bruce" <[EMAIL PROTECTED]> wrote:
> At a client site we just installed DBD/dbi. Upon starting up our
> product that uses this method to connect with the database we received
> this error:
This is typical problem with standard PERL+DBD::Oracle installat
On Tue, 15 Oct 2002 12:56:36 +0100 (BST)
[EMAIL PROTECTED] wrote:
> I don't see any of this being the fault of DBD::ODBC. There are other
> issues with the MS SQL Server ODBC driver and procedures (specifically
> cursors) you might want to be aware of - search microsoft's site as I
> don't have t
On 20 Sep 2002 07:34:07 -0500
"P. M. Wright" <[EMAIL PROTECTED]> wrote:
> On Fri, 2002-09-20 at 06:29, Waldemar Zurowski wrote:
>
> > > We installed DBI and DBD::Pg
> >
> > How did you installed it? Are they come from Debian packages,
On 20 Sep 2002 07:03:59 -0500
"P. M. Wright" <[EMAIL PROTECTED]> wrote:
> We recently upgraded our server to woody, which brought perl up to
> 5.6.1.
> After the upgrade our CGI Postgres scripts don't work.
> Other CGI scripts (with no database interface) work, and psql works in
> interactive mod
On Thu, 12 Sep 2002 11:08:57 -0400
"Rich DeSimone" <[EMAIL PROTECTED]> wrote:
> Ok so you are suggesting an "apt-get remove libdbd-mysql-perl" then an
> "apt-get install libdbd-mysql-perl"?
No.
Remove:
/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql
/usr/local/lib/perl5/site_perl
On Wed, 11 Sep 2002 13:57:25 -0400
"Rich DeSimone" <[EMAIL PROTECTED]> wrote:
> I thought 5.8.0 was stable? Do you suggest I use an earlier version?
No. I was thinking about Debian.
I
> I tried "apt-get install libdbd-mysql-perl" and it says I have the newest
> version.
Then look again at th
On Wed, 11 Sep 2002 10:33:36 -0400
"Rich DeSimone" <[EMAIL PROTECTED]> wrote:
> I am using debian and I verified which packages are installed by viewing a
> list at http://slashcode.com/docs/INSTALL.debian I installed all the perl
> modules packages even though I am sure I don't need all of them
On Tue, 10 Sep 2002 22:16:19 -0400
"Rich DeSimone" <[EMAIL PROTECTED]> wrote:
[..]
> So I am assuming that code is right and I don't think it is even relevant to my
>problem. When I try to run the script I get "perl: relocation error:
>/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/my
On Tue, 10 Sep 2002 10:43:40 +0100
Tim Bunce <[EMAIL PROTECTED]> wrote:
> On Thu, Aug 29, 2002 at 08:52:52AM -0700, Michael A Chase wrote:
> > > > We downloaded PERL 5.8.0 and compiled in AIX 5.1.0.0
> > > > It seemed to works fine, but we have a problem which I think might be
> > > > related to
On Mon, 1 Jul 2002 21:34:50 +0100
Tim Bunce <[EMAIL PROTECTED]> wrote:
> > Yet is't a horribly long name. Why don't you change "connect" into
> > "connect_to_database", "prepare" into "prepare_statement" and "do" into
> > "prepare_and_execute_statement"?
>
> Huffman coding.
Well - I personally
On Mon, 20 May 2002 07:47:12 +0100
"Stevenson, Jonathan" <[EMAIL PROTECTED]> wrote:
> .. On another note, I don't know if you are trying to install
> DBD::Oracle (the +z suggests you may be), no one has found the exact
> recipe to do it using gcc. If you do get this to work, I would be like
> to
On Mon, 20 May 2002 08:45:57 +1000
Adam Stuckey <[EMAIL PROTECTED]> wrote:
> gcc -c -Ae -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
> +Onolimit
>
> Stop.
> root:mv36_1#
>
> Any Ideas??
That is because your perl was built with HP-UX' native C compiler.
Either you have to bu
On Fri, 17 May 2002 10:55:24 -0500
[EMAIL PROTECTED] wrote:
> Hi. I'm having an issue when I attempt to compile the DBI module
> (1.20) on my HP-UX box (11.00/PA-RISC). I'm using GCC
> (64/3.02.2001-11-14) but the Makefile is still trying to use CC! Any
> suggestions would be most appreciated. Th
> I am having problems with the building of DBD::Informix on HPUX 11
> using gcc 3.0.4, the Makefile does not complete. I get the following
> output :
> gcc: +Ofastaccess: No such file or directory
> gcc: +DS2.0: No such file or directory
> gcc: +DA1.1: No such file or directory
> cc1: Unrecogniz
On Mon, 6 May 2002 08:39:37 +1000
"Michael Blackmore" <[EMAIL PROTECTED]> wrote:
>
> my ($col1,$col2,.) = split(/,/);
> $col1 = undef unless($col1);
>
>
> I realise that this is not strictly a DBI problem, really 'split'
> should return undef's, shouldn't it? Anyway I wondered if a
> 'cl' is not recognized as an internal or external command,
> operable program or batch file.
> NMAKE : fatal error U1077: 'C:\WINNT\system32\cmd.exe' : return code
> '0x1' Stop.
You need Visual C compiler, from Microsoft, You do have it - do You? If
You would like to use Cygwin GCC, than you ha
25 matches
Mail list logo
