[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] (no subject)
- Subject: Re: [sqr-users] (no subject)
- From: "George Jansen" <gjansen@aflcio.org>
- Date: Tue, 24 Feb 2004 21:45:15 -0500
- List-id: This list is for discussion about the SQR database reporting language from Hyperion. <sqr-users.sqrug.org>
At a guess--your code is reading with a fixed character length of n, and
the records are n+1 long. Perhaps the SQR was written on a UNIX box with
LF-terminated records and you're running it on Windows, with CR-LF
terminating?
>>> rwulfson@bost.com 02/24/04 6:44 PM >>>
Put a show on the $record it may already be truncated
Thanks,
Russ Wulfson
Developer
Boston Market Corporation
Office: 303-216-5614
Fax: 303 -216- 8727
"lifezfun"
<lifezfun@indiati To:
<sqr-users@sqrug.org>
mes.com> cc:
Sent by: Subject: [sqr-users] (no
subject)
sqr-users-admin@s
qrug.org
02/24/2004 03:56
PM
Please respond to
sqr-users
Hello,
I dont see anything wrong with the following still there is data
trunction
problem.
Can anyone shed some light on this.
Thanks in advance
Ram
============================================================
Unstring $record by ',' Into
$lastname $firstname $ssn
for the data following data,
Ward,Lisa,123456789
Shelton,Angela,987654321
Hooper,Colleen,123459876
Papazian,Paula,987612345
1) Record: show 'lname: ' $lastname = Ward 0 charater
truncated
2) Record: show 'lname: ' $lastname = helton 1 charater truncated
"S"
3) Record: show 'lname: ' $lastname = oper 2 charater truncated
"Ho"
4) Record: show 'lname: ' $lastname = azian 3 charater truncated
"Pap"Indiatimes Email now powered by APIC Advantage. Help!
HelpClick onthe image to chat with me
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users