Got something to say or just want fewer pesky ads? Join us... 😊

Press Ctrl+V on your keyboard, see what comes up, and post it here.







Sussex Nomad

Well-known member
Aug 26, 2010
18,185
EP
$sectors_tbl = new ExternalTable('sectors');
$tmp_sectorSH = $sectors_tbl->findAll("show_on_franchise_id='3'", 'title');
//$sector_SH = array();
foreach ($tmp_sectorSH as $option_SH) {
$sector_SH .= '<li><a href="/?sector='.$option_SH->sector_id.'&investment_amount=&exhibition_id=&keywords=">'.$option_SH->title . '</a></li>';
}
$smarty->assign('sectors_SH',$sector_SH);

Yawn.

Smarty templates, some php going on there I believe?
 




Buzzer

Languidly Clinical
Oct 1, 2006
26,121
select a.*, f.*, d1.description as xDEA, d2.description as xGFC , isnull(r.rel_value,'SCI') as partner, isnull(pd.description,'Head Office') as xpartner
from (select isnull(t1.dim_5,'SCI') as subgrant, s.dim3 as project, s.dim4 as SOF, s.dim5 as DEA, sum(s.amount) as amount, sum(s.donor_amount) as donor_da_amount, 0 as pla_amount, 0 as donor_amount
from aagsctrdcur s
left outer join agltransact t1 on (t1.voucher_no = s.dim6 and t1.sequence_no = s.dim7 and t1.client = s.client)
where s.client = 'SC' and t1.voucher_date between '2011-10-01 00:00:00.000' and '2011-12-31 00:00:00.000'
group by t1.dim_5, s.dim3, s.dim4, s.dim5
union all
select isnull(t.subgrant,'SCI') as subgrant, s.dim3 as project, s.dim4 as SOF, s.dim5 as DEA, 0 as amount, 0 as donor_amount, sum(s.pla_amount) as pla_amount, sum(s.donor_da_amount) as donor_da_amount
from aagscdcur s
left outer join (select t.period, t.account, t.dim_1 as costc, t.dim_2 as project, t.dim_3 as SOF, t.dim_4 as DEA
, CASE t.dim_5 WHEN '' THEN 'SCI' ELSE t.dim_5 END as subgrant, sum(t.amount) as amount
from agltransact t group by t.client, t.period, t.account, t.dim_1, t.dim_2, t.dim_3, t.dim_4, t.dim_5) as t
on (t.account = s.dim1 and t.costc = s.dim2 and t.project = s.dim3 and t.SOF = s.dim4 and t.DEA = s.dim5 and t.period = s.period)
where s.client = 'SC'
and s.period between '201110' and '201111'
group by t.subgrant, s.dim3, s.dim4, s.dim5
) as a
left outer join afxdeagf f on (f.dim_value = a.DEA)
left outer join agldimvalue d1 on (d1.client = 'SC' and d1.attribute_id = '2003' and d1.dim_value = a.DEA)
left outer join agldimvalue d2 on (d1.client = 'SC' and d2.attribute_id = '2058' and d2.dim_value = f.gf_category)
left outer join aglrelvalue r on (r.attribute_id = '2004' and r.att_value = a.subgrant and r.rel_attr_id = '2039')
left outer join agldescription pd on (pd.attribute_id = '2039' and pd.dim_value = r.rel_value and pd.client = 'SC')
where a.project = '0500002' and a.SOF = '84000079' and a.DEA <> '00000'
order by d1.description, pd.description
 










Titanic

Super Moderator
Helpful Moderator
Jul 5, 2003
39,930
West Sussex
Boring...

