Search results for query: *

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

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

Thanks for replying! Its outputting America/New_York DarkMan

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

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

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

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

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

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

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

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

...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;, & #92...

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

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

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

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

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

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

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

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