Re^2: Building SQL Query on the fly

Thanks for the replies guys. I am not too concerned about abuse or security for this first run thru. I would just like to be able to do the things I mentioned above. The front end is built in ruby on rails, so I am not sure I can use template toolkit.

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

Replies are listed 'Best First'.
Re^3: Building SQL Query on the fly by perrin (Chancellor) on Oct 08, 2007 at 02:45 UTC
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.	[reply]
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]
A reply falls below the community's threshold of quality. You may see it by logging in.