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 =20


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



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org