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 Chriss Miller 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. SidianConsulting

    Strange DB connection problems

    Try creating a test cfm page that just does a generic query against the database, using the datasource name you set up in the admin, not the variable #DB_SOURCE#. Does it connect? Then it's a problem in your code, with the variable DB_SOURCE not being set correctly on the production server. -Andy
  2. SidianConsulting

    cache only images?

    The cfcache tag in ColdFusion 8 cannot cache page fragments, unfortunately. As of CF 9, it DOES handle that, however, which is nice. One caching custom tag I know of is cf_scopecache: http://scopecache.riaforge.org/ I am not sure if it will solve your problem but it won't hurt to give it a...
  3. SidianConsulting

    Slow Development Server Reasons

    Do you have "Save class files" checked under the Settings section in the CF Administrator? Uncheck it. On that page you can also clear the template and component caches (scroll further down on that page). In addition, I'd run Disk Cleanup on your server (right-click the drive, properties...
  4. SidianConsulting

    Date formatting input text box

    Did you try type="datefield" for your cfinput tag in conjunction with the mask attribute? -Andy
  5. SidianConsulting

    Creating a two column pdf

    What about using a table with two columns per row and just putting one drug and it's reactions in each cell, left to right, alphabetically? -Tek
  6. SidianConsulting

    inserting date string into a smalldatetime

    It's my guess (which I can only do based on the lack of code) that one or more of your dates are not valid ones. As you loop over the data in your CSV file, output the date field to the screen before each database insert. As soon as you hit an invalid date, you'll get an error and see the...
  7. SidianConsulting

    Need to do some delete in several tables

    You can try: Delete table1,table2,table3,table4 FROM table1,table2,table3,table4 Where table1.Id = table2.Id AND table1.Id = table3.Id AND table1.Id = table4.Id AND status = 'D' -Tek
  8. SidianConsulting

    CFMail issue

    I think the cfmailpart tags are overriding the type attribute that you have set to "text". You could try setting it to "plain", but I think what you'll have to do is put a cfif around the cfmailpart that renders the HTML content so it doesn't get called in specific situations where you want to...
  9. SidianConsulting

    Map path

    Farther down in the docs it does mention all of the path types you can use, including relative and absolute. I assume you, bombboy, are the one who commented at the bottom of the page about the error. So, you are using CFMX 6.1 and NOT getting an error, but if the wrong drive is being returned...
  10. SidianConsulting

    Map path

    Well that's strange, because it works on my end, CFMX 6.1 w/updater. -Tek
  11. SidianConsulting

    Map path

    Actually, you CAN start at the web root with ExpandPath(): #ExpandPath("\images")# The "\" returns the absolute path starting at the root of the web site. -Tek
  12. SidianConsulting

    Displaying a date from a SQL server

    Or you could return the date, already formatted, from SQL Server: SELECT CONVERT(varchar(10),dateField,101) AS dateField This will return every column named dateField that is a datetime or smalldatetime in the format "mm/dd/yyyy". Look up the CONVERT function in SQL Server Books Online to see...
  13. SidianConsulting

    Links to information on same page

    <a href="#section1" ...>Click me for section 1!</a> ... ... ... <a name="section1">This is section one!</a> -Tek
  14. SidianConsulting

    Email notification

    cf59102, Maybe I am not understanding you, but... Say I pick the 1st of each month to send out expiration reminders. I send reminders for all accounts that are due to expire within 30 days. What about the accounts that expire 31 days from the day I am sending the email out? Since any day...
  15. SidianConsulting

    Naming the Exported Excel Worksheet

    Check out the cfsavecontent tag. Wrap all the data that gets output to Excel in this tag. Then use the CFFILE tag to write that content to a file. After this you can use the code I posted a few messages back to push the file to the browser. Just remember to add the DELETEFILE attribute to...
  16. SidianConsulting

    Email notification

    How about a BIT field (1 or 0) called wasNotified? Update it to 1 (TRUE) after the notification email goes out. When you select the customers to email notifications to, do a WHERE wasNotified = 0 in your query to weed out the people who were notified already. -Tek
  17. SidianConsulting

    Naming the Exported Excel Worksheet

    You might end up having to write it to a temp file, then, and use the deletefile attribute of the cfcontent tag for easy cleanup. Can you paste the code you are using to push the data to the user? -Tek
  18. SidianConsulting

    Naming the Exported Excel Worksheet

    Try: <cfheader name="Content-Disposition" VALUE="attachment; filename=myexcelfile.xls"> <cfcontent type="Application/vnd.ms-excel" file="x:\myexcelfile.xls"> If you still have problems, it might be the browser you are using. Some do not play well with filenames. -Tek
  19. SidianConsulting

    how to manage a group of checkboxes?

    DeZiner is right, but you want to use ListFind(FORM.q1,"2") instead of ListContains(). ListContains() would return TRUE if you had a list of "1,3,12", since it looks for items that CONTAIN a "2" character. -Tek
  20. SidianConsulting

    The search is killing the server. Please help!

    I remember writing something like that a year or so ago. I called it PKCache (Primary Key Cache), but I never finished it. It does exactly what you described, webmigit. I never tried it out in production. The most important thing about caching is knowing when and when not to do it. With...

Part and Inventory Search

Back
Top