Hello and a Question

Hi,

This is my first post to the list. In fact, I just subscribed today. =
I'm a
web programmer at Haverford College in Haverford, PA--just outside of
Philadelphia.

I write a lot of web programs in Perl that rely on MySQL databases. I =
often
find myself "quoting" numerous variables using the Perl MySQL DBI to =
make
sure that they'll insert into my databases properly. I'm not sure if =
that's
the best terminology for what I do, so here's an example:

$my_quoted_variable_name =3D $dbh->quote( qq[$input{'my_variable_name'}] =
);


The preceding line would "quote" the form variable "my_variable_name" =
and
assign it to the variable "$my_quoted_variable_name", which I would then
insert into my MySQL table.

The issue I've run into, though, is that when I have a web form with =
dozens
of variables, I spend a lot of time "quoting" them all--one by one. Is
there an easier way to do this?

If this seems like a simple question and that there's an obvious answer,
you're probably right. I am somewhat of a novice.

Thanks!






Douglas


--------------------------------------
Douglas S. Davis
Programmer/Analyst
Haverford College
Department of Administrative Computing
370 Lancaster Ave.
Haverford, PA 19041
610-896-4206
dsdavis [at] haverford.edu
http://www.haverford.edu



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules [at] m.gmane.org
dsdavis [ Mo, 28 Juni 2004 22:27 ] [ ID #180703 ]
Datenbanken » gmane.comp.db.mysql.perl » Hello and a Question

Vorheriges Thema: Hello and a Question
Nächstes Thema: mail_to_db