August 12th, 2005, 07:45 AM
|
|
Newbie wannabe extrodanaire
|
|
Join Date: Apr 2004
Location: stoke
Posts: 310
Time spent in forums: 2 Days 8 h 25 m 2 sec
Reputation Power: 6
|
|
|
list
Hi i have a list that i have created which is
Code:
SELECT td.status as tdStatus,tu.Status as tustatus,ild.trackingID as dTrackingID,ilu.trackingID as uTrackingID,item.site, item.name, item.width, item.height, item.option1, item.option2, item.option3, item.option4,
ilD.filename AS Dfilename,td.status AS Dstatus, ild.file_size as iDFileSize,ilU.filename AS Ufilename, tu.status as uStatus, ilu.file_size as iuFileSize
FROM itemFlash item
inner join pageHasFlash ph on ph.itemID = item.id
INNER JOIN itemPage p ON ph.pageID = p.id
INNER JOIN templateFlash tmp ON p.templateID = tmp.templateID
INNER JOIN itemFlashLanguage iLd ON item.id = ild.itemID
inner join tracking td on ild.trackingID=td.id
left outer join itemFlashLanguage ilu on item.id = ilu.itemID
left outer join tracking tu on ilu.trackingID=tu.id and iLu.languageID = <cfqueryparam value="#iUserLanguage#" cfsqltype="CF_SQL_INTEGER"> and tu.status = <cfqueryparam value="translated">
WHERE (td.status in (<cfqueryparam value="#liVisibleStates#" cfsqltype="cf_sql_varchar">))
AND (p.id = <cfqueryparam value="#pageID#" cfsqltype="CF_SQL_INTEGER">)
AND (ph.itemNumber =<cfqueryparam value="#attribID#" cfsqltype="CF_SQL_INTEGER">)
AND (tmp.itemNumber =<cfqueryparam value="#attribID#" cfsqltype="CF_SQL_INTEGER">)
but for some reason it doesnt work in my query when i call the variable liVisableStates.
I think it is something to do with the fact that there are no '' seperating the states - but the query works when i put the states in manually into the query.
Code:
SELECT td.status as tdStatus,tu.Status as tustatus,ild.trackingID as dTrackingID,ilu.trackingID as uTrackingID,item.site, item.name, item.width, item.height, item.option1, item.option2, item.option3, item.option4,
ilD.filename AS Dfilename,td.status AS Dstatus, ild.file_size as iDFileSize,ilU.filename AS Ufilename, tu.status as uStatus, ilu.file_size as iuFileSize
FROM itemFlash item
inner join pageHasFlash ph on ph.itemID = item.id
INNER JOIN itemPage p ON ph.pageID = p.id
INNER JOIN templateFlash tmp ON p.templateID = tmp.templateID
INNER JOIN itemFlashLanguage iLd ON item.id = ild.itemID
inner join tracking td on ild.trackingID=td.id
left outer join itemFlashLanguage ilu on item.id = ilu.itemID
left outer join tracking tu on ilu.trackingID=tu.id and iLu.languageID = 120 and tu.status = 'translated'
WHERE td.status in ('built','published','publishedsoon','approved','submitted','rejected')AND (p.id = <cfqueryparam value="#pageID#" cfsqltype="CF_SQL_INTEGER">)
AND (ph.itemNumber = <cfqueryparam value="#attribID#" cfsqltype="CF_SQL_INTEGER">)
AND (tmp.itemNumber = <cfqueryparam value="#attribID#" cfsqltype="CF_SQL_INTEGER">)
I was wondering if someone can shed a light on it
Thanks for your help
Andy
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
