RE: [sqr-users] Re: Problem with data being inserted into a tablefroman array

["the dragon" <ceprn@hotmail.com>]

Denise,

I think you may be incorrect.  Unless they changed the functionality, 
isblank only checks for spaces; isnull checks for nulls.

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)
----Original Message Follows----

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

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


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