'If Blank' Conditions Wont work!!!!

The other thing to do is just append an emptystring ie:

if (objrs("Street1") & "" = "") then
    chkVal = "None"
''etc..

what it does in asp is force it to be a string regardless if it's an nul value in the recordset column and it also saves not having to do two checks for empty values ie:
if isnull(objrs("Street1")) or len(trim(objrs("Street1"))) = 0) then
    chkVal = "None"
'etc

CooPzZ

I get string values, i.e:
 
ABBEY AVENUE  
ABBEY MILL LANE  

But it goes haywire when there is no value, in the client side source code for it i can see that the value of the checkbox is being cut of so rather than be this:

...value="none"

as it should, its this:

Value="

so its gotta be this:

 value=""" & chkVal & """

part in the loop

any ideas?

Thanks Coopzz

but i dont really understand how its work, could you give an example, using this:

if (objrs("Street1") & "" = "") then
    chkVal = "None"
Else
   chkVal = objrs("Street1")
End If

does it need to be:

if (objrs("Street1") & "" = "")  = "" = "" then?

exactly how you have it. your just stiching an emptystring to the record value so it turns it into a string if it's a null value. if it's a string value already it doesn't add anything to it. so like that below.

if (objrs("Street1") & "" = "") then
    chkVal = "None"
Else
   chkVal = objrs("Street1")
End If

just remember that you may want your triming to make sure there is nothing in it. ie:
if (trim(objrs("Street1") & "") = "") then
    chkVal = "None"
Else
   chkVal = objrs("Street1")
End If

CooPzZ

Guys nothing is working!!! I dont understand what the hell kinda stick this code has up its ass but i cant get it out!!!

Its driving me crazy!!

This is the entire code again, Coopzz i tried your code but still nothing:

Response.Write "<TR><TH>Street</TH><TH>Count</TH><TH>Remove</TH></TR>"
Response.Write "<TR><TD Colspan=""3""><br></TD></TR>"
   While NOT objrs.eof
         If Trim(objrs("Street1")) = "" OR IsNull(objrs("Street1")) = True Then
      chkVal = "NONE"
      Response.Write "zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz"
         Else
      chkval = trim(objrs("Street1"))
         End If
Response.Write "<TR>"
Response.Write "<TD align=""Center"">" & chkVal & "</TD>"
Response.Write "<TD align=""center"">" & objrs("StreetCount") & "</TD>"
Response.Write "<TD align=""Center""><input type=""checkbox"" name=""DelValues"" value=""" & chkVal & """></TD>"
Response.Write "</TR>"
      objrs.movenext
    Wend

And this is what the client side source code looks like:

<TR>
  <TH>Street</TH>
  <TH>Count</TH>
  <TH>Remove</TH>
</TR>

<TR>
  <TD Colspan="3">
 <br>
  </TD>
</TR>

<TR>
  <TD align="Center">   <---****No end </TD>
  <TD align="center">130</TD>  
  <TD align="Center"><input type="checkbox" name="DelValues" value="     <----****???
</TR>

<TR>
  <TD align="Center">ABBEY AVENUE</TD>
  <TD align="center">4</TD>
  <TD align="Center"><input type="checkbox" name="DelValues" value="ABBEY AVENUE"></TD>
</TR>

As you can see its just the first record

I have a feeling its just one glitch and it will sort itself out, can anyone spot anything?

The only thing I can see thats doing is that there is a chr(0) is in the string. the code below replacates the problem
<%
    dim o: o = chr(0)
    Response.Write "Hello" & o & "Yeh!"
    'even triming wont fix this.
    Response.Write "<br>Hello" & trim(o) & "Yeh!"
%>
so you may want to try doing the replace on the chkVal
chkVal = replace(chkVal, chr(0), "")

but most probably you just have some bad data that got inthere somehow.

CooPzZ

You could try just printing out the values of Street1 to see what you get:

<%
While NOT objrs.eof
         Response.Write trim(objrs("Street1"))
         objrs.movenext
Wend
%>

--------
D_M_D

Hi all

Coopzz i went with your solution as a temporary fix, in the end i did this:

If Len(trim(objrs("Street1"))) < 2 Then

and that seemed to work, but it still gets to me because i dont know what the hell got into it, i havent got the time at the mo to look into it but at least its working for now.

I really appreciate everyone's contribution, but the points go to coopzz - You stuck with me dude!!! Thanks alot, if i could i would give feedback but they've taken it away!!

Ciao for now

Apresto

also i think a problem was that the set up of the database wasnt great to start with and has a mixture of nulls and blanks (sql server) and it has about 120 millions records in this table so changing the set up or structure of the table isnt an option at the mo :o)

Thanks again