Re: HostMySite: Linux Builder + CF No Longer Offered
On Saturday 21 Jul 2007, [EMAIL PROTECTED] wrote: terms of support. I think this has a LOT to do with the fact that SeeFusion, the software we use to keep CF in control on shared servers, doesn't work in a Linux Environment. So you'll be offering the service based on CF8, that has this built in, instead then ? -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:284346 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Export to Quickbook/Ms Money
On Monday 23 Jul 2007, [EMAIL PROTECTED] wrote: Can anyone point me to resources that explain how to export a Recordset to a Quickbooks ? Similar to any bank website where you can download you transaction to your software. Does quickbooks take CSV files ? In which case, just construct the string and send it to the user. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:284347 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: This is a good one - another Regex question
Claude Schneegans wrote: IMO, the format you are trying to modify is by far more correct than the result you are trying to attempt. Agreed. And the question, although once posed, still beckons - Jide, why do you want to do this again?? What precisely are you gaining by moving the closing paragraph tag outside the UL? I'm not going to even presume I know the answer, although I have my suspicions! Mark ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284348 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: This is a good one - another Regex question
Jide Aliu wrote: Thanks for your reply Claude. I know that formatting wise it's madness to have p tags round ul tag, but the problem we are having is that we are suppplying xml data to a vendor for some reason their system won't accept ul listing without p tags round them. That is my dilema. I'll have a look at CF_Extract and see if it's any good to me. Duh, so much for sorting by thread. Scratch my last question sorry, as you answered it days ago. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284349 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Export to Quickbook/Ms Money
Google for OFX. There is an ofx.net web site with the xml syntax, but it appears to be down now. M!ke -Original Message- From: Yannick Morin [mailto:[EMAIL PROTECTED] Sent: Sunday, July 22, 2007 7:39 PM To: CF-Talk Subject: Export to Quickbook/Ms Money Can anyone point me to resources that explain how to export a Recordset to a Quickbooks ? Similar to any bank website where you can download you transaction to your software. I've look into CFDOCUMENT, CFCONTENT, CFREPORT without success Thanks for any help possible. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284350 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 with Query
If all your photos will have prices you won't need to left join you can just join on them. Joel Watson wrote: Joe, First of all I am not sure if you need LEFT JOIN for both comments and prices. My first example was based on the assumption that you could have photos without comments and you might want to display those as well. It will help if you can paste the entire query and your output code. Thanks Qasim Yes, not all of the photos will have comments, but all will have prices (and the same number of them...8) Here is what I have so far: cfquery name=rsPhotoInformation datasource=#application.dsn# SELECT * FROM photos LEFT OUTER JOIN prices ON photos.photoID = prices.photoID_fk LEFT OUTER JOIN comments ON photos.photoID = comments.photoID_fk WHERE categoryID_fk = cfqueryparam value=1 cfsqltype=cf_sql_integer /cfquery And again, here are abbreviated table structures: photos table photoID photoTitle comments table commentID commentText photoID_fk prices table priceID priceValue photoID_fk Thanks again! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284351 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
hooking up IMS Lite
Hi, We have a client that wants to use IMS lite to send out mass emails and IMS lite has already been 'put' on their server. They would like to get an estimate on how long it would take us to 'hook it up to cfmail'. Having no experience of IMS I thought I'd ask the question to someone who has! So, a.) Does that make sense? b.) How easy is IMS to integrate with cfmail? ;) Thanks in advance, Dominic ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284352 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 with Query
If all your photos will have prices you won't need to left join you can just join on them. Joel Watson wrote: That's true, but when I combine it with the LEFT OUTER JOIN on the comments, it screws up the comments. While it will return the prices information fine, it duplicates the comments values for the number of price fields there are. For example, each photo currently has 8 price values which are being returned. With the query and output that I currently have, the photos with comments have their comments values returned the number commens * 8. So if photo1 has 3 comments, it will return 24 values for the comments. I am pasting below the current query that I have, as well as my current output structure. Thanks for everyone's help so far---it's almost there! cfquery name=rsPhotoInformation datasource=#application.dsn# SELECT * FROM photos JOIN prices ON photos.photoID = prices.photoID_fk LEFT OUTER JOIN comments ON photos.photoID = comments.photoID_fk WHERE categoryID_fk = cfqueryparam value=1 cfsqltype=cf_sql_integer /cfquery cfoutput query=rsPhotoInformation group=photoID #photoTitle# br / cfoutput group=priceID #priceValue# br / /cfoutput cfoutput #commenter# /cfoutput br / br / /cfoutput ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284353 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CDDocument Image problem
I am trying to use CFDocument to make a PDF of a web page. I have an image that produces what kinds of looks like a missing image icon in the PDF. When I click on thing in Acrobat it says There was an error processing an annotation or link. There was a problem reading this document (14). http://chadgray.info/Untitled-1.jpg Now this code works fine on our development server. Only on the production server do I get the problem. My code to place the image is simple enough. The page and image are in the same folder. The PDF is saved into a sub-folder. td width=352 height=59 valign=top align=center img src=invoicelogoNEW.jpg border=0 /td My code to make the pdf and save it is: cfdocument format=pdf pagetype=letter name=invoice overwrite=yes cffile action=write file=#application.invoicePDFPath##fileName# output=#invoice# H now that I think more about this. The area that this code is running from does have NTFS permissions on it so users have to login to use the web site. Does CFDocument need permissions to grab the image and use it in the PDF ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284354 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CDDocument Image problem
Ya, I put the images in a public folder and chaged my image path to: img src=http://websitename/images/invoicelogoNEW.jpg border=0 Now the image shows up in the PDF. So what permissions does CFDocument need on images to place them into the PDF??? Right now SYSTEM has full permissions, and IIS_WPG has Read/Execute and list folders. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 9:27 AM To: CF-Talk Subject: CDDocument Image problem I am trying to use CFDocument to make a PDF of a web page. I have an image that produces what kinds of looks like a missing image icon in the PDF. When I click on thing in Acrobat it says There was an error processing an annotation or link. There was a problem reading this document (14). http://chadgray.info/Untitled-1.jpg Now this code works fine on our development server. Only on the production server do I get the problem. My code to place the image is simple enough. The page and image are in the same folder. The PDF is saved into a sub-folder. td width=352 height=59 valign=top align=center img src=invoicelogoNEW.jpg border=0 /td My code to make the pdf and save it is: cfdocument format=pdf pagetype=letter name=invoice overwrite=yes cffile action=write file=#application.invoicePDFPath##fileName# output=#invoice# H now that I think more about this. The area that this code is running from does have NTFS permissions on it so users have to login to use the web site. Does CFDocument need permissions to grab the image and use it in the PDF ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CDDocument Image problem
I had a problem with IMGs a while back. It turned out to be a problem with the Router, not with ColdFusion: http://www.bennadel.com/index.cfm?dax=blog:266.view I don't understand server stuff that much, but this might help. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 9:39 AM To: CF-Talk Subject: RE: CDDocument Image problem Ya, I put the images in a public folder and chaged my image path to: img src=http://websitename/images/invoicelogoNEW.jpg border=0 Now the image shows up in the PDF. So what permissions does CFDocument need on images to place them into the PDF??? Right now SYSTEM has full permissions, and IIS_WPG has Read/Execute and list folders. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284356 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
GROUP BY RIGHT()?
Hello Guys, I've got a query which returns a load of file names which I'm looking to group by their extension. Is there any way to do this dynamically from the name or do I have to make a separate column in the database? Can I do something like this: cfoutput query=myquery group=right(filename, 3) #myquery.filename# /cfoutput Thanks guys for any help, first time I've done any cf in a while, things are feeling a little rusty. Rob ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: GROUP BY RIGHT()?
Not sure if you can do that, but you might want to try getting the file extension as a calculated column in the query SELECT ( RIGHT( filename, 3 ) ) AS ext Then, in the CFOutput, you could group=ext .. 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, July 23, 2007 11:11 AM To: CF-Talk Subject: GROUP BY RIGHT()? Hello Guys, I've got a query which returns a load of file names which I'm looking to group by their extension. Is there any way to do this dynamically from the name or do I have to make a separate column in the database? Can I do something like this: cfoutput query=myquery group=right(filename, 3) #myquery.filename# /cfoutput Thanks guys for any help, first time I've done any cf in a while, things are feeling a little rusty. Rob ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GROUP BY RIGHT()?
cfquery name=foo datasource=bar SELECT filename, right(filename, 3) AS ext, othercol FROM table ORDER BY right(filename, 3) /cfquery cfoutput query=foo group=ext that, of course, assumes you only have file extensions of 3 characters. .jpeg or .tiff would throw off the logic. I suppose you could run an instr() function inside of a CASE to determine the position of the dot if need be. On 7/23/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Hello Guys, I've got a query which returns a load of file names which I'm looking to group by their extension. Is there any way to do this dynamically from the name or do I have to make a separate column in the database? Can I do something like this: cfoutput query=myquery group=right(filename, 3) #myquery.filename# /cfoutput Thanks guys for any help, first time I've done any cf in a while, things are feeling a little rusty. Rob ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284359 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GROUP BY RIGHT()?
No, but you could select a column in your query that reads just the first 3 characters of the filename, give it a column alias, order by that column alias, and then use that in your cfoutput group attribute. Something like this (check your particular RDBMS for the Right() function or similar): select filename, right(filename, 3) as lastThreeFileName from my table order by lastThreeFileName cfoutput group=lastThreeFileName/cfoutput On 7/23/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Hello Guys, I've got a query which returns a load of file names which I'm looking to group by their extension. Is there any way to do this dynamically from the name or do I have to make a separate column in the database? Can I do something like this: cfoutput query=myquery group=right(filename, 3) #myquery.filename# /cfoutput Thanks guys for any help, first time I've done any cf in a while, things are feeling a little rusty. Rob ~| ColdFusion 8 beta - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Project Time Tracking Software?
Hi Aaron, I don't know if you are still interested in a time tracking application. I would like to suggest Fanurio (http://www.fanuriotimetracking.com) which does both time tracking and invoicing (Iâm one of the people involved in this project). We have designed Fanurio to help freelancers manage their work and be paid for it. It can do basic project management, time tracking and invoicing in order to have all the functionality in one place. Cosmina ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284361 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Model Glue - Fusebox - Mach II ...... Looking for Opinions
I am looking for several opinions on all these frameworks and any others. Currently we are trying to figure out which one(s) we need to focus on evaluating so start a plan to port our current system into a framework. Our current system is basically a ton of cfincludes with the data access display and business logic all wrapped together. We would like to of course standardize the way new parts of the application are built so all three developers are writing virtually the same type code. The application is HUGE with a lot of reporting, I would say that virtually 70% of the application is reporting. Many of these reports are driven from one time use queries - basically queries that cannot be reused in other places. One concern is that a framework might add too much overhead to the application because of the use of XML files etc. The only framework any of the three has worked with is Fusebox(2 thru 5). It is acknowledged that we really should start using a framework but we just don't know which one is going to scale the best for us and makes the most sense. As a side note - we do not have time to really play with all the frameworks to see which one we like the best - that just not possible. Thanks Jason ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284362 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Model Glue - Fusebox - Mach II ...... Looking for Opinions
I've been working with FB recently, and what I wish I could do is create functions like we do fuseactions, and be able to use them in the includes. -Original Message- From: Jason Fill [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 11:26 AM To: CF-Talk Subject: Model Glue - Fusebox - Mach II .. Looking for Opinions I am looking for several opinions on all these frameworks and any others. Currently we are trying to figure out which one(s) we need to focus on evaluating so start a plan to port our current system into a framework. Our current system is basically a ton of cfincludes with the data access display and business logic all wrapped together. We would like to of course standardize the way new parts of the application are built so all three developers are writing virtually the same type code. The application is HUGE with a lot of reporting, I would say that virtually 70% of the application is reporting. Many of these reports are driven from one time use queries - basically queries that cannot be reused in other places. One concern is that a framework might add too much overhead to the application because of the use of XML files etc. The only framework any of the three has worked with is Fusebox(2 thru 5). It is acknowledged that we really should start using a framework but we just don't know which one is going to scale the best for us and makes the most sense. As a side note - we do not have time to really play with all the frameworks to see which one we like the best - that just not possible. Thanks Jason ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284363 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions
On 7/23/07, Jason Fill [EMAIL PROTECTED] wrote: I am looking for several opinions on all these frameworks and any others. I'm basically in the same boat and have decided to work with Fusebox. I'd love to hear thoughts/experiences on this topic too! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284364 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: GROUP BY RIGHT()?
Thanks guys for the suggestion, I'll agree that the calculated column is probably my best bet, you're right Charlie about that assuming the file extension is only 3 characters, however two file extensions with the same last 3 characters isn't all that likely. Now, I'm having a little trouble with this group by: cfoutput query=VARIABLES.Messages group=type #VARIABLES.Messages.type# /cfoutput For some reason it doesn't appear to group properly, either that or I'm forgetting how to use it properly :-D That code snippet outputs like this: Gif Jpg Gif Txt Gif Vcf See how it's not grouping the gifs properly? Any ideas what I'm missing? Thanks guys, Rob -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: 23 July 2007 16:24 To: CF-Talk Subject: Re: GROUP BY RIGHT()? No, but you could select a column in your query that reads just the first 3 characters of the filename, give it a column alias, order by that column alias, and then use that in your cfoutput group attribute. Something like this (check your particular RDBMS for the Right() function or similar): select filename, right(filename, 3) as lastThreeFileName from my table order by lastThreeFileName cfoutput group=lastThreeFileName/cfoutput On 7/23/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Hello Guys, I've got a query which returns a load of file names which I'm looking to group by their extension. Is there any way to do this dynamically from the name or do I have to make a separate column in the database? Can I do something like this: cfoutput query=myquery group=right(filename, 3) #myquery.filename# /cfoutput Thanks guys for any help, first time I've done any cf in a while, things are feeling a little rusty. Rob ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions
If everyone's worked with Fusebox, why not just pick Fusebox? There's always a lot of concern over performance and frameworks -- bluntly, unless you're doing *phenomenal* transaction volume with very tight time tolerances, the framework shouldn't be an issue. Scaling out horizontally or vertically is how you'll typically handle scaling, so the framework is a non-issue. And if it's that big a deal, you roll your own that focuses on performance or you throw bigger hardware at it until the problem disappears. If most of your application is reporting, then the databases (and correspondingly disk) are going to be the noticeable bottlenecks, not the parsing of the XML for a framework file. If you don't have time to play with them, then go with what your developers know. You're not going to have detailed performance information without spending time playing with them against your code. If your developers are not very experienced in OO development, that's another big plus for Fusebox. And with the declarative model of Fusebox, porting an existing application over is fairly straightforward since the top level fuses are already specified. You could quickly implement a MVC-oriented container using Fusebox5, use your existing CFINCLUDed code in the appropriate place (model in model, controller in controller, etc) and you'd be Fuseboxed. Using the something like MG or MachII has the additional overhead of really getting familiar with OO, which might be too big an initial bite. On 7/23/07, Jason Fill [EMAIL PROTECTED] wrote: I am looking for several opinions on all these frameworks and any others. Currently we are trying to figure out which one(s) we need to focus on evaluating so start a plan to port our current system into a framework. Our current system is basically a ton of cfincludes with the data access display and business logic all wrapped together. We would like to of course standardize the way new parts of the application are built so all three developers are writing virtually the same type code. The application is HUGE with a lot of reporting, I would say that virtually 70% of the application is reporting. Many of these reports are driven from one time use queries - basically queries that cannot be reused in other places. One concern is that a framework might add too much overhead to the application because of the use of XML files etc. The only framework any of the three has worked with is Fusebox(2 thru 5). It is acknowledged that we really should start using a framework but we just don't know which one is going to scale the best for us and makes the most sense. As a side note - we do not have time to really play with all the frameworks to see which one we like the best - that just not possible. Thanks Jason ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
name conflicts with cffile action=move
Is there any reason why cffile action=move doesn't support the nameconflict attribute, like action=upload, or is this just a design oversight? ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284367 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Model Glue - Fusebox - Mach II ...... Looking for Opinions
I will throw my $.02 towards model-glue:Unity. I have been doing OO based .cfc's now for several years, and MG:U really clicked with me. You have your model (which is basically events setup that fire off controller message-listeners). The model simply says 'ok, I have a request for something called X. Go run these controller actions (which will run queries, do actions, whatever you need) then invoke the view Y. Your controller block is just XML saying 'I have an event called goGetSomething that is tied to a cfc named myStuff.controller, and called a function called getSomething' Your views just grab data that the model or the controllers stuck into a 'scope' especially for the view. They have decent documentation and tons of examples out there, and once I got started, adding in new functions and pages is a snap! Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Jason Fill [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 11:26 AM To: CF-Talk Subject: Model Glue - Fusebox - Mach II .. Looking for Opinions I am looking for several opinions on all these frameworks and any others. Currently we are trying to figure out which one(s) we need to focus on evaluating so start a plan to port our current system into a framework. Our current system is basically a ton of cfincludes with the data access display and business logic all wrapped together. We would like to of course standardize the way new parts of the application are built so all three developers are writing virtually the same type code. The application is HUGE with a lot of reporting, I would say that virtually 70% of the application is reporting. Many of these reports are driven from one time use queries - basically queries that cannot be reused in other places. One concern is that a framework might add too much overhead to the application because of the use of XML files etc. The only framework any of the three has worked with is Fusebox(2 thru 5). It is acknowledged that we really should start using a framework but we just don't know which one is going to scale the best for us and makes the most sense. As a side note - we do not have time to really play with all the frameworks to see which one we like the best - that just not possible. Thanks Jason ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284366 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: GROUP BY RIGHT()?
An ORDER BY? Adrian -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: 23 July 2007 16:45 To: CF-Talk Subject: RE: GROUP BY RIGHT()? Thanks guys for the suggestion, I'll agree that the calculated column is probably my best bet, you're right Charlie about that assuming the file extension is only 3 characters, however two file extensions with the same last 3 characters isn't all that likely. Now, I'm having a little trouble with this group by: cfoutput query=VARIABLES.Messages group=type #VARIABLES.Messages.type# /cfoutput For some reason it doesn't appear to group properly, either that or I'm forgetting how to use it properly :-D That code snippet outputs like this: Gif Jpg Gif Txt Gif Vcf See how it's not grouping the gifs properly? Any ideas what I'm missing? Thanks guys, Rob ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GROUP BY RIGHT()?
did you ORDER BY appropriately? you need to ORDER BY the column(s) on which you're grouping. On 7/23/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Thanks guys for the suggestion, I'll agree that the calculated column is probably my best bet, you're right Charlie about that assuming the file extension is only 3 characters, however two file extensions with the same last 3 characters isn't all that likely. Now, I'm having a little trouble with this group by: cfoutput query=VARIABLES.Messages group=type #VARIABLES.Messages.type# /cfoutput For some reason it doesn't appear to group properly, either that or I'm forgetting how to use it properly :-D That code snippet outputs like this: Gif Jpg Gif Txt Gif Vcf See how it's not grouping the gifs properly? Any ideas what I'm missing? Thanks guys, Rob -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: 23 July 2007 16:24 To: CF-Talk Subject: Re: GROUP BY RIGHT()? No, but you could select a column in your query that reads just the first 3 characters of the filename, give it a column alias, order by that column alias, and then use that in your cfoutput group attribute. Something like this (check your particular RDBMS for the Right() function or similar): select filename, right(filename, 3) as lastThreeFileName from my table order by lastThreeFileName cfoutput group=lastThreeFileName/cfoutput On 7/23/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Hello Guys, I've got a query which returns a load of file names which I'm looking to group by their extension. Is there any way to do this dynamically from the name or do I have to make a separate column in the database? Can I do something like this: cfoutput query=myquery group=right(filename, 3) #myquery.filename# /cfoutput Thanks guys for any help, first time I've done any cf in a while, things are feeling a little rusty. Rob ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Web Based Project Management Tool
Oßuz Demirkapñ wrote: Of course it is my issue if I say this code does not support Unicode. But I think we have a different situation when we say, the code support Unicode. your static text, your encoding. do any other files in ray's blog have a BOM? I do not want BOM support. I just want to have your best practices and Unicode without BOM and required tags on it. The problem that I mentioned is not because of BOM support, it is because of having Western in page encoding. Ray has mixed encodings on his code. Some has Western, same Unicode w/o BOM and some Unicode w BOM and I think this is not he also wants to have. BOM is an optional point but I also *prefer* having BOM on all project files. :) it's optional by definition for utf-8. there's quite a bit of s/w floating around that will ignore or even remove it. unless you can guarantee that yoru files won't get touched by one of those apps, you're probably better off relying on cfprocessingdirective. We are talking a solution on CF and I do not care about other software or solutions. You can not also guarantee anything if we consider all possible alternatives. What we are trying to do is having a working platform in CF in order to have Unicode support. Just that. :) Ah, when I have Turkish as locale on my OS, CF still does not work/start. Is this my problem because of having Turkish as locale. Or this is an issue on CF which needs to be handled by Adobe or whoever. Specially if you consider other J2EE solutions such as Tomcat or JBoss works without any issue. ;) Have a nice week! Sincerely, OÄuz Demirkapı ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284371 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Web Based Project Management Tool
Thanks for the advice but we decided to use OpenSVN Trac as platform for this non-profit organization. By the way this product also does not support Unicode. ;) -Original Message- From: Mark Phillips [mailto:[EMAIL PROTECTED] Sent: Saturday, July 21, 2007 11:09 PM To: CF-Talk Subject: Re: Web Based Project Management Tool Have you looked at our product, Vertabase Pro? www.vertabase.com Its a web-based project management application written in CF. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284372 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: name conflicts with cffile action=move
I always thought it would be COOL if MOVE and COPY did handle the naming conflict as well. I can't see any downside to giving users the option to leverage CF for that. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Rebecca Younes [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 11:38 AM To: CF-Talk Subject: name conflicts with cffile action=move Is there any reason why cffile action=move doesn't support the nameconflict attribute, like action=upload, or is this just a design oversight? ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MySQL Client
Hi all, I am using Navicat (navicat.com) as MySQL client now but I would like to hear what you have. Do you have any MySQL client suggestion? I have MySQL 5.x and I need a solution which also supports Unicode. Thanks in advance for your suggestions. Sincerely, OÄuz Demirkapı Sr. Developer | TeraTech http://www.teratech.com ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284374 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL Client
I use the tools published by MySQL. Administrator and Query Browser, specifically. --Ben Doom OÄuz_Demirkapı wrote: Hi all, I am using Navicat (navicat.com) as MySQL client now but I would like to hear what you have. Do you have any MySQL client suggestion? I have MySQL 5.x and I need a solution which also supports Unicode. Thanks in advance for your suggestions. Sincerely, Oßuz Demirkapñ Sr. Developer | TeraTech http://www.teratech.com ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: mysql and media servers
The MySQL script file is meant to be run either at the command line with mysql tools, or with a MySQL client, like Aqua Data Studio. On 7/21/07, Peter Donahue [EMAIL PROTECTED] wrote: Good evening everyone, I just finished creating the database and the DSN for Blog CFC. My first question is do I upload the mysql.sol to a folder on the server, or does this need to be imported in to the mysql Administrator to create the tables the Blog_CFC Database will use? I looked at the documentation for Blog CFC again and find it to be more straight forward than I originally thought. And yes I downloaded the most recent version so we're good to go with it. Last week I posted concerning the limited amount of disk space one tends to get with ColdFusion Hosting accounts. A few of you suggested pulling audio and video files from a media server. Do you have any suggestions for online media storage you can recommend that will allow me to have more disk space to store these files so they can be accessed by my Web Sites? Your recommendations will be very much appreciated. Peter Donahue - Original Message - From: Dinner [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, July 21, 2007 8:12 PM Subject: Re: Help with joins... On 7/21/07, Crit wrote: Any suggestions? I am not even sure if this is the best way to setup the projects table.. so if it's not... let me know... I'd restructure your DB. Maybe use a join table instead? projectAnimals projectAnimalID projectID animalID Knowing nothing about what your doing tho... who knows? :-) ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions
I am looking for several opinions on all these frameworks and any others. Currently we are trying to figure out which one(s) we need to focus on evaluating so start a plan to port our current system into a framework. Our current system is basically a ton of cfincludes with the data access display and business logic all wrapped together. We would like to of course standardize the way new parts of the application are built so all three developers are writing virtually the same type code. The application is HUGE with a lot of reporting, I would say that virtually 70% of the application is reporting. Many of these reports are driven from one time use queries - basically queries that cannot be reused in other places. One concern is that a framework might add too much overhead to the application because of the use of XML files etc. The only framework any of the three has worked with is Fusebox(2 thru 5). It is acknowledged that we really should start using a framework but we just don't know which one is going to scale the best for us and makes the most sense. As a side note - we do not have time to really play with all the frameworks to see which one we like the best - that just not possible. Thanks Jason I'm porting an application to a framework also and decided on MachII. I looked at the three frameworks you mentioned and chose MachII. I chose it because it seemed to make MVC development with OO easiest for me to understand. Fusebox and ModelGlue are good frameworks though, but MachII seemed to click with me. Performance also isn't much of an issue because the application is initialized (XML file read and parsed) once and runs from memory (speaking from MachII and ModelGlue experience since I don't really understand how Fusebox is working under the hood in that respect). Even on my development machine, when I turn off debugging for a moment to test the look and feel of the app, it is blazing fast compared to my old app. In the end though, any of the frameworks will make a good choice, but don't expect that you will be up and running with ANY of the above frameworks in short time. It took me some time to evaluate each one and then finally to get comfortable with MachII. Each will have a learning curve to get over before your staff become efficient. Possibly your developers need to do a little homework outside of work to get up to speed with how each framework works. It would be a good investment of time to take a little piece of your application and re-factor it into each of the frameworks to see how they work and which one would benefit you. This is what I did before I decided on MachII! CoolJJ ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL Client
I second the MySQL tools recommendation. You can find the tools here: http://www.mysql.com/products/tools/ Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ BlueDragon Alliance Member [EMAIL PROTECTED] Ben Doom wrote: I use the tools published by MySQL. Administrator and Query Browser, specifically. --Ben Doom Oßuz_Demirkapñ wrote: Hi all, I am using Navicat (navicat.com) as MySQL client now but I would like to hear what you have. Do you have any MySQL client suggestion? I have MySQL 5.x and I need a solution which also supports Unicode. Thanks in advance for your suggestions. Sincerely, OÃâà ¸uz DemirkapÃâñ Sr. Developer | TeraTech http://www.teratech.com ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284378 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
LDAP SSLv3
I know that coldfusion MX's cfldap tag is limited to SSLv2. But the question is, how do I get around that problem. Im looking for a ready to go solution as I am working on an important project. So I ether need a custom tag, or specific instructions. I will be using the LDAP calls for the purpose of authentication. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MySQL Client
I like HeidiSQL formerly known as MySQL-Front. http://www.heidisql.com/ -Original Message- From: OÄuz_Demirkapı [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 12:29 PM To: CF-Talk Subject: MySQL Client Hi all, I am using Navicat (navicat.com) as MySQL client now but I would like to hear what you have. Do you have any MySQL client suggestion? I have MySQL 5.x and I need a solution which also supports Unicode. Thanks in advance for your suggestions. Sincerely, OÄuz Demirkapı Sr. Developer | TeraTech http://www.teratech.com ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284380 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MySQL Client
Man... The interface on that HeidiSQL app is HORRIBLE. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 1:55 PM To: CF-Talk Subject: RE: MySQL Client I like HeidiSQL formerly known as MySQL-Front. http://www.heidisql.com/ -Original Message- From: OÄuz_Demirkapı [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 12:29 PM To: CF-Talk Subject: MySQL Client Hi all, I am using Navicat (navicat.com) as MySQL client now but I would like to hear what you have. Do you have any MySQL client suggestion? I have MySQL 5.x and I need a solution which also supports Unicode. Thanks in advance for your suggestions. Sincerely, OÄuz Demirkapı Sr. Developer | TeraTech http://www.teratech.com ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284381 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL Client
OÄuz_Demirkapı said the following on 7/23/2007 11:29 AM: Do you have any MySQL client suggestion? I have MySQL 5.x and I need a solution which also supports Unicode. I use SQLyog: http://www.webyog.com/en/ -- Best regards, Chris Montgomery ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284382 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFC With Remote Access
I have a cfc that is called from JS that returns a string, works
perfectly on CF6 but is not working on CF7. My JS and cfc are below.
Again this exact code is working on my beta server with CF6 on it. The
production server is set up the same besides having CF7. When I try to
alert(result) on CF6 I get the correct value, when I do it on CF7 I get
a blank/empty value like the cfc was never called. If I do a
alert(objHTTP.status) after the objHTTP.send(null) I get a result of 200
var PromoCode = document.SubscriberForm.SpecialOfferCode.value;
CFOUTPUT
var strURL =
#Request.webroot#Ajax/MyFunctions.cfc?Method=FindPromoCodeSubType=1Th
ePromoCode= + PromoCode;
/CFOUTPUT
if(window.XMLHttpRequest) {
objHTTP = new XMLHttpRequest();
objHTTP.open(GET, strURL, false);
objHTTP.send(null);
result = objHTTP.responseText;
}
else if (window.ActiveXObject) {
objHTTP = new ActiveXObject(Microsoft.XMLHTTP);
objHTTP.open(GET,strURL,false);
objHTTP.send(null);
result = objHTTP.responseText;
}
var PromoCodeFound = result.substring(57,58);
if(PromoCodeFound == 1) {
return true;
}
else if(PromoCodeFound == 2) {
//alert(The promotion code entered is for a monthly subscription
you are signing up for a Pay-Per-Pick subscription.\n\n Please try
again.);
return true;
}
else {
//alert(The promotion code entered was not found.\n\n Please try
again.);
return true;
}
This is my CFC
cfcomponent
!--- Function to check the Promo Code ---
CFFUNCTION name=FindPromoCode returntype=string output=no
access=remote
CFARGUMENT name=ThePromoCode required=yes type=string
CFARGUMENT name=SubType required=yes type=string
CFQUERY name=FindPromoCode datasource=#request.dsource#
SELECT SubscriptionType
FROM SpecialOffers
WHERE PromoCode = '#Arguments.ThePromoCode#'
/CFQUERY
CFSET IsFound = 0 /
CFIF FindPromoCode.recordcount GT 0 AND FindPromoCode.SubscriptionType
IS NOT
CFIF Arguments.SubType EQ FindPromoCode.SubscriptionType
CFSET IsFound = 1 /
CFELSE
CFSET IsFound = 2 /
/CFIF
/CFIF
cfreturn IsFound /
/CFFUNCTION
/cfcomponent
~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284383
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 With Remote Access
Not sure about the differences from CF6 to 7, but you should add var
declarations to the beginning of your file to ensure no funky variable
values or un-expected behavior. I would re-write it like this:
CFFUNCTION name=FindPromoCode returntype=string output=no
access=remote
CFARGUMENT name=ThePromoCode required=yes type=string
CFARGUMENT name=SubType required=yes type=string
cfset var findPromoCode = '' /
cfset var isFound = 0 /
CFQUERY name=FindPromoCode datasource=#request.dsource#
SELECT SubscriptionType
FROM SpecialOffers
WHERE PromoCode = cfqueryparam cfsqltype=cf_sql_varchar
value=#arguments.thePromoCode#
/CFQUERY
CFIF FindPromoCode.recordcount GT 0 AND
FindPromoCode.SubscriptionType IS NOT
CFIF Arguments.SubType EQ FindPromoCode.SubscriptionType
CFSET IsFound = 1 /
CFELSE
CFSET IsFound = 2 /
/CFIF
/CFIF
cfreturn IsFound /
/CFFUNCTION
Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion Developer
-Original Message-
From: Chad McCue
Sent: Monday, July 23, 2007 3:33 PM
To: CF-Talk
Subject: CFC With Remote Access
I have a cfc that is called from JS that returns a string, works
perfectly on CF6 but is not working on CF7. My JS and cfc are below.
Again this exact code is working on my beta server with CF6 on it. The
production server is set up the same besides having CF7. When I try to
alert(result) on CF6 I get the correct value, when I do it on CF7 I get
a blank/empty value like the cfc was never called. If I do a
alert(objHTTP.status) after the objHTTP.send(null) I get a result of 200
var PromoCode = document.SubscriberForm.SpecialOfferCode.value;
CFOUTPUT
var strURL =
#Request.webroot#Ajax/MyFunctions.cfc?Method=FindPromoCodeSubType=1Th
ePromoCode= + PromoCode;
/CFOUTPUT
if(window.XMLHttpRequest) {
objHTTP = new XMLHttpRequest();
objHTTP.open(GET, strURL, false);
objHTTP.send(null);
result = objHTTP.responseText;
}
else if (window.ActiveXObject) {
objHTTP = new ActiveXObject(Microsoft.XMLHTTP);
objHTTP.open(GET,strURL,false);
objHTTP.send(null);
result = objHTTP.responseText;
}
var PromoCodeFound = result.substring(57,58);
if(PromoCodeFound == 1) {
return true;
}
else if(PromoCodeFound == 2) {
//alert(The promotion code entered is for a monthly subscription
you are signing up for a Pay-Per-Pick subscription.\n\n Please try
again.);
return true;
}
else {
//alert(The promotion code entered was not found.\n\n Please try
again.);
return true;
}
This is my CFC
cfcomponent
!--- Function to check the Promo Code --- CFFUNCTION
name=FindPromoCode returntype=string output=no
access=remote
CFARGUMENT name=ThePromoCode required=yes type=string
CFARGUMENT name=SubType required=yes type=string
CFQUERY name=FindPromoCode datasource=#request.dsource#
SELECT SubscriptionType
FROM SpecialOffers
WHERE PromoCode = '#Arguments.ThePromoCode#'
/CFQUERY
CFSET IsFound = 0 /
CFIF FindPromoCode.recordcount GT 0 AND FindPromoCode.SubscriptionType
IS NOT
CFIF Arguments.SubType EQ FindPromoCode.SubscriptionType
CFSET IsFound = 1 /
CFELSE
CFSET IsFound = 2 /
/CFIF
/CFIF
cfreturn IsFound /
/CFFUNCTION
/cfcomponent
~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284384
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Client
I would highly recommend Datastudio by Aquadata. It is a great Query tool that is cross-platform and works with all of the popular databases. I use it for MSSQL and MySQL. The table and column insight is great. I have recently settled on DBManager by DBTools for general MySQL admin. It has a pretty good range of functionality with a real nice diagram tool for working with foreign keys and documenting a database. It also has a query tool, but I use Datastudio for all my query work. Terry Schmitt ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284385 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: hooking up IMS Lite
very easy. If you've ever config'd a mail server before you should be in for about 5 minutes' work. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284386 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HostMySite: Linux Builder + CF No Longer Offered
Its the same old story for shared ColdFusion hosting... morons can code in crap that takes the server out and blows everyone else up with it. A service nightmare even if the host has CF knowledge. Takes me back to the days when I was on shared CF hosting at Interland. Anyone remember that nightmare world? And then moving to Virtualscape and how good they were by comparison? ah... CF nostalgia. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
news and press releases - need help!
I tried on here before without much luck, but I really need to know how to set up some code that allows us to notify people on a mailing list when we've posted a new news or press release item. I'm assuming I need to set up a database that will hold the people who register, but how will we notify them when something has been updated and how can we email them what's been updated? It's a lot like the mailing lists here. How do they work? I'm just really stuck putting all of the pieces together! ~| ColdFusion 8 beta - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284388 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 With Remote Access
What happens if you put a properly rendered URL to that CFC method into a browser? Do you get the string you expect or something else. Do note that a ColdFusion error page would return a 200 status code because it is a properly returned web page, just not the page, one usually wants. ~| ColdFusion 8 beta - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284389 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: news and press releases - need help!
Why not set up an RSS feed? I've done that before with a certain level of success. I created an admin interface that allowed me to add news items, and a CF page that fed the RSS feed. That way people can manage their own subscriptions. -- Nicholas M. Tunney Blog: http://www.nictunney.com Adobe Certified Advanced ColdFusion MX7 Developer Adobe Certified Instructor Adobe Community Expert Steven Sprouse wrote: I tried on here before without much luck, but I really need to know how to set up some code that allows us to notify people on a mailing list when we've posted a new news or press release item. I'm assuming I need to set up a database that will hold the people who register, but how will we notify them when something has been updated and how can we email them what's been updated? It's a lot like the mailing lists here. How do they work? I'm just really stuck putting all of the pieces together! ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions
Thank you all for the input on this topic. I defiantly think that in the short term and to get started Fusebox would have the smallest learning curve - which would allow us to get going fairly quick. While that is great, our main goal here is to adopt a framework that will be flexible and grow with us. We do not want to go down a path and in 2 years sayman I wish we would have taken a little extra time to adopt xyz framework over the one we chose. I think we have pretty much decided that we are going to use ColdSpring to take care of IoC. So let me throw this out, does any one of the frameworks lend itself better to the use of ColdSpring, and possible Transfer or Reactor? I have used ColdSpring with a Fusebox app and it seemed to work well, however I am not sure if it just works easier or better with other frameworks. Sorry if these seem like redundant questions, just trying to get everything that is on the top of my head out. On a side note, I am the only one that has any Fusebox experience and would not like to put that into our equation in this evaluation of which is best suited for us. Thanks again! ~| ColdFusion 8 beta - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HostMySite: Linux Builder + CF No Longer Offered
Thanks, I'm gonna give Vivio VPS a shot if their CF8 pricing is comparable to their CF7 pricing when it is announced. I'm just waiting on CF8. --Greg On 7/20/07, Jamie Price [EMAIL PROTECTED] wrote: Unfortunally HostMySite just discontinued the shared Linux Builder + CF plans, and won't offer them for CF8. The Windows plans have way less bandwidth and disk space per dollar spent. I've got a ticket in to find out if they plan to continue support for existing customers indefinitely. They are recommending their VPS for CF and Linux. --Greg Just to give you some background on this decision, after a recent audit of our services we found that the top six 'worst performing' servers were those that had the Linux CF Builder plans. That's not to say they're bad servers, but compared to the rest of our network they're an eyesore in terms of support. I think this has a LOT to do with the fact that SeeFusion, the software we use to keep CF in control on shared servers, doesn't work in a Linux Environment. Moving to a VPS would be good because you don't have to worry as much about CF performance problems stemming from other clients - just your own code. As to the RAM requirements CF can run on our 512 offering provided it's not a high traffic site...in which case I'd suggest the 1 GB offering. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284393 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: news and press releases - need help!
The steps are pretty simple. Front end Form to allow people to subscribe to the email. Form to allow people to UNSUBSCRIBE from the email When they ask to subscribe, add them to the database When they ask to unsubscribe, remove them from the database (or mark them inactive) Backend Form to allow you to create press release When the press release is created and saved, pull all the current active records from the email list, and send an email with the press release information to all those users. Those are the main steps. The rss idea is a good one, but more of an also for me than an instead of. On 7/23/07, Nicholas M Tunney [EMAIL PROTECTED] wrote: Why not set up an RSS feed? I've done that before with a certain level of success. I created an admin interface that allowed me to add news items, and a CF page that fed the RSS feed. That way people can manage their own subscriptions. -- Nicholas M. Tunney Blog: http://www.nictunney.com Adobe Certified Advanced ColdFusion MX7 Developer Adobe Certified Instructor Adobe Community Expert Steven Sprouse wrote: I tried on here before without much luck, but I really need to know how to set up some code that allows us to notify people on a mailing list when we've posted a new news or press release item. I'm assuming I need to set up a database that will hold the people who register, but how will we notify them when something has been updated and how can we email them what's been updated? It's a lot like the mailing lists here. How do they work? I'm just really stuck putting all of the pieces together! ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284392 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: news and press releases - need help!
You could download blogcfc (google it) and look at the code. It does this, and supports subscription confirmation to stop people from subscribing someone else. --Greg On 7/23/07, Jerry Johnson [EMAIL PROTECTED] wrote: The steps are pretty simple. Front end Form to allow people to subscribe to the email. Form to allow people to UNSUBSCRIBE from the email When they ask to subscribe, add them to the database When they ask to unsubscribe, remove them from the database (or mark them inactive) Backend Form to allow you to create press release When the press release is created and saved, pull all the current active records from the email list, and send an email with the press release information to all those users. Those are the main steps. The rss idea is a good one, but more of an also for me than an instead of. On 7/23/07, Nicholas M Tunney [EMAIL PROTECTED] wrote: Why not set up an RSS feed? I've done that before with a certain level of success. I created an admin interface that allowed me to add news items, and a CF page that fed the RSS feed. That way people can manage their own subscriptions. -- Nicholas M. Tunney Blog: http://www.nictunney.com Adobe Certified Advanced ColdFusion MX7 Developer Adobe Certified Instructor Adobe Community Expert Steven Sprouse wrote: I tried on here before without much luck, but I really need to know how to set up some code that allows us to notify people on a mailing list when we've posted a new news or press release item. I'm assuming I need to set up a database that will hold the people who register, but how will we notify them when something has been updated and how can we email them what's been updated? It's a lot like the mailing lists here. How do they work? I'm just really stuck putting all of the pieces together! ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284394 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 With Remote Access
Pasting the url in the web browser produces the correct result. Seems to be something with the xmlhttp request. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 4:23 PM To: CF-Talk Subject: Re: CFC With Remote Access What happens if you put a properly rendered URL to that CFC method into a browser? Do you get the string you expect or something else. Do note that a ColdFusion error page would return a 200 status code because it is a properly returned web page, just not the page, one usually wants. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284395 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions
Jason, There is a fantastic sample app, called LitePost, that Matt Woodward, Peter Farrell, Chris Scott, and few others contributed to, that is available on GoogleCode. It's way undocumented, but basically it shows a simple blogging application. The 'Model' layer is a single set of CFCs, with a single ColdSpring config file. The 'Controller' and 'View' layers are done in MG, Mach-II, and Fusebox, allowing you to try it on each one. Really great way of showing that, if written properly, an application can fairly easily port between any framework. Each framework app uses the same set of 'Model' components, as well as the same ColdSpring config file. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Jason Fill wrote: Thank you all for the input on this topic. I defiantly think that in the short term and to get started Fusebox would have the smallest learning curve - which would allow us to get going fairly quick. While that is great, our main goal here is to adopt a framework that will be flexible and grow with us. We do not want to go down a path and in 2 years sayman I wish we would have taken a little extra time to adopt xyz framework over the one we chose. I think we have pretty much decided that we are going to use ColdSpring to take care of IoC. So let me throw this out, does any one of the frameworks lend itself better to the use of ColdSpring, and possible Transfer or Reactor? I have used ColdSpring with a Fusebox app and it seemed to work well, however I am not sure if it just works easier or better with other frameworks. Sorry if these seem like redundant questions, just trying to get everything that is on the top of my head out. On a side note, I am the only one that has any Fusebox experience and would not like to put that into our equation in this evaluation of which is best suited for us. Thanks again! ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: news and press releases - need help!
Some ideas: The steps are pretty simple. Front end Form to allow people to subscribe to the email. Form to allow people to UNSUBSCRIBE from the email When they ask to subscribe, add them to the database After submit send an e-mail which contains their wish and a link to finalize the request with a generated authorization code that you can generate random such as UUID etc. When they ask to unsubscribe, remove them from the database (or mark Same process. First send an e-mail to authorize. them inactive) Backend Form to allow you to create press release When the press release is created and saved, pull all the current active records from the email list, and send an email with the press release information to all those users. Those are the main steps. The rss idea is a good one, but more of an also for me than an instead of. ~| ColdFusion 8 beta - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284396 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 With Remote Access
My server is also behind a strict firewall, not sure if that is my
problem. If it is what settings would I need to change?
-Original Message-
From: Peterson, Chris [mailto:[EMAIL PROTECTED]
Sent: Monday, July 23, 2007 3:47 PM
To: CF-Talk
Subject: RE: CFC With Remote Access
Not sure about the differences from CF6 to 7, but you should add var
declarations to the beginning of your file to ensure no funky variable
values or un-expected behavior. I would re-write it like this:
CFFUNCTION name=FindPromoCode returntype=string output=no
access=remote
CFARGUMENT name=ThePromoCode required=yes type=string
CFARGUMENT name=SubType required=yes type=string
cfset var findPromoCode = '' /
cfset var isFound = 0 /
CFQUERY name=FindPromoCode datasource=#request.dsource#
SELECT SubscriptionType
FROM SpecialOffers
WHERE PromoCode = cfqueryparam cfsqltype=cf_sql_varchar
value=#arguments.thePromoCode#
/CFQUERY
CFIF FindPromoCode.recordcount GT 0 AND
FindPromoCode.SubscriptionType IS NOT
CFIF Arguments.SubType EQ FindPromoCode.SubscriptionType
CFSET IsFound = 1 /
CFELSE
CFSET IsFound = 2 /
/CFIF
/CFIF
cfreturn IsFound /
/CFFUNCTION
Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion Developer -Original Message-
From: Chad McCue
Sent: Monday, July 23, 2007 3:33 PM
To: CF-Talk
Subject: CFC With Remote Access
I have a cfc that is called from JS that returns a string, works
perfectly on CF6 but is not working on CF7. My JS and cfc are below.
Again this exact code is working on my beta server with CF6 on it. The
production server is set up the same besides having CF7. When I try to
alert(result) on CF6 I get the correct value, when I do it on CF7 I get
a blank/empty value like the cfc was never called. If I do a
alert(objHTTP.status) after the objHTTP.send(null) I get a result of 200
var PromoCode = document.SubscriberForm.SpecialOfferCode.value;
CFOUTPUT
var strURL =
#Request.webroot#Ajax/MyFunctions.cfc?Method=FindPromoCodeSubType=1Th
ePromoCode= + PromoCode;
/CFOUTPUT
if(window.XMLHttpRequest) {
objHTTP = new XMLHttpRequest();
objHTTP.open(GET, strURL, false);
objHTTP.send(null);
result = objHTTP.responseText;
}
else if (window.ActiveXObject) {
objHTTP = new ActiveXObject(Microsoft.XMLHTTP);
objHTTP.open(GET,strURL,false);
objHTTP.send(null);
result = objHTTP.responseText;
}
var PromoCodeFound = result.substring(57,58);
if(PromoCodeFound == 1) {
return true;
}
else if(PromoCodeFound == 2) {
//alert(The promotion code entered is for a monthly subscription
you are signing up for a Pay-Per-Pick subscription.\n\n Please try
again.);
return true;
}
else {
//alert(The promotion code entered was not found.\n\n Please try
again.);
return true;
}
This is my CFC
cfcomponent
!--- Function to check the Promo Code --- CFFUNCTION
name=FindPromoCode returntype=string output=no
access=remote
CFARGUMENT name=ThePromoCode required=yes type=string
CFARGUMENT name=SubType required=yes type=string
CFQUERY name=FindPromoCode datasource=#request.dsource#
SELECT SubscriptionType
FROM SpecialOffers
WHERE PromoCode = '#Arguments.ThePromoCode#'
/CFQUERY
CFSET IsFound = 0 /
CFIF FindPromoCode.recordcount GT 0 AND FindPromoCode.SubscriptionType
IS NOT
CFIF Arguments.SubType EQ FindPromoCode.SubscriptionType
CFSET IsFound = 1 /
CFELSE
CFSET IsFound = 2 /
/CFIF
/CFIF
cfreturn IsFound /
/CFFUNCTION
/cfcomponent
~|
ColdFusion 8 beta - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284398
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Client
I am using Navicat (navicat.com) as MySQL client now but I would like to hear what you have. I've tried the MySQL tools, DBManager and a couple others and settled on Navicat. So far it's done the best for me, particularly in terms of creating correct SQL dumps with all the proper information included (like defaults, indexes, etc.). I liked DBManager particularly since I do work with multiple databases but I kept running into instances where it was not doing proper cases, which is kind of important with MySQL. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284399 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Client
Hello Mary Jo and listers, Thanks for this information. I'll need to download Navicat for Windows and give it a go. I have a MYSQL Script I need to run to create a database on a remote host. This is the database for Blog CFC. Do you need to have MYSQL installed on your local machine to use Navicat if you're going to work with MYSQL Databases located on remote servers? This is my first time installing a remote database. I'm a glutton for punishment. Peter Donahue who wishes we had a CFUG in San Antonio Texas right about now. - Original Message - From: Mary Jo Sminkey [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, July 23, 2007 5:36 PM Subject: Re: MySQL Client I am using Navicat (navicat.com) as MySQL client now but I would like to hear what you have. I've tried the MySQL tools, DBManager and a couple others and settled on Navicat. So far it's done the best for me, particularly in terms of creating correct SQL dumps with all the proper information included (like defaults, indexes, etc.). I liked DBManager particularly since I do work with multiple databases but I kept running into instances where it was not doing proper cases, which is kind of important with MySQL. --- Mary Jo ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284400 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 with Query
If all your photos will have prices you won't need to left join you can just join on them. Joel Watson wrote: That's true, but when I combine it with the LEFT OUTER JOIN on the comments, it screws up the comments. While it will return the prices information fine, it duplicates the comments values for the number of price fields there are. For example, each photo currently has 8 price values which are being returned. With the query and output that I currently have, the photos with comments have their comments values returned the number commens * 8. So if photo1 has 3 comments, it will return 24 values for the comments. I am pasting below the current query that I have, as well as my current output structure. Thanks for everyone's help so far---it's almost there! cfquery name=rsPhotoInformation datasource=#application.dsn# SELECT * FROM photos JOIN prices ON photos.photoID = prices.photoID_fk LEFT OUTER JOIN comments ON photos.photoID = comments.photoID_fk WHERE categoryID_fk = cfqueryparam value=1 cfsqltype=cf_sql_integer /cfquery cfoutput query=rsPhotoInformation group=photoID #photoTitle# br / cfoutput group=priceID #priceValue# br / /cfoutput cfoutput #commenter# /cfoutput br / br / /cfoutput Sorry to bump this thread...any ideas anyone? ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284401 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Running CF7 on 64 bit Windows
I thought I'd asked this either here or the CFServer list and was told it wasn't a problem. Can we run CF7 on 64 bit Windows Server 2003? Dual 64bit Xeon 5130s, and IIS6 as the web server. I'm getting the following error trying to access the CFIDE: %1 is not a valid Win32 application. Some searches lead me to not a lot of concrete information. The configuration is not fully supported by Macromedia, whatever that means. Are there no workarounds? Do we have to either wait for CF8 (surely 64 bit is fully supported in CF8, right?) or else install 32 bit Win2k3 Server? ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284402 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions
I also presented on this very topic at the Frameworks conference earlier this year. My slides and code are available for download: http://www.briankotek.com/blog/files/framework_agnostic_models_presentation_code.zip The takeaway should be that when your model is well architected and encapsulated, switching from say Fusebox to Mach-II should only require rewriting the config XML files and slight modifications to the views to support the way Mach-II passes event arguments. You should also be able to hit your model directly from a Flex front end with no (or extremely few) changes required. The question of ColdSpring and ORM is really separate from the UI-Controller frameworks. ColdSpring, Reactor, and Transfer play well with any of them. I'd say technically Model-Glue 2 has a slight edge because it already has ColdSpring embedded within it (the framework itself uses ColdSpring to configure itself) and also has built in ORM support (via the built in ORMAdapter and scaffolding). But getting ColdSpring to work with the other frameworks is not difficult at all, nor is using one of the ORM frameworks. Basically, I'd be more concerned about which UI-Controller framework the team was most comfortable with, as well as the challenge of really understanding best practices regarding ColdSpring and the ORM frameworks themselves. These are the hard parts. Hope that helps. On 7/23/07, Cutter (CFRelated) [EMAIL PROTECTED] wrote: Jason, There is a fantastic sample app, called LitePost, that Matt Woodward, Peter Farrell, Chris Scott, and few others contributed to, that is available on GoogleCode. It's way undocumented, but basically it shows a simple blogging application. The 'Model' layer is a single set of CFCs, with a single ColdSpring config file. The 'Controller' and 'View' layers are done in MG, Mach-II, and Fusebox, allowing you to try it on each one. Really great way of showing that, if written properly, an application can fairly easily port between any framework. Each framework app uses the same set of 'Model' components, as well as the same ColdSpring config file. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Jason Fill wrote: Thank you all for the input on this topic. I defiantly think that in the short term and to get started Fusebox would have the smallest learning curve - which would allow us to get going fairly quick. While that is great, our main goal here is to adopt a framework that will be flexible and grow with us. We do not want to go down a path and in 2 years sayman I wish we would have taken a little extra time to adopt xyz framework over the one we chose. I think we have pretty much decided that we are going to use ColdSpring to take care of IoC. So let me throw this out, does any one of the frameworks lend itself better to the use of ColdSpring, and possible Transfer or Reactor? I have used ColdSpring with a Fusebox app and it seemed to work well, however I am not sure if it just works easier or better with other frameworks. Sorry if these seem like redundant questions, just trying to get everything that is on the top of my head out. On a side note, I am the only one that has any Fusebox experience and would not like to put that into our equation in this evaluation of which is best suited for us. Thanks again! ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Running CF7 on 64 bit Windows
CF8 will only support 64-bit on Solaris. CF7 doesn't support 64-bit. I would stick to what is supported unless your client and you are willing deal with debugging things without Adobe support. Is there a particular reason you are wanting 64-bit? Just processing power? Thread throughput? John [EMAIL PROTECTED] -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 9:37 PM To: CF-Talk Subject: Running CF7 on 64 bit Windows I thought I'd asked this either here or the CFServer list and was told it wasn't a problem. Can we run CF7 on 64 bit Windows Server 2003? Dual 64bit Xeon 5130s, and IIS6 as the web server. I'm getting the following error trying to access the CFIDE: %1 is not a valid Win32 application. Some searches lead me to not a lot of concrete information. The configuration is not fully supported by Macromedia, whatever that means. Are there no workarounds? Do we have to either wait for CF8 (surely 64 bit is fully supported in CF8, right?) or else install 32 bit Win2k3 Server? ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions
On 7/23/07, Jason Fill [EMAIL PROTECTED] wrote: One concern is that a framework might add too much overhead to the application because of the use of XML files etc. The only framework any of the three has worked with is Fusebox(2 thru 5). All three frameworks have a production mode where they read the XML once at startup and that's it so there really is no performance overhead in that mode. As John Paul says, if there is some familiarity with one of the frameworks, that will likely be your best bet since not all of the team will have as steep a learning curve. I'll answer your follow-up post next... -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions
On 7/23/07, Jason Fill [EMAIL PROTECTED] wrote: I think we have pretty much decided that we are going to use ColdSpring to take care of IoC. So let me throw this out, does any one of the frameworks lend itself better to the use of ColdSpring, and possible Transfer or Reactor? They all work fine with ColdSpring and Transfer or Reactor. My startup's website is built with Fusebox 5.1, ColdSpring and Transfer. We initialize the model - using ColdSpring - in a fuseaction in the model circuit, specified by the appinit global fuseaction. Then we either invoke service layer CFCs from fuseactions or just interact with them from model fuses (CFML pages includedd from the model circuit's fuseactions). On a side note, I am the only one that has any Fusebox experience and would not like to put that into our equation in this evaluation of which is best suited for us. Well, you can't really take it out of the equation since you are part of the team and therefore your experience is part of the team's experience. I have experience with all three frameworks (and ColdSpring and Transfer and Reactor as well) but if I was part of a team that on balance had more experience with any given framework, I'd be happy to go that way. If I was part of a team that had no framework experience, I'd have to balance other aspects of their experience to determine which framework I might pick. Overall, picking any framework is better than not picking one. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| ColdFusion 8 beta - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Running CF7 on 64 bit Windows
Jim McAtee wrote: I thought I'd asked this either here or the CFServer list and was told it wasn't a problem. Can we run CF7 on 64 bit Windows Server 2003? Dual 64bit Xeon 5130s, and IIS6 as the web server. You can run CF as a 32 bit application on 64 bit Windows. Connecting to a 64 bit webserver is not supported. Jochem ~| ColdFusion 8 beta - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284407 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
