My vbscript reference says the right way to check
for a null field is:
isNull ( mystring )
so why doesn't this work?
if ( IsNull( sList ) ) then
'do nothing
else
Re...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_10297656.htm...
Zones:
ASPDate Answered: 02/21/2000 Rating: 7.6 Views: 0
Hi,
I need to update a column (+1) for all entry matching in a list.
UPDATE table
SET err = isNull(0,err) + 1
WHERE custno in (@list)
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20442341.html
Zones:
MS SQL ServerDate Answered: 01/03/2003 Rating: 7.6 Views: 0
Hi
This may be very basic question - but can I use isnull while creating a view
e.g is this ok.
SELECT
(isnull(B.field1,0)/B.field2) NET,
FROM
TABLE1
...
http://www.experts-exchange.com/Database/Oracle/Q_20556470.html
Zones:
OracleDate Answered: 03/19/2003 Rating: 8.2 Views: 0
I have a library database with a field for author's last name and another for first name. I am trying to design an "author search" query for the library. The first and last name for the search ar...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20596429.html
Zones:
MS AccessDate Answered: 04/25/2003 Rating: 5.8 Views: 0
for a table temp
which have a column is named id varchar(20)
in select clause
select 1
from temp t
where isnull((select id from temp where t.id= id and 1=2 ), '2') = '2'
will reutrn n...
http://www.experts-exchange.com/Database/Sybase/Q_20751412.html
Zones:
SybaseDate Answered: 07/11/2004 Rating: 7.4 Views: 0
in vb6 there was IsNull()... is there a replacement in vb.net?
- Marc
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20813419.html
Zones:
Visual BasicDate Answered: 12/01/2003 Rating: 9.2 Views: 110
Hello,
Here's the problem. if this (If Form2.SetAlertsViewer.ListItems(H).ListSubItems(1) = "Source Interface" Then) isn't true SourceIntCol collection never gets built and this (If SourceIntCol...
http://www.experts-exchange.com/Programming/Misc/Q_20954410.html
Zones:
ProgrammingDate Answered: 04/14/2004 Rating: 5.8 Views: 36
I have a problem...I have the following code to display inventory values for groups in a web page. i am able to display the information if the value is either null or greater than 0....but i get a...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21378506.htm...
Zones:
ASPDate Answered: 04/11/2005 Rating: 7.6 Views: 0
with regards too the below sp, would it be possible too pick up A.GrandTotals that are 0? would it be using ISNULL
@surname nvarchar(25),
@start nvarchar(20),
@end nvarchar(20)
AS
SELECT...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21489838.html
Zones:
MS SQL ServerDate Answered: 07/15/2005 Rating: 8.6 Views: 0
Here's what I'm trying to do in a crystal running total, but i get an error on the isnull(previous({PolicyBaseView.DateofDeath})) part. Is there a way to read null from a previous record. I need t...
http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_21498381.html
