Search results for query: *

During a service call to fix a bad processor on the server, the tech for some reason changed the time on the server (probably because the server is [intentionally] running as a different time zone). Since then, my CF scheduled tasks have been running an hour early. I have changed the time on...

I have a cftree set up on one of our intranet sites. Sometimes it asks folks to d/l the jvm...which is fine. However, the version it requires is lower than the version required for another intranet application (not mine). Is there anyway to have 2 java versions on the client? If so, is there a...

I have an automated email that uses one template twice (2 different query results). The stylesheet (basic, used for colors and formatting only) is linked on the output template. An <h3> tag before the 1st and 2nd outputs AND all of the 2nd output render the stylesheet just fine, but the first...

I reinstalled ColdFusion MX7 yesterday on my server, and since then, linked stylesheets are being ignored. CSS specified inline or in script tags on the page work fine, it's just when I use <link rel="stylesheet" type="css\text" href="stat_style.css"> that it ignores it. Any ideas?? Is...

I am attempting to consolidate several reports into a tabbed Flash form. I have 3 heirarchies of tabnavigators, and in the bottom level there are 3 pages, each with a cfgrid (the reports). It all works fine and dandy if I have 10 or less mid-level pages (Cincinnati, Columbus, etc, in code...

I am working on a query that would provide maximum values per record over the past month, 6 months, and 9 months. There is a one-to-many relationship between the table containing the records and the one containing the values. There are about 1200 records to get these values for. I've tried...

I need to create a dynamic chart page that charts multiple values for multiple elements over time. For example, a query could be something like: select element, date_val, value from table where element IN('abc','bcd','def') and date_val > '5/5/2007' Output: abc,5/5/2007,10 abc,5/6/2007,15...

I have two servers. One is replacing the other, eventually. I have *almost* identical databases on both. Because they are not completely identical, I have to manually copy some of the table data from the old to the new. I am able to successfully setup an ODBC connection to the old database. I...

I have Coldfusion MX7 installed on a Windows 2K3 R2 server, using IIS 6.0. Yesterday, I tried installing PHP on the server to support other existing scripts. Prior to the PHP installation, Coldfusion was working fabulously. Now, though, I have some weird problems. My flash forms only partially...

I apologize if this is answered somewhere, but I can't find it. I have a start page (index.cfm) with two iframes. The top one is the header which is a flash-form report menu (tabs, radio buttons, etc). The reports appear in the second frame. One of these reports brings up a flash-form submenu...

I need to create a flat file for import into a 3rd-party application. The format of the data versus the table structure of the source is driving me crazy. Table structure example: Site BR Tx ABC 11 8526750 ABC 12 8526850 ABC 12 8526855...

First, let me say, I am not a DBA, we don't have a DBA, and we are learning this as we go, out of necessity. We have 5 (identical in structure) sql databases that store large amounts of data. We are experiencing massive performance issues lately and I was hoping someone could help. These are...

I hope someone out there can help me. I have a table that has date, time, cellid, and 25 other numeric data fields (call them f1, f2, etc). There are entries for each cellid, every halfhour, every day. I need to find the max(f1) and list all the data within that row for each cellid...

Table 1: Date, Time, ID, Value1, Value2,.....Value20 Table 2: Date, Time, ID, SubID, Value1, Value2... -These tables are updated every halfhour, 24 hours a day, 7 days a week. -There will be 2-3,000+ new records coming in every halfhour for table 1, and 10-20,000 new records each halfhour...

I have several CF scripts that query a DBase file. The problem is, when 2 or more scripts are running at the same time, I get an error saying the database is in use. I was told that DBase is exclusive only. Does anyone know a way to get around this?? Thanks!