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 RepliesI cant select the eventtext as my date in my datebase is of mm/dd/yyyy. I tried all ways of formatdatetime.Anyone who is kind enough to help me please with the select statement.How to convert the date to mm/dd/yyyy.
thisday=FormatDateTime(now(), 2)
rs.Open "select EventText from Events where EventDate = '"&thisday&"'", conn
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 RelatedobjRS.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 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