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


ADVERTISEMENT

To Send The Resultset To Printer

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

Calendar / Album Style Resultset

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

Resultset Returned By Stored Proc

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

Resultset Output In Excel Format

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

ResultSet For Multiple Select Lists

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







Copyrights 2005-15 www.BigResource.com, All rights reserved