How do I build a SQL statement in Class::DBI programmaticallyby rlb3 (Deacon)
|on Dec 08, 2004 at 22:15 UTC||Need Help??|
rlb3 has asked for the
wisdom of the Perl Monks concerning the following question:
I'm having some trouble building an SQL statement from a
web form. I'm using Class::DBI's set_sql method to create and new method
that changes everytime through a loop.
A full SQL statement would look like this:
The starting_point_topics would change as it loops and WHERE statement will change also but this is the one i'm testing right now. The error i'm getting is:
I 'm not sure why the table names in the where statement are not changing.