[Download-List] @date issue...

[Maggie Steyn]

I think you need to move the Date field to somewhere before the keyword
"HEADING". You actually want the date to be output as part of the data, so
all data fields need to be defined before "HEADING".
 
Hope this helps.
 
 

Maggie Steyn
Application Analyst
Information Technology Department
Niagara University
msteyn at niagara.edu
Phone: (716) 286-8651
Fax: (716) 286-8045 

 



-----Original Message-----
From: Keith Johnson [mailto:KJohnson at lcsc.edu] 
Sent: Tuesday, November 18, 2003 2:52 PM
To: download-list at cedarville.edu
Subject: [Download-List] @date issue...



Hello all,

This is my first post to this list.  Thanks Dave for helping me getting on
the list.

My question is regarding this download:

SSELECT UT.OPERS BY SYS.USER.NAME WITH SYS.USER.CLASSES LIKE ...ADMIN... OR
WITH SYS.USER.CLASSES LIKE ''

DOWNLOAD UT.OPERS \

@ID COL.HDG "Datatel loginID"\

SYS.USER.NAME COL.HDG "User Name" \

EVAL "IF SYS.USER.CLASSES EQ '' THEN 'Power' ELSE ''" COL.HDG "Power User;
All Screens except Privileged (Admin)" \

SYS.USER.CLASSES NUM.VALUES ALL \

HEADING FIELD.NAMES @DATE CONV "D4/" \

FILE _HOLD_ UT.OPERS.HTM FORMAT HTML OVERWRITING

I get records like this but no date; any ideas?  I just upgraded to Download
7.02.

-KJ

Datatel loginID User Name       Power User; All Screens except Privileged
(Admin)       SYS.USER.CLASSES       
AMAYERCIT       Amy A. Mayer, IT staff          BUD.ADMIN.2 ADMIN FA.ADMIN
ADMIN.1 AP.ADMIN BUDADMIN GL.ADMIN PU.ADMIN DG95 DG96       
AMAYERCIT.HOLD  Amy A. Mayer, IT staff          BUD.ADMIN.2 ADMIN FA.ADMIN
ADMIN.1 AP.ADMIN BUDADMIN GL.ADMIN PU.ADMIN DG95 DG96       


CHOLBROOKREG    Carolyne M. Holbrook    Power          


Keith Johnson

UNIX Systems Administrator                                      Programmer /
Analyst

Lewis-Clark State College
208.792.2510

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20031118/0b59f943/attachment.html>