robn
Posts: 70
|
| Posted: 07/10/2007, 2:29 AM |
|
Hi
I'm sure this is something simple and straight forward to bu just can't work it out. I've used ccdlookup many times without issue, but I can't get this one to work.
The select statement is very long and therefore appears to exceed the maxium length of the row of code within CCS therefore I need to write the select
over 2 rows. But can't figure out a way to do it, I've tried &, " + at the end of the first row but can't seem to get it to carry on with the select statement onto the second row.
Basically I want to go from this (this is a cut down example)
If CCDLookUp("sum (cast (Sec2_1 as int)+ cast(Sec2_2 as int) ) as total","tblcareroles inner join dbo.tblUserRole on dbo.tblRoles.RoleID = tblUserRole.RID","UID=" & DBconnection1.ToSQL(session("userid"),ccsInteger), DBconnection1) = 0 Then
tblSupervisionReport.Panel2.Visible = false
End if
To something like this
If CCDLookUp("sum (cast (Sec2_1 as int)+"
"cast(Sec2_2 as int) ) as total","tblroles inner join dbo.tblUserRole on dbo.tblRoles.RoleID = tblUserRole.RID","UID=" & DBconnection1.ToSQL(session("userid"),ccsInteger), DBconnection1) = 0 Then
tblSupervisionReport.Panel2.Visible = false
End if
Any help would be much appreciated
thanks in advance
RobN
|
