Search results for query: *

In regard to CreateODBCDate that's a date converter in coldusion so basically I am adding that 75 days in coldfusion and not SQL.

Those #s are for output in ColdFusion and that's why my query is saying CFQUERY. The query works fine except the part that I would like to add to it. I have not clue how to integrate that IF ELSE with my query. I'm using SQL 2000.

Below is my query. Thx for taking your time on this. <CFQUERY datasource="PGI" name="GetWorkflow"> SELECT ClientDB.CustNum, PlanDB.PlanName, PlanDB.PlanCodeId, ClientDB.Company, AnnualDB.RecNum, AnnualDB.ClientId, AnnualDB.PlanId, AnnualDB.PlanYrEnd...

You are right. here is what i exactly want: If (Date800 <> '' or Date800 IS NOT NULL) THEN PlanYrEnd <= #CreateODBCDate(DateAdd("d",75,Back5Months))# ELSE PlanYrEnd <= #CreateODBCDate(Back5Months)# End But I can't just put this on my WHERE clause...

Now how can I integrate this logic with my query? If (Date800 = '' or Date800 IS NULL) THEN PlanYrEnd <= #CreateODBCDate(DateAdd("d",75,Back5Months))# ELSE PlanYrEnd <= #CreateODBCDate(Back5Months)# End

I changed <> "" to <> '' and worked and now let try the rest of it.

thx for the replies. i'm getting this error when using <> "": Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot use empty object or column names. Use a single space if necessary. The error occurred on line 158.

I would like to add to my query the following logic but I don't know how to right it: WHERE IF Date800 IS NOT NULL THEN (Date802 + 75 Days) < Date803 END Can someone please help me with my situation? Thanks, Mike

I fixed this by unchecking this option: Cache web server paths Caches page paths on single-site web server installations, which provides improved performance. You must restart the server for this change to take effect. Thanks, Mike

Hello, I am running IIS 6 and ColdFusion MX in one machine. I am hosting about 5 domain names with my IIS such as xyz.com, abc.com, def.com, ghi.com, and jkl.com. One of these 5 domain is all the way written with basic HTML language so ColdFusion is not used in this domain and I don't have any...

Here is my final code and it's working perfectly: <cfset myList = ""> <CFIF IsDate(Date303)> <cfif listLen(myList) is 0> <cfset myList = DateFormat(Date303, "YYYYMMDD")> <cfelse> <cfset myList = myList & ", " & DateFormat(Date303, "YYYYMMDD")> </cfif> </CFIF>...

I got this to work after outputing the data: Please see my other post under coldfusion: http://www.tek-tips.com/viewthread.cfm?qid=1001565 Thanks everyone for all the suggestions :) Mike

I like your idea a lot and I am going to change my codes :)

and here is the rest of it: <cfset myList = ListSort(Replace(myList,"/", "", "ALL"),"numeric","desc")> <CFSET myList = ListGetAt(myList,1)> <CFSET myList = Left(myList, 3) & "/" & Mid(myList,4,2) & "/" & Right(myList,2)>

I think I got it to work: <cfset myList = ""> <CFIF IsDate(Date303)> <cfif listLen(myList) is 0> <cfset myList = DateFormat(Date303, "MM/DD/YY")> <cfelse> <cfset myList = myList & ", " & DateFormat(Date303, "MM/DD/YY")> </cfif> </CFIF> <CFIF IsDate(Date304)>...

this is not smart enough to sort by year!

Thank you guys for the replys. SQLSister, you are correct. I meant the largest of date1, date2, date3, and date4 from each individual record.

Let's say I have a table which has records like this: ID Date1 Date2 Date3 Date4 OtherFields... 1 2/23/03 4/15/03 3/11/03 3/18/05 .............. 2 2/24/03 2/10/05 4/12/03 3/15/03 .............. 3 NULL 3/12/03 2/11/03 3/31/03 .............. Is it possible to find the largest...

ListSort won't work with Date!

Is there any function to find the greatest date on a list?