Chancellor
05-11-2010, 06:25 PM
I am trying to query a web service but my query is not a standard one. I want to know if a particular date is between two fields in the database.
This is the relevant code:
" <q1:Condition>" +
" <q1:Values>" +
" <q1:Value xsi:type='xsd:string'>" + thedate + "</q1:Value>" +
" </q1:Values>" +
" <q1:Operator>Between</q1:Operator>" +
" <q1:AttributeName>datefield1</q1:AttributeName>"+
" <q1:AttributeName>datefield2</q1:AttributeName>" +
" </q1:Condition>" +
I keep getting this error:
text "soap:ServerServer was unable to process request. 0x80040203 Wrong number of conditions specified for a "between" clause. Platform"
I tried putting an "and" operator in between the two attribute names and nothing seems to work. Can anyone help me? I'm new to XML and kind of over my head here.
This is the relevant code:
" <q1:Condition>" +
" <q1:Values>" +
" <q1:Value xsi:type='xsd:string'>" + thedate + "</q1:Value>" +
" </q1:Values>" +
" <q1:Operator>Between</q1:Operator>" +
" <q1:AttributeName>datefield1</q1:AttributeName>"+
" <q1:AttributeName>datefield2</q1:AttributeName>" +
" </q1:Condition>" +
I keep getting this error:
text "soap:ServerServer was unable to process request. 0x80040203 Wrong number of conditions specified for a "between" clause. Platform"
I tried putting an "and" operator in between the two attribute names and nothing seems to work. Can anyone help me? I'm new to XML and kind of over my head here.