RE: cfmx stopped working after installing XP SP2 - any ideas?

2004-09-09 Thread Kevin Webb
I experienced a simliar issue. CFMX was working for some time and after several Win 2K Server updates it stopped.I uninstalled CFMX, re-installed and not change, I un-installed removed registry entries and reinstalled and no change. I still have not figured it out.Macromedia web site

RE: SQL Freetext

2004-02-15 Thread Kevin Webb
I have not done any full text search like you have, but I did notice that there is a comma after the first INNER JOIN.I have written many queries with joins and have not used a comma after an inner join.that is probably your issue. SELECT name, FROM table1 as ft_tbl, table2 as ft_tbl2 INNER

RE: another dateDiff bug

2003-12-13 Thread Kevin Webb
You don't have to do any rounding.It sounds like all of you are making this in to a larger problem then it is.If we know that 1 hour is lost because of the time change then why not get the number of hours between days.So for the calcuation, do the DateDiff for the days in question and return the

RE: T-SQL division drops the decimal?

2003-08-01 Thread Kevin Webb
Kevin Webb -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 6:08 AM To: CF-Talk Subject: RE: T-SQL division drops the decimal? Joshua, I bump into this all the time. You said it is a numeric field but what is the definition of your numeric field