[ic] sql query with UNION broken

Jon Jensen jon at endpoint.com
Fri Aug 22 16:04:23 EDT 2003


On Fri, 22 Aug 2003, Kevin Walsh wrote:

> The second correction is better, in my opinion.  There is only one
> SELECT statement, while there are loads of statements that would need
> $update to be set.
> 
> I suggest a minor correction to your second proposal, as follows:
> 
>     $update = 1 if $query !~ /^[\s\W]*select\s+/i;
> 
> That would allow multiple opening parentheses (with or without
> whitespace between) before the SELECT.

That's a good idea. I'll commit that unless someone sees problems with it.

Jon


More information about the interchange-users mailing list