Skip navigation
Home/Support/

Forums

Up to Discussions in Advanced Techniques
158 Views 1 Reply Latest reply: Jan 14, 2012 8:13 PM by ccsimmons RSS
ccsimmons Calculating status...
ccsimmons
15 posts since
Feb 13, 2005
Currently Being Moderated

Jan 12, 2012 4:14 PM

SELECT IN query using ormExecuteQuery()

I'm trying to do a SELECT IN query using ormExecuteQuery().  Following is the code I have:

 

Categories = ormExecuteQuery("from Category where Id IN (?)",[CategoryList]);

 

It only works when there is 1 value in the CategoryList.  i.e. This works:

 

Categories = ormExecuteQuery("from Category where Id IN (?)",[9]);

 

This DOES NOT work:

 

Categories = ormExecuteQuery("from Category where Id IN (?)",[8,9,10]);

 

Help would be greatly appreciated.

Tags: orm, hql

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points
Choose your region
Security Contact Adobe Report piracy EULAs Permissions and trademarks Careers

Copyright © 2011 Adobe Systems Incorporated. All rights reserved.

Reviewed by TRUSTe: site privacy statement

Use of this website signifies your agreement to the Terms of Use and Online Privacy Policy (updated 07-14-2009).