Michelle Kobza-Road Runner writes:
> Hi,
>
> I am trying to pull date from 3 different tables to generate a specifically
> formatted text file. I can successfully join two tables using the ANSI LEFT
> JOIN, but when I try to add a third this does not work. I have than moved to
> using the o
%% "M.W. Koskamp" <[EMAIL PROTECTED]> writes:
>> When I try to use $sth->errstr, for example, from within my classes, I
>> get a reference error.
>>
>> or croak "DB Error: $this->errstr\n";
>>
>> $sth->execute()
>> or croak "DB Error: $sth->errstr\n";
mwk> The arrow isnt interp
Hi,
I am trying to pull date from 3 different tables to generate a specifically
formatted text file. I can successfully join two tables using the ANSI LEFT
JOIN, but when I try to add a third this does not work. I have than moved to
using the older perl script " from a,b,c" . This seems to join
>
> There is one issue left:
>
> When I try to use $sth->errstr, for example, from within my classes, I
> get a reference error.
>
> or croak "DB Error: $this->errstr\n";
>
> $sth->execute()
> or croak "DB Error: $sth->errstr\n";
> DB Error: MyDB::DB::st=HASH(0x82e78a0)->err
%% "M.W. Koskamp" <[EMAIL PROTECTED]> writes:
mwk> I have the same problem. Possibly a feature of the mailinglist.
mwk> You have to choose reply all, to get it in the mailing list cause
mwk> hitting reply only, will send it to just the private email
mwk> adress. After that you will recei
%% Steve Sapovits <[EMAIL PROTECTED]> writes:
ss> It's not that hard. I subclassed it for the purpose of allowing
ss> logical database names that we map to the real DBI resource
ss> strings. Among other things, that gives us one place to change
ss> where a given database/schema really
- Original Message -
From: Paul D. Smith <[EMAIL PROTECTED]>
To: M.W. Koskamp <[EMAIL PROTECTED]>
Cc: dbi-users <[EMAIL PROTECTED]>
Sent: Saturday, April 21, 2001 12:04 AM
Subject: Re: ISA inheritance vs. DBI?
> This is annoying; that's twice today I've received a private email from
> s
This is annoying; that's twice today I've received a private email from
someone on the list, with just me in the headers, only to have it show
up later with _both_ me _and_ the rest of the list in the headers.
Is this a "feature" of the dbi-users list somehow? It's a pain, since
by the time I ge
- Original Message -
From: Paul D. Smith <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 5:56 PM
Subject: Re: ISA inheritance vs. DBI?
> %% "M.W. Koskamp" <[EMAIL PROTECTED]> writes:
>
> mwk> sub connect{
> mwk> my $class = shift;
> mwk> my $class
In article <[EMAIL PROTECTED]>, Nicolas JOURDEN
<[EMAIL PROTECTED]> writes
>Hi,
>
>I'd like to do something using DBD::CSV, it's like a good system but
>does he understand DELETE, UPDATE, DROP reuquest (in sql statement...) ?
>
>There's no information about this kind of things
>
DELETE and UP
In article <000901c0c994$4aaf0220$[EMAIL PROTECTED]>, M.W. Koskamp
<[EMAIL PROTECTED]> writes
>What folders did you make to put the files in?
None.
I saw that @INC included "." so I put the .pm files in the cgi-bin
directory. Then the error messages changed from "can't find module" to
can't find
I have only used DBD::CSV a little, but discovered the following:
o SELECT works
o DROP table works
o DELETE works
o UPDATE works
o APPEND works
No real field data type info is preserved. Dates are treated like text. A
missing column at the end of a record is treated as a NU
Everett Hickey writes:
> I've torn through website after website, faq after faq, and the man page for DBI...
>searched CPAN, search engines, and interrogated a number of books, people, and
>inanimate objects. So far only inanimate objects have been hurt in the process... so
>far...
>
>
Hi dbi-users,
I just want to share with you the solution to the famous "Solaris patch" problem
that finally worked for my system.
I support a production system on Solaris 2.6 which was recently upgraded to
Oracle 8.1.6, OAS 4.0.8.2, Perl 5.005_03, DBI 1.15 and DBD 1.06 (also Oracle
Developer 6i
It's not that hard. I subclassed it for the purpose of allowing
logical database names that we map to the real DBI resource
strings. Among other things, that gives us one place to change
where a given database/schema really is. I'm attaching that
code so you can see what you have to do to su
Sorry, sent that to the wrong list. Should have gone to mod_perl.
-- Brett
On Fri, 20 Apr 2001, Brett W. McCoy wrote:
> > this is very interesting ... and another good reason to buy the
> > PerlCookBook. But are there in the mod_perl architecture some
> > guidelines and/or frameworks that enco
> this is very interesting ... and another good reason to buy the
> PerlCookBook. But are there in the mod_perl architecture some
> guidelines and/or frameworks that encourages the MVC design patern ? I
> think that Apache::ASP could be (for example) the right tool, adding
> the "forward" feature.
On Fri, 20 Apr 2001, Everett Hickey wrote:
> I've torn through website after website, faq after faq, and the man
> page for DBI... searched CPAN, search engines, and interrogated a
> number of books, people, and inanimate objects. So far only inanimate
> objects have been hurt in the process...
I've torn through website after website, faq after faq, and the man page for DBI...
searched CPAN, search engines, and interrogated a number of books, people, and
inanimate objects. So far only inanimate objects have been hurt in the process... so
far...
So maybe someone here can either put m
%% "M.W. Koskamp" <[EMAIL PROTECTED]> writes:
mwk> sub connect{
mwk> my $class = shift;
mwk> my $class = ref($class) || $class;
mwk> return bless $class->SUPER::connect(@_), $class;
mwk> }
I don't see how either of these are any different from what I said I
already tried in
%% Regarding Re: ISA inheritance vs. DBI?; you wrote:
rls> Let class methods be class methods. Instance methods be instance
rls> methods. Especially for constructors.
rls> Just another guy who has been OO-programming for *21* years, and
rls> a member of the "help stamp out ref($class)|
* Jeff Thies ([EMAIL PROTECTED]) [010420 11:35]:
> I believe there is an easy way to return the last value of an
> auto_increment field with DBI and MySQL. (I think this can be retrieved
> from the database handle.) What is it?
It's actually in the DBD::mysql docs:
$dbh->do( "insert into..."
I believe there is an easy way to return the last value of an
auto_increment field with DBI and MySQL. (I think this can be retrieved
from the database handle.) What is it?
Jeff
Hi everyone,
I am a web developer and I am developing a website manager tool using Perl, mason and
mySQL. In my client interface I'd like to have the posibility of copy and paste object
from other aplications like Excel, Word (I mean graphics objects, datasheet and keep
thier format).
I've lo
Hi Michael,
thanks for your reply.
Michael Peppler wrote:
> If the return status can be more than a fail/success value then I
> would fetch it in a normal fetch loop and check the result type
> (CS_STATUS_RESULT).
Is it reliable to use the string "COL(1)" to fetch that value
or will that string
On Thu, 19 Apr 2001, Amit wrote:
> You see I have designed a chat interface in perl which connects to mysql to
> store chat transacripts and to show the chat sessions. Eg. Say I am
> chatting, I type a message it stores it into mysql. Now, the place where the
> chat appears, the page is refreshed
> "M" == M W Koskamp <[EMAIL PROTECTED]> writes:
M> sub connect{
M> my $class = shift;
M> my $class = ref($class) || $class;
M> return bless $class->SUPER::connect(@_), $class;
M> }
Please remove the ref($class) || $class there. That bad meme seems to
continue to spread like wil
On Fri, Apr 20, 2001 at 11:33:52AM +0200, [EMAIL PROTECTED] wrote:
> table_info
> ok 103
> The stat preceding lstat() wasn't an lstat at blib/lib/DBD/ExampleP.pm line 130.
> dubious
Thanks. Fixed for the next release.
> not ok 75
> Missing directories: .,..,lib,blib,t
> Expecting directories lib
What folders did you make to put the files in?
They might also need to be in the root of your website, depends on what the
current directory is for scripts.
- Original Message -
From: Ian Hobson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 2:06 PM
Subject: H
Hi All,
I have a working site on my test machine, which includes DBI using the
CSV drivers.
Now I discover that the ISP hosing this will not or cannot provide DBI
centrally.
I thought I could get round this by placing the modules I need in the
local cgi-bin but when I try this I get a "method
Amit wrote:
> You see I have designed a chat interface in perl which connects to mysql to
> store chat transacripts and to show the chat sessions. Eg. Say I am
> chatting, I type a message it stores it into mysql. Now, the place where the
> chat appears, the page is refreshed every 5 seconds to ge
- Original Message -
From: James Maes <[EMAIL PROTECTED]>
To: Paul D. Smith <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 11:48 PM
Subject: Re: ISA inheritance vs. DBI?
>
>
> connect
> {
>my($that) = shift;
>my $class = ref($that) || $that;
>my $
You see I have designed a chat interface in perl which connects to mysql to
store chat transacripts and to show the chat sessions. Eg. Say I am
chatting, I type a message it stores it into mysql. Now, the place where the
chat appears, the page is refreshed every 5 seconds to get the transcripts
fr
Interspersed.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Reuss, Bob" <[EMAIL PROTECTED]>
To: "'Michael A. Chase'" <[
34 matches
Mail list logo