IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  "&" symbol in xql-query

    Posted Fri July 20, 2001 12:46 PM

    I’ve got a cgi-program which ist connected to my Tamino-Database as a HTTP-Client. Now I want to send a query like:

    LOB[LOBName=“Business & Consumers”]

    in the cgi-Program.

    If I send this query in the Tamino Interactive Interface i’ve got no problems. But in the cgi-program the answer of tamino is:
    xql:queryLOB[LOBName="Business </xql:query>

    Missing end quotation character

    How can I use a “&” in a query in Tamino?


    #API-Management
    #Tamino
    #webMethods


  • 2.  RE: "&" symbol in xql-query

    Posted Wed July 25, 2001 02:49 PM

    You have to escape the “&”

    The reason is that ‘&’ is a parameter separator in the ? part of URLs or in the POST body.

    So you would have to write %xx where xx is the hex value of the ‘&’ character codepoint
    .
    In general

    In Jscript you can call the routine escape to escape parameter values like queries.

    You can call it form Visual Script also.

    Like this
    var escapedQuery = escape(‘LOB[LOBName=“Business & Consumers”]’);

    I don’t know what language you are using in your CGI program - If it is Perl then
    $query=~s/([^a-zA-Z0-9_.-])/uc sprintf(“%%%02x”,ord($1))/eg;
    will do the right thing.(believe it or not :slight_smile: )
    CGI.PM has a support routine somewhere.

    In java there is a routine that does the same thing and so do most cgi function support libraries I’ve seen.

    However this algorthim won’t work on UTF-8
    with characters greater that “7F” - at least not with the current version of Tamino.

    If you use the Tamino DOM APIs to talk to Tamino this work is all done for you.

    regards


    #API-Management
    #Tamino
    #webMethods