RE: IIRF Rewrite Rules
Thanks pal that worked an absolute charm. Rob -Original Message- From: AJ Mercer [mailto:[EMAIL PROTECTED] Sent: 19 March 2007 00:16 To: CF-Talk Subject: Re: IIRF Rewrite Rules Try this out # www.mydomain.com/articles/6/i-wonder-how-i-achieve-this RewriteRule (?i)^/articles/([^/]+)/([^/]+) /index.cfm?event=viewarticlearticleid=$1 This rule would also put 'i-wonder-how-i-achieve-this' into $2 On 3/19/07, Robert Rawlins [EMAIL PROTECTED] wrote: Hello Guys, My regex is pretty poor to be honest, and its somthing i REALLY need to start learning, so in addition to any help on this some reccomendations of books or resources on the subject would be greatly appreciated. I've currently got a bunch of urls for model-glue events, and most importantly a section for news reports, and further down the line blog posts. these looking somthing like this. www.mydomain.com/index.cfm?event=viewarticlearticleid=6 Now what i'd like to achieve with the rewrite would be to use somthing like this. www.mydomain.com/articles/6/i-wonder-how-i-achieve-this So i can then link to my articles using the ID but also contain the title in the URL for the search engine friendlyness. How would the regex for this kind of thing plan out? Many thanks, Rob ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272967 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Weird Trouble with CF + MySQL.
I'm having this problem. The query works fine directly on the database, but when used on coldfusion it gives this error. If I copy the string from the sql field here, and executes on mysql , it works fine again. Don't get what can be wrong. Maybe CF is doing something stupid when talking to the datasource? Error Executing Database Query. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select b.id_article, group_concat( c.name order by c.use The error occurred in D:\Hosting\myCFC\article2.cfc: line 5 Called from D:\Hosting\article\article2.cfm: line 5 Called from D:\Hosting\myCFC\article2.cfc: line 5 Called from D:\Hosting\article\article2.cfm: line 5 3 : cffunction name=ListArticles access=remote returntype=query 4 : cfargument name=dsn type=string required=yes 5 : cfquery name=qListArticles datasource=#dsn# 6 : select a.id_article, a.title, u.users, t.tags 7 : from articles as a SQLselect a.id_article, a.title, u.users, t.tags from articles as a left outer join ( select b.id_article, group_concat( c.name order by c.userseparator ', ') as users from articlexuser as b inner join users as c on c.id_user = b.id_user group by b.id_article ) as u on u.id_article = a.id_article left outer join ( select d.id_article, group_concat( e.tagorder by e.tag separator ', ') as tags from articlextags as d inner join tags as e on e.id_tag = d.id_tag group by d.id_article ) as t on t.id_article = a.id_article ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272968 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dealing with Reactor Record Objects
Hello Guys, A quick 'best practice' type question when it comes to dealing with record objects/beans within the model-glue MVC pattern. At the moment I'm working on a template that displays a news article, so in my event I have a broadcast that says 'NeedArticle', this then gets dealt with by my articlesController.cfc and a method called 'getArticle'. The method uses code like this to get the elements I require and then place them into the viewState. cfscript // Create temporary local structure var LOCAL = structNew(); // Create the article data object LOCAL.Article = getModelGlue().getOrmService().createRecord(Article); // Load Article LOCAL.Article.setArticleID(ARGUMENTS.Event.getValue(ID)); LOCAL.Article.load(); // Set Document Elements LOCAL.Title = LOCAL.Article.getTitle(); LOCAL.SubTitle = LOCAL.Article.getSubTitle(); LOCAL.Body = LOCAL.Article.getBody(); LOCAL.Created = LOCAL.Article.getCreated(); LOCAL.Modified = LOCAL.Article.getModified(); LOCAL.Source = LOCAL.Article.getSource(); LOCAL.SourceLink = LOCAL.Article.getSourceLink(); // Build elements into event ARGUMENTS.Event.Trace(Article Created, LOCAL.Created); ARGUMENTS.Event.setValue(Created, LOCAL.Created); ARGUMENTS.Event.Trace(Article Modified, LOCAL.Modified); ARGUMENTS.Event.setValue(Modified, LOCAL.Modified); ARGUMENTS.Event.Trace(Article Source, LOCAL.Source); ARGUMENTS.Event.setValue(Source, LOCAL.Source); ARGUMENTS.Event.Trace(Article SourceLink, LOCAL.SourceLink); ARGUMENTS.Event.setValue(SourceLink, LOCAL.SourceLink); ARGUMENTS.Event.Trace(Article Title, LOCAL.Title); ARGUMENTS.Event.setValue(ArtTitle, LOCAL.Title); ARGUMENTS.Event.Trace(Article Sub Title, LOCAL.SubTitle); ARGUMENTS.Event.setValue(SubTitle, LOCAL.SubTitle); ARGUMENTS.Event.Trace(Article Body, LOCAL.Body); ARGUMENTS.Event.setValue(Body, LOCAL.Body); /cfscript Should I be doing it like this? Or should I just place the entire record object into the viewstate and then call the getter functions from my view? Thanks for the advice, Rob ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272969 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Desk / Trouble Ticket recommendation?
I'll second this as one worth looking at. I used CFTicket in a previous job, and liked it a great deal. I had to do some fairly extensive modifications (primarily adding Oracle support, and also some other business-specific features). I found the code to be well organized and easy to work with, which is rather important if you actually intend to make modifications. Also Andrew, I think that CFTicket would work well for you based on your privacy requirements. At it's core it's e-mail driven - each queue in the system has a corresponding POP mail box. All e-mail correspondence is between the requester and the system, and you can set fairly granular permissions for each queue, so if it's a sensitive issue, you could put the ticket into a restricted queue to limit who can see the requesters personal info, and none of the people managing tickets ever has to have their personal info involved (since the messages come from the queue address, not an employee address). On 3/17/07, Cedric Villat [EMAIL PROTECTED] wrote: Andrew, shameless_plug We make CFTicket, which is written in ColdFusion and is open source (not free, but affordable). You can see it at www.cornfeed.com. It sounds like it does what you want, but you can check it out as there is an online demo you can play with. /shameless_plug ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Weird Trouble with CF + MySQL.
Would this line be your culprit? Maybe it has gotten combined due to the paste operation, but shouldn't it be (e.tag order by e.tag separator ', ') ( e.tagorder by e.tag separator ', ') -Original Message- From: Adrien Akkhazza R. Cardoso [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 4:07 AM To: CF-Talk Subject: Weird Trouble with CF + MySQL. I'm having this problem. The query works fine directly on the database, but when used on coldfusion it gives this error. If I copy the string from the sql field here, and executes on mysql , it works fine again. Don't get what can be wrong. Maybe CF is doing something stupid when talking to the datasource? Error Executing Database Query. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select b.id_article, group_concat( c.name order by c.use The error occurred in D:\Hosting\myCFC\article2.cfc: line 5 Called from D:\Hosting\article\article2.cfm: line 5 Called from D:\Hosting\myCFC\article2.cfc: line 5 Called from D:\Hosting\article\article2.cfm: line 5 3 : cffunction name=ListArticles access=remote returntype=query 4 : cfargument name=dsn type=string required=yes 5 : cfquery name=qListArticles datasource=#dsn# 6 : select a.id_article, a.title, u.users, t.tags 7 : from articles as a SQLselect a.id_article, a.title, u.users, t.tags from articles as a left outer join ( select b.id_article, group_concat( c.name order by c.userseparator ', ') as users from articlexuser as b inner join users as c on c.id_user = b.id_user group by b.id_article ) as u on u.id_article = a.id_article left outer join ( select d.id_article, group_concat( e.tagorder by e.tag separator ', ') as tags from articlextags as d inner join tags as e on e.id_tag = d.id_tag group by d.id_article ) as t on t.id_article = a.id_article ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272971 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Desk / Trouble Ticket recommendation?
I second Jira, we use it too and with the Jira eclipse plugin or with myra it rocks in eclipse. On 3/17/07, Richard Kroll [EMAIL PROTECTED] wrote: I highly recommend Jira (www.atlassian.com) Its Java based and once you purchase the application, you have access to the source. It is configurable to a degree that I've never seen in any other app. Has SVN integration, an active community of plug-in developers, web service availability, can run on tomcat, I could go on for days (I'm a BIG fan!). My 2 cents... Rich Kroll -Original Message- From: Andrew Peterson [mailto:[EMAIL PROTECTED] Sent: Friday, March 16, 2007 5:00 PM To: CF-Talk Subject: Help Desk / Trouble Ticket recommendation? Can someone recommend a good help desk/trouble ticket system? The ideal application would be cf based and open source. Thanks. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272972 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help Desk / Trouble Ticket recommendation?
The www.cornfeed.com seems to have been down for the past 3 or 4 days. I'm also in the market for a ticket system and would be keen to take a look around this, I did look into building a custom system a while back but it's quite a hefty project for what will essentially be a low traffic section of my application. Rob -Original Message- From: Doug Bezona [mailto:[EMAIL PROTECTED] Sent: 19 March 2007 12:32 To: CF-Talk Subject: Re: Help Desk / Trouble Ticket recommendation? I'll second this as one worth looking at. I used CFTicket in a previous job, and liked it a great deal. I had to do some fairly extensive modifications (primarily adding Oracle support, and also some other business-specific features). I found the code to be well organized and easy to work with, which is rather important if you actually intend to make modifications. Also Andrew, I think that CFTicket would work well for you based on your privacy requirements. At it's core it's e-mail driven - each queue in the system has a corresponding POP mail box. All e-mail correspondence is between the requester and the system, and you can set fairly granular permissions for each queue, so if it's a sensitive issue, you could put the ticket into a restricted queue to limit who can see the requesters personal info, and none of the people managing tickets ever has to have their personal info involved (since the messages come from the queue address, not an employee address). On 3/17/07, Cedric Villat [EMAIL PROTECTED] wrote: Andrew, shameless_plug We make CFTicket, which is written in ColdFusion and is open source (not free, but affordable). You can see it at www.cornfeed.com. It sounds like it does what you want, but you can check it out as there is an online demo you can play with. /shameless_plug ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272973 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Fire Department Blotter Program
I am working with a local volunteer fire department that needs a daily blotter (log) program for keeping a running log of activities and runs into a MS SQL database. Anyone heard of anything already created in CF? Thanks in Advance, Kent ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272974 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using queryname.columnlist
Hi All, I have a data import project that I am trying to simplify, mainly because of the number of tables and amount of data involved. I'm importing a number of tables from a MySQL database to an MS SQL Server database with an identical structure, except for datatypes being changed where appropriate. The problem is, in my code I am ending up passing in the column name rather than the actual column value. Can anyone tell me what I'm doing wrong? Here's my code: cfscript function sqlValueFormat(field) { if (isNumeric(field)) { field = trim(field); } else { field = ' trim(field) '; } return field; } /cfscript cfset table_list = table1, table2, table3, table4, table5, table6 cfloop index=I list=#table_list# delimiters=, cfquery name=getall datasource=db_mysql SELECT * FROM#trim(i)# /cfquery cfquery name=insertAll datasource=db_mssql cfloop query=getall INSERT INTO #trim(i)#(#getall.columnlist#) VALUES (cfloop list=#getall.columnlist# index=j delimiters=,#sqlValueFormat(evaluate(j))#cfif NOT listLast(getall.columnlist, ,),/cfif/cfloop); /cfloop /cfquery /cfloop The error that I'm getting is cannot convert the value STAMP to a boolean -- STAMP is a column name in the table, not the actual chunk of data, which is what I want. Thanks! Pete ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272975 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Can anyone tell me why someone would do this?
I inherited a web site that is having session management issues, and using a good amount of ram. In the application.cfm file, there is the following session code: cfapplication sessionmanagement=yes name=#Hash(GetCurrentTemplatePath())# setclientcookies=no Now, can anyone tell me why you would want, on a web site that requires users to login, to set the session name based on the template? Chris ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272976 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Can anyone tell me why someone would do this?
Doesn't make much sense. -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 8:26 AM To: CF-Talk Subject: Can anyone tell me why someone would do this? I inherited a web site that is having session management issues, and using a good amount of ram. In the application.cfm file, there is the following session code: cfapplication sessionmanagement=yes name=#Hash(GetCurrentTemplatePath())# setclientcookies=no Now, can anyone tell me why you would want, on a web site that requires users to login, to set the session name based on the template? Chris ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272977 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can anyone tell me why someone would do this?
It's the application name, not the session name. We do something like this on our dev server, so each developer can have independent instances of the application without stepping on each others application and session scopes, etc. and without having to remember to manually rename the application for each instance. On 3/19/07, Peterson, Chris [EMAIL PROTECTED] wrote: I inherited a web site that is having session management issues, and using a good amount of ram. In the application.cfm file, there is the following session code: cfapplication sessionmanagement=yes name=#Hash(GetCurrentTemplatePath())# setclientcookies=no Now, can anyone tell me why you would want, on a web site that requires users to login, to set the session name based on the template? Chris ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272978 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: downloading large files via cfhttp
I think you're probably asking for trouble. I tried using Coldfusion to download a 7meg SQL file once and it crashed out every time. -Original Message- From: Dov Katz [mailto:[EMAIL PROTECTED] Sent: Saturday, March 17, 2007 7:46 PM To: CF-Talk Subject: downloading large files via cfhttp If I need to cfschedule a 10-40 mb download, is cfhttp going to buffer the entire input to memory if I specify a file to write it to? Also concerned about losing an available thread. I'm trying to basically do a wget in coldfusion and don't want to lose an available thread while I do it. Here's my planned. Is something like this available somewhere? What do you think? Cfx_wget url= destinationFile=. Callbackurl=localhost/callback.cfm Calling this gets a uuid Then I write a java class to kick off a thread (thread name is the uuid the cfx returned) to write a url input stream to the specified file and then hit the callback url when done, with all the params of the tag call and the http status code of the get operation. I can also ask this thread what its status is and/or cancel it by looking for the thread by its uuid name. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272979 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Can anyone tell me why someone would do this?
It looks like an attempt to keep folks from accessing individual pages, without going through some kind of entrance page. Hth sas -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 9:26 AM To: CF-Talk Subject: Can anyone tell me why someone would do this? I inherited a web site that is having session management issues, and using a good amount of ram. In the application.cfm file, there is the following session code: cfapplication sessionmanagement=yes name=#Hash(GetCurrentTemplatePath())# setclientcookies=no Now, can anyone tell me why you would want, on a web site that requires users to login, to set the session name based on the template? Chris ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272980 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can anyone tell me why someone would do this?
Peterson, Chris wrote: I inherited a web site that is having session management issues, and using a good amount of ram. In the application.cfm file, there is the following session code: cfapplication sessionmanagement=yes name=#Hash(GetCurrentTemplatePath())# setclientcookies=no Now, can anyone tell me why you would want, on a web site that requires users to login, to set the session name based on the template? Chris Perhaps they used the same application template for multiple applications on the same server, and this was their shortcut way of making sure that the application names didn't conflict. Or, was the application meant for shared hosting...this may have been a way to make sure there wasn't any conflict there. I doubt if that in itself is causing your session management issues, it produces a valid...though unreadable...application name. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272981 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: downloading large files via cfhttp
You could use cfexecute to launch a wget at the command line. I have did this before. Make sure that you use the time out options in the wget statement so you do not get caught with hung wget threads cfexecute allows you to launch the command and return to the page. The above method is not full proof because you do not know if the wget is successful or not. The cfexecute could call a script file that would do the wget, check to see the wget was successful and then issue another wget to call the cf page to do the call back and the rest of the processing -Randy - Original Message - From: Andy Matthews [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 19, 2007 9:33 AM Subject: RE: downloading large files via cfhttp I think you're probably asking for trouble. I tried using Coldfusion to download a 7meg SQL file once and it crashed out every time. -Original Message- From: Dov Katz [mailto:[EMAIL PROTECTED] Sent: Saturday, March 17, 2007 7:46 PM To: CF-Talk Subject: downloading large files via cfhttp If I need to cfschedule a 10-40 mb download, is cfhttp going to buffer the entire input to memory if I specify a file to write it to? Also concerned about losing an available thread. I'm trying to basically do a wget in coldfusion and don't want to lose an available thread while I do it. Here's my planned. Is something like this available somewhere? What do you think? Cfx_wget url= destinationFile=. Callbackurl=localhost/callback.cfm Calling this gets a uuid Then I write a java class to kick off a thread (thread name is the uuid the cfx returned) to write a url input stream to the specified file and then hit the callback url when done, with all the params of the tag call and the http status code of the get operation. I can also ask this thread what its status is and/or cancel it by looking for the thread by its uuid name. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Can anyone tell me why someone would do this?
We do something like this because our development server has both an area for the dev projects but also for client-betas (duplicate of the code base with public facing access). We use the HASHing to make sure the two applications don't start overwriting each other's cached values. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 9:26 AM To: CF-Talk Subject: Can anyone tell me why someone would do this? I inherited a web site that is having session management issues, and using a good amount of ram. In the application.cfm file, there is the following session code: cfapplication sessionmanagement=yes name=#Hash(GetCurrentTemplatePath())# setclientcookies=no Now, can anyone tell me why you would want, on a web site that requires users to login, to set the session name based on the template? Chris ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272983 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfc and wsdl
Hello, I am playing with cfcs and what I am reading so far I should be able to hit the cfc with ?wsdl on the end and get WSDL. Here is my test cfc right out of the help files: cfcomponent cffunction name = echoString returnType = string output = no access = remote cfargument name = input type = string cfreturn #arguments.input# /cffunction /cfcomponent I get the following: AXIS error Sorry, something seems to have gone wrong... here are the details: Fault - Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272984 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfc and wsdl
Your CFC has to be set to remote. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 9:07 AM To: CF-Talk Subject: cfc and wsdl Hello, I am playing with cfcs and what I am reading so far I should be able to hit the cfc with ?wsdl on the end and get WSDL. Here is my test cfc right out of the help files: cfcomponent cffunction name = echoString returnType = string output = no access = remote cfargument name = input type = string cfreturn #arguments.input# /cffunction /cfcomponent I get the following: AXIS error Sorry, something seems to have gone wrong... here are the details: Fault - Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272985 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfc and wsdl
It is set to remote. I just copied the cfc to our production server and it works fine. I get good WSDL. It has something to do with out development server. They are the same server versions. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 10:13 AM To: CF-Talk Subject: RE: cfc and wsdl Your CFC has to be set to remote. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 9:07 AM To: CF-Talk Subject: cfc and wsdl Hello, I am playing with cfcs and what I am reading so far I should be able to hit the cfc with ?wsdl on the end and get WSDL. Here is my test cfc right out of the help files: cfcomponent cffunction name = echoString returnType = string output = no access = remote cfargument name = input type = string cfreturn #arguments.input# /cffunction /cfcomponent I get the following: AXIS error Sorry, something seems to have gone wrong... here are the details: Fault - Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272986 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfc and wsdl
Check to see if either server has a root mapping (i.e. / is mapped to something) and if there are any other differences between the mappings on the boxes. On 3/19/07, Chad Gray [EMAIL PROTECTED] wrote: It is set to remote. I just copied the cfc to our production server and it works fine. I get good WSDL. It has something to do with out development server. They are the same server versions. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 10:13 AM To: CF-Talk Subject: RE: cfc and wsdl Your CFC has to be set to remote. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 9:07 AM To: CF-Talk Subject: cfc and wsdl Hello, I am playing with cfcs and what I am reading so far I should be able to hit the cfc with ?wsdl on the end and get WSDL. Here is my test cfc right out of the help files: cfcomponent cffunction name = echoString returnType = string output = no access = remote cfargument name = input type = string cfreturn #arguments.input# /cffunction /cfcomponent I get the following: AXIS error Sorry, something seems to have gone wrong... here are the details: Fault - Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Passing along: TechRepublic on Coldfusion
Worth a look, from today's NetNote email: Implement the State pattern with ColdFusion Components The introduction of ColdFusion Components (CFCs) in ColdFusion MX opened the door to more object-oriented programming (OOP) in CF. When application developers start thinking about OOP, the idea of design patterns almost always comes up. In that context, Brian Kotek discusses the State pattern: its purpose, the problems it can solve, and how you can implement it using CFCs. [http://downloads.techrepublic.com.com/abstract.aspx?docid=286546tag=nl.e606] Check out other downloads about ColdFusion Best practices for using ColdFusion Components [http://downloads.techrepublic.com.com/download.aspx?docid=173189tag=nl.e606] Use ColdFusion to develop dynamic reports [http://downloads.techrepublic.com.com/download.aspx?docid=173096tag=nl.e606] Create a simple shopping cart using ColdFusion [http://downloads.techrepublic.com.com/download.aspx?docid=173530tag=nl.e606] FWIW, Jerry Johnson ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272988 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfc and wsdl
Oh... yes the development server has this mapping: / C:\CFusionMX7\wwwroot The production server does not have this mapping. Should I remove this mapping? One of the other developers must have made it and I will need to find out why. -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 10:36 AM To: CF-Talk Subject: Re: cfc and wsdl Check to see if either server has a root mapping (i.e. / is mapped to something) and if there are any other differences between the mappings on the boxes. On 3/19/07, Chad Gray [EMAIL PROTECTED] wrote: It is set to remote. I just copied the cfc to our production server and it works fine. I get good WSDL. It has something to do with out development server. They are the same server versions. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 10:13 AM To: CF-Talk Subject: RE: cfc and wsdl Your CFC has to be set to remote. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 9:07 AM To: CF-Talk Subject: cfc and wsdl Hello, I am playing with cfcs and what I am reading so far I should be able to hit the cfc with ?wsdl on the end and get WSDL. Here is my test cfc right out of the help files: cfcomponent cffunction name = echoString returnType = string output = no access = remote cfargument name = input type = string cfreturn #arguments.input# /cffunction /cfcomponent I get the following: AXIS error Sorry, something seems to have gone wrong... here are the details: Fault - Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272989 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
TIFF image converstion (cfc)
Hello, I would like to know if anyone knows of an coldfusion compatible cfc/tag that converts tiff files to jpeg and can manipulate them on the fly. Be great if you have actual experience with it. Currently, I'm using something called ACDSee to convert them periodically, but it's a pain to have to remember to do that all the time. Was looking into something called 'jimg', but it's not available anymore. We have Coldfusion 6.1 JRun 4 updater 6, and jvm 1.4.2_12 Thanks, Doug p.s. Hope all it well with everyone, long time no post. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272990 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using queryname.columnlist
You want to evaluate field to its value if (isNumeric(field)) { field = trim(evaluate(field)); } else { field = ' trim(evaluate(field)) '; } return field; Mik At 09:21 AM 3/19/2007, Pete Ruckelshaus wrote: Hi All, I have a data import project that I am trying to simplify, mainly because of the number of tables and amount of data involved. I'm importing a number of tables from a MySQL database to an MS SQL Server database with an identical structure, except for datatypes being changed where appropriate. The problem is, in my code I am ending up passing in the column name rather than the actual column value. Can anyone tell me what I'm doing wrong? Here's my code: cfscript function sqlValueFormat(field) { if (isNumeric(field)) { field = trim(field); } else { field = ' trim(field) '; } return field; } /cfscript cfset table_list = table1, table2, table3, table4, table5, table6 cfloop index=I list=#table_list# delimiters=, cfquery name=getall datasource=db_mysql SELECT * FROM#trim(i)# /cfquery cfquery name=insertAll datasource=db_mssql cfloop query=getall INSERT INTO #trim(i)#(#getall.columnlist#) VALUES (cfloop list=#getall.columnlist# index=j delimiters=,#sqlValueFormat(evaluate(j))#cfif NOT listLast(getall.columnlist, ,),/cfif/cfloop); /cfloop /cfquery /cfloop The error that I'm getting is cannot convert the value STAMP to a boolean -- STAMP is a column name in the table, not the actual chunk of data, which is what I want. Thanks! Pete ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272991 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TIFF image converstion (cfc)
They are not a CFCs, but CFXs and work great! http://efflare.com/ ImageCR and ImageFlare are powerful tools and I have been using them for years with millions of images with no problems. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 10:41 AM To: CF-Talk Subject: TIFF image converstion (cfc) Hello, I would like to know if anyone knows of an coldfusion compatible cfc/tag that converts tiff files to jpeg and can manipulate them on the fly. Be great if you have actual experience with it. Currently, I'm using something called ACDSee to convert them periodically, but it's a pain to have to remember to do that all the time. Was looking into something called 'jimg', but it's not available anymore. We have Coldfusion 6.1 JRun 4 updater 6, and jvm 1.4.2_12 Thanks, Doug p.s. Hope all it well with everyone, long time no post. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using queryname.columnlist
I would modify the code to eliminate evaludate cfscript function sqlValueFormat(field) { if (isNumeric(field)) { field = trim(field); } else { field = ' trim(field) '; } return field; } /cfscript cfset table_list = table1, table2, table3, table4, table5, table6 cfset k = 1 / cfloop index=i list=#table_list# delimiters=, cfquery name=getall datasource=db_mysql SELECT * FROM#trim(i)# /cfquery cfloop query=getall cfquery datasource=db_mssql INSERT INTO #trim(i)# cfloop list=#getall.columnlist# index=j #j# cfif k LT ListLen( getall.columnlist ),/cfif cfset k = k + 1 / /cfloop cfset k = 1 / VALUES ( cfloop list=#getall.columnlist# index=j #sqlValueFormat( getall[j][currentrow] )# cfif k LT ListLen( getall.columnlist ),/cfif cfset k = k + 1 / /cfloop ) /cfquery /cfloop /cfloop On 3/19/07, Mik Muller [EMAIL PROTECTED] wrote: You want to evaluate field to its value if (isNumeric(field)) { field = trim(evaluate(field)); } else { field = ' trim(evaluate(field)) '; } return field; Mik At 09:21 AM 3/19/2007, Pete Ruckelshaus wrote: Hi All, I have a data import project that I am trying to simplify, mainly because of the number of tables and amount of data involved. I'm importing a number of tables from a MySQL database to an MS SQL Server database with an identical structure, except for datatypes being changed where appropriate. The problem is, in my code I am ending up passing in the column name rather than the actual column value. Can anyone tell me what I'm doing wrong? Here's my code: cfscript function sqlValueFormat(field) { if (isNumeric(field)) { field = trim(field); } else { field = ' trim(field) '; } return field; } /cfscript cfset table_list = table1, table2, table3, table4, table5, table6 cfloop index=I list=#table_list# delimiters=, cfquery name=getall datasource=db_mysql SELECT * FROM#trim(i)# /cfquery cfquery name=insertAll datasource=db_mssql cfloop query=getall INSERT INTO #trim(i)#(#getall.columnlist#) VALUES (cfloop list=#getall.columnlist# index=j delimiters=,#sqlValueFormat(evaluate(j))#cfif NOT listLast(getall.columnlist, ,),/cfif/cfloop); /cfloop /cfquery /cfloop The error that I'm getting is cannot convert the value STAMP to a boolean -- STAMP is a column name in the table, not the actual chunk of data, which is what I want. Thanks! Pete ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272993 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Create an Excel Spreadsheet
If you use an html table instead and use TH, the TH will transfer over as column headers in Excel. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Paymentech ...
1) Which gateway are you using? Linkpoint, Authorize.net or Orbital? 2) I use JS script to disable the submit button to prevent multiple submissions ... There are two options ... 1) place in the submit button: onclick=this.disabled=true; or (my prefered) 2) place in the form validation script document.getElementById('submit_button').disabled=false; if the validation fails, just turn it back on :-) ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272995 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Paymentech ...
I'm not quite sure what problem this is referring too, but I'd say that relying on client side only authentication for this kind of thing is pretty ropey, id look to implement something server side that won't break if the user has scripting disabled. Rob -Original Message- From: Ashley Brandwood [mailto:[EMAIL PROTECTED] Sent: 19 March 2007 15:04 To: CF-Talk Subject: Paymentech ... 1) Which gateway are you using? Linkpoint, Authorize.net or Orbital? 2) I use JS script to disable the submit button to prevent multiple submissions ... There are two options ... 1) place in the submit button: onclick=this.disabled=true; or (my prefered) 2) place in the form validation script document.getElementById('submit_button').disabled=false; if the validation fails, just turn it back on :-) ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272996 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Create an Excel Spreadsheet
I'm not sure how flexible it is, but I know in the past when working with Excel sheets I always worked with the XML model as it allowed quite a nice set of features. Without the funny hacks of changing HTML into excel files. Rob -Original Message- From: Dana Kowalski [mailto:[EMAIL PROTECTED] Sent: 19 March 2007 14:58 To: CF-Talk Subject: Re: Create an Excel Spreadsheet If you use an html table instead and use TH, the TH will transfer over as column headers in Excel. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272997 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Debugging?
Is there a way to have Debugging turned OFF for one site but on for everything else? I am building an internal application and would like the Debugging on that site off. Since developers are using the same server for other applications, the debugging (CF Admin settings) is turned on. TIA! ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272998 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE:_Debugging?
cfsetting showdebugoutput=no If you want it to be site wide stick it in your application.cfm -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 11:30 AM To: CF-Talk Subject: Debugging? Is there a way to have Debugging turned OFF for one site but on for everything else? I am building an internal application and would like the Debugging on that site off. Since developers are using the same server for other applications, the debugging (CF Admin settings) is turned on. TIA! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Object Instantiation Error
Thank you for your response Janet. You nailed the issue. It works now. I really appreciate this! Thanks again! -Original Message- From: Janet MacKay [mailto:[EMAIL PROTECTED] Sent: Saturday, March 17, 2007 11:48 PM To: CF-Talk Subject: Re: Object Instantiation Error There shouldn't be a (space) in between the double quote and the start of the class name. Remove the space and it should work. cfscript exifReader = createObject(java, (space)com.drew.imaging.coldfusion.CFreadExif); /cfscipt ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273000 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: _Debugging?
DOH!! DAMMIT!! How stupid of me! Thanks Chad -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 11:33 AM To: CF-Talk Subject: RE:_Debugging? cfsetting showdebugoutput=no If you want it to be site wide stick it in your application.cfm -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 11:30 AM To: CF-Talk Subject: Debugging? Is there a way to have Debugging turned OFF for one site but on for everything else? I am building an internal application and would like the Debugging on that site off. Since developers are using the same server for other applications, the debugging (CF Admin settings) is turned on. TIA! ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273001 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Debugging?
Sure is, in cfadmin under debugging settings Debugging Logging Debugging IP List , add the IP address for debug output. Bob -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 10:30 AM To: CF-Talk Subject: Debugging? Is there a way to have Debugging turned OFF for one site but on for everything else? I am building an internal application and would like the Debugging on that site off. Since developers are using the same server for other applications, the debugging (CF Admin settings) is turned on. TIA! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
TC's and Privacy Policy
Hello Guys, I'm looking for a pretty standard 'terms and conditions' I can sit on my site, after googling around a little it seems that most firms want you to cough up money for a copy. Does anyone have a fairly generic terms and conditions as well as a privacy policy they wouldn't mind sharing? Thanks, Rob ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273003 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TC's and Privacy Policy
If you can't find anything, you might want to just find one you like on another site and swap out the names ;) I have no idea of the legal ramifications of this... Does the copy right cover the copy right itself??? .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 11:39 AM To: CF-Talk Subject: TC's and Privacy Policy Hello Guys, I'm looking for a pretty standard 'terms and conditions' I can sit on my site, after googling around a little it seems that most firms want you to cough up money for a copy. Does anyone have a fairly generic terms and conditions as well as a privacy policy they wouldn't mind sharing? Thanks, Rob ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273004 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: _Debugging?
To add a little overkill to this thread, I like to do something similar to the following (please note this code is very trimmed down): --- in application.cfc: cffunction name=onRequestEnd cfparam name=URL.debug default=false / cfsetting showdebugoutput=#URL.debug# / /cffunction Then you can show debug output whenever you want by specifying http://myURL.com?debug=true -- this is especially helpful when using AJAX or other HTTP calls where the debug output may pollute your result set. Jake Pilgrim ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273005 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: TC's and Privacy Policy
Here are some templates I have used in the past. Fill in the [blanks]. Web Site Terms and Conditions of Use 1. Terms By accessing this web site, you are agreeing to be bound by these web site Terms and Conditions of Use, all applicable laws and regulations, and agree that you are responsible for compliance with any applicable local laws. If you do not agree with any of these terms, you are prohibited from using or accessing this site. The materials contained in this web site are protected by applicable copyright and trade mark law. 2. Use License (a) Permission is granted to temporarily download one copy of the materials (information or software) on [Web Site Name]'s web site for personal, non-commercial transitory viewing only. This is the grant of a license, not a transfer of title, and under this license you may not: (i) modify or copy the materials; (ii) use the materials for any commercial purpose, or for any public display (commercial or non-commercial); (iii) attempt to decompile or reverse engineer any software contained on [Web Site Name]'s web site; (iv) remove any copyright or other proprietary notations from the materials; or (v) transfer the materials to another person or mirror the materials on any other server. (b) This license shall automatically terminate if you violate any of these restrictions and may be terminated by [Web Site Name] at any time. Upon terminating your viewing of these materials or upon the termination of this license, you must destroy any downloaded materials in your possession whether in electronic or printed format. 3. Disclaimer (a) The materials on [Web Site Name]'s web site are provided as is. [Web Site Name] makes no warranties, expressed or implied, and hereby disclaims and negates all other warranties, including without limitation, implied warranties or conditions of merchantability, fitness for a particular purpose, or non-infringement of intellectual property or other violation of rights. Further, [Web Site Name] does not warrant or make any representations concerning the accuracy, likely results, or reliability of the use of the materials on its Internet web site or otherwise relating to such materials or on any sites linked to this site. 4. Limitations In no event shall [Web Site Name] or its suppliers be liable for any damages (including, without limitation, damages for loss of data or profit, or due to business interruption,) arising out of the use or inability to use the materials on [Web Site Name]'s Internet site, even if [Web Site Name] or a [Web Site Name] authorized representative has been notified orally or in writing of the possibility of such damage. Because some jurisdictions do not allow limitations on implied warranties, or limitations of liability for consequential or incidental damages, these limitations may not apply to you. 5. Revisions and Errata The materials appearing on [Web Site Name]'s web site could include technical, typographical, or photographic errors. [Web Site Name] does not warrant that any of the materials on its web site are accurate, complete, or current. [Web Site Name] may make changes to the materials contained on its web site at any time without notice. [Web Site Name] does not, however, make any commitment to update the materials. 6. Links [Web Site Name] has not reviewed all of the sites linked to its Internet web site and is not responsible for the contents of any such linked site. The inclusion of any link does not imply endorsement by [Web Site Name] of the site. Use of any such linked web site is at the user's own risk. 7. Site Terms of Use Modifications [Web Site Name] may revise these terms of use for its web site at any time without notice. By using this web site you are agreeing to be bound by the then current version of these Terms and Conditions of Use. 8. Governing Law Any claim relating to [Web Site Name]'s web site shall be governed by the laws of the State of [State (ie. California)] without regard to its conflict of law provisions. General Terms and Conditions applicable to Use of a Web Site. - 2 - Privacy Policy Your privacy is very important to us. Accordingly, we have developed this Policy in order for you to understand how we collect, use, communicate and disclose and make use of personal information. The following outlines our privacy policy. * Before or at the time of collecting personal information, we will identify the purposes for which information is being collected. * We will collect and use of personal information solely with the objective of fulfilling those purposes specified by us and for other compatible purposes, unless we obtain the consent of the individual concerned or as required by law. * We will only retain personal information as long as necessary for the fulfillment of those purposes. * We will collect personal information by lawful and fair means and, where appropriate, with the knowledge or consent of the
RE: TC's and Privacy Policy
Thanks Ben, I'm looking around now to see if I can find anything, buy like yourself I wasn't sure of the legal implications of taking someone else's without permission, but I'll continue hunting around, I find it hard to believe anyone really bothers to read write their own :-D Thanks, Rob -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 19 March 2007 15:43 To: CF-Talk Subject: RE: TC's and Privacy Policy If you can't find anything, you might want to just find one you like on another site and swap out the names ;) I have no idea of the legal ramifications of this... Does the copy right cover the copy right itself??? ... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 11:39 AM To: CF-Talk Subject: TC's and Privacy Policy Hello Guys, I'm looking for a pretty standard 'terms and conditions' I can sit on my site, after googling around a little it seems that most firms want you to cough up money for a copy. Does anyone have a fairly generic terms and conditions as well as a privacy policy they wouldn't mind sharing? Thanks, Rob ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273007 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: _Debugging?
Doesn't this still require debug to be on at the server level and behind the scenes means every request is still getting it, which can add overhead. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, 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: Jake Pilgrim To: CF-Talk Sent: Mon Mar 19 15:41:43 2007 Subject: Re: _Debugging? To add a little overkill to this thread, I like to do something similar to the following (please note this code is very trimmed down): --- in application.cfc: cffunction name=onRequestEnd cfparam name=URL.debug default=false / cfsetting showdebugoutput=#URL.debug# / /cffunction Then you can show debug output whenever you want by specifying http://myURL.com?debug=true -- this is especially helpful when using AJAX or other HTTP calls where the debug output may pollute your result set. Jake Pilgrim ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfc and wsdl
Note: You don't need to # the arguments.input. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, 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: Chad Gray To: CF-Talk Sent: Mon Mar 19 14:07:24 2007 Subject: cfc and wsdl Hello, I am playing with cfcs and what I am reading so far I should be able to hit the cfc with ?wsdl on the end and get WSDL. Here is my test cfc right out of the help files: cfcomponent cffunction name = echoString returnType = string output = no access = remote cfargument name = input type = string cfreturn #arguments.input# /cffunction /cfcomponent I get the following: AXIS error Sorry, something seems to have gone wrong... here are the details: Fault - Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273009 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: downloading large files via cfhttp
You could use cfx-http5 for this (http://www.cftagstore.com/tags/cfxhttp5.cfm). Options are: 1. The tag will not buffer file in memory. 2. You can do this asynchronously (not in CF thread), while executing another code on the same (or different) page. 3. You can check the status of the process in real time and to cancel it, if needed. 4. You can launch the job in a parallel separate (non-CF) thread, but result will be unknown until the file appears (or not). ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Eclipse FTP Issues
Hello Guys, I've got beef with my eclipse FTP this afternoon, the one that comes bundled with Aptana. Basically as I'm running reactor it creates a set of data objects, such as DAO, Gateway, TO and so forth on the server, which I now need to amend and add in a couple of new functions, so I right click my folder in eclipse, and chose 'download'. It then connects, scans for the file, I see it tick by the ones I want, but then it DOESNT download them, just says '0 files downloaded'. Any ideas why this is? Thanks, Rob ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273011 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: _Debugging?
Yes, it still requires debugging to be turned on at the server level but that shouldn't be a concern here. On your development server, enable debugging; on your production server, disable debugging. This code isn't going to add or subtract any overhead in either scenario. Jake Pilgrim Doesn't this still require debug to be on at the server level and behind the scenes means every request is still getting it, which can add overhead. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, 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: Jake Pilgrim To: CF-Talk Sent: Mon Mar 19 15:41:43 2007 Subject: Re: _Debugging? To add a little overkill to this thread, I like to do something similar to the following (please note this code is very trimmed down): --- in application.cfc: cffunction name=onRequestEnd cfparam name=URL.debug default=false / cfsetting showdebugoutput=#URL.debug# / /cffunction Then you can show debug output whenever you want by specifying http://myURL.com?debug=true -- this is especially helpful when using AJAX or other HTTP calls where the debug output may pollute your result set. Jake Pilgrim ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273012 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
@@identity
For years I've been using SELECT @@IDENTITY AS ID in my code to get the record ID for a newly inserted record. And now I'm wondering... would this, or something similar, work inside an insert statement? I'm working on some insert code right now and one of the fields is a notes field that I'm storing some HTML, including (possibly) a path to an image that would be based on the record ID, ie; /path/to/###/record/image.jpg I know it's a bit redundant, and that I could make an image field in the table and automate the appearance of the image through code, but I was wondering if there was anything in the SQL insert statement that would be aware of the impending unique ID that I could use. Mik Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273013 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: @@identity
Not that I know of, unless you use an external identity table for your identities, as some folks like to do. Of course, you could do the insert leaving the path blank, and then immediately do an update using the newly created id. By the way, @@identity is not safe, you should use scope_identity() instead. In some cases, @@identity will return the wrong identity value. On 3/19/07, Mik Muller [EMAIL PROTECTED] wrote: For years I've been using SELECT @@IDENTITY AS ID in my code to get the record ID for a newly inserted record. And now I'm wondering... would this, or something similar, work inside an insert statement? I'm working on some insert code right now and one of the fields is a notes field that I'm storing some HTML, including (possibly) a path to an image that would be based on the record ID, ie; /path/to/###/record/image.jpg I know it's a bit redundant, and that I could make an image field in the table and automate the appearance of the image through code, but I was wondering if there was anything in the SQL insert statement that would be aware of the impending unique ID that I could use. Mik Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273014 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: @@identity
Mik Muller wrote: For years I've been using SELECT @@IDENTITY AS ID in my code to get the record ID for a newly inserted record. And now I'm wondering... would this, or something similar, work inside an insert statement? I'm working on some insert code right now and one of the fields is a notes field that I'm storing some HTML, including (possibly) a path to an image that would be based on the record ID, ie; /path/to/###/record/image.jpg I know it's a bit redundant, and that I could make an image field in the table and automate the appearance of the image through code, but I was wondering if there was anything in the SQL insert statement that would be aware of the impending unique ID that I could use. Mik This may not be the most efficient way, but you could use a stored procedure to add the record without the notes field, grab the ID of the newly created record, then update it with the appropriate info for the notes field. Incidentally, you should look at using scope_identity() instead of @@identity. @@identity does not always return the ID of the record you just added, particularly if there is a trigger on that table. It could return the ID of a record that was added by the trigger instead of your actual insert statement. In most cases you would not need to worry about that, but at some point you or somebody else may add a trigger to that table for whatever reason and you will be getting the incorrect ID returned to you. I just stick with scope_identity() from the beginning and never have to worry about it. Steve --- --- ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273015 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: @@identity
You can reference it in your inserts by adding a select. There may be a better way, and this may not be kosher but it works insert into yada() values blah; select thisId = @@identity ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273016 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: @@identity
By the way, @@identity is not safe, you should use scope_identity() instead. In some cases, @@identity will return the wrong identity value. Jacob, When would this happen? I use it in the very next statement, like the very next line. How would I use scope_identity()... same way? Just replace one term for the other? Mik Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273017 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: @@identity
Ok, I found this: http://www.sqlteam.com/item.asp?ItemID=319 I've been using code that originally ran on Access. Looks like it's time to do some searching and replacing. Thanks all, Mik Incidentally, you should look at using scope_identity() instead of @@identity. @@identity does not always return the ID of the record you just added, particularly if there is a trigger on that table. It could return the ID of a record that was added by the trigger instead of your actual insert statement. In most cases you would not need to worry about that, but at some point you or somebody else may add a trigger to that table for whatever reason and you will be getting the incorrect ID returned to you. I just stick with scope_identity() from the beginning and never have to worry about it. Steve --- Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: @@identity
This happens if there is a trigger associated with the table. For example, if you do an insert on TableA, and there is an insert trigger that inserts a record on TableB, @@IDENTITY will give you the identity value from TableB, not TableA. And yes, you use scope_identity() the same way as @@identity. On 3/19/07, Mik Muller [EMAIL PROTECTED] wrote: By the way, @@identity is not safe, you should use scope_identity() instead. In some cases, @@identity will return the wrong identity value. Jacob, When would this happen? I use it in the very next statement, like the very next line. How would I use scope_identity()... same way? Just replace one term for the other? Mik Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273019 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Slightly OT @@identity
Just wanted to share something that I just worked out how to do properly (not everyone is a SQL guru by birth) How often do you need to check if a record exists, and if not insert it? This is so cool (but I might just be easily amused) cfquery name=addToWatchList datasource=myDSN declare @userID int SET @userID = cfqueryparam cfsqltype=cf_sql_numeric value=#arguments.userID# declare @itemnumber int SET @itemnumber = cfqueryparam cfsqltype=cf_sql_numeric value=#arguments.itemnum# if (SELECT Count(*) FROM Watchlist WHERE User_ID = @userID AND itemnumber = @itemnumber) = 1 Begin SELECT 'Record already exists' as Results End else Begin INSERT INTO Watchlist (user_id, itemnumber) VALUES (@userID, @itemnumber) SELECT 'Record Added' as Results End /cfquery And it will return 'Record Added', or 'Record already exists' 1 SQL statement from 2, I love it. Chris ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273020 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: @@identity
Well, you should be using scope_identity for one, not @@identity. Will your insert alway be a single row insert? I am sure you will no doubt have to update the record after insert, though you may be able to do it in one go... I will have to investigate. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, 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: Mik Muller To: CF-Talk Sent: Mon Mar 19 18:08:48 2007 Subject: @@identity For years I've been using SELECT @@IDENTITY AS ID in my code to get the record ID for a newly inserted record. And now I'm wondering... would this, or something similar, work inside an insert statement? I'm working on some insert code right now and one of the fields is a notes field that I'm storing some HTML, including (possibly) a path to an image that would be based on the record ID, ie; /path/to/###/record/image.jpg I know it's a bit redundant, and that I could make an image field in the table and automate the appearance of the image through code, but I was wondering if there was anything in the SQL insert statement that would be aware of the impending unique ID that I could use. Mik Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273021 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: @@identity
A notes field? In SQL Server? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, 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: Mik Muller To: CF-Talk Sent: Mon Mar 19 18:08:48 2007 Subject: @@identity For years I've been using SELECT @@IDENTITY AS ID in my code to get the record ID for a newly inserted record. And now I'm wondering... would this, or something similar, work inside an insert statement? I'm working on some insert code right now and one of the fields is a notes field that I'm storing some HTML, including (possibly) a path to an image that would be based on the record ID, ie; /path/to/###/record/image.jpg I know it's a bit redundant, and that I could make an image field in the table and automate the appearance of the image through code, but I was wondering if there was anything in the SQL insert statement that would be aware of the impending unique ID that I could use. Mik Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273022 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: @@identity
Well, not a notes field, per se. VarChar(4000) Can't stop thinking in Access terms sometimes, though it's been years... MM At 02:51 PM 3/19/2007, you wrote: A notes field? In SQL Server? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, 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: Mik Muller To: CF-Talk Sent: Mon Mar 19 18:08:48 2007 Subject: @@identity For years I've been using SELECT @@IDENTITY AS ID in my code to get the record ID for a newly inserted record. And now I'm wondering... would this, or something similar, work inside an insert statement? I'm working on some insert code right now and one of the fields is a notes field that I'm storing some HTML, including (possibly) a path to an image that would be based on the record ID, ie; /path/to/###/record/image.jpg I know it's a bit redundant, and that I could make an image field in the table and automate the appearance of the image through code, but I was wondering if there was anything in the SQL insert statement that would be aware of the impending unique ID that I could use. Mik Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
including functions
Is there a good way to create component libraries? I'm finding that I'm creating components with *lots* of functions in them. I'd like to be able to create one file per function and include them when the component is instantiated. The cfimport is nice, but it's designed for 'custom tags', not functions. And, using cfinclude doesn't provide proper scope access to local (var) variables. Any thoughts? This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: including functions
I'd like to be able to create one file per function and include them when the component is instantiated. You could use the extends property of the CFC or you could modify the base CFC, but those may not be what you are looking for. For a more mix-and-match approach, I think you may want to look into the mixins concept. Hal Helms has been speaking on this considerably recently. 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. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: including functions
Why not put them into a CFC? Then you can instantiate the whole mess? -Original Message- From: Leitch, Oblio [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 2:31 PM To: CF-Talk Subject: including functions Is there a good way to create component libraries? I'm finding that I'm creating components with *lots* of functions in them. I'd like to be able to create one file per function and include them when the component is instantiated. The cfimport is nice, but it's designed for 'custom tags', not functions. And, using cfinclude doesn't provide proper scope access to local (var) variables. Any thoughts? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: including functions
Because I'm trying to avoid the whole mess that comes of having too many functions in one file. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 3:36 PM To: CF-Talk Subject: RE: including functions Why not put them into a CFC? Then you can instantiate the whole mess? This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: including functions
Oblio, Using CFInclude should actually provie proper THIS / VARIABLES scope to which ever CFC does the including. THIS and VARIABLES binding is done at run time and will actually be accurate if two CFC SHARE the same function pointer. Do you actually get an error from using CFInclude or were just assuming this would not work (or am I just not understanding what you meant)? .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Leitch, Oblio [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 3:31 PM To: CF-Talk Subject: including functions Is there a good way to create component libraries? I'm finding that I'm creating components with *lots* of functions in them. I'd like to be able to create one file per function and include them when the component is instantiated. The cfimport is nice, but it's designed for 'custom tags', not functions. And, using cfinclude doesn't provide proper scope access to local (var) variables. Any thoughts? This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273028 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: including functions
-Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] You could use the extends property of the CFC or you could modify the base CFC, but those may not be what you are looking for. Nope. I think I'd end up with a serial chain of CFCs, rather than a library of functions. For a more mix-and-match approach, I think you may want to look into the mixins concept. Hal Helms has been speaking on this considerably recently. I've seen his baseComponent.cfc, but he's never written any real how-to with it. This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Eliminating .cfm extensions in SES
I am on a quest to figure out a more seamless approach to Search Engine Safe (SES) URL's with ColdFusion. Several solutions I have seen achieve SES using a URL like http://www.myweb.com/targetpage.cfm/variable1/parameter1 What I want to achieve is the same result, but without having to give away that the page I am calling is CF by avoiding the telltale .cfm in the above example. So, it would be http://www.myweb.com/targetpage/variable1/parameter1 wherein targetpage is really a .cfm file. Is there any way to achieve this? Thx! ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: including functions
Well, I guess, specifically, this is what I've got: in Application.cfc, I'm defining a new function reSubstring(); in there, I'm cfincluding a chunk that does the actual processing. When I try to run it, it fails to execute (without throwing an error). -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 3:41 PM To: CF-Talk Subject: RE: including functions Oblio, Using CFInclude should actually provie proper THIS / VARIABLES scope to which ever CFC does the including. THIS and VARIABLES binding is done at run time and will actually be accurate if two CFC SHARE the same function pointer. Do you actually get an error from using CFInclude or were just assuming this would not work (or am I just not understanding what you meant)? This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273031 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Eliminating .cfm extensions in SES
Yes, you would need to use url rewriting, either through apache with mod_rewrite, one of the third party plugins for IIS, or a custom 404 handler for cf. Russ -Original Message- From: james carberry [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 4:00 PM To: CF-Talk Subject: Eliminating .cfm extensions in SES I am on a quest to figure out a more seamless approach to Search Engine Safe (SES) URL's with ColdFusion. Several solutions I have seen achieve SES using a URL like http://www.myweb.com/targetpage.cfm/variable1/parameter1 What I want to achieve is the same result, but without having to give away that the page I am calling is CF by avoiding the telltale .cfm in the above example. So, it would be http://www.myweb.com/targetpage/variable1/parameter1 wherein targetpage is really a .cfm file. Is there any way to achieve this? Thx! ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273032 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eliminating .cfm extensions in SES
You bet, use a real URL rewriting solution from your web server, instead of using a CF-based solution with CGI.PATH_INFO. mod_rewrite is the 800 LBS gorilla in the arena, and if you're not running Apache HTTPD, there are similar tools available for other web servers. Just keep in mind that SES urls are of benefit because you have meaningful information in the URL, not because the ? and are missing. If you're just chopping those out, it's not going to make a difference. You need to create keyword-rich URLs. For example 'domain.com/product.cfm?id=342' and 'domain.com/product/id/342' are going to be identical in performance with search engines. `domain.com/product/342` will perform similarly poorly. On the other hand, 'domain.com/product/MyNeatRemoteControlCar/342' will perform much better because of the keywords. 'domain.com/MyNeatRemoteControlCar` will perform best of all. Standard caveats about contrived examples apply, but you get the idea. cheers, barneyb On 3/19/07, james carberry [EMAIL PROTECTED] wrote: I am on a quest to figure out a more seamless approach to Search Engine Safe (SES) URL's with ColdFusion. Several solutions I have seen achieve SES using a URL like http://www.myweb.com/targetpage.cfm/variable1/parameter1 What I want to achieve is the same result, but without having to give away that the page I am calling is CF by avoiding the telltale .cfm in the above example. So, it would be http://www.myweb.com/targetpage/variable1/parameter1 wherein targetpage is really a .cfm file. Is there any way to achieve this? Thx! -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273033 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eliminating .cfm extensions in SES
Yes, you would need to use url rewriting, either through apache with mod_rewrite, one of the third party plugins for IIS, or a custom 404 handler for cf. Russ Can you recommend any of these 3rd Party IIS plug ins? Thanks! -j ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273034 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion Resellers - Dedicated hosting
I am looking for a place to host my sites. I have about 10 or so sites that need to be placed in a reliable managed hosting environment. I have maintained a couple of dedicated servers over the years and frankly I am just sick of fending off hackers, fixing things when they break, and server maintenance in general. I need all the usual stuff like the ability for clients to manage their own email accounts, control over DNS, someone to answer the phone when I need support and for it to be reasonably priced enough to make it profitable for offer hosting in the $25-40/month range. I would like to have Plesk or preferably H-Sphere for the Control Panel. Any suggestions? Thanx in advance Jerry Guido Programmer MGT of America, Inc. [EMAIL PROTECTED] The information contained in this electronic communication is intended only for the use of the addressee, and may be a confidential communication. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273035 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cflog questions
All, I have recently added some cflog tags to an application, using these parameters: text=some text and numbers file=myLog application=yes My problem is that it is not only logging to the specified file, but also to the standard out log (coldfusion-out.log) and I'm afraid that is why that log file is ballooning in size. Can I specify that my specific logging should only go into myLog file instead of into both log files? Seems redundant otherwise. Also, since coldfusion-out.log is getting so large, how come this log isn't truncating? It is pretty unwieldy at this point (290+MB) and growing. Thanks in advance for your help, Caroline Wise ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273036 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ColdFusion Resellers - Dedicated hosting
I'm using Gearhost. They allow multiple sites under one account (8 at the level I have). They have a pretty decent control panel and they offer CFM,ASP,PHP as well as SQL Server and MySQL. -Original Message- From: Jerry Guido [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 3:39 PM To: CF-Talk Subject: ColdFusion Resellers - Dedicated hosting I am looking for a place to host my sites. I have about 10 or so sites that need to be placed in a reliable managed hosting environment. I have maintained a couple of dedicated servers over the years and frankly I am just sick of fending off hackers, fixing things when they break, and server maintenance in general. I need all the usual stuff like the ability for clients to manage their own email accounts, control over DNS, someone to answer the phone when I need support and for it to be reasonably priced enough to make it profitable for offer hosting in the $25-40/month range. I would like to have Plesk or preferably H-Sphere for the Control Panel. Any suggestions? Thanx in advance Jerry Guido Programmer MGT of America, Inc. [EMAIL PROTECTED] The information contained in this electronic communication is intended only for the use of the addressee, and may be a confidential communication. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273037 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion Resellers - Dedicated hosting
Viux has good plans and uses Plesk. viux.com Mik At 04:38 PM 3/19/2007, you wrote: I am looking for a place to host my sites. I have about 10 or so sites that need to be placed in a reliable managed hosting environment. I have maintained a couple of dedicated servers over the years and frankly I am just sick of fending off hackers, fixing things when they break, and server maintenance in general. I need all the usual stuff like the ability for clients to manage their own email accounts, control over DNS, someone to answer the phone when I need support and for it to be reasonably priced enough to make it profitable for offer hosting in the $25-40/month range. I would like to have Plesk or preferably H-Sphere for the Control Panel. Any suggestions? Thanx in advance Jerry Guido Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273038 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: including functions
Can you show us the code for the function definition And then also the snippet that invokes the method. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Leitch, Oblio [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 4:14 PM To: CF-Talk Subject: RE: including functions Well, I guess, specifically, this is what I've got: in Application.cfc, I'm defining a new function reSubstring(); in there, I'm cfincluding a chunk that does the actual processing. When I try to run it, it fails to execute (without throwing an error). -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 3:41 PM To: CF-Talk Subject: RE: including functions Oblio, Using CFInclude should actually provie proper THIS / VARIABLES scope to which ever CFC does the including. THIS and VARIABLES binding is done at run time and will actually be accurate if two CFC SHARE the same function pointer. Do you actually get an error from using CFInclude or were just assuming this would not work (or am I just not understanding what you meant)? This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion Resellers - Dedicated hosting
I've got Crystal Tech. Multiple domains under one account, I only pay $16.95 a month, and that's for their mid range service which is very nice indeed. Their customer support has been very responsive often taking care of my needs same day when they say it may take 24 hours. I switched to them from Viux. Chris Mik Muller wrote: Viux has good plans and uses Plesk. viux.com Mik At 04:38 PM 3/19/2007, you wrote: I am looking for a place to host my sites. I have about 10 or so sites that need to be placed in a reliable managed hosting environment. I have maintained a couple of dedicated servers over the years and frankly I am just sick of fending off hackers, fixing things when they break, and server maintenance in general. I need all the usual stuff like the ability for clients to manage their own email accounts, control over DNS, someone to answer the phone when I need support and for it to be reasonably priced enough to make it profitable for offer hosting in the $25-40/month range. I would like to have Plesk or preferably H-Sphere for the Control Panel. Any suggestions? Thanx in advance Jerry Guido Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Eliminating .cfm extensions in SES
On 3/19/07, james carberry [EMAIL PROTECTED] wrote: What I want to achieve is the same result, but without having to give away that the page I am calling is CF by avoiding the telltale .cfm in the above example. So, it would be http://www.myweb.com/targetpage/variable1/parameter1 wherein targetpage is really a .cfm file. Just out of curiousity, *WHY* do you want to do that? Do you think it will improve search engine rankings (it won't) or do you just not want anyone to know you're running coldfusion (anyone who really wants to know can probably find out) Rick -- CFMBB - Coldfusion Message Boards, Version 1.21 Now Available! http://www.cfmbb.org ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Eliminating .cfm extensions in SES
http://cheeso.members.winisp.net/IIRF.aspx -Original Message- From: james carberry [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 2:10 PM To: CF-Talk Subject: Re: Eliminating .cfm extensions in SES Yes, you would need to use url rewriting, either through apache with mod_rewrite, one of the third party plugins for IIS, or a custom 404 handler for cf. Russ Can you recommend any of these 3rd Party IIS plug ins? Thanks! -j ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273042 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
upgrade java in CF
Hi, All: Does anyone know if it is ok to upgrade the current Java version(1.4.2_09) to the newest java 1.5.0_06? My network security guys found a vulnerability on my CF server and would like to upgrade to 1.5.0_06. Does anyone know the upgrade will affect anything? Nathan Chen ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273043 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cflogin issue with cf7
When using the cflogin tag on MX 7 we have to use the following code, otherwise, we throw a String index out of range: -1 error. Anyone have any insight on this ? The error does not appear if we disable netegrity siteminder rules, which basically say prompt on any folder you hit. cfparam name=SESSION.CFAUTHORIZATION default= cfcookie name=CFAUTHORIZATION_#APPLICATION.applicationname# value=#SESSION.CFAUTHORIZATION# Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: upgrade java in CF
Yes, ColdFusion MX is not supported on Java 1.5 Mark On 3/20/07, Nathan Chen [EMAIL PROTECTED] wrote: Hi, All: Does anyone know if it is ok to upgrade the current Java version(1.4.2_09) to the newest java 1.5.0_06? My network security guys found a vulnerability on my CF server and would like to upgrade to 1.5.0_06. Does anyone know the upgrade will affect anything? Nathan Chen ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: upgrade java in CF
Nathan, ColdFusion is not supported on 1.5. I believe the highest you can go to is 1.4.2_11. HTH, Phil -Original Message- From: Nathan Chen [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 5:59 PM To: CF-Talk Subject: upgrade java in CF Hi, All: Does anyone know if it is ok to upgrade the current Java version(1.4.2_09) to the newest java 1.5.0_06? My network security guys found a vulnerability on my CF server and would like to upgrade to 1.5.0_06. Does anyone know the upgrade will affect anything? Nathan Chen ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273046 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: upgrade java in CF
I've successfully tested to 1.4.2_12, and it seems to fix some memory issues on some sites I was dealing with. It is not Adobe certified though. Phillip Duba wrote: Nathan, ColdFusion is not supported on 1.5. I believe the highest you can go to is 1.4.2_11. HTH, Phil -Original Message- From: Nathan Chen [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 5:59 PM To: CF-Talk Subject: upgrade java in CF Hi, All: Does anyone know if it is ok to upgrade the current Java version(1.4.2_09) to the newest java 1.5.0_06? My network security guys found a vulnerability on my CF server and would like to upgrade to 1.5.0_06. Does anyone know the upgrade will affect anything? Nathan Chen ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help Desk / Trouble Ticket recommendation?
Rob, Looks like something hit our server Saturday or so, and caused it to become very slow. Anyway, we are working on it and hopefully it'll be back up later today or tomorrow. You can email me off-list if you want another link to the demo which you can try. Cedric The www.cornfeed.com seems to have been down for the past 3 or 4 days. I'm also in the market for a ticket system and would be keen to take a look around this, I did look into building a custom system a while back but it's quite a hefty project for what will essentially be a low traffic section of my application. Rob -Original Message- From: Doug Bezona [mailto:[EMAIL PROTECTED] Sent: 19 March 2007 12:32 To: CF-Talk Subject: Re: Help Desk / Trouble Ticket recommendation? I'll second this as one worth looking at. I used CFTicket in a previous job, and liked it a great deal. I had to do some fairly extensive modifications (primarily adding Oracle support, and also some other business-specific features). I found the code to be well organized and easy to work with, which is rather important if you actually intend to make modifications. Also Andrew, I think that CFTicket would work well for you based on your privacy requirements. At it's core it's e-mail driven - each queue in the system has a corresponding POP mail box. All e-mail correspondence is between the requester and the system, and you can set fairly granular permissions for each queue, so if it's a sensitive issue, you could put the ticket into a restricted queue to limit who can see the requesters personal info, and none of the people managing tickets ever has to have their personal info involved (since the messages come from the queue address, not an employee address). On 3/17/07, Cedric Villat [EMAIL PROTECTED] wrote: ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Need some SQL help!
MySQL 5. I'm building a dynamic question survey form. Here's my db schema: http://wtomlinson.com/evalDBSchema.jpg I need to pull data for a specific instructor. How do I get a count for each answer? I need to display each question like this: http://wtomlinson.com/evaldisplay.jpg I'm workin on the query and having a hard time figuring out howta write it. This returns 3 records. I filled out a 3 question survey to get that. Now, I need to total up answers. Here's what I've got so far. Could someone point me in the right direction? SELECT tblevaluations.EvalID, tblevaluations.Course, tblevaluations.GtccDeptID, tblevaluations.InstructorID, tblevaluations.Program, tblevaluations.Section, tblevaluations.SectionID, tblevaluations.DivCode, tblevalanswerresults.evalID, tblevaluations.DeptPrograms, tblevalanswerresults.answerID, tblevalanswerresults.evalanswerID, tblevalanswerresults.questionID, tblevalanswerresults.questionsetID, tblquestions.answersetID, tblquestions.question, tblquestions.questionID, tblquestions.questionsetID, tblquestions.questionsortnum, tblanswersets.answersetid, tblanswersets.answersetname, SUM(tblanswers.answerID) AS numAnswers, tblanswers.answersetID, tblanswers.answername, tblanswers.answersortnum, tblanswers.answervalue, tblquestionsets.questionsetID, tblInstructor.instructorLastName, tblInstructor.instructorFirstName, tblInstructor.InstructorID FROM tblEvaluations, tblevalanswerresults, tblquestions, tblanswersets, tblInstructor, tblanswers , tblquestionsets WHERE tblevaluations.EvalID = tblevalanswerresults.evalID AND tblevalanswerresults.answerID = tblanswers.answerID AND tblevalanswerresults.questionID = tblquestions.questionID AND tblevalanswerresults.questionsetID = tblquestionsets.questionsetID AND tblanswers.answersetID = tblanswersets.answersetid AND tblquestions.questionID = tblevalanswerresults.questionID AND tblevaluations.InstructorID = '0103419' GROUP BY tblquestionsets.questionsetID, tblquestions.questionID, tblanswersets.answersetid, tblanswers.answerID Thanks, Will ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need some SQL help!
Ok, I wrote down in plain english what I need. Show me a list of questions, all possible evaluation answers for each question, and a total of each answer chosen. Does this make sense? Thanks, Will ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Lyris ListManager- CF wrapper to SOAP API?
Has anyone created a CF wrapper on the Lyris List Manager SOAP API? http://www.lyris.com/help/lm_api/9.1/ Aside from that, I'm looking to use their API, but I am having some difficulty getting the SelectMembers method to work: http://www.lyris.com/help/lm_api/9.1/selectmembers.html CFOBJECT name=NetAtlantic webservice=http://pr3.netatlantic.com:82/?wsdl; Cfset FilterCriteriaArray = ArrayNew(1) Cfset FilterCriteriaArray[1]=( EmailAddress = ) Cfinvoke method=SelectMembers webservice=#NetAtlantic# username= password= returnVariable =cont cfinvokeargument name=FilterCriteriaArray value=#FilterCriteriaArray# /cfinvoke Cfdump var=#Cont# The error I get is: Could not perform web service invocation SelectMembers. Here is the fault returned when invoking the web service operation: AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: java.lang.ClassCastException: org.apache.axis.message.Text faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace:java.lang.ClassCastException: org.apache.axis.message.Text at org.apache.axis.message.SOAPFaultBuilder.onEndChild(SOAPFaultBuilder.java:299) at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1090) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfc and wsdl
Note: The mapping is a default setting by CF when installing. Also you are not telling us how you're trying to connect to the webservice either, or connecting to the function via a URL. There is a difference. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: upgrade java in CF
With all this talk about upgrading the java runtime, what is the process in doing so. Is it just a simple matter of backing up the lib directory and dropping the new libs in there? Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: upgrade java in CF
For multi server instance, you simply install the new JRE to a directory in the filesystem. Then, open jvm.config in your bin directory and point the java.home variable to the new path. Then, restart your cf server. MAKE SURE TO BACK UP JVM.CONFIG BEFORE MAKING THIS CHANGE just in case something goes wrong. Andrew Scott wrote: With all this talk about upgrading the java runtime, what is the process in doing so. Is it just a simple matter of backing up the lib directory and dropping the new libs in there? Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Calling a function based on variable name
Hello, Here is what I am trying to accomplish. I cannot seem to remember or find a way to do this: cfset myfunction=AddMe cfset AddMe() Thanks! Randy ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Update cart items without reloading--AJAX?
Hi forum-- My client has a pretty complicated product listing and I would like to set their cart up so that the customer can click on a button and visually add an item to a list displayed on the same page, without reloading the page. These items will be put into a database, as well. It's really crucial that the customer can see his shopping cart and the list of items for sale on the same screen. This is a site that customers have to log in to use, so I have some leeway technology-wise--in other words, we don't have to support Netscape 4.5--but I'm basically looking for the simplest implementation for the lowest common denominator (within reason). I was thinking of dabbling in AJAX (which I know next to nothing about)? Or is there a simpler way (aside from using frames, which I refuse to do...). muchas gracias, Megan Cytron Alpha 60 Design Shop Madrid, Spain ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Weird Trouble with CF + MySQL.
Problem solved. The trouble was that mysql 4 don't suport subselects. Using mysql 5 now and everything works fine. Nothing wrong with CF. ;) Doug Brown wrote: Would this line be your culprit? Maybe it has gotten combined due to the paste operation, but shouldn't it be (e.tag order by e.tag separator ', ') ( e.tagorder by e.tag separator ', ') -Original Message- From: Adrien Akkhazza R. Cardoso [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 4:07 AM To: CF-Talk Subject: Weird Trouble with CF + MySQL. I'm having this problem. The query works fine directly on the database, but when used on coldfusion it gives this error. If I copy the string from the sql field here, and executes on mysql , it works fine again. Don't get what can be wrong. Maybe CF is doing something stupid when talking to the datasource? Error Executing Database Query. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select b.id_article, group_concat( c.name order by c.use The error occurred in D:\Hosting\myCFC\article2.cfc: line 5 Called from D:\Hosting\article\article2.cfm: line 5 Called from D:\Hosting\myCFC\article2.cfc: line 5 Called from D:\Hosting\article\article2.cfm: line 5 3 : cffunction name=ListArticles access=remote returntype=query 4 : cfargument name=dsn type=string required=yes 5 : cfquery name=qListArticles datasource=#dsn# 6 : select a.id_article, a.title, u.users, t.tags 7 : from articles as a SQLselect a.id_article, a.title, u.users, t.tags from articles as a left outer join ( select b.id_article, group_concat( c.name order by c.userseparator ', ') as users from articlexuser as b inner join users as c on c.id_user = b.id_user group by b.id_article ) as u on u.id_article = a.id_article left outer join ( select d.id_article, group_concat( e.tagorder by e.tag separator ', ') as tags from articlextags as d inner join tags as e on e.id_tag = d.id_tag group by d.id_article ) as t on t.id_article = a.id_article ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update cart items without reloading--AJAX?
Megan, If you want the page to be refreshed without a reload, then the easiest way is to use some form of Ajax call. With that said, I would recommend looking into any of the number of top-notch libraries out their that will make this task easier. These include: jQuery - my personal choice (http://jQuery.com) Prototype (http://prototypejs.org) Spry (http://labs.adobe.com/technologies/spry/) Yahoo User Interface Library (http://developer.yahoo.com/yui/) There are other choices out there but these, IMO, offer the best selection of functionality, documentation, and user support. ColdFusion-specific choices include: AjaxCFC (http://www.robgonda.com/blog/projects/ajaxcfc/) MXAjax (http://www.indiankey.com/mxajax/) JSMX (http://www.lalabird.com/) My personal favorite of the 3 is AjaxCFC. Its extremely easy to implement and now uses jQuery under the hood. That in itself adds a ton of functionality to AjaxCFC. Both MXAjax JSMX, though, are very good libraries. If you want to learn more about Ajax without the use of a library, then checkout the tutorials here: http://www.maxkiesler.com/index.php/weblog/comments/42_recent_ajax_tutorials/ I'm part of the jQuery team and a big advocate for CF users in that project so I hope to see you on the mailing list. Rey... megan cytron wrote: Hi forum-- My client has a pretty complicated product listing and I would like to set their cart up so that the customer can click on a button and visually add an item to a list displayed on the same page, without reloading the page. These items will be put into a database, as well. It's really crucial that the customer can see his shopping cart and the list of items for sale on the same screen. This is a site that customers have to log in to use, so I have some leeway technology-wise--in other words, we don't have to support Netscape 4.5--but I'm basically looking for the simplest implementation for the lowest common denominator (within reason). I was thinking of dabbling in AJAX (which I know next to nothing about)? Or is there a simpler way (aside from using frames, which I refuse to do...). muchas gracias, Megan Cytron Alpha 60 Design Shop Madrid, Spain ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfc and wsdl
Check if it's being used by anyone else before removing it. If you can't remove it, you can create a mapping for your webservice so that the mapping path matches the request path. e.g. if I want somesite.com/somefolder/myWS.cfc?wsdl I'd map the physical folder to /somefolder/. Getting rid of the root mapping is easier. On 3/19/07, Chad Gray [EMAIL PROTECTED] wrote: Oh... yes the development server has this mapping: / C:\CFusionMX7\wwwroot The production server does not have this mapping. Should I remove this mapping? One of the other developers must have made it and I will need to find out why. -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 10:36 AM To: CF-Talk Subject: Re: cfc and wsdl Check to see if either server has a root mapping (i.e. / is mapped to something) and if there are any other differences between the mappings on the boxes. On 3/19/07, Chad Gray [EMAIL PROTECTED] wrote: It is set to remote. I just copied the cfc to our production server and it works fine. I get good WSDL. It has something to do with out development server. They are the same server versions. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 10:13 AM To: CF-Talk Subject: RE: cfc and wsdl Your CFC has to be set to remote. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 9:07 AM To: CF-Talk Subject: cfc and wsdl Hello, I am playing with cfcs and what I am reading so far I should be able to hit the cfc with ?wsdl on the end and get WSDL. Here is my test cfc right out of the help files: cfcomponent cffunction name = echoString returnType = string output = no access = remote cfargument name = input type = string cfreturn #arguments.input# /cffunction /cfcomponent I get the following: AXIS error Sorry, something seems to have gone wrong... here are the details: Fault - Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could not resolve CFC datatype: /lib/cfc/utils.cfc] ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273059 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ColdFusion Resellers - Dedicated hosting
Check out sunshinetechsolutions.com...tell him Eric sent you...I have benn hosting with them since November and have almost 100% uptime Eric -Original Message- From: Jerry Guido [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 2:39 PM To: CF-Talk Subject: ColdFusion Resellers - Dedicated hosting I am looking for a place to host my sites. I have about 10 or so sites that need to be placed in a reliable managed hosting environment. I have maintained a couple of dedicated servers over the years and frankly I am just sick of fending off hackers, fixing things when they break, and server maintenance in general. I need all the usual stuff like the ability for clients to manage their own email accounts, control over DNS, someone to answer the phone when I need support and for it to be reasonably priced enough to make it profitable for offer hosting in the $25-40/month range. I would like to have Plesk or preferably H-Sphere for the Control Panel. Any suggestions? Thanx in advance Jerry Guido Programmer MGT of America, Inc. [EMAIL PROTECTED] The information contained in this electronic communication is intended only for the use of the addressee, and may be a confidential communication. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IE6, SSL 3.0, form file fields problem continued...
On 3/16/07, Les M wrote: Russ wrote: Hmm... SSL 2 is supposed to be have problems with it, but wonder if you force SSL 2 for IE 6... Can maybe set up different subdomains like ssl2.mydomain.com and ssl3.mydomain.com and redirect the browser based on the browser version? Interesting idea. Hmmm I've tried the Microsoft fix on my processing page by calling a small gif file like https://www.mydomain.com/secureapp/small.gif - and that doesn't fix it, but, I'm wondering if the gif is getting loaded to quickly or something. Haven't had time to try it yet, but I'm thinking about trying to add a .5 second pause to the page before the cffile code block and see what that does. Weird, just darned weird... Seems to me the problem that Tech note is about, is more submitting from http to https, which, IIRC, you already had the whole page loading from https. Totally strange. Gotta love the THIS IS HOW YOU USE THIS PAGE type instructions on a page, neh? So pro. Yup, send 'em a bill, and if it works, I'll send 'em one for the webDAV tomfoolery I spent a few hours on. [-; ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need some SQL help!
On 3/19/07, Will T wrote: MySQL 5. I'm building a dynamic question survey form. Here's my db schema: Honestly, I would probably do it in CF with loops, vs. a nifty SQL query. Also, a cheap and easy solution, is to use a graphic query builder (like *shiver* MSAccess ;)... although, you should have one of those. Better than Access's even! Ah! I remember figuring out sums and stuff was as hard graphically... hrm... that sorta looks like generated stuff already eh. Maybe J has an idea, he's a SQL ninja. I'd start with a left join from the teacher table, and work my way out, since I want ALL instructors. Sorry no code 'zample )-; ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cflog questions
Not an answer, but the cflog4j(?) project on The List (Open Source CF) looks to offer quite a bit of control over log file stuff... http://code.google.com/p/cflog4j/ On 3/19/07, Caroline Wise wrote: All, I have recently added some cflog tags to an application, using these parameters: ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query that should run but won't (but does run)
Hey All, I have a query that no matter how I try and use a variable (in cfqueryparam or not), it returns no records UNTIL I hardcode the value of the variable!! I might add it runs just fine in TOAD. Things I've tried: -trimming it -val() (it's an integer) -int() -#myVar# -cfqueryparam value=#myVar# cfsqltype=cf_sql_numeric (also tried cf_sql_integer) -clearing the template cache -restarting CF services I'm at a total loss. I've seen some queries that won't run with CFQUERYPARAM in which case I removed it and just use the raw variable (#myVar#), but this time it just won't run unless I hardcode it!! Yes I have also checked the debugging output, and it shows the correct value being used for that param!!! There is some serious weirdness afoot and this is NOT the time for it :-( HELP!!! TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query that should run but won't (but does run)
On 3/19/07, Bryan Stevenson wrote: Hey All, I have a query that no matter how I try and use a variable (in cfqueryparam or not), it returns no records UNTIL I hardcode the value of the variable!! I might add it runs just fine in TOAD. Oi! Dang. Don't know what the deal is, but you could try maybe WHERE CAST(theField AS Int) = cfqueryparam value=#val(myVar)# cfsqltype=cf_sql_integer Or something similar... *shrug* Something is funky. I'm thinking datatype or some such, but I don't know. Force be with you, mate! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IE6, SSL 3.0, form file fields problem continued...
The technote is telling you to add the image to the page that contains the file upload control in the browser, not the subsqeuent action page that does the cffile action = upload. On 3/17/07, Les Mizzell [EMAIL PROTECTED] wrote: Russ wrote: Hmm... SSL 2 is supposed to be have problems with it, but wonder if you force SSL 2 for IE 6... Can maybe set up different subdomains like ssl2.mydomain.com and ssl3.mydomain.com and redirect the browser based on the browser version? Interesting idea. Hmmm I've tried the Microsoft fix on my processing page by calling a small gif file like https://www.mydomain.com/secureapp/small.gif - and that doesn't fix it, but, I'm wondering if the gif is getting loaded to quickly or something. Haven't had time to try it yet, but I'm thinking about trying to add a .5 second pause to the page before the cffile code block and see what that does. Weird, just darned weird... ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4