coldfusion 10 Host My Site SQL permission
HMS moved site to CF10 server. For the past 5+ years I've used scripting quite often to create and alter tables for this site. Now when running script I receive error: Executing the SQL statement is not allowed. I can confirm datasource, username, password, dbtype are all correct. HMS reviewed code and CF Server setting and respond that everything is set up properly and should work. Any ideas? ~| 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:351861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion 10 Host My Site SQL permission
HMS moved site to CF10 server. For the past 5+ years I've used scripting quite often to create and alter tables for this site. Now when running script I receive error: Executing the SQL statement is not allowed. I can confirm datasource, username, password, dbtype are all correct. HMS reviewed code and CF Server setting and respond that everything is set up properly and should work. I suspect that the CF datasource is not configured to allow execution of CREATE and ALTER statements - there's an option right in the datasource settings for this. 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:351862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion 10 Host My Site SQL permission
I hope you ASKED to be moved to CF10. On Mon, Jul 9, 2012 at 8:37 PM, Dave Watts dwa...@figleaf.com wrote: HMS moved site to CF10 server. For the past 5+ years I've used scripting quite often to create and alter tables for this site. Now when running script I receive error: Executing the SQL statement is not allowed. I can confirm datasource, username, password, dbtype are all correct. HMS reviewed code and CF Server setting and respond that everything is set up properly and should work. I suspect that the CF datasource is not configured to allow execution of CREATE and ALTER statements - there's an option right in the datasource settings for this. 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:351863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion 10 Host My Site SQL permission
Randy, What is the account number, domain or ticket number and I can take a deeper look. Feel free to contact me directly. ma...@hostmysite.com On Tue, Jul 10, 2012 at 3:15 PM, Randy Messer rmes...@digitecinteractive.com wrote: HMS moved site to CF10 server. For the past 5+ years I've used scripting quite often to create and alter tables for this site. Now when running script I receive error: Executing the SQL statement is not allowed. I can confirm datasource, username, password, dbtype are all correct. HMS reviewed code and CF Server setting and respond that everything is set up properly and should work. Any ideas? ~| 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:351864 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
inserting a new row at the top of CSV file
unusual request I know, I have a CSV file with lots of rows but it has no column headings. Is there a way of inserting a row at the top of the file (1st row) with the heading names? any help would be appreciated. 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:351865 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
inserting a new row at the top of CSV file
Unusual request I know, I have a CSV file with lots of rows but it has no headings, is there a way of inserting a new row at the top of the CSV file with some heading names? Any help would be greatly appreciated. ~| 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:351866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: inserting a new row at the top of CSV file
cffile action=read file=myfile.csv variable=myvariable cfset myvariable = header1,header2,header3 chr(13) chr(10) myvariable cffile action=write file=myfile.csv output=#myvariable# On Tue, Jul 10, 2012 at 1:57 PM, Akos Fortagh akos.fort...@yahoo.comwrote: Unusual request I know, I have a CSV file with lots of rows but it has no headings, is there a way of inserting a new row at the top of the CSV file with some heading names? Any help would be greatly appreciated. ~| 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:351867 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion 10 Host My Site SQL permission
Just to let everyone know, I believe I resolved this issue for Randy. Appears the CF10 default for creating new DSNs on the server his new site is on, only enables SELECT, INSERT, UPDATE and DELETE by default. So it's necessary to expand the additional settings and enable the additional options. I let our system admins know about this and they are going to look into if this is a CF10 issue or something with that particular installation. I checked our internal CF10 servers and this does not seem to be the case, so it may just be this particular instance. Byron Mann Lead Engineer Architect | Hosting.com | Delaware On Tue, Jul 10, 2012 at 3:15 PM, Randy Messer rmes...@digitecinteractive.com wrote: HMS moved site to CF10 server. For the past 5+ years I've used scripting quite often to create and alter tables for this site. Now when running script I receive error: Executing the SQL statement is not allowed. I can confirm datasource, username, password, dbtype are all correct. HMS reviewed code and CF Server setting and respond that everything is set up properly and should work. Any ideas? ~| 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:351868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion 10 Host My Site SQL permission
HMS has updated setting for my account on server to enable CREATE, ALTER, etc. Consider issue resolved HMS moved site to CF10 server. For the past 5+ years I've used scripting quite often to create and alter tables for this site. Now when running script I receive error: Executing the SQL statement is not allowed. I can confirm datasource, username, password, dbtype are all correct. HMS reviewed code and CF Server setting and respond that everything is set up properly and should work. I suspect that the CF datasource is not configured to allow execution of CREATE and ALTER statements - there's an option right in the datasource settings for this. 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:351869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Code Re-Factoring
Question: Has anyone ever had to do code re-factoring that involved taking attributes from one set of tags and moving them to a different set of tags within the same template? For example taking the attributes from the following tag cfmodule template='#header#' sorttable=true useJQuery='true' and moving them to this tag cfmodule template='#footer#'. Client has switched to using Boilerplate for JS stuff and wanted all the tags that referenced a set of attributes from the site wide header file to be moved to the footer file. My first thought was to write up some ColdFusion code to parse through all the files and use RegEx to manipulate the code in the templates. Then as I thought through all the variables, the amount of code it would take to do it, and the fact that ColdFusion doesn't like parsing thought thousands of files [read that as request time out setting would be very high], I decided to just cut and paste by hand. However I was just wondering if anyone else has had to tackle this problem previously and what if any was your different solution to the problem. Side note: My quick search for GREP/ RegEx software to do it for me turned up nothing useful. ~| 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:351870 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Code Re-Factoring
How many #header# and #footer# files are there? If it's not hundreds this might work: You COULD - just bind the two together - cfmodule tags were created for this exact type of thing So, instead of having a cfmodule template='#header#' sorttable=true useJQuery='true' BUNCH O HTML AND CF HERE cfmodule template='#footer#' You'd have cfmodule template='#header#' sorttable=true useJQuery='true' BUNCH O HTML AND CF HERE /cfmodule To combine the #header# and #footer# cfmodules to each other - simply add the footer CF/html to the header cf/html in this cfif THISTAG.ExecutionMode IS Startheader content here/cfif cfif THISTAG.ExecutionMode IS Endfooter content here/cfif Then the values from the opening cfmodule tag will be available to all of your closing footer tags as well. Feel free to ping me off list with any specific questions alan dot rother at gmail dot com -- Alan Rother Manager, Phoenix Cold Fusion User Group, www.AZCFUG.org Twitter: @AlanRother ~| 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:351871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Code Re-Factoring
IntelliJ IDEA seems to get the best rep for refactoring. On 7/10/12 2:15 PM, Brett Davis wrote: Question: Has anyone ever had to do code re-factoring that involved taking attributes from one set of tags and moving them to a different set of tags within the same template? For example taking the attributes from the following tag cfmodule template='#header#' sorttable=true useJQuery='true' and moving them to this tag cfmodule template='#footer#'. Client has switched to using Boilerplate for JS stuff and wanted all the tags that referenced a set of attributes from the site wide header file to be moved to the footer file. My first thought was to write up some ColdFusion code to parse through all the files and use RegEx to manipulate the code in the templates. Then as I thought through all the variables, the amount of code it would take to do it, and the fact that ColdFusion doesn't like parsing thought thousands of files [read that as request time out setting would be very high], I decided to just cut and paste by hand. However I was just wondering if anyone else has had to tackle this problem previously and what if any was your different solution to the problem. Side note: My quick search for GREP/ RegEx software to do it for me turned up nothing useful. ~| 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:351872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Code Re-Factoring
Alan it's 375 files that need to be changed and I'm almost done doing it manually. However, I never would have thought to effectively merge the header and footer files and use the start/ end on the module. See this is why I love House of Fusion always can get a awesome answer on weird questions. Thanks Alan! ~| 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:351873 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
New line character for SMS sent via Clickatell HTTP API
Hi All, I have tried MANY characters to force a new line in a text message sent via Clickatell's HTTP API using CFHTTP Their docs say to use 0%A which is of course the urlEncodedFormat() for a new line ...when I send that it just shows in the message as a string (when viewing on Android phone).have tried br tagshave tried \r \n.have tried HEXalways just show as strings ...and there are many more opinions online and in Clickatell's docs Has anyone out there successfully done this? If so, please share some code ;-) Thanks in advance Cheers -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. - makers of FACTS⢠phone: 250.480.0642 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com and www.fisheryfacts.com Please consider the environment before printing this e-mail -CONFIDENTIALITY-- 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. ~| 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:351874 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
