I got this error in every query with a LEFT JOIN with NULL values.
For example:
<cfquery datasource="buenosaliens_contenidos" name="q_test"
result="res">
SELECT nota.nro_nota as ID, titulo, copete,
variables4.variable, variables4.valor
FROM nota
LEFT JOIN variables as variables4 ON variables4.nro_nota =
nota.nro_nota
WHERE nota.nro_nota >= 28211
limit 100
</cfquery>
<cfdump var="#q_test#">
<cfdump var="#res#">
Thank you for your help.
Dante
On Jul 17, 1:30 pm, Matthew Woodward <[email protected]> wrote:
> On Sat, Jul 17, 2010 at 8:37 AM, Dante <[email protected]> wrote:
> > So, if I want to use the second row of this query I get several errors
> > because the field is "undefined" instead of "null"...
>
> Can you post the code that breaks due to this difference?
>
> --
> Matthew Woodward
> [email protected]http://blog.mattwoodward.com
> identi.ca / Twitter: @mpwoodward
>
> Please do not send me proprietary file formats such as Word, PowerPoint,
> etc. as attachments.http://www.gnu.org/philosophy/no-word-attachments.html
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
online manual: http://www.openbluedragon.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
