Hi everybody,
I've had a thoroughly annoying time trying to make CF export data to a file,
complete with nulls. I think the only proper solution is SQL based, which is why
its off-topic.
The problem is that the only way I can think of to do it is to have all non-null
values returned in quotes by SQL, and null values returned without quotes. And
the only way I can think of to do that is to use the property that a null
concatenated with a string is a null.
Good plan, except it doesn't seem to work on my SQL 7. You can set
concat_null_yields_null to on til the cows come home, and it still smugly
returns a string ('abc') if you go SELECT 'abc'+NULL from dummy.
You can even use the databaseproperty function to confirm that its on, and it
says it is! It just isn't using it.
Can any SQL gurus out there enlighten me before I tear my hair out?
David Cummins
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
