Hello, I live in Germany and had to work in business hours. And dbforms is not my primary business. So it could happen that i will answer to mails a day later oir in the evening. Sorry for that.
Crying for help will not make this quicker! For your problem - i saw that you got an answer from Bill. Please read the chapters of special searching. Regards, Henner > -----Original Message----- > From: Bouhaik Said [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 04, 2005 11:49 AM > To: Henner Kollmann > Cc: [email protected] > Subject: Need Help in absence of Henner Kollmann > Importance: High > > Hello > > My goal is to select records using the meta character (* or %). > I have try * and % characters in the query field by is not working. > I send you my JSP, XSL in the attachment. > > Rgds, > > Said > > ----- Original Message ----- > From: "Henner Kollmann" <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > To: "'Bouhaik Said'" <[EMAIL PROTECTED] > <mailto:[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] > <mailto:[EMAIL PROTECTED]> > > >> To: "'Bouhaik Said'" <[EMAIL PROTECTED] > <mailto:[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] > <mailto:[EMAIL PROTECTED]> > > >> >> To: "'Bouhaik Said'" <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > >> >> Cc: <[email protected] > <mailto:[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. > >> > > 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
