Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MsChelle

    Time changed

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

    how to not evaluate tags and functions

    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 >?
  3. MsChelle

    Java conflicts

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

    CFMAIL and Stylesheets

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

    CFMAIL and Stylesheets

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

    Linked CSS no longer working after new install

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

    Linked CSS no longer working after new install

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

    Linked CSS no longer working after new install

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

    using cfquery, maxrows, and pagination

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

    using cfquery, maxrows, and pagination

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

    using cfquery, maxrows, and pagination

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

    Flash Form and CFGrid Limitations?

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

    Find max over past month, 6 months, 9 months

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

    Having stored procedure output go to excel document w/ Parameters

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

    CFCHART - Multiple values, multiple elements over time

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

    Number Format

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

    CFCHART - Multiple values, multiple elements over time

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

    Linked Server Error 17

    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!
  19. MsChelle

    Linked Server Error 17

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

    Linked Server Error 17

    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.

Part and Inventory Search

Back
Top