I have tried % character. it's not working.
Here a part of the code which I used:
<db:dbform tableName="{$origTableName}" maxRows="{$maxRows}"
followUp="/{$fileName}" autoUpdate="false" multipart="{$MultiPart}"
dbConnectionName="{$dbConnectionName}">
<db:header>
<db:errors />
<xsl:text disable-output-escaping="yes"> <table align="center" >
</xsl:text>
<tr class="clsHeaderDataTableRow">
<xsl:for-each select="field">
<xsl:text disable-output-escaping="yes"><td
class="clsHeaderDataTableCell"></xsl:text>
<db:message><xsl:attribute name="key"><xsl:value-of
select='@name'/></xsl:attribute></db:message>
<xsl:text disable-output-escaping="yes"></td></xsl:text>
</xsl:for-each>
</tr>
<tr class="clsHeaderDataTableRow">
<xsl:for-each select="field">
<xsl:text disable-output-escaping="yes"><td
class="clsHeaderDataTableCell"></xsl:text>
<db:sort fieldName='[EMAIL PROTECTED]'/>
<xsl:text disable-output-escaping="yes"></td></xsl:text>
</xsl:for-each>
</tr>
<tr class="clsHeaderDataTableRow">
<xsl:for-each select="field">
<td>
<xsl:text disable-output-escaping="yes">
<INPUT type="text" name="<%=
searchFieldNames_</xsl:text><xsl:value-of select="$tableName"/>
<xsl:text
disable-output-escaping="yes">.get("</xsl:text><xsl:value-of
select="@name"/>
<xsl:text disable-output-escaping="yes">")
%>" size="10" class="clsInputStyle" ></xsl:text>
</td>
</xsl:for-each>
</tr>
</db:header>
Rgds,
Said
----- Original Message -----
From: "Bill Tribley" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, October 04, 2005 3:28 PM
Subject: Re: [dbforms] Searching & filtring records
You did not provide any detail. Without a code snippet it is impossible to
say, except that wildcard searches using % work in sql (an attribute of
the language). The asterisk is a filesystem metacharacter, no one in the
ANSI sql world thinks of an asterisk as a database metacharacter for
searching.
On Tue, 04 Oct 2005 08:16:41 -0500, Bouhaik Said
<[EMAIL PROTECTED]> wrote:
functionality (Search records by meta character). the search is working
but not with the asterisk (* or %) character.
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
This message contains information that may be privileged or confidential and is
the property of the Capgemini Group. It is intended only for the person to whom
it is addressed. If you are not the intended recipient, you are not authorized
to read, print, retain, copy, disseminate, distribute, or use this message or
any part thereof. If you receive this message in error, please notify the
sender immediately and delete all copies of this message.
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
