Re: Lite CFML Editor
You may want to take a look at Brackets - http://brackets.io ~Steve On Thu, Jan 10, 2013 at 7:29 PM, John M Bliss bliss.j...@gmail.com wrote: Hi! Quick poll: I'd like to install a lite, free, CFML editor onto a computer (not my main computer) where the editor is suitable for me to use my iPad to RDC to the computer and edit existing code. Suggestions? -- John Bliss - http://about.me/jbliss ~| 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:353828 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Lite CFML Editor
Notepad++ has a ColdFusion plugin, and it is kind of nice to have color coding. Steve -Original Message- From: Steve Milburn [mailto:scmilb...@gmail.com] Sent: Friday, January 11, 2013 8:10 AM To: cf-talk Subject: Re: Lite CFML Editor You may want to take a look at Brackets - http://brackets.io ~Steve ~| 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:353829 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfset this.scriptProtect = No
Hi. I have a question about the wisdom of disabling the scriptProtect function in application.cfc. In my application.cfc, I have set cfset this.scriptProtect = No . like this: cfcomponent output=false cfset this.scriptProtect = No I did this to allow my client to paste the OBJECT tag into TinyMCE in her content management system. Previously, when she pasted: OBJECT classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354 codebase=http://fpdownload.macromedia.com/get/flashplayer/current/swflash.c ab id=Player_8fb00b70-06ad-4ced-acd0-5ba940ba131c WIDTH=500px HEIGHT=175px .. etc . ..ColdFusion would replace OBJECT with InvalidTag. She needs to paste in embed codes for various Amazon widgets. I have read up on Pete Freitag's notes about the scriptProtect function. My question: is there a safer way to allow my client to paste in her Amazon widgets into TinyMCE? I prefer to not turn off scriptProtect , even if its protection is incomplete. Thank you for any advice. Eric p.s. in my edit form (which updates the data table) I have set: !--- in user-editable form fields, set up protection against XSS --- cfloop collection=#FORM# item=field cfset FORM[ field ] = ReReplaceNoCase (FORM[ field ], script.*?.*?/script, , all) /cfloop I do not know if that offsets disabling the scriptProtect function. ~| 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:353830 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Lite CFML Editor
Thanks! On Fri, Jan 11, 2013 at 7:11 AM, DURETTE, STEVEN J sd1...@att.com wrote: Notepad++ has a ColdFusion plugin, and it is kind of nice to have color coding. Steve -Original Message- From: Steve Milburn [mailto:scmilb...@gmail.com] Sent: Friday, January 11, 2013 8:10 AM To: cf-talk Subject: Re: Lite CFML Editor You may want to take a look at Brackets - http://brackets.io ~Steve ~| 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:353831 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Newbie question regarding MSSQL queries w/ CF8
Hello all! I am new to ColdFusion and web development in general, and have only had cursory training in programming (Python). I have a need for a web page that will accept either an absolute number or percentile from the end-user (I'm still having trouble w/ the 'form' functionality of HTML), and then set the variable (or parameter?) rows to the number chosen, then choose THAT number of records at random from the database (MSSQL). Then I would like to display them (in no particular order) in plain-old HTML, CSS and other stylization is not important at this point, solely the functionality of the page. Here is my code: cfquery name=rs datasource=#application.dsn# SELECT * FROM DONOR /cfquery cfset displayRow = randRange(1,rs.recordcount) cfparam name = rows default = 5 cfoutput query=rs startrow=#displayRow# maxrows=#rows# br /h3#displayRow#nbsp;nbsp;nbsp;#first#nbsp;nbsp;nbsp;#last#nbsp;nbsp;nbsp;#flag#/h3br / /cfoutput The table name is 'DONOR', and the fields I want to display from it are 'first', 'last', and 'flag'. I'm wondering at this point why when I run the page, the output indeed picks a random record to start with, but then displays the next four sequentially instead of choosing the other four at random. I am more than happy to post a screencap of my browser output if need be. Your help is much appreciated as I am quite stumped and I hope you all can point me in the right direction. ~| 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:353832 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Newbie question regarding MSSQL queries w/ CF8
It's because that's the way cfoutput works. Try something like this: cfoutput cfloop index=i from=1 to=#rows# cfset displayRow = randrange(1, rs.recordcount) br /h3#displayRow# #rs.first[displayRow]# #rs.last[displayRow]# #rs.flag[displayRow]#/h3br / /cfloop /cfoutput On Fri, Jan 11, 2013 at 4:17 PM, B Griffith br.griff...@yahoo.com wrote: Hello all! I am new to ColdFusion and web development in general, and have only had cursory training in programming (Python). I have a need for a web page that will accept either an absolute number or percentile from the end-user (I'm still having trouble w/ the 'form' functionality of HTML), and then set the variable (or parameter?) rows to the number chosen, then choose THAT number of records at random from the database (MSSQL). Then I would like to display them (in no particular order) in plain-old HTML, CSS and other stylization is not important at this point, solely the functionality of the page. Here is my code: cfquery name=rs datasource=#application.dsn# SELECT * FROM DONOR /cfquery cfset displayRow = randRange(1,rs.recordcount) cfparam name = rows default = 5 cfoutput query=rs startrow=#displayRow# maxrows=#rows# br /h3#displayRow# #first# #last# #flag#/h3br / /cfoutput The table name is 'DONOR', and the fields I want to display from it are 'first', 'last', and 'flag'. I'm wondering at this point why when I run the page, the output indeed picks a random record to start with, but then displays the next four sequentially instead of choosing the other four at random. I am more than happy to post a screencap of my browser output if need be. Your help is much appreciated as I am quite stumped and I hope you all can point me in the right direction. ~| 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:353833 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Newbie question regarding MSSQL queries w/ CF8
Because that is what you ate telling it to do. Start from row x, and then output the next 4 rows. If you want to get 5 random rows then you need to create a loop from 1 to 5, inside that loop generate your random number, then get that row. To get a specific row from a query use Queryname[row].column Or it might be Queryname[column name][row] I forget the exact syntax. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Jan 11, 2013 10:17 PM, B Griffith br.griff...@yahoo.com wrote: Hello all! I am new to ColdFusion and web development in general, and have only had cursory training in programming (Python). I have a need for a web page that will accept either an absolute number or percentile from the end-user (I'm still having trouble w/ the 'form' functionality of HTML), and then set the variable (or parameter?) rows to the number chosen, then choose THAT number of records at random from the database (MSSQL). Then I would like to display them (in no particular order) in plain-old HTML, CSS and other stylization is not important at this point, solely the functionality of the page. Here is my code: cfquery name=rs datasource=#application.dsn# SELECT * FROM DONOR /cfquery cfset displayRow = randRange(1,rs.recordcount) cfparam name = rows default = 5 cfoutput query=rs startrow=#displayRow# maxrows=#rows# br /h3#displayRow# #first# #last# #flag#/h3br / /cfoutput The table name is 'DONOR', and the fields I want to display from it are 'first', 'last', and 'flag'. I'm wondering at this point why when I run the page, the output indeed picks a random record to start with, but then displays the next four sequentially instead of choosing the other four at random. I am more than happy to post a screencap of my browser output if need be. Your help is much appreciated as I am quite stumped and I hope you all can point me in the right direction. ~| 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:353834 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Newbie question regarding MSSQL queries w/ CF8
If you're wanting rows to be sorted randomly, you should be doing this at the database level. That's one of the items RDBMS's are really good at. For SQL Server, check out the post below. http://stackoverflow.com/questions/848872/select-n-random-rows-from-sql-server-table On Fri, Jan 11, 2013 at 4:17 PM, B Griffith br.griff...@yahoo.com wrote: Hello all! I am new to ColdFusion and web development in general, and have only had cursory training in programming (Python). I have a need for a web page that will accept either an absolute number or percentile from the end-user (I'm still having trouble w/ the 'form' functionality of HTML), and then set the variable (or parameter?) rows to the number chosen, then choose THAT number of records at random from the database (MSSQL). Then I would like to display them (in no particular order) in plain-old HTML, CSS and other stylization is not important at this point, solely the functionality of the page. Here is my code: cfquery name=rs datasource=#application.dsn# SELECT * FROM DONOR /cfquery cfset displayRow = randRange(1,rs.recordcount) cfparam name = rows default = 5 cfoutput query=rs startrow=#displayRow# maxrows=#rows# br /h3#displayRow# #first# #last# #flag#/h3br / /cfoutput The table name is 'DONOR', and the fields I want to display from it are 'first', 'last', and 'flag'. I'm wondering at this point why when I run the page, the output indeed picks a random record to start with, but then displays the next four sequentially instead of choosing the other four at random. I am more than happy to post a screencap of my browser output if need be. Your help is much appreciated as I am quite stumped and I hope you all can point me in the right direction. ~| 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:353835 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Lite CFML Editor
1++ for Notepad++ I don't know if they fixed the plugin installer for the CF lexer but the last time I installed it I had to do it manually. The downloads are here.. Just unzip it and follow the instructions, https://bitbucket.org/bbluemel/nppcoldfusion/downloads The manual install requires SQLLite. More info here: https://bitbucket.org/bbluemel/nppcoldfusion/wiki/Home HTH G! On Fri, Jan 11, 2013 at 8:11 AM, DURETTE, STEVEN J sd1...@att.com wrote: Notepad++ has a ColdFusion plugin, and it is kind of nice to have color coding. Steve -Original Message- From: Steve Milburn [mailto:scmilb...@gmail.com] Sent: Friday, January 11, 2013 8:10 AM To: cf-talk Subject: Re: Lite CFML Editor You may want to take a look at Brackets - http://brackets.io ~Steve ~| 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:353836 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Newbie question regarding MSSQL queries w/ CF8
Here's an excellent resource for random row generation using SQL. http://www.petefreitag.com/item/466.cfm ~| 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:353837 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Newbie question regarding MSSQL queries w/ CF8
I was assuming he was just doing a learn CF exercise. If not, agreed he should do it in SQL Server. On Jan 11, 2013 4:52 PM, Chester Austin chesteraus...@gmail.com wrote: Here's an excellent resource for random row generation using SQL. http://www.petefreitag.com/item/466.cfm ~| 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:353838 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm