Null table row, but cant get VBScript to see it???

[ModicaR]

Hi there,

i am trying to test if a file exists on my system, i have written all the code to deal with this and that is not the problem. What the problem is, is some products do not have files associated with them so the appropriate fields in the database are empty string values (thus = "&quot. However when i try to create a loop to deal with this, it never enters my loop!

Example:

Manu = RS("Manufact_Name&quot

if Manu = "" Then
ExistF = "F"
End If

It just does not go into the loop, even if the Manufact_Name is empty!????? i am very confused as i have tried to out the values and there is nothing, and i have set Manu to be "" and then it works!!

Please Help! it is becomming very frustrating!

Regards,

Rob

 

[onpnt]

try
If (IsNull(Manu ) or Manu = "&quot then

and also test that value as
Response.Write Manu

can you post the loop you stated. maybe there's a error in it

____________________________________________________
_{Python????? The other programming language you never thought of!
thread333-584700}

http://www.onpntwebdesigns.com

 

[davemcdonaldireland]

You could also use:

If RS("Manufact_Name&quot.ActualSize = 0 Then
....

This will pick up NULLs and empty strings.

Dave Mc Donald

http://www.mcdonaldit.com

 

[ModicaR]

Thank for the responces it now works like a charm!!! it was a silly thing!

Thanks very much!

Roberto