hi i was just wondering how would i be able to upload something onto the same page after the percentage has reached 100%. sorry for hassle but i'm new to CF. thanks

I know that, but in this case I wanted the whole screen to be absolutely positioned (along with the bottom), and have the processing section just appear as it goes. worked out well!

Instead of using visibility: visable; and hidden; try using display: block; and display: none; This will prevent your page from displaying a large gap of white space in IE 6+.

I know this application does a lot that you most likely will not want to do, but here is the code I am using. Also, as a side note: I think a lot of people mistakenly think that they can have a percentage bar while a query is processing on the server. That is a mistake, when a query goes out to the DB server (SQL, DB2, whatever) there is no data coming back to ColdFusion telling it '10% done, 15% done', etc. Where you CAN show processing is in-between sets of queries, or while your application is physically doing some work (in my instance, while I am inserting multiple SQL records) So hopefully that can clarify things for you. :) Anyways, you will have to do some heavy modification to get my code to work for you, but here it is in all its looping glory. ;)

The password you entered does not allow you to run a report greater than 7 days long. Please see Tamara Wilson to obtain the correct password.

The password you entered does not allow you to run a daily load report. Please see Tamara Wilson to obtain the correct password.

SELECT ReportNumber FROM RunReports WHERE ReportNumber = '#ReportNumber#'

Report Processing, please wait...
Report number #ReportNumber# is complete. Click here to open it.

SELECT (ORDBILL.ORODR##) AS ORDERNUM, ORDBILL.ORBAMT, ORDBILL.ORTAMT, ORDER.ORCONS, ORDER.ORCUST, ORDER.ORLDAT, (ORDER.ORDV##) as Division, ORDER.OROCTY, ORDER.OROST, ORDER.ORDCTY, ORDER.ORDST, ORDER.ORSTAT, ORDER.ORMILE, (ORDER.ORSTP##) AS Stops, ORDER.ORCUST AS CustomerCode, LOADDATE.DIDISP, LOADDATE.DIDATE, LOADDATE.DIEMIL as EmptyMiles, LOADDATE.DITRLR as Trailer, LOADDATE.DITMIL as TotalMiles, LOADDATE.DISMNF as LoadedMiles, LOADDATE.DICONT, LOADDATE.DIINIT, ORDER.ORCUST as LoadAtCode, NMSAREA.NMAREG AS RegionCode, (SELECT MCFGTX FROM MSMCREL0 WHERE MCAVTX = LOADDATE.DIINIT) as DMNAME, (SELECT SUM(DIEMIL) FROM LOADDATE WHERE (DIODR##) = (ORDER.ORODR##)) as TotalEmptyMiles, (SELECT SUM(DISMNF) FROM LOADDATE WHERE (DIODR##) = (ORDER.ORODR##)) as TotalLoadedMiles, (SELECT CUNAME FROM CUSTMAST WHERE CUCODE = ORDER.ORCONS) as Customer, (SELECT MCFGTX FROM CUSTMAST INNER JOIN MSMCREL0 ON CUSTMAST.CUSLMN = MSMCREL0.MCAVTX WHERE CUCODE = ORDER.ORBILL) as Salesman, (SELECT CUBZIP FROM CUSTMAST WHERE CUCODE = ORDER.ORCONS) as Zip, (SELECT CUSHNM FROM CUSTMAST WHERE CUCODE = ORDER.ORCUST) as LoadAt, (SELECT DISTINCT CISHNM FROM CITIES WHERE CIST = ORDER.OROST AND CICTY = ORDER.OROCTY) AS OriginCityName, (SELECT DISTINCT CISHNM FROM CITIES WHERE CIST = ORDER.ORDST AND CICTY = ORDER.ORDCTY) AS DestinationCityName, (SELECT Count(*) FROM Billing WHERE BIODR = (ORDER.ORODR##)) as BillCount, (SELECT OANAME FROM ORDERADD WHERE OAORD = (ORDER.ORODR##) AND OACNT = '03' AND (OASTP##) = 0) as AddLoadAt, (SELECT OANAME FROM ORDERADD WHERE OAORD = (ORDER.ORODR##) AND OACNT = '04' AND (OASTP##) = 0) as AddCustomer, (SELECT SUM(BILLING.BIAMT) as Total FROM BILLING LEFT OUTER JOIN COMODITY ON BILLING.BICOMM = COMODITY.COMCDE WHERE BILLING.BIODR = (ORDER.ORODR##) AND BICOMM NOT IN ('DET', 'DETD') AND COMODITY.COMDIV = (ORDER.ORDV##) AND COMODITY.CORTYP = 'L' OR BILLING.BIODR = (ORDER.ORODR##) AND BIAMT > 0 AND BILLING.BICOMM = '') as TotalLinehaul, (SELECT SUM(BILLING.BIAMT) as Total FROM BILLING LEFT OUTER JOIN COMODITY ON BILLING.BICOMM = COMODITY.COMCDE WHERE BILLING.BIODR = (ORDER.ORODR##) AND BICOMM NOT IN ('DET', 'DETD') AND COMODITY.COMDIV = (ORDER.ORDV##) AND COMODITY.CORTYP IN ('A', 'S')) as TotalAccess FROM (((LOADDATE INNER JOIN ORDBILL ON (LOADDATE.DIODR##) = (ORDBILL.ORODR##) AND LOADDATE.DIDATE >= #FromDate# AND LOADDATE.DIDATE <= #ToDate# AND LOADDATE.DIDISP = '01') INNER JOIN ORDER ON (ORDBILL.ORODR##) = (ORDER.ORODR##) AND ORDER.ORSTAT IN ('E', 'D')) INNER JOIN NMSAREA ON Trim(ORDER.OROST) = Trim(NMSAREA.NMACOD) AND NMSAREA.NMAREG = '#RealRegionCode#' AND NMSAREA.NMAREG = '#form.Region#') WHERE (ORDER.ORDV##) IN #Replace(Form.Division, "X", "'", "ALL")# AND ORDER.ORBILL = '#UCase(Trim(Form.Billto))#' INSERT INTO RunReports( ReportNumber, StartDate, EndDate, RunDate, RunRegion, Billto, IP, Rows) VALUES( '#ReportNumber#', '#Form.StartDate#', '#Form.EndDate#', '#DateFormat(Now(), 'MM/DD/YYYY')#', '#Form.Region#', '#Form.Billto#', '#CGI.REMOTE_ADDR#', #RowCount#)

Hey Justice, I'm having a look at your tutorial and it would be perfect for me to use. Only problem is, it's way over my head...so if you could, could I see a working example with code....Cheers:)

