Thanks for that Nigel it worked a treat. I understand that it would be more efficient not to have the months in a database table, but unfortunately for the peice of software we are using the database with requires it!! we are hoping it will be ironed out in a later release tho. Cheers for time anyway!
Jonathan Musto BT Ignite Solutions Telephone - 0113 237 3277 Fax - 0113 244 1413 E-mail - [EMAIL PROTECTED] <mailto:Jonathan.Musto@;bt.com> http://www.technet.bt.com/sit/public British Telecommunications plc Registered office: 81 Newgate Street London EC1A 7AJ Registered in England no. 1800000 This electronic message contains information from British Telecommunications plc which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. -----Original Message----- From: Nigel Wetters [mailto:nigel.wetters@;rivalsdm.com] Sent: Wednesday, October 30, 2002 09:59 To: Musto,J,Jonathan,IVYD3 C Cc: [EMAIL PROTECTED] Subject: Re: Comparing array elements with scalar variables. On Wed, 2002-10-30 at 09:33, [EMAIL PROTECTED] wrote: > I've have some code that prints a column of a database table into a html > form. The column of the table is just the last 6 months of the year: see previous post database lookups are expensive. the last 6 months of the year are fairly constant, you should probably not need to store them in a database. -- Nigel Wetters, Senior Programmer, Development Group Rivals Digital Media Ltd, 151 Freston Road, London W10 6TH Tel. 020 8962 1346 (direct line), Fax. 020 8962 1311 http://www.rivalsdm.com/ <[EMAIL PROTECTED]> -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]