Re: [sqr-users] blank line being inserted unexpectedly while issuingprint commands

[marc.taquoi@bluewin.ch]

>-- Message original --
>Date: Mon, 11 Apr 2005 21:41:21 -0400
>From: "Larry Roux" <lroux@syr.edu>
>To: <sqr-users@sqrug.org>
>Subject: Re: [sqr-users] blank line being inserted unexpectedly while
>       issuingprint commands
>Reply-To: "This list is for discussion about the SQR database reporting
>       language from Hyperion Solutions." <sqr-users@sqrug.org>
>
>
>It appears that you are still printing a line in your loop, but the
>variable is coming out a space so you don't see the results.  As a
>method of debugging try something like 
>
>Let $var = $var || ' row: ' || some data from the row
>
>that might tell you which row is still printing.
>
>also, instead of blanking out the variable (Let $var = ' ') try putting
>something in there to see if that is, in fact, what is happening.
>
>
>
>
>
>Larry Roux
>Syracuse University
>lroux@syr.edu
>
>>>> fromthehills@gmail.com 04/11/05 9:27 PM >>>
>Hello All -
>You've been super helpful to me in the past, and I've got another
>problem that has me stumped.
>
>I am writing a report that selects a row of data from a table and
>based on the data in that row, it may decide to omit the line from the
>report.
>
>So let's say I have table:
>row 1 - a1
>row 2 - a2
>row 3 - a3
>row 4 - b1
>row 5 - b2
>row 6 - b3
>row 7 - c1
>row 8 - c2
>row 9 - c3
>
>And I know that, based on the content of row 5 (b2) that I want to
>omit rows 4-6 (the b's).  I've got the logic working so that all three
>rows are omiitted, but for some reason the output is:
>
>a1
>a2
>a3
>
>c1
>c2
>c3
>
>and not:
>a1
>a2
>a3
>c1
>c2
>c3
>
>I'm just using a basic "print $var (+1,1)" command and have been
>through the code about a million times to see if I might have an extra
>"print"  statement in my exclusion processing, but I can't find
>anything.
>
>Has anyone encountered anything like this?  Any suggestions of things
>to check that could cause this?
>
>Thanks!
>Marc
>
>_______________________________________________
>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

Marc TAQUOI
Chemin des Vignes
1127  CLARMONT

Fixe : +41 (0)21 624 21 27
Mobile : +41 (0)79 818 52 35 

Email : marc.taquoi@bluewin.ch
 


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users