RE: Witango-Talk: metatags within DBMS

Steve Smith Fri, 06 Jun 2003 05:19:07 -0700

There was a solution written by Promptu (who were a San Jose based Tango development shop) for Epic Records that looked after the web sites of roughly 150 Epic artists (including the comeback kid Ozzy). There were about 5 tafs that ran the whole thing and it was originally developed in Tango 2.x (.qry files). I took it over while I was with Pervasive's Professional Services to upgrade the solution to Tango 2000. Using Oracle as the backend database, much of the Results HTML was stored in databases and retrieved using Direct DBMS calls.

You might have to play around with your ENCODING attributes but it will work.

Hope this helps,

Steve Smith

Oakbridge Information Solutions
Office: (519) 624-4388
GTA:    (416) 606-3885
Fax:    (519) 624-3353
Cell:   (416) 606-3885
Email: [EMAIL PROTECTED]
Web:    http://www.oakbridge.ca

-----Original Message-----
From: Atrix Wolfe [mailto:[EMAIL PROTECTED]
Sent: June 5, 2003 2:28 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: metatags within DBMS

cool (:

which database engine do you use?
----- Original Message -----

From: Wolf, Gene

To: '[EMAIL PROTECTED]'

Sent: Thursday, June 05, 2003 11:21 AM

Subject: RE: Witango-Talk: metatags within DBMS

This should not be a problem. I've generated SQL outside of a DBMS, and the following code is used inside of a DBMS action. Both work.

<@Assign User$Makeand 0>
SELECT
Count(*)
FROM LABORHIST L1
WHERE (
<@IF EXPR="(LEN('<@ARG WORKDATE>'))">
L1.WORKDATE>='<@ARG WORKDATE>' AND L1.WORKDATE<='<@ARG WORKDATE_1>'
<@Assign User$Makeand 1>
</@IF>
<@IF EXPR="(LEN('<@ARG Job>'))">
<@IF EXPR="(<@Var User$Makeand>)">
  AND
</@IF>
L1.JOB LIKE '<@ARG JOB>%'
<@Assign User$Makeand 1>
</@IF>
<@IF EXPR="(LEN('<@ARG Job_1>'))">
<@IF EXPR="(<@Var User$Makeand>)">
  AND
</@IF>
L1.JOB = '<@ARG JOB_1>'
<@Assign User$Makeand 1>
</@IF>
<@IF EXPR="(LEN('<@ARG EmployeeFullName>'))">
<@IF EXPR="(<@Var User$Makeand>)">
  AND
</@IF>
L1."EMPLOYEE FULL NAME" LIKE '<@ARG EMPLOYEEFULLNAME>%'
<@Assign User$Makeand 1>
</@IF>
<@IF EXPR="(LEN('<@ARG PE_DATE>'))">
<@IF EXPR="(<@Var User$Makeand>)">
  AND
</@IF>
L1.PE_DATE>=<@ARG PE_DATE>
<@Assign User$Makeand 1>
</@IF>
<@IF EXPR="(LEN('<@ARG PE_DATE_1>'))">
<@IF EXPR="(<@Var User$Makeand>)">
  AND
</@IF>
L1.PE_DATE<=<@ARG PE_DATE_1>
<@Assign User$Makeand 1>
</@IF>
<@IF EXPR="(LEN('<@ARG PARTNO_>'))">
<@IF EXPR="(<@Var User$Makeand>)">
  AND
</@IF>
L1."PART NO_" LIKE '<@ARG PARTNO_>%'
<@Assign User$Makeand 1>
</@IF>
<@IF EXPR="(LEN('<@ARG PARTNO__1>'))">
<@IF EXPR="(<@Var User$Makeand>)">
  AND
</@IF>
L1."PART NO_"='<@ARG PARTNO__1>'
<@Assign User$Makeand 1>
</@IF>
<@IF EXPR="(LEN('<@ARG WO_NO>'))">
<@IF EXPR="(<@Var User$Makeand>)">
  AND
</@IF>
L1.WO_NO LIKE '<@ARG WO_NO>%'
<@Assign User$Makeand 1>
</@IF>
<@IF EXPR="(LEN('<@ARG WO_NO_1>'))">
<@IF EXPR="(<@Var User$Makeand>)">
  AND
</@IF>
L1.WO_NO='<@ARG WO_NO_1>'
<@Assign User$Makeand 1>
</@IF>
<@IF EXPR="(LEN('<@ARG WO_PART>'))">
<@IF EXPR="(<@Var User$Makeand>)">
  AND
</@IF>
L1.WO_PART='<@ARG WO_PART>'
<@Assign User$Makeand 1>
</@IF>
<@IF EXPR="(LEN('<@ARG Ccen>'))">
<@IF EXPR="(<@Var User$Makeand>)">
  AND
</@IF>
L1.CCEN>=<@ARG Ccen>
<@Assign User$Makeand 1>
</@IF>
<@IF EXPR="(LEN('<@ARG Ccen1>'))">
<@IF EXPR="(<@Var User$Makeand>)">
  AND
</@IF>
L1.CCEN<=<@ARG Ccen1>
<@Assign User$Makeand 1>
</@IF>
)

Gene Wolf
Business Systems Analyst
DRS Optronics, Inc.
2330 Commerce Park Drive
Palm Bay, Florida 32905
Phone: 321-309-0685
E-mail: [EMAIL PROTECTED]
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf

RE: Witango-Talk: metatags within DBMS

Reply via email to