Re^3: Building SQL Query on the fly

I believe the suggestion was to use Template Toolkit to generate the SQL, not HTML. Another approach is to use a SQL builder. For simple things, SQL::Abstract can work. For complicated things, SQL::Interpolate or Rose::DB::Object::QueryBuilder are better.

Comment on Re^3: Building SQL Query on the fly

Replies are listed 'Best First'.
Re^4: Building SQL Query on the fly by UnstoppableDrew (Sexton) on Oct 08, 2007 at 16:37 UTC
Actually I was suggesting using it for the xml output, but using it for the sql generation is in interesting angle too. probably a bit overkill though.	[reply]
Re^5: Building SQL Query on the fly by perrin (Chancellor) on Oct 08, 2007 at 17:25 UTC
Overkill maybe, but sometimes I find myself writing half a templating engine just to build up some SQL string and then wondering why I didn't just start with one.	[reply]