PCFormat Forum Archive

Hi, I got into development 2 years ago at the age of 31 ... so your never too old. The IT industry is wide open to anybody wanting to work. Your choice of dev language is less important than your OS. I develop in PHP for LINUX. I'm currently doing my BSC with UNISA (started this year) and they offer...

I think ISNULL will probably be more optimised than COALESCE, since it is basically an IF..ELSE, while COALESCE compares more to CASE..WHEN..END. One thing to remember about SQL clients is that they do a pre-optimize on your query before its given to the server. I use COALESCE on a rather large DB ...

update Table3 set SomeField2 = (select SomeField from #test where #test.ID = Table3.ID ); Update on JOINS is not SQL standard and this appears what you are trying to do: UPDATE Table3 SET SomeField2=(SELECT SomeField FROM #test WHERE #test.ID = Table3.ID LIMIT 1) WHERE ID IN (SELECT ID FROM #test);...

Hi I'm trying to learn PHP but i'm about to blow a gasket! The reason i want to do this is when the page loads i dont want the PHP code to run it must only run after i pressed a button. The stupid If statement doesnt work! how do i make PHP code only run when i press a button. ? Hi. I'm a PHP devel...

Hi, we use Nagios to Monitor 11 servers and two remote PC's. I've only just started adding in monitoring myself but it basically works with scripts that it periodicaly calls and then responds to each ones exit code. I would not recomend Nagios unless you got programming experience in non-Microsoft l...