Gotta run, reading this I realized that you must use the special search
constructs (beginning with any ending, any beginning, anything) instead of
embedding a wildcard in the search text. Look at the search examples where
they have the drop-down box for the comparison type.
Hope this helps, I am out for the day to my day job, back tonight.
Bill
On Tue, 04 Oct 2005 08:41:02 -0500, Bouhaik Said
<[EMAIL PROTECTED]> wrote:
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: <jdbforms-interest@lists.sourceforge.net>
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
