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?
I was just wondering what the zero represented in the code:
objRS(0)
Is it the record position within the opened table?
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.
I"m having trouble inserting into a table with a objRS can someone post a example of the formatting?
View Replies View RelatedI 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
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
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