Pat Rice wrote:
Hi all
I'm trying to get the following working
what I want to do is to click on the link and it would order the
table, through the SQL query.
I think the problem is that when I click on on the link to ORDER BY it
fails, that is it does not change the order of the table.
It works fine for me. It should be noted, though, that I'm using MySQL,
not SQLite. Don't know if there is a difference in syntax that is not
taken care of by DBI and friends.
I wondering
does anyone know how I can confirm that the ? is correct, as in what
is being passed to the query.
It seems like the code does not report an error even if what's passed to
the execute() method is a non-existing column.
but I'm prety sure that I am passing the
correct arguments to the SQL query,
I agree. Printing certain variables, just like you are doing, is a good
debugging habit.
1 #!/usr/bin/perl
2 use DBI;
3 use CGI;
4
5
<rest of code snipped>
You should also include
use strict;
use warnings;
Also, you should make it easier to help you by not including the line
numbers. The code you post should better be possible to copy and run.
--
Gunnar Hjalmarsson
Email: http://www.gunnar.cc/cgi-bin/contact.pl
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
