RE: Adding Small sections of a query

: Travis Haley [mailto:[EMAIL PROTECTED] Sent: Tuesday, 2 October 2007 3:37 PM To: CF-Talk Subject: RE: Adding Small sections of a query The date part of the datetime is the same the time part differs but the time part is irrelevant to this report. I was able to get this to work by dropping the date

Adding Small sections of a query

, Travis Haley, 100.00, 203 1234, Travis Haley, 6.00, 207 1234, Travis Haley, 21.00, 213 This is done to allow me to run a report on expense type and get what I need to pay in taxes. (I hate taxes lol) Anyway now that I'm trying to make a General Ledger I am trying to combine these back together

RE: Adding Small sections of a query

- From: Travis Haley [mailto:[EMAIL PROTECTED] Sent: Monday, 1 October 2007 4:43 PM To: CF-Talk Subject: Adding Small sections of a query I am not sure the best way to phrase this question but I'll try here. I have a table that records checks I am breaking the check down in the database to show where

RE: Adding Small sections of a query

:55 they are not equal and therefore the sum wont add them I tried taking the date out of the group by statement and get: You tried to execute a query that does not include the specified expression 'pur_Date_Purchased' as part of an aggregate function. Travis Haley -Original Message- From

RE: Inserting data into a word document

Why not use a pdf is there a specific reason for word? If it is for formatting I had the same problem and used extra document info fields to do this. Travis Haley -Original Message- From: George Linderman [mailto:[EMAIL PROTECTED] Sent: Monday, October 01, 2007 5:05 PM To: CF-Talk

RE: Adding Small sections of a query

But I need the date, should I run this in a second query? Travis Haley -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, October 01, 2007 6:45 PM To: CF-Talk Subject: Re: Adding Small sections of a query Remove the date from the query

RE: Adding Small sections of a query

BY. Travis Haley -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, October 01, 2007 7:38 PM To: CF-Talk Subject: Re: Adding Small sections of a query Which date do you want? You have multiple entries - which one should the query return? On 10/2/07, Travis Haley [EMAIL

mailmerge w/ cf8 and pdf

of a paragraph into a variable then filling the form with this variable but the code is messy and the output was not always the way I wanted it. The .pdf would not adjust the text around the form elements so the flow of the letter had a lot of extra spaces. Travis Haley

RE: Regular timeout

Do you declare you application variable with this amount of time? Travis Haley Haley Computer Solutions 2749 E. Nichols Cir Centennial, CO 80122 P: (303) 694-8050 F: (303) 779-0335 -Original Message- From: Ian Rutherford [mailto:[EMAIL PROTECTED] Sent: Monday, September 24, 2007 11:01

RE: Regular timeout

Do you use IIS if so maybe your keep alives are not enabled this causes session timeout I never measured the time though I thought it was faster then 3 hours. Travis Haley -Original Message- From: Ian Rutherford [mailto:[EMAIL PROTECTED] Sent: Monday, September 24, 2007 11:49 AM To: CF

RE: CFDocument Question

linecount = linecount + 1 until you reach the page height then insert the pagebreak and reset linecount to 0, repeat hope that helps Travis Haley Haley Computer Solutions -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Monday, September 24, 2007 12:00 PM To: CF-Talk

RE: Security Questions

Yes have those Java guys start setting up YOUR Coldfusion server for their Three Tiered Security LoL Travis Haley Haley Computer Solutions -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, September 24, 2007 12:16 PM To: CF-Talk Subject: Re: Security

table union

I am trying to create a report that will show me all the checks I have written on my system in numerical order, the problem is I have my checks stored in two different tables in the database. These two tables split up expense checks and client checks, both tables have quite different data,

RE: table union

I am using an access database, I could create a temp table inside the database run the select's run the inserts, then delete all info from the table, is that what you are suggesting? I did index the date fields and got the original union query down to 30 seconds. Travis Haley Haley Computer

doubble post

Sorry about the double post I don't know how that happened Travis Haley Haley Computer Solutions 2749 E. Nichols Cir Centennial, CO 80122 P: (303) 694-8050 F: (303) 779-0335 ~| Get involved in the latest ColdFusion

RE: table union

There are 4000 entries currently and growing every check we write go's into one of the two tables. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 12:09 PM To: CF-Talk Subject: RE: table union I'm not sure about temp tables in access. If my

RE: table union

I think all the time is in the UNION statement because running these queries without the union I get about 23ms to run the whole page. The test server I am running this on is local SATA with the Server (witch I have not tested this on yet) is Raid 1. -Original Message- From: Brad Wood

RE: table union

Changed it to a UNION ALL and still taking 32 seconds. By letting CF combine the data you mean drop the two queries into an array? Would this be a good time to switch to a full SQL server, if so any suggestions I use access because it is easy to use. Travis Haley Haley Computer Solutions 2749 E

RE: table union

I get about the same time using the QoQ... you would not think it was this hard to join two tables together lol Would making an additional table to keep all the info in and writing each check transaction to both tables Then pull the report off the master table? -Original Message- From: