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!

  • Congratulations Mike Lewis 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. shammack

    Exporting to MS Word

    How do you get ColdFusion to export to MS Word? I used the CFCONTENT tag as follows, but that does not work for me. <cfcontent type=&quot;application/msword&quot; > also tried <cfcontent type=&quot;application/vnd.ms-word&quot; > Neither work. Any advice?
  2. shammack

    Drill Down Graphs and MX

    ColdFusion MX does not appear to support drill down on graphs at the data bar or pie slice level (whereas ColdFusion 5 did). Is this feature really gone?!! If so, does anybody have any suggestions for how to produce dynamic drill down graphs?
  3. shammack

    Oracle Stored Procedures

    Nevermind. The problem was with the driver.
  4. shammack

    What's Wrong with this Query Statement

    The error message seems to suggest that you have not assigned a value to the variables AGCY_AGENT_CODE. Is this really a variable, or is it the name of a column in your table? The syntax in the SUBSTR command is probably wrong. Try this if AGCY_AGENT_CODE is actually a column name select...
  5. shammack

    Oracle Stored Procedures

    I have an Oracle stored procedure that returns a result set. It works fine in SQL+, but I am having trouble with the syntax in ColdFusion. I keep getting an error WRONG NUMBER OR TYPE OF PARAMETERS. Does anybody have any examples of CF code that actually works?
  6. shammack

    CFX_ZIP and Internal CF Server error 500

    Does anyone have any ideas of how to resolve a '500 Internal Server Error' related to using CFX_ZIP on a Cold Fusion server. The error is being generated when one scheduled task creates a zip file of the inetpub/wwwroot directory and all subdirectories on a CF server. When this was tested on...
  7. shammack

    Fiscal Year

    Is it company specific? Maybe it is, I don't know.
  8. shammack

    Fiscal Year

    Is there a way to derive the fiscal year from a date?
  9. shammack

    Session Variable

    Have you tried using the SETDOMAINCOOKIES attribute in the <CFAPPLICATION> tag?
  10. shammack

    Does anyone have any ideas of how t

    Does anyone have any ideas of how to resolve a '500 Internal Server Error' related to using CFX_ZIP on a Cold Fusion server. The error is being generated when one scheduled task creates a zip file of the inetpub/wwwroot directory and all subdirectories on a CF server. When this was tested on...
  11. shammack

    Numbers to Words

    I don't know of any existing code to do this either. You could write a custom tag to do it though. If you really need it in your app, it wouldn't be that difficult.
  12. shammack

    ListQualify and IN clause

    You may want to consider making your ID's numeric. This problem with the quotes in the IN clause when you pass it a list does not exist for lists of numeric data. Alternatively, another option is to use a stored procedure to parse your list rather than attempting to do it with ColdFusion in...
  13. shammack

    ListQualify and IN clause

    I have a reply to your original question. This isn't very elegant, but it should work. <CFQUERY NAME=&quot;qTrainer&quot;> select FirstName,LastName from trainer where <cfloop list=&quot;#session.Event.selTrainerID#&quot; item=&quot;i&quot;> userid = '#i#' or...
  14. shammack

    Books on CF website design &amp; planning?

    The O'Reilly book on ColdFusion 5.0 is excellent.
  15. shammack

    Finding Differences between 2 tables

    Seems like there are three different kinds of differences you might be interested in. This might require three queries or one query with two unions inside of it. For the natural inner join between the two tables, i.e., rows with the same key, you can easily extract the rows whose non-key...
  16. shammack

    URL, After the Slash

    Oops! I put an extraneous semicolon in there. The correct syntax should be this. <cfset x = ListLast(&quot;http://www.mysite.com/cats&quot;,&quot;/&quot;)>
  17. shammack

    URL, After the Slash

    If all you want to do is capture the word &quot;cats&quot;, try this <cfset x = ListLast(&quot;http://www.mysite.com/cats&quot;,&quot;/&quot;)> x should equal cats.
  18. shammack

    CF server problem

    I would first look at the code being executed rather than the server. Sounds like there could be a problem with application or session variable locks locking eachother out. You can set the server for single thread access and see if this addresses the problem.
  19. shammack

    Virtual Directories or Web Server Mappings

    How do you set up a virtual directory (sometimes called a web server mapping) in Apache? I want to be able to reuse images on various subsites of a site, and I would like to just be able to specify the path to the images as /images/image1.gif regardless of which directory I am in. Anybody know...

Part and Inventory Search

Back
Top