<CFQUERY DATASOURCE="xx" NAME="DispState" cachedwithin="#createTimeSpan(0,0,0,-1)#"> SELECT distinct StateTbl.StateID, StateTbl.StateName FROM StateTbl LEFT JOIN CityTbl ON CityTbl.StateID = StateTbl.StateID LEFT JOIN ChurchTbl ON ChurchTbl.ChCityID = CityTbl.CityID WHERE ChurchTbl.ChurchName <> "null" and ChurchTbl.ChurchStatus = 1 and CityTbl.CityStatus = 1 and StateTbl.StateStatus = 1 </CFQUERY>
|Coldfusion graceful timeout||3||51|
|Passing value to a stored procedure||8||91|
|Converting a Coldfusion/ms-access application to a Coldfusion/mysql application.||42||36|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
25 Experts available now in Live!