Discussion on:

4
Comments

Join the conversation!

Follow via:
RSS
Email Alert
0 Votes
+ -
Why does this return 0

SELECT @x. exist ('/christmaslist/zach')
0 Votes
+ -
doesn't contain it, 0 is false

christmaslist/person would return 1, true

christmaslist/person[@name='zack'], would also be true.

zack is the value of a name attribute of a person element which is a child of christmaslist.

XPath takes a while to get your head round.

Hths
I've still got to support SQL 2000, and potentially MySQL. So I'm afraid it's out of the equation....

Ho hum.
Is there a way to search 'case-insensitively'?

For medical terms, and for what I require from the XML nodes, often the titles are interchanged making for lengthily data collation.

Thanks
Adam
Keyboard Shortcuts:
Prev
Next
Toggle
Join the conversation
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.