Ok Thanks.
Rgds,
Said
----- Original Message -----
From: "Henner Kollmann" <[EMAIL PROTECTED]>
To: "'Bouhaik Said'" <[EMAIL PROTECTED]>
Cc: <jdbforms-interest@lists.sourceforge.net>
Sent: Tuesday, October 04, 2005 5:55 PM
Subject: RE: Need Help in absence of Henner Kollmann
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: jdbforms-interest@lists.sourceforge.net
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: <jdbforms-interest@lists.sourceforge.net
<mailto:jdbforms-interest@lists.sourceforge.net> >
>> >> 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 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
