Webmaster Forum / ASP / Database Access / July 2006

Im stuck on this stored procedure.  I want to get a recordset that has
the first two rows populated with the min() and max() of each column of
the following stored procedure, with the rest of the rows filled with
the results from the stored procedure:

I get the following error while trying to execute a stored proc
Application uses a value of the wrong type for the current operation.
heres the ASP Code
sfrmDate = Request.Form("frmMonth") & Request.Form("frmDate") & Request.Form("frmYear")

I was wondering if i can create 2 server objects for my MySQL database. here is my code:
           <!--#INCLUDE FILE="connection.asp"-->
           <%
           catID = Request.QueryString("catID")

heres what i wanna do.......
for each month, i want to create a new table...........but if the table is already existing, then how would i detect that........and vice versa, how would i check that its not there.................

Ok what do I have to do to make it work if JUST checking for NULL columns it
is ok to update field?
I have ACCESS database.
I was given this but I cannot make it work:

We are moving over to SQL Server 2005.
Could anyone give me a simple code to connect SQL Server 2005 in ASP.
What's the connection string?
Is

I don't know how best to describe this, except with an example of what i
want to do:
A table in MS Access 2000 holds choices made by a user in response to a
series of questions, but for each question in the response (a response

Anyone who can send me a sample code of how to upload a file into SQL 2005
server using .asp running on IIS 6?
I have a code that has been working when uploading into SQL 2000 but when I
do the migration to SQL 2005, it doesn't work anymore.

OK I've got a database that a programmer setup with char columns
instead of varchar, because char columns are more efficient than
varchar to process.  Whenever I list the data on a webpage, however, I
have to call trim to get rid of the whitespace.  It would seem to me

i know how to use rs.MoveNext to get the next record in the database. Was
wanting to know how to get the previous record.
I tried rs.MovePrevious and i get error.....
My code is as follows (the database is opened, and a query is already ran

How do I display only the first few records in a recordset.  I don't
want paging.  I just want to list the last few additions to a database
and thats it.  Is there a simple way?

I recently came across an article
(http://www.aspfaq.com/show.asp?id=2188) which said:
--
Depending on the version of your MDAC driver, and the database you are

Here
http://www.aspfaq.com/show.asp?id=2424
it says
"Open your connection just before needing it, and close it as soon as

I have a table of substitutions, like this:
id  word  substitutions
1  cat  feline mammal
2  dog  mans best friend

I want to SELECT * but omit one field (the ID field, the first one)
from the recordset.  Any way of doing this?  I want to do this because
I have several tables with different fields and I want to use the same
code to list the contents of each, so I don't want to specifically