RE: [ACFUG Discuss] Monitoring CF app / monitoring service

One really simple method of determining if the CF service restarted is to look at the server.coldfusion.expiration variable. If your CF server is properly license then this variable will hold the timestamp of when the CF service last started. Another way is to simply parse through your cf logs.

[ACFUG Discuss] Monitoring CF app / monitoring service

Does anyone have or know of a service that can monitor a CF app for up time? I don't mean just pinging the domain to get a reply, but making sure that your app is working and that Java, and thus, CF has not died in the middle of the night? _ Derrick Peavy Sales and Web Services

Query and CFC caching (was RE: [ACFUG Discuss] CFC and reuse query)

Extending Allen's proposal to add reuse of the query data, as Steven was heading toward in his note, you may want to recognize something if you're calling these methods often, and perhaps from lots of different users of the application. You may want to consider some form of query caching. There ar

RE: [ACFUG Discuss] CFC and reuse query

Allen's is the closest to what I would think Anthony's looking for (just my opinion). I have a couple points of clarification to Allen's code for Anthony, since he's really new at this. First, you would put the CFFUNCTION in side of a file called something.cfc. And you should (though you don't

RE: [ACFUG Discuss] CFC and reuse query

This is an interesting take. I wouldn't jump at seeing a Query of Queries as being the solution (again, I like Allen's), but let me comment that you are on a good track in recognizing that there's an aspect of query result reuse that would be useful. I'd propose query caching instead, but that's a

RE: [ACFUG Discuss] CFC and reuse query

If I may interject, Brooks, I'm curious that you chose to show use of the wildcard SQL statements, since he didn't indicate needing that. No offense intended. I realize you must have read his requirements as needing them, but it doesn't seem he was. I'm just saying this in case other newcomers may

RE: [ACFUG Discuss] CFC and reuse query

Before anyone attacks you on this...you shouldn't do something like this: select blah from blah where #col# = #val# - big security risk...plus, using cfqueryparam (in most cases) will help a database store the query plan. But, you could do something like this: SELECT * FROM s

RE: [ACFUG Discuss] CFC and reuse query

Use cfarguments for the cffunctions.. don't remember the syntax off the top of my head tho (been buried neck deep in ActionScript 3.0 and MXML) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Mathis Sent: Friday, February 02, 2007 1:27 PM To: discu

Re: [ACFUG Discuss] CFC and reuse query

Seems like you would just select them all and do a QoQ... probably the fastest way to do it but, that may not be true depending on the number of records you are returning. So query for all and then go check out QoQ http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/ww

Re: [ACFUG Discuss] CFC and reuse query

Let me try to explain what I trying to accomplish a little bit better. I'm not sure if cfcs can do this. Documentation seems to make me think that they can. In my test.cfm I have the following: #qryWINDOWS.recordcount# #qryLINUX.recordcount# I'm using the following query from a cfinclude actio

Re: [ACFUG Discuss] CFC and reuse query

The solution should still work with the latest version of mySQL. mySQL ahs support for stored procedures and the coalesce function. You will need however, CF 7 with the Hot Fix 1 that re-enables the use of directly mapping stored procedure named paramaters. Teddy On 2/2/07, Anthony Mathis <[E

Re: [ACFUG Discuss] CFC and reuse query

mysql On Fri, 2007-02-02 at 11:57 -0500, Teddy Payne wrote: > What database are you using? > > Teddy > > > On 2/2/07, Anthony Mathis <[EMAIL PROTECTED]> wrote: > I'm looking for a solution to reusing a query in a cfc where > the "where > clause needs to change. >

Re: [ACFUG Discuss] CFC and reuse query

Now, here is a quick snippet of a MS SQl Server solution that is quite neat. CF: The above CF just passes in the name of the column, the data inside of the column and the data type of the column. You can put the function into any CFC that you like for generic non-dependent q

Re: [ACFUG Discuss] CFC and reuse query

Thanks! On Fri, 2007-02-02 at 12:05 -0500, [EMAIL PROTECTED] wrote: > > Anthony: > > If you have three columns that you want to query on you, can do the > following: > > > > > > > > > > > select * > from fooTable > where 1=1 >and column1 = '%myA

RE: [ACFUG Discuss] CFC and reuse query

Don't forget to use cfqueryparam... John [EMAIL PROTECTED] _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 02, 2007 12:05 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] CFC and reuse query Anthony: If you have

Re: [ACFUG Discuss] CFC and reuse query

Anthony: If you have three columns that you want to query on you, can do the following: select * from fooTable where 1=1 and column1 = '%myArgument1%' and column2 = '%myArgument2%' and column3 = '%myArgument3%' select * from fooTable where 1=1

Re: [ACFUG Discuss] CFC and reuse query

What database are you using? Teddy On 2/2/07, Anthony Mathis <[EMAIL PROTECTED]> wrote: I'm looking for a solution to reusing a query in a cfc where the "where clause needs to change. example: select * from table where #field# = #value# How would I pass the info from my c

[ACFUG Discuss] CFC and reuse query

I'm looking for a solution to reusing a query in a cfc where the "where clause needs to change. example: select * from table where #field# = #value# How would I pass the info from my cfm to the cfc and continue to run the same query from the same cfm using different values

RE: [ACFUG Discuss] OT does anyone have a favorite CSS user group to recommend?

Just a couple more CSS sites.. http://www.csszengarden.com/ http://www.acfug.org/index.cfm?fa=meetings.meetingdetail &EventID=121 -Steven Ross did a presentation on CSS back in Jan 2006. His code examples are very good and tak

Re: [ACFUG Discuss] OT does anyone have a favorite CSS user group to recommend?

http://www.adobe.com/cfusion/communityengine/index.cfm?event=homepage&productId=1 This is the CSS Advisor offered by Adobe. Precia On 2/2/07, Ajas Mohammed <[EMAIL PROTECTED]> wrote: Hi Dusty, Did you solve the issue? I am just curious and also I want to get an idea of moving

Re: [ACFUG Discuss] OT does anyone have a favorite CSS user group to recommend?

Hi Dusty, Did you solve the issue? I am just curious and also I want to get an idea of moving from table design to tableless desing i.e pure css. It would be great if you could share your experience with us or if you are still facing any issues. Ajas Mohammed. On 1/31/07, Steven R