Re: ERROR Coalesce

Quote from: markf on Today at 05:19:47 AM

My comment about breaking was everywhere different types are used as in the coalesce case (i.e. "integer and boolean cannot be matched").

Ups, my bad, sorry

Thank ...



Re: ERROR Coalesce

Re: ERROR Coalesce

My comment about breaking was everywhere different types are used as in the coalesce case (i.e. "integer and boolean cannot be matched").



I'm completely aware that you can do "where 1=1" to do every row selects, and in a dynamically built query, this i...



Re: ERROR Coalesce

Re: ERROR Coalesce

1=1 is just bad coding anyway



Re: ERROR Coalesce

Re: ERROR Coalesce

well, full credit to @DerEineDa for the original fix, but thanks for taking it in.

might want to check any other "1=1" logic, as they'll all break on postgresql, just haven't been hit yet.





Re: ERROR Coalesce

Re: ERROR Coalesce

Could you please attach your ManageNews.php, please?



Re: ERROR Coalesce