I'm using the QueryBuilder from some of my code, and it has been working
quite well.  I have a case where the behavior surprised me and I'm
wondering if I misunderstood the docs.

The docs show this:
query => [ legs => { gt_sql => 'eyes' } ]

This results in "legs > eyes" with no quoting.  However, if "legs" is
something other than a column name that the QueryBuilder knows, it just
gets silently dropped.  My impression from the docs was that this would
allow me to put arbitrary functions and such in here, like this:

query => [ '1+1' => { sql => '2' } ]

Of course I can use the clauses option to get around this, but I'm just
wondering if this should have worked as I expected.  Also, it would be
very nice if columns that don't match could cause a fatal error instead
of being silently dropped.  I will see if I can make a patch for that if
you agree.

- Perrin


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object

Reply via email to