May 19th, 2005, 04:13 AM
|
|
Newbie wannabe extrodanaire
|
|
Join Date: Apr 2004
Location: stoke
Posts: 311
Time spent in forums: 2 Days 8 h 29 m 30 sec
Reputation Power: 6
|
|
|
finding values from a list
Hi
Can some can person please help me , im trying to get the results of from a pre-defined list - but its not displaying anything.
BElow is my code - can some one tell me where im going wrong please.
Code:
SELECT DATALENGTH(iL.content) AS iFileSize, i.lowest_node, i.id, i.name, upper(t.status) as status, i.site, segs.title, iL.languageID
FROM itemText i
INNER JOIN itemTextLanguage iL ON i.id = iL.itemID
INNER JOIN site s on i.site = s.code
INNER JOIN tracking t ON iL.trackingID = t.id
INNER JOIN segments segs ON i.lowest_node = segs.id
LEFT OUTER JOIN trackingApproval TA ON iL.trackingID = tA.trackingID
where i.lowest_node IN (<cfqueryparam value="#filterSegmentlist#" cfsqltype="CF_SQL_INTEGER">)
All help is appreiated
Thanks for your help
Andy
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
