cachedwithin
If you've used cachedwithin on a cfquery and set it for, say, 10 minutes, is there any way to reset that query before the ten minutes is up? for example, the threadlist in my forum has a very chunky query, so I use cached within. After the first load, it uses cached data which lasts for 5 minutes. At some point I add a new thread - obviously it won't appear in the threadlist until the 5 minutes is up and the query is cached anew, but is there a bit of code I could attach to the end of the "create new thread" function that would reset the query again? Toby ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cachedwithin
Sure. Set cachedwithin to a variable in application.cfm, say 0,0,5,0 Then set it to 0,0,0,0 when you want to re-set the cache. best, paul At 08:11 PM 12/30/00 +1100, you wrote: If you've used cachedwithin on a cfquery and set it for, say, 10 minutes, is there any way to reset that query before the ten minutes is up? for example, the threadlist in my forum has a very chunky query, so I use cached within. After the first load, it uses cached data which lasts for 5 minutes. At some point I add a new thread - obviously it won't appear in the threadlist until the 5 minutes is up and the query is cached anew, but is there a bit of code I could attach to the end of the "create new thread" function that would reset the query again? Toby ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
eruditionzone's Boards
Hi, I installed eruditionzone.com's board for testing, onto a new DS, but am getting an error. I was just wondering if anyone is using their board, or can anyone explain this error: Parameter 2 of function DateAdd which is now "" must be an integer The error occurred while evaluating the expression: #UCase(DayOfWeekAsString(DayOfWeek(DateAdd("h", GetGenSet.ServerTime, Now()# I ran the setup procedure which worked a dream - created a new forum in the Admin Control - but get this when trying it out. TIA Will ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Overwrites Struct problem
What am i doing wrong here: I am building a shopping cart everything with this code works ok if I change the qty it updates correctly. The trouble begins when i try adding a new Item. When I do this it overwrites the old entry completely. Thanks and HAPPY NEW YEAR Rick cfparam name="form.ProductID" default="" cfparam name="form.ProductClass" default="" cfparam name="form.GroupID" default="" cfparam name="form.ProductName" default="" cfparam name="form.Price" default="" cfparam name="form.Quantity" default="" cfset basket = StructNew() cfoutput cfscript // if its not there add it... if (not(StructKeyExists(basket, "#form.ProductID#"))){ StructInsert(basket, "id", "#form.ProductID#"); StructInsert(basket, "class", "#form.ProductClass#"); StructInsert(basket, "Group", "#form.GroupID#"); StructInsert(basket, "name", "#form.ProductName#"); StructInsert(basket, "cost", "#form.Price#"); StructInsert(basket, "Qty", "#form.Quantity#"); } else { // if there is a change in qty change it StructUpdate(basket, "Qty", "#form.Quantity#"); } /cfscript /cfoutput cfoutput P#StructFind(basket, "id")#/P P#StructFind(basket, "class")#/P P#StructFind(basket, "Group")#/P P#StructFind(basket, "name")#/P P#StructFind(basket, "cost")#/P p#StructFind(basket, "Qty")#,/p /cfoutput ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Coldfusion Debugger
I just dont get it I am a newbie to Coldfusion, maybe about 6 weeks old. In my previously life, I have been in the client/server arena for over 11 years. I have used many types of interactive debuggers but when it comes to using the debugger for studio, I just dont get it. I have a fusebox infrastructure that I would like to step through. I tried following the instructions in the Coldfusion Studios manual but I am not succeeding. Can anyone please shed some light on this? Thanks Justme Kinley ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT- HTH
Liets kill the topic before someone gets crabby. larry Duane Boudreau wrote: Its not something you'd do for the halibut. (ducking and running). That depends on how nice you are to the halibut ;) Duane Chaos, panic, and disorder - my work here is done. -- Duane Boudreau wrote: Sorry I have to. Ever held a halibut? Duane ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Overwrites Struct problem
any key in a struct can have only one value. What I would do if I wanted more than one item in a basket would be to have an one dimensional array aBasket and each element of the array be a struct of the type basket that you have now - Original Message - From: "Richard L Smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 30, 2000 10:19 AM Subject: Overwrites Struct problem What am i doing wrong here: I am building a shopping cart everything with this code works ok if I change the qty it updates correctly. The trouble begins when i try adding a new Item. When I do this it overwrites the old entry completely. Thanks and HAPPY NEW YEAR Rick cfparam name="form.ProductID" default="" cfparam name="form.ProductClass" default="" cfparam name="form.GroupID" default="" cfparam name="form.ProductName" default="" cfparam name="form.Price" default="" cfparam name="form.Quantity" default="" cfset basket = StructNew() cfoutput cfscript // if its not there add it... if (not(StructKeyExists(basket, "#form.ProductID#"))){ StructInsert(basket, "id", "#form.ProductID#"); StructInsert(basket, "class", "#form.ProductClass#"); StructInsert(basket, "Group", "#form.GroupID#"); StructInsert(basket, "name", "#form.ProductName#"); StructInsert(basket, "cost", "#form.Price#"); StructInsert(basket, "Qty", "#form.Quantity#"); } else { // if there is a change in qty change it StructUpdate(basket, "Qty", "#form.Quantity#"); } /cfscript /cfoutput cfoutput P#StructFind(basket, "id")#/P P#StructFind(basket, "class")#/P P#StructFind(basket, "Group")#/P P#StructFind(basket, "name")#/P P#StructFind(basket, "cost")#/P p#StructFind(basket, "Qty")#,/p /cfoutput ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Overwrites Struct problem
any key in a struct can have only one value. This isn't true; a structure member can be a complex data object such as an array, structure or query object. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stored Procedures
I thought I would ask the list a question with Store Procs andf CF, I was working on a few scripts and was wondering is it possible for CF to detect that the Proc doesn't exist and create the proc or even if it can be done within a stored Procedure... Yes, this is generally possible. CF can run any kind of SQL statement you want, including data definition statements, not just data manipulation statements. The syntax used to check for the existence of something within the database will vary from one database platform to another. Here's an example in T-SQL that would work in SQL Server 7: cfquery name="qAddSP" datasource="ds" if exists (select * from sysobjects where id = object_id(N'[dbo].[getAnEmailAddress]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[getAnEmailAddress] GO CREATE PROCEDURE getAnEmailAddress @theUserName varchar (255) AS SELECT Email FROMUserInfo WHERE UserName = @theUserName /cfquery Note that this example is a little different from what you asked for, but illustrates the fact that you can write DDL within an SQL batch and run it through CFQUERY. This example checks for the existence of a specific stored procedure, and if it does exist, it drops it. Then, in either case, it builds the stored procedure. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Overwrites Struct problem
I didn't say only a simple value. If anyone inferred that I am sorry for the confusion. You are certainly correct. From his post, however, I think he was setting for example basket.id=12 and then when he added a new item basket.id =7 and wondering why the first was overwritten. - Original Message - From: "Dave Watts" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 30, 2000 4:37 PM Subject: RE: Overwrites Struct problem any key in a struct can have only one value. This isn't true; a structure member can be a complex data object such as an array, structure or query object. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Studio and w2k
I have encountered an extremely weird behavior of ColdFusion Studio 4.5 on win2000 when using RDS - all directories are shown and can be expanded as usual, but not a single file appears! It is quite the same on my local development server as well as on remote servers which work alrite with CF Studio on another machine. It is my first installation on Win2000 - is ist a specific w2k problem? Have anybody experienced the same thing? Thanks Alexander Apartsev just me design [EMAIL PROTECTED] ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: network drives and cfdirectory
Thank you - that was it! Make sure that CFAS is running under an account that has access to those resources. By default CFAS runs under the system account which does not have network access to mapped drives. Jeff Garza I am trying to access an network drive through CFDIRECTORY. I've tried "\\Myshare\somedir" as well as the drive letter, all to no avail. Is it possible at all? ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Debugger
I am a newbie to Coldfusion, maybe about 6 weeks old. In my previously life, I have been in the client/server arena for over 11 years. I have used many types of interactive debuggers but when it comes to using the debugger for studio, I just don't get it. I have a fusebox infrastructure that I would like to step through. I tried following the instructions in the Coldfusion Studio's manual but I am not succeeding. Unfortunately, the interactive debugger can be a bit difficult to deal with. It's a little more complex in its setup than traditional debuggers, which debug code running on the developer's machine. The interactive debugger uses the RDS client to connect to a CF server, then send instructions to that server to stop at the breakpoints you've set, etc. You might find this presentation useful. It covers using the interactive debugger, among other things: http://www.figleaf.com/figleafhome/cfug/CFUGSep99-GAkickoff.zip In my opinion, though, just debugging manually, by placing CFOUTPUTs and CFABORTs in your pages to diagnose specific problems, is easier and more helpful. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio and w2k
I have encountered an extremely weird behavior of ColdFusion Studio 4.5 on win2000 when using RDS - all directories are shown and can be expanded as usual, but not a single file appears! It is quite the same on my local development server as well as on remote servers which work alrite with CF Studio on another machine. It is my first installation on Win2000 - is ist a specific w2k problem? Have anybody experienced the same thing? I had this problem with versions of CF Studio prior to 4.5.1. If you upgrade to 4.5.1, you should be able to browse through RDS again. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Debugger
Thanks Dave, Yes, I have been using the cfoutput method of debugging but there always the times where certain values are being set and your are not sure if all the proper code is being executed. Stepping through the stack is helpful. But your right the interactive debugger needs some improvement. Happy New Year Justme kinley -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 30, 2000 4:12 PM To: CF-Talk Subject: RE: Coldfusion Debugger I am a newbie to Coldfusion, maybe about 6 weeks old. In my previously life, I have been in the client/server arena for over 11 years. I have used many types of interactive debuggers but when it comes to using the debugger for studio, I just don't get it. I have a fusebox infrastructure that I would like to step through. I tried following the instructions in the Coldfusion Studio's manual but I am not succeeding. Unfortunately, the interactive debugger can be a bit difficult to deal with. It's a little more complex in its setup than traditional debuggers, which debug code running on the developer's machine. The interactive debugger uses the RDS client to connect to a CF server, then send instructions to that server to stop at the breakpoints you've set, etc. You might find this presentation useful. It covers using the interactive debugger, among other things: http://www.figleaf.com/figleafhome/cfug/CFUGSep99-GAkickoff.zip In my opinion, though, just debugging manually, by placing CFOUTPUTs and CFABORTs in your pages to diagnose specific problems, is easier and more helpful. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF's way of retrieving client data...
We have several default variables associated client states: LastVisited,HitCount, etc So we have two sets of client variable types: custom and allaire's global set. After watching the queries on the sql server through the sql profiler, CF calls two separate queries for each client request. One to the cglobal table for the global/allaire's variables, and another to cdata for the custom variables. Even you "disable automatic global variable updates", which basically renders the global variables useless, CF continues to call two separate sql statements for each request. I can understand why they would do this since the client global variables are in the documentation and thus they should always be there to use but what I don't understand is the lack of the ability to get rid of that overhead, and it can become a major overhead considering it's searching on a string key. And why would they use a string as the search key? Couldn't they just have two int fields, cfid, cftoken, and group them together as the primary key? I would think the int search would be faster considering how many times those queries runs a small improvement can go a long way. And why don't they just use one sql statment and use join to consolidate the two table rows since they use the same key instead of the overhead of two separate statements? Is it just me? Xing testing 1.2.3...testing 1.2.3... ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Slow tonight
Seems slow tonight on the list. Is everyone partying tonight... Robert ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Slow tonight
Not everyone - though I wish I were :-) Howie - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 30, 2000 10:48 PM Subject: Slow tonight Seems slow tonight on the list. Is everyone partying tonight... Robert ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Slow tonight
I hear you!!! With a Webhosting company to run, no time to party... Only work... Hope everyone has a great New Year. Lets see some activity on the list, I am bored... Robert - Original Message - From: "Howie Hamlin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 30, 2000 11:03 PM Subject: Re: Slow tonight Not everyone - though I wish I were :-) Howie - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 30, 2000 10:48 PM Subject: Slow tonight Seems slow tonight on the list. Is everyone partying tonight... Robert ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slow tonight
I hear you!!! With a Webhosting company to run, no time to party... Only work... Hope everyone has a great New Year. Lets see some activity on the list, I am bored... Could always build a portal-based 6dof fps with cf. That would keep everyone busy for a while. ;-) --min ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Slow tonight
I guess so... Happy New Year to All! ^_^ Finally New Years Eve! At 10:48 PM 12/30/00 -0500, [EMAIL PROTECTED] you wrote: Seems slow tonight on the list. Is everyone partying tonight... Robert ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists