On Sun, 4 Jan 2004 16:47:54 +1100, Ron Savage wrote:
> I tried DBI ->
> data_sources('mysql', {}, $dbh) and got:
> Undefined subroutine &DBD::mysql::db::SQL_VARCHAR called at
> C:/Perl/site/lib//DBD/mysql.pm line 337.
No - my mistake. I get:
DBI data_sources: invalid number of parameters: handle +
Hi Folks
Scott R. Godin, in a post on 2003/10/18, had this code:
my $sth = $dbh1->column_info( undef, undef, $table, '%');
so I've tried a few similar things...
1) I tried:
my($column_sth) = $dbh -> column_info(undef, undef, $table_name, '%');
and got:
Undefined subroutine &DBD::mysql::
Hi Folks
1) Under 'synopsis', it says:
@data_sources = DBI->data_sources($driver_name, \%attr, $dbh);
however that combination of options is not listed under the discussion of
data_sources().
Anyway, I tried DBI -> data_sources('mysql')
and got an empty list. Sigh.
I tried DBI -> data_sources('my
0.2 January 3, 2004
A major update to SQL::Interpolate is now available. The most notable
addition is support for a new quote-like sql// operator that
intelligently and securely handles interpolation of variables into SQL
strings:
my $rows = $dbh->selectall_arrayref( sql[
SELECT * FROM
Thank you all for the replies, I am not behind proxy!.
This is what I did, I copied the DBI module local to my machine
and installed with no Errors.
One more question though, I couldn't find module DBD-Oracle in perl5.8.2..
Is it not supported yet!
Thanks
- Original Message -
From: R
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> PPM - Programmer's Package Manager version 3.1.
> Copyright (c) 2001 ActiveState SRL. All Rights Reserved.
>
> Entering interactive shell. Using Term::ReadLine::Stub as readline
library.
>
> Type 'help' to get started.
>
> ppm> install D
Are you behind a proxy? Go to activestate.com and do a search for PPM and firewall.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sat 1/3/2004 7:52 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Ins
essential quint wrote:
I'm writing a login script for a website, and the first subroutine
will look up the username. But suppose the username doesnt exist in
the database, then what kind of value will MySQL or DBI return? I
need it for writing the conditional in the control structure.
There
"Anniballi, Fran" <[EMAIL PROTECTED]> writes:
> As soon as I recompile the same DBI/DBD with it pointing to Oracle 9
> environment (libraries), it doesn't work. It is looking for Oracle9
> library files and I obviously don't have it pointing to oracle9
> libraries when I access an Oracle 8 instan
Michael A Chase wrote:
On Sat, 03 Jan 2004 04:57:10 -0500 Terrence Brannon <[EMAIL PROTECTED]> wrote:
Jim Cromie wrote:
My comment was based on a cursory read, and general queasyness with
non-placeholder construction of complex SQL - seeing all those $,@
just made me itch.
let me
The tnsnames.ora are all set. I did what you said already.
Example: DBI/DBD will work fine if I compile the DBI/DBD pointing to Oracle 8
environment(libraries) and access an Oracle 8 instance. I didn't have to change
tnsnames.ora
As soon as I recompile the same DBI/DBD with it pointing to
PPM - Programmer's Package Manager version 3.1.
Copyright (c) 2001 ActiveState SRL. All Rights Reserved.
Entering interactive shell. Using Term::ReadLine::Stub as readline library.
Type 'help' to get started.
ppm> install DBI
Error: No valid repositories:
Error: 500 Can't connect to ppm.ActiveSt
Greetings,
I'm writing a login script for a website, and the first subroutine will look
up the username. But suppose the username doesnt exist in the database,
then what kind of value will MySQL or DBI return? I need it for writing the
conditional in the control structure.
Thanks,
quint
__
The instances you can access in any $ORACLE_HOME depend on you correctly
configuring the tnsnames.ora file . I suggest compiling against 9i and
adding the 8i instance to your tnsnames. If you can use sqlplus to access
the other instance then you will be able to use DBI. You need to also look
at usi
I did this. I compiled against 9i during the install. But can't access any 8i
instances if I do this. If I do then it is looking for 9i libraries and I have to
have the environments pointing to 8i if I want to access an 8i instance.
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL P
On Sat, 03 Jan 2004 04:57:10 -0500 Terrence Brannon <[EMAIL PROTECTED]> wrote:
> Jim Cromie wrote:
>
>> My comment was based on a cursory read, and general queasyness with
>> non-placeholder construction of complex SQL - seeing all those $,@
>> just made me itch.
>
> let me make sure I understa
Jim Cromie wrote:
My comment was based on a cursory read, and general queasyness with
non-placeholder
construction of complex SQL - seeing all those $,@ just made me itch.
let me make sure I understand the source of your quasiness: it is
because if you use placeholders in conjunction with $dbh-
17 matches
Mail list logo