My problem now is building the queries. How can I see what SQL code is being generated for me? According to the tutorial John so kindly pointed me towards, the SQL that was used should be output by script/myapp_server.pl, but that only gives me errors like
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 'Date' ) OR ( select COUNT 'Date' ) ) ) ORDER BY sensorid' at line 1 at /usr/lib/perl5/vendor_perl/5.8.7/DBIx/Class/Storage/DBI.pm line 516.
and not the whole query.
~ Sarah
On 6/19/06, Sarah Berry <[EMAIL PROTECTED]
> wrote:
On 6/16/06, John SJ Anderson <[EMAIL PROTECTED]> wrote:
"Sarah Berry" <[EMAIL PROTECTED]> writes:
> Can anyone point me towards some resources?
It sounds like you might want to grab the SVN version of the tutorial
and work through that. It doesn't take long (less than a day), and it
will give you a much better idea how DBIx::Class fits into Catalyst,
how authentication and authorization work, and how to do basic CRUD
stuff (as well as several other topics).
You can get it by using SVN like so:
svn co http://dev.catalyst.perl.org/repos/Catalyst/trunk/Catalyst/lib/Catalyst/Manual
Or use a web browser to look at:
http://dev.catalyst.perl.org/browser/trunk/Catalyst/lib/Catalyst/Manual/Tutorial
I've been messing around with Cat fora while, and have even given a
talk on it to the local Perl group -- and after working through the
tutorial, my overall understanding of the structure of the whole
"Catalyst experience" is a lot better, and it's much easier to work
around speedbumps when I hit them.
chrs,
john.
Thanks John, I will start going through these.
_______________________________________________ List: [email protected] Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
