Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
<cfparam name="URL.bureauID" default="0"> <cfquery name="getBureauProjects" datasource="#application.datasource#"> SELECT b.bureauID, b.bureauTitle, p.projectID, p.ProjectName, p.bureauTitle, p.State, p.Archive FROM #REQUEST.BureauTable# b LEFT JOIN #REQUEST.ProjectsTable# p ON p.bureauTitle = b.bureauTitle <!--- no need for cfqueryparam when it's a hard coded value ---> AND p.Archive = 0 WHERE b.bureauID = <cfqueryparam cfsqltype="cf_sql_integer" value="#val(url.bureauID)#"> ORDER BY p.State ASC </cfquery>
<!--- if a project was found ...---> <cfif getBureauProjects.projectID GT 0> <cfoutput query="getBureauProjects" group="state"> <h3>#getBureauProjects.State#</h3> <p><a href="/showProjectRecord.cfm?ProjectID=#val(getBureauProjects.ProjectID)#">#getBureauProjects.ProjectName#</a></p> </cfoutput> <cfelse> <h2>Currently no projects are associated with this bureau. Please check back for future projects.</h2> </cfif>
Add your voice to the tech community where 5M+ people just like you are talking about what matters.