Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to modify a query?

Status
Not open for further replies.

Nico876

Programmer
Dec 19, 2004
7
0
0
DE
If I use the sendDocQuery-Function in Get-Resources, I got e.g. a query like this:

SELECT lPortfolioItemId FROM amPortfolio WHERE lPortfolioItemId = 123456

This statement works.
But, if I try to grab more then 1 lPortfolioItemId's, because they are softwareinstallations related to the asset, I got a problem. I mean, sendDocQuery creates then a query like this:

SELECT lPortfolioItemId FROM amPortfolio WHERE (lPortfolioItemId = 123456) AND (lPortfolioItemId = 654321)

This doesn't works, because of the AND-condition.
I need there a OR-condition.

How can I transform, within sendDocQuery, the AND-condition in a OR-condition?

Any help or input would be appreciated. Nick
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top