For this percentage meter to work, you would have to be doing something repetative. The loop I put there was just for an example. Think of it like this: First, you run a query to return all distinct orders in the system. Then, you have to loop through the query (or order numbers) and get total bill amounts, invoice information, etc, from several different sources. This is the point, while you are getting all that different information, that would would put the javascript percentage # update in. For doing a file upload, there is no native coldfusion method to present a progress bar. If the files are REALLY huge, you could write something client side in java to break the file into bits, then upload each one to the server and re-combine them, but it looks like you are just uploading a .doc file, so I bet its pretty small. I hope I made sense there! If you still have some questions, I can post a working example out on my site with source code to show you exactly what I mean! :) Let me know what you need!

Hey justice, I did the tutorial but I think there is a problem with the loop. I put the following code into your commented part and the file gets uploaded like 5 times(I checked the destination folder) and then I get this error. How do I stop the loop please?Cheers The request has exceeded the allowable time limit Tag: CFLOOP The error occurred in D:\hshome\hernande\thomasgreg.com\a2.cfm: line 56 54 : 55 : 56 : 57 : 58 :

Well, the way I use this: I have to perform a query from 1 datasource, then I process that data (some logic, some variables, etc), and I have to insert it into another database (SQL server temp tables) so the user can view individual data sets in a report. I present the user a percentage bar so they know how the report is coming (especially when they have to wait about 5 minutes if they are running a month's worth of data or more) :) If you want more specific examples, just toss me another comment! :)

I like the taught of a processing counter, but how would you incorparate a query instead of a loop?