Re: A little help with some code and theory

["paross1" <webforumsuser@xxxxxxxxxxxxxx>]

Not sure if this is what you are looking for, but something like this should 
give you the apps in workstationApps that are still available (have fewer 
"installs" than maxConcurrentInstalls).

 SELECT w.*
 FROM workstationApps w
 WHERE (SELECT COUNT(wi.appID)
 FROM workstationAppIndex wi
 WHERE wi.appID = w.id) < w.maxConcurrentInstalls
 <cfif isDefined("form.searchCriteria")>
 AND w.searchType like '%#form.searchCriteria#%'
 </cfif>

 (NOTE: I'm not sure what you meant by [i]#form.searchType# like 
'%#form.searchCriteria#%'[/i] except that you probably meant to say something 
like [i]searchType like '%#form.searchCriteria#%'[/i], or something like it)

 Phil