Re: Frameworks: Post vs. Get
Matt Quackenbush wrote: I should have clarified my question. I completely realize that the 'form' and 'url' scopes (structs) still exist inside the various frameworks, so I know that I can directly reference them. However, in an OO world, you're technically not supposed to reference outside scopes. That is not specific to an OO world, you shouldn't do that in procedural code either. Is it okay to directly reference the form scope in my OO-like controllers? Or is there another way for me to guarantee that the variable is a post vs. get? Since the answer to both questions is No I will add a third question: How important is it *really* to know the variable came from a post? Jochem ~| 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:291076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Check File For Change
Robert Rawlins - Think Blue wrote: Now, I'm looking for a method to ensure that the file has not been modified on the file system since the user uploaded it, the chances of it being modified are exceptionally slim, I know, but the consequences of it having happened are quite serious, so I need to be sure. I'm thinking about implementing some form of MD5 check sum on the files, this sum will be saved to the database when the file is uploaded, and checked against a newly generated checksum before the file is served back to the user again. Does that sounds like a fair concept? How are you going to guarantee the person that changes the file doesn't change the registered hash too? Jochem ~| 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:291077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
AES decryption problem
Hi all, I have a token that is being passed in via the URL, that is generated in a .NET program. I am having trouble decoding it in CF 8 so I was hoping that someone could give me a hand. I am very frustrated with this as this is my first dive into AES. The .NET developer gave me the following instructions: These are the steps needed to return the key in the email back to it's original state 1. URLDecode the key 2. Convert result to decoded base64 binary 3. Remove chr(0) from end of string 4. Decrypt from AES192 (requires a 24 character Key). Hence make sure you pad the hash key with spaces at the end up to 24 characters And here is what I have code wise now (I changed the key to keep it private): cfoutput !--- comes in via URL --- cfset forDec=OTg4MTc6NjcmOEpoXmRXRWY0JSVHWUcqb2xpa3VqZGxveHRvbkByZWQ1LmNvbS5hdQ%3D%3D !--- padded with spaces to make 24 chars --- cfset key=7KSK^8SID br /#forDec# !--- 1. URLDecode the key --- cfset forDec = URLDecode(forDec) br /#forDec# !--- 2. Convert result to decoded base64 binary --- cfset forDec = BinaryDecode(forDec,base64) !--- we now have binary object --- cfdump var=#forDec# !---3. Remove chr(0) from end of string --- !--- I cant put a trim on to a binary object, nor can I do a ReplacenoCase() --- !---4. Decrypt from AES192 (requires a 24 character Key). Hence make sure you pad the hash key with spaces at the end up to 24 characters--- cfset key = Decrypt(forDec,key,AES,base64) /cfoutput This results in a bytearray cannot be converted to strings error. So I tried forDec.toString(), but every request this generates a different value - how can this be? cfset key = Decrypt(BinaryEncode(forDec,base64),BinaryDecode(key,base64),AES,base64) Results in getting an error that The input and output encodings are not same. I am at a loss and tearing my hair out - can anyone help me out here??? -- Duncan I Loxton [EMAIL PROTECTED] ~| 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:291078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Frameworks: Post vs. Get
How is the value being used in the said object? To remain OO, the value should be supplied through a method, if it is to be set when the object is initiated, then the value should be supplied as an argument to the constructor. To make sure the argument is a post variable, you simply call the appropriate object method and pass 'form.myVar' to it. Referencing the post scope inside an object is, as you pointed out, opposed to OO priniciples, so do it outside the object and then behave accordingly. Dom On 15/10/2007, Jochem van Dieten [EMAIL PROTECTED] wrote: Matt Quackenbush wrote: I should have clarified my question. I completely realize that the 'form' and 'url' scopes (structs) still exist inside the various frameworks, so I know that I can directly reference them. However, in an OO world, you're technically not supposed to reference outside scopes. That is not specific to an OO world, you shouldn't do that in procedural code either. Is it okay to directly reference the form scope in my OO-like controllers? Or is there another way for me to guarantee that the variable is a post vs. get? Since the answer to both questions is No I will add a third question: How important is it *really* to know the variable came from a post? Jochem ~| ColdFusion 8 - 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:291080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Frameworks: Post vs. Get
On 10/14/07, Dave Watts [EMAIL PROTECTED] wrote: Data changes should not be triggered by GET requests. Whilst I agree and that guides whether I use GET or POST within my UI (and it's OK to use method=get on forms if they are query-only forms such as searches), I would question whether it's really important *inside* your application code to distinguish between GET and POST. Question to Dave: do your applications actually verify that any data changing requests really use POST? Suggestion to Matt et al: since all you really need to ensure is that certain requests came from a POST, you can write a filter (or whatever equivalent your framework de jour supports) that checks the request was a POST and encapsulate the logic in that one place (testing CGI.HTTP_METHOD). Then for a data changing request, just add that filter and you're done. Fusebox example: in prefuseaction on your controller circuit, check the fuseaction against a list of must use POST fuseactions and check the CGI variable: set name=dataChangingActions value=doupdate,dosomething / if condition=listFindNoCase(dataChangingActions,myFusebox.originalFuseaction) true if condition=CGI.HTTP_METHOD is 'POST' false !-- illegal GET -- /false /if /true /if -- 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:291079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT Sys-con at it again
On Friday 12 Oct 2007, [EMAIL PROTECTED] wrote: print (can they?). shouldn't there be some sort of system in place whereby somebody can say, hey sys-con... produce me one (just ONE) person in the CF community that feels that Adobe's destruction of CF started by pulling the plug on CFDJ. Libel/Slander. Adobe probably don't want to go to caught over it though, do they ? -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! 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 Solicitors Regulation Authority. 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. ~| 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:291083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Concat Issue
It is early and my brain my not be functioning 100% but may need to add a GROUP BY for the HAVING to function on some DBs. On 10/15/07, James Smith [EMAIL PROTECTED] wrote: With some DB's moving your criteria from the WHERE clause to the HAVING clause will take care of it since HAVING is evaluated after the results have been calculated... sometimes... -- Jay -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 October 2007 00:01 To: CF-Talk Subject: SQL Concat Issue I am probably being dense or showing my ignorance here, but I have a legacy database that I need to run a query on like the following. Can anyone tell me how I can achieve the following. Right now I am getting an error that PubYear is not a valid column. Thank you! SELECT AdINFO_Publication, ADINFO_PUBLICATIONDATE_YEAR+ '-' + ADINFO_PUBLICATIONDATE_MONTH + '-01' AS PubYear FROMcrAdInfo AND PubYear BETWEEN #dateformat(startdate,-mm-dd)# AND #dateformat(enddate,-mm-dd)# Any Help is appreciated. Thanks! ~| 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:291082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Concat Issue
With some DB's moving your criteria from the WHERE clause to the HAVING clause will take care of it since HAVING is evaluated after the results have been calculated... sometimes... -- Jay -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 October 2007 00:01 To: CF-Talk Subject: SQL Concat Issue I am probably being dense or showing my ignorance here, but I have a legacy database that I need to run a query on like the following. Can anyone tell me how I can achieve the following. Right now I am getting an error that PubYear is not a valid column. Thank you! SELECT AdINFO_Publication, ADINFO_PUBLICATIONDATE_YEAR+ '-' + ADINFO_PUBLICATIONDATE_MONTH + '-01' AS PubYear FROMcrAdInfo AND PubYear BETWEEN #dateformat(startdate,-mm-dd)# AND #dateformat(enddate,-mm-dd)# Any Help is appreciated. Thanks! ~| 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:291081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: connectstring in CF8
On Sunday 14 Oct 2007, [EMAIL PROTECTED] wrote: It's odd because I've been using jruby lately which uses jdbc connections and it allows you to dynamically set your datasources all day long. It's one feature of CF5 that I really miss. You can use the AdminAPI CFC's to do this in CF8, maybe 7 too. -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! 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 Solicitors Regulation Authority. 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 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:291084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why would this query not return the correct data?
That's the actual sql... a simple statement. Now this is strange... I ran a little test. I changed the event_day data directly in the database from 1,1,1,3,4,6 or whatever it was and added one to each digit and made the event_day data 2,2,2,4,5,7. This data is in a MySQL db with a field type of tiny integer. (I then convert this into a day_of_week using MySQL) Anyway, when I run the same query in the MySQL editor, I get the expected results, 2,4,5,7. However, when I run the query via a cf page using... cfquery name=get_days datasource=his_anointing select distinct event_day from weekly_schedule order by event_day /cfquery cfloop query=get_days cfoutput#get_days.event_day#/cfoutputbr / /cfloop cfdump var=#get_days# I still get 1,1,1,1 from both the looped output and the cfdump. I even went back and changed the text color on the page to make sure I'm running the correct page in the browser. It's the right one, because the text color is now red. I changed the database table data and changed one of the 2's to a 3 to see if the output and cfdump changed to make sure I'm running the query on the same database in both places... yep, now the output from the editor reads 2,3,4,5,7, but the query output and cfdump reads 1,1,1,1,1. It just added another 1 to the original 4 1's. So the 1's can't be representing the data; there are no 1's in the table now. It's as if it's stuck on a rowcount of 1 or something; or perhaps...no it couldn't be...a value of 1. But that wouldn't make any sense. Is it a variable type (tinyint) problem? I don't see why a variable type of tinyint wouldn't work. I just need to store numbers 1-7 to convert to a day of the week. Which worked fine in MySQL 4.1 and CF 4.5. ??? Rick -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 10:17 PM To: CF-Talk Subject: Re: Why would this query not return the correct data? is this select distinct event_day from weekly_schedule order by event_day your actual sql statement, or just a 'simplified' version for the mailing list? ~| 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:291085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Frameworks: Post vs. Get
Question to Dave: do your applications actually verify that any data changing requests really use POST? Hell yeah! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:291086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: connectstring in CF8
Be forewarned that this would be very bad form to do if you're on a shared host. Unless, of course, you have permission to do so from your system administrator. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| 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:291087 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Why would this query not return the correct data?
now that IS strange... is there some query caching involved??? i have even reproduced your table and query on my CF8/MySQL5 setup, and it returns correct data... does your cfdump still return 1,1,1,1 ??? did you try running: cfoutput query=get_days #get_days.event_day#br/ /cfoutput (no cfloop) Azadi Rick Faircloth wrote: That's the actual sql... a simple statement. Now this is strange... I ran a little test. I changed the event_day data directly in the database from 1,1,1,3,4,6 or whatever it was and added one to each digit and made the event_day data 2,2,2,4,5,7. This data is in a MySQL db with a field type of tiny integer. (I then convert this into a day_of_week using MySQL) Anyway, when I run the same query in the MySQL editor, I get the expected results, 2,4,5,7. However, when I run the query via a cf page using... cfquery name=get_days datasource=his_anointing select distinct event_day from weekly_schedule order by event_day /cfquery cfloop query=get_days cfoutput#get_days.event_day#/cfoutputbr / /cfloop cfdump var=#get_days# I still get 1,1,1,1 from both the looped output and the cfdump. I even went back and changed the text color on the page to make sure I'm running the correct page in the browser. It's the right one, because the text color is now red. I changed the database table data and changed one of the 2's to a 3 to see if the output and cfdump changed to make sure I'm running the query on the same database in both places... yep, now the output from the editor reads 2,3,4,5,7, but the query output and cfdump reads 1,1,1,1,1. It just added another 1 to the original 4 1's. So the 1's can't be representing the data; there are no 1's in the table now. It's as if it's stuck on a rowcount of 1 or something; or perhaps...no it couldn't be...a value of 1. But that wouldn't make any sense. Is it a variable type (tinyint) problem? I don't see why a variable type of tinyint wouldn't work. I just need to store numbers 1-7 to convert to a day of the week. Which worked fine in MySQL 4.1 and CF 4.5. ??? Rick -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 10:17 PM To: CF-Talk Subject: Re: Why would this query not return the correct data? is this select distinct event_day from weekly_schedule order by event_day your actual sql statement, or just a 'simplified' version for the mailing list? ~| 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:291089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Why would this query not return the correct data?
Rick, This might sound really, really stupid... but is your datasource pointing to the a different version of your database? Also, make sure that caching is turned off within the admin for things like class files. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| 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:291088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Why would this query not return the correct data?
I know this does not solve the actual problem but if all you need to do is convert 1-7 to the day of the week you could just make a query result using the QueryNew() function and avoid querying the database altogether. Are you 100% sure this is the only query in the site returning incorrect data? On 10/15/07, Rick Faircloth [EMAIL PROTECTED] wrote: numbers 1-7 to convert to a day of the week. Which worked fine in MySQL 4.1 and CF 4.5. -- Aaron Rouse http://www.happyhacker.com/ ~| ColdFusion 8 - 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:291091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CPU spiking, possible bad loop or conditional statement
All, Can anyone recommend a server monitoring tools for a CF MX install that all of a sudden is creating the CPU to spike and the CF server is maxing out? Thanks for any direction. D ~| ColdFusion 8 - 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:291090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why would this query not return the correct data?
I doubt it would make any difference, if the cfdump has the wrong values then the problem would be outside of how he is looping over the query and referencing the values. On 10/15/07, Azadi Saryev [EMAIL PROTECTED] wrote: now that IS strange... is there some query caching involved??? i have even reproduced your table and query on my CF8/MySQL5 setup, and it returns correct data... does your cfdump still return 1,1,1,1 ??? did you try running: cfoutput query=get_days #get_days.event_day#br/ /cfoutput (no cfloop) Azadi -- Aaron Rouse http://www.happyhacker.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:291092 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why would this query not return the correct data?
Could CF8 be converting the Tiny Integer type to say a bit/boolean type? Could you quickly test using an equivalent table but use integer instead of tiny integer? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 8:02 AM To: CF-Talk Subject: RE: Why would this query not return the correct data? That's the actual sql... a simple statement. Now this is strange... I ran a little test. I changed the event_day data directly in the database from 1,1,1,3,4,6 or whatever it was and added one to each digit and made the event_day data 2,2,2,4,5,7. This data is in a MySQL db with a field type of tiny integer. (I then convert this into a day_of_week using MySQL) Anyway, when I run the same query in the MySQL editor, I get the expected results, 2,4,5,7. However, when I run the query via a cf page using... cfquery name=get_days datasource=his_anointing select distinct event_day from weekly_schedule order by event_day /cfquery cfloop query=get_days cfoutput#get_days.event_day#/cfoutputbr / /cfloop cfdump var=#get_days# .I still get 1,1,1,1 from both the looped output and the cfdump. I even went back and changed the text color on the page to make sure I'm running the correct page in the browser. It's the right one, because the text color is now red. I changed the database table data and changed one of the 2's to a 3 to see if the output and cfdump changed to make sure I'm running the query on the same database in both places... yep, now the output from the editor reads 2,3,4,5,7, but the query output and cfdump reads 1,1,1,1,1. It just added another 1 to the original 4 1's. So the 1's can't be representing the data; there are no 1's in the table now. It's as if it's stuck on a rowcount of 1 or something; or perhaps...no it couldn't be...a value of 1. But that wouldn't make any sense. Is it a variable type (tinyint) problem? I don't see why a variable type of tinyint wouldn't work. I just need to store numbers 1-7 to convert to a day of the week. Which worked fine in MySQL 4.1 and CF 4.5. ??? Rick -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 10:17 PM To: CF-Talk Subject: Re: Why would this query not return the correct data? is this select distinct event_day from weekly_schedule order by event_day your actual sql statement, or just a 'simplified' version for the mailing list? ~| ColdFusion 8 - 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:291094 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Frameworks: Post vs. Get
I'm aware of this rule, it just doesn't make any sense to me. In fact, if adhered to it would add a good bit of complexity to otherwise simple apps. I've seen the Rails folks obsessing about this, where they are forcing some normal URLs to be POST, and likewise forcing some forms to be GET, for no benefit at all other than to obey this seemingly pointless rule. On 10/14/07, Dave Watts [EMAIL PROTECTED] wrote: I suppose I don't understand why you'd care if the variable came from a form field as opposed to a URL variable. Either way you're going to have to make sure the user is an admin and they they have the rights to delete something. Data changes should not be triggered by GET requests. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:291093 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Frameworks: Post vs. Get
I'm with Brian here - I don't see why this is critical. The only known cause of a problem in this area (that I know of) is when the Google Accelrator came out and it began auto firing Delete links in web admins. Any program that automatically follows links can cause this problem, as long as it has credentials to access the URLs in question. Google Web Accelerator was simply one example. Google Search Appliances are another. Rather than worrying about these programs, you can simply avoid the problem altogether by conforming to the appropriate RFC recommendation: http://www.w3.org/Protocols/rfc2616/rfc2616-sec9.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:291096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Frameworks: Post vs. Get
I'm with Brian here - I don't see why this is critical. The only known cause of a problem in this area (that I know of) is when the Google Accelrator came out and it began auto firing Delete links in web admins. On 10/15/07, Brian Kotek [EMAIL PROTECTED] wrote: I'm aware of this rule, it just doesn't make any sense to me. In fact, if adhered to it would add a good bit of complexity to otherwise simple apps. I've seen the Rails folks obsessing about this, where they are forcing some normal URLs to be POST, and likewise forcing some forms to be GET, for no benefit at all other than to obey this seemingly pointless rule. -- === Raymond Camden, Camden Media Email: [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| 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:291095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Frameworks: Post vs. Get
I'm aware of this rule, it just doesn't make any sense to me. In fact, if adhered to it would add a good bit of complexity to otherwise simple apps. I've seen the Rails folks obsessing about this, where they are forcing some normal URLs to be POST, and likewise forcing some forms to be GET, for no benefit at all other than to obey this seemingly pointless rule. Crawlers submit GET requests, but not POST requests. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:291097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Is This Possible??
Hi Kris, First I would like to thank you for responding to my post, it is greatly appreciated. I will try to answer your questions in the order you presented them. Q1 - The ultimate goal of this project is to display a listing of the annual training calendar and show what training a given employee has and has not completed from that list. Q2 - Whether this can be accomplished with a single query or multiple queries, makes no difference to me. Q3 - Expected output would be something along the lines of this row 1: trng_code --- trng_title --- completed row 2: trng_code --- trng_title --- not completed row 3: trng_code --- trng_title --- completed and so forth running the through the table containing the annual training event information. Q4 - Not sure what you are looking for with this question. Q5 - Table structure tbl_personnel --- record_id = key --- first_name (varchar) --- last_name (varchar) --- emp_id varchar tbl_training_calendar --- record_id = key --- trng_code (varchar) --- trng_title (varchar) tbl_training_completed --- record_id = key --- trng_code (varchar) --- emp_id (varchar) --- trng_status (varchar) With my current thinking process, the only time there would information entered into the tbl_training_completed table, would be when the individual actually completed said training. This I am having no problems with query and displaying. However, the issue I am having problems with is, determining what training of the scheduled training the individual has not done so I can include it in the same display / output in the layout described in Q3. The more I ponder on the scenario, the more I am becoming convinced it cannot be accomplished without pre-loading the trng_status field of the tbl_training_completed table with 'not completed' or NULL and query/evaluate against that. With there being 63 individuals and about 75 different training elements, pre-loading does not look pleasant. I am certainly open to suggestions on easier / more effective ways to accomplish this. I can do messengers as well as offer a virtual meeting session, if this would make reaching a solution easier. Thanks in advance, I hope I answered your questions. Leonard ~| ColdFusion 8 - 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:291098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is This Possible??
Hi Kris, First I would like to thank you for responding to my post, it is greatly appreciated. I will try to answer your questions in the order you presented them. Q1 - The ultimate goal of this project is to display a listing of the annual training calendar and show what training a given employee has and has not completed from that list. Q2 - Whether this can be accomplished with a single query or multiple queries, makes no difference to me. Q3 - Expected output would be something along the lines of this row 1: trng_code --- trng_title --- completed row 2: trng_code --- trng_title --- not completed row 3: trng_code --- trng_title --- completed and so forth running the through the table containing the annual training event information. Q4 - Not sure what you are looking for with this question. Q5 - Table structure tbl_personnel --- record_id = key --- first_name (varchar) --- last_name (varchar) --- emp_id varchar tbl_training_calendar --- record_id = key --- trng_code (varchar) --- trng_title (varchar) tbl_training_completed --- record_id = key --- trng_code (varchar) --- emp_id (varchar) --- trng_status (varchar) With my current thinking process, the only time there would information entered into the tbl_training_completed table, would be when the individual actually completed said training. This I am having no problems with query and displaying. However, the issue I am having problems with is, determining what training of the scheduled training the individual has not done so I can include it in the same display / output in the layout described in Q3. The more I ponder on the scenario, the more I am becoming convinced it cannot be accomplished without pre-loading the trng_status field of the tbl_training_completed table with 'not completed' or NULL and query/evaluate against that. With there being 63 individuals and about 75 different training elements, pre-loading does not look pleasant. I am certainly open to suggestions on easier / more effective ways to accomplish this. I can do messengers as well as offer a virtual meeting session, if this would make reaching a solution easier. Thanks in advance, I hope I answered your questions. Leonard ~| 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:291100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Is This Possible??
Hi Kris, First I would like to thank you for responding to my post, it is greatly appreciated. I will try to answer your questions in the order you presented them. Q1 - The ultimate goal of this project is to display a listing of the annual training calendar and show what training a given employee has and has not completed from that list. Q2 - Whether this can be accomplished with a single query or multiple queries, makes no difference to me. Q3 - Expected output would be something along the lines of this row 1: trng_code --- trng_title --- completed row 2: trng_code --- trng_title --- not completed row 3: trng_code --- trng_title --- completed and so forth running the through the table containing the annual training event information. Q4 - Not sure what you are looking for with this question. Q5 - Table structure tbl_personnel --- record_id = key --- first_name (varchar) --- last_name (varchar) --- emp_id varchar tbl_training_calendar --- record_id = key --- trng_code (varchar) --- trng_title (varchar) tbl_training_completed --- record_id = key --- trng_code (varchar) --- emp_id (varchar) --- trng_status (varchar) With my current thinking process, the only time there would information entered into the tbl_training_completed table, would be when the individual actually completed said training. This I am having no problems with query and displaying. However, the issue I am having problems with is, determining what training of the scheduled training the individual has not done so I can include it in the same display / output in the layout described in Q3. The more I ponder on the scenario, the more I am becoming convinced it cannot be accomplished without pre-loading the trng_status field of the tbl_training_completed table with 'not completed' or NULL and query/evaluate against that. With there being 63 individuals and about 75 different training elements, pre-loading does not look pleasant. I am certainly open to suggestions on easier / more effective ways to accomplish this. I can do messengers as well as offer a virtual meeting session, if this would make reaching a solution easier. Thanks in advance, I hope I answered your questions. Leonard ~| 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:291099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excel, POI, and HTML Tables (was Re: Memory Issue)
On 10/12/07, Russ [EMAIL PROTECTED] wrote: Well you do realize that whenever you use strings, and you modify it, a brand new string has to be created, since Strings in java are immutable. You should use some java code and use something like StingBuffer instead to build out your string. This should help with memory utilization. Russ, I'm aware of that, which is exactly why I asked if they had any plans to improve string handling in coldfusion - perhaps NOT To use java strings, but string buffers instead. Take a look at this thread: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:53814 Rick -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.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:291101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
forwarding a session url in an included template
Hi everybody need help on how i could forward a url session variable in an included template I have two files first is index.cfm the main page and header.cfm the included page I have a page home.cfm which calls index.cfm my code is this on the index.cfm cfif IsDefined(URL.Language) cfset Session.Language=URL.Language /cfif cfif NOT IsDefined(Session.Language) cfset Session.Language=1 /cfif outputting session.language on a cfdump on the index.cfm page outputs ok but not on the header.cfm page... which also i tried transferring the code to header.cfm thanks alex ~| 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:291102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Is This Possible??
What you are looking for here is an outer join. An outer join says select all the records from one table and any records from a second table, if they match. If there is no match the column from the second table it will contain a NULL value. Thus your employees who have not completed a specific training will have a null value for that training record. ~| 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:291103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: open source eCommerce application
Nick, The first sentence on cfCommerce.org says, cfCommerce aims to be an Open Source based online shop e-commerce solution. do you mean, ... Open Source ColdFusion based...? Chris On 10/14/07, Nick Tong [EMAIL PROTECTED] wrote: Hi all, I've started the ball rolling on getting a eCommerce solution developed - more information here: http://www.succor.co.uk/index.cfm/2007/10/14/cfCommerceorg--a-free-coldfusion-eCommerce-solution Please post any thoughts on the blog post - many thanks. Nick -- Nick Tong web: http://talkwebsolutions.co.uk blog: http://succor.co.uk f..works:http://cfframeworks.com short urls: http://wapurl.co.uk green link: http://wapurl.co.uk/?4Z2YDLX ~| 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:291104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Frameworks: Post vs. Get
While I am not religious about it, if you see any url as a potential REST webservice, separating GET and POST make sense. Of course this apply much more to public facing urls, les to password protected ones. Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.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:291105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
pinging
I'm kind of a newbie on all the features of CF. Is there a CF command that can run a command line (DOS) ping command ? I familiar with commands such as cfhttp, etc, but have not seen one for dos-based entries. Thanks. Robert O. HWW ~| ColdFusion 8 - 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:291107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Frameworks: Post vs. Get
Brian Kotek wrote: I'm aware of this rule, it just doesn't make any sense to me. In fact, if adhered to it would add a good bit of complexity to otherwise simple apps. I don't believe it adds complexity for the developer. Have you ever seen that popup that says: The page you are trying to view contains POSTDATA. If you resend the data, any action the form carried out (such as a search or online purchase) will be repeated. To resend the data, click OK. Otherwise, click Cancel. Have you ever tried coding something like that throughout your entire application? How much complexity did that add compared to just using the proper HTTP method and let the browser take care of warning the user? Not to mention the usability gains in using GET where appropriate and *not* confronting the user with this popup on pages that don't make changes. Jochem ~| 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:291106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Frameworks: Post vs. Get
That's fine, but it doesn't change anything in my mind. Just because a crawler won't submit a form doesn't mean that a user (or a non-compliant crawler) won't. It's also not complicated for a user to modify the headers to issue a post instead of a get or vice versa. The point being, if you have something that can trigger a data change, you have to assume someone can execute it regardless of whether it is a POST or a GET and regardless of whether it was initiated by a crawler or something else. It's far more critical in my mind to make sure that only people or agents that you want to be changing data can actually change the data. The triviality of whether the request was a POST or a GET seems to mean nothing. I think that forcing data change requests to be POSTS is just forcing an extra limitation on the usefulness of the application (I personally think being able to do something via a form post as well as a simple URL GET request is a very handy thing), when you're still going to have to have the proper logic in place to make sure the data change is valid in the first place. I suppose the summary here is that I know this rule exists, and I know why it exists. It just doesn't seem to have any real bearing on anything other than to add complexity while at the same time reducing flexibility. To me, it smacks of a carryover from the early days of the web that doesn't mean much in the current environment. On 10/15/07, Dave Watts [EMAIL PROTECTED] wrote: I'm aware of this rule, it just doesn't make any sense to me. In fact, if adhered to it would add a good bit of complexity to otherwise simple apps. I've seen the Rails folks obsessing about this, where they are forcing some normal URLs to be POST, and likewise forcing some forms to be GET, for no benefit at all other than to obey this seemingly pointless rule. Crawlers submit GET requests, but not POST requests. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| ColdFusion 8 - 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:291108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check File For Change
How are you going to guarantee the person that changes the file doesn't change the registered hash too? Easy: don't put the registered hash in the edit form. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| ColdFusion 8 - 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:29 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Frameworks: Post vs. Get
Sean Corfield wrote: Suggestion to Matt et al: since all you really need to ensure is that certain requests came from a POST, you can write a filter (or whatever equivalent your framework de jour supports) that checks the request was a POST and encapsulate the logic in that one place (testing CGI.HTTP_METHOD). That only checks the request method, not whether individual variables came from the URL or the Form scopes (yes, a request can have both form and URL variables at the same time). Jochem ~| 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:291110 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: pinging
cfexecute... ~| 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:291109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why would this query not return the correct data?
Could CF8 be converting the Tiny Integer type to say a bit/boolean type? I was thinking about this, but in this case, all even values would converted to zeros, not ones -- ___ 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 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:291114 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Frameworks: Post vs. Get
You're proving my point. Going through your app and changing any A HREF tag that targets a link that changes data on the server to use POST instead of GET *is* an increase in complexity. And, if I understand you correctly, you're doing it just to get a pop-up window from your browser? A pop up that anyone can ignore, or that a spider can just bypass anyway? When under the hood you're still going to have to have logic to make sure the user is logged in, and editing data that they are allowed to edit, etc.? Is this really the best reason someone can offer to justify making all data-editing URLs use the POST method? I know it isn't anyone's job here to convince me, and that I'm the one ignoring this rule, but so far I'm still not seeing any particularly compelling reason to be concerned. On 10/15/07, Jochem van Dieten [EMAIL PROTECTED] wrote: Brian Kotek wrote: I'm aware of this rule, it just doesn't make any sense to me. In fact, if adhered to it would add a good bit of complexity to otherwise simple apps. I don't believe it adds complexity for the developer. Have you ever seen that popup that says: The page you are trying to view contains POSTDATA. If you resend the data, any action the form carried out (such as a search or online purchase) will be repeated. To resend the data, click OK. Otherwise, click Cancel. Have you ever tried coding something like that throughout your entire application? How much complexity did that add compared to just using the proper HTTP method and let the browser take care of warning the user? Not to mention the usability gains in using GET where appropriate and *not* confronting the user with this popup on pages that don't make changes. Jochem ~| 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:291112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Encrypted String - SQL Field Length
On Sunday 14 Oct 2007, [EMAIL PROTECTED] wrote: in my tables, is this easy to predict? Does AES encryption give me a regular string length regardless of that of the original string? I *imagine* it'll be rounded up to the next block size. -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! 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 Solicitors Regulation Authority. 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. ~| 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:291113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: forwarding a session url in an included template
On Monday 15 Oct 2007, [EMAIL PROTECTED] wrote: outputting session.language on a cfdump on the index.cfm page outputs ok but not on the header.cfm page... which also i tried transferring the code to header.cfm Is the session scope enabled in Application.cfm/Application.cfc ? -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! 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 Solicitors Regulation Authority. 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. ~| 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:291116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Why would this query not return the correct data?
@ Azadi: The cfdump reports no query caching. Even after I manually changed the data in the database to exclude the integer 1, I still get all 1's ! What datatype did you assign to event_day? If it was tinyint, did you give it a length of 1? @ Matthew: I changed two things to make sure I wasn't accessing the wrong database or cfm page. I change the text to red and that worked. I also changed the integers for event_day I the database and they editor query returns the new and correct information. CFDump reports no query caching. @ Aaron: I haven't checked the rest of the site for errors explicitly, but I haven't noticed any problems yet. I'll expand the error search soon if this isn't resolved. @ Aaron: Yes, the cfdump shows consistent data. I get same wrong result whether I cfoutput the query or loop the query. @ Andrew: Your theory could be correct about the bit/Boolean datatype. I had assigned a tinyint datatype with a length of 1. Which would fit the definition for a Boolean and also my single digit day of the week number requirements. However, when I changed the datatype to integer and allowed it to have its full length of 11, I got back the correct results from my query, the cfdump, and sql editor's query. So the issue seems to be solved... but the question remains: Why did my datatype and length no work? Just wanted to say THANKS! to everyone who has helped solve this. Now I really want to understand this behavior so I don't run into unexpected problems in the future. Ideas? Rick -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 8:56 AM To: CF-Talk Subject: Re: Why would this query not return the correct data? now that IS strange... is there some query caching involved??? i have even reproduced your table and query on my CF8/MySQL5 setup, and it returns correct data... does your cfdump still return 1,1,1,1 ??? did you try running: cfoutput query=get_days #get_days.event_day#br/ /cfoutput (no cfloop) Azadi ~| 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:291115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Is This Possible??
Hi Leonard, Something along the lines of this may work. I'm sure you'll need to tweak it a bit depending on your RDBMS and other requirements. SELECT t.trng_code, t.trng_title, c.trng_status FROM tbl_training_calendar t LEFT OUTER JOIN tbl_training_completed c ON c.trng_code=t.trng_code INNER JOIN tbl_personnel p ON p.emp_id=c.emp_id ORDER BY t.trng_code Pretty sure that will work, but I know that when I use short-hand join notation it will fail because of the inner reference to an outer joined element. Formal join notation usually works. However, that query gives you ALL employees, and I don't think you can reliably limit the query to the currently logged-in employee when using an element in an OUTER reference. You could use a subquery instead, which would allow you to specify a unique employee: SELECT t.trng_code, t.trng_title, (SELECT c.trng_status FROM tbl_training_completed WHERE c.trng_code=t.trng_code AND c.emp_id=[currently_logged_in_employee_id]) as training_status FROM FROM tbl_training_calendar t ORDER BY t.trng_code But here's a question: if they are only holding training that have been completed in the tbl_training_completed table, why the trng_status column? Maybe the assumption that the table only holds completed trainings is not correct? That would certainly simplify things a bit. Cheers, Kris ~| 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:291117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cferror wont fire on syntax problems
I have the following catch-all cferror in place on my application.cfm: cferror type=EXCEPTION exception=any template=/error/index.cfm mailto=[EMAIL PROTECTED] cferror type=REQUEST template=/error/index.cfm mailto=[EMAIL PROTECTED] However, If I run my test page with a bad cf syntax cfoutput#now(#/cfoutput, it still displays the default error display thrown by CF, and not my specified template. Any ideas, suggestions 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:291118 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Why would this query not return the correct data?
It could be more simple... All non-zero values are true. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 10:57 AM To: CF-Talk Subject: Re: Why would this query not return the correct data? Could CF8 be converting the Tiny Integer type to say a bit/boolean type? I was thinking about this, but in this case, all even values would converted to zeros, not ones -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:291119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: column totals
I don't know about actual cycle efficiency, but arraysum(query['row']) is what I use. Very good on typing efficiency. :-) --Ben Doom Toby King wrote: Hi there I have an application where I am outputing a number of sales figures for a year for various departments. Basically the table that I am outputing is in this format: Dept July Aug SepOctNov DecTotal A 23 24 20 18 15 50 150 B 20 20 20 20 20 20 120 C 10 10 10 10 10 10 60 Total xxx xxx xxx xxx xxx xxx xxx Basically I have not had any trouble creating the total for the end of the row - I have created an array and just added to the array and then I get the total. I am struggling with obtaining the total for the bottom of the columns. What would be the most efficient way to do this. Thanks in advance. ~| 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:291120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: column totals
I would move this total logic to the actual query i.e. SQL which will be the most efficient IMHO. HTH Qasim On 10/15/07, Ben Doom [EMAIL PROTECTED] wrote: I don't know about actual cycle efficiency, but arraysum(query['row']) is what I use. Very good on typing efficiency. :-) --Ben Doom Toby King wrote: Hi there I have an application where I am outputing a number of sales figures for a year for various departments. Basically the table that I am outputing is in this format: Dept July Aug SepOctNov DecTotal A 23 24 20 18 15 50 150 B 20 20 20 20 20 20 120 C 10 10 10 10 10 10 60 Total xxx xxx xxx xxx xxx xxx xxx Basically I have not had any trouble creating the total for the end of the row - I have created an array and just added to the array and then I get the total. I am struggling with obtaining the total for the bottom of the columns. What would be the most efficient way to do this. Thanks in advance. ~| 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:291122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Frameworks: Post vs. Get
Brian Kotek wrote: You're proving my point. Going through your app and changing any A HREF tag that targets a link that changes data on the server to use POST instead of GET *is* an increase in complexity. And, if I understand you correctly, you're doing it just to get a pop-up window from your browser? A pop up that anyone can ignore, or that a spider can just bypass anyway? When under the hood you're still going to have to have logic to make sure the user is logged in, and editing data that they are allowed to edit, etc.? I don't retrofit existing sites just for the sake of getting this correct, but if I develop something new it is the guiding principle. And it saves me the why do I get billed twice for this report questions from users that are logged in and have the right to order something. And the part you glossed over is that I change forms from post to get if they do not change the data. Because it provides a better user experience if the browser does not come with that annoying popup. Is this really the best reason someone can offer to justify making all data-editing URLs use the POST method? I know it isn't anyone's job here to convince me, and that I'm the one ignoring this rule, but so far I'm still not seeing any particularly compelling reason to be concerned. Would you do it if it were easier? For a while now I have considered proposing to the W3 HTML standard committee to add a method attribute to the href tag so you could also make a normal link fire a post instead of a get. Jochem ~| 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:291121 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CPU spiking, possible bad loop or conditional statement
SeeFusion FusionReactor are the one that come to mind if you are looking for a server monitoring utility. HTH Qasim On 10/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: All, Can anyone recommend a server monitoring tools for a CF MX install that all of a sudden is creating the CPU to spike and the CF server is maxing out? Thanks for any direction. D ~| 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:291123 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cferror wont fire on syntax problems
I'm not sure what version of CF you're running, however if its 7+ then I would look at moving over to Application.cfc, its far more comprehensive in a great many ways. You can then use the onError() method to handle any exceptions thrown, it's quite a bit cleaner. Rob -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: 15 October 2007 16:25 To: CF-Talk Subject: cferror wont fire on syntax problems I have the following catch-all cferror in place on my application.cfm: cferror type=EXCEPTION exception=any template=/error/index.cfm mailto=[EMAIL PROTECTED] cferror type=REQUEST template=/error/index.cfm mailto=[EMAIL PROTECTED] However, If I run my test page with a bad cf syntax cfoutput#now(#/cfoutput, it still displays the default error display thrown by CF, and not my specified template. Any ideas, suggestions anyone? ~| 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:291124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CPU spiking, possible bad loop or conditional statement
It was a poorly written sql statement. Shame on me. All, Can anyone recommend a server monitoring tools for a CF MX install that all of a sudden is creating the CPU to spike and the CF server is maxing out? Thanks for any direction. D ~| 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:291125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Frameworks: Post vs. Get
I thought that the google web accelerator did all the convincing anyone needed. If I recall correctly, a lot of intranets had a problem with it in that lots of GET operations would alter data. The user would be logged in, and gwa would automatically fetch all GET links. There'd be no security concerns since deleting records would be a valid operation for a logged in user. On 10/15/07, Brian Kotek [EMAIL PROTECTED] wrote: You're proving my point. Going through your app and changing any A HREF tag that targets a link that changes data on the server to use POST instead of GET *is* an increase in complexity. And, if I understand you correctly, you're doing it just to get a pop-up window from your browser? A pop up that anyone can ignore, or that a spider can just bypass anyway? When under the hood you're still going to have to have logic to make sure the user is logged in, and editing data that they are allowed to edit, etc.? Is this really the best reason someone can offer to justify making all data-editing URLs use the POST method? I know it isn't anyone's job here to convince me, and that I'm the one ignoring this rule, but so far I'm still not seeing any particularly compelling reason to be concerned. On 10/15/07, Jochem van Dieten [EMAIL PROTECTED] wrote: Brian Kotek wrote: I'm aware of this rule, it just doesn't make any sense to me. In fact, if adhered to it would add a good bit of complexity to otherwise simple apps. I don't believe it adds complexity for the developer. Have you ever seen that popup that says: The page you are trying to view contains POSTDATA. If you resend the data, any action the form carried out (such as a search or online purchase) will be repeated. To resend the data, click OK. Otherwise, click Cancel. Have you ever tried coding something like that throughout your entire application? How much complexity did that add compared to just using the proper HTTP method and let the browser take care of warning the user? Not to mention the usability gains in using GET where appropriate and *not* confronting the user with this popup on pages that don't make changes. Jochem ~| 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:291126 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SiteObjects: No answer at all !
I switched over to FCKeditor after having a relatively simple question go unanswered for weeks. My guess is that they crawled under a rock and died. Pete On 10/14/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi list, does s.o. know what happened to the guys of: http://www.siteobjects.com/ ?? Nobody answers, when I send them an eMail. Besides their Support Forums are out of order for weeks now ! Uwe ~| ColdFusion 8 - 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:291127 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Frameworks: Post vs. Get
Brian Kotek wrote: That's fine, but it doesn't change anything in my mind. Just because a crawler won't submit a form doesn't mean that a user (or a non-compliant crawler) won't. It's also not complicated for a user to modify the headers to issue a post instead of a get or vice versa. The point being, if you have something that can trigger a data change, you have to assume someone can execute it regardless of whether it is a POST or a GET and regardless of whether it was initiated by a crawler or something else. It's far more critical in my mind to make sure that only people or agents that you want to be changing data can actually change the data. I fully agree. The triviality of whether the request was a POST or a GET seems to mean nothing. And here I disagree. After you have ensured that only authorized users and agents have access, using the correct method is important enough to get it right. Jochem ~| 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:291128 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Frameworks: Post vs. Get
Wowsers! Seems I hit on a hot topic. On 10/15/07, Jochem van Dieten wrote: Since the answer to both questions is No I will add a third question: How important is it *really* to know the variable came from a post? Jochem I don't allow data altering in my apps via a 'get', especially not deletes. Whether or not the user is authorized to alter said data, while obviously crucial, is not the only important thing; they must alter that data by following the correct protocols that the app has set in place, as Zaphod (and others) pointed out. Therefore, as far as I am concerned, it is extremely critical to know that these sort of variables came from a post. So, back to the root question at hand: Is it okay to directly reference the form scope in my OO-like controllers? I'm leaning toward the belief that it's okay to reference the form/post scope from within the controller, to verify that the data is from a post. (Sean's code example seems to bolster that belief.) At that point, the var(s) is/are passed off to the model where it does the heavy lifting. Inside the model, I completely and thoroughly agree with Brian - it doesn't matter where the variable(s) came from. Matt ~| 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:291129 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: pinging
Thanks! -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 10:47 AM To: CF-Talk Subject: Re: pinging cfexecute... ~| 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:291130 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Frameworks: Post vs. Get
Jochem van Dieten wrote: Would you do it if it were easier? For a while now I have considered proposing to the W3 HTML standard committee to add a method attribute to the href tag so you could also make a normal link fire a post instead of a get. Sorry, that should read 'to add a method attribute to every tag with a href attribute' (under the XHTML 2 proposal all tags could get a href attribute, not just anchors and stylesheets, and I hope they will put that in HTML 5 too). Jochem ~| ColdFusion 8 - 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:291131 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why would this query not return the correct data?
When accessing MySQL 5 from Java (i.e. when using JDBC) all TINYINT(1) fields are converted to Boolean values. Documented here: http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-type-conversions.html You can prevent this behavior by adding a Connection String to your ColdFusion datasource (in Advanced Settings): tinyInt1isBit=false This will cause the JDBC driver to treat TINYINT(1) the way you want it to - as tiny little integers instead of boolean true/false values. -tom- Rick Faircloth wrote: Hi, all. Here's the query: cfquery name=get_days datasource=#dsn# select distinct event_days from weekly schedule order by event_day /cfquery The data that should be returned if the query is looped is 1, 1, 1, 1, 2, 4, 6 However, when I run. cfloop query=get_days cfoutput#event_days#/cfoutput /cfloop .. all I get is 1, 1, 1, 1.four ones, and that's it. What could I be doing wrong? I knew transitioning from CF 4.5 to CF 8 would present some issues, but gee whiz. Rick ~| 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:291132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Frameworks: Post vs. Get
Just because a crawler won't submit a form doesn't mean that a user (or a non-compliant crawler) won't. It's also not complicated for a user to modify the headers to issue a post instead of a get or vice versa. The point being, if you have something that can trigger a data change, you have to assume someone can execute it regardless of whether it is a POST or a GET and regardless of whether it was initiated by a crawler or something else. Often, when a rule seems pointless, you may simply be missing the point. In this case, the point has nothing to do with security. It's about following a simple convention. If you follow this convention, you don't have to worry about other programs that conform to those conventions. That's the whole point of having conventions. And, I can guarantee from my personal experience as a Google Search Appliance consultant, this is a regular and ongoing problem. Typically, when implementing enterprise search, you configure your GSA to crawl content that requires credentials; users can then, when searching, enter their own credentials to view private search results if those credentials allow. The GSA may be configured to crawl millions of documents across many servers, public and private, which may correspond to hundreds of separate applications. If one developer of one application doesn't understand this basic web development 101 concept, hilarity often ensues. And, frankly, this is a basic concept of web development, just like conformance to standards like HTML and CSS. Dave Watts, CTO, Fig Leaf Software ~| 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:291133 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Creating replicated sites with coldfusion
Hi, I am working on a site for a MLM company that wants each person who signs up with the company to have their own replicated website. The replicated site is really no more than each person having a separate URL that is defined by the username they put in when they sign up- everyone's site is exactly the same otherwise. For example, if I signed up for the program with a username of jessica my replicated website's address would be http://www.sample.com/jessica;. I do not want to have to create a separate folder index page for each every person who signs up, because that seems like it would be kind of ridiculous waste a lot of space, so how can I (firstly) trick the server into believing there is a separate page for each person even without a folder with their username existing in my directory? Second, and I guess this question could be answered by the first, how can I get that username to be pulled from the URL for use in dynamic queries and the like. -More or less, I am just wanting to somehow convert a query string such as http://www.sample.com?username=jessica; into the more user-friendly http://www.sample.com/jessica;. I think i am making this harder than it really is.. hopefully I have made this clear enough to understand, and any help would be greatly appreciated! Thanks!! ~| 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:291134 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF 8 - cfquery returns a struct?
Has anyone else encountered this? We switched to CF8 this week and I noticed that when I do a dump of the query variable, it now displays a struct with the query results as a member of the struct named resultset. I haven't been able to find any documentation on this subject. And I'm sure the CF programmers wouldn't have made so drastic a change without making sure old code still works. But I'm a little concerned and I want to make sure there aren't any potential code issues I need to fix. ~| 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:291136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF 8 - cfquery is returning a struct
Has anyone else encountered this? We switched to CF8 this week and I noticed that when I do a dump of the query variable, it now displays a struct with the query results as a member of the struct named resultset. I haven't been able to find any documentation on this subject. And I'm sure the CF programmers wouldn't have made so drastic a change without making sure old code still works. But I'm a little concerned and I want to make sure there aren't any potential code issues I need to fix. ~| 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:291135 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating replicated sites with coldfusion
Well, I can think of a number of ways. All of the ones I'm thinking of offhand require that you have access to your webserver. Basically, they are (in descending order of preference) mod_rewrite or the IIS equivalent, virtual directories, and a custom 404. --Ben Doom Jessica Kennedy wrote: Hi, I am working on a site for a MLM company that wants each person who signs up with the company to have their own replicated website. The replicated site is really no more than each person having a separate URL that is defined by the username they put in when they sign up- everyone's site is exactly the same otherwise. For example, if I signed up for the program with a username of jessica my replicated website's address would be http://www.sample.com/jessica;. I do not want to have to create a separate folder index page for each every person who signs up, because that seems like it would be kind of ridiculous waste a lot of space, so how can I (firstly) trick the server into believing there is a separate page for each person even without a folder with their username existing in my directory? Second, and I guess this question could be answered by the first, how can I get that username to be pulled from the URL for use in dynamic queries and the like. -More or less, I am just wanting to somehow convert a query string such as http://www.sample.com?username=jessica; into the more user-friendly http://www.sample.com/jessica;. I think i am making this harder than it really is.. hopefully I have made this clear enough to understand, and any help would be greatly appreciated! Thanks!! ~| 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:291138 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating replicated sites with coldfusion
You've got CGI variables at your disposal, when the URL is called. Provided that the username will equal the path name in every case You can use cgi.PATH_INFO and extrapolate the username from the path, and run your queries accordingly. Hth sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -Original Message- From: Jessica Kennedy [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 3:14 PM To: CF-Talk Subject: Creating replicated sites with coldfusion Hi, I am working on a site for a MLM company that wants each person who signs up with the company to have their own replicated website. The replicated site is really no more than each person having a separate URL that is defined by the username they put in when they sign up- everyone's site is exactly the same otherwise. For example, if I signed up for the program with a username of jessica my replicated website's address would be http://www.sample.com/jessica;. I do not want to have to create a separate folder index page for each every person who signs up, because that seems like it would be kind of ridiculous waste a lot of space, so how can I (firstly) trick the server into believing there is a separate page for each person even without a folder with their username existing in my directory? Second, and I guess this question could be answered by the first, how can I get that username to be pulled from the URL for use in dynamic queries and the like. -More or less, I am just wanting to somehow convert a query string such as http://www.sample.com?username=jessica; into the more user-friendly http://www.sample.com/jessica;. I think i am making this harder than it really is.. hopefully I have made this clear enough to understand, and any help would be greatly appreciated! Thanks!! ~| 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:291137 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 8 - cfquery is returning a struct
I've only just started playing with CF8, and yeah, it looks like you're correct. the data that (as of CFMX7) was available in the 'result' struct (if you used that attribute) is now available when you dump the query itself. i don't know that i'd call it a 'drastic change'. cfdump is pretty much just for debugging. what kind of potential code issues would you be running into? you're not using cfdump in your programming logic, are you? On 10/15/07, Chris Long [EMAIL PROTECTED] wrote: Has anyone else encountered this? We switched to CF8 this week and I noticed that when I do a dump of the query variable, it now displays a struct with the query results as a member of the struct named resultset. I haven't been able to find any documentation on this subject. And I'm sure the CF programmers wouldn't have made so drastic a change without making sure old code still works. But I'm a little concerned and I want to make sure there aren't any potential code issues I need to fix. ~| 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:291139 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating replicated sites with coldfusion
I would start by employing a custom (CF-based) 404 page. However, without knowing more about the app or the architecture, I don't want to suggest anything beyond that. Pete ~| 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:291140 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 8 - cfquery is returning a struct
Chris Long wrote: that when I do a dump of the query variable, it now displays a struct with the query results as a member of the struct named resultset. it's actually documented. old code still works. But I'm a little concerned and I want to make sure there aren't any potential code issues I need to fix. shouldn't be. ~| 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:291143 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What in the world is CF8 trying to say?
Well...with CF8 also supports C++ CFX tagsso shouldn't be a problem. I believe, as far as, C++ datatypes are properly typecastd by CF, there shouldn't be any problem using them. I would suggest you to refer the documentation for CF8, as it will have History of changes done and may explain you how it should be used. But since you are directly jumping from the CF4.5 to CF8, there might have been some change around this. Thanks Regards, Jayesh Viradiya Adobe CF Team -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Saturday, October 13, 2007 11:03 PM To: CF-Talk Subject: RE: What in the world is CF8 trying to say? Thanks for the feedback, Jayesh. It's must be Image.Link# since that's a variable used by the CFX_Tag. Would the fact that the CFX_tag, CFX_JPG, is a C++ tag cause any problems? Rick -Original Message- From: Jayesh Viradiya [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 12:36 AM To: CF-Talk Subject: RE: What in the world is CF8 trying to say? This kind of errors are usually seen when there is a specific type of datatype used for a wrong reason or purpose. Although I can not run your code on my machine, I would like to give some pointers which may help you. Error message says that a datatype which is QueryColumn type is being used as a structure datatype which is wrong. Any of the below three variables are not returning the expected kind of data #GAP# - #Get_Announcements.Image# - #Image.Link# Thanks Regards, Jayesh Viradiya Adobe CF Team -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Saturday, October 13, 2007 8:05 PM To: CF-Talk Subject: What in the world is CF8 trying to say? Error Occurred While Processing Request You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. Huh The code I was processing that threw the error is: 34 : div id=annPhoto 35 : CFX_JPG Source=#GAP##Get_Announcements.Image# 36 : Img Src=/_cache/#Image.Link# width=100 border=1 37 : /div I get this sinking feeling that it's because I'm trying to use the CFX_JPG tag from Efflare that I've been using with CF 4.5 for many years. Someone please tell CFX_JPG is compatible with CF8! I've used that tag on almost all of my site and I don't want to have to rewrite all that code! Rick ~| 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:291141 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating replicated sites with coldfusion
Jessica: Also, have you considered using wildcard DNS? As in http://jessica.sample.com You can do that by simply adding a * A host entry in your DNS manager. Michael -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 11:41 AM To: CF-Talk Subject: RE: Creating replicated sites with coldfusion You've got CGI variables at your disposal, when the URL is called. Provided that the username will equal the path name in every case You can use cgi.PATH_INFO and extrapolate the username from the path, and run your queries accordingly. Hth sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -Original Message- From: Jessica Kennedy [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 3:14 PM To: CF-Talk Subject: Creating replicated sites with coldfusion Hi, I am working on a site for a MLM company that wants each person who signs up with the company to have their own replicated website. The replicated site is really no more than each person having a separate URL that is defined by the username they put in when they sign up- everyone's site is exactly the same otherwise. For example, if I signed up for the program with a username of jessica my replicated website's address would be http://www.sample.com/jessica;. I do not want to have to create a separate folder index page for each every person who signs up, because that seems like it would be kind of ridiculous waste a lot of space, so how can I (firstly) trick the server into believing there is a separate page for each person even without a folder with their username existing in my directory? Second, and I guess this question could be answered by the first, how can I get that username to be pulled from the URL for use in dynamic queries and the like. -More or less, I am just wanting to somehow convert a query string such as http://www.sample.com?username=jessica; into the more user-friendly http://www.sample.com/jessica;. I think i am making this harder than it really is.. hopefully I have made this clear enough to understand, and any help would be greatly appreciated! Thanks!! ~| 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:291142 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
IIS 7.0 for CFML Developers
I've prepared a talk entitled, IIS 7.0 for CFML Developers that I'll be presenting at various CF user groups and conferences over the next several months. While I do discuss BlueDragon, this is not a BD-specific presentation, but is intended to be of general interest to all developers who deploy CFML applications on IIS using either ColdFusion or BlueDragon (either the Java/J2EE edtions or BlueDragon.NET). Here's the synopsis: Internet Information Server (IIS) 7.0 is the newest release of Microsoftâs web server for Windows. Currently shipping with Windows Vista, IIS 7.0 is also part of Windows Server 2008, scheduled for release in February 2008. This talk will present an overview of the major new features of IIS 7.0, including: customizable installation, simplified configuration and administration, security enhancements, integrated request pipeline, extensibility enhancements, and much more. The impact and benefits of the new IIS 7.0 features for developers using Adobe ColdFusion or New Atlanta BlueDragon will be explored. Here's my current schedule: - Maryland CFUG, November 13, 2007 - Capitol Hill User Group, November 15, 2007 - Atlanta CFUG, January 2008 - CFUNITED Europe 2008, March 12-13 2008 Let me know if you're interested in having me give this presentation to your local CFUG. Vince Bonfanti New Atlanta Communications, LLC ~| 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:291144 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF 8 - cfquery returns a struct?
I am pretty sure that this is a thing that CFDump does directly. You do not have to now do #queryname.resultset.columnname#... J.J. On 10/15/07, Chris Long [EMAIL PROTECTED] wrote: Has anyone else encountered this? We switched to CF8 this week and I noticed that when I do a dump of the query variable, it now displays a struct with the query results as a member of the struct named resultset. I haven't been able to find any documentation on this subject. And I'm sure the CF programmers wouldn't have made so drastic a change without making sure old code still works. But I'm a little concerned and I want to make sure there aren't any potential code issues I need to fix. ~| 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:291145 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 8 - cfquery returns a struct?
If you look at the CF8 docs on CFQUERY you'll see a full description of what the result structure contains. It doesn't break any existing code, but it does add several useful bits of information that you can use. On 10/15/07, Chris Long [EMAIL PROTECTED] wrote: Has anyone else encountered this? We switched to CF8 this week and I noticed that when I do a dump of the query variable, it now displays a struct with the query results as a member of the struct named resultset. I haven't been able to find any documentation on this subject. And I'm sure the CF programmers wouldn't have made so drastic a change without making sure old code still works. But I'm a little concerned and I want to make sure there aren't any potential code issues I need to fix. ~| 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:291147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Frameworks: Post vs. Get
On 10/15/07, Dave Watts [EMAIL PROTECTED] wrote: Often, when a rule seems pointless, you may simply be missing the point. Which is, you know, the point of talking about it. The discussion has expanded my horizons since I had never considered the problems that Google accelerator or a secure spider might cause. Since the vast majority of developers haven't had this issue cause them any problems, it's easy to see why many people don't see the point of worrying about it. Back to the original topic, I still wouldn't be referencing the form scope from within the model. If you want to guarantee that the request was a POST, I'd do it in the controller before anything even gets to the model. ~| ColdFusion 8 - 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:291146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Frameworks: Post vs. Get
On 10/15/07, Brian Kotek wrote: Back to the original topic, I still wouldn't be referencing the form scope from within the model. If you want to guarantee that the request was a POST, I'd do it in the controller before anything even gets to the model. Which is precisely what I was asking about. As I said above, I wholeheartedly agree with you that your model should not care where it came from. My question was specific to the controller. Matt ~| 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:291148 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Rollback db changes in CFCUnit/CFUnit tests
Could someone post Rick's script? I am very interested in looking @ it. Thanks, ~| ColdFusion 8 - 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:291150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Enabling RDS and/or configuring Report Builder (RDS 404)
When I installed CF8 on my development machine, I disabled RDS because none of the developers use it. However, our manager now wants to use Report Builder. I've uncommented the block in the web.xml file, reset the box, and updated the password via the Admin. I still get a 404 from Report Builder when I try to connect to the IP. Am I missing a step when trying to enable RDS? Does Report Builder require more information that the IP and password? Some third option? --Ben Doom ~| 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:291149 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Why would this query not return the correct data?
Thanks, Tom! Rick -Original Message- From: Tom Donovan [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 1:44 PM To: CF-Talk Subject: Re: Why would this query not return the correct data? When accessing MySQL 5 from Java (i.e. when using JDBC) all TINYINT(1) fields are converted to Boolean values. Documented here: http://dev.mysql.com/doc/refman/5.0/en/connector-j- reference-type-conversions.html You can prevent this behavior by adding a Connection String to your ColdFusion datasource (in Advanced Settings): tinyInt1isBit=false This will cause the JDBC driver to treat TINYINT(1) the way you want it to - as tiny little integers instead of boolean true/false values. -tom- ~| 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:291151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT Sys-con at it again
Is it me, or is the article verging on the incomprehensible? I think they spent longer editing the little graphic... Josh says the sys-con mailing list is really slow, and JH somehow comes to the conclusion from that that CF is dead? OK then, well lets take that logic a little furtherbecause the sky is blue, I will win the F1 World championship on Sunday. Neil On 10/15/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Friday 12 Oct 2007, [EMAIL PROTECTED] wrote: print (can they?). shouldn't there be some sort of system in place whereby somebody can say, hey sys-con... produce me one (just ONE) person in the CF community that feels that Adobe's destruction of CF started by pulling the plug on CFDJ. Libel/Slander. Adobe probably don't want to go to caught over it though, do they ? -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! 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 Solicitors Regulation Authority. 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. ~| 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:291152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
DataGrid with Dynamic Link
Hi Guys- I'm trying to use the DataGrid for my log viewer, but i need to link the summary field to a details page. When I use the code below, it appends all sorts of garbage onto the URL. What am I doing wrong? cfform cfgrid name=log format=html pagesize=20 striperows=yes delete=yes bind=cfc:common.cfcs.log.getlog({cfgridpage}, {cfgridpagesize}, {cfgridsortcolumn}, {cfgridsortdirection}) cfgridcolumn name=datecreated header=Date width=100 / cfgridcolumn name=type header=Type width=100/ cfgridcolumn name=category header=Category width=100/ cfgridcolumn name=summary header=Summary width=200href=details.cfm hrefkey=id/ cfgridcolumn name=details header=Details width=400/ /cfgrid /cfform Thanks Phil ~| 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:291153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Rollback db changes in CFCUnit/CFUnit tests
Here is the ant script that I was referring to the properties file that powers it. Also included are the caveats that I gave Janet: A few caveats: 1. It is targeted specifically to MSSQL. 2. I am using the open source JTDS drivers ( http://jtds.sourceforge.net/) to access our databases. One problem I ran into when resetting our database was when constraints existed on existing tables so I use some MSSQL specific SQL to temporarily detach the constraints during the reset process. If you are not using MSSQL, you will need to change the insert operation to CLEAN_INSERT (if i remember correctly) as it is currently using MSSQL_CLEAN_INSERT in addition to updating the constraint code. I hope this helps you with what you are working on. Good luck! HTH, Rich Kroll *** Properties file (db-build.properties) *** db.driver=net.sourceforge.jtds.jdbc.Driver db.urlprefix=jdbc:jtds:sqlserver:// db.server=RKROLL db.port=1433 db.instance= db.database=MYDATABASE db.username=user db.password=password db.exportfile=dataset *** Build file (build.xml) *** project name=Build default=menu basedir=. taskdef name=dbunit classname=org.dbunit.ant.DbUnitTask / property file=db-build.properties / target name=menu depends=init echo MENU Available tasks: export: Exports the database to a flat xml file. (Should only be done on schema changes) export-dtd: Exports the database schema DTD reset: Reset the database to a last known good state disable-constraints:Disable database constraints enable-constraints: Enable database constraints /echo input message=Choose a task: validargs=export,export-dtd,reset,disable-constraints,enable-constraints defaultvalue=reset addproperty=task / antcall target=${task} inheritAll=true / /target !-- = target: INIT = -- target name=init description=-- Initilization property name=db.server value=RKROLL/ property name=db.port value=1433/ property name=db.instance value=/ property name=db.username value=sa/ property name=db.password value=password/ property name=db.exportfile value=dataset/ /target !-- = target: reset = -- target name=reset depends=init,disable-constraints description=-- resets the database to a last known good state echoPerforming database reset on ${db.server}:${db.port}/${db.database};instance=${db.instance}/echo echoclean insert beginning.../echo dbunit driver=${db.driver} url=${db.urlprefix}${db.server}:${db.port}/${db.database};instance=${db.ins tance} userid=${db.username} password=${db.password} operation type=MSSQL_CLEAN_INSERT src=${db.exportfile}.xml format=flat / /dbunit echoclean insert complete/echo echoenabling constraints.../echo antcall target=enable-constraints / echodatabase reset complete./echo /target !-- = target: export = -- target name=export depends=init echoAccessing DB [jdbc:jtds:sqlserver://${db.server}:${db.port}/${db.database};instance=${db. instance}]/echo dbunit driver=${db.driver} url=${db.urlprefix}${db.server}:${db.port}/${db.database};instance=${db.ins tance} userid=${db.username} password=${db.password} export dest=${db.exportfile}.xml / /dbunit /target !-- = target: export-dtd = -- target name=export-dtd depends=init description=-- Exports the database DTD dbunit driver=${db.driver} url=${db.urlprefix}${db.server}:${db.port}/${db.database};INSTANCE=${db.ins tance} userid=${db.username} password=${db.password} export dest=${db.exportfile}.dtd format=dtd/ /dbunit /target !-- = target: disable-constraints = -- target name=disable-constraints
Re: Rollback db changes in CFCUnit/CFUnit tests
http://www.barneyb.com/barneyblog/2007/07/13/schema-tool-update/ This is quite a useful tool for managing database migrations. Mark F ~| 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:291155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Catching referring domain in CF?
Is there a way to pass a variable with the domain name only from the referring page to a target page using CF? For example, how can I pass (or extract) just houseoffusion.com to the target page when coming from http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm; Thanks in advance for your help, Les ~| ColdFusion 8 - 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:291156 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: AES decryption problem
I hope someone with a little knowledge of Encryption and AES stuff can help me out with how to use a provided key to decrypt some info. Your time here would be greatly appreciated. Details below. On 10/15/07, Duncan [EMAIL PROTECTED] wrote: Hi all, I have a token that is being passed in via the URL, that is generated in a .NET program. I am having trouble decoding it in CF 8 so I was hoping that someone could give me a hand. I am very frustrated with this as this is my first dive into AES. The .NET developer gave me the following instructions: These are the steps needed to return the key in the email back to it's original state 1. URLDecode the key 2. Convert result to decoded base64 binary 3. Remove chr(0) from end of string 4. Decrypt from AES192 (requires a 24 character Key). Hence make sure you pad the hash key with spaces at the end up to 24 characters And here is what I have code wise now (I changed the key to keep it private): cfoutput !--- comes in via URL --- cfset forDec=OTg4MTc6NjcmOEpoXmRXRWY0JSVHWUcqb2xpa3VqZGxveHRvbkByZWQ1LmNvbS5hdQ%3D%3D !--- padded with spaces to make 24 chars --- cfset key=7KSK^8SID br /#forDec# !--- 1. URLDecode the key --- cfset forDec = URLDecode(forDec) br /#forDec# !--- 2. Convert result to decoded base64 binary --- cfset forDec = BinaryDecode(forDec,base64) !--- we now have binary object --- cfdump var=#forDec# !---3. Remove chr(0) from end of string --- !--- I cant put a trim on to a binary object, nor can I do a ReplacenoCase() --- !---4. Decrypt from AES192 (requires a 24 character Key). Hence make sure you pad the hash key with spaces at the end up to 24 characters--- cfset key = Decrypt(forDec,key,AES,base64) /cfoutput This results in a bytearray cannot be converted to strings error. So I tried forDec.toString(), but every request this generates a different value - how can this be? cfset key = Decrypt(BinaryEncode(forDec,base64),BinaryDecode(key,base64),AES,base64) Results in getting an error that The input and output encodings are not same. I am at a loss and tearing my hair out - can anyone help me out here??? -- Duncan I Loxton [EMAIL PROTECTED] -- Duncan I Loxton [EMAIL PROTECTED] ~| 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:291157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Catching referring domain in CF?
Is there a way to pass a variable with the domain name only from the referring page to a target page using CF? Try listGetAt(CGI.HTTP_REFERER, 2, /) But the HTTP_REFERER value is not always set by the client, so it is not 100% proof. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:291158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, Flex, and Remoting over SSL
On 10/4/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote: On 10/4/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote: Content-Length: 331 What the content here say ? Fiddler doesn't decode AMF content... When I highlight the hex content, it says the length is 331... so that must be it :) If you set the logging in services-config.xml to level=Debug does the CF log indicate it sent stuff back ? I finally got around to doing this... what I did so as not to break my other applications was set up a second destination called ColdfusionSSL, which used the my-cfamf-secure channel. I verified that https://advanceweb.ads.duke.edu/flex2gateway/cfamfsecure answers. I set the flex debug level to Debug and got the following output: This is generated by a VERY simple call to a very simple method called checkAuth() - all it does is check for the existence of a cookie, and return true or false. I don't know what any of this logging means. [Flex] FlexSession created with id 'a430990913ea13bb4ad595c1936a7a554258TR' for an Http-based client connection. [Flex] Channel endpoint my-cfamf-secure received request. [Flex] Deserializing AMF/HTTP request Version: 3 (Message #0 targetURI=null, responseURI=/1) (Array #0) [0] = (Typed Object #0 'flex.messaging.messages.CommandMessage') operation = 5 correlationId = messageId = 987088B3-4172-5E89-C9BA-A5C58325ABE9 body = (Object #1) clientId = null timeToLive = 0 headers = (Object #2) DSId = nil timestamp = 0 destination = [Flex] Executed command: (default service) commandMessage: Flex Message (flex.messaging.messages.CommandMessage) operation = client_ping clientId = D9B7365E-821B-0933-EB49-0778BC185020 correlationId = destination = messageId = 987088B3-4172-5E89-C9BA-A5C58325ABE9 timestamp = 1192487125922 timeToLive = 0 body = {} hdr(DSId) = nil hdr(DSEndpoint) = my-cfamf-secure replyMessage: Flex Message (flex.messaging.messages.AcknowledgeMessage) clientId = D9B7365E-821B-0933-EB49-0778BC185020 correlationId = 987088B3-4172-5E89-C9BA-A5C58325ABE9 destination = null messageId = D9B7365E-822E-51FF-4E91-C20D589B541F timestamp = 1192487125922 timeToLive = 0 body = null hdr(DSId) = D9B7365E-820A-23DC-E6BB-A423E671BF99 [Flex] Serializing AMF/HTTP response Version: 3 (Message #0 targetURI=/1/onResult, responseURI=) (Typed Object #0 'flex.messaging.messages.AcknowledgeMessage') timestamp = 1.192487125922E12 headers = (Object #1) DSId = D9B7365E-820A-23DC-E6BB-A423E671BF99 body = null correlationId = 987088B3-4172-5E89-C9BA-A5C58325ABE9 messageId = D9B7365E-822E-51FF-4E91-C20D589B541F timeToLive = 0.0 clientId = D9B7365E-821B-0933-EB49-0778BC185020 destination = null -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.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:291159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: DataGrid with Dynamic Link
I don't see the link here. You are probably doing something with that href and hrefkey but i have no idea what, setup a proxy listener or just bind the summary to this grid. I think you are making it harder than it needs to be. But I would need to see the summary or how that works to be sure, is the summary another grid, or a pod or a window etc. Regards Dale Fraser http://learncf.com -Original Message- From: Philip Hayes [mailto:[EMAIL PROTECTED] Sent: Tuesday, 16 October 2007 6:14 AM To: CF-Talk Subject: DataGrid with Dynamic Link Hi Guys- I'm trying to use the DataGrid for my log viewer, but i need to link the summary field to a details page. When I use the code below, it appends all sorts of garbage onto the URL. What am I doing wrong? cfform cfgrid name=log format=html pagesize=20 striperows=yes delete=yes bind=cfc:common.cfcs.log.getlog({cfgridpage}, {cfgridpagesize}, {cfgridsortcolumn}, {cfgridsortdirection}) cfgridcolumn name=datecreated header=Date width=100 / cfgridcolumn name=type header=Type width=100/ cfgridcolumn name=category header=Category width=100/ cfgridcolumn name=summary header=Summary width=200href=details.cfm hrefkey=id/ cfgridcolumn name=details header=Details width=400/ /cfgrid /cfform Thanks Phil ~| 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:291160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFINPUT: how can I prevent spaces
I've got this: CFINPUT TYPE=text TYPE=text NAME=_username validate=regular_expression pattern=[A-Za-z0-9] maxlength=20 required=yes message=Please enter an alphanumeric username, without spaces but this will accept spaces. What code can I use to prevent spaces. ~| 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:291161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DataGrid with Dynamic Link
read up on how to use hrefkey attribute of cfgridcolumn tag. you are using it wrong. there is no column named ID that it is tied to. -- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com ~| ColdFusion 8 - 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:291162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: AES decryption problem
So far in my investigation and trial and error, I have discovered that the AES key you use cannot have ^ or in it. The key we were provided by the .NET side did have these in. Another thing is that padding to 24 characters renders the error The key specified is not a valid key for this encryption: Invalid AES key length: 7 bytes - 7 bytes? Its like CF doesnt even see the extra spaces. So I replaced the spaces with 3's and I get an 18 byte string? What in the wierd? Replace the last 2 characters with == and it works fine, my manually generated key is 7+8sh+dWEf== I am putting this out there because its causing me no end of problems, and I cant find anything out in google land or on blogs about this. On 10/16/07, Duncan [EMAIL PROTECTED] wrote: I hope someone with a little knowledge of Encryption and AES stuff can help me out with how to use a provided key to decrypt some info. Your time here would be greatly appreciated. Details below. On 10/15/07, Duncan [EMAIL PROTECTED] wrote: Hi all, I have a token that is being passed in via the URL, that is generated in a .NET program. I am having trouble decoding it in CF 8 so I was hoping that someone could give me a hand. I am very frustrated with this as this is my first dive into AES. The .NET developer gave me the following instructions: These are the steps needed to return the key in the email back to it's original state 1. URLDecode the key 2. Convert result to decoded base64 binary 3. Remove chr(0) from end of string 4. Decrypt from AES192 (requires a 24 character Key). Hence make sure you pad the hash key with spaces at the end up to 24 characters And here is what I have code wise now (I changed the key to keep it private): cfoutput !--- comes in via URL --- cfset forDec=OTg4MTc6NjcmOEpoXmRXRWY0JSVHWUcqb2xpa3VqZGxveHRvbkByZWQ1LmNvbS5hdQ%3D%3D !--- padded with spaces to make 24 chars --- cfset key=7KSK^8SID br /#forDec# !--- 1. URLDecode the key --- cfset forDec = URLDecode(forDec) br /#forDec# !--- 2. Convert result to decoded base64 binary --- cfset forDec = BinaryDecode(forDec,base64) !--- we now have binary object --- cfdump var=#forDec# !---3. Remove chr(0) from end of string --- !--- I cant put a trim on to a binary object, nor can I do a ReplacenoCase() --- !---4. Decrypt from AES192 (requires a 24 character Key). Hence make sure you pad the hash key with spaces at the end up to 24 characters--- cfset key = Decrypt(forDec,key,AES,base64) /cfoutput This results in a bytearray cannot be converted to strings error. So I tried forDec.toString(), but every request this generates a different value - how can this be? cfset key = Decrypt(BinaryEncode(forDec,base64),BinaryDecode(key,base64),AES,base64) Results in getting an error that The input and output encodings are not same. I am at a loss and tearing my hair out - can anyone help me out here??? -- Duncan I Loxton [EMAIL PROTECTED] -- Duncan I Loxton [EMAIL PROTECTED] -- Duncan I Loxton [EMAIL PROTECTED] ~| 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:291163 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: DataGrid with Dynamic Link
I understand what those tags are doing, what I don't understand is what you want to do. From the sound of your post you wanted to do something when a row was clicked, not a column. If you can answer my question on where the details show, ie pod, div or window (ajax or html) types then I can assist. Regards Dale Fraser http://learncf.com -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Tuesday, 16 October 2007 11:23 AM To: CF-Talk Subject: Re: DataGrid with Dynamic Link read up on how to use hrefkey attribute of cfgridcolumn tag. you are using it wrong. there is no column named ID that it is tied to. -- Azadi Saryev Sabai-dee.com http://www.sabai-dee.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:291164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Enabling RDS and/or configuring Report Builder (RDS 404)
I still get a 404 from Report Builder when I try to connect to the IP. The URL /CFIDE/Main/ide.cfm must resolve. There isn't actually a file there; to trick your web server, you might try creating one. Dave Watts, CTO, Fig Leaf Software ~| 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:291165 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DataGrid with Dynamic Link
@Dale: my comment and suggestion to read up on hrefkey use was addressed to the OP, Phil, not to you... i know you know those attributes :) sorry if I caused confusion but why do you think there is more to Phil's code than what he has posted? his mentioning garbage in the url makes me think his grid is just a simple one linked to a details.cfm page via summary column... Azadi Dale Fraser wrote: I understand what those tags are doing, what I don't understand is what you want to do. From the sound of your post you wanted to do something when a row was clicked, not a column. If you can answer my question on where the details show, ie pod, div or window (ajax or html) types then I can assist. Regards Dale Fraser http://learncf.com -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Tuesday, 16 October 2007 11:23 AM To: CF-Talk Subject: Re: DataGrid with Dynamic Link read up on how to use hrefkey attribute of cfgridcolumn tag. you are using it wrong. there is no column named ID that it is tied to. -- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com ~| 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:291166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Problem with using variables scope
Hi People, I have encountered a very weird error with variables scope. cfset var AnnouncementBean = createObject(component,mypath.announcement).init(argumentcollection=arguments)/ and cfset var AnnouncementType = createObject(component,mypath.announcementType).init(argumentcollection=arguments)/ Then I dump those two objects and found that the AnnouncementBean object is the same as AnnouncementType (it has properties and methods of AnnouncementType ) When I comment the creation of the second object then dump it, it show the correct object. I found that because cfset variables.instance = StructNew() / is declared in both objects and when I created the second object, this variables.instance overrides the first variables.instance was created in the first one. To me, it's really really weird as the variables scope exists only within that object. Using CFMX 7 is ok, the CF6 causes this problem. I am running in Unix. Any help is appreciated. ~| 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:291167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IIS 7.0 for CFML Developers
Internet Information Server (IIS) 7.0 is the newest release of Microsoftâs web server for Windows. Currently shipping with Windows Vista, IIS 7.0 is also part of Windows Server 2008, scheduled for I can't believe anything would even RUN on Vista. It's still just as useless as ever. ~| 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:291169 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with using variables scope
Michael - You do realise that CFMX 6 is no longer supported by Adobe? Does the issue also occur on 6.1? Mark On 10/16/07, Michael Nguyen [EMAIL PROTECTED] wrote: Hi People, I have encountered a very weird error with variables scope. cfset var AnnouncementBean = createObject(component,mypath.announcement).init(argumentcollection=arguments)/ and cfset var AnnouncementType = createObject(component,mypath.announcementType).init(argumentcollection=arguments)/ Then I dump those two objects and found that the AnnouncementBean object is the same as AnnouncementType (it has properties and methods of AnnouncementType ) When I comment the creation of the second object then dump it, it show the correct object. I found that because cfset variables.instance = StructNew() / is declared in both objects and when I created the second object, this variables.instance overrides the first variables.instance was created in the first one. To me, it's really really weird as the variables scope exists only within that object. Using CFMX 7 is ok, the CF6 causes this problem. I am running in Unix. Any help is appreciated. ~| 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:291168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: DataGrid with Dynamic Link
You are probably correct, I was going to suggest how I do it. Which is using cfajaxproxy With javascript you have more control if you setup the listeners, clicking on a column that refreshes the page and takes you to another loosing the grid is very Web 1 to me, so everything im working on would have this type of summary in a cfwindow, pod, another grid etc etc. Regards Dale Fraser http://learncf.com -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Tuesday, 16 October 2007 12:51 PM To: CF-Talk Subject: Re: DataGrid with Dynamic Link @Dale: my comment and suggestion to read up on hrefkey use was addressed to the OP, Phil, not to you... i know you know those attributes :) sorry if I caused confusion but why do you think there is more to Phil's code than what he has posted? his mentioning garbage in the url makes me think his grid is just a simple one linked to a details.cfm page via summary column... Azadi Dale Fraser wrote: I understand what those tags are doing, what I don't understand is what you want to do. From the sound of your post you wanted to do something when a row was clicked, not a column. If you can answer my question on where the details show, ie pod, div or window (ajax or html) types then I can assist. Regards Dale Fraser http://learncf.com -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Tuesday, 16 October 2007 11:23 AM To: CF-Talk Subject: Re: DataGrid with Dynamic Link read up on how to use hrefkey attribute of cfgridcolumn tag. you are using it wrong. there is no column named ID that it is tied to. -- Azadi Saryev Sabai-dee.com http://www.sabai-dee.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:291171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem with using variables scope
Never seen that with 7 and now 8 and do that type of thing all the time. If this is just 6, id say upgrade. Your right, it shouldn't happen. Regards Dale Fraser http://learncf.com -Original Message- From: Michael Nguyen [mailto:[EMAIL PROTECTED] Sent: Tuesday, 16 October 2007 2:25 PM To: CF-Talk Subject: Problem with using variables scope Hi People, I have encountered a very weird error with variables scope. cfset var AnnouncementBean = createObject(component,mypath.announcement).init(argumentcollection=argu ments)/ and cfset var AnnouncementType = createObject(component,mypath.announcementType).init(argumentcollection= arguments)/ Then I dump those two objects and found that the AnnouncementBean object is the same as AnnouncementType (it has properties and methods of AnnouncementType ) When I comment the creation of the second object then dump it, it show the correct object. I found that because cfset variables.instance = StructNew() / is declared in both objects and when I created the second object, this variables.instance overrides the first variables.instance was created in the first one. To me, it's really really weird as the variables scope exists only within that object. Using CFMX 7 is ok, the CF6 causes this problem. I am running in Unix. Any help is appreciated. ~| 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:291170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is This Possible??
In your table structure, I see you have declared the primary key for each table, but I am unclear as to any foreign keys. Since the rest of the columns are varchars. Can I assume that tbl_personnel.emp_id is a 'unique' id that represents each unique row? Can I assume the same for tbl_training_calendar.trng_code? If so, I would write Select p.first_name, p.last_name, p.emp_id, cal.trng_title, com.trng_status From tbl_personnel p, tbl_training_calendar cal LEFT OUTER JOIN tbl_training_completed com ON com.emp_id = p.emp_id And com.trng_code = cal.trng_code Order by p.emp_id asc This is, of course, untested. -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer http://William.Seiter.com -Original Message- From: Leonard Boche [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 7:50 AM To: CF-Talk Subject: Re: Is This Possible?? Hi Kris, First I would like to thank you for responding to my post, it is greatly appreciated. I will try to answer your questions in the order you presented them. Q1 - The ultimate goal of this project is to display a listing of the annual training calendar and show what training a given employee has and has not completed from that list. Q2 - Whether this can be accomplished with a single query or multiple queries, makes no difference to me. Q3 - Expected output would be something along the lines of this row 1: trng_code --- trng_title --- completed row 2: trng_code --- trng_title --- not completed row 3: trng_code --- trng_title --- completed and so forth running the through the table containing the annual training event information. Q4 - Not sure what you are looking for with this question. Q5 - Table structure tbl_personnel --- record_id = key --- first_name (varchar) --- last_name (varchar) --- emp_id varchar tbl_training_calendar --- record_id = key --- trng_code (varchar) --- trng_title (varchar) tbl_training_completed --- record_id = key --- trng_code (varchar) --- emp_id (varchar) --- trng_status (varchar) With my current thinking process, the only time there would information entered into the tbl_training_completed table, would be when the individual actually completed said training. This I am having no problems with query and displaying. However, the issue I am having problems with is, determining what training of the scheduled training the individual has not done so I can include it in the same display / output in the layout described in Q3. The more I ponder on the scenario, the more I am becoming convinced it cannot be accomplished without pre-loading the trng_status field of the tbl_training_completed table with 'not completed' or NULL and query/evaluate against that. With there being 63 individuals and about 75 different training elements, pre-loading does not look pleasant. I am certainly open to suggestions on easier / more effective ways to accomplish this. I can do messengers as well as offer a virtual meeting session, if this would make reaching a solution easier. Thanks in advance, I hope I answered your questions. Leonard ~| ColdFusion 8 - 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:291172 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating replicated sites with coldfusion
Use a custom 404 page. You will need to update the 404 error handling in your server (Apache, IIS, etc) to point to this new page on all 404 errors. This page will parse the cgi.request_uri string into an array based on the / character. Do a check in the database for the user which matches the value in the last position in the array. (or you can do an 'or' check for each of the positions after the host_name) If the result is eq 1, then display the agent's website. If the result is gt 1, then display a 'choice' of which one the user had intended to type in. If the result is eq 0, then show your 404 error page. William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer http://William.Seiter.com -Original Message- From: Jessica Kennedy [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 12:14 PM To: CF-Talk Subject: Creating replicated sites with coldfusion Hi, I am working on a site for a MLM company that wants each person who signs up with the company to have their own replicated website. The replicated site is really no more than each person having a separate URL that is defined by the username they put in when they sign up- everyone's site is exactly the same otherwise. For example, if I signed up for the program with a username of jessica my replicated website's address would be http://www.sample.com/jessica;. I do not want to have to create a separate folder index page for each every person who signs up, because that seems like it would be kind of ridiculous waste a lot of space, so how can I (firstly) trick the server into believing there is a separate page for each person even without a folder with their username existing in my directory? Second, and I guess this question could be answered by the first, how can I get that username to be pulled from the URL for use in dynamic queries and the like. -More or less, I am just wanting to somehow convert a query string such as http://www.sample.com?username=jessica; into the more user-friendly http://www.sample.com/jessica;. I think i am making this harder than it really is.. hopefully I have made this clear enough to understand, and any help would be greatly appreciated! Thanks!! ~| 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:291173 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Frameworks: Post vs. Get
It seems that if the framework doesn't let you know which request method the variables came from, the controller code will have to be modified to check the FORM scope with StructKeyExists() or, perhaps more appropriately, CGI.REQUEST_METHOD (if that is populated by your webserver). On 10/16/07, Matt Quackenbush [EMAIL PROTECTED] wrote: On 10/15/07, Brian Kotek wrote: Back to the original topic, I still wouldn't be referencing the form scope from within the model. If you want to guarantee that the request was a POST, I'd do it in the controller before anything even gets to the model. Which is precisely what I was asking about. As I said above, I wholeheartedly agree with you that your model should not care where it came from. My question was specific to the controller. Matt ~| 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:291174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Creating replicated sites with coldfusion
I have actually done just this with a website of mine... Best way I found was to use mod_rewrite which will require you to have apache. If you are are able to do that then just add a file called ..htaccess to your root and in that do: RewriteEngine on RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule (.*) /index.cfm?username=$1 [L] J.J. On 10/15/07, Jessica Kennedy [EMAIL PROTECTED] wrote: Hi, I am working on a site for a MLM company that wants each person who signs up with the company to have their own replicated website. The replicated site is really no more than each person having a separate URL that is defined by the username they put in when they sign up- everyone's site is exactly the same otherwise. For example, if I signed up for the program with a username of jessica my replicated website's address would be http://www.sample.com/jessica;. I do not want to have to create a separate folder index page for each every person who signs up, because that seems like it would be kind of ridiculous waste a lot of space, so how can I (firstly) trick the server into believing there is a separate page for each person even without a folder with their username existing in my directory? Second, and I guess this question could be answered by the first, how can I get that username to be pulled from the URL for use in dynamic queries and the like. -More or less, I am just wanting to somehow convert a query string such as http://www.sample.com?username=jessica; into the more user-friendly http://www.sample.com/jessica;. I think i am making this harder than it really is.. hopefully I have made this clear enough to understand, and any help would be greatly appreciated! Thanks!! ~| 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:291175 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4