wot: has anyone scene this browser error before?
sorry for the wot post but i cant seem to find my answers anywhere. i just reinstalled my op system again (good ole xp) and now when i try to go onto a lot of sites i get this error Windows 3.1 (16-bit) Web browsers are not supported, even if they are running in Windows 95. Download the latest 32-bit version i installed the latest ie explore with sp1 new mdacs, active x's, everything frickin pissin me off! lol i also installed the latest vm and the newest mozzila, still with no luck any thoughts? thanks dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Is it possible to achieve workflow in Coldfusion ???
Hi I am trying to add a workflow element into a news application, and would just like to hear if anybody else on the list have been able to achieve this? or best practices on how to achieve this? I have an admin form that allows users to add news stories. At present when the form is submitted the data is entered into the database table. What I would like to achieve is when the user submits the form an e-mail is sent to the relevant approver. They view their e-mail and click on the link which opens up their admin screen. From here they can see they have content to approve. The approver reads through the story and if they are happy they approve the data and it is entered into the database and goes live on the site. If the approver declines the story it sends the user who created the content an e-mail with why the data was not approved and the changes needed to be made, and the story does not go live on the site. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is it possible to achieve workflow in Coldfusion ???
Ian, This is relatively simple. As part of the submit page, have it save the document away with a flag 'pending'. Is there just one administrator? Do you want different admin for different areas of the site? That is the real pain. You could have a pending approval page that admin can go to to see any pending pages. They could then view (AND edit) those pages before accepting the content or rejecting the comment. Adam -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 09:38 To: CF-Talk Subject: Is it possible to achieve workflow in Coldfusion ??? Hi I am trying to add a workflow element into a news application, and would just like to hear if anybody else on the list have been able to achieve this? or best practices on how to achieve this? I have an admin form that allows users to add news stories. At present when the form is submitted the data is entered into the database table. What I would like to achieve is when the user submits the form an e-mail is sent to the relevant approver. They view their e-mail and click on the link which opens up their admin screen. From here they can see they have content to approve. The approver reads through the story and if they are happy they approve the data and it is entered into the database and goes live on the site. If the approver declines the story it sends the user who created the content an e-mail with why the data was not approved and the changes needed to be made, and the story does not go live on the site. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is it possible to achieve workflow in Coldfusion ???
Adam There is only one administrator or approver. How would you achieve this, do you have example code so I can see how it may function, how do you stop the data entering the database ?? As part of the submit page, have it save the document away with a flag 'pending'. - Original Message - From: Adam Reynolds [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:46 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, This is relatively simple. As part of the submit page, have it save the document away with a flag 'pending'. Is there just one administrator? Do you want different admin for different areas of the site? That is the real pain. You could have a pending approval page that admin can go to to see any pending pages. They could then view (AND edit) those pages before accepting the content or rejecting the comment. Adam -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 09:38 To: CF-Talk Subject: Is it possible to achieve workflow in Coldfusion ??? Hi I am trying to add a workflow element into a news application, and would just like to hear if anybody else on the list have been able to achieve this? or best practices on how to achieve this? I have an admin form that allows users to add news stories. At present when the form is submitted the data is entered into the database table. What I would like to achieve is when the user submits the form an e-mail is sent to the relevant approver. They view their e-mail and click on the link which opens up their admin screen. From here they can see they have content to approve. The approver reads through the story and if they are happy they approve the data and it is entered into the database and goes live on the site. If the approver declines the story it sends the user who created the content an e-mail with why the data was not approved and the changes needed to be made, and the story does not go live on the site. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is it possible to achieve workflow in Coldfusion ???
You don't stop the data entering the database, you add a column to the db table called status. This determines what pages are visible, which ones are pending, and possibly which ones are deleted but I would hard delete these on reject unless people want to be able to contest the rejection. The code is releatively simple and any CF book will give you examples of what to do. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 11:02 To: CF-Talk Subject: Re: Is it possible to achieve workflow in Coldfusion ??? Adam There is only one administrator or approver. How would you achieve this, do you have example code so I can see how it may function, how do you stop the data entering the database ?? As part of the submit page, have it save the document away with a flag 'pending'. - Original Message - From: Adam Reynolds [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:46 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, This is relatively simple. As part of the submit page, have it save the document away with a flag 'pending'. Is there just one administrator? Do you want different admin for different areas of the site? That is the real pain. You could have a pending approval page that admin can go to to see any pending pages. They could then view (AND edit) those pages before accepting the content or rejecting the comment. Adam -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 09:38 To: CF-Talk Subject: Is it possible to achieve workflow in Coldfusion ??? Hi I am trying to add a workflow element into a news application, and would just like to hear if anybody else on the list have been able to achieve this? or best practices on how to achieve this? I have an admin form that allows users to add news stories. At present when the form is submitted the data is entered into the database table. What I would like to achieve is when the user submits the form an e-mail is sent to the relevant approver. They view their e-mail and click on the link which opens up their admin screen. From here they can see they have content to approve. The approver reads through the story and if they are happy they approve the data and it is entered into the database and goes live on the site. If the approver declines the story it sends the user who created the content an e-mail with why the data was not approved and the changes needed to be made, and the story does not go live on the site. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is it possible to achieve workflow in Coldfusion ???
Ian, Perhaps I can clarify/expand on what Adam suggested: 1) You do not stop the data entering the database when a story is submitted. Instead, it is inserted as normal but you also set another column probably in the same table, perhaps named status with a value of P for pending when you perform the insert e.g. insert into stories (story_id, foo, bar, status) values (666,'Foo','Bar','P') 2) Only display stories on the website if the status column is not P, perhaps only if the status column is A for approved e.g. select foo, bar from stories where status = 'A' 3) When the approver approves a story to be published, the appropriate row in the database gets updated and the status column is changed appropriately. e.g. update stories set status = 'A' where story_id = 666 You could extend this model quite simply to allow for multi-level approvals and multiple types of status. It's important to note that this is not a ColdFusion specific problem. It is merely a programming issue and there is more than one way to skin a cat. Thanks, André -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 11:02 To: CF-Talk Subject: Re: Is it possible to achieve workflow in Coldfusion ??? Adam There is only one administrator or approver. How would you achieve this, do you have example code so I can see how it may function, how do you stop the data entering the database ?? As part of the submit page, have it save the document away with a flag 'pending'. - Original Message - From: Adam Reynolds [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:46 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, This is relatively simple. As part of the submit page, have it save the document away with a flag 'pending'. Is there just one administrator? Do you want different admin for different areas of the site? That is the real pain. You could have a pending approval page that admin can go to to see any pending pages. They could then view (AND edit) those pages before accepting the content or rejecting the comment. Adam -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 09:38 To: CF-Talk Subject: Is it possible to achieve workflow in Coldfusion ??? Hi I am trying to add a workflow element into a news application, and would just like to hear if anybody else on the list have been able to achieve this? or best practices on how to achieve this? I have an admin form that allows users to add news stories. At present when the form is submitted the data is entered into the database table. What I would like to achieve is when the user submits the form an e-mail is sent to the relevant approver. They view their e-mail and click on the link which opens up their admin screen. From here they can see they have content to approve. The approver reads through the story and if they are happy they approve the data and it is entered into the database and goes live on the site. If the approver declines the story it sends the user who created the content an e-mail with why the data was not approved and the changes needed to be made, and the story does not go live on the site. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Weird Error Message
Today, thinking of normal day I typed in my site address. Clicked on a link and its giving following error. Does anyone knows what this error is all about and how come its appearing without anything being changed. Thanks in advance Errors reported by Java compiler: Found 1 semantic error compiling C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfSelect2ecfm2055018563.java: 1. public final class cfSelect2ecfm2055018563 extends coldfusion.runtime.CFPage{ - *** Error: Cannot write class file cfSelect2ecfm2055018563.class because that name conflicts with the name of the class file cfselect2ecfm2055018563.class in directory cfclasses. This is illegal because file names are case-insensitive in this system. . Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Weird Error Message
We had a similar problem but with cfdump after running an updater... Goto your C:/CFusionMX/wwwroot/WEB-INF/cfclasses/ directory and delete the .java and .class files relating to the cfselect and you should be alright... HTH Mikey = http://www.phonebin.com From Phone to Web in minutes -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, March 3, 2003 11:29 To: CF-Talk Subject: Weird Error Message Today, thinking of normal day I typed in my site address. Clicked on a link and its giving following error. Does anyone knows what this error is all about and how come its appearing without anything being changed. Thanks in advance Errors reported by Java compiler: Found 1 semantic error compiling C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfSelect2ecfm2055018563.java: 1. public final class cfSelect2ecfm2055018563 extends coldfusion.runtime.CFPage{ - *** Error: Cannot write class file cfSelect2ecfm2055018563.class because that name conflicts with the name of the class file cfselect2ecfm2055018563.class in directory cfclasses. This is illegal because file names are case-insensitive in this system. . Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Weird Error Message
Citeren Shahzad.Butt [EMAIL PROTECTED]: Today, thinking of normal day I typed in my site address. Clicked on a link and its giving following error. Does anyone knows what this error is all about and how come its appearing without anything being changed. Thanks in advance Errors reported by Java compiler: Found 1 semantic error compiling C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfSelect2ecfm2055018563.java: 1. public final class cfSelect2ecfm2055018563 extends coldfusion.runtime.CFPage{ - *** Error: Cannot write class file cfSelect2ecfm2055018563.class because that name conflicts with the name of the class file cfselect2ecfm2055018563.class in directory cfclasses. This is illegal because file names are case-insensitive in this system. . It probably means that you once had a file called cfslect2e.cfm It was opened and compiled a while back. The compiled page was saved to improve execution speed. then you removed it and created a file called cfSelect2e (note the case of the 's') and when coldfusion tried to compile it it found that another file with an almost identical name existed, but as the cases differ it can't (won't) overwrite the original file. To sole this you need to remove the cfselect2ecfm2055018563.class file from the cfroot\webroot\web-inf\cfclasses directory to sole this. Jesse ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Weird Error Message
Thanks, it works after deleting both .class and .java files -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 11:45 To: CF-Talk Subject: Re: Weird Error Message Citeren Shahzad.Butt [EMAIL PROTECTED]: Today, thinking of normal day I typed in my site address. Clicked on a link and its giving following error. Does anyone knows what this error is all about and how come its appearing without anything being changed. Thanks in advance Errors reported by Java compiler: Found 1 semantic error compiling C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfSelect2ecfm2055018563.java: 1. public final class cfSelect2ecfm2055018563 extends coldfusion.runtime.CFPage{ - *** Error: Cannot write class file cfSelect2ecfm2055018563.class because that name conflicts with the name of the class file cfselect2ecfm2055018563.class in directory cfclasses. This is illegal because file names are case-insensitive in this system. . It probably means that you once had a file called cfslect2e.cfm It was opened and compiled a while back. The compiled page was saved to improve execution speed. then you removed it and created a file called cfSelect2e (note the case of the 's') and when coldfusion tried to compile it it found that another file with an almost identical name existed, but as the cases differ it can't (won't) overwrite the original file. To sole this you need to remove the cfselect2ecfm2055018563.class file from the cfroot\webroot\web-inf\cfclasses directory to sole this. Jesse ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is it possible to achieve workflow in Coldfusion ???
Andre Thanks for the explanation!! Ok I understand how it is working - A user fills in the fields and clicks submit the data in entered into the db with a 'status' field set to a default of 'Pending' Ok Then when the form is submitted I use CFMail to send an e-mail to the approver informing them they have a story to approve. (Is this process correct ?) The approver clicks on the link in the e-mail and they are taken to the 'Pending Jobs' Screen. The approver opens the relevant pending job. At the bottom of this page there are two buttons 'Approve' and 'Decline' If the aprrover clicks approve the 'status' field changes to 'approve' However if the approver clicks decline then the 'status' field stays the same and an e-mail is sent back to the content owner informing them that the content has been declined. Does this make sense logically ?? Or would you add more features and or more advanced settings?? - Original Message - From: Andre Mohamed [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:24 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, Perhaps I can clarify/expand on what Adam suggested: 1) You do not stop the data entering the database when a story is submitted. Instead, it is inserted as normal but you also set another column probably in the same table, perhaps named status with a value of P for pending when you perform the insert e.g. insert into stories (story_id, foo, bar, status) values (666,'Foo','Bar','P') 2) Only display stories on the website if the status column is not P, perhaps only if the status column is A for approved e.g. select foo, bar from stories where status = 'A' 3) When the approver approves a story to be published, the appropriate row in the database gets updated and the status column is changed appropriately. e.g. update stories set status = 'A' where story_id = 666 You could extend this model quite simply to allow for multi-level approvals and multiple types of status. It's important to note that this is not a ColdFusion specific problem. It is merely a programming issue and there is more than one way to skin a cat. Thanks, André -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 11:02 To: CF-Talk Subject: Re: Is it possible to achieve workflow in Coldfusion ??? Adam There is only one administrator or approver. How would you achieve this, do you have example code so I can see how it may function, how do you stop the data entering the database ?? As part of the submit page, have it save the document away with a flag 'pending'. - Original Message - From: Adam Reynolds [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:46 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, This is relatively simple. As part of the submit page, have it save the document away with a flag 'pending'. Is there just one administrator? Do you want different admin for different areas of the site? That is the real pain. You could have a pending approval page that admin can go to to see any pending pages. They could then view (AND edit) those pages before accepting the content or rejecting the comment. Adam -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 09:38 To: CF-Talk Subject: Is it possible to achieve workflow in Coldfusion ??? Hi I am trying to add a workflow element into a news application, and would just like to hear if anybody else on the list have been able to achieve this? or best practices on how to achieve this? I have an admin form that allows users to add news stories. At present when the form is submitted the data is entered into the database table. What I would like to achieve is when the user submits the form an e-mail is sent to the relevant approver. They view their e-mail and click on the link which opens up their admin screen. From here they can see they have content to approve. The approver reads through the story and if they are happy they approve the data and it is entered into the database and goes live on the site. If the approver declines the story it sends the user who created the content an e-mail with why the data was not approved and the changes needed to be made, and the story does not go live on the site. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Is it possible to achieve workflow in Coldfusion ???
Ian, I see no flaws the logic you outlined; seems perfectly acceptable to me. As for adding more features and or more advanced settings, that is entirely dependent on whether they are justified, required or are likely to be required - something which only you are in a position to judge at present. If what you outlined is all that you need then I see no reason to expand. It is conceivable, as in other workflow systems, that you may in the future need more than one level of approval i.e. the article/story may go through a whole chain of people before it is finally ready to be published e.g. author - editor - creative/formatting - publisher etc. however, I don't know if that is appropriate for your circumstances but it might be worth bearing in mind. Hope you are successful in your endeavors. Thanks, André -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 11:54 To: CF-Talk Subject: Re: Is it possible to achieve workflow in Coldfusion ??? Andre Thanks for the explanation!! Ok I understand how it is working - A user fills in the fields and clicks submit the data in entered into the db with a 'status' field set to a default of 'Pending' Ok Then when the form is submitted I use CFMail to send an e-mail to the approver informing them they have a story to approve. (Is this process correct ?) The approver clicks on the link in the e-mail and they are taken to the 'Pending Jobs' Screen. The approver opens the relevant pending job. At the bottom of this page there are two buttons 'Approve' and 'Decline' If the aprrover clicks approve the 'status' field changes to 'approve' However if the approver clicks decline then the 'status' field stays the same and an e-mail is sent back to the content owner informing them that the content has been declined. Does this make sense logically ?? Or would you add more features and or more advanced settings?? - Original Message - From: Andre Mohamed [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:24 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, Perhaps I can clarify/expand on what Adam suggested: 1) You do not stop the data entering the database when a story is submitted. Instead, it is inserted as normal but you also set another column probably in the same table, perhaps named status with a value of P for pending when you perform the insert e.g. insert into stories (story_id, foo, bar, status) values (666,'Foo','Bar','P') 2) Only display stories on the website if the status column is not P, perhaps only if the status column is A for approved e.g. select foo, bar from stories where status = 'A' 3) When the approver approves a story to be published, the appropriate row in the database gets updated and the status column is changed appropriately. e.g. update stories set status = 'A' where story_id = 666 You could extend this model quite simply to allow for multi-level approvals and multiple types of status. It's important to note that this is not a ColdFusion specific problem. It is merely a programming issue and there is more than one way to skin a cat. Thanks, André -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 11:02 To: CF-Talk Subject: Re: Is it possible to achieve workflow in Coldfusion ??? Adam There is only one administrator or approver. How would you achieve this, do you have example code so I can see how it may function, how do you stop the data entering the database ?? As part of the submit page, have it save the document away with a flag 'pending'. - Original Message - From: Adam Reynolds [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:46 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, This is relatively simple. As part of the submit page, have it save the document away with a flag 'pending'. Is there just one administrator? Do you want different admin for different areas of the site? That is the real pain. You could have a pending approval page that admin can go to to see any pending pages. They could then view (AND edit) those pages before accepting the content or rejecting the comment. Adam -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 09:38 To: CF-Talk Subject: Is it possible to achieve workflow in Coldfusion ??? Hi I am trying to add a workflow element into a news application, and would just like to hear if anybody else on the list have been able to achieve this? or best practices on how to achieve this? I have an admin form that allows users to add news stories. At present when the form is submitted the data is entered into the database table. What I would like to achieve is when the user submits the form an e-mail is sent to
Bug? java.lang.StringIndexOutOfBoundsException: String index out of range: -3
Hello! I load a text/plain document via cfHTTP and the size is about one MegaByte. Now I have the following problem: cfset a_str_content = cfhttp.FileContent cfset a_str_content = ReplaceNoCase(a_str_content, !-- RESULT ITEM END - - , chr(9), ALL) If the http content is smaller (f.e. only 300kb) this works well, but if the file is bigger I receive the following error message: java.lang.StringIndexOutOfBoundsException: String index out of range: - 3 Is this a bug or limitation? Any workarounds? Updater 2 is installed. Best regards, Peter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Bug? java.lang.StringIndexOutOfBoundsException: String index out of range: -3
looks like a bug to me. Break up the string into chucks and check each chunk at a time. Horrible. WG -Original Message- From: Peter Mayer [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 13:20 To: CF-Talk Subject: Bug? java.lang.StringIndexOutOfBoundsException: String index out of range: -3 Hello! I load a text/plain document via cfHTTP and the size is about one MegaByte. Now I have the following problem: cfset a_str_content = cfhttp.FileContent cfset a_str_content = ReplaceNoCase(a_str_content, !-- RESULT ITEM END - - , chr(9), ALL) If the http content is smaller (f.e. only 300kb) this works well, but if the file is bigger I receive the following error message: java.lang.StringIndexOutOfBoundsException: String index out of range: - 3 Is this a bug or limitation? Any workarounds? Updater 2 is installed. Best regards, Peter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: calculating date recurrence
Looks like this will break on a leap year, though. Try calDays=DaysInYear(Now()); -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 4:54 PM To: CF-Talk Subject: RE: calculating date recurrence Matthew, thanks ... I modified what you showed me to the code below, and it works perfectly. cfscript calDays = 365; interval = form.TIME_INTERVAL; numEvents = calDays \ interval; variables.myDate = ArrayNew(1); variables.myDate[1] = #form.month#/#form.day#/#form.year#; for(i=1; i LTE numEvents; i=i+1) { arrayAppend(variables.myDate, dateAdd('d', i * interval, variables.myDate[1])); } variables.recurrence_type = Daily; /cfscript -Original Message- From: Matthew Walker [SMTP:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 5:53 PM To: CF-Talk Subject:RE: calculating date recurrence What are you trying to do? Create an array of dates for your recurring event? How about this...? cfset showEventsnDaysInAdvance = 365 cfset interval = 7 cfset numberOfEventsToShow = showEventsnDaysInAdvance \ interval cfset myDates = arrayNew(1) cfloop from=1 to=#numberOfEventsToShow# index=i cfset arrayAppend(myDates, dateAdd(d, i * interval, now())) /cfloop -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Friday, 28 February 2003 1:36 p.m. To: CF-Talk Subject: calculating date recurrence OK, I'm working on building my own calendar application. I'm trying to come up with a way of dealing with recurrence. The first step is to calculate -- event occures every n days apart, i.e., event occures every 3 days. Here's one way I've tried so far (but this is like chewing up all the processor time) variables.date = ArrayNew(1); variables.date[1] = #form.month#/#form.day#/#form.year#; for(i=1; i LTE 30; i=i+1) { x=1; while (i mod form.TIME_INTERVAL){ variables.date[x] = DateAdd(d, (form.TIME_INTERVAL-1)+x, variables.date[1]); x=x+1; } } Something else I tried, but it creates too many empty array elements: variables.date = ArrayNew(1); variables.date[1] = #form.month#/#form.day#/#form.year#; for(i=1; i LTE 30; i=i+1) { if (i mod TIME_INTERVAL){ } else { variables.date[i] = DateAdd(d, (TIME_INTERVAL-1)+i, variables.date[1]); } } I'm open to suggestions. H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MM : No Cookies = No Updater
Annoying : We have a machine which has cookies entirely disabled. We were installing CF and needed to upgrade; we tried to goto the MM site to get the second updater but with no cookies it is impossible via normal hyperlink / login means The updater should be available for all machines regardless of config! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Subscription billing management
Hi all, I have looked into building a subscription management application and have all of the basics covered. Payment Type, Subscription Length, Subscription Amount, Invoice, Invoice Items, Customer Info, Customer Billing Info, etc... I was wondering if anyone has something like this out there already. I've seen the application from 2simplifi.com but that's the only one I've seen. I'm looking for an open source app and will purchase it if necessary. Any help in this area would be much appreciated. Thanks, Jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT SQL Question
Can someone assist me with a quick SQL statement. I have a table with 3 columns: A, B, C (A would be the primary key) I need to swap the values in column B with the values in column C and vice versa. TIA, Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT SQL Question
SQL server ? use a format like this.. INSERT author_sales EXECUTE (' SELECT ''EXEC STRING'', authors.au_id, authors.au_lname, SUM(titles.price * sales.qty) FROM authors INNER JOIN titleauthor ON authors.au_id = titleauthor.au_id INNER JOIN titles ON titleauthor.title_id = titles.title_id INNER JOIN sales ON titles.title_id = sales.title_id WHERE authors.au_id like ''8%'' GROUP BY authors.au_id, authors.au_lname ') wg -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 14:36 To: CF-Talk Subject: OT SQL Question Can someone assist me with a quick SQL statement. I have a table with 3 columns: A, B, C (A would be the primary key) I need to swap the values in column B with the values in column C and vice versa. TIA, Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT SQL Question
SQL 7 does this still apply? -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:42 AM To: CF-Talk Subject: RE: OT SQL Question SQL server ? use a format like this.. INSERT author_sales EXECUTE (' SELECT ''EXEC STRING'', authors.au_id, authors.au_lname, SUM(titles.price * sales.qty) FROM authors INNER JOIN titleauthor ON authors.au_id = titleauthor.au_id INNER JOIN titles ON titleauthor.title_id = titles.title_id INNER JOIN sales ON titles.title_id = sales.title_id WHERE authors.au_id like ''8%'' GROUP BY authors.au_id, authors.au_lname ') wg -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 14:36 To: CF-Talk Subject: OT SQL Question Can someone assist me with a quick SQL statement. I have a table with 3 columns: A, B, C (A would be the primary key) I need to swap the values in column B with the values in column C and vice versa. TIA, Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT SQL Question
yeap actually simplier... INSERT t1 SELECT a as a , b as c ,c as b FROM t1 TEST b4 you do it WG -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 14:44 To: CF-Talk Subject: RE: OT SQL Question SQL 7 does this still apply? -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:42 AM To: CF-Talk Subject: RE: OT SQL Question SQL server ? use a format like this.. INSERT author_sales EXECUTE (' SELECT ''EXEC STRING'', authors.au_id, authors.au_lname, SUM(titles.price * sales.qty) FROM authors INNER JOIN titleauthor ON authors.au_id = titleauthor.au_id INNER JOIN titles ON titleauthor.title_id = titles.title_id INNER JOIN sales ON titles.title_id = sales.title_id WHERE authors.au_id like ''8%'' GROUP BY authors.au_id, authors.au_lname ') wg -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 14:36 To: CF-Talk Subject: OT SQL Question Can someone assist me with a quick SQL statement. I have a table with 3 columns: A, B, C (A would be the primary key) I need to swap the values in column B with the values in column C and vice versa. TIA, Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT SQL Question
Are you talking about a one time query to change the values stored in the DB? UPDATE tableName SET tableName.B = tableName.C, tableName.C = tableName.B WHERE tableName.A = tableName.A Adam. -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 8:36 AM To: CF-Talk Subject: OT SQL Question Can someone assist me with a quick SQL statement. I have a table with 3 columns: A, B, C (A would be the primary key) I need to swap the values in column B with the values in column C and vice versa. TIA, Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF5/CFMX/NT/UNIX ??
Before scrapping these machines, what kind of Suns are they? What models/# procs/specs? In my experience, a Sun e250 can handle similar traffic to a cluster of NT boxes. Sparc stations about 2 to 1 advantage on NT boxes. Does the AS400 connection need to be real time, or is it more for batch processing and periodic inventory database syncing? Last I used them, the AS400 odbc drivers were stable but slow from Cold Fusion 5. But if you've got Websphere running, it seems like CFMX might be a good addition to Websphere, rather than a replacement. So, no help from here, just more questions, Jerry Johnson [EMAIL PROTECTED] 02/28/03 05:11PM Hello Folks, Who out there has experience running CF in an NT environment and also a Unix environment on a LARGE scale? We were previously CF (4.5), and moved to Java (Websphere). Now there is question of going back to CF which is great. There are 24 Sun Solaris Machines onsite each with a license of CF5. 1) should they stick with CF5 2) should they move to CFMX 3) Should they scrap machines and move to NT?!? Also, the need to connect to an AS400 to get product information is critical (possible?) We do not have to get into this on the list if you would like to email me privately ... [EMAIL PROTECTED] Thank you Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT SQL Question
Can someone assist me with a quick SQL statement. I have a table with 3 columns: A, B, C (A would be the primary key) I need to swap the values in column B with the values in column C and vice versa. This should work with MS SQL assuming columns b and c are the same data type: UPDATE t1 SET b=c, c=b Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
App Suggestions
The company I work for is looking for an application that will let us create a document online based on an outline. The author should be able to modify the outline (move, delete and add sections) and the document would follow the changes in the outline. The outline would be shown as a tree menu on the left and the document would be on the right. The application should let us search a database of boilerplate text and select sections to be added to the document. We should also be able to manage the documents online. I have searched Macromedia's Developer Exchange and cfextras but I haven't found anything that meets all the requirements. thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: App Suggestions
Though SiteDirector is considered a Commerce application, it may fit your needs below. Our heirarchy is very flexible allowing multiple depths (unlimited) of a tree structure. So instead of thinking in Departments, content and products, you could think of the departments as steps in your outline Note the outline below this could be either an outline or a department structure. A. Men's Clothing 1 Shirts a) long sleeve 1a) button down 2b) henley b) short sleeve 2 Pants a) pleated b) non-pleated Each of the departments or outline points could have content associated with it ... Since SiteDirector is open source, you can modify the templates to provide the look and feel you are looking for. Just a suggestion ... let us know if you have any questions (off-list). Thank you Paul Giesenhagen QuillDesign - Original Message - From: Luis Lebron [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:16 AM Subject: App Suggestions The company I work for is looking for an application that will let us create a document online based on an outline. The author should be able to modify the outline (move, delete and add sections) and the document would follow the changes in the outline. The outline would be shown as a tree menu on the left and the document would be on the right. The application should let us search a database of boilerplate text and select sections to be added to the document. We should also be able to manage the documents online. I have searched Macromedia's Developer Exchange and cfextras but I haven't found anything that meets all the requirements. thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX DSN woes
I cannot for the life of me configure a DSN in the CF MX Administrator. I have tried to configure both an Oracle Native DSN (on a remote server) and an MS SQL Server 2000 DSN (on localhost) and get this error: Connection verification failed for data source: cm []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Interestingly, I get the same error for both the Oracle DSN and the MS SQL Server DSN. I have updated the JET and MDAC, and have run Updater 2. I am running MX Enterprise on localhost running the built-in web server on port 8500. Right now, I need to get the SQL Server DSN up and running. It gives me this error whether I have the database set up for no security or for a DB User with appropriate rights, and a userid/password assigned. I am using the following settings: DSN: cm database: cm (this is a database in my local instance of SQL Server) server: (local) port: 1433 username: system OR cm (system with only windows security set, cm with SQL Server auth set) password: [none] or password Everything else is default except I have Unicode enabled in the String Format checkbox and I have CLOB enabled. Can someone help me? Oddly, Access DSN's work fine. Thanks, Pete ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX DSN woes
CFMX will only connect to SQLServer databases setup for SQL Server logins... What happens if you try to set the DB up through the sa account? -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, March 3, 2003 15:36 To: CF-Talk Subject: CFMX DSN woes I cannot for the life of me configure a DSN in the CF MX Administrator. I have tried to configure both an Oracle Native DSN (on a remote server) and an MS SQL Server 2000 DSN (on localhost) and get this error: Connection verification failed for data source: cm []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Interestingly, I get the same error for both the Oracle DSN and the MS SQL Server DSN. I have updated the JET and MDAC, and have run Updater 2. I am running MX Enterprise on localhost running the built-in web server on port 8500. Right now, I need to get the SQL Server DSN up and running. It gives me this error whether I have the database set up for no security or for a DB User with appropriate rights, and a userid/password assigned. I am using the following settings: DSN: cm database: cm (this is a database in my local instance of SQL Server) server: (local) port: 1433 username: system OR cm (system with only windows security set, cm with SQL Server auth set) password: [none] or password Everything else is default except I have Unicode enabled in the String Format checkbox and I have CLOB enabled. Can someone help me? Oddly, Access DSN's work fine. Thanks, Pete ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Ann: Cost Effective Content Management Free Seminar
Cost: FREE March 6th: Atlanta GA March 18th: Washington, DC More info and registration at http://training.figleaf.com/figleaftraining/Courses/freecms.cfm For all you CMS vendors out there who would like me to review your products for future inclusion in this seminar, please contact me off-list. Course Objectives -Review the capabilities you should be looking for in a content management system -Compare and contrast the functionality and price points of four industry-leading content management systems -Build awareness of common pitfalls that may occur during CMS implementations and deployments Course Outline -What is content management? -Content management principals -Content management pitfalls -Comparing and contrasting four CM Solutions Macromedia Contribute Ektron CMS 100/200/300 Paperthin CommonSpot 3.2 Microsoft Content Management Server 2002 --- Quotes from prior attendees: The seminar format was useful too. Started out with a broad introduction, then demos of Macromedia Contribute with a little DreamWeaver thrown in, Ektron (with details of the gotchas in the 3 different products), CommonSpot, and MS CMS 2002 (which I knew would bore me to tears, so I left before that demo started). All in all, it was a useful seminar. I sat through Fig Leaf's free CMS seminar. It was extremely informative for me and my team, focusing on the evaluation criteria as much as anything else. More importantly, the presenter (Steve Drucker) was without preference for a single solution. I'd highly recommend that if you are just getting started in your CMS journey, you should consider sitting through Steve's session. Regards, Steve Drucker CEO Fig Leaf Software www.figleaf.com 1-877-FIG-LEAF ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX DSN woes
I am using the following settings: DSN: cm database: cm (this is a database in my local instance of SQL Server) server: (local) Try the IP address or FQDN - I don't think JDBC recognizes (local). port: 1433 username: system OR cm (system with only windows security set, cm with SQL Server auth set) password: [none] or password You can't use Windows security, only SQL Server logins. You might want to test the account from the ODBC control panel, by setting up an ODBC datasource for testing. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX DSN woes
That, and changing the server name to my machine name in all caps did the trick. Thanks! The Oracle issue persists, but I would prefer to prototype with SQL Server anyway... Pete - Original Message - From: Mike Townend [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 10:38 AM Subject: RE: CFMX DSN woes CFMX will only connect to SQLServer databases setup for SQL Server logins... What happens if you try to set the DB up through the sa account? -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, March 3, 2003 15:36 To: CF-Talk Subject: CFMX DSN woes I cannot for the life of me configure a DSN in the CF MX Administrator. I have tried to configure both an Oracle Native DSN (on a remote server) and an MS SQL Server 2000 DSN (on localhost) and get this error: Connection verification failed for data source: cm []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Interestingly, I get the same error for both the Oracle DSN and the MS SQL Server DSN. I have updated the JET and MDAC, and have run Updater 2. I am running MX Enterprise on localhost running the built-in web server on port 8500. Right now, I need to get the SQL Server DSN up and running. It gives me this error whether I have the database set up for no security or for a DB User with appropriate rights, and a userid/password assigned. I am using the following settings: DSN: cm database: cm (this is a database in my local instance of SQL Server) server: (local) port: 1433 username: system OR cm (system with only windows security set, cm with SQL Server auth set) password: [none] or password Everything else is default except I have Unicode enabled in the String Format checkbox and I have CLOB enabled. Can someone help me? Oddly, Access DSN's work fine. Thanks, Pete ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX DSN woes
Actually, you can use trusted connections (Windows Authentication) with SQL Server, however CFMX will only connect using the account that it is running as. We have Domain level service accounts for all our CFMX installations. If you want to use a Trusted Connection you have to run CFMX as a named user. System (which is the Default for CFMX) cannot participate in a domain or any network sharing for that matter... Otherwise Mike is correct. You have to enable SQL Server logins. As for Oracle... ??? Don't work with it. Jeff - Original Message - From: Mike Townend [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 8:38 AM Subject: RE: CFMX DSN woes CFMX will only connect to SQLServer databases setup for SQL Server logins... What happens if you try to set the DB up through the sa account? -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, March 3, 2003 15:36 To: CF-Talk Subject: CFMX DSN woes I cannot for the life of me configure a DSN in the CF MX Administrator. I have tried to configure both an Oracle Native DSN (on a remote server) and an MS SQL Server 2000 DSN (on localhost) and get this error: Connection verification failed for data source: cm []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Interestingly, I get the same error for both the Oracle DSN and the MS SQL Server DSN. I have updated the JET and MDAC, and have run Updater 2. I am running MX Enterprise on localhost running the built-in web server on port 8500. Right now, I need to get the SQL Server DSN up and running. It gives me this error whether I have the database set up for no security or for a DB User with appropriate rights, and a userid/password assigned. I am using the following settings: DSN: cm database: cm (this is a database in my local instance of SQL Server) server: (local) port: 1433 username: system OR cm (system with only windows security set, cm with SQL Server auth set) password: [none] or password Everything else is default except I have Unicode enabled in the String Format checkbox and I have CLOB enabled. Can someone help me? Oddly, Access DSN's work fine. Thanks, Pete ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX DSN woes
ACK... my bad, the only way to do Trusted connections is by using the JDBC:ODBC Bridge in CFMX. (You have to set up a SQL Server ODBC connection on the server). Sorry for the confusion... need more coffee... Jeff - Original Message - From: Jeff Garza [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 03, 2003 8:54 AM Subject: Re: CFMX DSN woes Actually, you can use trusted connections (Windows Authentication) with SQL Server, however CFMX will only connect using the account that it is running as. We have Domain level service accounts for all our CFMX installations. If you want to use a Trusted Connection you have to run CFMX as a named user. System (which is the Default for CFMX) cannot participate in a domain or any network sharing for that matter... Otherwise Mike is correct. You have to enable SQL Server logins. As for Oracle... ??? Don't work with it. Jeff - Original Message - From: Mike Townend [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 8:38 AM Subject: RE: CFMX DSN woes CFMX will only connect to SQLServer databases setup for SQL Server logins... What happens if you try to set the DB up through the sa account? -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, March 3, 2003 15:36 To: CF-Talk Subject: CFMX DSN woes I cannot for the life of me configure a DSN in the CF MX Administrator. I have tried to configure both an Oracle Native DSN (on a remote server) and an MS SQL Server 2000 DSN (on localhost) and get this error: Connection verification failed for data source: cm []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Interestingly, I get the same error for both the Oracle DSN and the MS SQL Server DSN. I have updated the JET and MDAC, and have run Updater 2. I am running MX Enterprise on localhost running the built-in web server on port 8500. Right now, I need to get the SQL Server DSN up and running. It gives me this error whether I have the database set up for no security or for a DB User with appropriate rights, and a userid/password assigned. I am using the following settings: DSN: cm database: cm (this is a database in my local instance of SQL Server) server: (local) port: 1433 username: system OR cm (system with only windows security set, cm with SQL Server auth set) password: [none] or password Everything else is default except I have Unicode enabled in the String Format checkbox and I have CLOB enabled. Can someone help me? Oddly, Access DSN's work fine. Thanks, Pete ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX DSN woes
Pete, There is a patch floating around somewhere for CF's administrator which gives you more meaningful error messages when connecting to data sources other than the generic JDBC pool error. Search macromedia.com For SQL Server: 1) Make sure you are using Mixed Mode Authentication (not Windows only). 2) Make sure your password is not more than 16 chars. 3) Do not use (local) as the server. Hope this helps. Setting up a SQL data source should be a snap. Thanks, André -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 15:36 To: CF-Talk Subject: CFMX DSN woes I cannot for the life of me configure a DSN in the CF MX Administrator. I have tried to configure both an Oracle Native DSN (on a remote server) and an MS SQL Server 2000 DSN (on localhost) and get this error: Connection verification failed for data source: cm []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Interestingly, I get the same error for both the Oracle DSN and the MS SQL Server DSN. I have updated the JET and MDAC, and have run Updater 2. I am running MX Enterprise on localhost running the built-in web server on port 8500. Right now, I need to get the SQL Server DSN up and running. It gives me this error whether I have the database set up for no security or for a DB User with appropriate rights, and a userid/password assigned. I am using the following settings: DSN: cm database: cm (this is a database in my local instance of SQL Server) server: (local) port: 1433 username: system OR cm (system with only windows security set, cm with SQL Server auth set) password: [none] or password Everything else is default except I have Unicode enabled in the String Format checkbox and I have CLOB enabled. Can someone help me? Oddly, Access DSN's work fine. Thanks, Pete ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX for J2EE on JRun 4
Hello, i didnt understand some things about CFMX for J2EE: - how to use it without context_root? - does it works with subdirs in URL? Sincerely, Roman Krutyakov mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFINPUT required=yes fails in MX?
It appears that the required=yes option no longer works in cfinput on MX...? I haven't used cfinput in over a year, but a co-worker just noticed this behaviour on our new MX development box. cfform name=myForm action=blank.cfm cfinput name=test required=Yes message=Enter something, dumbo input type=submit name=submit value=submit /cfform The above form is submitted even when test is blank. Ricq Pattay Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFINPUT required=yes fails in MX?
Never mind, our server guy fixed it. The file form.js was not in the expected place because of a virtual server issue. Adding a /CFIDE/ alias to the apache conf file fixed the problem. - Original Message - From: Ricq Pattay [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 10:38 AM Subject: CFINPUT required=yes fails in MX? It appears that the required=yes option no longer works in cfinput on MX...? I haven't used cfinput in over a year, but a co-worker just noticed this behaviour on our new MX development box. cfform name=myForm action=blank.cfm cfinput name=test required=Yes message=Enter something, dumbo input type=submit name=submit value=submit /cfform The above form is submitted even when test is blank. Ricq Pattay Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF 5.0 Admin switched to CF 4.5 Express Admin - how can I get bac k CF 5.0 Admin?
Our CF 5.0 development server was hit with nimda. We are running CF 5.0 SP2. Since our server guys ran the nimda fix, instead of getting the CF 5.0 Administrator we get the CF 4.5 Express Administrator! If I go to the Version Info page in the CF 4.5 Express Admin it shows the version as 5.0, Service Pack 2, Build 2195 and the serial number is correct. How should I fix this? Is there a way I can replace the CF 4.5 Express Admin with the original CF 5.0 Admin without having to reinstall CF 5.0? Or should I be suspect of the CF 5.0 install and reinstall it anyway? If the latter, where can I find SP2 for CF 5.0? I went to the download pages for CF and all I see is individual Hot Fixes, no SP2 . . . Thanks! George ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Question about Datasources and connections
Hi, I was wondering if anyone might be able to assist me. I have been having problems lately with my CF server returning the following error messages: Unable to instantiate environment for 'ORACLE80.' Unable to instantiate environment for 'ODBC.' It seems to be happening more and more lately and I have been unable to find a solution. I am currently running Cf 4.5 on Windows NT. I use either or Oracle or SqlServer depending on the application. I can send more information if needed (like timeout request and such as soon as get an admin to look into the setting). I am just wondering what might be causing these errors. I was told to use the Native Drivers for Oracle and OLE-DB for my SQLServer connections. Is this correct or should I be using ODBC for SqlServer. My DBA's will not let me use ODBC for Oracle - only native Drivers. Thanks in advance, Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX Updater 2 to blame?
Hey All, I saw a few threads in Google Groups on this, but not enough to solve my problem (Jochem if you're out thereyou helped someone else with the same problem). I'm able to setup SQL2K datasources using Windows Datasource utility just fine, but they don't show in CF Admin. If I try and add them through CF Admin I get this: Connection verification failed for data source: RightStuffDatingDB []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. - The thread I saw referenced a file called jrpatch.jar, but doesn't say where to get it or what to do with it (although I know it's installed with CFMX). So any help would be great because not being able to add datasources is a tad limiting ;-) TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
What CF version are the CF server behaviors in DWMX?
Are the CF server behaviors that come with Dreamweaver MX written specifically for CFMX? If we are still using CF 5.0 should we avoid using these server behaviors? (I'm sure some think we should avoid using the behaviors regardless of version considerations . . . but I have to ask the question.) Thanks! George [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 5.0 Admin switched to CF 4.5 Express Admin - how can I get bac k CF 5.0 Admin?
Our CF 5.0 development server was hit with nimda. We are running CF 5.0 SP2. Since our server guys ran the nimda fix, instead of getting the CF 5.0 Administrator we get the CF 4.5 Express Administrator! If I go to the Version Info page in the CF 4.5 Express Admin it shows the version as 5.0, Service Pack 2, Build 2195 and the serial number is correct. How should I fix this? Is there a way I can replace the CF 4.5 Express Admin with the original CF 5.0 Admin without having to reinstall CF 5.0? Or should I be suspect of the CF 5.0 install and reinstall it anyway? If the latter, where can I find SP2 for CF 5.0? I went to the download pages for CF and all I see is individual Hot Fixes, no SP2 . . . First, the CF Administrator is just a web application, so as long as you can find the CF 5 version of it floating around, just put it in the right place and it'll work. Second, those version and SP numbers refer to Windows, I think, not CF. You're running Win2K SP2. I don't think there is an SP2 for CF5. Let me know offlist if you need any assistance. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Updater 2 to blame?
Bryan, Did you try the usual: 1) Make sure you're using mixed mode authentication on SQL server. 2) Make sure your passwords are not more than 16 chars. 3) Make sure you aren't using (local) as the server etc. Thanks, André PS Good luck with the dating web app! -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 17:59 To: CF-Talk Subject: CFMX Updater 2 to blame? Hey All, I saw a few threads in Google Groups on this, but not enough to solve my problem (Jochem if you're out thereyou helped someone else with the same problem). I'm able to setup SQL2K datasources using Windows Datasource utility just fine, but they don't show in CF Admin. If I try and add them through CF Admin I get this: Connection verification failed for data source: RightStuffDatingDB []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. - The thread I saw referenced a file called jrpatch.jar, but doesn't say where to get it or what to do with it (although I know it's installed with CFMX). So any help would be great because not being able to add datasources is a tad limiting ;-) TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Updater 2 to blame?
I'm able to setup SQL2K datasources using Windows Datasource utility just fine, but they don't show in CF Admin. Are you using SQL Server logins, or Windows Authentication? You have to use SQL Server logins. Are you using default or named SQL Server instances? If you're using named instances, they'll be listening at non-default ports, and you'll have to have installed SQL Server SP2 or higher. Did you specify the IP address and port of the server in the CF Administrator? You can't use Windows machine names, unless they also resolve via DNS. If you post your datasource information, it might help. The jrpatch.jar file just gives you more verbose error information, but you can probably solve your problem without it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Updater 2 to blame?
The diagnostic jar file can be found here: http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602Method=Full chris -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:59 AM To: CF-Talk Subject: CFMX Updater 2 to blame? Hey All, I saw a few threads in Google Groups on this, but not enough to solve my problem (Jochem if you're out thereyou helped someone else with the same problem). I'm able to setup SQL2K datasources using Windows Datasource utility just fine, but they don't show in CF Admin. If I try and add them through CF Admin I get this: Connection verification failed for data source: RightStuffDatingDB []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. - The thread I saw referenced a file called jrpatch.jar, but doesn't say where to get it or what to do with it (although I know it's installed with CFMX). So any help would be great because not being able to add datasources is a tad limiting ;-) TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cookie expiration date seems incorrect
From last week: Tested the cookie-setting page with the Httpanalyzer. It (header info) does show the cookie being set as I wanted it, and I can see the correct expiration date. I reverted back to original code to simply set the expires attribute (on cfcookie) as 30 (for 30 days). All looked fine. I guess I can only see the cookie information in the header of the template where the cookie is actually being set. There isn't a *cookie reader* that can give expiration date, etc.? Thanks for help, Dave. Helped me clarify what was going on and with a tool to gather information. E. Keith Dodd Wings of Eagles Services www.wingserv.com First, when you set the expiration date, that information is sent to the browser, but not returned when the browser sends the cookie back to the server. It's only used by the browser to determine when it should get rid of the cookie. So, you won't see that information anywhere in your CF variables, using CFDUMP. Second, when you set a cookie, the browser sees something like this: Set-Cookie: CFID=251232; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; This HTTP header contains all the information for the cookie, including the expiration date. When you use EXPIRES=NEVER, as in the above example, the cookie is actually set to expire in the relatively distant future, many years from now. Now, when I used CFCOOKIE like so: cfcookie name=foo value=bar expires=2/27/2002 it generated this: Set-Cookie: FOO=bar;expires=Wed, 27-Feb-2002 22:22:05 GMT;path=/ You might find it useful to look at these HTTP headers. One easy way to do that is with HTTP Analyzer: http://ftp.coolfusion.com/pub/ods/httpanalyzer/httpanalyzer.zip You may also want to play around with different date formats; I seem to recall just generating a valid GMT date myself in the past, and using that, but it's been a while. Finally, if you want the cookie to expire in 30 days, why not just say so? cfcookie name=foo value=bar expires=30 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 - [This E-mail scanned for viruses by declude AntiVirus Software] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF5/CFMX/NT/UNIX ??
On Monday, Mar 3, 2003, at 06:55 US/Pacific, Jerry Johnson wrote: But if you've got Websphere running, it seems like CFMX might be a good addition to Websphere, rather than a replacement. I'd second that. CFMX for J2EE WebSphere edition. Protects the investment in hardware and software already made and provides all the benefits of both J2EE and CFMX. [EMAIL PROTECTED] 02/28/03 05:11PM Who out there has experience running CF in an NT environment and also a Unix environment on a LARGE scale? Out of curiosity, define LARGE. There are 24 Sun Solaris Machines onsite each with a license of CF5. It would be interesting to know what sort of spec these are? 1) should they stick with CF5 So you're running both CF5 *and* WebSphere? You mentioned you were running CF4.5 before. 2) should they move to CFMX See above. CFMX on WebSphere would seem a good choice. 3) Should they scrap machines and move to NT?!? What are they running WebSphere on? Unix or NT? Buying enough NT iron to match the compute power of those Sun boxes could prove pretty expensive. Macromedia is pretty much all Solaris in production and Allaire was all Windows so one of the questions after the merger was whether to move to Windows. In order to support our traffic levels on Windows, we would have spent a lot of money buying additional hardware. Furthermore, the majority of our IT staff are more familiar with Unix than Windows, from a development and production point of view, so there would have needed to be quite a bit of training involved. Windows would have been a very expensive change for us. The systems that we inherited from Allaire still run on Windows but as we introduce new systems to replace those, they will most likely be deployed on our Solaris infrastructure. Note: in case it needs saying, I'm talking about Macromedia IT who build and support the website, as opposed to Macromedia product teams who develop CF, JRun etc. Also, the need to connect to an AS400 to get product information is critical (possible?) At least one person on this list has CFMX talking to an AS400 so hopefully they'll chime in. We do not have to get into this on the list if you would like to email me privately I think it will be interesting to hear people's experiences. Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What CF version are the CF server behaviors in DWMX?
Are the CF server behaviors that come with Dreamweaver MX written specifically for CFMX? If we are still using CF 5.0 should we avoid using these server behaviors? (I'm sure some think we should avoid using the behaviors regardless of version considerations . . . but I have to ask the question.) Thanks! So far, all the ones I've looked at work fine with CF 5. I thought that the authentication ones might use CFLOGIN, which is new to CFMX, but they apparently don't. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOLVED: Re: CFMX Updater 2 to blame?
Dave helped me offlist... I had to use SQL Server Authentication when setting up the datasource in Windows ODBC. Thanks Dave and all that replied Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Dave Watts [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 03, 2003 10:04 AM Subject: RE: CFMX Updater 2 to blame? I'm able to setup SQL2K datasources using Windows Datasource utility just fine, but they don't show in CF Admin. Are you using SQL Server logins, or Windows Authentication? You have to use SQL Server logins. Are you using default or named SQL Server instances? If you're using named instances, they'll be listening at non-default ports, and you'll have to have installed SQL Server SP2 or higher. Did you specify the IP address and port of the server in the CF Administrator? You can't use Windows machine names, unless they also resolve via DNS. If you post your datasource information, it might help. The jrpatch.jar file just gives you more verbose error information, but you can probably solve your problem without it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF5/CFMX/NT/UNIX ??
Sean, Please read below! - Original Message - From: Sean A Corfield [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:18 AM Subject: Re: CF5/CFMX/NT/UNIX ?? On Monday, Mar 3, 2003, at 06:55 US/Pacific, Jerry Johnson wrote: But if you've got Websphere running, it seems like CFMX might be a good addition to Websphere, rather than a replacement. I'd second that. CFMX for J2EE WebSphere edition. Protects the investment in hardware and software already made and provides all the benefits of both J2EE and CFMX. We are running WebSphere on an AS400 -- So we need to have our CFMX machines talk to the DB2 DB [EMAIL PROTECTED] 02/28/03 05:11PM Who out there has experience running CF in an NT environment and also a Unix environment on a LARGE scale? Out of curiosity, define LARGE. 50,000 uniques and above per day. 30,000 product sku's There are 24 Sun Solaris Machines onsite each with a license of CF5. It would be interesting to know what sort of spec these are? The are Sun 450's - 4 processor machines 1) should they stick with CF5 So you're running both CF5 *and* WebSphere? You mentioned you were running CF4.5 before. We are running CF5 ...for some applications and WebSphere powers the commerce site 2) should they move to CFMX See above. CFMX on WebSphere would seem a good choice. 3) Should they scrap machines and move to NT?!? What are they running WebSphere on? Unix or NT? Buying enough NT iron to match the compute power of those Sun boxes could prove pretty expensive. Macromedia is pretty much all Solaris in production and Allaire was all Windows so one of the questions after the merger was whether to move to Windows. In order to support our traffic levels on Windows, we would have spent a lot of money buying additional hardware. Furthermore, the majority of our IT staff are more familiar with Unix than Windows, from a development and production point of view, so there would have needed to be quite a bit of training involved. Windows would have been a very expensive change for us. The systems that we inherited from Allaire still run on Windows but as we introduce new systems to replace those, they will most likely be deployed on our Solaris infrastructure. Note: in case it needs saying, I'm talking about Macromedia IT who build and support the website, as opposed to Macromedia product teams who develop CF, JRun etc. The problem today is that our 5 different Sun machines are rebooted automatically ever 20 minutes. If they don't about every 30 minutes all the memory leaks out and the machines lock up. My comment about this is that there are so many people running cf5 in the same environment, why can't we keep our systems running. The group is pretty stuborn about being wrong .. it's easier to blame MM ... becauase Allaire CF 4.0 ran pretty bad on the Suns. Also, the need to connect to an AS400 to get product information is critical (possible?) At least one person on this list has CFMX talking to an AS400 so hopefully they'll chime in. I would love to hear from them. We do not have to get into this on the list if you would like to email me privately I think it will be interesting to hear people's experiences. We shall see Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: blue dragon and coolfusion iMS
Yes with ActivMail you can use a ColdFusion query to supply the email addresses, or a list. You can also personalize the content in the message using the query columns. Is that what you mean by Does it handle mailing lists? _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 7:30 PM To: CF-Talk Subject: RE: blue dragon and coolfusion iMS Does it handle mailing lists? H. -Original Message- From: Pete Freitag [SMTP:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 4:37 PM To: CF-Talk Subject: RE: blue dragon and coolfusion iMS Is anybody running iMS on a Blue Dragon server? How's the performance? Do they work well and play well together? Have they been tested together? If you need a high end email solution for Blue Dragon ActivMail works great on it. It's written in Java, so it should work on all but the free versions of BD. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: blue dragon and coolfusion iMS
I mean a CF-Talk type of mailing list ... a discussion list. H. -Original Message- From: Pete Freitag [SMTP:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 10:46 AM To: CF-Talk Subject: RE: blue dragon and coolfusion iMS Yes with ActivMail you can use a ColdFusion query to supply the email addresses, or a list. You can also personalize the content in the message using the query columns. Is that what you mean by Does it handle mailing lists? _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 7:30 PM To: CF-Talk Subject: RE: blue dragon and coolfusion iMS Does it handle mailing lists? H. -Original Message- From: Pete Freitag [SMTP:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 4:37 PM To: CF-Talk Subject:RE: blue dragon and coolfusion iMS Is anybody running iMS on a Blue Dragon server? How's the performance? Do they work well and play well together? Have they been tested together? If you need a high end email solution for Blue Dragon ActivMail works great on it. It's written in Java, so it should work on all but the free versions of BD. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: blue dragon and coolfusion iMS
Oh, you could certainly send the messages with it, but there is nothing built-in to receive the messages. So to answer your question: no, not out of the box. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 1:26 PM To: CF-Talk Subject: RE: blue dragon and coolfusion iMS I mean a CF-Talk type of mailing list ... a discussion list. H. -Original Message- From: Pete Freitag [SMTP:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 10:46 AM To: CF-Talk Subject: RE: blue dragon and coolfusion iMS Yes with ActivMail you can use a ColdFusion query to supply the email addresses, or a list. You can also personalize the content in the message using the query columns. Is that what you mean by Does it handle mailing lists? _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 7:30 PM To: CF-Talk Subject: RE: blue dragon and coolfusion iMS Does it handle mailing lists? H. -Original Message- From: Pete Freitag [SMTP:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 4:37 PM To: CF-Talk Subject:RE: blue dragon and coolfusion iMS Is anybody running iMS on a Blue Dragon server? How's the performance? Do they work well and play well together? Have they been tested together? If you need a high end email solution for Blue Dragon ActivMail works great on it. It's written in Java, so it should work on all but the free versions of BD. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX and debug output
Hey All, I haven't been using my local box for development for a while (working off client machines). Anyways, I was happily cleaning up my local dev environment and found that debugging doesn't seem to be working in MX!! Anybody run across this one? I'm on Win2K/IIS/CFMX w/ updater 2 I've got these addresses in for debugging: -localhost -127.0.0.1 -the internal IP and the external IP of the server -debugging is turned on TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
dynamically created session variables
I'm trying to load form variables into session variables in an application...but I'm having problems with the creating dynamically created session variable names. Any help is appreciated. CFLOOP index=FieldName list=#Form.FieldNames# CFLOCK TIMEOUT=30 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=SESSION CFSET Session.#FieldName# = #Evaluate(FieldName)# /CFLOCK /CFLOOP Thanks, Ali --- This message (including any attachments) may contain confidential and privileged information. If you are not the intended recipient, please notify the sender and delete all copies of the original message without using or disclosing it. Thank you. --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about Datasources and connections
Mario, I'll be happy to assist offline if you send me more detailed problem description. Don Li --- Ciliotta, Mario [EMAIL PROTECTED] wrote: Hi, I was wondering if anyone might be able to assist me. I have been having problems lately with my CF server returning the following error messages: Unable to instantiate environment for 'ORACLE80.' Unable to instantiate environment for 'ODBC.' It seems to be happening more and more lately and I have been unable to find a solution. I am currently running Cf 4.5 on Windows NT. I use either or Oracle or SqlServer depending on the application. I can send more information if needed (like timeout request and such as soon as get an admin to look into the setting). I am just wondering what might be causing these errors. I was told to use the Native Drivers for Oracle and OLE-DB for my SQLServer connections. Is this correct or should I be using ODBC for SqlServer. My DBA's will not let me use ODBC for Oracle - only native Drivers. Thanks in advance, Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dynamically created session variables
-Original Message- From: Ali Daniali [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 1:48 PM To: CF-Talk Subject: dynamically created session variables I'm trying to load form variables into session variables in an application...but I'm having problems with the creating dynamically created session variable names. Any help is appreciated. CFLOOP index=FieldName list=#Form.FieldNames# CFLOCK TIMEOUT=30 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=SESSION CFSET Session.#FieldName# = #Evaluate(FieldName)# /CFLOCK /CFLOOP Thanks, Ali --- This message (including any attachments) may contain confidential and privileged information. If you are not the intended recipient, please notify the sender and delete all copies of the original message without using or disclosing it. Thank you. --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dynamically created session variables
Try this: CFSET Session.#FieldName# = Evaluate(FieldName) -Original Message- From: Ali Daniali [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 1:48 PM To: CF-Talk Subject: dynamically created session variables I'm trying to load form variables into session variables in an application...but I'm having problems with the creating dynamically created session variable names. Any help is appreciated. CFLOOP index=FieldName list=#Form.FieldNames# CFLOCK TIMEOUT=30 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=SESSION CFSET Session.#FieldName# = #Evaluate(FieldName)# /CFLOCK /CFLOOP Thanks, Ali --- This message (including any attachments) may contain confidential and privileged information. If you are not the intended recipient, please notify the sender and delete all copies of the original message without using or disclosing it. Thank you. --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
verity and PDF's
Has anyone ever had a PDF with 'selectable text' that verity will show as being indexed, but won't return in the results when searched for? When I say selectable text, I mean that I can open it up in acrobat reader, click on the text cursor button 'T', and then swipe blocks of text - there may be an official term for this. When I dump the results of a blank search, it's showing up but the summary field is blank. I'm assuming this has something to do with it? Is there anything special I should look for in the PDF that would prevent its text from being exposed to verity - I've got about 300 others that are working just fine. Any help would be appreciated. Adam. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
dynamically created session variables
When I make this change I get the following error: A CFML variable name cannot end with a . character. The variable Session. ends with a . character. You must supply an additional structure key or delete the . character. The CFML compiler was processing: a CFSET tag beginning on line 3, column 18. a CFSET tag beginning on line 3, column 18. The Error Occurred in : line 3 1 : CFLOOP index=FieldName list=#Form.FieldNames# 2 : CFLOCK TIMEOUT=30 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=SESSION 3 : CFSET Session.#FieldName# = #Evaluate(FieldName)# 4 : /CFLOCK 5 : /CFLOOP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
dynamically created session variables
I see my mistake I need to have double quotes around Session.#FieldName# ...now it works. Thanks, Ali ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Need help configuring web server CF
I'm a newbie to server admin, I configured cf to use a new webserver per the docs. I have a webserver whose webroot is /soft/www/test. The new webserver has a webroot of /soft/www/mytest. I created a mapping /new/ /soft/www/mytest; but that did not work. What else do I need to do for this new webserver to be able to see the cfm pages. Let give you more details ORIGINAL --site = http://workarea.senecac.on.ca NEW SITE -site =http://saturn.senecac.on.ca:85/testing --click on JavaCFXMacromediaDemo+ Both are iplanet webservers. cfm pages displays perfectly on http://workarea.senecac.on.ca. TIA, Ron ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dynamically created session variables
IIRC, you need to do cfset session[#fieldname#] = evaluate(fieldname) -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Ali Daniali [mailto:[EMAIL PROTECTED] : Sent: Monday, March 03, 2003 1:48 PM : To: CF-Talk : Subject: dynamically created session variables : : : I'm trying to load form variables into session variables in an : application...but I'm having problems with the creating : dynamically created : session variable names. Any help is appreciated. : : CFLOOP index=FieldName list=#Form.FieldNames# : CFLOCK TIMEOUT=30 THROWONTIMEOUT=No TYPE=EXCLUSIVE : SCOPE=SESSION : CFSET Session.#FieldName# = #Evaluate(FieldName)# : /CFLOCK : /CFLOOP : : Thanks, : Ali : : --- : This message (including any attachments) may contain : confidential and privileged information. If you are : not the intended recipient, please notify the sender : and delete all copies of the original message without : using or disclosing it. Thank you. : --- : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: calculating date recurrence
Actually that variable is just the number of days to look ahead, so it won't break it. - Original Message - From: Everett, Al [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 2:37 AM Subject: RE: calculating date recurrence Looks like this will break on a leap year, though. Try calDays=DaysInYear(Now()); -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 4:54 PM To: CF-Talk Subject: RE: calculating date recurrence Matthew, thanks ... I modified what you showed me to the code below, and it works perfectly. cfscript calDays = 365; interval = form.TIME_INTERVAL; numEvents = calDays \ interval; variables.myDate = ArrayNew(1); variables.myDate[1] = #form.month#/#form.day#/#form.year#; for(i=1; i LTE numEvents; i=i+1) { arrayAppend(variables.myDate, dateAdd('d', i * interval, variables.myDate[1])); } variables.recurrence_type = Daily; /cfscript -Original Message- From: Matthew Walker [SMTP:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 5:53 PM To: CF-Talk Subject: RE: calculating date recurrence What are you trying to do? Create an array of dates for your recurring event? How about this...? cfset showEventsnDaysInAdvance = 365 cfset interval = 7 cfset numberOfEventsToShow = showEventsnDaysInAdvance \ interval cfset myDates = arrayNew(1) cfloop from=1 to=#numberOfEventsToShow# index=i cfset arrayAppend(myDates, dateAdd(d, i * interval, now())) /cfloop -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Friday, 28 February 2003 1:36 p.m. To: CF-Talk Subject: calculating date recurrence OK, I'm working on building my own calendar application. I'm trying to come up with a way of dealing with recurrence. The first step is to calculate -- event occures every n days apart, i.e., event occures every 3 days. Here's one way I've tried so far (but this is like chewing up all the processor time) variables.date = ArrayNew(1); variables.date[1] = #form.month#/#form.day#/#form.year#; for(i=1; i LTE 30; i=i+1) { x=1; while (i mod form.TIME_INTERVAL){ variables.date[x] = DateAdd(d, (form.TIME_INTERVAL-1)+x, variables.date[1]); x=x+1; } } Something else I tried, but it creates too many empty array elements: variables.date = ArrayNew(1); variables.date[1] = #form.month#/#form.day#/#form.year#; for(i=1; i LTE 30; i=i+1) { if (i mod TIME_INTERVAL){ } else { variables.date[i] = DateAdd(d, (TIME_INTERVAL-1)+i, variables.date[1]); } } I'm open to suggestions. H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
recurrence engine
Thanks to all who helped figure some of this stuff out. FWIW: Here's the calendar recurrence engine I built: cfscript // events may or may not have an end_date if (Len(form.day_end)) { end_date = #form.month_end#/#form.day_end#/#form.year_end#; } else { end_date = 'NULL'; } // run through case statements for which kind of recurrance this is switch (#form.RECURRENCE_TYPE#) { // if onetime date entry, create a single element array case OneTime: { mydate = ArrayNew(1); mydate[1] = #form.month#/#form.day#/#form.year#; // get the final date of the array finalDate=myDate[arrayLen(myDate)]; break; } case Daily: { calDays = 365; interval = form.TIME_INTERVAL_daily; numEvents = calDays \ interval; myDate = ArrayNew(1); myDate[1] = #form.month#/#form.day#/#form.year#; for(i=1; i LTE numEvents; i=i+1) { arrayAppend(myDate, dateAdd('d', i * interval,myDate[1])); } // get the final date of the array finalDate=myDate[arrayLen(myDate)]; break; } case Weekly: { calDays = 365; interval = form.TIME_INTERVAL_weekly; numEvents = calDays \ interval; numEvents = numEvents \ 7; myDate = ArrayNew(1); myDate[1] = #form.month#/#form.day#/#form.year#; for(i=1; i LTE numEvents; i=i+1) { arrayAppend(myDate, dateAdd('d', (i * 7) * interval,myDate[1])); } // get the final date of the array finalDate=myDate[arrayLen(myDate)]; break; } case Monthly: { // calculate month recurrence // udf can be found here: http://www.cflib.org/udf.cfm?ID=179 // udf modified to loop over 12 months past a change of year ... calMonths = 12; interval = form.TIME_INTERVAL_monthly; numEvents = calMonths \ interval; firstDate = DayOfWeek('#form.month#/#form.day#/#form.year#'); /* check to see if pattern is specific date of each month, * or Nth occurance of each day of the month */ if (form.PATTERN is specificdate){ // create array and seed with first date myDate = ArrayNew(1); myDate[1] = '#form.month#/#form.day#/#form.year#'; // loop over number of events for the year and create date-specific array for(i=1; i LTE numEvents; i=i+1) { arrayAppend(myDate, dateAdd('m', i * interval,myDate[1])); } } Else { // or use UDF to get the Nth day of the month for each month for a year out startDate = GetNthOccOfDayInMonth(form.EVERY_N, firstDate, form.Month, form.Year); // create array and seed with first date myDate = ArrayNew(1); myDate[1] = #form.month#/#startDate#/#form.year#; /* loop over UDF * new month is each new month integer for 12 months through the loop * calcMonth contains the incremental integer so we can loop over * 12 months and recognize that we're dealing with a new year * when that happens, we calculate what month starting in Jan. we're dealing with */ for(i=1; i LTE 12; i=i+1) { newMonth=form.Month+i; calcMonth=form.Month+i; if (calcMonth GTE 13) { useYear=form.Year+1; newMonth=i-(12-form.month); } else {useYear=form.Year;} newDate = GetNthOccOfDayInMonth(form.EVERY_N, firstDate, newMonth, useYear); arrayAppend(myDate, '#newMonth#/#newDate#/#useYear#'); } } // get the final date of the array finalDate=myDate[arrayLen(myDate)]; break; } case Yearly: { break; } default: { break; } } /cfscript ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~
RE: dynamically created session variables
Kill that evaluate() too: cfset session[fieldname] = form[fieldname] / -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:03 AM To: CF-Talk Subject: RE: dynamically created session variables IIRC, you need to do cfset session[#fieldname#] = evaluate(fieldname) -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Ali Daniali [mailto:[EMAIL PROTECTED] : Sent: Monday, March 03, 2003 1:48 PM : To: CF-Talk : Subject: dynamically created session variables : : : I'm trying to load form variables into session variables in an : application...but I'm having problems with the creating : dynamically created : session variable names. Any help is appreciated. : : CFLOOP index=FieldName list=#Form.FieldNames# : CFLOCK TIMEOUT=30 THROWONTIMEOUT=No TYPE=EXCLUSIVE : SCOPE=SESSION : CFSET Session.#FieldName# = #Evaluate(FieldName)# : /CFLOCK : /CFLOOP : : Thanks, : Ali : : --- : This message (including any attachments) may contain : confidential and privileged information. If you are : not the intended recipient, please notify the sender : and delete all copies of the original message without : using or disclosing it. Thank you. : --- : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dynamically created session variables
Or even better: cfset session[fieldname] = form[fieldname] No need for evaluate, or all those #s and s. You can also do: cfset structAppend(session,form) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 1:03 PM To: CF-Talk Subject: RE: dynamically created session variables IIRC, you need to do cfset session[#fieldname#] = evaluate(fieldname) -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Ali Daniali [mailto:[EMAIL PROTECTED] : Sent: Monday, March 03, 2003 1:48 PM : To: CF-Talk : Subject: dynamically created session variables : : : I'm trying to load form variables into session variables in an : application...but I'm having problems with the creating : dynamically created : session variable names. Any help is appreciated. : : CFLOOP index=FieldName list=#Form.FieldNames# : CFLOCK TIMEOUT=30 THROWONTIMEOUT=No TYPE=EXCLUSIVE : SCOPE=SESSION : CFSET Session.#FieldName# = #Evaluate(FieldName)# : /CFLOCK : /CFLOOP : : Thanks, : Ali : : --- : This message (including any attachments) may contain : confidential and privileged information. If you are : not the intended recipient, please notify the sender : and delete all copies of the original message without : using or disclosing it. Thank you. : --- : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What CF version are the CF server behaviors in DWMX?
Are the CF server behaviors that come with Dreamweaver MX written specifically for CFMX? If we are still using CF 5.0 should we avoid using these server behaviors? You are safe with CF 5.0 and maybe even with CF 4.5 (I'm sure some think we should avoid using the behaviors regardless of version considerations . . . but I have to ask the question.) Thanks! Sure, people think that in order to be professional you don't use that sort of tools; of course, images are also best done in any hex editor... Okay it takes a while but it's very professional, Photoshop or Fireworks are just girlie tools :-))) BTW One of the most powerful and unsung feature in DW is the ability to create your own Server Behaviors using a GUI; basically you can teach DW MX to write the code the way you prefer. For additional details, check the docs for Server Behaviors Builder. Massimo Foti Team Macromedia Volunteer for Dreamweaver Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.macromedia.com/go/team ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dynamically created session variables
Make sure you add a third parameter to structAppend() for whether or not you want to overwrite values. And note that it'll add EVERYTHING in the FORM scope, which may or may not be what you want. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:18 AM To: CF-Talk Subject: RE: dynamically created session variables Or even better: cfset session[fieldname] = form[fieldname] No need for evaluate, or all those #s and s. You can also do: cfset structAppend(session,form) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 1:03 PM To: CF-Talk Subject: RE: dynamically created session variables IIRC, you need to do cfset session[#fieldname#] = evaluate(fieldname) -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Ali Daniali [mailto:[EMAIL PROTECTED] : Sent: Monday, March 03, 2003 1:48 PM : To: CF-Talk : Subject: dynamically created session variables : : : I'm trying to load form variables into session variables in an : application...but I'm having problems with the creating : dynamically created : session variable names. Any help is appreciated. : : CFLOOP index=FieldName list=#Form.FieldNames# : CFLOCK TIMEOUT=30 THROWONTIMEOUT=No TYPE=EXCLUSIVE : SCOPE=SESSION : CFSET Session.#FieldName# = #Evaluate(FieldName)# : /CFLOCK : /CFLOOP : : Thanks, : Ali : : --- : This message (including any attachments) may contain : confidential and privileged information. If you are : not the intended recipient, please notify the sender : and delete all copies of the original message without : using or disclosing it. Thank you. : --- : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: recurrence engine
calDays = 365; What about leap years? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: calculating date recurrence
Ah. Nevermind then. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 2:10 PM To: CF-Talk Subject: Re: calculating date recurrence Actually that variable is just the number of days to look ahead, so it won't break it. - Original Message - From: Everett, Al [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 2:37 AM Subject: RE: calculating date recurrence Looks like this will break on a leap year, though. Try calDays=DaysInYear(Now()); -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 4:54 PM To: CF-Talk Subject: RE: calculating date recurrence Matthew, thanks ... I modified what you showed me to the code below, and it works perfectly. cfscript calDays = 365; interval = form.TIME_INTERVAL; numEvents = calDays \ interval; variables.myDate = ArrayNew(1); variables.myDate[1] = #form.month#/#form.day#/#form.year#; for(i=1; i LTE numEvents; i=i+1) { arrayAppend(variables.myDate, dateAdd('d', i * interval, variables.myDate[1])); } variables.recurrence_type = Daily; /cfscript -Original Message- From: Matthew Walker [SMTP:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 5:53 PM To: CF-Talk Subject: RE: calculating date recurrence What are you trying to do? Create an array of dates for your recurring event? How about this...? cfset showEventsnDaysInAdvance = 365 cfset interval = 7 cfset numberOfEventsToShow = showEventsnDaysInAdvance \ interval cfset myDates = arrayNew(1) cfloop from=1 to=#numberOfEventsToShow# index=i cfset arrayAppend(myDates, dateAdd(d, i * interval, now())) /cfloop -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Friday, 28 February 2003 1:36 p.m. To: CF-Talk Subject: calculating date recurrence OK, I'm working on building my own calendar application. I'm trying to come up with a way of dealing with recurrence. The first step is to calculate -- event occures every n days apart, i.e., event occures every 3 days. Here's one way I've tried so far (but this is like chewing up all the processor time) variables.date = ArrayNew(1); variables.date[1] = #form.month#/#form.day#/#form.year#; for(i=1; i LTE 30; i=i+1) { x=1; while (i mod form.TIME_INTERVAL){ variables.date[x] = DateAdd(d, (form.TIME_INTERVAL-1)+x, variables.date[1]); x=x+1; } } Something else I tried, but it creates too many empty array elements: variables.date = ArrayNew(1); variables.date[1] = #form.month#/#form.day#/#form.year#; for(i=1; i LTE 30; i=i+1) { if (i mod TIME_INTERVAL){ } else { variables.date[i] = DateAdd(d, (TIME_INTERVAL-1)+i, variables.date[1]); } } I'm open to suggestions. H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Java2 Issues (CFTREE) on a Mac
Attempting to use CFTREE (CF5) on a Mac (IE 5.22) and getting a message where its supposed to appear that this browser does not support Java2. Are there any known workarounds to accomplish this (the ability to view a CFTREE tag control through a Mac browser) ? Thanks in advance, phil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: recurrence engine
It's an arbitrary number. It could be set to 30 or 1000. However, you could do something like this: !--- if this is a leap year and the date is before 1 March, or if next year is a leap year and the date is 1 March or later then look ahead 366 days. --- cfif (isleapyear(year(now())) and month(now()) lte 2) or (isleapyear(year(now())+1) and month(now()) gt 2) cfset calDays = 366 cfelse cfset calDays = 365 /cfif Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Everett, Al [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 8:22 AM Subject: RE: recurrence engine calDays = 365; What about leap years? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Java2 Issues (CFTREE) on a Mac
You probably just have to install the Java2 JRE, although I don't know that for sure. Most browsers come with Java1 support, not Java2, although that's probably changing. -Original Message- From: phil e hebenstreit [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:32 AM To: CF-Talk Subject: Java2 Issues (CFTREE) on a Mac Attempting to use CFTREE (CF5) on a Mac (IE 5.22) and getting a message where its supposed to appear that this browser does not support Java2. Are there any known workarounds to accomplish this (the ability to view a CFTREE tag control through a Mac browser) ? Thanks in advance, phil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dynamically created session variables
So with this option I drop the CFLOOP all together, correct? Thank you all for your help! -AD -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:18 AM To: CF-Talk Subject: RE: dynamically created session variables Or even better: cfset session[fieldname] = form[fieldname] No need for evaluate, or all those #s and s. You can also do: cfset structAppend(session,form) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 1:03 PM To: CF-Talk Subject: RE: dynamically created session variables IIRC, you need to do cfset session[#fieldname#] = evaluate(fieldname) -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Ali Daniali [mailto:[EMAIL PROTECTED] : Sent: Monday, March 03, 2003 1:48 PM : To: CF-Talk : Subject: dynamically created session variables : : : I'm trying to load form variables into session variables in an : application...but I'm having problems with the creating : dynamically created : session variable names. Any help is appreciated. : : CFLOOP index=FieldName list=#Form.FieldNames# : CFLOCK TIMEOUT=30 THROWONTIMEOUT=No TYPE=EXCLUSIVE : SCOPE=SESSION : CFSET Session.#FieldName# = #Evaluate(FieldName)# : /CFLOCK : /CFLOOP : : Thanks, : Ali : : --- : This message (including any attachments) may contain : confidential and privileged information. If you are : not the intended recipient, please notify the sender : and delete all copies of the original message without : using or disclosing it. Thank you. : --- : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Java2 Issues (CFTREE) on a Mac
Try this site: http://java.sun.com/getjava/download1.html Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: phil e hebenstreit [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 2:32 PM To: CF-Talk Subject: Java2 Issues (CFTREE) on a Mac Attempting to use CFTREE (CF5) on a Mac (IE 5.22) and getting a message where its supposed to appear that this browser does not support Java2. Are there any known workarounds to accomplish this (the ability to view a CFTREE tag control through a Mac browser) ? Thanks in advance, phil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dynamically created session variables
But it defaults to yes - so if he wants to just copy them over, he can leave it off. :) Of course, there is something to be said about including optional args just as a helpful reminder about what's going on. :) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 1:22 PM To: CF-Talk Subject: RE: dynamically created session variables Make sure you add a third parameter to structAppend() for whether or not you want to overwrite values. And note that it'll add EVERYTHING in the FORM scope, which may or may not be what you want. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:18 AM To: CF-Talk Subject: RE: dynamically created session variables Or even better: cfset session[fieldname] = form[fieldname] No need for evaluate, or all those #s and s. You can also do: cfset structAppend(session,form) == = Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 1:03 PM To: CF-Talk Subject: RE: dynamically created session variables IIRC, you need to do cfset session[#fieldname#] = evaluate(fieldname) -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Ali Daniali [mailto:[EMAIL PROTECTED] : Sent: Monday, March 03, 2003 1:48 PM : To: CF-Talk : Subject: dynamically created session variables : : : I'm trying to load form variables into session variables in an : application...but I'm having problems with the creating : dynamically created : session variable names. Any help is appreciated. : : CFLOOP index=FieldName list=#Form.FieldNames# : CFLOCK TIMEOUT=30 THROWONTIMEOUT=No TYPE=EXCLUSIVE : SCOPE=SESSION : CFSET Session.#FieldName# = #Evaluate(FieldName)# : /CFLOCK : /CFLOOP : : Thanks, : Ali : : --- : This message (including any attachments) may contain : confidential and privileged information. If you are : not the intended recipient, please notify the sender : and delete all copies of the original message without : using or disclosing it. Thank you. : --- : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dynamically created session variables
Yes - if you want to copy EVERYTHING over. You will get at least one 'crap' field, fieldnames, which is the list of all the form fields. If this bugs you, just follow the structAppend with a structDelete. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ali Daniali [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 1:38 PM To: CF-Talk Subject: RE: dynamically created session variables So with this option I drop the CFLOOP all together, correct? Thank you all for your help! -AD -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:18 AM To: CF-Talk Subject: RE: dynamically created session variables Or even better: cfset session[fieldname] = form[fieldname] No need for evaluate, or all those #s and s. You can also do: cfset structAppend(session,form) == = Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 1:03 PM To: CF-Talk Subject: RE: dynamically created session variables IIRC, you need to do cfset session[#fieldname#] = evaluate(fieldname) -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Ali Daniali [mailto:[EMAIL PROTECTED] : Sent: Monday, March 03, 2003 1:48 PM : To: CF-Talk : Subject: dynamically created session variables : : : I'm trying to load form variables into session variables in an : application...but I'm having problems with the creating : dynamically created : session variable names. Any help is appreciated. : : CFLOOP index=FieldName list=#Form.FieldNames# : CFLOCK TIMEOUT=30 THROWONTIMEOUT=No TYPE=EXCLUSIVE : SCOPE=SESSION : CFSET Session.#FieldName# = #Evaluate(FieldName)# : /CFLOCK : /CFLOOP : : Thanks, : Ali : : --- : This message (including any attachments) may contain : confidential and privileged information. If you are : not the intended recipient, please notify the sender : and delete all copies of the original message without : using or disclosing it. Thank you. : --- : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: anybody ever done: every n day of the month for a year ...
Don't know what you found in the UDF, probably better then what I got, but this is something I created a couple of years ago, that automatically calculates the 2nd Tuesday of the Month for our CFUG meetings. I'll have to look into the UDF at cflib. cfset Month = Month(Now()) cfswitch expression=#DayOfWeek(CreateDate(Year(Now ()), Month, 1))# cfcase value=3cfset dayoffset = 1/cfcase cfcase value=2cfset dayoffset = 2/cfcase cfcase value=1cfset dayoffset = 3/cfcase cfcase value=7cfset dayoffset = 4/cfcase cfcase value=6cfset dayoffset = 5/cfcase cfcase value=5cfset dayoffset = 6/cfcase cfcase value=4cfset dayoffset = 7/cfcase /cfswitch cfif CreateDateTime(Year(Now ()), Month, 7 + dayoffset, 18, 30, 59) LTE Now() cfset Month = Month + 1 cfif Month EQ 13 cfset Month = 1 /cfif cfswitch expression=#DayOfWeek(CreateDate(Year(Now ()), Month, 1))# cfcase value=3cfset dayoffset = 1/cfcase cfcase value=2cfset dayoffset = 2/cfcase cfcase value=1cfset dayoffset = 3/cfcase cfcase value=7cfset dayoffset = 4/cfcase cfcase value=6cfset dayoffset = 5/cfcase cfcase value=5cfset dayoffset = 6/cfcase cfcase value=4cfset dayoffset = 7/cfcase /cfswitch /cfif cfset Next Meeting = CreateDateTime(Year(Now ()), Month, 7 + dayoffset, 18, 30, 59) Ian -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 3:22 PM To: CF-Talk Subject: anybody ever done: every n day of the month for a year ... Just to save me spending too much time trying to figure this out ... Anybody already have a code snippet for calculating every N day of the Month, for a year ... Such as, Every 3rd Tuesday of the month? That's where I'm at on building my little recurrance engine. I'll spit the whole code back out the list when it's done, if anybody wants it. H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dynamically created session variables
CFSET Session.#FieldName# = #Evaluate(FieldName)# You have a few choices 1. cfset session['#myFieldName#'] = form.someField 2. structAppend(session, form); // simple struct copy 3. session.frmStruct = duplicate(form); // deep copy Hope this helps. Joe Eugene -Original Message- From: Ali Daniali [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 1:48 PM To: CF-Talk Subject: dynamically created session variables I'm trying to load form variables into session variables in an application...but I'm having problems with the creating dynamically created session variable names. Any help is appreciated. CFLOOP index=FieldName list=#Form.FieldNames# CFLOCK TIMEOUT=30 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=SESSION CFSET Session.#FieldName# = #Evaluate(FieldName)# /CFLOCK /CFLOOP Thanks, Ali --- This message (including any attachments) may contain confidential and privileged information. If you are not the intended recipient, please notify the sender and delete all copies of the original message without using or disclosing it. Thank you. --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help porting ASP to CF
Hello Everyone, I am in the process of porting some code from ASP to CF. The code interfaces with a COM object which requires an array as input variables and then returns several other arrays as response variables. I am having difficulties writing the CF code that will allow me to call and pass these variables and receive the right info accordingly. This is the ASP code that generates the Address info array the COM function needs: '*** Dim asSearch, i ReDim asSearch (Request(SearchInput).Count - 1) for i = 1 to Request(SearchInput).Count asSearch(i - 1) = Request(SearchInput)(i) next '*** This is the cf code i wrote to do the same thing !--- * --- cfset addressArray = arraynew(1) !--- create address info array --- cfset counter = 0 cfloop collection=#form# item=pointer !--- populate array with collection elements --- cfset counter = counter + 1 cfoutput#pointer#=#evaluate(pointer)#/cfoutput cfset addressArray[counter] = #evaluate(pointer)# /cfloop !--- * --- The ASP code that actually executes the COM function is as follows: '*** Dim QuickAddress Set QuickAddress = Server.CreateObject(QAS.QAProWeb) Dim iPotential, asPreviews, asTags, aiFlags, aiScores QuickAddress.Search 0, sCountryCode, iPromptSet, asSearch, iPotential, asPreviews, asTags, aiFlags, aiScores '*** I don't really know how to call that function in the same was ASP does in CF. The resulting variables (asPreviews, asTags, aiFlags, aiScores) contain arrays of data each. How can i tell CF to run this function and put the right info in the right variables? thanks! andres ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JRun Config to Hotload Objects?
I think myself or someone else asked this question a while ago... Can remember now. Where is the xml config to Hotload Objects? What *.xml and element/Attribute? Thanks Joe Eugene ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help porting ASP to CF
What kind of data is request(searchinut)? Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Andres [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 3:24 PM To: CF-Talk Subject: Help porting ASP to CF Hello Everyone, I am in the process of porting some code from ASP to CF. The code interfaces with a COM object which requires an array as input variables and then returns several other arrays as response variables. I am having difficulties writing the CF code that will allow me to call and pass these variables and receive the right info accordingly. This is the ASP code that generates the Address info array the COM function needs: '*** Dim asSearch, i ReDim asSearch (Request(SearchInput).Count - 1) for i = 1 to Request(SearchInput).Count asSearch(i - 1) = Request(SearchInput)(i) next '*** This is the cf code i wrote to do the same thing !--- * --- cfset addressArray = arraynew(1) !--- create address info array --- cfset counter = 0 cfloop collection=#form# item=pointer !--- populate array with collection elements --- cfset counter = counter + 1 cfoutput#pointer#=#evaluate(pointer)#/cfoutput cfset addressArray[counter] = #evaluate(pointer)# /cfloop !--- * --- The ASP code that actually executes the COM function is as follows: '*** Dim QuickAddress Set QuickAddress = Server.CreateObject(QAS.QAProWeb) Dim iPotential, asPreviews, asTags, aiFlags, aiScores QuickAddress.Search 0, sCountryCode, iPromptSet, asSearch, iPotential, asPreviews, asTags, aiFlags, aiScores '*** I don't really know how to call that function in the same was ASP does in CF. The resulting variables (asPreviews, asTags, aiFlags, aiScores) contain arrays of data each. How can i tell CF to run this function and put the right info in the right variables? thanks! andres ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help porting ASP to CF
It's a form, the loop goes through all the items in a form that was passed from the prior page. andres -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 3:32 PM To: CF-Talk Subject: RE: Help porting ASP to CF What kind of data is request(searchinut)? Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Andres [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 3:24 PM To: CF-Talk Subject: Help porting ASP to CF Hello Everyone, I am in the process of porting some code from ASP to CF. The code interfaces with a COM object which requires an array as input variables and then returns several other arrays as response variables. I am having difficulties writing the CF code that will allow me to call and pass these variables and receive the right info accordingly. This is the ASP code that generates the Address info array the COM function needs: '*** Dim asSearch, i ReDim asSearch (Request(SearchInput).Count - 1) for i = 1 to Request(SearchInput).Count asSearch(i - 1) = Request(SearchInput)(i) next '*** This is the cf code i wrote to do the same thing !--- * --- cfset addressArray = arraynew(1) !--- create address info array --- cfset counter = 0 cfloop collection=#form# item=pointer !--- populate array with collection elements --- cfset counter = counter + 1 cfoutput#pointer#=#evaluate(pointer)#/cfoutput cfset addressArray[counter] = #evaluate(pointer)# /cfloop !--- * --- The ASP code that actually executes the COM function is as follows: '*** Dim QuickAddress Set QuickAddress = Server.CreateObject(QAS.QAProWeb) Dim iPotential, asPreviews, asTags, aiFlags, aiScores QuickAddress.Search 0, sCountryCode, iPromptSet, asSearch, iPotential, asPreviews, asTags, aiFlags, aiScores '*** I don't really know how to call that function in the same was ASP does in CF. The resulting variables (asPreviews, asTags, aiFlags, aiScores) contain arrays of data each. How can i tell CF to run this function and put the right info in the right variables? thanks! andres ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Renaming a DSN bug in MX?
Ok, here is what I am seeing...can anyone tell me if this is just me or a bug? If it's just me, anyone know how to fix it? - Create an Access DSN called test. - Rename DSN to test.renamed. - Create SQL Server DSN called test. The DSN gets created, but above the list of DSN's I see this error: Connection verification failed for data source: test []java.sql.SQLException: No datasource named test is configured in jrun-resources.xml The root cause was that: java.sql.SQLException: No datasource named test is configured in jrun-resources.xml - Rename the test DSN to test2. The test2 DSN should now validate and work, renaming it back to test will throw the above error again. I have recreated this with multiple databases. Whatever is happening it's definitely not database specific. Are DSN's in MX one time use only? Seems silly, but that's what it looks like to me. -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Fusebox for Flash?
I was thinking about your email this weekend and happen to run across this book at the local Barnes Noble: Object-Oriented Macromedia Flash MX - William Drol http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=53CY3FBL DYisbn=1590590147itm=1 HTH, Ryan Kime -Original Message- From: dwayne [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 3:43 AM To: CF-Talk Subject: OT - Fusebox for Flash? Is this possible? I've been looking for a structured development methodology for rich-applications using Flash. To me, Fusebox offers a solid framework for organizing and maintaing code. Is there such a framework for Flash? I've been tinkering with Flash-Remoting and ColdFusion Components for the past 6 months now but I just can't get with the all over the place coding. Dwayne Cole, MS in MIS, MBA Florida AM University Certified Advanced ColdFusion Developer ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How can I see incoming http request data
Hi, How can I capture and/or view the entire http request. Have a post that is being submitted and it seems that the form.variables are not making it. I'd like to actually see the string coming in. Any help? Thanks, Eric Homa ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help porting ASP to CF
What is Request(SearchInput).Count? You are creating an addressArray with the entire form variables, Are you sure.. these are the parameters to the COM Object? Look at the COM Object Function.. and check exactly what it requires as parameters. Joe Eugene -Original Message- From: Andres [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 3:24 PM To: CF-Talk Subject: Help porting ASP to CF Hello Everyone, I am in the process of porting some code from ASP to CF. The code interfaces with a COM object which requires an array as input variables and then returns several other arrays as response variables. I am having difficulties writing the CF code that will allow me to call and pass these variables and receive the right info accordingly. This is the ASP code that generates the Address info array the COM function needs: '*** Dim asSearch, i ReDim asSearch (Request(SearchInput).Count - 1) for i = 1 to Request(SearchInput).Count asSearch(i - 1) = Request(SearchInput)(i) next '*** This is the cf code i wrote to do the same thing !--- * --- cfset addressArray = arraynew(1) !--- create address info array --- cfset counter = 0 cfloop collection=#form# item=pointer !--- populate array with collection elements --- cfset counter = counter + 1 cfoutput#pointer#=#evaluate(pointer)#/cfoutput cfset addressArray[counter] = #evaluate(pointer)# /cfloop !--- * --- The ASP code that actually executes the COM function is as follows: '*** Dim QuickAddress Set QuickAddress = Server.CreateObject(QAS.QAProWeb) Dim iPotential, asPreviews, asTags, aiFlags, aiScores QuickAddress.Search 0, sCountryCode, iPromptSet, asSearch, iPotential, asPreviews, asTags, aiFlags, aiScores '*** I don't really know how to call that function in the same was ASP does in CF. The resulting variables (asPreviews, asTags, aiFlags, aiScores) contain arrays of data each. How can i tell CF to run this function and put the right info in the right variables? thanks! andres ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How can I see incoming http request data
CF5+ you can use getHTTPRequestData(), or simply start up you favorite sniffer to watch what is actually going across the wire. -- jon mailto:[EMAIL PROTECTED] Monday, March 3, 2003, 4:00:25 PM, you wrote: EH Hi, EH How can I capture and/or view the entire http request. Have a post that is being submitted and it seems that the form.variables are not making it. I'd like to actually see the string coming in. EH Any help? EH Thanks, EH Eric Homa ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Renaming a DSN bug in MX?
Just to follow up, restarting the server will allow the SQL Server test DSN to verify... -- jon mailto:[EMAIL PROTECTED] Monday, March 3, 2003, 3:42:31 PM, you wrote: jh Ok, here is what I am seeing...can anyone tell me if this is just me jh or a bug? If it's just me, anyone know how to fix it? jh - Create an Access DSN called test. jh - Rename DSN to test.renamed. jh - Create SQL Server DSN called test. jh The DSN gets created, but above the list of DSN's I see this error: jh Connection verification failed for data source: test jh []java.sql.SQLException: No datasource named test is configured in jrun-resources.xml jh The root cause was that: java.sql.SQLException: No datasource named test is configured in jrun-resources.xml jh - Rename the test DSN to test2. jh The test2 DSN should now validate and work, renaming it back to test jh will throw the above error again. I have recreated this with jh multiple databases. Whatever is happening it's definitely not jh database specific. jh Are DSN's in MX one time use only? Seems silly, but that's what it jh looks like to me. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query of Queries in CF5 with Subquery
I am using ColdFusion 5 Enterprise Edition. I have 2 separate oracle databases that cannot communicate to each other, but the web server can communicate to them individually. I am pulling back data from to queries as such. Query 1: Machine1 null Loc1 Machine2 null Loc2 Machine3 null Loc3 Machine4 null Loc4 Query2 null Machine1 Loc1 null Machine3 Loc3 null Machine4 Loc4 null Machine5 Loc5 I am trying to get a union query with nested selects to work as such Select * from Query1 where Q1MachineName not in (Select Q2MachineName from Query2) UNION Select * from Query2 where Q2MachineName not in (Select Q1MachineName from Query1) So I end up with Machine2 null Loc2 null Machine5 Loc5 The problem is, when I run the union query above, I get the error Query Manipulation Error Code = 0 Can't find symbol: select Any suggestions as to what I am doing wrong? Thanks, Rob Edwards ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
XML Transformations using CF 5.0 and below
Here's some code that'll use Xalan to transform an XML document with an XSLT stylesheet, for all of us that don't want to use the gawd-awful MSXML COM object and don't yet have CFMX. cfscript // Create the transformer factory. transformerFactory = createObject(java, javax.xml.transform.TransformerFactory); factory = transformerFactory.newInstance(); // XML document xmlDoc = createObject(java, javax.xml.transform.stream.StreamSource); // Set the path to the XML document xmlDoc.setSystemId(c:\inetpub\wwwroot\msol\msol\projecttracker\layout\list.xml); // XSLT document xsltDoc = createObject(java, javax.xml.transform.stream.StreamSource); // Set the path to the XSLT document xsltDoc.setSystemId(c:\inetpub\wwwroot\msol\msol\projecttracker\layout\menu.xsl); // Create the transformer. transformer = factory.newTransformer(xsltDoc); // Output string result = createObject(java, java.io.StringWriter); // We need to do this so that the StringWriter object is actually created. result.write(); // Create the StreamResult streamResult = createObject(java, javax.xml.transform.stream.StreamResult); // Pass the StringWriter to the StreamResult streamResult.setWriter(result); // Transform the XML document. transformer.transform(xmlDoc, streamResult); // Write it to the screen. You can do this anytime. writeOutput(result.toString()); /cfscript ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ODBC Problems?
I'm getting errors with my MX box trying to connect to an AS/400. After about an hour the MX server hangs. Stopping and starting the ODBC services generally clears it up. Just wondering if anyone has any ideas or if anyone is experiencing similar problems ? Here is one of the error messages I am receiving. :[MERANT][SequeLink JDBC Driver][ODBC Socket][IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]Communication link failure. Thanks. ~~~ Tom Botts Gilbarco Inc. 336-547-5911 phone 336-547-5163 fax [EMAIL PROTECTED] www.gilbarco.com ~~~ ...OLE_Obj... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Looping over struct refresher
Brain dead. I have an xml file, parsed into a cfstructure. So now we have node.node.[number].item with each node.node.[number] having many items. How do I loop over this to access the variables? Set it to an array somehow? Any quick pointers would so appreciated as I cannot for the life of me get my head on straight today. Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ODBC Problems?
Sounds like the CFMX ODBC Connection Polling Framework, whatever it uses might be acting up. Question is...Has anybody seen problems with CFMX ODBC connections being dropped? Either SQL-Server ODBC or any other ODBC configured with CFMX. Joe Eugene -Original Message- From: Botts, Tom [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 5:35 PM To: CF-Talk Subject: ODBC Problems? I'm getting errors with my MX box trying to connect to an AS/400. After about an hour the MX server hangs. Stopping and starting the ODBC services generally clears it up. Just wondering if anyone has any ideas or if anyone is experiencing similar problems ? Here is one of the error messages I am receiving. :[MERANT][SequeLink JDBC Driver][ODBC Socket][IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]Communication link failure. Thanks. ~~~ Tom Botts Gilbarco Inc. 336-547-5911 phone 336-547-5163 fax [EMAIL PROTECTED] www.gilbarco.com ~~~ ...OLE_Obj... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ODBC Problems?
Joe wrote: Question is...Has anybody seen problems with CFMX ODBC connections being dropped? In MX, I sure have. I couldn't get reliable performance on dev or live boxes, using both Pro and Developer (running as Enterprise before its 30 days were up), unless I used the native drivers. Got the error you described exactly, if I recall correctly. Was trying to use SQL Server (latest MSDE), Oracle (9i, I think), mySQL and Access via odbc and couldn't get it to work. In fairness this was in a pre-update initial release of cfmx. --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX and RSS
Hi, I'm trying to find a decent tutorial on bringing down RSS feeds into CFMX--something that's supposed to be relatively easy, and I don't dispute that it is, however I need a starting point and my searches aren't getting me much beyond Full As A Goog. Can anyone direct me to a good tutorial starting point? Thanks in advance, Russ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is it possible to achieve workflow in Coldfusion ???
You might want to think about whether there is a required publication date. For example, if a story is entered, but is embargoed until next week, you might want to store that publication date and it won't show up on the site until that date arrives. H. -Original Message- From: Ian Vaughan [SMTP:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 3:54 AM To: CF-Talk Subject: Re: Is it possible to achieve workflow in Coldfusion ??? Andre Thanks for the explanation!! Ok I understand how it is working - A user fills in the fields and clicks submit the data in entered into the db with a 'status' field set to a default of 'Pending' Ok Then when the form is submitted I use CFMail to send an e-mail to the approver informing them they have a story to approve. (Is this process correct ?) The approver clicks on the link in the e-mail and they are taken to the 'Pending Jobs' Screen. The approver opens the relevant pending job. At the bottom of this page there are two buttons 'Approve' and 'Decline' If the aprrover clicks approve the 'status' field changes to 'approve' However if the approver clicks decline then the 'status' field stays the same and an e-mail is sent back to the content owner informing them that the content has been declined. Does this make sense logically ?? Or would you add more features and or more advanced settings?? - Original Message - From: Andre Mohamed [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:24 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, Perhaps I can clarify/expand on what Adam suggested: 1) You do not stop the data entering the database when a story is submitted. Instead, it is inserted as normal but you also set another column probably in the same table, perhaps named status with a value of P for pending when you perform the insert e.g. insert into stories (story_id, foo, bar, status) values (666,'Foo','Bar','P') 2) Only display stories on the website if the status column is not P, perhaps only if the status column is A for approved e.g. select foo, bar from stories where status = 'A' 3) When the approver approves a story to be published, the appropriate row in the database gets updated and the status column is changed appropriately. e.g. update stories set status = 'A' where story_id = 666 You could extend this model quite simply to allow for multi-level approvals and multiple types of status. It's important to note that this is not a ColdFusion specific problem. It is merely a programming issue and there is more than one way to skin a cat. Thanks, André -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 11:02 To: CF-Talk Subject: Re: Is it possible to achieve workflow in Coldfusion ??? Adam There is only one administrator or approver. How would you achieve this, do you have example code so I can see how it may function, how do you stop the data entering the database ?? As part of the submit page, have it save the document away with a flag 'pending'. - Original Message - From: Adam Reynolds [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:46 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, This is relatively simple. As part of the submit page, have it save the document away with a flag 'pending'. Is there just one administrator? Do you want different admin for different areas of the site? That is the real pain. You could have a pending approval page that admin can go to to see any pending pages. They could then view (AND edit) those pages before accepting the content or rejecting the comment. Adam -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 09:38 To: CF-Talk Subject: Is it possible to achieve workflow in Coldfusion ??? Hi I am trying to add a workflow element into a news application, and would just like to hear if anybody else on the list have been able to achieve this? or best practices on how to achieve this? I have an admin form that allows users to add news stories. At present when the form is submitted the data is entered into the database table. What I would like to achieve is when the user submits the form an e-mail is sent to the relevant approver. They view their e-mail and click on the link which opens up their admin screen. From here they can see they have content to approve. The approver reads through the story and if they are happy they approve the data and it is entered into the database and goes live on the site. If the approver declines the story it sends the user who
RE: ODBC Problems?
if I recall correctly. Was trying to use SQL Server (latest MSDE), Oracle (9i, I think), mySQL and Access via odbc and couldn't get it to work. Interesting, Thanks Matt. Ok, looks like we have a problem with the CFMX ODBC Sever Engine. Can someone from MM Product Team clarify whats happening? Is this an MM aware issue, any patches available? Thanks Joe Eugene -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 7:04 PM To: CF-Talk Subject: RE: ODBC Problems? Joe wrote: Question is...Has anybody seen problems with CFMX ODBC connections being dropped? In MX, I sure have. I couldn't get reliable performance on dev or live boxes, using both Pro and Developer (running as Enterprise before its 30 days were up), unless I used the native drivers. Got the error you described exactly, if I recall correctly. Was trying to use SQL Server (latest MSDE), Oracle (9i, I think), mySQL and Access via odbc and couldn't get it to work. In fairness this was in a pre-update initial release of cfmx. --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
debug output not working in CFMX
Hey All, I can't get debugging to fly in CFMX. The second updater is installed, and I've tried every possible IP. Debugging is turned on in classic mode, but nothing shows when CFM pages are run. Man I hate it when the simple things blow up like this ;-) TIA for any insight Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4