> Yep, that was it. Well done Mark. > There were some NULL values in Trail. Ack NULLS - curse the man who decided we need to be able to represent the lack of a value.....
> btw, I thought CFDUMP was used on to show names of variables, not their > values. ?? Not sure what you mean - when I dump a query I want to see what's in the query in a nice table, same with structs & arrays. > I tried using the bottom code, but nothing displayed. Could be it was > either reading the NULLs first, or not getting past them ? No idea - I generally avoid ever having NULLS unless I really, really need them in there (hardly ever). Another thing to watch out for that completely floored me once was that if you create a query with queryNew() and then populate the first row - CF will try to work out the types of each column based on this first row alone. So if you have a fields that's meant to be a varchar but you put a number in the first row CF will think you want the whole column to be numeric & start being very temperamental when you later try to add a string to the column. There's something on livedocs about this.... http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_r6.htm#wp115797 0 http://mx.blogs.com/blog/2003/12/cfmx_query_of_q.html Cheers Mark ------------------ Mark Stanton Technical Director Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 http://www.gruden.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
