[Koha-devel] Question on proper/preferred DBI usage?

Tonnesen Steve tonnesen at cmsd.bc.ca
Thu May 16 06:22:01 CEST 2002


On Wed, 15 May 2002, Alan Millar wrote:

> I definitely do not want to get into a flame war on this, so if
> it turns that direction, I'll drop the subject.

No flame war from me.  I didn't know about the '?' method.  I like it a
lot, but did you _have_ to use _my_ code as an example?  ;)

As far as indenting goes, Paul, I'm with Chris, except I do whatever vim
does by default.  I'm all for setting a standard, I'm sure I can make vim
do whatever we decide.

Steve.



>         my $q_isbn=$dbh->quote($isbn);
>         my $q_issn=$dbh->quote($issn);
>         my $q_lccn=$dbh->quote($lccn);
>         my $q_volume=$dbh->quote($input->param('volume'));
>         my $q_number=$dbh->quote($input->param('number'));
>         my $q_itemtype=$dbh->quote($input->param('itemtype'));
>         my $q_dewey=$dbh->quote($input->param('dewey'));
>         my $q_subclass=$dbh->quote($input->param('subclass'));
>         my $q_publicationyear=$dbh->quote($input->param('publicationyear'));
>         my $q_publishercode=$dbh->quote($input->param('publishercode'));
>         my $q_volumedate=$dbh->quote($input->param('volumedate'));
>         my $q_volumeddesc=$dbh->quote($input->param('volumeddesc'));
>         my $q_illus=$dbh->quote($input->param('illustrator'));
>         my $q_pages=$dbh->quote($input->param('pages'));
>         my $q_notes=$dbh->quote($input->param('note'));
>         my $q_size=$dbh->quote($input->param('size'));
>         my $q_place=$dbh->quote($input->param('place'));
>         my $q_marc=$dbh->quote($input->param('marc'));
> 
>         $sth=$dbh->prepare("insert into biblioitems (biblioitemnumber, biblionum
> ber, volume, number, itemtype, isbn, issn, dewey, subclass, publicationyear, pub
> lishercode, volumedate, volumeddesc, illus, pages, notes, size, place, lccn, mar
> c) values ($biblioitemnumber, $biblionumber, $q_volume, $q_number, $q_itemtype,
> $q_isbn, $q_issn, $q_dewey, $q_subclass, $q_publicationyear, $q_publishercode, $
> q_volumedate, $q_volumeddesc, $q_illus, $q_pages, $q_notes, $q_size, $q_place, $
> q_lccn, $q_marc)");





More information about the Koha-devel mailing list