Re: Commercial/Open Source CF based CMS
Is it rollback or promote versioning? I like FarCry, always have done but it does require a lot of tinkering code wide to get it working. It is one of the best ColdFusion CMS apps in the market (way better than CommonSpot, which is one of the so called market leaders). FarCry can be light on features compared to other tools, but that is the price of flexibility. It also does not have a publishing model built in as far as I know which can be a problem for some. When we chose our system, we did not limit ourself to just ColdFusion, it would be stupid to, we looked at many, including Vignette. We chose a system with the greatest toolset. Sure it was expensive and it has it's quirks :-) we can happily use ColdFusion, Java, .NET inside the CMS. If you can afford it, do your research and don't just look at ColdFusion apps. It took is nearly a year to evaluate products. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Geoff Bowers To: CF-Talk Sent: Mon Sep 18 00:53:05 2006 Subject: Re: Commercial/Open Source CF based CMS James, On 9/18/06, James Holmes [EMAIL PROTECTED] wrote: Geoff, while we've got you in this thread, does FarCry offer a full history of every change to a page (i.e. is is possible to be able to say exactly what was displayed publicly in a page at any given time, along with who made it look that way)? If so, can the rollback go back to every version of the page in the history? Versioning can be turned on/off for any specific content type -- so has to be turned on for the specific content type in question. Out of the box, all relevant content types have versioning turned on. Editing a live content item creates an underlying DRAFT content item. When this is approved, the current live content item database record is archived. This archive is permanent by default, although many folks set a maintenance task to wipe archives older than a certain date. The limit is really a question of database size - these days that's pretty much as many as you like. There is an option to archive associated media assets such as images and files. These are copied to a specific archive location outside of the web root. Rollback is based on the record only. Most of the time this is all you need. However, if you have changed or deleted the associated content templates (display methods) the restore will show the current look and feel or only show a dump of the record in question respectively. System wide attributes for content include createdby, lastupdatedby and owner fields. Plus there is an audit trail for all activities which you can report against. Hope that helps, -- geoff http://www.daemon.com.au/ ~| 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:253400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reliability
On Friday 15 September 2006 20:21, Snake wrote: No because CFC's did not exist in previous versions :-) The underlying problem of abusing the various scopes did though. -- Tom Chiverton Helping to dramatically brand edge-of-your-seat patterns 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:253401 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Install error
On Monday 18 September 2006 02:53, Phil Devitt wrote: Could not find the ColdFusion Component wqcfcs.utils.cffile.File. This isn't a standard CF component, afaik. Things to check include the Custom Tag path. -- Tom Chiverton Helping to authoritatively market killer methodologies 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:253402 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfquery sql= ...
Where would that be? I don't see it in my local copy (CFMX). Is that an MX 7 path? Yeah, if you are running a single server install try the following three lines... cffile action=read file=C:\CFusionMX7\wwwroot\WEB-INF\cftags\META-INF\taglib.cftld variable=cftags cfset cftags = xmlParse(cftags) cfdump var=#cftags# ~| 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:253403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 500 errors
Hi Charles - i do send mail off the box but not on the day in question. I'll search the MS knowledge base for more detials. Snake - I wish i had - that would have been easy to fix ;) On 17/09/06, Charles Sheehan-Miles [EMAIL PROTECTED] wrote: Question -- was cfmail processing a lot of mail at the time and do you have an smtp server on that box? Or something else that was opening a lot of network connections? I ran into a similar issue a while back and it turned out the root cause was that my server had exceeded an OS built in limit of 32k simultaneous network connections, and I could no longer open connections to my sql server database. There are some MS knowledge base articles on this, including how to modify the registry to increase that limit. I don't remember the registry key off hand. Rebooting my server cleared the problem for a while, but next time I ran a huge mailing it came back. I've since moved my whole mailing process of onto a separate box. On 9/17/06 1:06 PM, Snake [EMAIL PROTECTED] wrote: Haven't run out of disk space on the server have you ? Snake -Original Message- From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED] Sent: 17 September 2006 16:54 To: CF-Talk Subject: CF 500 errors Hi All, i've had a strange error on my server recently and depending on what site i went to displayed i got a different error: 500 Not enough storage is available to process this command Not enough storage is available to process this command 500 Error attempting to resolve the template error.cfm. Error attempting to resolve the template error.cfm. anyone know why this would happen? I restarted the server and all sites are now running fine. -- Nick Tong web: http://talkwebsolutions.co.uk blog: http://succor.co.uk short urls: http://wapurl.co.uk green link: http://wapurl.co.uk/?4Z2YDLX ~| 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:253404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL in a variable
Is there any way to get the formatted SQL from a query? For instance if I run the query... Select * from table where id = #someid# The debug info shows this as Select * from table where id = 7 Is there some way I can grab that second example from an existing variable or am I going to have to recreate it into a string? -- Jay ~| 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:253405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL in a variable
You can get the same info you see in the debug from debug.cfm. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: James Smith To: CF-Talk Sent: Mon Sep 18 11:14:09 2006 Subject: SQL in a variable Is there any way to get the formatted SQL from a query? For instance if I run the query... Select * from table where id = #someid# The debug info shows this as Select * from table where id = 7 Is there some way I can grab that second example from an existing variable or am I going to have to recreate it into a string? -- Jay ~| 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:253406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL in a variable
I'm not really sure what your asking james. If your asking how you can store a query in a string, then this is how cfsavecontent variable=query Select * from table where id = #someid# /cfsavecontent - Russ -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 18 September 2006 11:14 To: CF-Talk Subject: SQL in a variable Is there any way to get the formatted SQL from a query? For instance if I run the query... Select * from table where id = #someid# The debug info shows this as Select * from table where id = 7 Is there some way I can grab that second example from an existing variable or am I going to have to recreate it into a string? -- Jay ~| 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:253407 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Commercial/Open Source CF based CMS
On 9/18/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Is it rollback or promote versioning? I suspect it is promote versioning -- in that when you roll back it simply promotes the older version to be the new live object and automatically archives the current live object. The history of the object is preserved. But that's my guess at what you mean -- in the CMS world every man and his goat has their own glossary of terms. I like FarCry, always have done but it does require a lot of tinkering code wide to get it working. It is one of the best ColdFusion CMS apps in the market (way better than CommonSpot, which is one of the so called market leaders). FarCry can be light on features compared to other tools, but that is the price of flexibility. It also does not have a publishing model built in as far as I know which can be a problem for some. One of the advantages for those of us who like to tinker is that the code base improves the way we want it to. Point in fact FarCry 4.0 is due to go into beta early next week. re: light on features -- I beg to differ on this but there's no point boring people here with a CMS shoot out. re: publishing model -- I assume you mean to flat HTML? I'm not sure I understand why anyone would be in a screaming hurry to buy into an expensive publishing model when you can implement robust solutions like HTTRACK [1] and reverse proxies like SQUID [2] to provide convenient flat HTML equivalents of dynamically served sites. [1]: http://www.httrack.com/ [2]: http://wiki.squid-cache.org/SquidFaq/ReverseProxy When we chose our system, we did not limit ourself to just ColdFusion, it would be stupid to, we looked at many, including Vignette. We chose a system with the greatest toolset. Sure it was expensive and it has it's quirks :-) we can happily use ColdFusion, Java, .NET inside the CMS. If you can afford it, do your research and don't just look at ColdFusion apps. It took is nearly a year to evaluate products. What a crazy old world we live in... -- geoff http://www.daemon.com.au/ ~| 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:253408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL in a variable
I'm not really sure what your asking james. If your asking how you can store a query in a string, then this is how cfsavecontent variable=query Select * from table where id = #someid# /cfsavecontent What is happening is I am creating an audit trail for some of our intranet pages to see who is editing what and when. The first query is a complex query full of query params etc... And I then want to insert the executed sql statement into another table so I can come back at a later date and see what sql was executed. This is obviously simple if the first querys sql is saved into some variable I can then use in the insert query for the audit. -- Jay ~| 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:253409 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL in a variable
Jay, CFMX7 added a RESULT attribute to CFQUERY which (among other things) contains the final SQL as submitted to the database driver. So you can do any dynamic processing you want in CFQUERY and then just check the RESULT structure afterwards. Also, as an FYI, if you want to log SQL statement execution you may want to do it on the database server instead of the client. You can use a TRIGGER for this, perhaps. --- Ben -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 6:35 AM To: CF-Talk Subject: RE: SQL in a variable I'm not really sure what your asking james. If your asking how you can store a query in a string, then this is how cfsavecontent variable=query Select * from table where id = #someid# /cfsavecontent What is happening is I am creating an audit trail for some of our intranet pages to see who is editing what and when. The first query is a complex query full of query params etc... And I then want to insert the executed sql statement into another table so I can come back at a later date and see what sql was executed. This is obviously simple if the first querys sql is saved into some variable I can then use in the insert query for the audit. -- Jay ~| 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:253410 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL in a variable
CFMX7 added a RESULT attribute to CFQUERY which (among other things) contains the final SQL as submitted to the database driver. So you can do any dynamic processing you want in CFQUERY and then just check the RESULT structure afterwards. Also, as an FYI, if you want to log SQL statement execution you may want to do it on the database server instead of the client. You can use a TRIGGER for this, perhaps. Cheers Ben, I am honoured by your presence ;-) and that is nearly exactly what I was looking for, except that where I have used a cfqueryparam in the sql it gets reported as '?' instead of the actual value and the sql parameters are then returned as a separate array, however I can't see it being to hard to recreate from here and much simpler than doing it all from scratch. Thanks. -- Jay ~| 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:253412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL in a variable
that looks like a handy attribute, although like you say James the SQL value doesn't look so easy straight forward to use once you use the CFQUERYPARAM on the ingoing query attribute. !? :o/ On 9/18/06, Dan G. Switzer, II [EMAIL PROTECTED] wrote: James, In CFMX 7, there's an attribute called result for the cfquery / tag. This will return a struct, that contains the executed SQL statement--along with other miscellaneous information about the query. http://livedocs.macromedia.com/coldfusion/7/htmldocs/0316.htm#1102316 -Dan -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 6:14 AM To: CF-Talk Subject: SQL in a variable Is there any way to get the formatted SQL from a query? For instance if I run the query... Select * from table where id = #someid# The debug info shows this as Select * from table where id = 7 Is there some way I can grab that second example from an existing variable or am I going to have to recreate it into a string? -- Jay ~| 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:253413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL in a variable
that looks like a handy attribute, although like you say James the SQL value doesn't look so easy straight forward to use once you use the CFQUERYPARAM on the ingoing query attribute. !? I am using... cfset ParsedSQL = UpdateMainResult.SQL cfloop from=1 to=#arrayLen(UpdateMainResult.SQLParameters)# index=i cfset ParsedSQL = replace(ParsedSQL, = ?, = ' UpdateMainResult.SQLParameters[i] ',one) /cfloop And that does a reasonable job, unfortunately one of my text fields is a ratio and the isDate() function incorrectly identifies it as a date so I can't use that to skip the quotes, but if I was very worried about it I could use isDate() and isNumeric() to not quote fields that don't need them. -- Jay ~| 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:253414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL in a variable
I am not sure that I would ColdFusion to solve this issue. If the SQL tracking is in question, I would simple convert the queries into stored procedures and then audit the execution of the stored procedures upon execution. So, you are tracking when a stored procedure is executed and which attributes were passed to it. This is pretty simple to achieve and executes rather quickly. SQL auditing is not really a client responsibility. By client, I mean CF. Teddy On 9/18/06, James Smith [EMAIL PROTECTED] wrote: that looks like a handy attribute, although like you say James the SQL value doesn't look so easy straight forward to use once you use the CFQUERYPARAM on the ingoing query attribute. !? I am using... cfset ParsedSQL = UpdateMainResult.SQL cfloop from=1 to=#arrayLen(UpdateMainResult.SQLParameters)# index=i cfset ParsedSQL = replace(ParsedSQL, = ?, = ' UpdateMainResult.SQLParameters[i] ',one) /cfloop And that does a reasonable job, unfortunately one of my text fields is a ratio and the isDate() function incorrectly identifies it as a date so I can't use that to skip the quotes, but if I was very worried about it I could use isDate() and isNumeric() to not quote fields that don't need them. -- Jay ~| 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:253415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Spry framework and n selects related
I need to make a proper project out of this so it is easier to download. Sorry folks. On 9/16/06, Charlie Griefer [EMAIL PROTECTED] wrote: the 'Download' links in each of the blog entries (altho since entry #2 is an update to entry #1, all you really need is entry #2...i was just providing the link to entry #1 for historical purposes) :) http://ray.camdenfamily.com/enclosures/Archive2.zip On 9/15/06, Rey Bango [EMAIL PROTECTED] wrote: Charlie, I'm looking for Ray's CFC but can't find it in the links you provided. Where can I find it? Thanks for the info. Rey... Charlie Griefer wrote: Massimo Foti has a custom tag that will convert a CF query into a spry-workable XML dataset at http://www.olimpo.ch/tmt/tag/spryxml/ Ray has a toXML() function that will do essentially the same thing (I believe). http://ray.camdenfamily.com/index.cfm/2006/7/2/ToXML-CFC--Converting-data-types-to-XML http://ray.camdenfamily.com/index.cfm/2006/7/13/ToXML-Update ~| 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:253416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Use CFMX with SAP
Hello, I want to make a timesheet application for a company that stores al its HR (human resource) data in SAP. Currently employees fill in their timesheetdata in an Excel spreadsheet and email it to the company. The timesheet then is being validated by a Perl script and if OK sent by ftp to SAP. If not OK employees call back to manually correct the sheet. This is tedious and error prone process since it depends on many intermediate steps (validation scripts running, ftp connection up etc etc). When any of these fails the whole chain fails and often timesheetdata is not sent. Having an online timesheetmodule connected directly to SAP should makes things easier: the employee fills in the sheet (a form) and submits the timesheet to SAP. SAP validates the timesheetdata using it's validationrules and generates error messages if something's wrong. The idea is to have these error messages sent back to the client in response to the submit and have him/her correct the timesheet if needed. Since I am a CFMX programmer and not SAP knowledgeable I wonder if anyone on this list has experience with connecting CFMX to SAP. I'd like to get some tips please! ~| 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:253417 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Spry framework and n selects related
Thanks Charlie and Ray! :o) Rey... Raymond Camden wrote: I need to make a proper project out of this so it is easier to download. Sorry folks. On 9/16/06, Charlie Griefer [EMAIL PROTECTED] wrote: the 'Download' links in each of the blog entries (altho since entry #2 is an update to entry #1, all you really need is entry #2...i was just providing the link to entry #1 for historical purposes) :) http://ray.camdenfamily.com/enclosures/Archive2.zip On 9/15/06, Rey Bango [EMAIL PROTECTED] wrote: Charlie, I'm looking for Ray's CFC but can't find it in the links you provided. Where can I find it? Thanks for the info. Rey... Charlie Griefer wrote: Massimo Foti has a custom tag that will convert a CF query into a spry-workable XML dataset at http://www.olimpo.ch/tmt/tag/spryxml/ Ray has a toXML() function that will do essentially the same thing (I believe). http://ray.camdenfamily.com/index.cfm/2006/7/2/ToXML-CFC--Converting-data-types-to-XML http://ray.camdenfamily.com/index.cfm/2006/7/13/ToXML-Update ~| 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:253418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Is anyone minding the store at Adobe?
I have been trying to reach the CF tech support forums on Adobe.com. I get an error message saying, essentially, insufficient disk space. How does this happen in today's day and age of server monitoring, etc, etc. ??? ~| 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:253419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Test PDF
Thanks Jeff I definitely have something weird going on. Whenever I view a PDF generated report, even yours, all my text is mirror image. If I save the PDF and send it to somebody else, it is normal. I must have some strange configuration, but for the life of me, I can not find it. If I view regular PDF files not generated by CF report, they display normally. So far this is what I have. Only I am experiencing this issue. Only with CFreport generated PDF content. Regular PDF files open normally. If I send a saved report PDF to another, they open normally. This is mind boggling and I have no idea where to look further. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:253420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
We have had the following issue with Macromedia ColdFusion 7 (7.0.1.116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException.cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur (although I did not record full details for the first time and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic previously to experiencing these problems, the server had been hosting an online competition, handling around 30 simultaneous users during busy periods, and never having a window of more than 20 minutes inactivity. This did make me wonder if it might be an issue with the Garbage Collection Process? Has anyone Experienced this problem, or got any ideas as to how to resolve it? Thanks, Dan. ~| 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:253421 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cross-server CFC/WS implementation.
Hello. We are re-building a couple of systems. An internal backend system, and the public website that goes with it. The two systems will be on seperate servers, seperated by a firewall. All the backend logic is to go in CFCs, with the intention that the public website can then just use them as web-services. Here is a diagram which I comissioned a top artist to draw describing this situation: http://www.hybridchill.com/misc/ws.png The problem I am trying to solve is that the CFCs require initialisation, (using a standard cfreturn This/ style init method), and you can't initialise web services. The messy not-really-a-solution solution I have come up with is to have a component within the backend system which acts as a gateway web service, and has a single remote function that calls a specified function of a specified component object. Like this: invoke object=WS method=Action returnvariable=Countries argument name=Object value=Codes/ argument name=Function value=listCountries/ argument name=Params value=#StructNew()#/ /invoke This means that the already-initialised components from the backend system can be used without needing to be re-initialised. But as I said I don't like it and I'm sure it will cause problems six months down the line. So, does anyone here have any suggestions on a better, more elegant way to share the components with the public website? Thanks. Peter ~| 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:253422 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method We have had the following issue with Macromedia ColdFusion 7 (7.0.1. 116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX 7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException. cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion ? eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash ? which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur ? (although I did not record full details for the first time ? and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic ? previously to experiencing these problems, the server had been hosting an online competition, handling around 30 simultaneous users during busy periods, and never having a window of more than 20 minutes inactivity. This did make me wonder if it might be an issue with the Garbage Collection Process? Has anyone Experienced this problem, or got any ideas as to how to resolve it? Thanks, Dan. ~| 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:253423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe:
RE: Use CFMX with SAP
If you have the budget, look into B-Talk http://www.backsoft.com/. (Not sure if they still support ColdFusion, but they used to.) If you have the VB expertise, you can create some VB COM objects that interact with SAP's API. Since you create the VB COM objects yourself, you can make sure they work with ColdFusion. I had a bit of experience with this about 7-8 years ago. I'm not sure if anything has changed with the SAP API since then. M!ke -Original Message- From: marc -- [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 9:16 AM To: CF-Talk Subject: Use CFMX with SAP Hello, I want to make a timesheet application for a company that stores al its HR (human resource) data in SAP. Currently employees fill in their timesheetdata in an Excel spreadsheet and email it to the company. The timesheet then is being validated by a Perl script and if OK sent by ftp to SAP. If not OK employees call back to manually correct the sheet. This is tedious and error prone process since it depends on many intermediate steps (validation scripts running, ftp connection up etc etc). When any of these fails the whole chain fails and often timesheetdata is not sent. Having an online timesheetmodule connected directly to SAP should makes things easier: the employee fills in the sheet (a form) and submits the timesheet to SAP. SAP validates the timesheetdata using it's validationrules and generates error messages if something's wrong. The idea is to have these error messages sent back to the client in response to the submit and have him/her correct the timesheet if needed. Since I am a CFMX programmer and not SAP knowledgeable I wonder if anyone on this list has experience with connecting CFMX to SAP. I'd like to get some tips please! ~| 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:253424 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Use CFMX with SAP
On Monday 18 September 2006 16:27, Dawson, Michael wrote: If you have the VB expertise, you can create some VB COM objects that interact with SAP's API. Since you create the VB COM objects yourself, you can make sure they work with ColdFusion. I thought that SAP had web services these days. -- Tom Chiverton Helping to enormously negotiate strategic models 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:253425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cross-server CFC/WS implementation.
On Monday 18 September 2006 16:00, Peter Boughton wrote: But as I said I don't like it and I'm sure it will cause problems six months down the line. What we do is have our service layer invoke managers from an application-scope'd ColdSpring factory. ColdSpring takes care of making sure they are initialised and cached. -- Tom Chiverton, who promises to blog about all* this* this week 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:253426 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Viaklix
I am looking to use viaklix as well. Has anyone done this successfully yet... their developers guide only supports asp development. I am putting together my first shopping cart and am new to CF so if anyone has been able to get viaklix to work within a coldfusion site and has any recommendations, examples or can point me in the right direction I would really appreciate it. I've emailed their tech department and was responded to with the exact same crappy form email both times: Unfortunately we do not support coldfusion coding. We are sorry for the inconvenience. I ended up calling them after the 3rd email and found out that the coldfusion programming language will work with viaklix, but they just do not have any examples to help you get started. Thank you very much for any and all replies, Jesse Has anyone used viaklix as a credit card payment gateway ( https://www2.viaklix.com/Admin/main.asp)? Our sister institution uses it and we can either get on board with them or go our own way. We're impressed with the price (cheap), but sometimes you get what you pay for, if ya know what I mean. It's not one we'd even heard of prior to meeting about it. So, we thought we'd try to get a second opinion. -Deanna ~| 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:253428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
That fact that you have stated you store large objects in session scope is most likely your problem. If you are instantiating CFC's in session scope, then this uses tons of memory, as you are needlessly creating a new CFC instance for each user, and unless the cose is different for every single user, there is no need to do this. Better to cache a single copy in application scope. Russ -Original Message- From: Thomas Peer [mailto:[EMAIL PROTECTED] Sent: 18 September 2006 16:18 To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method We have had the following issue with Macromedia ColdFusion 7 (7.0.1. 116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX 7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException. cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion ? eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash ? which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur ? (although I did not record full details for the first time ? and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic ? previously to experiencing these problems, the server had been hosting an online competition, handling around 30 simultaneous users during busy periods, and never having a window of more than 20 minutes inactivity. This did make me wonder if it might be an issue with the Garbage Collection Process? Has
Re: Cross-server CFC/WS implementation.
Do you have a simple* example of a ColdSpring XML config? (*but not too simple) I've looked through the documentation and we're already doing the pass-objects-as-arguments part, but I'm not certain that I see how the config/bean side of things fits together? Thanks, Peter On Monday 18 September 2006 16:00, Peter Boughton wrote: But as I said I don't like it and I'm sure it will cause problems six months down the line. What we do is have our service layer invoke managers from an application-scope'd ColdSpring factory. ColdSpring takes care of making sure they are initialised and cached. -- Tom Chiverton, who promises to blog about all* this* this week 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:253429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL in a variable
I am not sure that I would ColdFusion to solve this issue. If the SQL tracking is in question, I would simple convert the queries into stored procedures and then audit the execution of the stored procedures upon execution. So, you are tracking when a stored procedure is executed and which attributes were passed to it. This is pretty simple to achieve and executes rather quickly. SQL auditing is not really a client responsibility. By client, I mean CF. It isn't the SQL I am auditing, it is our staff. I am recording the logged in user and ip address as well as other info allong side the query so that when someone does something they shouldn't they can no longer use the it wasn't me excuse. -- Jay ~| 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:253430 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Use CFMX with SAP
Hi, I'm working on an application that gets and sends data to/from a SAP back end. We use the SAP Java Connector (JCO) architecture to expose SAP RFCs as methods in a stateless EJB, and call these from within cf (cfmx running in weblogic). You *should* be able to get most of the benefit w/out having to use EJB (our architecture is a couple of years old, but it works so we don't change it) by just writing some POJOs and deploying them in a jar in your cfserver's /lib directory and then using them via createObject or cfobject calls from within your CF code. More information about JCO is available here: http://help.sap.com/saphelp_nw04/helpdata/en/6f/1bd5c6a85b11d6b28500508b5d5211/content.htm Regs, /t marc -- wrote: Hello, I want to make a timesheet application for a company that stores al its HR (human resource) data in SAP. Currently employees fill in their timesheetdata in an Excel spreadsheet and email it to the company. The timesheet then is being validated by a Perl script and if OK sent by ftp to SAP. If not OK employees call back to manually correct the sheet. This is tedious and error prone process since it depends on many intermediate steps (validation scripts running, ftp connection up etc etc). When any of these fails the whole chain fails and often timesheetdata is not sent. Having an online timesheetmodule connected directly to SAP should makes things easier: the employee fills in the sheet (a form) and submits the timesheet to SAP. SAP validates the timesheetdata using it's validationrules and generates error messages if something's wrong. The idea is to have these error messages sent back to the client in response to the submit and have him/her correct the timesheet if needed. Since I am a CFMX programmer and not SAP knowledgeable I wonder if anyone on this list has experience with connecting CFMX to SAP. I'd like to get some tips please! -- View this message in context: http://www.nabble.com/Use-CFMX-with-SAP-tf2291598.html#a6367670 Sent from the Cold Fusion - Technical mailing list archive at Nabble.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:253431 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL in a variable
I'd think it would be better to not allow them to do something they shouldnt in the first place. A generic permissions structure on the CF side of things could keep users out of administrative tools that they shouldnt be in and allow them into the ones they should have access to. Then, in the database server... give each user their own account and permissions for that database. They can update here but not delete there or add over there... etc... Building an audit system just to be able to point fingers sounds a little over the top. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 12:44 PM To: CF-Talk Subject: RE: SQL in a variable I am not sure that I would ColdFusion to solve this issue. If the SQL tracking is in question, I would simple convert the queries into stored procedures and then audit the execution of the stored procedures upon execution. So, you are tracking when a stored procedure is executed and which attributes were passed to it. This is pretty simple to achieve and executes rather quickly. SQL auditing is not really a client responsibility. By client, I mean CF. It isn't the SQL I am auditing, it is our staff. I am recording the logged in user and ip address as well as other info allong side the query so that when someone does something they shouldn't they can no longer use the it wasn't me excuse. -- Jay ~| 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:253432 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL in a variable
Building an audit system just to be able to point fingers sounds a little over the top. Not necessarily. In my application we keep history tables out the wazoo because our executives upstairs want to keep track of everything-- especially things concerning money. Fraud prevention is one motive, but we generally just don't trust users to NOT screw things up, even if it is well within their security permissions for them to have performed their action. (we have tons of security restrictions too) Even if we have an employee whose is the certified check printer for our company, it basically comes to down us still not trusting them. And it doesn't always have to be about fraud-- sometimes people will blame our application for screwing up an order, and then we will research and find out it was their own fault. That has nothing to do with permissions really, but just tracking what each user has done to the database. ~Brad ~| 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:253433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFLog4j
Folks, I had some free time last weekend which prompted me to write a Wrapper CFC to deal with logging with log4j. Here is the url on google project. http://code.google.com/p/cflog4j/ I have tried to include every resource in the links section however I do apologize in advance if I missed any name or credits. The code should be self explanatory and consist of 2 CFCs 1. A Config Bean for CFLog4j.cfc 2. CFLog4j.cfc is the actual wrapper around log4j. There is some example implemention in testCFLogger.cfm in the root. Please let me know if there is any problem or if I have missed anything. Next planned step would be to create some examples of integrating DBappender which will write logs to the database directly. Thanks, Qasim ~| 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:253434 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Viaklix
From what I understand, it's just form posting. Not too complicated and really unrelated for the most part to the technology used. -d On 9/18/06, Jesse Kuhn [EMAIL PROTECTED] wrote: I am looking to use viaklix as well. Has anyone done this successfully yet... their developers guide only supports asp development. I am putting together my first shopping cart and am new to CF so if anyone has been able to get viaklix to work within a coldfusion site and has any recommendations, examples or can point me in the right direction I would really appreciate it. ~| 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:253435 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL in a variable
Good points. But mostly could and should be taken care of in the database server since it would be the primary target for any kind of fraud in a dynamic application. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 1:28 PM To: CF-Talk Subject: RE: SQL in a variable Building an audit system just to be able to point fingers sounds a little over the top. Not necessarily. In my application we keep history tables out the wazoo because our executives upstairs want to keep track of everything-- especially things concerning money. Fraud prevention is one motive, but we generally just don't trust users to NOT screw things up, even if it is well within their security permissions for them to have performed their action. (we have tons of security restrictions too) Even if we have an employee whose is the certified check printer for our company, it basically comes to down us still not trusting them. And it doesn't always have to be about fraud-- sometimes people will blame our application for screwing up an order, and then we will research and find out it was their own fault. That has nothing to do with permissions really, but just tracking what each user has done to the database. ~Brad ~| 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:253436 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Test PDF
Yeah I finally tracked down and resolved my issue. I had a Font that was a reversed form of Arial on my system, and some reason the PDF generated by CFReport would default to this font. That bit is still strange to me, but once I removed this font and the upside down version of Arial as well just to be safe, I am not getting normal reports. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:253437 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Test PDF
Should that read I am _now_ getting normal reports? On 9/18/06, Ian Skinner [EMAIL PROTECTED] wrote: Yeah I finally tracked down and resolved my issue. I had a Font that was a reversed form of Arial on my system, and some reason the PDF generated by CFReport would default to this font. That bit is still strange to me, but once I removed this font and the upside down version of Arial as well just to be safe, I am not getting normal reports. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:253438 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Test PDF
Should that read I am _now_ getting normal reports? Why yes, that is exactly what is should read. Someday, oh someday, I will get around to creating that write what I meant, not what I typed spell checker. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:253439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL in a variable
Personally what I like doing in this whole audit trail is just mark the data IsDeleted and then insert a new record with the new data. 4 fields are needed. IsDeleted = 1 or 0 LastModified = TimeStamp ModifiedBy = UserID LastCurrentRecord = ID of record you just Marked IsDeleted. Now a month or year later I can go in and delete data that is just taking up space but is not needed for the audit trail anymore. Casey ~| 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:253440 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Jsessionid causing 404s. Please help
We just rolled out our new improved site on ColdFusion (rather than the nasty java mess that we had before) and everything is going great except for one small problem. To try and prevent issues with old URLs I set up some redirectors with the old .do extensions. Unfortunately what we're finding is that there are a lot of people who had bookmarked urls that look like http://www.pioneermilitaryloans.com/PMLcom/homepage.do;jsessionid=XXque ryString . I had hoped that these would work just fine, but instead they're generating 404 errors. I found a tech note that talkes about J2EE Session URL Identifies causes a 404 error when using IIS and have tried to follow the instructions in that, but it didn't work. The technote says to modify the cf_root/runtime/lib/wsconfig/1/jrun.ini file. We don't have one of those. We have a cf_root/runtime/lib/wsconfig/1/jrun_iis6_wildcard.ini file which I did modify to include the ignoresuffixmap property. It didn't make any difference at all even after I restarted IIS and ColdFusion both. Can someone point me in the right direction for this. Those 404s are really driving me nuts. We're running CFMX 7.0.2 Enterprise on IIS 6 Thanks, Jennifer Dodson Sr. Development Analyst Pioneer Services 4700 Belleview Suite 300 Kansas City, MO 64112 Phone 816-448-2391 Fax 816-756-0942 [EMAIL PROTECTED] PIONEER SERVICES is a brand name and registered service mark of Pioneer Licensing Services, Inc., where its use is duly licensed to affiliates and partners of Pioneer Licensing Services, Inc. Confidentiality Notice: The information contained in this e-mail transmission, including any attachments, is confidential information, proprietary to the sender and legally protected. Its purpose is intended for the sole use of the individual(s) or entity named in the message header. If you are not the intended recipient, you are hereby notified that any dissemination, copying or taking any action in reliance on the contents of this information is strictly prohibited. If you received this message in error, please notify the sender of the error and delete this message and any attachments. ~| 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:253441 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL in a variable
Large frequently changed tables could have potential to grow very large. We do employ insert update and triggers for most of our auditing, but our history tables are on a separate history database which can be moved so it does not affect the performance and disk space of our production server as much. ~Brad -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 2:23 PM To: CF-Talk Subject: Re: SQL in a variable Personally what I like doing in this whole audit trail is just mark the data IsDeleted and then insert a new record with the new data. 4 fields are needed. IsDeleted = 1 or 0 LastModified = TimeStamp ModifiedBy = UserID LastCurrentRecord = ID of record you just Marked IsDeleted. Now a month or year later I can go in and delete data that is just taking up space but is not needed for the audit trail anymore. Casey ~| 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:253442 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
As a test you could chop out the SQL Server DSN and do a one new connection for reach new request and no pooling and see if that does it. Start the connection in the application file and close it when the person leaves. ~| 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:253443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Jsessionid causing 404s. Please help
You mention that you do some forwarding of .do to ColdFusion. The technote describes how to solve the problem when using default page extensions for ColdFusion/JRun servers, i.e. .cfm, .cfc, .jsp. When ignoresuffixmap is false, the JRun connector gets to take a look at the extension to look for an extension match before IIS does. If the .do extension (URL Pattern) is not mapped to a servlet in ColdFusion's web.xml, then the JRun connector will not make a match, and then IIS will inspect it unless some other connector makes a match. If .do gets all the way to letting IIS do the match, the jsessionid will confuse it. -Steven Erat -Original Message- From: Jennifer Dodson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:29 PM To: CF-Talk Subject: Jsessionid causing 404s. Please help We just rolled out our new improved site on ColdFusion (rather than the nasty java mess that we had before) and everything is going great except for one small problem. To try and prevent issues with old URLs I set up some redirectors with the old .do extensions. Unfortunately what we're finding is that there are a lot of people who had bookmarked urls that look like http://www.pioneermilitaryloans.com/PMLcom/homepage.do;jsessio nid=XXque ryString . I had hoped that these would work just fine, but instead they're generating 404 errors. I found a tech note that talkes about J2EE Session URL Identifies causes a 404 error when using IIS and have tried to follow the instructions in that, but it didn't work. The technote says to modify the cf_root/runtime/lib/wsconfig/1/jrun.ini file. We don't have one of those. We have a cf_root/runtime/lib/wsconfig/1/jrun_iis6_wildcard.ini file which I did modify to include the ignoresuffixmap property. It didn't make any difference at all even after I restarted IIS and ColdFusion both. Can someone point me in the right direction for this. Those 404s are really driving me nuts. We're running CFMX 7.0.2 Enterprise on IIS 6 Thanks, Jennifer Dodson ~| 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:253444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Jsessionid causing 404s. Please help
I guess I should have been more specific. It doesn't work with .cfm or .jsp extensions either. Also, I do have the .do extension in the web.xml. The ..do extension is working great, except when someone bookmarked it with a ;jsessionid on the end of it. It's basically like the ignoresuffixmap is just not being recognized which makes me think I got it into the wrong file or something. Jennifer Dodson -Original Message- From: Steven Erat [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 2:39 PM To: CF-Talk Subject: RE: Jsessionid causing 404s. Please help You mention that you do some forwarding of .do to ColdFusion. The technote describes how to solve the problem when using default page extensions for ColdFusion/JRun servers, i.e. .cfm, .cfc, .jsp. When ignoresuffixmap is false, the JRun connector gets to take a look at the extension to look for an extension match before IIS does. If the .do extension (URL Pattern) is not mapped to a servlet in ColdFusion's web.xml, then the JRun connector will not make a match, and then IIS will inspect it unless some other connector makes a match. If .do gets all the way to letting IIS do the match, the jsessionid will confuse it. -Steven Erat -Original Message- From: Jennifer Dodson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:29 PM To: CF-Talk Subject: Jsessionid causing 404s. Please help We just rolled out our new improved site on ColdFusion (rather than the nasty java mess that we had before) and everything is going great except for one small problem. To try and prevent issues with old URLs I set up some redirectors with the old .do extensions. Unfortunately what we're finding is that there are a lot of people who had bookmarked urls that look like http://www.pioneermilitaryloans.com/PMLcom/homepage.do;jsessio nid=XXque ryString . I had hoped that these would work just fine, but instead they're generating 404 errors. I found a tech note that talkes about J2EE Session URL Identifies causes a 404 error when using IIS and have tried to follow the instructions in that, but it didn't work. The technote says to modify the cf_root/runtime/lib/wsconfig/1/jrun.ini file. We don't have one of those. We have a cf_root/runtime/lib/wsconfig/1/jrun_iis6_wildcard.ini file which I did modify to include the ignoresuffixmap property. It didn't make any difference at all even after I restarted IIS and ColdFusion both. Can someone point me in the right direction for this. Those 404s are really driving me nuts. We're running CFMX 7.0.2 Enterprise on IIS 6 Thanks, Jennifer Dodson ~| 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:253445 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
MySQL Front
I logged onto http://www.mysqlfront.de/ today to find they are out of business. Anyone have a good MySQL front program? ~| 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:253446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MySQL Front
Two, depending on what you need. The MySQL Administrator is good for administration (imagine that) and is free from MySQL AB. SQLYog was recently released as open-source (some advanced functionality available in a commercial version), so it is free as well. Most of my work I do in SQLYog, with bits and pieces in MySQL Administrator as needed. Cheers! -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:51 PM To: CF-Talk Subject: MySQL Front I logged onto http://www.mysqlfront.de/ today to find they are out of business. Anyone have a good MySQL front program? ~| 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:253447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MySQL Front
SQLyog will do everything you need. http://www.webyog.com/en/ -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:51 PM To: CF-Talk Subject: MySQL Front I logged onto http://www.mysqlfront.de/ today to find they are out of business. Anyone have a good MySQL front program? ~| 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:253448 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL Front
If you are talking about a GUI to manage MySQL databases -- Navicat!! Best $99 I ever spent on software. -- Josh - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, September 18, 2006 12:50 PM Subject: MySQL Front I logged onto http://www.mysqlfront.de/ today to find they are out of business. Anyone have a good MySQL front program? ~| 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:253449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MySQL Front
+1 -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 4:02 PM To: CF-Talk Subject: Re: MySQL Front If you are talking about a GUI to manage MySQL databases -- Navicat!! Best $99 I ever spent on software. -- Josh - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, September 18, 2006 12:50 PM Subject: MySQL Front I logged onto http://www.mysqlfront.de/ today to find they are out of business. Anyone have a good MySQL front program? ~| 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:253450 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MySQL Front
+1 for Navicat, it's pretty nice. I've spent years using SQL Svr Enterprise Mangler and Toad and now I've been on MySQL a lot the last couple of years and Navicat seems to be about the best **for the money**. EMS SQL Manager is really nice as well, but it's about twice the price or $415 for the Enterprise bundle. http://www.navicat.com http://www.sqlmanager.net/ Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:02 PM To: CF-Talk Subject: Re: MySQL Front If you are talking about a GUI to manage MySQL databases -- Navicat!! Best $99 I ever spent on software. -- Josh - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, September 18, 2006 12:50 PM Subject: MySQL Front I logged onto http://www.mysqlfront.de/ today to find they are out of business. Anyone have a good MySQL front program? ~| 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:253451 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Jsessionid causing 404s. Please help
Can you turn on connector logging in wsconfig's jrun.ini, restart IIS, and check the log for the extension to see if it got that far? The JRun connector will either report a match or no match when it examines the suffix. If you don't see the extension with jsessionid in the connector log at all then the connector was never even handed the request. Do you see the 404 in IIS's log instead? -Original Message- From: Jennifer Dodson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:50 PM To: CF-Talk Subject: RE: Jsessionid causing 404s. Please help I guess I should have been more specific. It doesn't work with .cfm or .jsp extensions either. Also, I do have the .do extension in the web.xml. The ..do extension is working great, except when someone bookmarked it with a ;jsessionid on the end of it. It's basically like the ignoresuffixmap is just not being recognized which makes me think I got it into the wrong file or something. Jennifer Dodson ~| 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:253452 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Front
sqlmanager.net FREEBEE! They have Mysql manager lite an sql server manager lite in the downloads. got everything navicat does but free. Paid version would be sweet but I don't need it for most of the sql work I do. Casey ~| 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:253453 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Ok... I have read and reread the mail I sent - and I still can't see where I said I store large objects in session scope :-/ The server is currently only hosting a single application, which uses the seesion scope only for storing a small number of simple variables specific to the currently logged in user - and there is a restriction of 5 concurrent authenticated users on the system. I doubt therefore thatsession memory usage is the problem here. Cheers Dan. On 9/18/06, Snake [EMAIL PROTECTED] wrote: That fact that you have stated you store large objects in session scope is most likely your problem. If you are instantiating CFC's in session scope, then this uses tons of memory, as you are needlessly creating a new CFC instance for each user, and unless the cose is different for every single user, there is no need to do this. Better to cache a single copy in application scope. Russ ~| 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:253454 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLog4j
Qasin, Pretty cool. For cf hibernate you 500 null or something !--- cfset log4jconfig = createObject(java, org.apache.log4j.PropertyConfigurator) cfset log4jconfig.configure (C:\CFusionMX7\wwwroot\cfhibernate\src\log4j.properties) --- For your app I tested this cfset DansArray[1] = createObject(java, java.net.URL).init(file: Replace(getdirectoryfrompath(CF_TEMPLATE_PATH), /, \, ALL) log4j-1.2.13.jar)/ cfset log4j_PropertyConfigurator = createObject(java, coldfusion.bootstrap.BootstrapClassLoader ).SystemClassLoader.newInstance(DansArray).loadClass( org.apache.log4j.PropertyConfigurator).newInstance()/ cfset log4j_PropertyConfigurator.configure(C:\\CFusionMX7\\wwwroot\\cflog4j.properties) and it worked ~| 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:253455 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Jsessionid causing 404s. Please help
I figured it out. I had the mapping in IIS set up to verify that file exists. When I unchecked that box and restarted IIS it all started working OK. I guess that IIS was trying to find the file before it even let the Isapi filter have a shot at it. -Original Message- From: Steven Erat [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:06 PM To: CF-Talk Subject: RE: Jsessionid causing 404s. Please help Can you turn on connector logging in wsconfig's jrun.ini, restart IIS, and check the log for the extension to see if it got that far? The JRun connector will either report a match or no match when it examines the suffix. If you don't see the extension with jsessionid in the connector log at all then the connector was never even handed the request. Do you see the 404 in IIS's log instead? -Original Message- From: Jennifer Dodson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:50 PM To: CF-Talk Subject: RE: Jsessionid causing 404s. Please help I guess I should have been more specific. It doesn't work with .cfm or .jsp extensions either. Also, I do have the .do extension in the web.xml. The ..do extension is working great, except when someone bookmarked it with a ;jsessionid on the end of it. It's basically like the ignoresuffixmap is just not being recognized which makes me think I got it into the wrong file or something. Jennifer Dodson ~| 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:253456 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Jsessionid causing 404s. Please help
Of course now my 404 page is not properly picking it up when the page doesn't exist. That's actually worse than the other problem was. -Original Message- From: Jennifer Dodson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:42 PM To: CF-Talk Subject: RE: Jsessionid causing 404s. Please help I figured it out. I had the mapping in IIS set up to verify that file exists. When I unchecked that box and restarted IIS it all started working OK. I guess that IIS was trying to find the file before it even let the Isapi filter have a shot at it. -Original Message- From: Steven Erat [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:06 PM To: CF-Talk Subject: RE: Jsessionid causing 404s. Please help Can you turn on connector logging in wsconfig's jrun.ini, restart IIS, and check the log for the extension to see if it got that far? The JRun connector will either report a match or no match when it examines the suffix. If you don't see the extension with jsessionid in the connector log at all then the connector was never even handed the request. Do you see the 404 in IIS's log instead? -Original Message- From: Jennifer Dodson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:50 PM To: CF-Talk Subject: RE: Jsessionid causing 404s. Please help I guess I should have been more specific. It doesn't work with .cfm or .jsp extensions either. Also, I do have the .do extension in the web.xml. The ..do extension is working great, except when someone bookmarked it with a ;jsessionid on the end of it. It's basically like the ignoresuffixmap is just not being recognized which makes me think I got it into the wrong file or something. Jennifer Dodson ~| 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:253457 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Front
Add another +10k from me. It isn't the best db tool I've used but it is the best for MySQL. On 9/18/06, Adkins, Randy [EMAIL PROTECTED] wrote: +1 -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 4:02 PM To: CF-Talk Subject: Re: MySQL Front If you are talking about a GUI to manage MySQL databases -- Navicat!! Best $99 I ever spent on software. -- Josh - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, September 18, 2006 12:50 PM Subject: MySQL Front I logged onto http://www.mysqlfront.de/ today to find they are out of business. Anyone have a good MySQL front program? ~| 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:253458 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Hi Thomas, It's a real relief (in a way) to know we are not the only ones experiencing this issue - as at least if it is a recognised issue, macrodobe may fix it at some point (although based on my experiences today even attempting to send a support email to adobe, I wonder if that is a valid assumption) First time in over six years of using CF that I've had a crash that I haven't been able to ascertain the cause... been tearing my hair out... Thanks for your suggestions with regards to SQL connections - I will look into these and see if any are relevant in our hosting environment. Have other people just been having a problem with CF 7? or has it also been an issue in CF 6.1? Also, has anyone experiencing this problem found any benefit from installing the 7.0.2 updater? - I have scheduled downtime for midngiht tonight to install the updater... not that I could see anything in the release notes that made me hopeful that this would make any difference... Cheers Dan. On 9/18/06, Thomas Peer [EMAIL PROTECTED] wrote: Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method ~| 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:253459 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL Front
http://www.cfmyadmin.com/ Haven't tested it on MySQL 5, or even on CF7 yet, but it used to be pretty good (and fairly identical to MySQL Front, just from a browser interface). Cutter John C. Bland II wrote: Add another +10k from me. It isn't the best db tool I've used but it is the best for MySQL. On 9/18/06, Adkins, Randy [EMAIL PROTECTED] wrote: +1 -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 4:02 PM To: CF-Talk Subject: Re: MySQL Front If you are talking about a GUI to manage MySQL databases -- Navicat!! Best $99 I ever spent on software. -- Josh - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, September 18, 2006 12:50 PM Subject: MySQL Front I logged onto http://www.mysqlfront.de/ today to find they are out of business. Anyone have a good MySQL front program? ~| 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:253460 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Come to think of it, virtually all of my CF performance problems started just about the time I added an application to the server which uses SQL Server. This is a server on which there are only about two or three people at any given time - MAX. I wonder if this is a driver issue or what? I just looked right now, because pages are taking forever to load and the jrun.exe is using 312,469K of memory and 97% of CPU. I've got another server with Win2K and SQL Server which has MUCH more traffic and jrun.exe is using 55,144K and hasn't restarted in weeks. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:48 PM To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Hi Thomas, It's a real relief (in a way) to know we are not the only ones experiencing this issue - as at least if it is a recognised issue, macrodobe may fix it at some point (although based on my experiences today even attempting to send a support email to adobe, I wonder if that is a valid assumption) First time in over six years of using CF that I've had a crash that I haven't been able to ascertain the cause... been tearing my hair out... Thanks for your suggestions with regards to SQL connections - I will look into these and see if any are relevant in our hosting environment. Have other people just been having a problem with CF 7? or has it also been an issue in CF 6.1? Also, has anyone experiencing this problem found any benefit from installing the 7.0.2 updater? - I have scheduled downtime for midngiht tonight to install the updater... not that I could see anything in the release notes that made me hopeful that this would make any difference... Cheers Dan. On 9/18/06, Thomas Peer [EMAIL PROTECTED] wrote: Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method ~| 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:253461 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL Front
Chad Gray wrote: I logged onto http://www.mysqlfront.de/ today to find they are out of business. Anyone have a good MySQL front program? I'll throw out my vote for Aqua Data Studio, which also will manage SQL Server, Oracle, etc. For me, it's nice having one tool for both MySQL and MS-SQL. It is free for personal and educational use, $149 for commercial. http://www.aquafold.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:253462 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
We've been having stability issues ourselves, and can't figure out why. It relates to sending email, a task that does a lot of sql as well as string processing activity. The memory doesn't seem to jump that much, but the server restarts every so often. We haven't been able to pinpoint the cause yet, but this seems like a good culprit. We are on SQL 2k and cf 7.0.1 Are there any updated drivers available? Russ -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 5:06 PM To: CF-Talk Subject: RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Come to think of it, virtually all of my CF performance problems started just about the time I added an application to the server which uses SQL Server. This is a server on which there are only about two or three people at any given time - MAX. I wonder if this is a driver issue or what? I just looked right now, because pages are taking forever to load and the jrun.exe is using 312,469K of memory and 97% of CPU. I've got another server with Win2K and SQL Server which has MUCH more traffic and jrun.exe is using 55,144K and hasn't restarted in weeks. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:48 PM To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Hi Thomas, It's a real relief (in a way) to know we are not the only ones experiencing this issue - as at least if it is a recognised issue, macrodobe may fix it at some point (although based on my experiences today even attempting to send a support email to adobe, I wonder if that is a valid assumption) First time in over six years of using CF that I've had a crash that I haven't been able to ascertain the cause... been tearing my hair out... Thanks for your suggestions with regards to SQL connections - I will look into these and see if any are relevant in our hosting environment. Have other people just been having a problem with CF 7? or has it also been an issue in CF 6.1? Also, has anyone experiencing this problem found any benefit from installing the 7.0.2 updater? - I have scheduled downtime for midngiht tonight to install the updater... not that I could see anything in the release notes that made me hopeful that this would make any difference... Cheers Dan. On 9/18/06, Thomas Peer [EMAIL PROTECTED] wrote: Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method ~| 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:253463 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
55,144K is rather low for jrun - on my dev box its around 50,000k when server starts then it goes to about 80,000k after few hours of development. That is with one developer working on few sites max, TK -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 5:06 PM To: CF-Talk Subject: RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Come to think of it, virtually all of my CF performance problems started just about the time I added an application to the server which uses SQL Server. This is a server on which there are only about two or three people at any given time - MAX. I wonder if this is a driver issue or what? I just looked right now, because pages are taking forever to load and the jrun.exe is using 312,469K of memory and 97% of CPU. I've got another server with Win2K and SQL Server which has MUCH more traffic and jrun.exe is using 55,144K and hasn't restarted in weeks. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:48 PM To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Hi Thomas, It's a real relief (in a way) to know we are not the only ones experiencing this issue - as at least if it is a recognised issue, macrodobe may fix it at some point (although based on my experiences today even attempting to send a support email to adobe, I wonder if that is a valid assumption) First time in over six years of using CF that I've had a crash that I haven't been able to ascertain the cause... been tearing my hair out... Thanks for your suggestions with regards to SQL connections - I will look into these and see if any are relevant in our hosting environment. Have other people just been having a problem with CF 7? or has it also been an issue in CF 6.1? Also, has anyone experiencing this problem found any benefit from installing the 7.0.2 updater? - I have scheduled downtime for midngiht tonight to install the updater... not that I could see anything in the release notes that made me hopeful that this would make any difference... Cheers Dan. On 9/18/06, Thomas Peer [EMAIL PROTECTED] wrote: Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method ~| 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:253464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLog4j
Dan, Thanks for looking into this. I haven't used hibernate or cfhibernate so my knowledge about these is very limited. Qasim On 9/18/06, Dan Plesse [EMAIL PROTECTED] wrote: Qasin, Pretty cool. For cf hibernate you 500 null or something !--- cfset log4jconfig = createObject(java, org.apache.log4j.PropertyConfigurator) cfset log4jconfig.configure (C:\CFusionMX7\wwwroot\cfhibernate\src\log4j.properties) --- For your app I tested this cfset DansArray[1] = createObject(java, java.net.URL).init(file: Replace(getdirectoryfrompath(CF_TEMPLATE_PATH), /, \, ALL) log4j-1.2.13.jar)/ cfset log4j_PropertyConfigurator = createObject(java, coldfusion.bootstrap.BootstrapClassLoader ).SystemClassLoader.newInstance(DansArray).loadClass( org.apache.log4j.PropertyConfigurator).newInstance()/ cfset log4j_PropertyConfigurator.configure(C:\\CFusionMX7\\wwwroot\\cflog4j.properties) and it worked ~| 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:253465 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Front
A conditional vote for SQLYog. They have a scheduler that is phenomenal -- once you fight with it to make it work -- for backing up databases automatically. Also its ability to alter tables is laid out way better than Navicat IIRC. The down side of SQLYog is a 'feature' in the thing that lets it alias text to perform automated actions. The strings it uses are all uncommon but the text 'default' is reserved... if you have a field that just contains the text 'default' SQLYog will corrupt it if you touch the record. I think I impressed upon them how outrageously stupid this was and they promised to make the feature optional, but so far a version has come and gone that doesn't fix the problem. -- [EMAIL PROTECTED] Janitor, MSB Web Systems mysecretbase.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:253467 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Tom, Dan, Since you're both running Windows 2003 and SQL Server, is BlueDragon.NET an option to consider? http://www.newatlanta.com/products/bluedragon/index.cfm Vince Bonfanti New Atlanta Communications, LLC Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method We have had the following issue with Macromedia ColdFusion 7 (7.0.1. 116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX 7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException. cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion ? eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash ? which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur ? (although I did not record full details for the first time ? and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic ? previously to experiencing these problems, the server had been hosting an online competition, handling around 30 simultaneous users during busy periods, and never having a window of more than 20 minutes inactivity. This did make me wonder if it might be an issue with the Garbage Collection Process? Has anyone Experienced this problem, or got any ideas as to how to resolve it?
Re: Is anyone minding the store at Adobe?
I tried to submit a problem using the email support app - which resulted in Page doess not exist error meesage after clicking send mail On 9/18/06, Tim Claremont [EMAIL PROTECTED] wrote: I have been trying to reach the CF tech support forums on Adobe.com. I get an error message saying, essentially, insufficient disk space. How does this happen in today's day and age of server monitoring, etc, etc. ??? ~| 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:253468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Element LOGGEDUSERFNAME is undefined in SESSION.
I keep on getting an error stating that an element is undefined in Session. I have checked the code but cant see why this is happening. Here is the section of code below. Thanks in advance for an assistance given. cfsilent cfif IsDefined(FORM.username) !--- Query the database to see if the user exists --- !--- cfquery name=getLogOn datasource=#request.dsn# username=#request.dsnUsername# password=#request.dsnPassword# --- cfquery name=getLogOn datasource=#request.dsn# SELECT * FROM tbl_establishments e, tbl_estcontacts c WHERE ABAMbrno = '#FORM.username#' AND MbrPassword = '#FORM.password#' AND e.EstablishmentID = c.EstablishmentID /cfquery cfparam name=LastLogin default=#getLogOn.mbr_LoginDate# cfif (LastLogin IS ) OR (NOT IsDate(LastLogin)) cfset LastLogin=CreateODBCDateTime(2002-01-01 01:00:00) cfelse cfset LastLogin=CreateODBCDateTime(LastLogin) /cfif !--- Record found, login --- cfif getLogOn.RecordCount NEQ 0 cflock timeout=5 throwontimeout=no type=exclusive !--- Set the session vars --- cfset Session.LoggedIn = 1 !--- This session store the username --- cfset Session.LoggedUserID = #getLogOn.EstablishmentID# cfset Session.LoggedContactID = #getLogOn.ContactID# cfset Session.LoggedUser = #getLogOn.Establishment# cfset Session.LoggedUserFName = #getLogOn.Fname# cfset Session.LoggedUserLName = #getLogOn.Lname# cfset Session.LastLogin = #getLogon.mbr_LastLogin# /cflock !--- Store username inside a cookie if required --- cfif isDefined(FORM.remember_me) cfcookie name=abambrname value=#FORM.username# expires=never !--- Else, clean any existing cookie --- cfelse cfcookie name=abambrname value= expires=now /cfif !--- Update user logon date --- !--- cfquery datasource=#request.dsn# username=#request.dsnUsername# password=#request.dsnPassword# --- cfquery datasource=#request.dsn# UPDATE tbl_establishments SET Mbr_LastLogin = #LastLogin#, Mbr_LoginDate = #CreateODBCDateTime(Now())# where ABAMbrno = #Form.username# /cfquery !--- If the user requested a specific page, redirect there --- cfif IsDefined(FORM.redirect_to) cflocation addtoken=no url=#URLDecode(FORM.redirect_to)# cfelse cflocation addtoken=no url=mbrhome.cfm /cfif !--- Login failed --- cfelse !--- Store the application's name in a local var to reduce locking --- cflock timeout=5 throwontimeout=No type=readonly scope=application cfset appname=application.applicationname /cflock !--- Display an error message --- cfset LogOnError=Log on unsuccesful. No match was found. Please try again or contact administrator. /cfif /cfif cfif not isdefined(cookie.abambrname) cfcookie name=abambrname value= /cfif /cfsilent ~| 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:253469 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Element LOGGEDUSERFNAME is undefined in SESSION.
Are you sure the page throwing the error is not available to a user who is not logged in yet? What if a user made a book mark to a page only accessible when logged in, and then clicked the book mark after logging out? Do you cfparam those session values or check for their existence before accessing them in case the session had expired? Also, you are not throwing on time out. With a timeout of 5 seconds, what if your app timed out trying to set those variables, but since it didn't throw an error, continued to execute the page? ~Brad -Original Message- From: Peter Tanswell [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 5:06 PM To: CF-Talk Subject: Element LOGGEDUSERFNAME is undefined in SESSION. I keep on getting an error stating that an element is undefined in Session. I have checked the code but cant see why this is happening. Here is the section of code below. Thanks in advance for an assistance given. ~| 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:253470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 500 errors
Hi - I am having the exact same issues - see http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:47798 I am almost certain that the error Not enough storage is available to process this command, realy means the JVM has run out of memory which it can / is allowed to access It has always been accompanied by the error Error attempting to resolve the template error.cfm - which I presume is because it is trying to load the error handling template to handle the first error, but can't because it cannot allocate any memory. Confusing error messages to say the least - and it would appear to be due to a memory leak in CF (joy oh joy) :( Let me know if you find a resolution... Cheers, Dan. ~| 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:253471 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
It wasn't you who said it, it was someone else you replied to you and gave a link to his problem. Russ -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED] Sent: 18 September 2006 21:33 To: CF-Talk Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash Ok... I have read and reread the mail I sent - and I still can't see where I said I store large objects in session scope :-/ The server is currently only hosting a single application, which uses the seesion scope only for storing a small number of simple variables specific to the currently logged in user - and there is a restriction of 5 concurrent authenticated users on the system. I doubt therefore thatsession memory usage is the problem here. Cheers Dan. On 9/18/06, Snake [EMAIL PROTECTED] wrote: That fact that you have stated you store large objects in session scope is most likely your problem. If you are instantiating CFC's in session scope, then this uses tons of memory, as you are needlessly creating a new CFC instance for each user, and unless the cose is different for every single user, there is no need to do this. Better to cache a single copy in application scope. Russ ~| 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:253472 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Viaklix
Deanna, Give this a whirl - I haven't used viaklix in about 4 years with another client, worked then, params might be slightly different now. Let me know, as I'm getting ready to do on for a different client: cfsetting enablecfoutputonly=yes !--- Convert the four digit year to the last two digts-merge the month and year expiration to one four digit number --- CFLOCK SCOPE=SESSION TYPE=READONLY TIMEOUT=10 !--- Convert the year to two digits --- CFSET VARIABLES.expYY = Right(SESSION.ecom.CreditCardExpirationYear, 2) !--- Send the form variables to the Authorizing Agent --- CFHTTP URL=https://www.viaklix.com/process.asp; method=post CFHTTPPARAM type=FORMFIELD name=ssl_show_form value=FALSE CFHTTPPARAM type=FORMFIELD name=ssl_result_format value=ASCII CFHTTPPARAM type=FORMFIELD name=ssl_merchant_ID value=[providedID] CFHTTPPARAM type=FORMFIELD name=ssl_pin value=[providedpin] CFHTTPPARAM type=FORMFIELD name=ssl_transaction_type value=SALE CFHTTPPARAM type=FORMFIELD name=ssl_amount value=#VARIABLES.productprice# CFHTTPPARAM type=FORMFIELD name=ssl_description value=#VARIABLES.productName# CFHTTPPARAM type=FORMFIELD name=ssl_card_number value=#SESSION.ecom.CreditCardNumber# CFHTTPPARAM type=FORMFIELD name=ssl_exp_date value=#SESSION.ecom.CreditCardExpirationMonth##VARIABLES.expYY# CFHTTPPARAM type=FORMFIELD name=ssl_company value=#SESSION.ecom.BillToCompanyName# CFHTTPPARAM type=FORMFIELD name=ssl_first_name value=#SESSION.ecom.FirstName# CFHTTPPARAM type=FORMFIELD name=ssl_last_name value=#SESSION.ecom.LastName# CFHTTPPARAM type=FORMFIELD name=ssl_avs_address value=#SESSION.ecom.BillToAddress1# CFHTTPPARAM type=FORMFIELD name=ssl_city value=#SESSION.ecom.BillToCity# CFHTTPPARAM type=FORMFIELD name=ssl_state value=#SESSION.ecom.BillToStateProvince# CFHTTPPARAM type=FORMFIELD name=ssl_avs_zip value=#SESSION.ecom.BillToZipPostalCode# CFHTTPPARAM type=FORMFIELD name=ssl_country value=#SESSION.ecom.BillToCountry# CFHTTPPARAM type=FORMFIELD name=ssl_email value=#SESSION.ecom.EmailAddress# CFHTTPPARAM type=FORMFIELD name=ssl_phone value=#SESSION.ecom.DayPhoneCountryCode# #SESSION.ecom.DayPhoneAreaCode# #SESSION.ecom.DayPhoneNumber# /CFHTTP /CFLOCK !--- Retrieve the transaction results from the Credit Card Processor --- CFSET VARIABLES.ccpVars = #CFHTTP.FILECONTENT# !--- Convert the string to a comma-delimited format, replacing spaces with commas --- CFSET VARIABLES.ccpVars = REREPLACE(VARIABLES.ccpVars, [[:space:]], ,, ALL) !--- Assign a New variable to each of the comma delimited items in the list --- CFSET VARIABLES.ssl_result = ListFirst(VARIABLES.ccpVars) CFSET VARIABLES.ssl_result_message = ListGetAt(VARIABLES.ccpVars, 2) CFSET VARIABLES.ssl_txn_id = ListGetAt(VARIABLES.ccpVars, 3) CFSET VARIABLES.ssl_approval_code = ListGetAt(VARIABLES.ccpVars, 4) !--- Change the variable character length to keep only those characters to the right of the = sign --- CFSET URL.approved = RemoveChars(VARIABLES.ssl_result, 1, 11) CFSET VARIABLES.resultsMessage = RemoveChars(VARIABLES.ssl_result_message, 1, 19) CFSET VARIABLES.ccpTransactionID = RemoveChars(VARIABLES.ssl_txn_id, 1, 11) CFSET VARIABLES.ccpApprovalCode = RemoveChars(VARIABLES.ssl_approval_code, 1, 18) !--- Test Output of Variables --- !--- CFOUTPUT #URL.approved#br #VARIABLES.resultsMessage#br / #VARIABLES.ccpTransactionID#br / --- Thanks, Mark -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 1:59 PM To: CF-Talk Subject: Re: Viaklix From what I understand, it's just form posting. Not too complicated and really unrelated for the most part to the technology used. -d On 9/18/06, Jesse Kuhn [EMAIL PROTECTED] wrote: I am looking to use viaklix as well. Has anyone done this successfully yet... their developers guide only supports asp development. I am putting
Re: CFLog4j
Qasim, Do you have to adjust the log4j.appender.A1.File=D:/apachesites/playground/cflog4j/cflog4j3.log line?? What should happen when you hit testCFLogger.cfm? How does this differ from java.util.Logger? thanks On 9/18/06, Qasim Rasheed [EMAIL PROTECTED] wrote: Dan, Thanks for looking into this. I haven't used hibernate or cfhibernate so my knowledge about these is very limited. Qasim On 9/18/06, Dan Plesse [EMAIL PROTECTED] wrote: Qasin, Pretty cool. For cf hibernate you 500 null or something !--- cfset log4jconfig = createObject(java, org.apache.log4j.PropertyConfigurator) cfset log4jconfig.configure (C:\CFusionMX7\wwwroot\cfhibernate\src\log4j.properties) --- For your app I tested this cfset DansArray[1] = createObject(java, java.net.URL).init(file: Replace(getdirectoryfrompath(CF_TEMPLATE_PATH), /, \, ALL) log4j-1.2.13.jar)/ cfset log4j_PropertyConfigurator = createObject(java, coldfusion.bootstrap.BootstrapClassLoader ).SystemClassLoader.newInstance(DansArray).loadClass( org.apache.log4j.PropertyConfigurator).newInstance()/ cfset log4j_PropertyConfigurator.configure(C:\\CFusionMX7\\wwwroot\\cflog4j.properties) and it worked ~| 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:253474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Viaklix
Mark, Thanks a million! I'll get to work and let you know how things go. Jesse Give this a whirl - I haven't used viaklix in about 4 years with another client, worked then, params might be slightly different now. Let me know, as I'm getting ready to do on for a different client: ~| 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:253475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cybersource CF
anybody have a cybersource payment gateway script that they'd like to share? Hi RayI do have code for integrating it into CFWebstore if that's what you are looking for. Although I would expect you could easily figure it out from that for another use as well. --- Mary Jo Sminkey www.cfwebstore.com Author of CFWebstore, ColdFusion Ecommerce ~| 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:253476 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cybersource CF
Hi Mary, I have the same need for the scripts that would integrate cybersource into CF shopping cart. I am new to this list. How do you prefer to share it? anybody have a cybersource payment gateway script that they'd like to share? Hi RayI do have code for integrating it into CFWebstore if that's what you are looking for. Although I would expect you could easily figure it out from that for another use as well. --- Mary Jo Sminkey www.cfwebstore.com Author of CFWebstore, ColdFusion Ecommerce ~| 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:253477 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Session.UrlToken on form post in CF7
We've just updated to CF7 on our dev server. Code that worked on CF6.1 is now breaking. On a form post, to a different subdomain, I am passing the session.urltoken in the action URL to ensure we get the right session (it's the same server, just a different subdomain). The jsessionid ends up being incorrect on the other page and we get the wrong session. I have confirmed that changing the action to a GET (and making no other changes) gives the correct result. In other words, the POST action is ignoring the passed jsessionid while a GET doesn't. Can anyone confirm this in CF 7.0.2 and does anyone have a fix (other than a GET if possible). -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| 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:253478 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLog4j
Dan, I have just uploaded a newer version of the code. This line in cflog4j.properties log4j.appender.A1.File=D:/apachesites/playground/cflog4j/cflog4j3.log define the file where log will be written. Once you run, you should see the info message in the above mentioned log file. However if you change the category logging level to 'DEBUG', you should also see a debug log in that file. Thanks, Qasim On 9/18/06, Dan Plesse dan.pleDan,[EMAIL PROTECTED] wrote: Qasim, Do you have to adjust the log4j.appender.A1.File=D:/apachesites/playground/cflog4j/cflog4j3.logline?? What should happen when you hit testCFLogger.cfm? How does this differ from java.util.Logger? thanks On 9/18/06, Qasim Rasheed [EMAIL PROTECTED] wrote: Dan, Thanks for looking into this. I haven't used hibernate or cfhibernate so my knowledge about these is very limited. Qasim On 9/18/06, Dan Plesse [EMAIL PROTECTED] wrote: Qasin, Pretty cool. For cf hibernate you 500 null or something !--- cfset log4jconfig = createObject(java, org.apache.log4j.PropertyConfigurator) cfset log4jconfig.configure (C:\CFusionMX7\wwwroot\cfhibernate\src\log4j.properties) --- For your app I tested this cfset DansArray[1] = createObject(java, java.net.URL ).init(file: Replace(getdirectoryfrompath(CF_TEMPLATE_PATH), /, \, ALL) log4j-1.2.13.jar)/ cfset log4j_PropertyConfigurator = createObject(java, coldfusion.bootstrap.BootstrapClassLoader ).SystemClassLoader.newInstance(DansArray).loadClass( org.apache.log4j.PropertyConfigurator).newInstance()/ cfset log4j_PropertyConfigurator.configure(C:\\CFusionMX7\\wwwroot\\cflog4j.properties) and it worked ~| 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:253479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Session.UrlToken on form post in CF7
James - Rupesh blogged about this very issue recently: http://coldfused.blogspot.com/2006/09/handling-j2ee-session-with-cookies _12.html -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 7:17 AM To: CF-Talk Subject: Session.UrlToken on form post in CF7 We've just updated to CF7 on our dev server. Code that worked on CF6.1 is now breaking. On a form post, to a different subdomain, I am passing the session.urltoken in the action URL to ensure we get the right session (it's the same server, just a different subdomain). The jsessionid ends up being incorrect on the other page and we get the wrong session. I have confirmed that changing the action to a GET (and making no other changes) gives the correct result. In other words, the POST action is ignoring the passed jsessionid while a GET doesn't. Can anyone confirm this in CF 7.0.2 and does anyone have a fix (other than a GET if possible). ~| 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:253480 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Hi Dan, Based on the description of the problem, it appears that the CF Server is hanging beforehand and timed out requests/memory growing large are the after affects. There could be many reasons that cause the server to hang. Since the server is not crashing completely, the thread dump could provide very useful information. Please refer to the following technote as to how to get a thread dump: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18339 It will be great if you can send the thread dump to [EMAIL PROTECTED] One more piece of information that can be useful is, if you have applied any CHF(Cumulative Hot Fix) on the server. If yes, please let me know that as well. Thanks, Praveen. We have had the following issue with Macromedia ColdFusion 7 (7.0.1. 116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX 7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException. cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion ? eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash ? which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur ? (although I did not record full details for the first time ? and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic ? previously to experiencing these problems, the server had been hosting an online competition, handling around 30 simultaneous users during busy periods, and never having a window of more than 20 minutes inactivity. This did make me wonder if it might be an issue with the Garbage Collection Process? Has anyone Experienced this problem, or got any ideas as to how to resolve it? Thanks, Dan. ~| 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:253481 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
