Subj : Re: Dynamic COntent and Database
To : All
From : HECTOR SANTOS
Date : Thu Jan 31 2019 07:10 pm
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: <
[email protected]>
References: <
[email protected]>
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 :-)
<ALEXANDRE FREIRE> wrote in message news:
[email protected]...
> 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)
