What object should it return if the node or the node content is null?
If you want to be safe return a new empty XmlElement in that case, but if you're using a WSDL, XSD or other schema, check the schema itself. If 'the other side' doesn't comply to your schema you can blame them, but if your schema flaws, it's all up to you to repair it...
Afterlife
Last Activity: Sep 12 '07, 11:30 PM
Joined: Sep 7 '07
Location:
-
Books Online is your friend: Cascade isn't a keyword you can use in your T-SQL queries, but part of the definition of your foreign keys.
But take care, in a lot of cases cascading deletes is not what you want.
Eg, if you want to remove a customer from your database, cascading deletes will also remove buys, invoices, etc. in the past, which most probably isn't what you want.
So use cascading deletes with care!...Leave a comment:
-
WHERE EXISTS is about as fast as SELECT TOP 1 ... because it exits the check when the 1st hit is reached. WHERE field IN (SELECT ...) is a lot costlier though.Leave a comment:
-
I guess you're using ColdFusion? (the cf... and MacroMedia hint to that)
I don't have any experience or knowledge of CF, but #id# (probably an integer?) will never be part of a varchar field CATEGORY. The types just won't match.
And why check if the #id# is part of the CATEGORY field in the same record? Doesn't sound logical or useful to me......Leave a comment:
No activity results to display
Leave a comment: