Have a look a the "Short Guide to DBI" available at perl.com It has an
example with queries.
http://www.perl.com/lpt/a/1999/10/DBI.html
Regards
Robert
----- Original Message -----
From: "Elie De Brauwer" <[EMAIL PROTECTED]>
To: "Ray Barker" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 02, 2001 10:15 AM
Subject: Re: DBI question (again)
> <snap>
>
> > good info on using the DBI module (should take you right to prepare):
> > http://theoryx5.uwinnipeg.ca/CPAN/data/DBI/DBI.html#prepare
> >
> > There is also a good O'Reilly book titled "Using the Perl DBI" (or
> > something like that) by Alligator Descartes
> >
>
> I know of the existence of that book but the problem is, if i order that
book
> it would take abount one month to actually have it, and this project has
to
> be finished before that ... so i am really searching online material ...
>
> > -> is the dereference operator--the cookbook won't teach you much
> > about it
> >
> > In your case, the $dbh = DBI... returns a database handle(=a
> > reference to a database object in OO speak).
> > Then the >$dbh->do($SQL); runs the do method of the $dbh object
> >
> > The code you've copied from the cookbook is a bit of nonsense meant
> > as an example. To make it work you have to fill in the driver, the
> > database name etc. in the DBI->connect call and you have to put a
> > legal SQL statement in the $SQL variable. This is covered in the
> > above DBI documentation. In my copy of the cookbook, example 14-7 is
> > a more nearly working example, but you would still have to point it
> > to your database.
>
> I know it is an example, as in i can make it work i type it in add the
driver
> add the query and it works perfectly but i'm not happy with that i want to
> know WHY is works and WHAT it does.
>
> I know but exemple 14-7 isn't a really query it's just an insert .... i am
> more interested in query's ....
>
> --
> <======================>
> real men do it in perl ;)
>
> De Brauwer Elie
> [EMAIL PROTECTED]
> <======================>
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
