SqlStatement parameters component

fabreece

Hi,

I'm looking for a way to give a parameters to a sqlstatement. So for example, in this:

<Data>
  <External>
    <Parameters>
      <Datum ID="pool" Name="Pool" Type="String">some_pool</Datum>
      <Datum ID="sql" Name="SQLStatement" Type="String">
          select * from flash
      </Datum>
    </Parameters>
    <Object Scope="local">com.interwoven.livesite.external.runtime.SQL</Object>
    <Method>executeSqlQuery</Method>
  </External>
</Data>

I would like to give a parameter to select a specific flash:
"select * from flash where id = 36" without hardcoding the 36 in the sql statement, it should come as a url parameter or so.

I hope it's clear,

Fabrice

Stokes

Fabrice,

That class supports defining the whole SQLStatement, as you've done, but it also supports defining each piece separately, as in:

<Data>
  <External>
    <Parameters>
      <Datum ID="pool" Name="Pool" Type="String">some_pool</Datum>
      <Datum ID="sqlselect" Name="Select" Type="String">*</Datum>
      <Datum ID="sqlfrom" Name="From" Type="String">flash</Datum>
      <Datum ID="sqlwhere" Name="Where" Type="String">id=36</Datum>
    </Parameters>
    <Object Scope="local">com.interwoven.livesite.external.runtime.SQL</Object>
    <Method>executeSqlQuery</Method>
  </External>
</Data>

Then on your URL you can pass the Where parameter, e.g. http://myserver/mypath/mypage.page?Where=id%3d36.

Stokes.