Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • Hmmm...error (Score:1, Interesting)

    by clinton (131) <clintp@geeksalad.org> on 2000.05.25 9:58 (#181) Homepage
    You're not cooking your CGI values as you receive them. This can be bad. For example, using a URL of:

    http://www.snowdrift.org/cgi-bin/eperl/computers/perl/pt/question.ep?id=*

    Causes an SQL error to print:

    DBD::mysql::st execute failed: You have an error in your SQL syntax near '* and b.question_id = a.question_id and c.category_id = a.category' at line 1 at /home/snowdrif/lib/perl/PerlTest/Question.pm line 80.
    DBD::mysql::st execute failed: You have an error in your SQL syntax near '* and b.question_id = a.question_id and c.category_id = a.category' at line 1 at /home/snowdrif/lib/perl/PerlTest/Question.pm line 80. 1

    Did you really want me to be able to put in values on my end and have them inserted directly into your SQL? :)

    PS: Your e-mail address isn't on the test site anywhere.