Re: Witango-Talk: metatags within DBMS

Atrix Wolfe Fri, 06 Jun 2003 04:42:58 -0700

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

Re: Witango-Talk: metatags within DBMS

Reply via email to