Simple VB script question (real easy) - Tilted Forum Project Discussion Community

Dilbert1234567 · 05-06-2004, 08:54 PM

ok i have a lot of experiance in VB, but none in VBS, i am trying to detect a NULL value from an Array and replace it with a string

the value is stored in VNR(5)

if VNR(5) is a NULL value then it should be replaced with the string nopic.gif

i know that vales are stored in VNR(5), i have tried using other search values other then NULL, like "1.jpg" which is one of the values that VNR(5) can return, when VNR(5) = "1.jpg", it is not changed to "nopic.gif" so i am quite confused about this.

Code:

<%if VNR(5) = NULL then
  VNR(5)= "nopic.gif"
  end if%>
 
<p><img src="Product_Pics\<%= VNR(5) %>" ></p>

any help would be a preciated.

Stompy · 05-07-2004, 12:45 PM

Try:

Code:

if IsNull(VNR(5)) then
....
end if

Dilbert1234567 · 05-07-2004, 01:47 PM

well that helps, the is null fired just fine but it says that VNR(5) does not suport updating, im sure i can get that on my own, trhanks foir the help Stompy

Dilbert1234567 · 05-07-2004, 01:48 PM

Code:

<%pic=VNR(5)%>

<%if IsNull(VNR(5)) then
  pic= "nopic.gif"
  end if%>
 
<p><img src="Product_Pics\<%= pic %>" ></p>

works like a charm

thanks again

05-06-2004, 08:54 PM	#1 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	Simple VB script question (real easy) ok i have a lot of experiance in VB, but none in VBS, i am trying to detect a NULL value from an Array and replace it with a string the value is stored in VNR(5) if VNR(5) is a NULL value then it should be replaced with the string nopic.gif i know that vales are stored in VNR(5), i have tried using other search values other then NULL, like "1.jpg" which is one of the values that VNR(5) can return, when VNR(5) = "1.jpg", it is not changed to "nopic.gif" so i am quite confused about this. Code: <%if VNR(5) = NULL then VNR(5)= "nopic.gif" end if%> <p><img src="Product_Pics\<%= VNR(5) %>" ></p> any help would be a preciated. __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen

05-07-2004, 12:45 PM	#2 (permalink)
Stompy Banned from being Banned Location: Donkey	Try: Code: if IsNull(VNR(5)) then .... end if __________________ I love lamp.

05-07-2004, 01:47 PM	#3 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	well that helps, the is null fired just fine but it says that VNR(5) does not suport updating, im sure i can get that on my own, trhanks foir the help Stompy __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen

05-07-2004, 01:48 PM	#4 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	Code: <%pic=VNR(5)%> <%if IsNull(VNR(5)) then pic= "nopic.gif" end if%> <p><img src="Product_Pics\<%= pic %>" ></p> works like a charm thanks again __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen