Hi all,

Got a problem here retrieving data from the database. I got error:
Error Type:
(0x80020009)
Exception occurred.
/text.asp, line 4

Which comes frm the function:
Function TD_Prop
    if rs("Schedule")="" then //line4
        TD_Prop = "EquipmentHead"
    else
        TD_Prop="EquipmentItem"
    end if
end function

Where it is supposed to display on the browser as:

<td width="66" class="<%=TD_Prop%>"><%=rs("Schedule")%></td>
<td width="298" class="<%=TD_Prop%>"><%=Item_Prop(rs("Code"),rs("I tem"))%></td>


Can anyone tell me what's wrong with the problem?
Thanks so much!

From where rs("Schedule") is coming in below function:

Function TD_Prop
    if rs("Schedule")="" then //line4
        TD_Prop = "EquipmentHead"
    else
        TD_Prop="EquipmentItem"
    end if
end function

I think the code should be:
---------------------------

Function TD_Prop(Schedule)
    if Schedule="" then //line4
        TD_Prop = "EquipmentHead"
    else
        TD_Prop="EquipmentItem"
    end if
end function

Where it is supposed to display on the browser as:

<td width="66" class="<%=TD_Prop(rs("Schedule"))%>"><%=rs("Schedu le")%></td>
<td width="298" class="<%=TD_Prop(rs("Schedule"))%>"><%=Item_Prop( rs("Code"),rs("Item"))%></td>

Hope this helps..

Om Prakash

Hihi om_prakash,

I got the error after trying out:
Wrong number of arguments or invalid property assignment: 'TD_Prop'
/text.asp, line 72 and 73

which is
<td width="66" class="<%=TD_Prop(rs("Schedule"))%>"><%=rs("Schedu le")%></td> //line 72
<td width="298" class="<%=TD_Prop(rs("Schedule"))%>"><%=Item_Prop( rs("Code"),rs("Item"))%></td>//line 73

Hmm..wonder what's the problem..
Click on http://n.domaindlx.com/hayley/PMS_Page.asp if u wanna see the test page. At the bottom U can see the error.

Click on "Complete unit servicing & renew wire rope". It pops up another window with dates. When u remove the date the page is able to display properly. If added date, the page displays error. Why?

But have u modified the function?

Function TD_Prop(Schedule)
    if Schedule="" then //line4
        TD_Prop = "EquipmentHead"
    else
        TD_Prop="EquipmentItem"
    end if
end function


And what does this function does: Item_Prop

Thanks


Om Prakash

Hi,

The item_prop is actually another function.

Function Item_Prop(sCode,sItem)
if len(sCode)>3 then
Item_Prop = "<a href=Maintenance.asp?EquipmentItemCode="&sCode&"&Y ear="&sYear&" title='Click to add Maintenance' target=MT_Window onclick=OpenWindow('','MT_Window')>"&sItem&"</a>"
else
    Item_Prop = sItem
end if
end Function

When the Item(which is the blue link) is linked to another page where the info are recorded according to the code(scode) linked to the item..