//TTTNXXB JOB 123456,CLASS=P,MSGCLASS=0,MSGLEVEL=(1,1),NOTIFY=&SYSUID
//BUNDLE EXEC PGM=ADRDSSU,REGION=4096K
//BACKUP DD DSN=TTTN.xxxxxx.LRS.V2R11.BUNDLE,
// SPACE=(CYL,(500,100),RLSE),
// DISP=(NEW,CATLG)
//SYSPRINT DD SYSOUT=X
//SYSIN DD *
DUMP -
DATASET(INCLUDE( -
TTIG.DN00.LRS.VPS.V2R11.LOAD, -
TTIG.DN00.LRS.VSV.V2R11.LOAD, -
TTIG.DN00.LRS.DRS.V2R11.LOAD, -
 












Sam Ovett

The New Manager Bus
1. Those which cover (or purport to cover) all branches of geography, notably the house journals of national academic societies: Annals of the Association of American Geographers (AAAG), Transactions of the Institute of British Geographers (TIBG), and so on.
2. Those which cover geographical sub-disciplines or adjacent inter-disciplinary topics and in which the majority of papers are by geographers, for example HP and ESPL on the physical side and series A and D of Environment & Planning (E&P) on the human side.
3. Those which cover multi- or inter-disciplinary specialisms that are not primarily geographical but to which geographers contribute a substantial minority of papers, for example Water Resources Research (WRR) in the same general area as HP or Int. J. Urban & Regional Research (IJURR) in the same general area as the type-2 Regional Studies.
4. Journals of all-round science, or all-round humanities. In the natural sciences Nature and Science are by far the most prestigious of these, with PRSA and its stablemates in the second rank. Contrary to the impression Thrift gives, very few physical geographers publish in these journals and those who do are generally co-author with non-geographers.
 










8ace

Banned
Jul 21, 2003
23,811
Brighton
Code:
	FMatrix localToWorldMat = RenderSurface->LocalToWorld();

	FVector minXYZWorld = localToWorldMat.TransformFVector(minXYZ);
	FVector2D minScreenPosition = TheLocalPlayer->Project(minXYZWorld);
	float const minScreenX = (0.5f + (minScreenPosition.X * 0.5f)) * sizeX;
	float const minScreenY = (0.5f - (minScreenPosition.Y * 0.5f)) * sizeY;
 


Rookie

Greetings
Feb 8, 2005
12,324
[2007] EWCA Civ 791

yep exciting I know
 


pasty

A different kind of pasty
Jul 5, 2003
31,040
West, West, West Sussex
select a.*, f.*, d1.description as xDEA, d2.description as xGFC , isnull(r.rel_value,'SCI') as partner, isnull(pd.description,'Head Office') as xpartner
from (select isnull(t1.dim_5,'SCI') as subgrant, s.dim3 as project, s.dim4 as SOF, s.dim5 as DEA, sum(s.amount) as amount, sum(s.donor_amount) as donor_da_amount, 0 as pla_amount, 0 as donor_amount
from aagsctrdcur s
left outer join agltransact t1 on (t1.voucher_no = s.dim6 and t1.sequence_no = s.dim7 and t1.client = s.client)
where s.client = 'SC' and t1.voucher_date between '2011-10-01 00:00:00.000' and '2011-12-31 00:00:00.000'
group by t1.dim_5, s.dim3, s.dim4, s.dim5
union all
select isnull(t.subgrant,'SCI') as subgrant, s.dim3 as project, s.dim4 as SOF, s.dim5 as DEA, 0 as amount, 0 as donor_amount, sum(s.pla_amount) as pla_amount, sum(s.donor_da_amount) as donor_da_amount
from aagscdcur s
left outer join (select t.period, t.account, t.dim_1 as costc, t.dim_2 as project, t.dim_3 as SOF, t.dim_4 as DEA
, CASE t.dim_5 WHEN '' THEN 'SCI' ELSE t.dim_5 END as subgrant, sum(t.amount) as amount
from agltransact t group by t.client, t.period, t.account, t.dim_1, t.dim_2, t.dim_3, t.dim_4, t.dim_5) as t
on (t.account = s.dim1 and t.costc = s.dim2 and t.project = s.dim3 and t.SOF = s.dim4 and t.DEA = s.dim5 and t.period = s.period)
where s.client = 'SC'
and s.period between '201110' and '201111'
group by t.subgrant, s.dim3, s.dim4, s.dim5
) as a
left outer join afxdeagf f on (f.dim_value = a.DEA)
left outer join agldimvalue d1 on (d1.client = 'SC' and d1.attribute_id = '2003' and d1.dim_value = a.DEA)
left outer join agldimvalue d2 on (d1.client = 'SC' and d2.attribute_id = '2058' and d2.dim_value = f.gf_category)
left outer join aglrelvalue r on (r.attribute_id = '2004' and r.att_value = a.subgrant and r.rel_attr_id = '2039')
left outer join agldescription pd on (pd.attribute_id = '2039' and pd.dim_value = r.rel_value and pd.client = 'SC')
where a.project = '0500002' and a.SOF = '84000079' and a.DEA <> '00000'
order by d1.description, pd.description

In a similar vein....

SELECT '<repDate>' as Rep_Date, dbo.Files_Processing.FileName, dbo.JobFileTypes.Description as 'Sub-Stream', CONVERT(nvarchar(8), dbo.Files_Processing.DateTimeEnteredIntoSystem, 3) AS DateIn, CONVERT(varchar(5),
dbo.Files_Processing.DateTimeEnteredIntoSystem, 8) AS TimeIn, 'FILLER' as Filler3, 'FILLER' as Filler4, 'FILLER' as Filler5, 'FILLER' as Filler6, dbo.PackCounts.PageCount AS 'PCL_Pages', dbo.PackCounts.SheetCount AS 'Printed_Sheets',
CASE WHEN dbo.JobFileTypes.Plex = 'Duplex' THEN dbo.PackCounts.SheetCount * 2 ELSE dbo.PackCounts.SheetCount END AS 'Printed_Images',
dbo.PackCounts.PackCount as 'Packs',
'FILLER' as Filler7, 'FILLER' as Filler8, 'FILLER' as Filler9, 'FILLER' as Filler10, 'FILLER' as Filler11, 'FILLER' as Filler12, 'FILLER' as Filler13, 'FILLER' as Filler14, 'FILLER' as Filler15, 'FILLER' as Filler16,
CASE WHEN dbo.PackCounts.Tray1 IS NULL THEN 0 ELSE dbo.PackCounts.Tray1 END AS Tray1,
CASE WHEN dbo.PackCounts.Tray2 IS NULL THEN 0 ELSE dbo.PackCounts.Tray2 END AS Tray2,
CASE WHEN dbo.PackCounts.Tray3 IS NULL THEN 0 ELSE dbo.PackCounts.Tray3 END AS Tray3,
CASE WHEN dbo.PackCounts.Tray4 IS NULL THEN 0 ELSE dbo.PackCounts.Tray4 END AS Tray4,
'FILLER' as Filler17,
CASE WHEN dbo.JobFileTypes.Hopper1 IS NULL THEN 0 ELSE dbo.PackCounts.Hopper1 END as Hopper1, CASE WHEN dbo.JobFileTypes.Hopper2 IS NULL THEN 0 ELSE dbo.PackCounts.Hopper2 END as Hopper2, CASE WHEN dbo.JobFileTypes.Hopper3 IS NULL THEN 0 ELSE dbo.PackCounts.Hopper3 END as Hopper3,
CASE WHEN dbo.JobFileTypes.Hopper4 IS NULL THEN 0 ELSE dbo.PackCounts.Hopper4 END as Hopper4, CASE WHEN dbo.JobFileTypes.Hopper5 IS NULL THEN 0 ELSE dbo.PackCounts.Hopper5 END as Hopper5, CASE WHEN dbo.JobFileTypes.Hopper6 IS NULL THEN 0 ELSE dbo.PackCounts.Hopper6 END as Hopper6,
CASE WHEN dbo.JobFileTypes.Hopper7 IS NULL THEN 0 ELSE dbo.PackCounts.Hopper7 END as Hopper7, CASE WHEN dbo.JobFileTypes.Hopper8 IS NULL THEN 0 ELSE dbo.PackCounts.Hopper8 END as Hopper8, CASE WHEN dbo.JobFileTypes.Hopper9 IS NULL THEN 0 ELSE dbo.PackCounts.Hopper9 END as Hopper9,
'FILLER' as Filler18, 'FILLER' as Filler19, 'FILLER' as Filler20,
1 as 'Files_Received', 'FILLER' as Filler25, 'FILLER' as Filler26, 'FILLER' as Filler27,
dbo.PackCounts.PageCount AS 'Total_PCL_Pages', dbo.PackCounts.SheetCount AS 'Total_Printed_Sheets',
CASE WHEN dbo.JobFileTypes.Plex = 'Duplex' THEN dbo.PackCounts.SheetCount * 2 ELSE dbo.PackCounts.SheetCount END AS 'Total_Printed_Images',
dbo.PackCounts.PackCount as 'Total_Packs'
FROM dbo.Files_Processing LEFT OUTER JOIN
dbo.JobFileTypes ON dbo.Files_Processing.FileName LIKE '%' + REPLACE(dbo.JobFileTypes.FileMask, '_', '!_') + '%' ESCAPE '!' LEFT OUTER JOIN
dbo.PackCounts ON dbo.Files_Processing.ID = dbo.PackCounts.ProcessFileID
WHERE (dbo.Files_Processing.ClientID = 3) AND (dbo.Files_Processing.SubClientID = '17') AND (dbo.Files_Processing.DateTimeEnteredIntoSystem BETWEEN
'<fromDate> 16:30:01' AND '<toDate> 16:30:00') AND dbo.JobFileTypes.Description = '<Client_Name>' AND (dbo.Files_Processing.FileName NOT LIKE '%TEST%')


Easy to spot those posting whilst at work..... :laugh:
 
Last edited:








Albion and Premier League latest from Sky Sports


Top
Link Here