Hello, 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: SELECT id as '#', name, ...more >>

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") stoDate = Request.Form("toMonth") & Request....more >>

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

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....................more >>

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: UPDATE Table SET Col1 = ISNULL(NULLIF(Col1,''),'new value'), Col2 = ISNULL(NULLIF(Col2,''),'new value') Please ...more >>

Hi, 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 "Provider=SQLNCLI;Server=127.0.0.1;Database=dbName;UID=UserName;PWD=User Pas­sword;" right? Thanks. *** Sent via Developer...more >>

I run an ASP script that invokes a stored procedure which creates a table, next step in that same ASP page there's a select statement that loads data from that recent table. That data is loaded into a recordset. Problem is that some of the values printed to the page that are obtained by re...more >>

Hi, 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. Thanks ...more >>

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 equates to a record) there is a rule that if she chooses (a or b...more >>

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 that calling trim() for ea...more >>

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 and all) rs.MovePrevious Pr...more >>

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? ...more >>

Here http://www.aspfaq.com/show.asp?id=2424 it says "Open your connection just before needing it, and close it as soon as you're done with it. Your motto should always be "get in, get/save data, get out." Always close your ADO objects and set them to nothing. " I'm unclear on when that is...more >>

Hi guys, I have a table of substitutions, like this: id word substitutions 1 cat feline mammal 2 dog mans best friend 3 bird creature belonging in a cage and then I have some text, The big cat was swallowed up by the fat dog just as an ugly bird flew overhead. and I want t...more >>

Hello, 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 select co...more >>

The ASP application inserts transaction records in transaction table with the system time as the primary key. However, it is possible to have primary key violation because the records in transaction table come from different sources. The application can show error message and the user can file a...more >>

How would I craft a query to check whether the resultset was a series? The basic query is this: SELECT StepNumber FROM Steps WHERE Range='Midset' stepnumber is an integer field. The stepnumbers in the range must form a series starting at 1, i.e. no gaps. 1 2 3 4 5 6 7 8 9 Can I do this in ...more >>

I have a simple script that uses an access database. Every time the script is called, I can see using filemon that a request for "c:\windows\system32\inetsrv\system.mdb" is made, which fails.(file not found) Script works fine, however, I am wondering why is it doing that? This database is not...more >>

Hi all, I have an asp page which reads files from SYBASE that are stored as IMAGE data type It appears that there only 1MB of data is retrieved, although data_length had suggest that there are 5 MB ++ worth of data. And because of that , the document does open at all cos of the incomple...more >>

Hi all, I've got a SQL Server 2005 Express Edition db running on Win2003 SP1 with a varchar(max) field and an ASP that retrieves text from the varchar(max) field and outputs it. Only problem is, nothing gets output. Page runs without error and all other fields are output but where the va...more >>

I want to check a number of 'columns' in a table to see if their value equals either 4 or 5. That is, select Count(*) from myTable WHERE step = 100 AND ( a=4 Or a=5 Or b=4 Or b=5 Or c=4 Or c=5 Or d=4 Or d=5 Or e=4 Or e=5 Or f=4 Or f=5) (there's more than this) I thought ther...more >>

Hi, Sorry if this has been asked before, I've searched the archives and FAQ with no luck. I'm using ASP to build a page containing the results of a simple 'SELECT * FROM whatevertable'. 'whatevertable' contains 60000+ rows, but only 1000 rows are displayed at a time (clicking a ...more >>

In SQL 2000 I have an Image table that has an "image" column. In this table these "images" are stored in a PDF format. I'm trying to render several of these PDF images in one browser by looping through the recordset and doing a Reponse.WriteBinary for each image. However, when I do this it on...more >>

Hi all, Very Frustrated!!!! I am trying to execute the follow Access (Jet SQL) query. As i understand it LEFT JOIN returns the results of the first table even if there is no matching results in the second table. This is ok until i introducts a WHERE or AND clause to filter the results...more >>

In a nutshell, I'm trying to access a FoxPro table in a Classic asp application that is located on another server, but I'm getting the [Microsoft][ODBC Visual FoxPro Driver]File 'table.dbf' does not exist. I'm in the process of upgrading to a new machine, but was able to get it to work with ...more >>

Want to get recrods from an access database the begin with a certain letter. Any way possible? not exactly sure how to setup the SQL code for it. thanks, jay ...more >>

Anybody have any experience with plotting map points with Google Maps API from an Access DB? I have a database with about 90 locations that I would like positioned in the Google Maps. I found a cool tool to get the long and latitudes to complete the database, now just need to figure out h...more >>