This tag will insert a parameter value into an sqlstmt if the value is present at runtime. If not present the tag will just return an empty String. The tag can be used to modify a parent sqlstmt at runtinme depending on what paramters are present.

In the following example the stmt in the Cp tag will be modified by the stmt in the SqlFragment tags. If the 'lastname' parameter returns a runtime value ? char will be replaced with the runtime value of the SqlFragment. If not the ? char will be replaced by an emtpy String.

<dxp:SqlStmt store="sqlMember">
   <dxp:Cp name="sql">select  from member ?</dxp:Cp>
   <dxp:SqlFragment name="lastname" type="CHAR">where lastname='?'</dxp:SqlFragment>
</dxp:SqlStmt>
  
   

  
   
@author Mark Ashworth
   
@version 0.2, 3/8/2002
  



Return to Index
Note: We have tried to test all of the code examples but they may contain errors. Any questions, comments,
suggestions, or problems should be sent to info@plands.com.