Re: Strange XML error with CFXML - XML declaration may only begin entities ?

2007-11-14 Thread Niall O'Doherty
Not sure if you can use CF tags within the CFXML tag? Prob better to perform your processing outside the CFXML tag and use a content variable then place it inside the CFXML tags. See the following post for more detail: http://andyjarrett.co.uk/andy/blog/index.cfm/2006/11/16/CFXML-and-CF-tags-gotc

Re: Better way to send nulls to a Stored Proc?

2007-01-23 Thread Niall O'Doherty
Just thinking out of the box here, and not sure if this is exactly what you're after but wouldn't you be better letting SQL decide what to insert. By using the NULLIF() SQL Function you can still pass your date as 01/01/00 if no date is specified and use the NULLIF() function to evaluate what to