<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:clearspace="http://www.jivesoftware.com/xmlns/jive/rss" version="2.0">
  <channel>
    <title>Adobe Community : All Content - All Communities</title>
    <link>https://forums.adobe.com/</link>
    <description>All Content in Adobe Community</description>
    <language>en</language>
    <pubDate>Sat, 08 Dec 2012 03:51:42 GMT</pubDate>
    <generator>Jive Engage 7.0.0.1  (http://jivesoftware.com/products/)</generator>
    <dc:date>2012-12-08T03:51:42Z</dc:date>
    <dc:language>en</dc:language>
    <item>
      <title>update failed</title>
      <link>https://forums.adobe.com/thread/1111811</link>
      <description>&lt;!-- [DocumentBodyStart:45d579fa-ca52-48fe-88ec-b308399c4a25] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I got an update message from ColdFusion 10.&lt;/p&gt;&lt;p&gt;I got failed error message to download &lt;/p&gt;&lt;p&gt;"failed signature&amp;nbsp; verification"&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Can you please advise where to check it?&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:45d579fa-ca52-48fe-88ec-b308399c4a25] --&gt;&lt;img src='/beacon?t=1415918115530' /&gt;</description>
      <pubDate>Sat, 08 Dec 2012 03:51:42 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1111811</guid>
      <dc:date>2012-12-08T03:51:42Z</dc:date>
      <clearspace:dateToText>1 week 2 days ago</clearspace:dateToText>
      <clearspace:replyCount>12</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>field date expression</title>
      <link>https://forums.adobe.com/thread/1613471</link>
      <description>&lt;!-- [DocumentBodyStart:3203bed1-dabf-4880-ba32-113b23f614b3] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;DateFormat(query.fromDay, "m/d") + "&amp;nbsp; "&amp;nbsp; + DateFormat(query.toDay, "m/d")&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I wanted to show my report field like ' from 10/20/2014 to 10/25/2014 and have above code in the expression.&lt;/p&gt;&lt;p&gt;I got error when run the report.&lt;/p&gt;&lt;p&gt;It works for one expression like DateFormat(query.fromDay, "m/d"), but it does not work to combine 2 of them together.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:3203bed1-dabf-4880-ba32-113b23f614b3] --&gt;</description>
      <pubDate>Tue, 21 Oct 2014 14:54:02 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1613471</guid>
      <dc:date>2014-10-21T14:54:02Z</dc:date>
      <clearspace:dateToText>3 weeks 2 days ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Reporting Excel missing clast column</title>
      <link>https://forums.adobe.com/thread/1579440</link>
      <description>&lt;!-- [DocumentBodyStart:19ad9820-9660-440a-83ad-cc83138250c4] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a report which has 40 columns and orientation is landscape. left and right margin is 0.0972 in.&lt;/p&gt;&lt;p&gt;It shows all columns on pdf format, but missing last column when use Excel format.&lt;/p&gt;&lt;p&gt;Are there any limitation for Excel format report?&lt;/p&gt;&lt;p&gt;If PDF format has the last column, why Excel does not pick the last column?&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:19ad9820-9660-440a-83ad-cc83138250c4] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">reporting.</category>
      <pubDate>Fri, 19 Sep 2014 16:15:27 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1579440</guid>
      <dc:date>2014-09-19T16:15:27Z</dc:date>
      <clearspace:dateToText>3 weeks 3 days ago</clearspace:dateToText>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>property inspector missing</title>
      <link>https://forums.adobe.com/thread/1612604</link>
      <description>&lt;!-- [DocumentBodyStart:62bba466-489c-496c-8f1a-a939efbd7b8a] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Property inspector of my ColdFusion Report Builder 10 missing suddenly, I tried to use View --&amp;gt; Panels --&amp;gt; Properties and Windows --&amp;gt; Inspector Properties, but it does not show.&lt;/p&gt;&lt;p&gt;Are there any way to show Properties Inspector from hiding?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:62bba466-489c-496c-8f1a-a939efbd7b8a] --&gt;</description>
      <pubDate>Mon, 20 Oct 2014 17:01:05 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1612604</guid>
      <dc:date>2014-10-20T17:01:05Z</dc:date>
      <clearspace:dateToText>3 weeks 3 days ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Reporting width scale and change group</title>
      <link>https://forums.adobe.com/thread/1586115</link>
      <description>&lt;!-- [DocumentBodyStart:dbef12f3-5e41-427c-8831-1a2c18555901] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a chart data source for 25 columns and assign to my line chart data source.&lt;/p&gt;&lt;p&gt;The chart shows data but only use 50 percent of the chart width.&lt;/p&gt;&lt;p&gt;I would like to have my chart extend the full width of the report which is landscape orientation.&lt;/p&gt;&lt;p&gt;Are there any property to set stretch the whole width?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;My report has group like element 1, element 2. Chart has evaluation group property to set.&lt;/p&gt;&lt;p&gt;I set it to my group name which is MyElement, but it seems that the chart prints the same chart for the all group.&lt;/p&gt;&lt;p&gt;Are there any property to set the the chart print different chart base on the group.&lt;/p&gt;&lt;p&gt;I have my chart in Group Footer. Should I have it in detail band?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks a million for the information and help,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:dbef12f3-5e41-427c-8831-1a2c18555901] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">reporting.</category>
      <pubDate>Fri, 26 Sep 2014 15:46:13 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1586115</guid>
      <dc:date>2014-09-26T15:46:13Z</dc:date>
      <clearspace:dateToText>1 month 3 weeks ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Specify Excel sheet name</title>
      <link>https://forums.adobe.com/thread/1577545</link>
      <description>&lt;!-- [DocumentBodyStart:71d65190-69df-4611-9fac-139ed2193edc] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a report and use Excel as its format.&lt;/p&gt;&lt;p&gt;The Excel sheet always name ColdFusionReport.&lt;/p&gt;&lt;p&gt;I would like to know are there any way to customize the Excel sheet name and it is possible to have the report pages become sheet 1, sheet 2.... instead of all pages on the first sheet.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&amp;nbsp; &lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:71d65190-69df-4611-9fac-139ed2193edc] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">reporting.</category>
      <pubDate>Wed, 17 Sep 2014 15:11:27 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1577545</guid>
      <dc:date>2014-09-17T15:11:27Z</dc:date>
      <clearspace:dateToText>1 month 4 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>sub report size at design time</title>
      <link>https://forums.adobe.com/thread/1578830</link>
      <description>&lt;!-- [DocumentBodyStart:9b56b4e2-35f0-45a9-91e3-d072d6a29afe] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I noticed that the size of sub report is limited on the main report at design time.&lt;/p&gt;&lt;p&gt;For example, if I have sub report hight at 1" then the maximum height will be 1" on the report at run time.&lt;/p&gt;&lt;p&gt;The design area has limit too, so if this is the case, my report design area is limited to my report.&lt;/p&gt;&lt;p&gt;Please let me know if I am wrong, or any work around for this,&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:9b56b4e2-35f0-45a9-91e3-d072d6a29afe] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">reporting.</category>
      <pubDate>Thu, 18 Sep 2014 20:52:26 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1578830</guid>
      <dc:date>2014-09-18T20:52:26Z</dc:date>
      <clearspace:dateToText>1 month 4 weeks ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>create Report charting data series</title>
      <link>https://forums.adobe.com/thread/1573336</link>
      <description>&lt;!-- [DocumentBodyStart:f246e880-0c89-466b-af92-8af1bfb383e3] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I want to add chart to my report and add a chart control on my report.&lt;/p&gt;&lt;p&gt;I double click on the chart and edit chart type as line chart and edit chart series.&lt;/p&gt;&lt;p&gt;I use Data from a fix of values and choose the field name from the drop down from my data source field name, but I got following error message.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;table border="0" cellpadding="0" cellspacing="0" style="width: 500px;"&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td align="left" style="border:0px solid black;" width="500"&gt;&lt;h1 style="color: black;"&gt;An error occurred while trying to create a chart on this report. &lt;/h1&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td colspan="2" style="border:0px solid black;" width="400"&gt;&lt;span style="color: black;"&gt;Ensure that the column(s) selected for the chart series are numerical values. Error: The chart could not be generated due to an error in the graphing engine. &lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I tried to select from data from query. I have to build my query from report.&lt;/p&gt;&lt;p&gt;I use a stored procedure for this report, so I need advance to build my query, once I use the stored procedure then Report Builder warn me that it will erase all fields to recreate fileds.&lt;/p&gt;&lt;p&gt;I would like to know what is the right procedure to create chart for the report.&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:f246e880-0c89-466b-af92-8af1bfb383e3] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">chart</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">reporting.</category>
      <pubDate>Fri, 12 Sep 2014 15:15:49 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1573336</guid>
      <dc:date>2014-09-12T15:15:49Z</dc:date>
      <clearspace:dateToText>1 month 4 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>13</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>report type flashpaper</title>
      <link>https://forums.adobe.com/thread/1565523</link>
      <description>&lt;!-- [DocumentBodyStart:4e0ce95b-d61e-4ca0-b32b-5382f1ca04f0] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I created a couple of reports and try to run different format.&lt;/p&gt;&lt;p&gt;I just realized that some report works flashpaper, but some of them do not.&lt;/p&gt;&lt;p&gt;I set default format to flashpaper at design time for all reports.&lt;/p&gt;&lt;p&gt;The reports work for PDF, Excel, RTF, XML and HTML, but for flashpaper some of them work, some of them do not.&lt;/p&gt;&lt;p&gt;I would like to know are there any property and code need to set it works.&lt;/p&gt;&lt;p&gt;I use IE 8 which should support flashpaper, since some of the reports work.&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:4e0ce95b-d61e-4ca0-b32b-5382f1ca04f0] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">reporting.</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">coldfusion 8</category>
      <pubDate>Thu, 04 Sep 2014 14:35:28 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1565523</guid>
      <dc:date>2014-09-04T14:35:28Z</dc:date>
      <clearspace:dateToText>2 months 1 week ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Report Type for pdf and Excel</title>
      <link>https://forums.adobe.com/thread/1558350</link>
      <description>&lt;!-- [DocumentBodyStart:c54094ee-c023-460f-9999-8a558ec6296d] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have following code to generate the report for pdf format.&lt;/p&gt;&lt;p&gt;I would like to let users to choose report type 'pdf' or 'excel'&lt;/p&gt;&lt;p&gt;I need pass the user select from user interface to &amp;lt;cfreport format= "PDF" or "Excel".&lt;/p&gt;&lt;p&gt;Can you please advise how I can pass the user select Report Type from lsReportType to my cfReport?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfstoredproc procedure="spGetReportType"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocresult name="rsReportType" resultset="1"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfstoredproc&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt; &amp;lt;cfreport format = "PDF" template= "MyReport.cfr" query="#myQuery#"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;/cfreport&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt; &amp;lt;td&amp;gt;&amp;lt;select width="50" name="lstReportType" id="lstReportType"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfoutput query="rsReportType"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;option value="#rsReportType.ReportTypeID#" &amp;lt;cfif (isDefined("form.ReportTypeID") AND form.ReportTypeID EQ rsReportType.ReportTypeID)&amp;gt;selected="selected"&amp;lt;/cfif&amp;gt;&amp;gt;#rsReportType.ReportType#&amp;lt;/option&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cfoutput&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/select&amp;gt;&amp;lt;/td&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:c54094ee-c023-460f-9999-8a558ec6296d] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">reporting"</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">coldfustion</category>
      <pubDate>Tue, 26 Aug 2014 18:09:36 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1558350</guid>
      <dc:date>2014-08-26T18:09:36Z</dc:date>
      <clearspace:dateToText>2 months 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Coonect RDS server issue</title>
      <link>https://forums.adobe.com/thread/1538919</link>
      <description>&lt;!-- [DocumentBodyStart:6e39d71e-609c-45cb-9458-b2b6350d07a0] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I tried to connect RDS server using ColdFusion Report Builder.&lt;/p&gt;&lt;p&gt;I got HTTP/1.1 404 Not Found.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I contacted Web Server Administrator that they said they created my ID and password.&lt;/p&gt;&lt;p&gt;I would like to know are there any way to check client side issue to connect to RDS server.&lt;/p&gt;&lt;p&gt;I have a ColdFusion developer version on my local machine and I am able to connect local developer version ColdFusion Server.&lt;/p&gt;&lt;p&gt;My local version is ColdFusion 10, remote server is ColdFusion 9.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:6e39d71e-609c-45cb-9458-b2b6350d07a0] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">rds</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">cold fusion</category>
      <pubDate>Mon, 04 Aug 2014 12:59:50 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1538919</guid>
      <dc:date>2014-08-04T12:59:50Z</dc:date>
      <clearspace:dateToText>3 months 1 week ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>set value for input text or textarea</title>
      <link>https://forums.adobe.com/thread/1491028</link>
      <description>&lt;!-- [DocumentBodyStart:c74d2fa0-4c27-4ba8-8c22-e88ed569e7ce] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I can use following code to set cfinput text and cftextarea a value from my database, but following code fails for html standard components like&lt;/p&gt;&lt;p&gt;&amp;lt;input type="text"&amp;gt; or textarea.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;CFINPUT type="text" name="Mytext" id="idMyText" value="#mySP.MyValue#" /&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Are there any way to set value from database for standard controls?&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:c74d2fa0-4c27-4ba8-8c22-e88ed569e7ce] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">coldfusion</category>
      <pubDate>Fri, 06 Jun 2014 13:18:48 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1491028</guid>
      <dc:date>2014-06-06T13:18:48Z</dc:date>
      <clearspace:dateToText>5 months 4 days ago</clearspace:dateToText>
      <clearspace:replyCount>3</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Growth Details Band</title>
      <link>https://forums.adobe.com/thread/1482933</link>
      <description>&lt;!-- [DocumentBodyStart:2427bd7e-a26b-42f8-8d73-9a4b855a443b] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a comments field from query result for report data source.&lt;/p&gt;&lt;p&gt;Because it is a navrchar(max) field, the result can be shorter or longer based on the data users entered.&lt;/p&gt;&lt;p&gt;I would like to have the text field and details band growth base on the data.&lt;/p&gt;&lt;p&gt;Are there any property to change it at run time or I need write UDF to do the task?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:2427bd7e-a26b-42f8-8d73-9a4b855a443b] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">reporting.</category>
      <pubDate>Mon, 26 May 2014 18:45:38 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1482933</guid>
      <dc:date>2014-05-26T18:45:38Z</dc:date>
      <clearspace:dateToText>5 months 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>can not adjust cftextarea hieght</title>
      <link>https://forums.adobe.com/thread/1482932</link>
      <description>&lt;!-- [DocumentBodyStart:b562e999-720c-4638-94b5-1fd226bc4843] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have following code for my cftextarea and try to make the height and width I need for the form for the users.&lt;/p&gt;&lt;p&gt;For some reason, it does not change the size even I modify row and col parameters.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Is it something I am missing to adjust the height and width of cftextarea?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;td&amp;gt;&amp;lt;CFtextarea name="MytxtArea"&amp;nbsp; id="MyTextArea"&amp;nbsp; row="6" col="10"/&amp;gt;&amp;lt;/td&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:b562e999-720c-4638-94b5-1fd226bc4843] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">coldfusion</category>
      <pubDate>Mon, 26 May 2014 18:40:27 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1482932</guid>
      <dc:date>2014-05-26T18:40:27Z</dc:date>
      <clearspace:dateToText>5 months 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>cffunction array parameter</title>
      <link>https://forums.adobe.com/thread/1480589</link>
      <description>&lt;!-- [DocumentBodyStart:bfe1b0a7-0bd1-498c-97fe-cb4935c97c0c] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have following code to get an array from jQuery to pass MS SQL Server stored procedure to update my tables.&lt;/p&gt;&lt;p&gt;Is it the right way to access array from passing jQuery function?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cffunction name="MyFunction" access="remote"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfargument name="MyData" type="any" required="true"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt; &amp;lt;cfif isJSON(arguments.MyData)&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfset arguments.MyData = deserializeJSON(arguments.MyData)&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cfif&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfstoredproc procedure = "MySP"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[1]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[2]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[3]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[4]#" CFSQLTYPE = "cf_sql_varchar"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[5]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[6]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[7]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[8]#" CFSQLTYPE = "CF_SQL_LONGVARCHAR"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[9]#" CFSQLTYPE = "CF_SQL_LONGVARCHAR"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[10]#" CFSQLTYPE = "cf_sql_date"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[11]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[12]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[13]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[14]#" CFSQLTYPE = "cf_sql_varchar"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[15]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[16]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[17]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[18]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[19]#" CFSQLTYPE = "cf_sql_numeric"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[20]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[21]#" CFSQLTYPE = "cf_sql_date"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[22]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[23]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#arguments.MyData[24]#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p&gt; &amp;lt;/cfstoredproc&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;/cffunction&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:bfe1b0a7-0bd1-498c-97fe-cb4935c97c0c] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">cold fusion</category>
      <pubDate>Thu, 22 May 2014 18:49:30 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1480589</guid>
      <dc:date>2014-05-22T18:49:30Z</dc:date>
      <clearspace:dateToText>5 months 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>11</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>limitation cf_sql_varchar length</title>
      <link>https://forums.adobe.com/thread/1480318</link>
      <description>&lt;!-- [DocumentBodyStart:151e9157-3e14-4f8c-9615-789196a0d3c7] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have following cffunction in my cfc and calling from jQuery.&lt;/p&gt;&lt;p&gt;I use MS SQL Server 2008 R2 and the field is nvarchar(max) in the database.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;The function fails to update when the string more than 800 characters.&lt;/p&gt;&lt;p&gt;I would like to know are there length limitation for cf_sql_varchar?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I tried to changed to CF_SQL_LONGVARCHAR, but it still fails when the text longer than 800 characters.&lt;/p&gt;&lt;p&gt;My users need to enter more than 800 characters.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Another issue is when the text has '%' then it wipe out all text and pass null to the MS SQL Server.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Any suggestion is appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cffunction name="Myfunction" access="remote"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfargument name ="MyField" required="no" default="" hint="My Field"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfstoredproc procedure = "MySP"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#MyField#" CFSQLTYPE = "cf_sql_varchar"&amp;gt;&lt;/p&gt;&lt;p&gt; &amp;lt;/cfstoredproc&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cffunction&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:151e9157-3e14-4f8c-9615-789196a0d3c7] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">coldfsuion</category>
      <pubDate>Thu, 22 May 2014 13:48:35 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1480318</guid>
      <dc:date>2014-05-22T13:48:35Z</dc:date>
      <clearspace:dateToText>5 months 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>3</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>cache query result issue</title>
      <link>https://forums.adobe.com/thread/1479505</link>
      <description>&lt;!-- [DocumentBodyStart:aa8f225b-a6a0-46d6-ab12-6985dd3423bb] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a link on the form to modify a table for the drop down select control.&lt;/p&gt;&lt;p&gt;The link works to add or modify data, but when I come back data entry form, the drop down does not refresh data. It remains same drop down, it does not add or modify the drop down.&lt;/p&gt;&lt;p&gt;It seems the drop down keep cache memory.&lt;/p&gt;&lt;p&gt;I would like to know are there any way to refresh the drop down box after user modify the physical drop down table.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your&amp;nbsp; help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:aa8f225b-a6a0-46d6-ab12-6985dd3423bb] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">coldfusion</category>
      <pubDate>Wed, 21 May 2014 13:45:31 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1479505</guid>
      <dc:date>2014-05-21T13:45:31Z</dc:date>
      <clearspace:dateToText>5 months 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>4</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>cffile action</title>
      <link>https://forums.adobe.com/thread/1479710</link>
      <description>&lt;!-- [DocumentBodyStart:37fe195a-1690-4139-93d3-38c654cf8031] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have the following code to upload file and using accept file type including "image/x-tiff, multipart/x-zip"&lt;/p&gt;&lt;p&gt;The code works for pdf, txt and msword, but I got error message like when I upload zip or tif files.&lt;/p&gt;&lt;p&gt;I would like to know if there is any configuration need to be done at server level,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt; &amp;lt;cffile action="UPLOAD" filefield="fleAttachment" destination="#UploadFolder#" &lt;/p&gt;&lt;p&gt;accept ="application/pdf, application/msword, application/vnd.ms-excel, text/plain, image/x-tiff, multipart/x-zip"&amp;nbsp; nameconflict="MAKEUNIQUE"&lt;/p&gt;&lt;p&gt;result="MyUpload"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Only files of type application/pdf, application/msword, application/vnd.ms-excel, text/plain, image/x-tiff, multipart/x-zip can be uploaded. &lt;/p&gt;&lt;p&gt;Verify that you are uploading a file of the appropriate type.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:37fe195a-1690-4139-93d3-38c654cf8031] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">coldfusion</category>
      <pubDate>Wed, 21 May 2014 17:26:37 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1479710</guid>
      <dc:date>2014-05-21T17:26:37Z</dc:date>
      <clearspace:dateToText>5 months 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>CFIF control form display</title>
      <link>https://forums.adobe.com/thread/1468438</link>
      <description>&lt;!-- [DocumentBodyStart:85425248-8f39-4829-a350-989749640e85] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I want to use following code to control elements on the form.&lt;/p&gt;&lt;p&gt;I use cfoutout that it shows the value is 0, but the cfif control does not show the cfselect on the form.&lt;/p&gt;&lt;p&gt;Is it the right way to do control on the form? &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt; &amp;lt;cfoutput&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; FORM site "#form.MySite#"&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cfoutput&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt; &amp;lt;CFIF structKeyExists(form,MySite)&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfif "#form.MySite#" EQ "0"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;tr&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;td&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfselect name="Mylst" id="Mylst"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/td&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/tr&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;/cfif&amp;gt;&lt;/p&gt;&lt;p&gt; &amp;lt;/cfif&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:85425248-8f39-4829-a350-989749640e85] --&gt;</description>
      <pubDate>Wed, 07 May 2014 13:34:27 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1468438</guid>
      <dc:date>2014-05-07T13:34:27Z</dc:date>
      <clearspace:dateToText>6 months 1 week ago</clearspace:dateToText>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Setup server root directory</title>
      <link>https://forums.adobe.com/thread/1465162</link>
      <description>&lt;!-- [DocumentBodyStart:384efcde-e19c-4d6b-b77c-a3fa8ecb8f04] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I am setting up a new site to my web server on Ubuntu Linux machine.&lt;/p&gt;&lt;p&gt;If I leave root directory empty then it copy my local files to \home\user\mywebsite&lt;/p&gt;&lt;p&gt;If I put /var/www/mywebsite then it says permission denied for hiding file. I think that DW to copy controls files to the server.&lt;/p&gt;&lt;p&gt;I would like to know which root directory I need put to leave blank or have /var/www/mysite.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:384efcde-e19c-4d6b-b77c-a3fa8ecb8f04] --&gt;</description>
      <pubDate>Sun, 04 May 2014 05:03:54 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1465162</guid>
      <dc:date>2014-05-04T05:03:54Z</dc:date>
      <clearspace:dateToText>6 months 1 week ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>ColdFusion 9 and ColdFusion 10</title>
      <link>https://forums.adobe.com/thread/1463982</link>
      <description>&lt;!-- [DocumentBodyStart:b35db747-7665-404c-901c-cf62c5d76563] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have following JavaScrip code which works for ColdFusion 10, but not ColdFsuion 9.&lt;/p&gt;&lt;p&gt;Because I have ColdFusion production server so I need find a solution for ColdFusion 9.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I use SQL Server 2008 as backend.&lt;/p&gt;&lt;p&gt;If SQL server returns datetime type then I can get curr_date, curr_month and curr_year.&lt;/p&gt;&lt;p&gt;The datetime type return is 'April, 25 2014 00:00:00', but I want to dispaly without time section and if it is possible that I need display like mm-dd-yyyy or yyyy-mm-dd have more compact display.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;If SQL server returns date type then rowdata, curr_date, curr_month, and curr_year are NaN.&lt;/p&gt;&lt;p&gt;SQL returns '2014-04-25' when I use Date Type which is what I need, but ColdFusion does not recognize when I pass to the other form and it reads NaN.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I understand that it is JavaScrip code, but for some reason they have different behavior on ColdFusion 9 and ColdFusion 10.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I would like to know is it possible to get compact date format and ColdFusion can recognize as a date field to parse right information,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;var d = new Date(rowdata[1]);&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; var curr_date = d.getDate();&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; var curr_month = d.getMonth() +1 ;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; var curr_year = d.getFullYear();&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:b35db747-7665-404c-901c-cf62c5d76563] --&gt;</description>
      <pubDate>Thu, 01 May 2014 19:08:30 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1463982</guid>
      <dc:date>2014-05-01T19:08:30Z</dc:date>
      <clearspace:dateToText>6 months 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>5</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Ubuntu Apache2</title>
      <link>https://forums.adobe.com/thread/1463276</link>
      <description>&lt;!-- [DocumentBodyStart:0680fbda-5091-4080-8b60-ccb410f92e09] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I plan to install ColdFuison Developer version on Ubuntu 13.10 Apache2 machine and would like to does ColdFusion support Ubuntu 13.10 and Apache2 web server.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:0680fbda-5091-4080-8b60-ccb410f92e09] --&gt;</description>
      <pubDate>Thu, 01 May 2014 02:49:29 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1463276</guid>
      <dc:date>2014-05-01T02:49:29Z</dc:date>
      <clearspace:dateToText>6 months 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Ubuntu 13.10</title>
      <link>https://forums.adobe.com/thread/1463275</link>
      <description>&lt;!-- [DocumentBodyStart:8fb29973-94f6-4d90-a8d1-08c7bad72559] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I plan to install Dreamweaver CS 6 on my Ubuntu 13.10 system and would like to know does Dreamweaver support Ubuntu 13.10 version?&lt;/p&gt;&lt;p&gt;Your information and help is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:8fb29973-94f6-4d90-a8d1-08c7bad72559] --&gt;</description>
      <pubDate>Thu, 01 May 2014 02:46:43 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1463275</guid>
      <dc:date>2014-05-01T02:46:43Z</dc:date>
      <clearspace:dateToText>6 months 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>4</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Assign cfinput checkbox value</title>
      <link>https://forums.adobe.com/thread/1436764</link>
      <description>&lt;!-- [DocumentBodyStart:106a930d-1dc6-44b7-aac7-c61fad9b1bcd] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have following code to assign value from my stored procedures.&lt;/p&gt;&lt;p&gt;The text cfinput works to get value from stored procedure, but check box does not get value.&lt;/p&gt;&lt;p&gt;The check box value return to 1, but check box does not check.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I would like to know are there any way to assign a stored procedure value to check box.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;iccsi,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt; &amp;lt;td&amp;gt;&amp;lt;cfinput type="checkbox" name="Mychk" id="Mychk" value="#MySP.MyCheckValue#"&amp;gt;&amp;lt;/td&amp;gt;&lt;/p&gt;&lt;p&gt; &amp;lt;td&amp;gt;&amp;lt;cfinput type="text" name="Mytxt" id="Mytxt" value="#MySP.MyTextValue#"&amp;gt;&amp;lt;/td&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:106a930d-1dc6-44b7-aac7-c61fad9b1bcd] --&gt;</description>
      <pubDate>Wed, 26 Mar 2014 16:43:15 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1436764</guid>
      <dc:date>2014-03-26T16:43:15Z</dc:date>
      <clearspace:dateToText>7 months 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>17</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>trigger onchange event by load server data</title>
      <link>https://forums.adobe.com/thread/1437793</link>
      <description>&lt;!-- [DocumentBodyStart:425b0edc-76bd-4ed5-85d7-7bc1da2c8fd8] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have following code to filter my second list from my list.&lt;/p&gt;&lt;p&gt;It works when user click the dropdown, since onchange event trigger.&lt;/p&gt;&lt;p&gt;I tried to load the data from stored procedure then the onchange event does not trigger, when user need update data then will see whole list without filtering.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I would like to know if it is possible to trigger onchange event when I load data from stored procedure,&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt; &amp;lt;td&amp;gt;&amp;lt;select name="Mylst" id="Mylst"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfoutput query="MySP"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;option value="#MySP.MyID#"&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfif (isDefined("form.MyID") AND form.MyID EQ MySP.MyID)&amp;gt;selected="selected"&amp;lt;/cfif&amp;gt;&amp;gt; #MySP.MyName# &amp;lt;/option&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cfoutput&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/select&amp;gt;&amp;lt;/td&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;$("#Mylst").change(function()&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&amp;nbsp;&amp;nbsp;&amp;nbsp; $.ajax({&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; type: "GET",&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; url:&amp;nbsp;&amp;nbsp; 'Mycfc.cfc?method=GetMethod&amp;amp;MyParam='+ jQuery("#MyPrelsty").val(),&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; dataType: "json",&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; cache: false,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; success: function(data)&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $('#MySublst option').remove();&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $.each(data, function(i, obj)&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $("#MySublst").append('&amp;lt;option value=' + '"' + data[i][0] + '"' +'&amp;gt;' + data[i][1] + &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;'&amp;lt;/option&amp;gt;')&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; });&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; });&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:425b0edc-76bd-4ed5-85d7-7bc1da2c8fd8] --&gt;</description>
      <pubDate>Thu, 27 Mar 2014 19:26:47 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1437793</guid>
      <dc:date>2014-03-27T19:26:47Z</dc:date>
      <clearspace:dateToText>7 months 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>update text in the table from cfc</title>
      <link>https://forums.adobe.com/thread/1437587</link>
      <description>&lt;!-- [DocumentBodyStart:4f95119d-b23f-4d56-bcf3-c32b27d9d74c] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a function in cfc file like following to call MS SQL server stored procedure.&lt;/p&gt;&lt;p&gt;The stored procedure check ID if ID exists then update table, if not then insert a new record.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt; &amp;lt;cffunction name="NewRecord" access="remote"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfargument name ="MyID" required="yes" default="1" hint="My ID"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfargument name ="MyText" required="no" default="" hint="MyText"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &lt;/p&gt;&lt;p&gt; &amp;lt;cfstoredproc datasource="mydatasource" procedure = "mySP"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#MyID#" CFSQLTYPE = "cf_sql_integer"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfprocparam value = "#MyText#" CFSQLTYPE = "cf_sql_varchar"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfstoredproc&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;/cffunction&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;The insert works if the record does not exist from my click button on cfm file, &lt;/p&gt;&lt;p&gt;I run the stored procedure works from SSMS works on update and insert.&lt;/p&gt;&lt;p&gt;I got excute query error when the record exists in the table.&lt;/p&gt;&lt;p&gt;The update works if I provide integer value for the text field.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span&gt;[Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the nvarchar value 'test' to data type int. &lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span&gt;For some reason, cfc function consider mytext must use integer instead of text even I declare cf_sql_varchar, but insert works,&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span&gt;Any suggestins or information is great appreciated,&lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span&gt;Regards,&lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span&gt;Iccsi,&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:4f95119d-b23f-4d56-bcf3-c32b27d9d74c] --&gt;</description>
      <pubDate>Thu, 27 Mar 2014 15:39:55 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1437587</guid>
      <dc:date>2014-03-27T15:39:55Z</dc:date>
      <clearspace:dateToText>7 months 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>hide cfm extension</title>
      <link>https://forums.adobe.com/thread/1414949</link>
      <description>&lt;!-- [DocumentBodyStart:be800ded-1539-4f9e-ba3c-abddae33f529] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;My users need to type whole web URL including cfm extention to get the web site like &lt;a class="jive-link-external-small" href="http://www.myserver.myhome.cfm" rel="nofollow"&gt;www.myserver.myhome.cfm&lt;/a&gt;.&lt;/p&gt;&lt;p&gt;I would like to know are there any way to let user enter the URL without cfm extention.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:be800ded-1539-4f9e-ba3c-abddae33f529] --&gt;</description>
      <pubDate>Tue, 25 Feb 2014 14:57:14 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1414949</guid>
      <dc:date>2014-02-25T14:57:14Z</dc:date>
      <clearspace:dateToText>8 months 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>icon iamge for the web site</title>
      <link>https://forums.adobe.com/thread/1415001</link>
      <description>&lt;!-- [DocumentBodyStart:f30faa15-c447-44ee-928d-a84dc35a2a6a] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I see some web site has an icon to present the web site.&lt;/p&gt;&lt;p&gt;ASP.Net has favicon to present the web site.&lt;/p&gt;&lt;p&gt;I would like to know does ColdFsuion has similar function to have my web site an icon to present.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your information and help is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:f30faa15-c447-44ee-928d-a84dc35a2a6a] --&gt;</description>
      <pubDate>Tue, 25 Feb 2014 15:00:14 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1415001</guid>
      <dc:date>2014-02-25T15:00:14Z</dc:date>
      <clearspace:dateToText>8 months 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>cfmail utf-8</title>
      <link>https://forums.adobe.com/thread/1412192</link>
      <description>&lt;!-- [DocumentBodyStart:a190edcb-2b03-4338-8291-b7c1e78c2683] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I use CFMail to send mail. Because the mail contains Spanish, I need the email support utf-8 character set.&lt;/p&gt;&lt;p&gt;I use following code to display Spanish characters, but the email shows funny characters.&lt;/p&gt;&lt;p&gt;I would like to know are there any way to display utf-8 characters for special language.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;CFMAIL FROM="#myMail.Frommail#" TO="#MyMail.ToEMail#" &lt;br/&gt;&amp;nbsp; bcc="#MyMail.BccEMail#" SUBJECT="My Subject" charset="utf-8"&lt;br/&gt;TYPE="Plain Text"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &lt;br/&gt;&amp;nbsp;&amp;nbsp; #MyEmail.EMailMessage#&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;/CFMAIL&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:a190edcb-2b03-4338-8291-b7c1e78c2683] --&gt;</description>
      <pubDate>Fri, 21 Feb 2014 14:07:58 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1412192</guid>
      <dc:date>2014-02-21T14:07:58Z</dc:date>
      <clearspace:dateToText>8 months 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>cfmail trigger by select list</title>
      <link>https://forums.adobe.com/thread/1410440</link>
      <description>&lt;!-- [DocumentBodyStart:8e0b3956-3a08-4b6b-9b3a-b6585a40d520] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I need to send an email when user change select list.&lt;/p&gt;&lt;p&gt;I can use cfmail to send out email, I would like to know is it possible to trigger the mail when user click and change the select list or I have to use when user click a button,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:8e0b3956-3a08-4b6b-9b3a-b6585a40d520] --&gt;</description>
      <pubDate>Wed, 19 Feb 2014 14:53:01 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1410440</guid>
      <dc:date>2014-02-19T14:53:01Z</dc:date>
      <clearspace:dateToText>8 months 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>3</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>&lt;cfif IsDefined("form.MySelect")</title>
      <link>https://forums.adobe.com/thread/1410662</link>
      <description>&lt;!-- [DocumentBodyStart:49dce0ce-a718-415e-b7ac-ca8eaf13819a] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I want to to pass the value users select from form.MySelect.&lt;/p&gt;&lt;p&gt;I use &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfif IsDefined("form.MySelect")&lt;/p&gt;&lt;p&gt;&amp;lt;/cfif&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;it seems that ColdFusion server does not recognize it.&lt;/p&gt;&lt;p&gt;It works if I use text control.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I would like to know are there anyway to pass select value to ColdFsuion server to use &amp;lt;CFIF IsDefined&amp;gt;&lt;/p&gt;&lt;p&gt;If not, any suggestions or use hidden controls to set the value when user select a value from drop down box.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:49dce0ce-a718-415e-b7ac-ca8eaf13819a] --&gt;</description>
      <pubDate>Wed, 19 Feb 2014 18:48:41 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1410662</guid>
      <dc:date>2014-02-19T18:48:41Z</dc:date>
      <clearspace:dateToText>8 months 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>12</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>hyperlink control</title>
      <link>https://forums.adobe.com/thread/1325384</link>
      <description>&lt;!-- [DocumentBodyStart:92174035-704e-453b-b39a-b7192aedabd3] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I would like to have a control to have hyper link based on data source.&lt;/p&gt;&lt;p&gt;I would like to know does Report Builder have any controls that I can set hyper link based on data.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:92174035-704e-453b-b39a-b7192aedabd3] --&gt;</description>
      <pubDate>Thu, 31 Oct 2013 00:18:52 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1325384</guid>
      <dc:date>2013-10-31T00:18:52Z</dc:date>
      <clearspace:dateToText>1 year 4 days ago</clearspace:dateToText>
      <clearspace:replyCount>4</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>error message from database stored procedures</title>
      <link>https://forums.adobe.com/thread/1331099</link>
      <description>&lt;!-- [DocumentBodyStart:96c1ef41-c1cd-4ed6-afb6-8d073f3493a7] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I would like to have some error message show at client side from stored procedures.&lt;/p&gt;&lt;p&gt;I use MS SQL Server and use RAISEERROR, but ColdFusion does not bring the error message just ignore the error continue to run the other part of code.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I just want to know are there any way to bring stroed procedure error message to client, or I have to trap the error at Web Server or JavaScript level.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:96c1ef41-c1cd-4ed6-afb6-8d073f3493a7] --&gt;</description>
      <pubDate>Fri, 08 Nov 2013 13:56:08 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1331099</guid>
      <dc:date>2013-11-08T13:56:08Z</dc:date>
      <clearspace:dateToText>1 year 4 days ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>cgi.script_name cgi.query_string</title>
      <link>https://forums.adobe.com/thread/1324401</link>
      <description>&lt;!-- [DocumentBodyStart:75570248-aa7e-4d72-ac56-6daa3b73f20a] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt; &amp;lt;cfform action= "#cgi.script_name#?#cgi.query_string#"&amp;nbsp; method="post"&amp;nbsp; name="MyForm" enctype="multipart/form-data"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I want to keep current action string when user upload file.&lt;/p&gt;&lt;p&gt;I have above code and add myform.myTextControlValue after "#cgi.script_name#?#cgi.query_string#"&amp;nbsp; to keep my parameter.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I tried the following to replace cgi.query_string, is it the right way to handle string like following code or any other solutions?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfset q = reReplaceNoCase(cgi.query_string, cgi.query_string, "MyForm.cfm&amp;amp;MyValue=" &amp;amp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; #form.MyValue#)&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfform action= "#cgi.script_name#?#q#"&amp;nbsp; method="post"&amp;nbsp; name="MyForm" enctype="multipart/form-data"&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:75570248-aa7e-4d72-ac56-6daa3b73f20a] --&gt;</description>
      <pubDate>Tue, 29 Oct 2013 18:14:00 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1324401</guid>
      <dc:date>2013-10-29T18:14:00Z</dc:date>
      <clearspace:dateToText>1 year 2 weeks ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>using select for jQuery auto complete performance issue</title>
      <link>https://forums.adobe.com/thread/1305509</link>
      <description>&lt;!-- [DocumentBodyStart:eaea5584-4b50-4785-9e1a-7784aec30918] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I use select controls for jQuery AutoComplete. &lt;/p&gt;&lt;p&gt;Because jQuery Auto complete does not filter server return data, my cfquery returns thousands records to auto complete which has performance issue.&lt;/p&gt;&lt;p&gt;here is my code to have my list and cfquery.&lt;/p&gt;&lt;p&gt;My query returns thousands recrods and jQuery auto complete&amp;nbsp; does not filter the records. I am looking a way to limit records return from user type on the dropdown box &lt;/p&gt;&lt;p&gt;I would like to know is it possible to have my cfquery smart enough to get only records I need for jQuery auto complete.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;select name="Mylst" id="Mylst" &amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfoutput query="MySP"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;option value="#MySP.MyID#"&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfif (isDefined("form.MyID") AND form.MyID EQ MySP.MyID)&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;gt;selected="selected"&amp;lt;/cfif&amp;gt;&amp;gt;#MySP.MyName#&amp;lt;/option&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cfoutput&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;/select&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:eaea5584-4b50-4785-9e1a-7784aec30918] --&gt;</description>
      <pubDate>Sat, 28 Sep 2013 00:12:08 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1305509</guid>
      <dc:date>2013-09-28T00:12:08Z</dc:date>
      <clearspace:dateToText>1 year 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>multi language characters</title>
      <link>https://forums.adobe.com/thread/1322281</link>
      <description>&lt;!-- [DocumentBodyStart:12040c8d-aea1-4c56-9540-48bbc462e05d] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have an applicaiton to support English, French and Spanish.&lt;/p&gt;&lt;p&gt;There are some characters with accent on the top for French and Spanish shows funny characters on the web pages.&lt;/p&gt;&lt;p&gt;I see some web site can display those characters correctly.&lt;/p&gt;&lt;p&gt;I would like to know are there any configuarion to do to display those characters correctly.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:12040c8d-aea1-4c56-9540-48bbc462e05d] --&gt;</description>
      <pubDate>Fri, 25 Oct 2013 22:04:02 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1322281</guid>
      <dc:date>2013-10-25T22:04:02Z</dc:date>
      <clearspace:dateToText>1 year 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>6</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>master detail report</title>
      <link>https://forums.adobe.com/thread/1321742</link>
      <description>&lt;!-- [DocumentBodyStart:cba55627-7667-43ef-a325-966b96b1667d] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I want to create a master details report using CF 10 Report Builder, but I do not find the option.&lt;/p&gt;&lt;p&gt;I would like to know should I insert a sub report in to detail band to generate master details report.&lt;/p&gt;&lt;p&gt;If not, can you please advise what is the procedures to build master details report using CF 10 Report Builder.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:cba55627-7667-43ef-a325-966b96b1667d] --&gt;</description>
      <pubDate>Fri, 25 Oct 2013 04:44:17 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1321742</guid>
      <dc:date>2013-10-25T04:44:17Z</dc:date>
      <clearspace:dateToText>1 year 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>cgi variable to get ip address, client machine and browser</title>
      <link>https://forums.adobe.com/thread/1323482</link>
      <description>&lt;!-- [DocumentBodyStart:613ac49e-bfcf-440c-851a-b4c4dd62add3] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I want to use CGI variable to get client information like IP Address, Machine Name and browser name and version,&lt;/p&gt;&lt;p&gt;I just get REMOTE_ADDR for IP address, but I can not get machine name using REMOTE_HOST, nor browser information,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I would like to know do I need any set at server level to get this client informaiton using CGI variable?&lt;/p&gt;&lt;p&gt;If not, are there any server variable available to get client informaiton?&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:613ac49e-bfcf-440c-851a-b4c4dd62add3] --&gt;</description>
      <pubDate>Mon, 28 Oct 2013 15:34:22 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1323482</guid>
      <dc:date>2013-10-28T15:34:22Z</dc:date>
      <clearspace:dateToText>1 year 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>3</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>sub report in column header</title>
      <link>https://forums.adobe.com/thread/1321315</link>
      <description>&lt;!-- [DocumentBodyStart:f503e03a-bb54-43f3-8120-fbe265451efc] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;h1 style="color: black;"&gt;&lt;span style="font-size: 10pt;"&gt;Infinite loop creating new page due to column header overflow. &lt;/span&gt;&lt;/h1&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="color: black;"&gt;I have a sub report on the column header which works, &lt;/p&gt;&lt;p style="color: black;"&gt;Because my sub report return different records from data source, it fails and get infinite loop error message like above when I have 9 records, it works less than 9 records.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="color: black;"&gt;I would like to know my sub report returns records some times more, are there any place for my subreport?&lt;/p&gt;&lt;p style="color: black;"&gt;Are there limit for sub report?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="color: black;"&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="color: black;"&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="color: black;"&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:f503e03a-bb54-43f3-8120-fbe265451efc] --&gt;</description>
      <pubDate>Thu, 24 Oct 2013 15:48:22 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1321315</guid>
      <dc:date>2013-10-24T15:48:22Z</dc:date>
      <clearspace:dateToText>1 year 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Invalid Arg Post</title>
      <link>https://forums.adobe.com/thread/1321005</link>
      <description>&lt;!-- [DocumentBodyStart:0792921f-26c9-418b-ab04-5a65a6f31f7e] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I got the following error message when I use Dreamweaver to view server debug.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I went to CF 10 local developer version to enabled Robust Exception Information and Enable Request Debugging Output on coldFusion admin page.&lt;/p&gt;&lt;p&gt;I use Dreamweaver to view server debug then I got &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;"The following error has occured while connection to coldFsuion Server.&lt;/p&gt;&lt;p&gt;&amp;nbsp; Invalid Arg Post."&lt;/p&gt;&lt;p&gt;Can you please advise are there configuration I need check from server side and Dreamweaver site?&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:0792921f-26c9-418b-ab04-5a65a6f31f7e] --&gt;</description>
      <pubDate>Thu, 24 Oct 2013 06:58:47 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1321005</guid>
      <dc:date>2013-10-24T06:58:47Z</dc:date>
      <clearspace:dateToText>1 year 3 weeks ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>insert sub report error message</title>
      <link>https://forums.adobe.com/thread/1320038</link>
      <description>&lt;!-- [DocumentBodyStart:4a81866b-adfe-4923-a101-e81f328db62b] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Object: TfrmWizardTemplate, frmWizardTemplate&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Exception:'String) into type (Boolean) when evaluation instruction OperEqual ($0' is not a value integer value&lt;/p&gt;&lt;p&gt;See error log for stack trace.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I got above error message while I insert a sub report to my report and I am unable to close Report Builde/ I had to use task manager to end task to close Report Builder.&lt;/p&gt;&lt;p&gt;The cancel, previouse, Next and Finish buttons are disabled on the sureport source form.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:4a81866b-adfe-4923-a101-e81f328db62b] --&gt;</description>
      <pubDate>Tue, 22 Oct 2013 20:59:32 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1320038</guid>
      <dc:date>2013-10-22T20:59:32Z</dc:date>
      <clearspace:dateToText>1 year 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>4</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>second sub report</title>
      <link>https://forums.adobe.com/thread/1320017</link>
      <description>&lt;!-- [DocumentBodyStart:ca90ff37-789a-4d07-99ee-17758e0d44e9] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a report which has one sub report and works.&lt;/p&gt;&lt;p&gt;I just move this sub report from column footer to rpeort footer and add a new sub report to column report.&lt;/p&gt;&lt;p&gt;The main report and first sub report works still the same, but second sub report added does not show on the report.&lt;/p&gt;&lt;p&gt;The usb report works fine itself.&lt;/p&gt;&lt;p&gt;I just wanted to know are there any particular configure for more than one subreport on the report.&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:ca90ff37-789a-4d07-99ee-17758e0d44e9] --&gt;</description>
      <pubDate>Tue, 22 Oct 2013 20:24:42 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1320017</guid>
      <dc:date>2013-10-22T20:24:42Z</dc:date>
      <clearspace:dateToText>1 year 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>4</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>formatdate</title>
      <link>https://forums.adobe.com/thread/1314307</link>
      <description>&lt;!-- [DocumentBodyStart:8d802016-2311-4a14-be9b-1071fd5a1838] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a cfinput date field on the form, I have value from my query like "#myquery.Mydate#", but it gives me {ts .....} format,&lt;/p&gt;&lt;p&gt;Are there an yway to set the date format using short date format?&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:8d802016-2311-4a14-be9b-1071fd5a1838] --&gt;</description>
      <pubDate>Sun, 13 Oct 2013 17:29:16 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1314307</guid>
      <dc:date>2013-10-13T17:29:16Z</dc:date>
      <clearspace:dateToText>1 year 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>6</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>SSL database server connection</title>
      <link>https://forums.adobe.com/thread/1314363</link>
      <description>&lt;!-- [DocumentBodyStart:a602d3dd-3442-48c6-b319-79fd2ccad1e8] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I need to create a DSN to connect a SSL MS SQL server using ColdFusion server for RDS server.&lt;/p&gt;&lt;p&gt;I tried to use ColdFsuion admin page to creat a DSN, but I got error message&amp;nbsp; like following:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="background-color: #e7e7e7; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif;"&gt;connection verification failed for data source&lt;/p&gt;&lt;p style="background-color: #e7e7e7; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif;"&gt;java.sql.SQLNonTransientConnectionexception:[Macromedia][SQLServer JDBC Driver]The SQL Server login requires SSL Conection.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="background-color: #e7e7e7; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif;"&gt;Any suggestions to connect SSS MS SQL server is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="background-color: #e7e7e7; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif;"&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="background-color: #e7e7e7; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif;"&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:a602d3dd-3442-48c6-b319-79fd2ccad1e8] --&gt;</description>
      <pubDate>Sun, 13 Oct 2013 17:58:34 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1314363</guid>
      <dc:date>2013-10-13T17:58:34Z</dc:date>
      <clearspace:dateToText>1 year 1 month ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>set form value from MyQuery</title>
      <link>https://forums.adobe.com/thread/1312058</link>
      <description>&lt;!-- [DocumentBodyStart:a8a020a3-c06e-420a-83a3-9ec2aeafebad] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt; &amp;lt;cfif structKeyExists(MyQuery, "MyID")&amp;gt;&lt;/p&gt;&lt;p&gt; &amp;lt;CFSET form.MyID= MyQuery.MyID&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfif&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt; &amp;lt;cfif structKeyExists(url, "MyID")&amp;gt;&lt;/p&gt;&lt;p&gt; &amp;lt;CFSET form.MyID= url.MyID&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfif&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I use above code to check if query ID exists then assign value to my form variable.&lt;/p&gt;&lt;p&gt;It seems that it does not work, but it works for url.&lt;/p&gt;&lt;p&gt;Can you please help and advise are there any way to check value in query and assign to the form if it is defined?&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:a8a020a3-c06e-420a-83a3-9ec2aeafebad] --&gt;</description>
      <pubDate>Wed, 09 Oct 2013 14:55:24 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1312058</guid>
      <dc:date>2013-10-09T14:55:24Z</dc:date>
      <clearspace:dateToText>1 year 1 month ago</clearspace:dateToText>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>2 controls overlap and control z index at run time</title>
      <link>https://forums.adobe.com/thread/1309107</link>
      <description>&lt;!-- [DocumentBodyStart:28ed1218-ee4d-40ff-9757-6c5cf97b14b8] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I would like to have one text box and one drop down box place on the same spot which one is over the other one and control focus and z index at run time. Does Dreamweave has this behavior to create?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:28ed1218-ee4d-40ff-9757-6c5cf97b14b8] --&gt;</description>
      <pubDate>Thu, 03 Oct 2013 23:39:09 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1309107</guid>
      <dc:date>2013-10-03T23:39:09Z</dc:date>
      <clearspace:dateToText>1 year 1 month ago</clearspace:dateToText>
      <clearspace:replyCount>4</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>report column footer print after report footer</title>
      <link>https://forums.adobe.com/thread/1309105</link>
      <description>&lt;!-- [DocumentBodyStart:198f94a6-dd7a-46b9-83ff-7f07cc87b47c] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a report which has column footer and report footer.&lt;/p&gt;&lt;p&gt;The column footer always print in the bottom of the page and it happens the report has half page then report footer print before column footer.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I would like to know is it possible to have column footer just after last detail line print and report footer print after column footer which is more professinal report format,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:198f94a6-dd7a-46b9-83ff-7f07cc87b47c] --&gt;</description>
      <pubDate>Thu, 03 Oct 2013 23:35:41 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1309105</guid>
      <dc:date>2013-10-03T23:35:41Z</dc:date>
      <clearspace:dateToText>1 year 1 month ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>create local temp table</title>
      <link>https://forums.adobe.com/thread/1305809</link>
      <description>&lt;!-- [DocumentBodyStart:fdfce75b-833a-4e84-8560-b0a65c0b89a2] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I need to create a temp local table and look for ColdFusion informaiton, the cffile action write only can write text file, pictures is more to create file.&lt;/p&gt;&lt;p&gt;I would like to know does ColdFusion support to create local temp tables on session start,&lt;/p&gt;&lt;p&gt;If yes, should be able to get client temp directory and access the data using temp directory without using data source from ColdFusion server?&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:fdfce75b-833a-4e84-8560-b0a65c0b89a2] --&gt;</description>
      <pubDate>Sat, 28 Sep 2013 19:02:15 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1305809</guid>
      <dc:date>2013-09-28T19:02:15Z</dc:date>
      <clearspace:dateToText>1 year 1 month ago</clearspace:dateToText>
      <clearspace:replyCount>4</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>developer version on local machine crashed</title>
      <link>https://forums.adobe.com/thread/1308395</link>
      <description>&lt;!-- [DocumentBodyStart:e824d776-b0ad-48f5-bbe0-b92de4333725] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;My devloper version on local machine crashed.&lt;/p&gt;&lt;p&gt;How should I to get it back?&lt;/p&gt;&lt;p&gt;Do I need uninstall it and download again from adobe web site or I can install one on top this one?&lt;/p&gt;&lt;p&gt;If I uninstall all the local web site and configuration like data source will be gone?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:e824d776-b0ad-48f5-bbe0-b92de4333725] --&gt;</description>
      <pubDate>Wed, 02 Oct 2013 20:57:22 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1308395</guid>
      <dc:date>2013-10-02T20:57:22Z</dc:date>
      <clearspace:dateToText>1 year 1 month ago</clearspace:dateToText>
      <clearspace:replyCount>24</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>sub report data source at run time</title>
      <link>https://forums.adobe.com/thread/1306826</link>
      <description>&lt;!-- [DocumentBodyStart:0b8b8219-adab-431c-8a3a-0e0662e8a070] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a sub report and on the main report and I want to set up sub report and main report data soruce using stored procedures.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I have following code, it only runs sub report, but not main report has sub report on it.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I would like to know any way to set sub report and main report to run a report which has sub report on it,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Your help and information is great appreciated,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Regards,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Iccsi,&amp;nbsp; &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfreport format = "PDF" template= "subReport.cfr"&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; query = "#mysubStored#"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;/cfreport&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;cfreport format = "PDF" template= "MainReport.cfr"&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; query = "#mydata#"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;/cfreport&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;/CFIF&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:0b8b8219-adab-431c-8a3a-0e0662e8a070] --&gt;</description>
      <pubDate>Mon, 30 Sep 2013 17:03:09 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1306826</guid>
      <dc:date>2013-09-30T17:03:09Z</dc:date>
      <clearspace:dateToText>1 year 1 month ago</clearspace:dateToText>
      <clearspace:replyCount>13</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
  </channel>
</rss>

