Forum OpenACS Development: Re: Limitation on length of bind variables

Error in include template "/var/www/openacs/packages/openacs-bootstrap3-theme/resources/templates/packages/forums/lib/search/search-form": can't read "form:id": no such variable
Collapse
12: Re: Limitation on length of bind variables (response to 1)
Posted by Janine Ohmer on 02/26/04 04:53 PM
Andrew, it's on page 893 of Tom Kyte's book.

When I tested the temporary table I did the same thing you mention - looped through the array and inserted each value (although I did use a bind variable to do it :).  I found that I had to create my temporary table to preserve rows instead of deleting them, because when the table was created to automatically delete rows they were gone when I went to select them.  So I had the additional overhead of deleting them afterwards.

Collapse
13: Re: Limitation on length of bind variables (response to 12)
Posted by Andrew Piskorski on 02/26/04 06:02 PM
Janine, sounds like you needed to due a "begin transaction" before you started inserting into your temporary table.