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
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
2 matches
Mail list logo