in reply to Re: Help with .hts (sybase "html" files w/inline perl)
in thread Help with .hts (sybase "html" files w/inline perl)

Howdy!

Liz wrote:

One note of warning: Sybperl was basically Perl 4 if I remember correctly. You might encounter some odd problems when converting to a "recent" Perl.

"Sybperl" is the non-DBI Sybase-Perl interface mpeppler wrote (and which rocks!). The .hts stuff is "websql", something that Sybase marketed for a while that was Perl 5 based, but it included its own copy of Perl and it was a low-numbered Perl 5, as I recall.

yours,
Michael

  • Comment on Re: Re: Help with .hts (sybase "html" files w/inline perl)

Replies are listed 'Best First'.
Re: Re: Re: Help with .hts (sybase "html" files w/inline perl)
by chrisgraber (Initiate) on Sep 16, 2003 at 17:34 UTC
    The site has about 85 .hts files. The files access a database and text files.

    I know some of my options are listed above, but I don't have experience with mod_perl etc. I am a low level Perl coder so I don't want to have to reinvent the wheel! I'd like to be able to semi-seamlessly plop the code into new pages.

    I posted a sample (right click his link) file at http://www.cjgdev.com/sample_file.hts

    Do these files use the Sybperl you talked about? I see SYB tags in them. I.e. does Sybperl = SYB?

    Help! Chris

      Howdy!

      That link was very difficult to read...however, I've dredged up more recollections from using WebSQL...

      WebSQL included Sybperl -- an old version of Sybperl at that. The code inside SYB tags is Perl code that may be using Sybperl stuff. One thing you won't see in the embedded code is setting up the database connection. WebSQL did some extra tricks to set up the connection and pass it in to the embedded code, keeping the user/password/server data in an external file, encrypted for some level of protection.

      You will need to modify your code to use something other than Sybperl for database access. DBI is strongly indicated. You may find yourself best served by setting up a template for accessing the MySQL database from the web page before trying to plop the usable parts of the Sybperl code in. You will have to rewrite pretty much all your data access parts.

      yours,
      Michael