| | |
|
|
|
Script in VB |
|---|
| message from Zwi2000 on 23 Jul 2004 |
I am trying to displat an item if a field in my recordset is NULL, problem
is I dont know how to modify this script, I hope someone can help me. In
this example it will display if the field is = 0, how can I change this to
NULL ?
<% If StepsHistory.Fields.Item("LastModified").Value = (0) Then 'script
%>
Whatever ist o be displayedhere ...
<% End If ' end If StepsHistory.Fields.Item("LastModified").Value = (0)
script %>
Thanks
Z
|
| cmbergin replied to Zwi2000 on 23 Jul 2004 |
<%
If isNull(StepsHistor.Fields.Item("LastModified").Value) Then
%>
|
| Zwi2000 replied to cmbergin on 23 Jul 2004 |
Excelent !
If you dont mind me asking .. how would it be if it was the other way around
? If it is NOT NULL instead of NULL ?
I tried:
<%
If isNotNull(StepsHistor.Fields.Item("LastModified").Value) Then
%>
But didnt work..
Z
"cmbergin" <webforumsuser@macromedia.com> wrote in message
news:cdrgev$pfn$1@forums.macromedia.com...
|
| Zwi2000 replied to Zwi2000 on 23 Jul 2004 |
Can a combination of two values be done ? Something like:
<%
If isNotNull(StepsHistor.Fields.Item("LastModified").Value) Then
%>
AND
<%If isNull(StepsHistory.Fields.Item("DateInitiated").Value) Then%>
I want to display if LastModified is NOT NULL and DateInitiated is NULL.
I really appreciate your help !!
Z
"Zwi2000" <zwi2000@hotmail.com> wrote in message
news:cdrhcs$qnf$1@forums.macromedia.com...
|
| Zwi2000 replied to Zwi2000 on 23 Jul 2004 |
<%If isNull(StepsHistory.Fields.Item("DateInitiated").Value) AND
isNull(StepsHistory.Fields.Item("DateInitiated").Value) Then%>
Only I dont know how to do the NOT NULL instead of isNull.....
Z
"Zwi2000" <zwi2000@hotmail.com> wrote in message
news:cdrhqg$r8k$1@forums.macromedia.com...
|
| Zwi2000 replied to Zwi2000 on 24 Jul 2004 |
Yeah ... got it thanks !!!
isNull(StepsHistory.Fields.Item("DateInitiated").Value) Then%>
|
|
Archived message: Script in VB (Macromedia Dreamweaver)
