Question
Query of Query
HI, I have a query :
<cfquery name="LocationDataDisplay" datasource="IMV1">
SELECT ID, Cat_ID, Categorie, CategorieB, CategorieC, FR_Info, FR_Tag, EN_Info, EN_Tag, List, Active
FROM LocationData
<cfif IsDefined ("URL.C") is true>
WHERE Active = 'true' and Cat_ID = '#URL.Loc#' and Categorie = '#URL.C#' and List LIKE '%#URL.SC#%'
</cfif>
ORDER BY FR_Tag ASC
</cfquery>
That I want to change for a query of query but my List LIKE '%#URL.SC#%' is not working, I tried contains but not working... ?
<cfquery dbtype="query" name="LocationDataDisplay">
SELECT ID, Cat_ID, Categorie, CategorieB, CategorieC, FR_Info, FR_Tag, EN_Info, EN_Tag, List, Active
FROM LocationData
<cfif IsDefined ("URL.C") is true>
WHERE Active = 'true' and Cat_ID = '#URL.Loc#' and Categorie = '#URL.C#' and List LIKE '%#URL.SC#%'
</cfif>
ORDER BY FR_Tag ASC
</cfquery>
How should I write it?
<cfquery name="LocationDataDisplay" datasource="IMV1">
SELECT ID, Cat_ID, Categorie, CategorieB, CategorieC, FR_Info, FR_Tag, EN_Info, EN_Tag, List, Active
FROM LocationData
<cfif IsDefined ("URL.C") is true>
WHERE Active = 'true' and Cat_ID = '#URL.Loc#' and Categorie = '#URL.C#' and List LIKE '%#URL.SC#%'
</cfif>
ORDER BY FR_Tag ASC
</cfquery>
That I want to change for a query of query but my List LIKE '%#URL.SC#%' is not working, I tried contains but not working... ?
<cfquery dbtype="query" name="LocationDataDisplay">
SELECT ID, Cat_ID, Categorie, CategorieB, CategorieC, FR_Info, FR_Tag, EN_Info, EN_Tag, List, Active
FROM LocationData
<cfif IsDefined ("URL.C") is true>
WHERE Active = 'true' and Cat_ID = '#URL.Loc#' and Categorie = '#URL.C#' and List LIKE '%#URL.SC#%'
</cfif>
ORDER BY FR_Tag ASC
</cfquery>
How should I write it?
AdChoices