This is a migrated thread and some comments may be shown as answers.

No data rendering in control

0 Answers 60 Views
Menu
This is a migrated thread and some comments may be shown as answers.
Ben
Top achievements
Rank 1
Ben asked on 03 Jun 2009, 03:01 PM
The control renders but in only 4 pixels as a block. If i manually enter items into the control then they show up, however when i'm trying to use my datasource the items don't. Heres my query...i have done something similar to this in the past with the same control and it worked, however this is not. I'm almost certain it might be my query so i figure a 2nd pair of eyes looking at it might notice something i haven't?
select 0 [id],'Select a Location'[Name],0 [ParentID],0 [Realid] 
-- 
union 
-- 
select 2 [id],'Dispatch'[Name],0 [ParentID],-2 [Realid] 
-- 
union 
-- 
select 3 [id],'Myself'[Name],0 [ParentID],-3 [Realid] 
-- 
union 
-- 
select 4 [id],'Another Rep'[Name],0 [ParentID],-4 [Realid] 
-- 
union 
-- 
select 5 [id],'Queue'[Name],0 [ParentID],-5 [Realid] 
-- 
union 
-- 
select 6 [id],'Close'[Name],0 [ParentID],-6 [Realid] 
-- 
union 
-- 
--Reps 
select (id+4)id ,Name,4 [ParentID],id [Realid] 
from tbluser  
where id > 1 and isrep=-1  
-- 
union 
-- 
--Queues 
select (id+4)id,Name,5 [ParentID],id [Realid] 
from tblqueue 
where (inactivedate is nulland isrepspecific=0 and id<>-2147483645 and Name<>'Application - Practice Manager' and Name<>'Application - FlowCast' 
--order by id asc 
-- 

No answers yet. Maybe you can help?

Tags
Menu
Asked by
Ben
Top achievements
Rank 1
Share this question
or