> $FORM{location} =~ s/\'/\'\'/g;
> doesn't seem to work.
Because the escape chracter for SQL::Statement is \ not ' as the docs explain.
> $loc = $dbh->quote("$FORM{location}");
>
> Generates and error in the web logs.
>
> Can't call method "quote" on an undefined value at
> /opt/wireless/process.cgi line 92.
This indicates that you don't have a valid database handle ($dbh).
For debugging I use {RaiseError=>1} during connect with use CGI::Carp
qw(fatalsToBrowser);
--
Simon Oliver
