|
Hello
My goal is to search records using the meta character (* or %). I have try *
and % characters in the query field by is not working.
My XSL code is: <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: "Henner Kollmann" <[EMAIL PROTECTED]> To: "'Bouhaik Said'" <[EMAIL PROTECTED]> Sent: Monday, October 03, 2005 7:28 PM Subject: RE: [dbforms] Help > Oh, i only saw your screendump. There you inserted a * into the query > field. > Just exchanged this by an * > > Henner > >> -----Original Message----- >> From: Bouhaik Said [mailto:[EMAIL PROTECTED] >> Sent: Monday, October 03, 2005 6:39 PM >> To: Henner Kollmann >> Subject: Re: [dbforms] Help >> Importance: High >> >> >> ok for the % character but I dont know how to make it in >> dbforms? I mean should I declare a new request like: >> <db: dbform table=..... >> >> Rgds, >> >> Said >> >> ----- Original Message ----- >> From: "Henner Kollmann" <[EMAIL PROTECTED]> >> To: "'Bouhaik Said'" <[EMAIL PROTECTED]> >> Sent: Monday, October 03, 2005 6:18 PM >> Subject: RE: [dbforms] Help >> >> >> >* is not a meta character in sql! Use % instead! >> > >> > Regards >> > Henner >> > >> >> -----Original Message----- >> >> From: Bouhaik Said [mailto:[EMAIL PROTECTED] >> >> Sent: Monday, October 03, 2005 6:10 PM >> >> To: Henner Kollmann >> >> Subject: Re: [dbforms] Help >> >> >> >> >> >> Thanks to reply to my email. >> >> Before sending my email I have changed the XSL >> >> "C:\dbforms_2.5\xsl-stylesheets\generate_list.xls" like this: >> >> >> >> <xsl:for-each select="field"> >> >> <td> >> >> <xsl:text disable-output-escaping="yes"> >> >> <INPUT type="text" name="<%= >> >> searchFieldNames_"$tableName".get("@name") %>" size="10" >> >> class="clsInputStyle" /> >> >> </td> >> >> </xsl:for-each> >> >> >> >> ===> is not working (servlet error....) >> >> >> >> >> >> and after I have found an example: >> >> "C:\dbforms_2.5\xsl-stylesheets\viewTable.xsl", so I have >> >> adapt my changes like this: >> >> >> >> <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> >> >> >> >> >> >> Now is working. >> >> The generated JSP page is: >> >> >> >> <td><INPUT type="text" name= >> >> "<%= searchFieldNames_DFA2_IF_DR_LIST_VAL.get("ENTITY_CODE") %>" >> >> size="10" class="clsInputStyle" ></td> >> >> >> >> >> >> Now my problem is to search records with "meta character" >> >> like "*". See the attachment file. >> >> >> >> Thanks a lot. >> >> >> >> Rgds, >> >> >> >> Said Bouhaik >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> ----- Original Message ----- >> >> From: "Henner Kollmann" <[EMAIL PROTECTED]> >> >> To: "'Bouhaik Said'" <[EMAIL PROTECTED]> >> >> Cc: <[email protected]> >> >> Sent: Monday, October 03, 2005 5:40 PM >> >> Subject: RE: [dbforms] Help >> >> >> >> >> >> > Hello, >> >> > >> >> >> I introduce myself. I'm Mr. bouhaik Said, and I work in >> >> >> Capgemini company France. Initially I execuse if there are >> >> >> errors in my English. >> >> > No problem - i will have errors in my English too. >> >> > >> >> > >> >> > What error do you get? >> >> > >> >> >> the name of my table is: "DFA2_IF_DR_LIST_VAL" It seems to >> >> >> me that the fact of having "_" character in the name of my >> >> >> table that causes problems. What you think about this? Can >> >> >> you help me? >> >> > Yes, that could be because dbforms use the _ to maskarde >> >> some special >> >> > values. Could you build a view in your database without _? >> >> > >> >> > Regards >> >> > Henner >> >> >> >> >> >> 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 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. >>
|
