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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
