Object Required

[crjo]

Get 'Object Required' error on the first line of my IF statement:
<%
IF (rsRoomRoster.Fields.Item("RoomHoldDate").Value IS NOT NULL) AND (rsRoomRoster.Fields.Item("AdmissionDate").Value IS NULL) THEN
Response.Write("<td>")
Response.Write(rsRoomRoster.Fields.Item("ResName").Value)
Response.Write("Room on Hold")
Response.Write("</td>")
ELSE
Response.Write("<td>")
Response.Write(rsRoomRoster.Fields.Item("ResName").Value)
Response.Write("</td>")
END IF
%>
Take out the statement and it everything works fine. Tried Dim, As String, Len, etc. Same error.
SQL is calling stored proc. Using Dreamweaver MX 2004.

 

[bslintx]

Crjo,

Hate to ask but did you create the recordset?

Set objConn = Server.CreateObject("ADODB.Connection")
Set rsRoomRoster = Server.CreateObject("ADODB.Recordset")

Did you open the sql?

rsRoomRoster.Open strSQL, objConn

Could you show your db connection and rs code?
Looks good to me...perhaps missing something there or try shortening code...

<%
IF rsRoomRoster("RoomHoldDate") <> NULL AND isNull(rsRoomRoster("AdmissionDate")) THEN 

Response.Write "<td>" & rsRoomRoster("ResName") & " Room on Hold</td>"

ELSE
Response.Write "<td>" & rsRoomRoster"ResName") & "</td>"
END IF
%>

 

[tsuji]

Or, maybe this would be better? (Because checking null using <>null will always result in null).
[tt]
IF (Not isNull(rsRoomRoster("RoomHoldDate"))) AND isNull(rsRoomRoster("AdmissionDate")) THEN
[/tt]
- tsuji

 

[bslintx]

yep..overlooked that...thanks tsuji ;-)

 

[crjo]

tsuji, thanks for your help (you too bslintx!)
This worked:
<%
IF (Not isNull(rsRoomRoster("RoomHoldDate"))) AND isNull(rsRoomRoster("AdmissionDate")) THEN
Response.Write "<td>" & rsRoomRoster("ResName") & " Room on Hold</td>"
ELSE
Response.Write "<td>" & rsRoomRoster("ResName") & "</td>"
END IF
%>

 

[bslintx]

Glad it worked, remember...asp has a lot of shortcuts...no need to put all the unnecessary response.writes (server trips)and also querystring can be written w/o querystring but need .form for post method. Thanks for the recognition.

BSL