ObjRS
I was just wondering what the zero represented in the code:
objRS(0)
Is it the record position within the opened table?
ADVERTISEMENT
ObjRS.RecordCount
I have:
strSQL = "SELECT * FROM newarchive WHERE Program_Title LIKE '%" & program & "%' ORDER BY ID"
set objRS = objConn.Execute(strSQL)
Response.Write "There are " & objRS.RecordCount & " results."
I get -1 for the count on every search.
Insert Into With OBJrs
I"m having trouble inserting into a table with a objRS can someone post a example of the formatting?
View Replies View RelatedObjRS.recordount
objRS.recordount returns 0 even though there are records in the recordset or table
This problem occurs only when I upload asp file to server(windows server)
It is working correctly on local computer. I have used following code:
<%
objrs.open strsql,objconn,3,2
count1=objrs.recordcount
%>
Any suggestions?
Do While Loop To Add Up ObjRS Values
I have an ASP page connected to an Access database table. Im wondering of an easy do while loop which will go through each of the records in a specific column and add them up.
Do While Not objRS.EOF
objRS.MoveNext
'Code to add the sum to TotalNumberValue using objRS("NumberValue") recordset
Loop
How Do I Compare A ObjRS(0).Value With NULL
Dim objRS
objRS=server.createobject
after my sql statement is executed
lets say thers nothin to return.. no value
then with what do i compare objRS(0).Value?
is it NULL or 0
i tried but they aint workin
ObjRS("eventdate").value
how to list a specific record's value on a one of many of these: <%=objRs("eventcaption")%>. I'll try to be as specific as possible but I am not sure if I know just how to describe it.Basically I have a calender and in each day I want to list an event caption such as "Wedding Day", specific to the events of any given day. Here is what I am looking at so far. Can I do something like <%=objRs("eventcaption.first")%>? Code:
View Replies View Related