Re: DateAdd in Query Statement
Try:
#CreateODBCDateTime(DateAdd('D',ARGUMENTS.twgFileExpDate,F.filePostDate))#
Ryan
[EMAIL PROTECTED] 27/11/2006 14:13
I'm attempting to filter a query set based on a date. However, it looks
like the DateAdd function is not in an ODBC format, so I can't compare the
current date to the filePostDate + twgFileExpDate. I've looked around CFLib
without success. How would I write this?
cfset ARGUMENTS.twgFileExpDate = 21
SELECT F.fileURL, F.filePostDate, F.caseID
FROM #APPLICATION.prefix#_Clients_Files_List F
WHERE F.caseID = cfqueryparam cfsqltype=cf_sql_char
value=#ARGUMENTS.caseID#
AND #CreateODBCDateTime(Now())# =
#DateAdd('D',ARGUMENTS.twgFileExpDate,F.filePostDate)#
Thanks,
Mark
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261707
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Function/Query Speed.
What I've been doing is testing the speed of a call to a function in a cfc not written by myself, that must be used as a search function to an interface I've written. My question revolves around the speed of the things. I'll explain what's happening before I try wording the question. *3 components written as web services, but in this case all sitting as objects in the application. *One function in each component provides an interface to search an address database (simple, standard and advanced searches). *In my code I've called clearTrustedCache() of the administrator and I've code to try and ensure the pages I'm looking at are not being cached, which I'm sure is working. *I'm timing just one line of code. The cfset that calls the application scope onbject(function), assigning it's return to a variable. I use getTickCount() just be fore and just after. So it's timing the call, the function process and the return of data. Everything is sitting on one CF7.01MX development box and always calling the same oracle DB. The administrator is set to cache the last 100 queries. The anomoly i can't explain is that the first call reports a much higher time than subsequent calls. But more still, the second third and so on can be to any of the 3 components (all created in application scope prior to any call), with any search criteria i.e. the second call doesn't need to use the same component/function as the first call and can even search with different criteria and it still seems to be benefitting from some form of caching that the first call did not. This might all sound a bit vague or fuzzy. I'd like to say I've ruled out template caching, and can't explain how it could possibly be query caching (dynamic queries, different criteria, different queries in different comonents..) So that leads to beleive that the first call is doing something else to slow it down rather than something being done to speed up the others. Lastly, I should say that reference to 'the first call' is neither the first call the the server, or the application but rather the first call to those functions each day/test... I'm even slightly unsure about the time between tests that needs to go by before I can produce a slow first call again. Any ideas at all would be helpful. I might have to come up with an explanation before I can consider putting this live. If any of the data or code would help I'll post on request. Ryan ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and should not be disclosed to any other party. If you have received this email in error please notify your system manager and the sender of this message. This email message has been swept for the presence of computer viruses but no guarantee is given that this e-mail message and any attachments are free from viruses. Fife Council Tel: 08451 55 00 00 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260625 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Function/Query Speed.
Tom, Thanks for taking the time to read through that last post. I just wonder though, the box is running IIS (which may do something similar with the wsdl), but each of the three functions/webservices are in 3 different components so 3 different wsdls? Ryan [EMAIL PROTECTED] 16/11/2006 11:11 On Thursday 16 November 2006 10:02, Ryan Stewart wrote: *3 components written as web services, but in this case all sitting as The anomoly i can't explain is that the first call reports a much higher time than subsequent calls. But more still, the second third and so on can This is ColdFusion (well, Apache Axis) compiling the WSDL that describes the service, and is normal. -- Tom Chiverton Helping to efficiently compete transparent meta-services This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260645 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MD5 in cfm is not correct
The only difference I see with the example string The quick brown fox jumps over the lazy dog, is that CF generates a string all uppercase alpha characters. Aside from that it seems to give the same value. So couldn't you just say: lcase(hash(The quick brown fox jumps over the lazy dog)) to get the value that should match php generation? Ryan [EMAIL PROTECTED] 09/11/2006 02:47 If we md5 a string in php and cfm we are getting different results That is PHP - Md5(*anystring) - Correct equivalent to MD5 val described in http://en.wikipedia.org/wiki/MD5 CFM Hash(*anystring,MD5) - Returns a different value Here is an example, if we execute the given below example in php we will get correct result but if we do it in cfm we are getting a different result. Can you please help? Do you have any idea how to create correct md5 values in cfm? MD5(The quick brown fox jumps over the lazy dog) = 9e107d9d372bb6826bd81d3542a419d6 (Correct MD5) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259742 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MD5 in cfm is not correct
I should have mentioned I was using cfmx 7.0.1 Ryan [EMAIL PROTECTED] 09/11/2006 09:50 CF 7.0.2 gives me the correct output as well. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259744 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Releasing objects from memory (Garbage Collection)
If you really wanted to, you could use: StructDelete(structure, key [, indicatenotexisting ]) StructDelete ( variables, objectKey [, true] ) Ryan [EMAIL PROTECTED] 01/11/2006 08:31 I have a cfloop that iterates through a query and creates an object for every userid that is returned in the query. Is there a way that I can dispose of the object once I am finished with it so that I can free up the processor and memory space. The loop could create up to 80 objects in any run, depending on the number of userid's that are returned in the query. Any help would be appreciated. H ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 79%[Maybe spam] CF7 hosting; cheap but reliable?
http://www.hostingfuse.com/ Cheap and reliable for home use. I don't use their mail server, but I get the impression it's probably fine. Tech support and H-Sphere tools are useful. --Ryan [EMAIL PROTECTED] 16/10/2006 04:35 Hi: I need a CF7 hosting that doesn't cost very much cause I need it for personal use but a reliable one that doesn't be down all the time and has a good email server. What do you suggest? Thanks Benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: built in web server
I've always noticed the same thing, even with external web servers but only with the first request after the services have been started. 10 seconds? I've never timed it, but it's probably about that. Ryan [EMAIL PROTECTED] 10/10/2006 22:10 Have you run any tests to compare the built-in web server to Apache or IIS? What everyone has said so far about CF caching compiled class files is true, but it is more just how CF works, and has nothing to do with what web server you use. ~Brad -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 10, 2006 3:10 PM To: CF-Talk Subject: RE: built in web server Hi, i am noticing when using the built in webserver, it takes a while for the pages to load. it says in the status bar 'waiting for local host' and maybe takes 10 seconds to load a page. i have noticed that it is moderately faster on some higher spec computers but was wondering if the performance is enhanced when running the enterprise edition in a production environment Typically, in a development environment, you're making changes, then testing those changes. Each time you run a script after changing it, that file needs to be recompiled by CF, which takes a considerable amount of time. This would be true whether you use the built-in web server or an external web server. In a production environment, many people are typically running the same scripts, and those scripts don't change very often. So, after they've been compiled the first time, CF simply reuses the compiled classes. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256218 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
IDE's
Quick question, I've been using dreamweaver for coldfusion development at work for sometime. I've always been of the opinion that it's much more of a designer/prototype/entry level tool. I'm looking into alternatives to put forward as suggestions for a DW replacement as others are now realising issues with it. Q. What IDE/editor do you use for coldfusion development? (and if you feel you want to expand with why and perhaps complexity of use, then that's very kind) Cheers, Ryan. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and should not be disclosed to any other party. If you have received this email in error please notify your system manager and the sender of this message. This email message has been swept for the presence of computer viruses but no guarantee is given that this e-mail message and any attachments are free from viruses. Fife Council Tel: 08451 55 00 00 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256239 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFForm programatically setting selectedDate for cfcalendar
I'm just starting to get into CFForm and loving that I can take some of my Flex knowledge and apply it to the forms. But I'm having an issue binding the selected date on cfcalendar. I have a datagrid that fires some ActionScript when a new item is selected. In the ActionScript I try setting the selected date as follows: calMyCalendar.selectedDate = dgMyDataGrid.selectedItem.my_date_field; but that isn't working. Does anyone who is more familiar with cfform know why that doesn't work and if there's a workaround? I'm sure that ..my_date_field has data, but I may not be formatting it correctly. Any help would be appreciated, Ryan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231000 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
