<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: xtk session write temp table in Adobe Campaign Standard Discussions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/xtk-session-write-temp-table/m-p/368287#M2242</link>
    <description>&lt;P&gt;&lt;LI-USER uid="12668708"&gt;&lt;/LI-USER&gt;&amp;nbsp; is this for ACS for ACC?&lt;/P&gt;&lt;P&gt;&lt;LI-USER uid="10908904"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;LI-USER uid="7623360"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am looking for help on ACS&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Sat, 27 Jun 2020 00:52:51 GMT</pubDate>
    <dc:creator>navink386520</dc:creator>
    <dc:date>2020-06-27T00:52:51Z</dc:date>
    <item>
      <title>xtk session write temp table</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/xtk-session-write-temp-table/m-p/250674#M495</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Update not working when adding data to temp table and Js is not throwing any error but it is updating any tow. Any suggestions&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;var schemaName = vars.targetSchema.substring(vars.targetSchema.indexOf(":") + 1);&lt;/P&gt;&lt;P&gt;logInfo("Schem name = " +schemaName); &lt;/P&gt;&lt;P&gt;var formatString = function(str) {&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; blah blah blah..........................&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; return str;&lt;BR /&gt;}&lt;/P&gt;&lt;P&gt;var query = xtk.queryDef.create(&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;queryDef schema={vars.targetSchema} operation="select"&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;select&amp;gt;&lt;BR /&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;node expr="@Label"/&amp;gt;&lt;BR /&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;node expr="@FullName"/&amp;gt;&lt;BR /&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;node expr="@lineNum"/&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/select&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/queryDef&amp;gt;);&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &lt;BR /&gt;var resultSet = query.ExecuteQuery();&lt;BR /&gt;for each (var row in resultSet.enrich5)&lt;BR /&gt;{&lt;BR /&gt;//instance.vars.Label=formatString(&lt;A href="mailto:row.@Label"&gt;row.@Label&lt;/A&gt;);&lt;BR /&gt;//logInfo(formatString(&lt;A href="mailto:resultSet.enrich5.@Label"&gt;resultSet.enrich5.@Label&lt;/A&gt;));&lt;BR /&gt;xtk.session.Write(&amp;lt;query _operation="update" _key="@lineNum" Label= {formatString(&lt;A href="mailto:row.@Label"&gt;row.@Label&lt;/A&gt;)}&amp;nbsp; xtkschema="temp:enrich5"/&amp;gt;);&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;} &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 26 Mar 2018 17:54:54 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/xtk-session-write-temp-table/m-p/250674#M495</guid>
      <dc:creator>srikanthr646926</dc:creator>
      <dc:date>2018-03-26T17:54:54Z</dc:date>
    </item>
    <item>
      <title>Re: xtk session write temp table</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/xtk-session-write-temp-table/m-p/250675#M496</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;typo it is not updating any row,&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 26 Mar 2018 18:22:38 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/xtk-session-write-temp-table/m-p/250675#M496</guid>
      <dc:creator>srikanthr646926</dc:creator>
      <dc:date>2018-03-26T18:22:38Z</dc:date>
    </item>
    <item>
      <title>Re: xtk session write temp table</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/xtk-session-write-temp-table/m-p/250676#M497</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Here is working code that I have; maybe this will help:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; xtk.session.Write(&amp;amp;lt;query xtkschema="temp:query" _key="@id" id={id} email={email} status={status} status_description={status_description} date={date} /&amp;amp;gt;)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Let me know if that works.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Dan&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 26 Mar 2018 23:00:43 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/xtk-session-write-temp-table/m-p/250676#M497</guid>
      <dc:creator>daniell35335226</dc:creator>
      <dc:date>2018-03-26T23:00:43Z</dc:date>
    </item>
    <item>
      <title>Re: xtk session write temp table</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/xtk-session-write-temp-table/m-p/250677#M498</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;It's not working. Can you please let me why there is no reference of querydef variable or operation=update in the above code.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 27 Mar 2018 02:44:59 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/xtk-session-write-temp-table/m-p/250677#M498</guid>
      <dc:creator>srikanthr646926</dc:creator>
      <dc:date>2018-03-27T02:44:59Z</dc:date>
    </item>
    <item>
      <title>Re: xtk session write temp table</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/xtk-session-write-temp-table/m-p/250678#M499</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Srikanth,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Instead of using the xtk.Session.Write, you can use the below statement to update the TempSchema :&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;sqlExec("update "+vars.tableName +" set abc='0' where bcd="+123);&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Let me know if this works.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Kapil&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 27 Mar 2018 07:26:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/xtk-session-write-temp-table/m-p/250678#M499</guid>
      <dc:creator>Kapil_Sharma_</dc:creator>
      <dc:date>2018-03-27T07:26:00Z</dc:date>
    </item>
    <item>
      <title>Re: xtk session write temp table</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/xtk-session-write-temp-table/m-p/368287#M2242</link>
      <description>&lt;P&gt;&lt;LI-USER uid="12668708"&gt;&lt;/LI-USER&gt;&amp;nbsp; is this for ACS for ACC?&lt;/P&gt;&lt;P&gt;&lt;LI-USER uid="10908904"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;LI-USER uid="7623360"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am looking for help on ACS&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 27 Jun 2020 00:52:51 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/xtk-session-write-temp-table/m-p/368287#M2242</guid>
      <dc:creator>navink386520</dc:creator>
      <dc:date>2020-06-27T00:52:51Z</dc:date>
    </item>
  </channel>
</rss>

