You need to use self raising flour when making muffins silly...
> -----Original Message----- > From: Peter Harrison [mailto:[EMAIL PROTECTED] > Sent: 15 January 2004 14:31 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] NEWBIE - Dividing a string by a > particular charact er > > > <cf_bigWoodenSpoon> > no, no, what you need is a abstraction layer > :D > </cf_bigWoodenSpoon> > > - Peter > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 15 January 2004 14:15 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] NEWBIE - Dividing a string by a > particular charact er > > > Now now....No, it was more like a RUSS type post :-) > > > > > > -----Original Message----- > From: Snake Hollywood [mailto:[EMAIL PROTECTED] > Sent: 15 January 2004 14:18 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] NEWBIE - Dividing a string by a > particular charact er > > Sorry I think this came across as a bit of a NEIL type post, > I am not trying to tell you that YOU MUST change your > database, if that's the way it has been written then you are > kinda stuck with it until you can rewrite everything that > accesses these tables. But as the solution to do what you > need has already been provided by the others I thought it > would be useful to tell you how to do the system better and > make it more manageable for you. > > Russ Michaels > Macromedia/Allaire Certified ColdFusion Developer > > CFDeveloper > The free resource and community for ColdFusion developer. > http://www.cfdeveloper.co.uk > > Join the CFDeveloper discussion lists. > To subscribe send an e-mail to [EMAIL PROTECTED] > > > > -----Original Message----- > > From: Snake Hollywood [mailto:[EMAIL PROTECTED] > > Sent: 15 January 2004 14:15 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] NEWBIE - Dividing a string by a particular > > charact er > > > > > > Having different prices and dates for one product doesn't matter, > > that's why you have relationships. > > > > E.g > > > > Ptoducts table > > productID > > productDescription > > > > FaresTable > > FareID > > Price > > ProductID > > Tdate > > > > So in your Farestable, you can have multiple fares/dates for one > > product, as they are linked by the productID > > > > > > Russ Michaels > > Macromedia/Allaire Certified ColdFusion Developer > > > > CFDeveloper > > The free resource and community for ColdFusion developer. > > http://www.cfdeveloper.co.uk > > > > Join the CFDeveloper discussion lists. > > To subscribe send an e-mail to [EMAIL PROTECTED] > > > > > > > -----Original Message----- > > > From: James Buckingham [mailto:[EMAIL PROTECTED] > > > Sent: 15 January 2004 12:53 > > > To: '[EMAIL PROTECTED]' > > > Subject: RE: [ cf-dev ] NEWBIE - Dividing a string by a particular > > > charact er > > > > > > > > > Sorry in reply to the DB question. The previous web development > > > company built the DB like this and the client is now > using this in > > > their systems so I'm pretty much stuck with it. > > > > > > I'm guessing it's been built like this because there is different > > > prices and dates for one product so rather than inserting > the same > > > product information over and over again they've crammed the dates > > > and fares into one record. > > > > > > Another area I need to learn about though :) > > > > > > -----Original Message----- > > > From: James Buckingham [mailto:[EMAIL PROTECTED] > > > Sent: 15 January 2004 12:48 > > > To: '[EMAIL PROTECTED]' > > > Subject: RE: [ cf-dev ] NEWBIE - Dividing a string by a particular > > > charact er > > > > > > Great thanks a lot guys for the answer and quick reply. > I'll give it > > > a shot just now. > > > > > > Cheers again, > > > James > > > > > > -----Original Message----- > > > From: Robertson-Ravo, Neil (RX) > > > [mailto:[EMAIL PROTECTED] > > > Sent: 15 January 2004 12:32 > > > To: '[EMAIL PROTECTED]' > > > Subject: RE: [ cf-dev ] NEWBIE - Dividing a string by a particular > > > charact er > > > > > > Any List type function will server you well here... > > > > > > <cfset myList = "�562.50�562.50�587.50�562.50�445.00"> > > > > > > <cfdump var="#ListGetAt(myList,3,"�")#"> > > > > > > [for example] > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > From: James Buckingham [mailto:[EMAIL PROTECTED] > > > Sent: 15 January 2004 12:35 > > > To: '[EMAIL PROTECTED]' > > > Subject: [ cf-dev ] NEWBIE - Dividing a string by a particular > > > character > > > > > > Hi there, > > > > > > I'm currently working on my very first Cold Fusion > project and I've > > > hit a bit of a stumbling block; so I was wondering if any of you > > > veterans out there could help me out :). I'm sure this is very > > > simple!!! > > > > > > I have a field in my DB called fares which contains a > single string > > > in each of the records. The string looks something like this: > > > > > > �562.50�562.50�587.50�562.50�445.00 > > > > > > Each fare is to correspond with a date which is stored in exactly > > > the same way. I've managed to split the date up ok as > this is a set > > > number of 8 characters but the prices could vary a lot so I'm > > > needing to split it up by the � character. > > > I've been looking at the left,mid and right functions but > I've not > > > managed to find anything on how to implement it in this > particular > > > way. Can anyone point me in the right direction? > > > > > > Cheers in advance, > > > JamesB > > > This e-mail is from Reed Exhibitions (Oriel House, 26 The > Quadrant, > > > Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed > > > Business, Registered in England, Number 678540. It contains > > > information which is confidential and may also be > privileged. It is > > > for the exclusive use of the intended recipient(s). If > you are not > > > the intended > > > recipient(s) please note that any form of distribution, > copying or > > > use of this communication or the information in it is strictly > > > prohibited and may be unlawful. If you have received this > > > communication in error please return it to the sender or call our > > > switchboard on +44 (0) 20 89107910. The opinions > expressed within > > > this communication are not necessarily those expressed by Reed > > > Exhibitions. Visit our website at http://www.reedexpo.com > > > > > > -- > > > ** Archive: > > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > > > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > -- > > > ** Archive: > > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > > > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > -- > > > ** Archive: > > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > > > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] For > > human help, e-mail: [EMAIL PROTECTED] > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human > help, e-mail: [EMAIL PROTECTED] > This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, > Richmond, Surrey, TW9 1DL, United Kingdom), a division of > Reed Business, > Registered in England, Number 678540. It contains > information which is > confidential and may also be privileged. It is for the > exclusive use of the > intended recipient(s). If you are not the intended > recipient(s) please note > that any form of distribution, copying or use of this > communication or the > information in it is strictly prohibited and may be unlawful. > If you have > received this communication in error please return it to the > sender or call > our switchboard on +44 (0) 20 89107910. The opinions > expressed within this > communication are not necessarily those expressed by Reed Exhibitions. > Visit our website at http://www.reedexpo.com > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
