Website design and marketing news, hints and tips
Archive for April, 2010
SQL – update records in one table based on values in another
Apr 29th
After messing around for a while to figure out a way to do this, eventually I figured it out using the EXISTS clause.
Here is an example :
UPDATE tbl1
SET tbl1_field = ( SELECT tbl1_field
FROM tbl1
WHERE tbl.tbl1_id = tbl2.tbl2_id)
WHERE EXISTS
( SELECT tbl1_field
FROM tbl1
WHERE tbl.tbl1_id = tbl2.tbl2_id);
iPad Update, Cross Platform Compatibility
Apr 13th
The iPad from Apple is an exciting new bit of kit – kind of a cross between a smartphone and a laptop.
The equipment has now been launched in the States, so us Brits are eagerly anticipating news of a release date here – there is a rumour going round that it could be the 26th April.
We are especially keen to get our hands on one as we are currently developing a number of iPad specific projects.
Nowadays it is important that businesses consider the range of different devices that can be used to access the web – does your existing website work as its meant to on an iPhone or Blackberry for example? What about on a 1080 HP high definition monitor – does the site look small and isolated in the middle of the screen? Perhaps your site might even appear differently on a Mac from a PC. In this situation, it is possible a percentage of your site visitors will not see your site as intended and this could reflect badly on the professionalism of your business.
We are experts in producing or converting sites so they appear correctly on any piece of equipment, through any software. If this interests you, why not give one of our team a call for a more detailed chat or some advice – 01253 297661.