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

["Knapp, Richard" <KnappR@umsystem.edu>]

Sorry to contradict, Clark, but isblank checks for "empty string, null
string, or composed entirely of whitespace" p 179 SQR Server v4.3.


Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
the dragon
Sent: Wednesday, March 01, 2006 10:24 AM
To: sqr-users@sqrug.org
Cc: DWhite@drc.com
Subject: RE: [sqr-users] Re: Problem with data being inserted into a
tablefroman array

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

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