Joshua D. Drake wrote:
Does anybody have an idea how I can pursuade Postgres into accepting
this as just a simple string and that Postgres shouldn't try to
interpret anything in it?
Yeah, quote the string. You can't submit an unquoted string to PostgreSQL.
As my original post demonstrated, that was not the issue at all. But I
found the reason for the bug. It seems IF in the following expression:
my $rsts = $c->model ('MintAppDB::TransSum')->find ({
category => $c->req->param ('category'),
sentto => $c->req->param ('sentto'),
iso => $c->req->param ('iso')
});
if category and iso pointed to undefined values, the bug I struggled
with was triggered. Making sure that they were defined took care of the
problem. I guess the sql generating stuff didn't like being fed
undefined values.
Thanks anyway,
Marius K.
_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
