<?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>Fri, 19 Apr 2013 07:48:38 GMT</pubDate>
    <generator>Jive Engage 7.0.0.1  (http://jivesoftware.com/products/)</generator>
    <dc:date>2013-04-19T07:48:38Z</dc:date>
    <dc:language>en</dc:language>
    <item>
      <title>ColdFusion ORM</title>
      <link>https://forums.adobe.com/thread/1195508</link>
      <description>&lt;!-- [DocumentBodyStart:28b11fdb-41f6-4725-909b-2cbf03c170fc] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have query which should filter the where clause condition depends on the URL parameter to the page?&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;With CFQuery:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfquery name="GetUser" datasource="Sample"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Select *from Users &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; where &amp;lt;cfif url.type EQ 1&amp;gt;userid=123&amp;lt;cfelse&amp;gt;userid=456&amp;lt;/cfif&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfquery&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;the same query i am tryinng to write with ORMExecuteQuery, i am failing to write it.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Please help me on this.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks in advance &lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:28b11fdb-41f6-4725-909b-2cbf03c170fc] --&gt;&lt;img src='/beacon?t=1415918996246' /&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">orm</category>
      <pubDate>Fri, 19 Apr 2013 07:48:38 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1195508</guid>
      <dc:date>2013-04-19T07:48:38Z</dc:date>
      <clearspace:dateToText>1 year 7 months ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>excludeheader attribute of cfspreadsheet is not working?</title>
      <link>https://forums.adobe.com/thread/882563</link>
      <description>&lt;!-- [DocumentBodyStart:cef6b093-2ed2-4416-98a3-8963867d8076] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi All,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I am new to CF. Just i started working with CFSpreadsheet.&lt;/p&gt;&lt;p&gt;I have one xlsheet which conatins the row header and i am reading xlsheet with query.&lt;/p&gt;&lt;p&gt;what i want is i dont want to read 1st row(Header row).&lt;/p&gt;&lt;p&gt;I tried with all options but i am not getting the things.&lt;/p&gt;&lt;p&gt;Please help me.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;even though i update to my CF to&amp;nbsp; 9.0.1.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Please find the follwing the code snippet.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfspreadsheet action="read"&amp;nbsp; src="#GetTempDirectory()#/msepdata_test1.xls"&amp;nbsp; excludeHeaderRow = "false"&amp;nbsp; sheet="1" query="queryData" /&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;Regards&lt;/p&gt;&lt;p&gt;Sateesh&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:cef6b093-2ed2-4416-98a3-8963867d8076] --&gt;</description>
      <pubDate>Wed, 27 Jul 2011 09:04:21 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/882563</guid>
      <dc:date>2011-07-27T09:04:21Z</dc:date>
      <clearspace:dateToText>1 year 9 months ago</clearspace:dateToText>
      <clearspace:replyCount>3</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
  </channel>
</rss>

