[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Re: Problem with data being inserted into a table froman array
- Subject: [sqr-users] Re: Problem with data being inserted into a table froman array
- From: "White . Denise" <DWhite@drc.com>
- Date: Wed, 1 Mar 2006 11:17:22 -0500
- Delivery-date: Wed, 01 Mar 2006 11:19:29 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcY9S56iJOLJgb6fTmW8Bl1E+VgvOg==
- Thread-topic: Re: Problem with data being inserted into a table from an array
I agree. I find isblank() to be very useful, since it encompasses both
blanks and null values.
(BTW, I suddenly have started receiving the digest again this week,
after a number of months without receiving it. Thanks, Nathan, or
whoever did something to reactivate it!)
Denise M. White
EBS Programmer/Analyst III
Dynamics Research Corporation
----------------------------------------------------------------------
Message: 1
Date: Tue, 28 Feb 2006 14:51:41 +0000 (GMT)
From: john.tucker@oracle.com
Subject: [sqr-users] Re: Problem with data being inserted into a table
from an array
To: sqr-users@sqrug.org
Message-ID: <4251069.1141138301050.JavaMail.oracle@web241.oracle.com>
Content-Type: text/plain; charset="iso-8859-1"
Akiko -
I like to use isblank for things like that, because it returns a "true"
value whether the variable being passed in is one blank space, eighty
blank spaces, or null. Your If statement would look like this:
if (not isblank($in_vendor_id) and not isblank($in_std_id_num))
(the outer parentheses being optional, of course)
-John Tucker
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users