• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 109
  • Last Modified:

XMLExists with Multiple Value Parameter

I am pulling data from a XML field in an Oracle database for use in a Crystal Report.  Currently, I'm using XMLExists with a parameter which works fine (below).  The problem is only one parameter value can be entered for each report.  Is there a way to query an XML field with a multiple value parameter?

      xmlexists('declare default element namespace "http://somenamespace.com/common/xsd"; (: :)
             /Person[Id={?ID}]' passing xmlfield)

Thanks!
0
SBsUserName
Asked:
SBsUserName
1 Solution
 
mlmccCommented:
I suspect not.  It will depend on whether you can change the = {?ID} to IN {?ID}.

mlmcc
0
 
SBsUserNameAuthor Commented:
"In" wouldn't work.  Thanks though.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now