Date: Mon, 07 Mar 2005 12:22:22 -0400   
   From: HECTOR SANTOS   
   To: ALEXANDRE FREIRE   
   Subject: Re: Dynamic COntent and Database   
   Newsgroups: win.server.wish.list   
   Message-ID: <1110216396.33.1110145225@winserver.com>   
   References:  <1110145225.33.0@winserver.com>   
   X-WcMsg-Attr: Rcvd   
   X-Mailer: Wildcat! Interactive Net Server v7.0.454.5   
   Lines: 136   
      
   Dynamic Content?   Like Microsoft IIS's ASP?   
      
   That is what WCT (Wildcat Templates) is all about.   
      
   WCT is to Wildcat! Web Server what ASP is to Microsoft IIS Web Server.   
      
   Very powerful stuff that helps you integrate the Wildcat! Macro and wcBASIC   
   programmability.   
      
   Your HTTP\TEMPLATE folder contains Wildcat HTML template files used for   
   creating dynamic context for all the clients in Wildcat!,  mail, file, chat,   
   personal properties, etc.   
      
   Outside the template folder, simply rename any HTM extension page to WCT,   
   like:   
      
           default.htm --->  default.wct   
      
   and you have dynamic content.   
      
   Of course, nothing is done until you actually add some WCT programmable   
   stuff inside of it.   
      
   See the WCT reference stuff at the Santronics Online Developer's Corner.   
      
   Here is an example for what you are looking for:   
      
   Note I am using the # character instead of the @ character so that they   
   don't get processed in this message and I will be able to illustrate the   
   logic:   
      
   Using WCT Macros:   
      
       #if DATE = "03/05/2005"#   
           #include articles/article-2005-03-05.htm#   
       #elseif DATE = "03/06/2005"#   
           #include articles/article-2005-03-06.htm#   
       #endif#   
      
   Put this where you want a "dynamic insert" of your dynamic content.   
      
   This allows you to use the IF command with the DATE macro to check for   
   specific dated files.   
      
   The date format mm/dd/yyyy above happens to be the default format on my   
   Windows machine (Regional Settings in Windows Control Panel).   
      
   If I changed the Windows default date format to yyyy-mm-dd, then the above   
   WCT code can be changed one single line:   
      
       #existinclude "articles\article-"+DATE+".htm"#   
      
   The ExistInclude macro means   
      
       "If the file exist, include in the display, otherwise continue with no   
   warning  message"   
      
   if you used the INCLUDE macro, then you will see a "warning" in the display   
   saying the file does not exist, if not found.   
      
   I can see now that we should improve the DATE macro so that a WCT programmer   
   can specify which part of the date or time he wants.   
      
   For example, if we had:   
      
       DATE.YEAR   
       DATE.MONTH   
       DATE.DAY   
       TIME.HOUR   
       TIME.MINUTE   
       TIME.SECOND   
      
   Then you have more flexibility to do various date and/or time formatted file   
   names.   
      
   We currently don't have the above so I will consider it for an update.   
      
   But if you wanted to have the full power and flexibility than you will use   
   WCX progamming which is what most people do to add custom dynamic content   
   specific to their likens   
      
   For example:   
      
           #RunWCX html-MyArticles#   
      
   Put this where you want a "dynamic insert" of your dynamic content.  This   
   will run a server-side program called html-MyArticles.wcx   
      
   Since its a WCX you have the full programming power of the wcBASIC language   
   and you can have the WCX spit out anything you like.   
      
   For SQL related stuff, WCODBC is used using the standard SQL ODBC interface.   
   There is an full working "Shopping cart" example demo of this in the   
   Developer's corner   
      
   Finally, the Wildcat! User Database is internal to Wildcat! and it is   
   accessable via WCT Macros and WCX programming..  It is not 3rd party based   
   for good reason:   
      
   We can't depend on anyone but ourselves:   
      
       - For controlling the market place (you don't need SQL),   
       - For controlling the future of the product,   
       - For controlling the security and the integrity of the system, and   
       - For speed and scalability reasons.   
      
   Hope this helps :-)   
      
      
      
      
    wrote in message news:1110145225.33.0@winserver.com...   
   > Hello all,   
   >   
   > I would like to know if Santronics plans some kind of dynamic content to   
   be   
   > used with WINS.. something like posting article with possibility to send   
   > article contents to user's e-mail and also a printed version of the   
   article.   
   > Features like scheduling the article to be published on specific date /   
   times.   
   > I think It would not be so hard for Santronics to implement this kind of   
   > feature to WINS.  it would be nice to have this kind of feature   
   implemented on   
   > the public default web page of WINS Server.   
   >   
   > Another question : How can I use WINS to work with Mysql or SQL Server   
   > database ? Is there any possibility to record, for example, the user   
   database   
   > on a relational database system ?   
   >   
   > Thanks very much.   
   > Best Regards   
   >   
   > Alexandre Freire   
   --- Platinum Xpress/Win/WINServer v3.1   
    * Origin: Prison Board BBS Mesquite Tx  //telnet.RDFIG.NET www. (1:124/5013)