the Coyote web server http://coyote.modsoft.com/ lets you write PICK/BASIC with HTML presentation. quite fast and fairly easy to implement. there are 2 ways to write an htm app. One way is to use the developer referred to as: PLZ the other is to write pick/basic code right in your htm item like this:
001 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> 002 <HTML> 003 <HEAD> 004 <TITLE>|PAGE.TITLE|</TITLE> 005 </HEAD> 006 |RAW(BODY.TEXT)| 007 |RAW(VCAT.NAME)| 008 |RAW(DISPLAY.TEXT)| 009 |RAW(VCAT.ADDR)| 010 |RAW(EMAILIT)| |RAW(HOMEIT)| 011 |RAW(TIMEDATE)| 012 |RAW(PAGE.LINKS)| 013 |RAW(DISP.CNTR)| 014 <PRE> 015 PicLan-IP/BASIC | | 016 * 017 * Virtual Catalog 018 * 019 ABORT=0; * set an abort flag for redirect 020 CALL CHECK.VCAT(ABORT) 021 IF ABORT THEN 022 R.ERR = '302 MOVED TEMPORARILY' 023 PL_ADD_HDR 'Location: index.htm' 024 RETURN 025 END 026 PL_GET_HDR RIP FROM \X-FORWARDED-FOR\ ELSE RIP = ST$RIP 027 DISP.CNTR='' 028 IF RIP # '' THEN 029 CALL UPDATE.CNTR(RIP,'WM_CTLG.HTM',DISP.CNTR) 030 END 031 PL_GETVAR ACTION FROM "BUTTON" ELSE ACTION='' 032 CONVERT "_" TO " " IN ACTION 033 PL_GETVAR CMD FROM "CMD" ELSE CMD='' 034 PL_GETVAR SEARCHWORDS FROM "SEARCHWORDS" ELSE SEARCHWORDS='' 035 IF ACTION = "Cart Review" THEN 036 CONVERT " " TO "_" IN ACTION 037 R.ERR = '302 MOVED TEMPORARILY' 038 XXX= 'Location: WM_CART.HTM?BUTTON=':ACTION 039 PL_ADD_HDR XXX 040 RETURN 041 END 042 PAGE.REC='' 043 CALL GEN.CTLG.SUB(PAGE.REC) 044 PAGE.TITLE = \Index of Catalog Selections\ 045 VCAT.NAME = PAGE.REC<3> ; * virtual catalog name 046 VCAT.ADDR = PAGE.REC<4> ; * virtual catalog address 047 BODY.TEXT = PAGE.REC<5> ; * background color & image 048 PAGE.LINKS = PAGE.REC<6> ; * page links 049 EMAILIT = PAGE.REC<7> ; * email image / link 050 HOMEIT = PAGE.REC<8> ; * home image / link 051 TIMEDATE = PAGE.REC<9> ; * time date stamp 052 DISPLAY.TEXT = PAGE.REC<10> ; * middle stuff 053 * 054 </PRE> 055 </BODY> 056 </HTML> notice you have PICK/BASIC, htm, called subroutines all within the htm item. the Coyote web server will extract, compile, and output on the fly - all within 1 - 3 seconds. Steve Trimble [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Richard Taylor Sent: Friday, November 05, 2004 10:50 AM To: [EMAIL PROTECTED] Subject: RE: [U2] UniVerse to Linux mySQL Our company does some work with U2 interfaced to a website and we are looking at doing more. You might want to check-out the MV/Internet product. This basically allows you to have a website that can talk directly to a Universe database. You write your site scripts in UniBasic and do cgi calls to interact with them (very rough description). We are just starting with this tool, but from what I have seen so far this is definitely the way to go if you want to put U2 data and functions out to a website. Another method would be to interface your MySql tables to Universe using ODBC or code written using the UniObjects api. Your call, it depends on what you have setup for security, existing web code, and requirements. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. "The more they complicate the plumbing the easier it is to stop up the drain" - Montgomery Scott NCC-1701 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DAREN LORD Sent: Friday, November 05, 2004 11:09 AM To: [EMAIL PROTECTED] Subject: [U2] UniVerse to Linux mySQL I am a bit of novice when it comes to the UniVerse database but I am trying to dive into it and learn as much as I can. I am also new to the mailing list, so my apologizes if I have gone about this the wrong way. My problem is this: I am running an AIX 4.3.3 with UniVerse database 10.1 installed. I am hosting my companies website from Linux running the osCommerce shopping cart that backends all the information in a mySQL database. Instead of having to type in all 250,000 items into the mySQL database, I want to real time the lookups with our own database. Is there a way for mySQL to look up the tables in UniVerse, or is there a better way? Thanks for the help Daren Lord [EMAIL PROTECTED] ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/