Re: [WEB400] null terminated

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

Hello Mark,

You wrote:
>At which point is the Environment variable Query_string null terminated.  I
>have to parse this string manually and the X'00' is giving me headaches.
>The current hack is just to:
>C     x'00':x'40'     Xlate      string         string.
>Not very elegant and I'm afraid this will bite me sometime in the future.

Not elegant at all and it will cause you problems.  Environment variables are
C-style null terminated strings.  That means they have a x'00' terminator.  You
cannot simply remove the terminator because there is quite likely rubbish after
the null character.

You should be using the %STR built-in function to extract the data or using C
functions that can handle null terminated strings.  %STR has been available 
since
VRM370 -- why do Toronto bother?  If you are on an earlier release or attempting
this in RPG III then you're on your own.

Since you said:

>Basically I'm sending a string of comma separated values from the HTML to
>the CGI. What I want to do is place the values into a variable to use in an
>IN clause in an SQL statement.

Then presuming that QUERY_STRING will contain something like "CUSNBR=1234,
ITEM=ABC, ORDDAT=020813" then something like the following should work:

D qryString     S                    1024
D @qryString    S                        *     INZ(%ADDR(qryString))

        ... get the QUERY_STRING env var how ever you like

C               EVAL    sqlClause = sqlClause + %STR(@qryString)

That should be enough for you to properly solve your current problem in a manner
that will not break in future.

Regards,
Simon Coulter.
--------------------------------------------------------------------
   FlyByNight Software         AS/400 Technical Specialists

   http://www.flybynight.com.au/
   Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
   Fax:   +61 3 9419 0175   mailto: shc@flybynight.com.au   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------