lightinthedark

purdy :-)

I expect you'll need to either find some common trait (eg that they're all of class "module" or some such) and specify a css rule that targets that class, or find all the ids that are used and treat them individually. I'd say the first approach is better if you can find some unifying feature. Firebug in firefox will help you enormously as you can click elements on the page to see their attributes and which styles are applied to them and even try out adding rules etc. Without seeing the actual page it's hard to be more specific.

My 2pence: * None of the column names is underlined: the "session_id" and "client_id" column names have an underscore in them instead of a space because you aren't allowed to have spaces in column names. * Column names are not generally case sensitive ("client_id" is the same as "client_ID") but it couldn't hurt to make sure that the column names listed in phpmyadmin look the same as the columns listed in that error message. * If not all the columns listed in that error are present in the jos_session table when you look in phpmyadmin then you could try to modify the table has them * If you've still got your original download of Joomla 1.0 you may be able to look in the installation folder then sql then joomla.sql and find the structure for the jos_session table. If you find that you could drop the existing table and re-run the query from your original installation and see if that puts things back to how they should be (nothing of permanent importance is in jos_session, so this should be pretty safe... but you should always backup before doing anything that might cause harm) * I'd guess this could only have happened if you've changed something on the server or maybe installed a new component/module. Maybe you accidentally (somehow) installed a 1.5 component and it altered the database structure? * Maybe this is your server's way of telling you it wants you to upgrade to Joomla 1.5 and perhaps you should take the hint? Sorry I can't offer a more concrete solution, but hopefully this gives you some directions to explore.

Thought it was really powerful. Good find. On a lighter note, did you notice how the UK did all its test on the other side of the planet from our home? Given that it was (unfortunately) going to happen _somewhere_, I think someone made a good call there.

Well, it doesn't make my eyes bleed with flashy wizzy wassnames and doodas, which I count as a good thing, but an 8 year old may not. I guess it all comes down to target audience. Who is the site for? If it's for adults (parents) you are probably about right with what you have. If it's for the kids, then a few more colourful / interesting things might be nice (multiple pics instead of one big one, etc). Different users == different desires, so survey your market a little more widely I'd suggest (assuming that edugeekers aren't your market). Best of luck. :-Dave

Am a regular visitor to onemorelevel. Red remover was a good game. The third bonus level in the dark was probably the hardest to get gold on. Personally, I've had a soft-spot for Hex empire (Risk-ish) for a while along with Colour shift (puzzle-ish) depending on what mood I'm in.

Hi, Sorry for my earlier comment which has since been deleted due to the trollish nature of it (grumpy morning). In response to the question "Who actually cares about the correct use of apostrophe's ?" (also since removed): I do, and so do many other people. Apostrophes can change the meaning of a sentence, and when misused are a "mental speed bump" when reading. It's just more pleasant to read a gramatically correct question. Sorry if my original terse response caused offense. Meanwhile, on the subject of your original question, I refined the search that I originally suggested, and have managed to find what looks to be a promising document which seems to provide reasonably detailed information on what merseyside police would like a cctv system to provide: http://www.merseyside.police.uk/Docs/sefton/cctv.pdf and north yorkshire police (possibly the same document based on a quick skim) http://www.islandautomatics.co.uk/cctv35.doc If those don't provide you with all the information you need then I would have to agree with JJonas that the police are probably the best people to ask. If you don't want to talk to the police (for whatever reason), I have a friend who is working on a CCTV contract at the moment; I could ask him if he knows anything that might help you. Best of luck sorting this out.

That's quite special

Alternatively (and I know it's a cliche) use firefox (probably opera too). In FF if you use +<+> or +<-> the page and everything on it is scaled up/down.

If you're a newbie to MSSQL server management then I'd strongly suggest that anything you do there you do first on a test / sample database, not live data. In theory you should be able to backup SIMS and restore the database under a different name then be able to poke that database as much as you like with minima risk to the SIMS db. Even better would be if you could do the restore on a physically separate box as that (I think) eliminates any risk to the live db. Depending on your long-term goals here it may be worth finding out any licensing issues that may trip you up later (Capita can be quite protective of "their" database schema so I hear). The last thing you want is to spend time creating something that you are then told you're not allowed to use. You might want to investigate using the commandreporter.exe tool (allows you to run SIMS reports from the DOS prompt) as an alternative way of extracting your data. Good luck finding your way. I hear that the database is an unholy mess of hundreds of barely normalised tables. The commandreporter may actually end up being easier to use (though slightly less flexible), and still gives you access to SIMS's internal ids for some fields if you need them if you export as xml. Good luck. Hello :-Dave

With great power comes great responsibility ... and you're giving this to teachers How good are your backups? How good is your support agreement? Hello :-Dave

@FABEnterprises: In this context "FOR XML PATH" is being used to compensate for MSSQL not having a "GROUP_CONCAT" function like MySQL does which allows for multiple rows to be combined into a single column on a single row. It takes the data from the SELECT inside the REPLACE and puts it all as one line of text which REPLACE then formats a bit more nicely ... in theory. Pretty clever way of bypassing some of MSSQL's limitations if you ask me. @Penfold: As I'm sure you're aware you shouldn't be poking the SIMS database. Naughty naughty. As for the query, it looks ok to me (though I'd have indented it differently :-P ) . and I see no reason why it shouldn't run fine. Really. I expect that if I ran this exact query on our server it'd come up with half a dozen nicely formated rows. Have you tried running just the subquery in the REPLACE on its own? Building up the whole query bit by bit? If you make any progress I'd be very interested to know how you get on. Another alternative is to use the commandreporter tool to grab all the relevant data to a csv or some such then import it into a database that allows you to do useful things like GROUP_CONCAT ... such as MySQL. Sorry it's not a more helpful answer. [edit] Looking at the reporting options within SIMS, it seems entirely possible to get the multi-row version of what you are after by using subreports and the like. Is it too much hardship to manually copy the UPNs for a contact's multiple children into a single entry/cell/whatever ? I know it's a manual process and therefore sucks, but it could be a heck of a lot easier in the short term. I guess the question is: how often are you going to need to do this? [/edit] [edit2] Having just run a report that I think gets the data you're after (but on multiple lines per contact) I get quite a few results, so maybe a manual process isn't a good fit. If you export the results of such a report to csv or xml then I'm sure you could use any number of linux-based text editing tools (sed, awk, etc.) to post-process the result list. Heck, I'm pretty sure that Excel has some sort of mechanism to do this (pivot tables?) if you get the data in there. Basically I'm saying that this may be a cat better skinned outside of MSSQL. [/edit2]

Woo yeah! Go Tim :-D

So bad it took a second reading to get it.

IE8 on xp core2duo + slashdot = dog slow but no crash.