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

WebSQL is a Sybase product based on perl and Sybperl 2.x (really, the Sybase::CTlib module). It's a product first released in early 1996, so the version of perl that it uses is very old (5.001m IIRC) and a similarly ancient version of Sybase::CTlib. I seem to remember someone mentioning an Apache::WebSql module that worked with modperl and that let you use .hts files without modifications, although last time I checked a couldn't find it on CPAN.

It should be feasible to adapt one of the current HTML templating systems to handle the <SYB> tags, although getting that to work right might really be more work than just porting the whole thing to PHP, as that appears to be your real target platform. In any case you'll have to adapt the Sybase calls to DBI calls so that it will work with MySQL.

Michael

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

Replies are listed 'Best First'.
Re: Re: Help with .hts (sybase "html" files w/inline perl) by chrisgraber (Initiate) on Sep 16, 2003 at 20:49 UTC
Thanks for the input. Sounds like getting the old perl code to work within a new system would be rather difficult. What about this scenario? The people I might do the work for just want to get rid of the ancient machine the .hts files run on. But now they don't want to convert the code to PHP (too much work). They don't know anything about what keeps the files working (Sybase related things) though. Might it be possible to move the code to a Solaris box and have it still function? What pieces are needed in order for the .hts code to work? Do you think I should I check on CPAN for that Apache module? Then there's also the other issue of using a mySQL db instead. To me, that doesn't seem to be possible, since all the inline perl code in the hts pages uses special ways of accessing the database. Am I crazy? Chris	[reply]
Re: Re: Re: Help with .hts (sybase "html" files w/inline perl) by mpeppler (Vicar) on Sep 16, 2003 at 23:53 UTC
The easy solution would be to find a Solaris version of Web.SQL and use that. However, that may be difficult to find. The Apache::WebSQL module is listed on CPAN in the module list, but it's not found on search.cpan.org. You may need to contact the author to see if there is something that you could use. If the client still has the Sybase server on their net then I'd skip porting to MySQL as simply unnecessary at this point. Michael	[reply]