yer right Tony..it's supposed to to produce a decimal value ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED]
--------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 1:23 PM Subject: RE: I sent this before and got no response...maybe someone can help? > wont that line... > > <cfset result = numerator/denominator> > > perform a numerator divided by denominator operation? > > wouldn't you do a concatenation of some sort like > > <cfset result = '#numerator#' & / & '#denominator#'> > > or something like that, that was syntactically correct? > > > tony weeg > uncertified advanced cold fusion developer > tony at navtrak dot net > www.navtrak.net > office 410.548.2337 > fax 410.860.2337 > > > -----Original Message----- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 13, 2003 4:26 PM > To: CF-Talk > Subject: Re: I sent this before and got no response...maybe someone can > help? > > > I'd convert all the data to decimal values and convert back to fractions > if you have to for display purposes. > > YOu could do this with CF if your SQL is a tad weak like mine: > > 1) Select all records with the fractions > 2) Loop over the results > 3) Do the math...use ListGetAt(column,"1","/") for numerator and > ListGetAt(column,"2","/") for the denominator....then <cfset result = > numerator/denominator> > 4) Update record with new decimal value > > NOTE: You may need to add a new blank column with a float datatype to > put the new values in....then once all updating is done...toast the old > column and change the name of the one you put the new data in to the > name of the original column. > > I know this is a tad clumsy...but it will get ya there. > > HTH > > Cheers > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > --------------------------------------------------------- > Macromedia Associate Partner > www.macromedia.com > --------------------------------------------------------- > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > ----- Original Message ----- > From: "Che Vilnonis" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, August 13, 2003 12:56 PM > Subject: I sent this before and got no response...maybe someone can > help? > > > > In my db I've got a varchar column called 'width'. > > It has values like 3/4" or 5/8", etc. > > > > I'd like to write a where clause in a SQL query that does something > > like this: > > > > ---------- > > WHERE 0=0 > > AND (WIDTH BETWEEN #FORM.Width1# AND #FORM.Width2#) > > [i.e. -- (AND (0.75 BETWEEN 0.5 AND 1))] > > ---------- > > > > What do I need to do to make this work? Convert? Cast? > > I don't know how to make SQL convert 7/8" into 0.875. > > > > Che Vilnonis > > Application Developer > > Advertising Systems Incorporated > > 8470C Remington Avenue > > Pennsauken, NJ 08110 > > p: 856.488.2211 > > f: 856.488.1990 > > www.asitv.com > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4