Re: CF and OOP - Controller
How much is the FAQU? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Matt Quackenbush To: CF-Talk Sent: Sun Dec 31 00:23:46 2006 Subject: Re: CF and OOP - Controller Jon, Thanks for the FAQU tip; it sounds like I definitely need to read the article(s). I keep meaning to subscribe, but I keep forgetting to. Hopefully I'll remember to do so when the next check comes in (before it's all spent!) :-) You've definitely helped clear the muck a bit. I'm pretty sure that my thinking is basically inline with your pointers and statements, just possibly worded a bit differently. In the old days, when the user submits a login form, I would simply have the code written at the top of the action file that would check their creds and grant/deny access accordingly. Now that I'm moving to an OO-based mindset (I realize that CF is not true OO), I want that code removed from the view. I have the userObject, but I don't allow it to access outside scopes. Whatever it requires in the form of outside data must be passed in. That's where, in my mind, the controller comes into play. It, to me, as the intermediary between the view and the model, has basically become the replacement (for a lack of a better word) for the code that used to be at the top of the view file. So now, the controller intercepts the page request, grabs the username/password from the form scope, and sends it off to the userObject to be verified/validated. I'm trying not to get too verbose here, so I'm not getting into the whole DAO/Gateway portion of it, but the controller would also handle any required interaction with those as well before sending the request back to the view. Anyways, I'll continue to plug away and learn all I can so that one day when I grow up I can maybe be a real programmer! LOL Matt ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
tool generate sql insert / update statements
I'm looking for a tool that would alow me select a table and then it automatically generates a series SQL statements to select, insert, update, delete records from the taable. Any suggestions. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF and OOP - Controller
I just picked up a single pdf download for 6.95. This way I can read through it and see if i like it or not On 12/31/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: How much is the FAQU? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Matt Quackenbush To: CF-Talk Sent: Sun Dec 31 00:23:46 2006 Subject: Re: CF and OOP - Controller Jon, Thanks for the FAQU tip; it sounds like I definitely need to read the article(s). I keep meaning to subscribe, but I keep forgetting to. Hopefully I'll remember to do so when the next check comes in (before it's all spent!) :-) You've definitely helped clear the muck a bit. I'm pretty sure that my thinking is basically inline with your pointers and statements, just possibly worded a bit differently. In the old days, when the user submits a login form, I would simply have the code written at the top of the action file that would check their creds and grant/deny access accordingly. Now that I'm moving to an OO-based mindset (I realize that CF is not true OO), I want that code removed from the view. I have the userObject, but I don't allow it to access outside scopes. Whatever it requires in the form of outside data must be passed in. That's where, in my mind, the controller comes into play. It, to me, as the intermediary between the view and the model, has basically become the replacement (for a lack of a better word) for the code that used to be at the top of the view file. So now, the controller intercepts the page request, grabs the username/password from the form scope, and sends it off to the userObject to be verified/validated. I'm trying not to get too verbose here, so I'm not getting into the whole DAO/Gateway portion of it, but the controller would also handle any required interaction with those as well before sending the request back to the view. Anyways, I'll continue to plug away and learn all I can so that one day when I grow up I can maybe be a real programmer! LOL Matt ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Ajaxcfc newbe problems
Hello people for once again, While trying develop my first ajax application I have stuck with the following problem. I am using a function on my test.cfc which automatically generates some output and I want to pass the output on my test.cfm page. Test.cfc looks like this: cfcomponent extends=ajax cffunction name=myFuncIngrWorld access=public Output=Yes cfoutput My ajax.cfc Coldfusion Example /cfoutput /cffunction /cfcomponent and on the test.cfm we have: !-- script type='text/javascript' _ajaxConfig = { '_cfscriptLocation':'Test.cfc', '_jsscriptFolder':'../js', 'debug':true}; /script script type='text/javascript' src='../js/ajax.js'/script script type=text/javascript function doingr() { DWREngine._execute(_ajaxConfig._cfscriptLocation, null, 'myFuncIngrWorld'); } /script-- and: !--a href=#onClick='document.getElementById(contentMain).innerHTML = doingr();'example/a/li-- The debugers error is invalid reply from server Thanx a lot for one more time... Ioannis ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: web servers - apache or IIS
thanks very much for all your help. good point about going with what they know jim. When i asked the admin people what they would prefer they looked blank and didnt say much when it came to apache so i think that was my answer :) thanks very much again for all your help ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
handling timeouts
hi, i am just configuring my system to handle timeouts for the first time. i was just wondering if i could get some opinions on the best way to do this, or how most of the experts do it. specifically, i was wondering how to deal with data that needs to be saved. my system has some features that require the user to think about their input, maybe for some time so i was thinking that i should set the timeout to about an hour. but if they extend this time is there a way to automatically save the data they have not saved before it logs them out. do i put the save code in the timeout code in the application .cfc? i would appreciate any general opinions or advice regarding handling timeouts just so i can get a grasp on how you guys handle it. thanks very much for any help ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265417 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: handling timeouts
For your 'think for a long time' example, I'd suggest you look at using javascript and cookies. In Blogger, for example, while you're posting a message, the system tells your browser to save the form's contents to a cookie every few seconds. So if your browser crashes and you go back to blogger, you get the 'saved' post back. In case you're wondering, I currently use BlogCFC, but I've been a blogger for almost 5 years now, and originally I had my blog on Blogger, long before it was purchased by Google. On 12/31/06, Richard White [EMAIL PROTECTED] wrote: hi, i am just configuring my system to handle timeouts for the first time. i was just wondering if i could get some opinions on the best way to do this, or how most of the experts do it. specifically, i was wondering how to deal with data that needs to be saved. my system has some features that require the user to think about their input, maybe for some time so i was thinking that i should set the timeout to about an hour. but if they extend this time is there a way to automatically save the data they have not saved before it logs them out. do i put the save code in the timeout code in the application .cfc? i would appreciate any general opinions or advice regarding handling timeouts just so i can get a grasp on how you guys handle it. thanks very much for any help ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Ajaxcfc newbe problems
Why are you putting output in the ajax component? You need to create a component that extends ajax.cfc. Have you tried to run any of the examples? On 12/31/06, Ioannis Papanikolaou [EMAIL PROTECTED] wrote: Hello people for once again, While trying develop my first ajax application I have stuck with the following problem. I am using a function on my test.cfc which automatically generates some output and I want to pass the output on my test.cfm page. Test.cfc looks like this: cfcomponent extends=ajax cffunction name=myFuncIngrWorld access=public Output=Yes cfoutput My ajax.cfc Coldfusion Example /cfoutput /cffunction /cfcomponent and on the test.cfm we have: !-- script type='text/javascript' _ajaxConfig = { '_cfscriptLocation':'Test.cfc', '_jsscriptFolder':'../js', 'debug':true}; /script script type='text/javascript' src='../js/ajax.js'/script script type=text/javascript function doingr() { DWREngine._execute(_ajaxConfig._cfscriptLocation, null, 'myFuncIngrWorld'); } /script-- and: !--a href=#onClick='document.getElementById(contentMain).innerHTML = doingr();'example/a/li-- The debugers error is invalid reply from server Thanx a lot for one more time... Ioannis ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: tool generate sql insert / update statements
Dreamweaver. -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 31 December 2006 15:00 To: CF-Talk Subject: tool generate sql insert / update statements I'm looking for a tool that would alow me select a table and then it automatically generates a series SQL statements to select, insert, update, delete records from the taable. Any suggestions. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: tool generate sql insert / update statements
I use cfeclipse but i have dw 2004 is it in that version -- Original Message -- From: Snake [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Sun, 31 Dec 2006 16:09:23 - Dreamweaver. -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 31 December 2006 15:00 To: CF-Talk Subject: tool generate sql insert / update statements I'm looking for a tool that would alow me select a table and then it automatically generates a series SQL statements to select, insert, update, delete records from the taable. Any suggestions. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265421 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ajaxcfc newbe problems
Why are you putting output in the ajax component? You need to create a component that extends ajax.cfc. Have you tried to run any of the examples? On 12/31/06, Ioannis Papanikolaou [EMAIL PROTECTED] wrote: Answers: 1st) I am putting output because this is what I want my component to do. In reality it reads rdf files and displays the output. The Component works fine if I just put : cfinvoke component=Test method=myFuncIngrWorld /cfinvoke But this is not my goal. I need to dynamicaly extract stored content from the server using Ajax. 2nd) My component extends AJAX.cfc according to the examples. Actually as far as I understand I just need to cfcomponent extends=ajax. 3rd) I ve test 3 of the examples and are working fine from my server. I forgot to specify before Server: PIII 1000 512 MB UBUNTU 6.06 MySQL 5 Coldfusion 7.02 Thanx for your responce Ioannis ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265422 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: tool generate sql insert / update statements
This is my favorite! It may do a little more than you need as it generates components but it is a great tool! The great thing about it is you can easily customize the xsl templates to output your style of coding. http://cfcgenerator.riaforge.org/ On 12/31/06, Snake [EMAIL PROTECTED] wrote: Dreamweaver. -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 31 December 2006 15:00 To: CF-Talk Subject: tool generate sql insert / update statements I'm looking for a tool that would alow me select a table and then it automatically generates a series SQL statements to select, insert, update, delete records from the taable. Any suggestions. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: tool generate sql insert / update statements
Dwayne Cole wrote: I'm looking for a tool that would alow me select a table and then it automatically generates a series SQL statements to select, insert, update, delete records from the taable. Any suggestions. Aqua Data Studio has this...you just right click on a table and choose what type of operation you want to script. It also does CREATE, ALTER, etc. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265424 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Ajaxcfc newbe problems
Invalid reply from the server? Do you use firebug? If not firebug will let you see the request to and from the server. That should give you a much better idea of what is going on. fyi - i just re read my 1st comment and that came out wrong, please dont think I was trying to be a d*** ...i had a rough night last night! Dan On 12/31/06, Ioannis Papanikolaou [EMAIL PROTECTED] wrote: Why are you putting output in the ajax component? You need to create a component that extends ajax.cfc. Have you tried to run any of the examples? On 12/31/06, Ioannis Papanikolaou [EMAIL PROTECTED] wrote: Answers: 1st) I am putting output because this is what I want my component to do. In reality it reads rdf files and displays the output. The Component works fine if I just put : cfinvoke component=Test method=myFuncIngrWorld /cfinvoke But this is not my goal. I need to dynamicaly extract stored content from the server using Ajax. 2nd) My component extends AJAX.cfc according to the examples. Actually as far as I understand I just need to cfcomponent extends=ajax. 3rd) I ve test 3 of the examples and are working fine from my server. I forgot to specify before Server: PIII 1000 512 MB UBUNTU 6.06 MySQL 5 Coldfusion 7.02 Thanx for your responce Ioannis ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: tool generate sql insert / update statements
can you give me a hint to install it? and is there any support? -- Original Message -- From: Dan Vega [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Sun, 31 Dec 2006 11:18:14 -0500 This is my favorite! It may do a little more than you need as it generates components but it is a great tool! The great thing about it is you can easily customize the xsl templates to output your style of coding. http://cfcgenerator.riaforge.org/ On 12/31/06, Snake [EMAIL PROTECTED] wrote: Dreamweaver. -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 31 December 2006 15:00 To: CF-Talk Subject: tool generate sql insert / update statements I'm looking for a tool that would alow me select a table and then it automatically generates a series SQL statements to select, insert, update, delete records from the taable. Any suggestions. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265426 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: handling timeouts
Unless you specially want someone to be logged out, you can simply re-create the session after it expires and carry on as normal. If you do want the user to be logged out, then you could save the current form data in a cookie, or alternately save the submitted data and post it to the the login page and then return the user including the data back to where they were after they login again. -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: 31 December 2006 14:41 To: CF-Talk Subject: handling timeouts hi, i am just configuring my system to handle timeouts for the first time. i was just wondering if i could get some opinions on the best way to do this, or how most of the experts do it. specifically, i was wondering how to deal with data that needs to be saved. my system has some features that require the user to think about their input, maybe for some time so i was thinking that i should set the timeout to about an hour. but if they extend this time is there a way to automatically save the data they have not saved before it logs them out. do i put the save code in the timeout code in the application .cfc? i would appreciate any general opinions or advice regarding handling timeouts just so i can get a grasp on how you guys handle it. thanks very much for any help ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265427 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ajaxcfc newbe problems
Invalid reply from the server? Do you use firebug? If not firebug will let you see the request to and from the server. That should give you a much better idea of what is going on. fyi - i just re read my 1st comment and that came out wrong, please dont think I was trying to be a d*** ...i had a rough night last night! Dan On 12/31/06, Ioannis Papanikolaou [EMAIL PROTECTED] wrote: Thanx for the advice FireBug lloks quite cool especialy for DOM but I am not sure if I am using it right. I am not receiving any errors... Thanx anyway Any other Ideas more than welcome Ioannis ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Gift Certificate/Shopping cart question
I personally just use the code, since it's a 20-digit random code that's going to be pretty secure on its own. You don't want to use the email since many people purchase them to give as gifts and the person using the code may not know the email of the person that bought it originally. I'm using the receiver's email in the field. The purchaser makes the purchase, then the receiver receives their certificate via email. But this makes me think... should I offer a choice of electronic or paper certificates? giftCertificateManager.cfc would be able to generate both types depending on what the user selects during checkout. Or should it just be a simple printable gift certificate type of thing. Thanks Mary Jo! Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Output query into table columns
Hello All, First of all, Happy New Year to all!! I'm struggling with outputting a query result. I query the database and I want the output similar to below: table border=1 tr td colspan=2Header 1/td td colspan=2Header 2/td /tr tr tdPicture 1/td tdInfo 1/td tdPicture 2/td tdInfo 2/td /tr tr td colspan=2Icons 1/td td colspan=2Icons 2/td /tr tr td colspan=2Header 3/td td colspan=2Header 4/td /tr tr tdPicture 3/td tdInfo 3/td tdPicture 4/td tdInfo 4/td /tr tr td colspan=2Icons 3/td td colspan=2Icons 4/td /tr /table To make it clearer, if I were to just output the query in a standard way, the following would result: Header 1 Picture 1 Info 1 Icons 1 Header 2 Picture 2 Info 2 Icons 2 Header 3 Picture 3 Info 3 Icons 3 Header 4 Picture 4 Info 4 Icons 4 Has anyone done this and would be willing to give me some tips on how to accomplish? Any help would be greatly appreciated. If I have not explained well enough let me know. Thanks, Greg ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265430 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Gift Certificate/Shopping cart question
I'm using the receiver's email in the field. The purchaser makes the purchase, then the receiver receives their certificate via email. But this makes me think... should I offer a choice of electronic or paper certificates? giftCertificateManager.cfc would be able to generate both types depending on what the user selects during checkout. I would allow either, because they may not want to email it. They may not know the receipient's email or they may want to give it as a gift at a later time, use it in a raffle as a prize, etc. Leave it as flexible for the buyer as possible. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265431 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CD Storage and Read Device
Hi, Dave... thanks for the reply. That looks like exactly the kind of device I'm looking for, but I'll bet it costs a lot more than I'm willing to pay. On every website I looked at where it's sold, you have to Call for a quote... I hate that. It's probably a lot more than the $200 or so I'd be willing to put into it. I can get similar stackable, chainable, 120-disk capacity CD/DVD holders that link to my computer, but they don't read the disks. I have to take them out and put them in my drive... a pain. But they only run about $80 each. Any idea how much a device like is mentioned on the link you sent might cost? Also, I thought about using an external drive and just loading ISO images onto it, but the risk of drive failure and losing all the info would be very great. I guess I can always keep another drive for backup, but I'd rather just serve the disks than have to create all those images. Rick -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, December 31, 2006 1:32 AM To: CF-Talk Subject: RE: CD Storage and Read Device You might try this: http://www.kintronics.com/jukebox.html Alternatively, you could just use ISO images instead of the actual CDs. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265432 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLocaleDateFormatException... WTF?
OK so I am working on a client's site. I am inserting a record into a SQL Server smalldatetime field like so: cfqueryparam value=#now()# cfsqltype=CF_SQL_DATE And I get back The cause of this output exception was that: coldfusion.runtime.locale.CFLocaleDateFormatException: {ts ''2006-12-31 12:35:23''} is an invalid date format.. So I try converting the field into a datetime field. No change. Next I change the cfqueryparam to cfqueryparam value=#now()# cfsqltype=CF_SQL_TIMESTAMP just for giggles. Again the same error. This is a pretty straightforward db, and a server I have worked on for quite some time without this happening. What could cause a locale exception error like this? CF is 6.1 Enterprise. db is SQL Server 2000. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Gift Certificate/Shopping cart question
Seems like a good idea would be to create a GiftCertificate.cfc and subclass them for specifc types DigitalCertificate extends GiftCertificate PaperCertificate extends GiftCertificate I would even look more into the Strategy Design Pattern. I am no OO expert but I have been reading up on different patterns lately and this looks like it may fit. If Im wrong here someone please point that out! http://en.wikipedia.org/wiki/Strategy_pattern On 12/31/06, Mary Jo Sminkey [EMAIL PROTECTED] wrote: I'm using the receiver's email in the field. The purchaser makes the purchase, then the receiver receives their certificate via email. But this makes me think... should I offer a choice of electronic or paper certificates? giftCertificateManager.cfc would be able to generate both types depending on what the user selects during checkout. I would allow either, because they may not want to email it. They may not know the receipient's email or they may want to give it as a gift at a later time, use it in a raffle as a prize, etc. Leave it as flexible for the buyer as possible. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265434 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLocaleDateFormatException... WTF?
How about cfqueryparam value=#createODBCDate(now())# cfsqltype=CF_SQL_DATE -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265435 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF and OOP - Controller
Hmmm... I tried to do that, but when I submit the form, it gives me only a blank page (with just the masthead and sidebar). I tried on 4 different browsers, and got the same result. :-( On 12/31/06, Dan Vega [EMAIL PROTECTED] wrote: I just picked up a single pdf download for 6.95. This way I can read through it and see if i like it or not ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265436 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLocaleDateFormatException... WTF?
I forgot to mention that CreateODBCDateTime(now()) doesn't do the trick either. Just tried your idea and got this: The cause of this output exception was that: coldfusion.runtime.locale.CFLocaleDateFormatException: {d ''2006-12-31''} is an invalid date format. I have found a solution but it makes ZERO sense: Give up on cfqueryparam and do a raw insertion. If I do that the db will accept both #now()# and #CreateODBCDateTime(now())# with similarly corrrect results in a Sql Server datetime field. Which points to cfqueryparam, which in turn points to java/jdbc? How can this happen? While its not the end of the world to do without cfqueryparam in this instance, I really don't like to 'go bare' like this. Especially for something so apparently bizarre. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com On 12/31/06, Claude Schneegans [EMAIL PROTECTED] wrote: How about cfqueryparam value=#createODBCDate(now())# cfsqltype=CF_SQL_DATE -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265437 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Output query into table columns
You could loop over the query like normal using cfloop and an index variable, but only store the values in a structure, instead of outputting them. The last part of your loop will have a cfif to check if the current row is even using the mod operator, like this: cfif i mod 2 eq 0 and then in the cfif output your display code, using the variables you stored above. This will only output the display code every other row. The last part of the cfif should reset the above structure. Does this make sense? On 12/31/06, Greg Edmonds [EMAIL PROTECTED] wrote: Hello All, First of all, Happy New Year to all!! I'm struggling with outputting a query result. I query the database and I want the output similar to below: table border=1 tr td colspan=2Header 1/td td colspan=2Header 2/td /tr tr tdPicture 1/td tdInfo 1/td tdPicture 2/td tdInfo 2/td /tr tr td colspan=2Icons 1/td td colspan=2Icons 2/td /tr tr td colspan=2Header 3/td td colspan=2Header 4/td /tr tr tdPicture 3/td tdInfo 3/td tdPicture 4/td tdInfo 4/td /tr tr td colspan=2Icons 3/td td colspan=2Icons 4/td /tr /table To make it clearer, if I were to just output the query in a standard way, the following would result: Header 1 Picture 1 Info 1 Icons 1 Header 2 Picture 2 Info 2 Icons 2 Header 3 Picture 3 Info 3 Icons 3 Header 4 Picture 4 Info 4 Icons 4 Has anyone done this and would be willing to give me some tips on how to accomplish? Any help would be greatly appreciated. If I have not explained well enough let me know. Thanks, Greg ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265438 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ajaxcfc newbe problems
You need to tick show xmlhttprequests in the firebug config. It will show each request and the result. On 1/1/07, Ioannis Papanikolaou [EMAIL PROTECTED] wrote: Invalid reply from the server? Do you use firebug? If not firebug will let you see the request to and from the server. That should give you a much better idea of what is going on. fyi - i just re read my 1st comment and that came out wrong, please dont think I was trying to be a d*** ...i had a rough night last night! Dan On 12/31/06, Ioannis Papanikolaou [EMAIL PROTECTED] wrote: Thanx for the advice FireBug lloks quite cool especialy for DOM but I am not sure if I am using it right. I am not receiving any errors... Thanx anyway Any other Ideas more than welcome Ioannis ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RDS in CFECLIPSE. What's Wrong?
In installed the RDS cfeclipse (3.1) plugin CFMX 7. When I set up the preference using port 80. I am able to test and verify the connection but when I go to view the Dataview I get an error that says: unable to connect to part: RDS Dataview then the dataview tab pops up but says: An error has occurred when creating this view What's am I doing wrong? The view works in Flex Builder for Eclipes but not in cfeclipse. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265440 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RDS in CFECLIPSE. What's Wrong?
Amended; It says that the plugin has a configuration error. I tried to disable and uninstall the plugin to no avail. In fact when I open cfeclipse all the rds features (rds configuration in preferences, cfplugin in manage configuration). I was going to just re-install but I can't get the darn thing to un-install. PS RDS stills runs in flex builder for eclipse -- Original Message -- From: Dwayne Cole [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Sun, 31 Dec 2006 20:29:59 -0500 In installed the RDS cfeclipse (3.1) plugin CFMX 7. When I set up the preference using port 80. I am able to test and verify the connection but when I go to view the Dataview I get an error that says: unable to connect to part: RDS Dataview then the dataview tab pops up but says: An error has occurred when creating this view What's am I doing wrong? The view works in Flex Builder for Eclipes but not in cfeclipse. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265441 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFMX7- incompatibility with latest OSCache (open symphony)?
I am using OSCache for my app,and it seem CF is dependent on an older version of the library. (www.opensymphony.com http://www.opensymphony.com/ ) - Nothing really blows up, but I do see these errors in my log. Who in adobe can I contact to see if they can patch CF to use the latest API? Thanks Dov [0]javax.servlet.ServletException: com.opensymphony.oscache.base.Cache.init(ZZZLjava/lang/String;I)V at coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.ja va:104) at coldfusion.bootstrap.BootstrapServlet.init(BootstrapServlet.java:48) at jrun.servlet.WebApplicationService.loadServlet(WebApplicationService.java:12 42) at jrun.servlet.WebApplicationService.preloadServlets(WebApplicationService.jav a:789) at jrun.servlet.WebApplicationService.postStart(WebApplicationService.java:291) at jrun.ea.EnterpriseApplication.start(EnterpriseApplication.java:203) at jrun.deployment.DeployerService.initModules(DeployerService.java:710) at jrun.deployment.DeployerService.createWatchedDeployment(DeployerService.java :242) at jrun.deployment.DeployerService.deploy(DeployerService.java:430) at jrun.deployment.DeployerService.handleEvent(DeployerService.java:381) at jrunx.kernel.JRunServiceDeployer.fireEvent(JRunServiceDeployer.java:710) at jrunx.kernel.JRunServiceDeployer.deployServices(JRunServiceDeployer.java:111 ) at jrunx.kernel.DeploymentService.loadServices(DeploymentService.java:46) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523) at jrunx.kernel.JRun.startServer(JRun.java:575) at jrunx.kernel.JRun.init(JRun.java:493) at jrunx.kernel.JRun$1.run(JRun.java:346) at java.security.AccessController.doPrivileged(Native Method) at jrunx.kernel.JRun.start(JRun.java:343) at jrunx.kernel.JRun.startByNTService(JRun.java:427) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at jrunx.kernel.JRun.invoke(JRun.java:180) at jrunx.kernel.JRun.main(JRun.java:168) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265442 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX7- incompatibility with latest OSCache (open symphony)?
If you need the latest version for your apps, you might be better off loading that latest version with a class loader of some kind, rather than risking problems with CF (and loss of support from Adobe). On 1/1/07, Dov Katz [EMAIL PROTECTED] wrote: I am using OSCache for my app,and it seem CF is dependent on an older version of the library. (www.opensymphony.com http://www.opensymphony.com/ ) - Nothing really blows up, but I do see these errors in my log. Who in adobe can I contact to see if they can patch CF to use the latest API? -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX7- incompatibility with latest OSCache (open symphony)?
Is this nothining more than using the classpath as defined in the CF Admin, or is there something I'm missing. With tomcat, this type of thing is easy, but I'm not sure where in the CF admin / server architecture I could designate certain libs to be loaded for access by my apps... TIA dov If you need the latest version for your apps, you might be better off loading that latest version with a class loader of some kind, rather than risking problems with CF (and loss of support from Adobe). On 1/1/07, Dov Katz [EMAIL PROTECTED] wrote: I am using OSCache for my app,and it seem CF is dependent on an older version of the library. (www.opensymphony.com http://www.opensymphony.com/ ) - Nothing really blows up, but I do see these errors in my log. Who in adobe can I contact to see if they can patch CF to use the latest API? -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX7- incompatibility with latest OSCache (open symphony)?
You need to use a trick like this: http://www.compoundtheory.com/?action=javaloader.index or this: http://www.spike.org.uk/blog/index.cfm?do=blog.entryentry=B49509DF-D565-E33F-31C9E574EA1591EE On 1/1/07, Dov Katz [EMAIL PROTECTED] wrote: Is this nothining more than using the classpath as defined in the CF Admin, or is there something I'm missing. With tomcat, this type of thing is easy, but I'm not sure where in the CF admin / server architecture I could designate certain libs to be loaded for access by my apps... -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265445 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4