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

    CF9 Time offset from server time

    By time functionality, I was talking about built-in functions like now(), etc. Also, scheduled tasks were running at the wrong times. For whatever reason over the weekend, the server reset to the correct time (I had set it back 10 hours so at least CF functions were reporting the correct...
  2. DarkMan

    CF9 Time offset from server time

    sorry, something told me I should have said mentioned that. The server is also Eastern Time, (US & Canada). The time zones are set the same... I also think somehow that's the problem. Eastern time is GMT -5. It's like CF is looking at the server like it's GMT and taking another 5 hours off...
  3. DarkMan

    CF9 Time offset from server time

    Thanks for replying! Its outputting America/New_York DarkMan
  4. DarkMan

    CF9 Time offset from server time

    all my time functions on CF9 are 10 hours off what the server is set to ever since we updated a few weeks ago. I've been pulling my hair on how to fix the offset. I'm sure it's something simple that I'm overlooking. :-( Does anyone here know how to fix the offset so CF reports the same time...
  5. DarkMan

    Database for a Forum like Tek-Tips?

    I know for sure...[pc2] We do use ColdFusion and SQL Server. As far as searches go, we could use ColdFusion's verity, but we simply have far more posts than verity can handle, so we're using SQL Server's text indexing, which is okay, but there does seem to be a storage limitation with that as...
  6. DarkMan

    Table Indexing Takes Over the Server

    tlbroadbent, Thanks! I've not seen that one before. I'm running the defrag right now, and my site isn't dogging out at all... This ought to lengthen the time that I have to re update statistics... You deserve another twenty stars for that one! DM DarkMan
  7. DarkMan

    Does CFError Work For Links

    ColdFusion can't validate a link like that, but you can set up custom 404 pages for your web server. This custom page would have to be a plain html page, but you can still set it up to be helpful to the user. If you have links to other sites, a better solution would be to periodically run a...
  8. DarkMan

    Table Indexing Takes Over the Server

    WOW! All of you had great suggestions I hadn't yet tried! (And I thought I had tried everything). Thanks to everyone. I think these will keep me out of trouble until I can re-do the system. Thanks to everyone for your generous help with this, you've put me way ahead of the game. (:I DarkMan
  9. DarkMan

    Table Indexing Takes Over the Server

    Thanks guys, Unfortunately, I can't use perl scripts, but I'll turn the auto stats off right now, and try dropping and recreating the index before I try deleting the rows again. (I won't do that 'til sometime in the middle of the night, for obvious reasons..:-) I'll post here how it went...
  10. DarkMan

    Table Indexing Takes Over the Server

    I've got a table that acts as a log file for a web site. For every impression the site gets, the system adds a row to the db, which I can go to later and count impressions and unique ips. The system used to work okay, but we're starting to see some serious problems as the site has grown. This...
  11. DarkMan

    Cookie Abuse

    tangram, Thanks for mentioning this. The cookie issue was on our "To-Do" list, but your post gave us the excuse to move it up on our priority list. I've implemented a new system for the "Remember Me" option that stores your information with reasonably strong encryption...
  12. DarkMan

    help with replacenocase function

    Does it NEED to be ReplaceNoCase? Something like this: <CFSET Variables.Artist = ReplaceList (Top1.Artist, &quot;#chr(34)#, #chr(39)#, &, (, ), [, ], *, /, \, +, =, ?, %, @, #chr(35)#, !, #chr(44)#, ., -&quot;, &quot;& #34;, & #39;, & amp;, & #40;, & #41;, & #91;, & #93;, & #42;, & #47;, &...
  13. DarkMan

    Truncating Transaction Logs.

    I had this problem for quite a while, and what I did that worked was: Go into Enterprise Manager, then the database's properties. Click on the options tag and change the database recovery model to 'Simple' and select the 'AutoShrink' checkbox. This keeps the transaction log's file size at a...
  14. DarkMan

    CF 4.5.1 Ent Solaris & DB on windows NT?

    I haven't used CF on a Solaris machine, but as long as CF supports ODBC on that platform, it shouldn't matter what OS the database is on... DarkMan
  15. DarkMan

    CFGRID Formatting

    I think it's #DateFormat(YourDate,&quot;d mm yyyy&quot;)#, but I don't think that'll work in a query driven CFGRID.... DarkMan
  16. DarkMan

    Using ASP within Cold Fusion

    Let me know if it does. It may help me with some stuff I'm grappling with..:-) DarkMan
  17. DarkMan

    SQL problems using a form page

    In your insert statement: <CFQUERY NAME=&quot;AddTrans&quot; DATASOURCE=&quot;bizbul&quot;> INSERT INTO TRANSACTION ('#Form.T_id#', '#Form.trans_type#', '#Form.id#', '#Form.item_num#', '#Form.model_num#', '#Form.date#', '#Form.qty#', '#Form.price#', '#Form.total_cost#') </CFQUERY> you're not...
  18. DarkMan

    CFGRID Formatting

    If you're using SQL Server, you could try something like: SELECT CONVERT(char, MyDateField, 107) as TheDate FROM MyTable (returns dates like Oct 10, 2000 and Jan 02, 2000) or SELECT CONVERT(char, MyDateField, 101) as TheDate FROM MyTable (returns dates like 10/10/2000 and 01/02/2000) in...
  19. DarkMan

    CFSCRIPT and TAGS

    It is my understanding that functions within CFSCRIPT tags will execute somewhat faster. That being said, I would think it's probably better to use CFSCRIPT whereever convenient (that is, whenever processing can be accomplished with CFSCRIPT commands and functions and without ColdFusion tags)...
  20. DarkMan

    Using ASP within Cold Fusion

    I've never tried it, but it seems that you should be able to write a separate ASP template, then call it from the CF page via CFHTTP... DarkMan

Part and Inventory Search

Back
Top