RESULTSET PROBLEM
I have a stored procedure below.. When I run it with a well parameter in
query analyser 3 of select statements return me. (i named select statements
1,2,3)
But in asp page when i call this procedure same as query analyser it returns
me 2 select statements value? what is the problem ? Code:
View Replies
I want to send the whole resultset i retrieved. now i am retrieving the resultset and able to print 15 records in one frame. if i want to print whole the dump records what i have to do.?
View Replies
View Related
I am trying to make my result set print out the results in the same style as
a calendar or photo album. I am actually making a photo album, and I can
only print the results in list format. I would like to have 3 or 4 results
per table row. Then once I have 3 or 4 results across a new row in the table
will start. Code:
View Replies
View Related
I've got a problem with an ASP page which calls a stored proc. The sybase stored procedure returns numeric values as shown: ...
View Replies
View Related
I have written an ASP script that connects to a database and runs a stored procedure and displays the results in text format ...using the <TABLE> tag. But I would like to
have these results appear in a NEW Window in an Excel format. I used :
<%
Response.ContentType = "application/vnd.ms-excel"
Response.Buffer = true
Response.Clear
%>
This opens up Excel in the same window and usually does not refresh my data ...even though the stored procedure is actually running on the database server.
View Replies
View Related
I am populating a SELECT list from a result set. I need the same result set to populate a second SELECT list. Only one list is being populated. How can I get this to populate both? Here is my code:
<select name="options" size=10 multiple="multiple">
<% while (!rs.EOF) { %>
<option value="<%=(rs.Fields.Item("FIELD1").Value)%>">
<%=(rs.Fields.Item("FIELD1").Value)%>
</option>
<% rs.MoveNext(); }
if (rs.CursorType > 0) {
if (!rs.BOF) rs.MoveFirst();
} else {
rs.Requery();
}
%>
</select>
View Replies
View Related