× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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  / \
--------------------------------------------------------------------



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.