Re: ColdFusion Companies in Baltimore/DC/VA
We are getting ready for a major undertaking to involve a complete overhaul of our very large Web site/CMS system to include a new design, information architecture, marketing strategy, CMS platform, etc. We plan on issuing 2 RFPs: one for the design/marketing strategy and one for the technical implementation. I see that other people have mentioned my company already, so I won't bother to toot my own horn. If you're implementing a CMS product, you might want to ask the vendor if they have any preferred partners. For example, we're a CommonSpot partner, and have done a lot of large-scale CMS implementations with it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338742 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re: Curious problem with CFINDEX
You have to create 2 different collections, one for the 1 document and the other for the 5 database rows and then create a 3rd collection that merges the first two, iirc. From: Kevin Parker tras...@internode.on.net Sent: Monday, November 01, 2010 9:11 PM To: cf-talk cf-talk@houseoffusion.com Subject: Curious problem with CFINDEX Be grateful for some insight if anyone can help please. Have a CFINDEX script (FILE) that when run on its own against the test site correctly indexes 1 document. Have a CFINDEX script (CUSTOM) that when run on its own against the test database correctly indexes 5 rows. But when I run both together (on the same cfm template) the result is not 6. If I run the document one first and then the database one there are 5 records in the collection. If I run the database one first and then the document one there is only one record in the collection. The template commences with a PURGE and I've tried using both UPDATE and REFRESH but same result. TIA!!! ++ Kevin Parker m: 0418 815 527 ++ http://au.linkedin.com/in/krparker ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338743 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Curious problem with CFINDEX
That is what I was going to say also, but I'm not sure if this is the case, it has been a long time since I used cfindex as I have always found it has no speed benefit over database queries, but If you check the cfdocs they seem to imply that you can index multiple types in the same collection with an update. The implication could be wrong though, they may simply be using the same collection name in all the code examples. Russ -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 02 November 2010 11:42 To: cf-talk Subject: re: Curious problem with CFINDEX You have to create 2 different collections, one for the 1 document and the other for the 5 database rows and then create a 3rd collection that merges the first two, iirc. From: Kevin Parker tras...@internode.on.net Sent: Monday, November 01, 2010 9:11 PM To: cf-talk cf-talk@houseoffusion.com Subject: Curious problem with CFINDEX Be grateful for some insight if anyone can help please. Have a CFINDEX script (FILE) that when run on its own against the test site correctly indexes 1 document. Have a CFINDEX script (CUSTOM) that when run on its own against the test database correctly indexes 5 rows. But when I run both together (on the same cfm template) the result is not 6. If I run the document one first and then the database one there are 5 records in the collection. If I run the database one first and then the document one there is only one record in the collection. The template commences with a PURGE and I've tried using both UPDATE and REFRESH but same result. TIA!!! ++ Kevin Parker m: 0418 815 527 ++ http://au.linkedin.com/in/krparker ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Curious problem with CFINDEX
Ah, you may be right, Ross. It's been a long time since I've done the multi-Verity thing, too, but maybe it's possible to UPDATE with 2 collections? Rings a (rather dim) bell ... From: Russ Michaels r...@michaels.me.uk Sent: Tuesday, November 02, 2010 7:52 AM To: cf-talk cf-talk@houseoffusion.com Subject: RE: Curious problem with CFINDEX That is what I was going to say also, but I'm not sure if this is the case, it has been a long time since I used cfindex as I have always found it has no speed benefit over database queries, but If you check the cfdocs they seem to imply that you can index multiple types in the same collection with an update. The implication could be wrong though, they may simply be using the same collection name in all the code examples. Russ -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 02 November 2010 11:42 To: cf-talk Subject: re: Curious problem with CFINDEX You have to create 2 different collections, one for the 1 document and the other for the 5 database rows and then create a 3rd collection that merges the first two, iirc. From: Kevin Parker tras...@internode.on.net Sent: Monday, November 01, 2010 9:11 PM To: cf-talk cf-talk@houseoffusion.com Subject: Curious problem with CFINDEX Be grateful for some insight if anyone can help please. Have a CFINDEX script (FILE) that when run on its own against the test site correctly indexes 1 document. Have a CFINDEX script (CUSTOM) that when run on its own against the test database correctly indexes 5 rows. But when I run both together (on the same cfm template) the result is not 6. If I run the document one first and then the database one there are 5 records in the collection. If I run the database one first and then the document one there is only one record in the collection. The template commences with a PURGE and I've tried using both UPDATE and REFRESH but same result. TIA!!! ++ Kevin Parker m: 0418 815 527 ++ http://au.linkedin.com/in/krparker ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Debugging output is not working
Hello. We have a new CF 9 server and the debugging output is set in the administrator but it still doesn't show on the page. I asked the server admin about it and here is his reply: *The debugger had to be turned on, port set (5005), and CF restarted. I have done this and setup redirects in the firewall for the IPs listed in the debugger. Can you test and let me know its working.* * *It's still not working. Any suggestions?* * ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338746 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
rereplace for removing repeating characters
Hi, i need to replace all repeating commas in a string with only one comma, plus remove the trailing comma, have tried a few different routes unsuccessfully and would appreciate any input: for example i would the the string: 'Genns,,DrBish Stratford,,,' to become: 'Genns,Dr,Bish Stratford' thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338747 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: rereplace for removing repeating characters
I am sure there are some nice slick regular expressions to do this, but I just simply do this a very dumbed down way. cfset myVar = ReplaceNoCase(myVar , ,, ,, ALL) cfset myVar = ReplaceNoCase(myVar , , ,, ALL) cfset myVar = ReplaceNoCase(myVar , ,, ALL) cfset myVar = ReplaceNoCase(myVar , ,,, ,, ALL) You could also write a loop to run until FindNoCase(myVar, ,,) EQ FALSE, so you keep turning double commas, into single commas which will continue to reduce the commas, until there are no matches. Again, there is probably a RegEx way to do this, but I don't know RegEx off the top of my head. Regards, David McGraw Oyova Software, LLC http://www.oyova.com On Tue, Nov 2, 2010 at 8:34 AM, Richard White rich...@j7is.co.uk wrote: Hi, i need to replace all repeating commas in a string with only one comma, plus remove the trailing comma, have tried a few different routes unsuccessfully and would appreciate any input: for example i would the the string: 'Genns,,DrBish Stratford,,,' to become: 'Genns,Dr,Bish Stratford' thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338748 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Companies in Baltimore/DC/VA
Hi Dave, Figleaf is definitely on our list and personally my favorite. Your mention of preferred partners is a great suggestion. Thanks :) We are getting ready for a major undertaking to involve a complete overhaul of our very large Web site/CMS system to include a new design, information architecture, marketing strategy, CMS platform, etc. We plan on issuing 2 RFPs: one for the design/marketing strategy and one for the technical implementation. I see that other people have mentioned my company already, so I won't bother to toot my own horn. If you're implementing a CMS product, you might want to ask the vendor if they have any preferred partners. For example, we're a CommonSpot partner, and have done a lot of large-scale CMS implementations with it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338749 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: rereplace for removing repeating characters
thanks for the reply, i actually just found a shortcut! i converted the string to an array which removed any empty array elements, and then converted back to a list and therefore deleted all the duplicate, and trailing commas I am sure there are some nice slick regular expressions to do this, but I just simply do this a very dumbed down way. cfset myVar = ReplaceNoCase(myVar , ,, ,, ALL) cfset myVar = ReplaceNoCase(myVar , , ,, ALL) cfset myVar = ReplaceNoCase(myVar , ,, ALL) cfset myVar = ReplaceNoCase(myVar , ,,, ,, ALL) You could also write a loop to run until FindNoCase(myVar, ,,) EQ FALSE, so you keep turning double commas, into single commas which will continue to reduce the commas, until there are no matches. Again, there is probably a RegEx way to do this, but I don't know RegEx off the top of my head. Regards, David McGraw Oyova Software, LLC http://www.oyova.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338750 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: rereplace for removing repeating characters
try this: cfset string = rereplace(rereplace(string, ,+$, ), ,+, ,, all) Azadi On 02/11/2010 20:34 , Richard White wrote: Hi, i need to replace all repeating commas in a string with only one comma, plus remove the trailing comma, have tried a few different routes unsuccessfully and would appreciate any input: for example i would the the string: 'Genns,,DrBish Stratford,,,' to become: 'Genns,Dr,Bish Stratford' thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFCHART:: no values for ## itemlabel ##
url=chartTestDetails.cfm?org=#itemlabel# If you are trying to use the pseudo-variables, the syntax is $ITEMLABEL$ http://livedocs.adobe.com/coldfusion/8/Tags_c_05.html Leigh, Thanks that was it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338752 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Debugging output is not working
On CF9 by default there are 2 entries in the debugging IP's You need to remove these if you want debugging to be visible to everyone. Regards -- Russ Michaels www.cfmldeveloper.com - free CFML hosting for developers my blog: http://russ.michaels.me.uk/ skype: russmichaels -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: 02 November 2010 12:25 To: cf-talk Subject: Debugging output is not working Hello. We have a new CF 9 server and the debugging output is set in the administrator but it still doesn't show on the page. I asked the server admin about it and here is his reply: *The debugger had to be turned on, port set (5005), and CF restarted. I have done this and setup redirects in the firewall for the IPs listed in the debugger. Can you test and let me know its working.* * *It's still not working. Any suggestions?* * ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFLDAP query attribute with multiple values
Are you using the separator attribute? I use it to query active directory for user groups and it returns a list of all memberOf entries. I haven't tried it without the separator though. ~Mahcsig On Mon, Nov 1, 2010 at 7:38 PM, Azadi Saryev azadi.sar...@gmail.com wrote: does cfldap tag support querying for an attribute with multiple values? it seems no matter what i do, it only returns the first value of an attribute... our school uses mac os x server ldap service (based on openldap), and some user attributes are multivalued, but cfldap only ever returns the first value. browsing the directory using server's Workgroup Manager or LDAPManager (3rd party app) returns all attribute's values. anyone has any ideas how to make cfldap return all values? thanks! Azadi ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338754 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFLDAP query attribute with multiple values
very interesting - somehow i have missed the separator attribute of cfldap tag when checking its syntax... will try it first thing tomorrow morning. thanks for the tip, Mahcsig - i will post results (or more questions) tomorrow. On 02/11/2010 21:10 , Mahcsig wrote: Are you using the separator attribute? I use it to query active directory for user groups and it returns a list of all memberOf entries. I haven't tried it without the separator though. ~Mahcsig On Mon, Nov 1, 2010 at 7:38 PM, Azadi Saryevazadi.sar...@gmail.com wrote: does cfldap tag support querying for an attribute with multiple values? it seems no matter what i do, it only returns the first value of an attribute... our school uses mac os x server ldap service (based on openldap), and some user attributes are multivalued, but cfldap only ever returns the first value. browsing the directory using server's Workgroup Manager or LDAPManager (3rd party app) returns all attribute's values. anyone has any ideas how to make cfldap return all values? thanks! Azadi ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338755 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Trying to create a Webservice for SAP Client
I somewhat new to webservices (ie creating them) not consuming them... We need to create a webservice for an SAP intergrtaion that will send us an XML file and we will return an a packet of information that will tell them if it is success and provide a url to open a new window or some error code on why it failed. I created a CFC and was able to test our wdsl using soapUI but I am being told that the defensions that CF is creating in the WSDL are not valid and SAP can not consume the service. Also I am trying to understand how I return an xml package back in the soap return not just a single value. Any help on this would be great and if there are any good resourse on how to do this with SAP out there that would also be helpful. Thanks in advance. Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338756 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging output is not working
Monique, The setting that you're referring to is for information sent to the debugging tools in CF-Builder. For the standard debugging output you'll need to go to: Debugging and Logging = Debug Output Settings = make sure that Enable Robust Exception Information is checked along with Enable Request Debugging Output. under Debug IP Addresses if you remove the default addresses (ie: make it blank) debug output will be sent to all users, or you can set specific IP addresses that can view the output.. Note: Do Not turn on debugging in production, while the output may only be viewable by certain IP addresses, it's sent with each request and can add significant weight to the page, causing performance issues. The best way around this whole issue is to create a custome error handling framework using a custom global handler, the onError() method in Application.cfc and cftry/cfcatch blocks around potentially troublesome code. This way you can capture error info without adding anything significant to the page On Tue, Nov 2, 2010 at 8:25 AM, Monique Boea moniqueb...@gmail.com wrote: Hello. We have a new CF 9 server and the debugging output is set in the administrator but it still doesn't show on the page. I asked the server admin about it and here is his reply: *The debugger had to be turned on, port set (5005), and CF restarted. I have done this and setup redirects in the firewall for the IPs listed in the debugger. Can you test and let me know its working.* * *It's still not working. Any suggestions?* * ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338757 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging output is not working
Thanks Guys I've tried everything that I normally do and it's not working. I'll trying removing the default. On Tue, Nov 2, 2010 at 9:08 AM, Russ Michaels r...@michaels.me.uk wrote: On CF9 by default there are 2 entries in the debugging IP's You need to remove these if you want debugging to be visible to everyone. Regards -- Russ Michaels www.cfmldeveloper.com - free CFML hosting for developers my blog: http://russ.michaels.me.uk/ skype: russmichaels -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: 02 November 2010 12:25 To: cf-talk Subject: Debugging output is not working Hello. We have a new CF 9 server and the debugging output is set in the administrator but it still doesn't show on the page. I asked the server admin about it and here is his reply: *The debugger had to be turned on, port set (5005), and CF restarted. I have done this and setup redirects in the firewall for the IPs listed in the debugger. Can you test and let me know its working.* * *It's still not working. Any suggestions?* * ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338758 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Debugging output is not working
Those default IP's make the debugging only visible to localhost. If you are not localhost, you won't see it. -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: 02 November 2010 17:14 To: cf-talk Subject: Re: Debugging output is not working Thanks Guys I've tried everything that I normally do and it's not working. I'll trying removing the default. On Tue, Nov 2, 2010 at 9:08 AM, Russ Michaels r...@michaels.me.uk wrote: On CF9 by default there are 2 entries in the debugging IP's You need to remove these if you want debugging to be visible to everyone. Regards -- Russ Michaels www.cfmldeveloper.com - free CFML hosting for developers my blog: http://russ.michaels.me.uk/ skype: russmichaels -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: 02 November 2010 12:25 To: cf-talk Subject: Debugging output is not working Hello. We have a new CF 9 server and the debugging output is set in the administrator but it still doesn't show on the page. I asked the server admin about it and here is his reply: *The debugger had to be turned on, port set (5005), and CF restarted. I have done this and setup redirects in the firewall for the IPs listed in the debugger. Can you test and let me know its working.* * *It's still not working. Any suggestions?* * ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338759 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Anonymous Feedback Form: Prevent Malicious Code On Documents
We had an attack yesterday to one of our anonymous uploads we provide for our faculty students to upload documents and some files. We were attacked yesterday (which was partly our fault for having this open to all file types) we have now minimized these files to the best of our ability for this application. The attack yesterday though was a valid file type but had a php script on the document that when read it would somehow give open access to write to our website. These individual(s) changed our footer by inserting a few links in Turkish language that linked to inappropriate sites one can only guess what they had and/or did on them. In our Development Meeting this morning we talked about two points we need to try and accomplish to prevent this from happening again (on top of the security we've already done): 1. Saving files uploaded in a folder that is not open to everyone but secure for only downloading the uploaded material via link of some sort. 2. Some way to scan the content of the file(s) uploaded for malicious code that would cause harmful consequences to our site again. I did some research yesterday on preventing malicious code being uploaded from open anonymous fields (http://www.paulsilver.co.uk/code/coldfusion_file_sandbox_security.php) this was the best I could find. It solves #1 on our list, which we have sort of already done minus using CFCONTENT. I tried to look on HoF and this was the best I could find (http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:59164) which doesn't really address my problem at all. So, we have come up with a way to make sure the correct extensions and presenting the material back to individuals correctly, but I'm still not convinced this is the best solution to preventing malicious code to come through and make trouble for us again. One other suggestion that was made at the meeting was to email the attached file to our IT department which they will review and approve/disapprove the file. This of course would be the logical way of doing things, but we have individuals who might need the file quicker and I'm confident there's some type of script/software out here that we can implement on top of the human verification that will help us prevent this from happening again. I just wanted to post this to see if any of you had better ideas in your years of experience. I'm confident you have all thought or experienced this in your own business's. I'm also confident that there's a way to use CF to assist in this problem. I just don't have enough knowledge to come up with the best method, yet. :) Thanks in advance! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338760 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Coldfusion Search
Anyone have any ideas on this? -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Monday, November 01, 2010 4:46 PM To: cf-talk Subject: Coldfusion Search Hi All, I've created a file index of all of my ColdFusion files so I can quickly search the files and find what I'm looking for. So far, it's working great except it doesn't seem to be searching inside any coldfusion tags. For example pIf I searched for this text, It would return a result/p cfset variables.foo = however, If I search for this text it wouldn't return any results. / Does anyone know if there's a way to search inside of a coldfusion tag like that? This is my index. cfindex collection = fileIndex action=refresh type=path key=d:\my-websites-location\ urlpath=http://mywebsite/; extensions=.cfm, .cfml, .cfc recurse=Yes This is my search. cfsearch name = testSearch collection = fileIndex type=internet criteria = variables.foo / Any ideas? Thanks, Paul : ) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Anonymous Feedback Form: Prevent Malicious Code On Documents
As long as you save the file to a directory that has limited execute and script permissions, the file should not ever be executed. If you loaded a PHP file from that directory in your browser you would get prompted to download but it should never execute. Make sure all script mappings on the directory are removed. Of course saving the file in an non-web accessible directory is even a better idea and use CFCONTENT to serve the file as mentioned... -Original Message- From: Matthew Lowrey [mailto:rid...@gmail.com] Sent: November-02-10 10:58 AM To: cf-talk Subject: Anonymous Feedback Form: Prevent Malicious Code On Documents We had an attack yesterday to one of our anonymous uploads we provide for our faculty students to upload documents and some files. We were attacked yesterday (which was partly our fault for having this open to all file types) we have now minimized these files to the best of our ability for this application. The attack yesterday though was a valid file type but had a php script on the document that when read it would somehow give open access to write to our website. These individual(s) changed our footer by inserting a few links in Turkish language that linked to inappropriate sites one can only guess what they had and/or did on them. In our Development Meeting this morning we talked about two points we need to try and accomplish to prevent this from happening again (on top of the security we've already done): 1. Saving files uploaded in a folder that is not open to everyone but secure for only downloading the uploaded material via link of some sort. 2. Some way to scan the content of the file(s) uploaded for malicious code that would cause harmful consequences to our site again. I did some research yesterday on preventing malicious code being uploaded from open anonymous fields (http://www.paulsilver.co.uk/code/coldfusion_file_sandbox_security.php) this was the best I could find. It solves #1 on our list, which we have sort of already done minus using CFCONTENT. I tried to look on HoF and this was the best I could find (http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:59164) which doesn't really address my problem at all. So, we have come up with a way to make sure the correct extensions and presenting the material back to individuals correctly, but I'm still not convinced this is the best solution to preventing malicious code to come through and make trouble for us again. One other suggestion that was made at the meeting was to email the attached file to our IT department which they will review and approve/disapprove the file. This of course would be the logical way of doing things, but we have individuals who might need the file quicker and I'm confident there's some type of script/software out here that we can implement on top of the human verification that will help us prevent this from happening again. I just wanted to post this to see if any of you had better ideas in your years of experience. I'm confident you have all thought or experienced this in your own business's. I'm also confident that there's a way to use CF to assist in this problem. I just don't have enough knowledge to come up with the best method, yet. :) Thanks in advance! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338762 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Search
If I had to guess I'd say Verity is ignoring the code as it looks like HTML. On Mon, Nov 1, 2010 at 3:45 PM, Paul Alkema paulalkemadesi...@gmail.com wrote: Hi All, I've created a file index of all of my ColdFusion files so I can quickly search the files and find what I'm looking for. So far, it's working great except it doesn't seem to be searching inside any coldfusion tags. For example. pIf I searched for this text, It would return a result/p cfset variables.foo = however, If I search for this text it wouldn't return any results. / Does anyone know if there's a way to search inside of a coldfusion tag like that? This is my index.. cfindex collection = fileIndex action=refresh type=path key=d:\my-websites-location\ urlpath=http://mywebsite/; extensions=.cfm, .cfml, .cfc recurse=Yes This is my search. cfsearch name = testSearch collection = fileIndex type=internet criteria = variables.foo / Any ideas? Thanks, Paul : ) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anonymous Feedback Form: Prevent Malicious Code On Documents
Thanks Brook: I agree this looks like the best method so far. I also forgot to mention images, if one was to upload images that were inappropriate, is there a way to 'flag' them or would human verification be the only resort to this type of situation. I want to say there's some way of flagging certain types of images like porno, but I can't remember. I thought there was a way I saw it done while in the military but my memory fails me. As long as you save the file to a directory that has limited execute and script permissions, the file should not ever be executed. If you loaded a PHP file from that directory in your browser you would get prompted to download but it should never execute. Make sure all script mappings on the directory are removed. Of course saving the file in an non-web accessible directory is even a better idea and use CFCONTENT to serve the file as mentioned... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338764 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Scheduling lots of ColdFusion tasks in a limited window
We're running CF9 Enterprise in a pretty robust intranet environment - multiple CPUs, lots of RAM, our own instance, load balanced across two servers. We have about 60 scheduled tasks that need to run in a two hour period each morning. Each task hits either a mainframe database or a data warehouse database. Most tasks complete in a few seconds to a minute (lots of data), some take a couple of minutes or longer. We are adding new tasks at a steady rate and the two hour window is getting pretty crowded. How concerned would you be about starting more than one task at the same time on the same server? What would guide you in determining a limit on how many tasks you would start at the same time on the same server? How concerned would you be about starting the same task(s) at the same time on each of the two load balanced servers? Thanks! George ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338765 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduling lots of ColdFusion tasks in a limited window
Scheduled tasks are just URLs requested by a computerize built-in browser rather then a client in front of a human. If the CFML code being run by the Scheduled task(s) could execute properly if two humans requested the URLs at the same time, their should be no problem with a computer doing the same thing. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338766 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Weird problem with CFPDF addheader/image
Ok, so I am hoping someone out there has some kind of insight on this issue as I cannot find anything on this. We are having an issue with CF9 with images not printing. We do a ton of pdf generation each day, and right now have a clients code updated to cf9. Its very simple code, and below is what is used: cfpdf action=addheader source=#ID# destination=#path#/#doc_id#.pdf pages=1 overwrite=yes image=images/thelogo.jpg align=right topmargin=1.25 The problem is that it is in fact inserting the header image into the pdf file, but when you randomly print some of these pdfs the image will not print. This doesn't happen to ever one, but maybe 50%. I cannot find any rhyme or reason to this, nor can I find anything over the internetz. If anyone has seen this issue or has any insight, it would be GREATLY appreciate! Thanks, Ryan ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338767 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anonymous Feedback Form: Prevent Malicious Code On Documents
I know that computer forensics folks have access to software that can scan images and essentially look for a certain amount of flesh tones in the images. I have no idea if there is a stripped down utility that could do this (as the software they play with is quite expensive)just letting you know there are more automated methods than humans viewing every image and allowing/dis-allowing HTH Cheers On Tue, 2010-11-02 at 14:14 -0400, Matthew Lowrey wrote: Thanks Brook: I agree this looks like the best method so far. I also forgot to mention images, if one was to upload images that were inappropriate, is there a way to 'flag' them or would human verification be the only resort to this type of situation. I want to say there's some way of flagging certain types of images like porno, but I can't remember. I thought there was a way I saw it done while in the military but my memory fails me. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338768 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFSTOREDPROC and invalid SQL
Hi all,
So I'm very stuck and tired of saying mean things to my computer... so I hope
you are able to see something I'm missing.
In short, in order to trouble shoot a larger stored proc call, I've created a
very simple one to get working first. It just returns a value.
Platforms: Oracle11g / CFMX7 (oracle drivers) / IIS6
The Stored Proc:
CREATE OR REPLACE PROCEDURE FUNDING.OMGItsMixedCase (datetext out varchar2
) is --AUTHID CURRENT_USER IS
BEGIN -- executable part starts here
datetext := to_char(sysdate, '-mm-dd');
END;
/
---
The CF Code to call it:
!--- I know setting the storedProc var works since I can call a different
storedProc on another schema with this method, though it requires nothing
passed in. ie: this code approach works elsewhere ---
cfset storedProc = FUNDING. OMGItsMixedCase()
cfstoredproc procedure=#storedProc# dataSource=databasemonster debug=yes
returncode=yes
cfprocparam type=out cfsqltype=CF_SQL_VARCHAR dbvarname=datetext
/
/cfstoredproc
The error: (nemisis)
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00900: invalid SQL statement
The error occurred in D:\somepath\act_updateProgramFund.cfm: line 50
48 :
49 : cfstoredproc procedure=#storedProc# dataSource=databasemonster
debug=yes returncode=yes
50 :cfprocparam type=out cfsqltype=CF_SQL_VARCHAR dbvarname=datetext
/
51 : /cfstoredproc
52 :
SQL { (param 1) = call P3DEVELOPER.date_text()( (param 2) )}
DATASOURCE oracle1srvr
VENDORERRORCODE 900
SQLSTATE 42000
What's with the param 1 in front of the call? then another param 2??
Thanks for your time and effort,
Brent
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338769
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFSTOREDPROC and invalid SQL
returncode=yes What's with the param 1 in front of the call? then another param 2?? A complete guess from a non-Oracle person, but ... could it be for the return code? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338770 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFSTOREDPROC and invalid SQL
returncode=yes
What's with the param 1 in front of the call? then another
param 2??
A complete guess from a non-Oracle person, but ... could it be for the return
code?
Ok, I've removed returncode and debug and now have the following.
cfstoredproc procedure=#storedProc# dataSource=bigdatabasemonster
cfprocparam type=out cfsqltype=CF_SQL_VARCHAR dbvarname=datetext
/
/cfstoredproc
Returns:
SQL {call P3DEVELOPER.date_text()( (param 1) )}
All the rest is the same error.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338771
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFSTOREDPROC and invalid SQL
I had incorrect information in my error in the previous two posts.
It should read:
The error: (nemisis)
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00900: invalid SQL statement
The error occurred in D:\somepath\act_updateProgramFund.cfm: line 50
48 :
49 : cfstoredproc procedure=#storedProc# dataSource=databasemonster
debug=yes returncode=yes
50 : cfprocparam type=out cfsqltype=CF_SQL_VARCHAR dbvarname=datetext
/
51 : /cfstoredproc
52 :
SQL {call FUNDING.date_text()( (param 1) )}
DATASOURCE oracle1srvr
VENDORERRORCODE 900
SQLSTATE 42000
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338772
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
What is wrong with this loop update?
I am trying to update multiple rows by looping through: cfloop query=GetExpOrg (diagnostics) cfoutputrow: #GetExpOrg.currentrow# id: #GetExpOrg.ExpOrg_ID#/cfoutputbr cfquery datasource=#application.datasource# name=UpdateExpOrg update Project_ExpOrg set OrgValue=(select org_value from expressionorganism3 where exporg_id = #GetExpOrg.ExpOrg_ID#) where project_id = #url.ProjectId# /cfquery /cfloop my diagnostics give me: row: 1 id: 2 row: 2 id: 693 so that is ok. but both rows are updated with the last value (693) instead of being individually updated? What's wrong with this? TNX if you can help. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338773 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Trying to create a Webservice for SAP Client [spamtrap bayes][spamtrap heur]
Matt, I tried to use the Web Services capability within Coldfusion for integrating into QuickBooks, and ended up with a work around. Here is some sample code that hopefully can help you: cfif isXmlDoc(xmlin) cftry cfset writeoutfile = 0 cfset filetime = #DateFormat(now(), MMDD)#-#TimeFormat(now(), HHmmss)# cfset wsmethod = xmlin.Envelope.Body.XmlChildren[1].XmlName cfswitch expression=#listlast(wsmethod, ':')# cfcase value = serverVersion !--- serverVersion method --- cfset xmlOut = '?xml version=1.0 encoding=utf-8? soap:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/; soap:Body serverVersionResponse xmlns=http://developer.intuit.com/; serverVersionResult xsi:type=xsd:stringV1/serverVersionResult /serverVersionResponse /soap:Body /soap:Envelope' /cfcase cfcase value = clientVersion !--- clientVersion method --- cfset strVersion = xmlin.Envelope.Body.clientVersion.strVersion.XmlText cfset xmlOut = '?xml version=1.0 encoding=utf-8? soap:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/; soap:Body clientVersionResponse xmlns=http://developer.intuit.com/; clientVersionResult xsi:type=xsd:stringO:2.0.0.139/clientVersionResult /clientVersionResponse /soap:Body /soap:Envelope' /cfcase This was built off of work by http://www.cf-ezcart.com/qwc-starter-kit.cfm. So thanks to them for helping me. Andy Quoting Matthew Friedman m...@hozgroup.com: I somewhat new to webservices (ie creating them) not consuming them... We need to create a webservice for an SAP intergrtaion that will send us an XML file and we will return an a packet of information that will tell them if it is success and provide a url to open a new window or some error code on why it failed. I created a CFC and was able to test our wdsl using soapUI but I am being told that the defensions that CF is creating in the WSDL are not valid and SAP can not consume the service. Also I am trying to understand how I return an xml package back in the soap return not just a single value. Any help on this would be great and if there are any good resourse on how to do this with SAP out there that would also be helpful. Thanks in advance. Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338774 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Trying to create a Webservice for SAP Client [spamtrap bayes][spamtrap heur]
Matt, I tried to use the Web Services capability within Coldfusion for integrating into QuickBooks, and ended up with a work around. Here is some sample code that hopefully can help you: cfif isXmlDoc(xmlin) cftry cfset writeoutfile = 0 cfset filetime = #DateFormat(now(), MMDD)#-#TimeFormat(now(), HHmmss)# cfset wsmethod = xmlin.Envelope.Body.XmlChildren[1].XmlName cfswitch expression=#listlast(wsmethod, ':')# cfcase value = serverVersion !--- serverVersion method --- cfset xmlOut = '?xml version=1.0 encoding=utf-8? soap:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/; soap:Body serverVersionResponse xmlns=http://developer.intuit.com/; serverVersionResult xsi:type=xsd:stringV1/serverVersionResult /serverVersionResponse /soap:Body /soap:Envelope' /cfcase cfcase value = clientVersion !--- clientVersion method --- cfset strVersion = xmlin.Envelope.Body.clientVersion.strVersion.XmlText cfset xmlOut = '?xml version=1.0 encoding=utf-8? soap:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/; soap:Body clientVersionResponse xmlns=http://developer.intuit.com/; clientVersionResult xsi:type=xsd:stringO:2.0.0.139/clientVersionResult /clientVersionResponse /soap:Body /soap:Envelope' /cfcase This was built off of work by http://www.cf-ezcart.com/qwc-starter-kit.cfm. So thanks to them for helping me. Andy Quoting Matthew Friedman m...@hozgroup.com: I somewhat new to webservices (ie creating them) not consuming them... We need to create a webservice for an SAP intergrtaion that will send us an XML file and we will return an a packet of information that will tell them if it is success and provide a url to open a new window or some error code on why it failed. I created a CFC and was able to test our wdsl using soapUI but I am being told that the defensions that CF is creating in the WSDL are not valid and SAP can not consume the service. Also I am trying to understand how I return an xml package back in the soap return not just a single value. Any help on this would be great and if there are any good resourse on how to do this with SAP out there that would also be helpful. Thanks in advance. Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338775 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFShopKart
Product Import Step 3 Creating columns in temporary table... 0% Completed Error We are sorry, but your request could not be completed. Please change the address bar in your browser to point to our homepage and try your request again. Thank you When trying import products from a csv file or database I get to the 3rd step and get the above error. I posted on the support forums but doesn't seem to be much traffic over there. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338776 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What is wrong with this loop update?
You say you're trying to update multiple rows... but your WHERE is stating, WHERE project_id = #URL.projectID#. Since URL.projectID most likely isn't changing during the iteration of that loop, you'll only ever be updating one row 'x' number of times. On Tue, Nov 2, 2010 at 4:28 PM, Rick Colman rcol...@cox.net wrote: I am trying to update multiple rows by looping through: cfloop query=GetExpOrg (diagnostics) cfoutputrow: #GetExpOrg.currentrow# id: #GetExpOrg.ExpOrg_ID#/cfoutputbr cfquery datasource=#application.datasource# name=UpdateExpOrg update Project_ExpOrg set OrgValue=(select org_value from expressionorganism3 where exporg_id = #GetExpOrg.ExpOrg_ID#) where project_id = #url.ProjectId# /cfquery /cfloop my diagnostics give me: row: 1 id: 2 row: 2 id: 693 so that is ok. but both rows are updated with the last value (693) instead of being individually updated? What's wrong with this? TNX if you can help. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338777 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
HELP!!! REgEx, XML and a Qutation Mark
I am trying to export our product list to an XML feed. It works pretty well except that one of the products, has a quotation mark in it that nothing seems to like. I believe it is a cut and past issue and that the quotation mark is a special character. It is this one right here â No matter what I do I cannot get rid of this thing. And if I do search in the resulting file, I cannot search for a because it is not the same. I am doing this, and that is not getting rid of it... cfset title = REReplaceNoCase(title,(.|\n)*?â,,ALL) / cfset title = REReplace(title, [^0-9a-zA-Z_], , ALL) / and I am wrapping the tag like this... title![CDATA[ #Trim(XmlFormat(title))# ]]/title What else can I do, besides go into the database and delete it. I would like a code solution. Thanks in advance. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338778 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: HELP!!! REgEx, XML and a Qutation Mark
I am trying to export our product list to an XML feed. It works pretty well except that one of the products, has a quotation mark in it that nothing seems to like. It is this one right here ââ¬Â I believe that's a fancy quote likely pasted from Word or some other word processing application. Change the quote in the database to a standard ascii character and the XMLFormat() should pick it up and change it to the character entity in the output (which should eliminate the need for the CDATA block as well. Alternately, if you switch the character encoding modes and the encoding of your XML file to UTF-8 all around (and the application you're importing to properly supports Unicode) then that may also allow the character to remain without error. -Justin Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338779 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
