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...

Not sure what method you are using to dynamically create your page, but I'll assume you're just writing to a text file and naming it with .cfm? If that's the case, maybe you could use the &lt; and &gt; codes to do the write instead of < and >?

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...

Never mind...it must be something with Outlook. When I forwarded the report to someone else, the formatting showed correctly on all portions.

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...

You're right. It was a configuration/permissions issue in IIS. Resolved, now. Drove me nuts for 2 days, though!! Thanks!

Yes, it is. It's not a complicated CSS page either, just some table and font formatting.

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 think part of the problem is the IDs aren't consecutive, so adding it into the where clause like that might not work. If you really want to do this in the query, you could do something like this select top 100 fields from table where columns not in (select top #startat# SomeUniqueField...

<cfloop query="qMyQuery" startrow=#start# endrow=#end#> #column#<br> (whatever) </cfloop> or <cfoutput query="qMyQuery" startrow=#start# maxrows="100"> #column#<br> (whatever) </cfoutput> No need to break.

Instead of using maxrows in your query, you could use it in your cfoutput or cfloop (how are you outputting the data?)

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...

Try changing your sql in Query to read: {Call storedprocedure1(?)} (with comma delimited ? for each input parameter)

I tried grouping by element, then date, then value. The closest I got it to working was grouping by element and putting a loop over cfchardata's. Most of my various attempts gave me either a correctly formatted graph with no data, but the legend and dates were correct. One arrangement got me...

Try more 9s? #NumberFormat(Evaluate(jmAnswer),"999,999,999")#

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...

OK I got it. I had to create an alias (there was a hyphen in the server name), then rebuild the registration, then create the linked server as an SQL Server, as opposed to an OLE. Thanks for your help!

That's actually why I'm trying to do it this way. DTS copies were failing or only giving me partial data. Even when I created new tables on the old server with subsets of the larger tables and tried copying brand new tables to the new server database, I got fails. It would create the tables but...

That's what I thought, too. I checked the accounts, and have tried several, including the sa, Administrator, and user accounts. They all work on the ODBC connection, Server instance (separate registration), and the old server. None make the linked server work.