SQL Azure and Coldfusion 9
FYI, SQL Azure is not part of the support matrix for ColdFusion. http://www.adobe.com/products/coldfusion/pdfs/cf9_support_matrix_4_ue.pdf There's an issue with SQL Azure where certain types of queries that when returning zero records, will not populate recordcount or set the query variable at all. After contacting Adobe about a patch for this for ColdFusion 9, Adobe indicated that SQL Azure is not supported and closed the support ticket. I have a ticket opon on the Microsoft side, and still trying to identify whether it is the JDBC driver itself or something specific with SQL Azure. For now, if considering SQL Azure, likely not an option for production at this time unless willing to write overly defensive 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:339540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Backing up a record in a cfloop
I'd like to put a separation divider (eg. '') in a dropdown box list whose values are populated using a cfloop. Once the divider is shown, I set a variable to not show that divider again. However I need to backup one record in order to show the actual record's value that was replaced in the loop with my divider. I could probably insert the divider into database query but I'm wondering if it is possible to skip -1 record within a cfloop. Hope this makes sense. 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:339541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Backing up a record in a cfloop
Why do you need to skip an iteration? Just put an if inside the loop as to whether to display the --. Psuedo: loop if myCondition = true option value=---/option set myCondition = false / /if option value=#queryLoopData##queryLoopData#/option /loop On Fri, Nov 26, 2010 at 11:05 AM, Richard Steele r...@photoeye.com wrote: I'd like to put a separation divider (eg. '') in a dropdown box list whose values are populated using a cfloop. Once the divider is shown, I set a variable to not show that divider again. However I need to backup one record in order to show the actual record's value that was replaced in the loop with my divider. I could probably insert the divider into database query but I'm wondering if it is possible to skip -1 record within a cfloop. Hope this makes sense. 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:339542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Javascript in fckEditor
Hello all. I am added content to my database via fckEditor and everytime I add a page with javascript on it, the editor acts up when I view try to edit it. The text field disappears and the content is actually displayed on the page. Any suggestions? Thanks and hope everyone enjoyed your holiday! ~| 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:339543 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Azure and Coldfusion 9
Sean, This is actually incredibly easy to deal with this scenario, you just have to check for the existence of the query variable first. You would normally check the recordcount 0 anyway so you don't output nothing, so it really isn't any more work. Russ -Original Message- From: Sean Henderson [mailto:shender...@followup.net] Sent: 26 November 2010 17:07 To: cf-talk Subject: SQL Azure and Coldfusion 9 FYI, SQL Azure is not part of the support matrix for ColdFusion. http://www.adobe.com/products/coldfusion/pdfs/cf9_support_matrix_4_ue.pdf There's an issue with SQL Azure where certain types of queries that when returning zero records, will not populate recordcount or set the query variable at all. After contacting Adobe about a patch for this for ColdFusion 9, Adobe indicated that SQL Azure is not supported and closed the support ticket. I have a ticket opon on the Microsoft side, and still trying to identify whether it is the JDBC driver itself or something specific with SQL Azure. For now, if considering SQL Azure, likely not an option for production at this time unless willing to write overly defensive 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:339544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Backing up a record in a cfloop
Duh! Of course! Thanks for clearing my brain cramp. Why do you need to skip an iteration? Just put an if inside the loop as to whether to display the --. Psuedo: loop if myCondition = true option value=---/option set myCondition = false / /if option value=#queryLoopData##queryLoopData#/option /loop ~| 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:339545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Javascript in fckEditor
By default FCKEditor renders your code. It's handy but might not be what you want. -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: Friday, November 26, 2010 9:31 AM To: cf-talk Subject: Javascript in fckEditor Hello all. I am added content to my database via fckEditor and everytime I add a page with javascript on it, the editor acts up when I view try to edit it. The text field disappears and the content is actually displayed on the page. Any suggestions? Thanks and hope everyone enjoyed your holiday! ~| 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:339546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm