Hi there,
I have a Query with Field1 with values and some Null values.
By applying IIf(IsNull([Field1]),0,[Field1]) it changes
a Null value with zero.
I want the Null to change to the highest...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20147280.html
Zones:
MS AccessDate Answered: 07/08/2001 Grade: B Views: 0
Hey all,
How do I display no values in the DateTimePicker when the user hasn't entered/selected a date?
When I bring up a new entry screen, all the DateTimePicker dates show the date the comp...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_20163060.html
Hi,
if i have null value in query in Dataenvironment and SQL statement, the field value equaled null gives me error when i want it to be displayed in Textbox.
for example:
Text1 = Dataenvironme...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20165967.html
Zones:
Visual BasicDate Answered: 08/22/2001 Grade: B Views: 0
I need confirmation that there is a function within Interbase 7.0 that allows you to substitute null values with replacement values, and whether the following code is correct.
CREATE TABLE "MyTa...
http://www.experts-exchange.com/Database/Interbase_Firebird/Q_20427027.html
In PHP the Ocifetchinto function fetches only not null values.how to fetch each row along with null values instead of using OCIFetchInto & OCIFetchStatement
http://www.experts-exchange.com/Database/Oracle/Q_20504120.html
Zones:
OracleDate Answered: 02/19/2003 Grade: B Views: 0
Anyone, that has ever dealt with SQL Server 2000 and cold fusion knows the problems of NULLS.
My question is there anyway to detect them. Here is my workarouns so far:
<!--Run query -->
<cf...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20546746...
Hello,
There is problem I am facing, though I have got around it - as you would all agree it is not the 'right' way.
I am reading a value from an Adodc object there is no problem if a value e...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_20613057.html
Zones:
VB DBDate Answered: 05/12/2003 Grade: B Views: 0
I have a SqlDataReader and I want to know if one of the fields is null. I have tried IsDBNull(dr.GetString(0)). It gave me an error message. Can anybody help? Thanks!
http://www.experts-exchange.com/Programming/Languages/.NET/Q_20843982.html
Zones:
.NETDate Answered: 01/07/2004 Grade: A Views: 17
Set DB = GetDatabase '*****Function to return adodb.connection object
strSQL = "insert into mytable(column1,column2) values(?,?)"
Set Cmd = GetADOCommand(DB, strSQL) '*****Function to return ...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21008465.html
Zones:
Visual BasicDate Answered: 05/31/2004 Grade: A Views: 5
Any one know how to have a field not display in a report when the value is null.
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_21317006...
