I have a union query like this that gets info from 2 different tables Like this   <cfquery name="getpeople"   datasource="#request.dsn#"    > SELECT  ID,CityName,  SUM(people) AS sump FROM table 1 GROUP by ID,CityName UNION   SELECT  ID,CityName,  SUM(people) AS sump FROM table 2 GROUP by ID,CityName ORDER BY SUM(people) </cfquery> So what I want is the sums from both tables but what I get is the sums of each table. For example I get ID-CityName-sump 1- New York -3 1-New York- 4 2-Chicago -5 2-Chicago -6 What I want is ID-CityName-sump 1-New York- 7 2-Chicago -11 Do I need to do another query after the union query? ... View more

I just migrated my last MS Access database over to SQL Server 8 database. I have  tables with 100-20,000 rows in them. My question is what can I do to improve performance (page load time)? I have pages that are taking 10 seconds to load that took 2 seconds with Access...I expected improvement with MSSQL. I have indexed tables etc... Is there something in the CF code I need to modify also. I am using CF9 ... View more

I have an application that at the end of the day 12:00 midnight I need all session.variables to expire and thus force my users to relogin. WIll this code end all of my user sessions? <cflock scope="Session" timeout="10" type="exclusive">       <cfset structclear(session)> </cflock> ... View more

I have been page caching on my site for years using this code: <cfcache timespan="#CreateTimespan(10, 0, 0, 0)#" directory="D:/websites/mysite/cache/" stripWhiteSpace="true"> This worked great -  it would keep a cached copy in the cache directory and would stay cached for 10 days. Good stuff!! Now I've had to switch servers and up to CF9. I still want to cache my pages but I just cant seem to get it right. I am now using this code <cfcache timespan="#CreateTimespan(10, 0, 0, 0)#"  useQueryString ="true" stripWhiteSpace="true"> But the pages dont cache in the cache directory and they dont seem to load faster as if they were cached. Am I doing his right? Am I even caching the pages? I'd like to keep a copy in my cache directory is that possible? ... View more

I have a CF form that when posted sends an email with an attachment from our website to an email specified in the form. The email is sent using the CFMAIL tag. Pretty straight forward. Now for compliance reasons I need to keep records of what was sent to whom and when. Ideally I'd like to run the emails though our mail server and not the CF server. Is something like that possible? ... View more

I am trying to extract the first letter of a firstname and the first 5 letters off a last name and concatate the two values For example I have a data field with "John Smith" in the field. I want to get the first letter of the first name -  "John" = J I want to get the first 5 letters of the last name- "Smith" = smith and then concatate the 2 values = jsmith another example For example I have a data field with "Reese Witherspoon" in the field. I want to get the first letter of the first name -  "Reese" = R I want to get the first 5 letters of the last name- "Witherspoon" = withe and then concatate the 2 values = rwithe How would I do that ? I think I know how to do each step individually but is there a better way to get the value? ... View more

I have a directory on my server named "documents" that I need to make sure users are authenticated (logged in) before they can access this directory. The directory contains PDF documents. Whats happening is that users are bypassing the log in process and directly accessing documents in this documents directory. When my users log in a SESSION variable "allowin" gets set. Normally I have an application.cfc or application.cfm file that  will redirect the user to the login page if they dont have the session created. For example if a user tried to access the site directly with a link and not log in they would not be allowed in and be redirected to the log in page. Thats because the application runs each time a cfm page runs. But when a user accesses the site at http://www.mysite.com/documents/test.pdf they get in because the application.cfm doesnt run and enforce the SESSION rule. Because there is not an application.cfm file in the documents directory. Any ideas on how to use CF to boot users to a login page that try to access a directory that does not contain an application.cfm or .cfc file? ... View more

I have 5 directories in my site that for organizational purposed I copied into one directory named usersites so they all would be in one place. So I had these 5 directories before the change website1 website2 website3 website4 website5 So before the change when my users accessed my site they would access these directories like this www.mysite.com/website1/mypage.cfm or www.mysite.com/website2/mypage.cfm  etc So now after the change the directories are in the usersites directory at  www.mysite.com/usersites/website1/ I dont want to tell all of my users that they need to change their existing urls from www.mysite.com/website1/pagename.cfm   to  www.mysite.com/usersites/website1/pagename.cfm Is there a way that when one of my users accessess the  old directory that they will automatically be redirected to the new directory? Maybe something in the application.cfm? Just to make sure when a user comes in here www.mysite.com/website1/test.cfm I want them to gets redirected to www.mysite.com/usersites/website1/test.cfm Thank you! ... View more

I have this form with 2 images as submit buttons <INPUT TYPE="image" SRC="assets/images/lgstart_b.png" ALT="Submit Form" name="time_in"> <INPUT TYPE="image" SRC="assets/images/lgstop_bo.png"   ALT="Submit Form" name="time_out"> The problem is I can tget the next page to acknowldge either button. I am using CF9 Here is the form2.cfm page <cfif IsDefined("FORM.time_in.X")> TIME IN <cfelseif IsDefined("FORM.time_out.X")> TIME OUT <cfelse > Nothing </cfif> I get an 'undefined' message only I know I have done this before what am I missing? Here is the form with the  2 images as submit buttons <form action="form2.cfm" method="post">           <table cellpadding="0" cellspacing="5">             <tr>                             <td align="center" class="crewlist_time"><strong>Status</strong></td>                          </tr>             <cfoutput query="get_employees">               <tr>                 <td width="20" align="left"><input type="checkbox"  checked name="Employee_ID" value="#Employee_ID#"/></td>                 <td class="crewlist_cell"> #EMPLOYEE_NAME# </td>                                 <div class="clock">             <div class="clockin">Clock In</div>         <INPUT TYPE="image" SRC="assets/images/lgstart_b.png"   ALT="Submit Form" name="time_in">         </div>           <div class="clockrt">             <div class="clockin">Clock Out</div>               <INPUT TYPE="image" SRC="assets/images/lgstop_bo.png"   ALT="Submit Form" name="time_out">              </div>         </div></cfoutput>         <br>         <br>         </form> ... View more