Datawindow - linking with retrival arguments

[Pål Magnus Nybų]

This problem is with datawindow and linking with retrival arguments.

I want to be able to search for a keyword among all the text in a table.
Example: user writes keyword "CAR" the user will after pressing "CAR" see
item "CAR" and all items containing the word "car", that means that items as
"CARRIER" "CARS" will also be shown.

I generated this link:
webpage2.html?retrival_arg1=16&retrival_arg2=%CAR%

I tried to type in 18 and %CAR%, and that worked very well, but when I try
the same in the web-browser, I don't get any items.

Definitions:
Retrival arg_1 is set to number
Retrival arg_2 is set to string

The select statement in powerbuilder:
...
where table.column like :arg_2

If i try to retrive in powerbuilder i type in, CAR% and it gives all items
beginning with the word car.. Why doesn't it work in html? Do I have to
define the % in another way in html?

Hope someone can help me!

Reply to this, or email me
at
paal....@limstrand.no

[Bruce Armstrong [TeamSybase]]

Most likely. % means something to a URL (it is usually the start of a special
character). Why not just pass 'CAR' and then tack on the '%' in your
PowerScript or Datawindow SQL?

On Mon, 20 Nov 2000 09:23:42 +0100,
in powersoft.public.powerbuilder.web-pb

Pål Magnus Nybø <paal....@limstrand.no> wrote:
>This problem is with datawindow and linking with retrival arguments.
>
> I want to be able to search for a keyword among all the text in a table.
>Example: user writes keyword "CAR" the user will after pressing "CAR" see
>item "CAR" and all items containing the word "car", that means that items as
>"CARRIER" "CARS" will also be shown.
>
>I generated this link:
>webpage2.html?retrival_arg1=16&retrival_arg2=%CAR%
>
>I tried to type in 18 and %CAR%, and that worked very well, but when I try
>the same in the web-browser, I don't get any items.
>
>Definitions:
>Retrival arg_1 is set to number
>Retrival arg_2 is set to string
>
>The select statement in powerbuilder:

>....

>where table.column like :arg_2
>
>If i try to retrive in powerbuilder i type in, CAR% and it gives all items
>beginning with the word car.. Why doesn't it work in html? Do I have to
>define the % in another way in html?
>
>Hope someone can help me!
>
>Reply to this, or email me
>at
>paal....@limstrand.no
>
>
>

Bruce Armstrong [TeamSybase]
mailto:Bruce.A...@teamsybase.com

Preach the gospel at all times. If necessary, use words. [Francis of Assisi]
http://www.kidbrothers.org | http://www.fccwc.org
http://www.harvest.org/knowgod/index.htm | http://www.needhim.org
http://www.jesusfilm.org/view/realvideo/rv/languages/english.ram

-----------== Posted via the PFCGuide Web Newsreader ==----------
http://www.pfcguide.com/_newsgroups/group_list.asp

[Pål Magnus Nybų]

Got it to work...
Thanks!

Bruce Armstrong [TeamSybase] <NOCANSPAM_br...@teamsybase.com>
wrote in message news:ZD7sMtw...@forums.sybase.com...

> Most likely. % means something to a URL (it is usually the start of a
special
> character). Why not just pass 'CAR' and then tack on the '%' in your
> PowerScript or Datawindow SQL?
>
> On Mon, 20 Nov 2000 09:23:42 +0100,
> in powersoft.public.powerbuilder.web-pb