Forum: ASP Database

SELECT COUNT(DISTINCT PRES_CYCL_ID) is being changed to SELECT COUNT(DISTINCTPRES_CYCL_ID) If I response.Write the query, I see the space and...

I have a number of websites running against several Access databases. Every once in a while (under relatively heavy load, but rarely more than 1...

Hi all! I've included a code sample below. I am trying to format a table cell so that if the value is outside some predefined range, the...

I would like to delimit a table to the newest 2000 entries I use ADODB and Microsoft.Jet.OLEDB.4.0 ========== Any sense in this PSEUDO!...

You should keep another column which stores the date as a date (as it should be). Or have *just* the date column. In case (1), you can have ...

Hello all. We have a page that calls a SQL Server database using this method, cn.uspGetEventPerson Null, Null, rsEventPersons where cn is our...

Iam trying to connect Oracle with ASP and resulted in Connection failed.. can anyone explain how the connection has to be established.

REPOST FROM Hi, I'm having trouble configuring RDS on an IIS 6.0 server. I've followed all KB articles I've found on it but it still doesn't...

Access 2000. I'm trying to create a DB that stores records of books, but my understanding of DBases is very simple at best so, I have a table...

I am looking to do the following from a C# ASP.Net applicatio 1. Generate a DS from a SQL pull of a single table. Once I have pulled the data...

Any ideas?? Here is the error I'm getting: <p>Microsoft OLE DB Provider for ODBC Drivers</font> <font face="Arial" size=2>error...

The problem with drop view is solved by not using stored procedures anymore. They where only used to limit the amount of records, but this can (in...

attaching a Further when I change the extension of the page to htm the javascript works alright even with the line at the top of the page ***...

I have a time field in an access database and I want to be able to add 15 minutes to it. I can do this manually by taking the minute, adding 15...

We just upgrade our oracle server from 8i up to 9i and now our asp pages are failing. We were using the Microsoft ODBC drivers for Oracle V...

Hi all, I have a stored proc which looks like this ---------------------------------------- create procedure PROC1 @param1,@param2,@param3,......

Hi All I've created my Tables in Access using it's standard Design window, but I don't seem to be able to export my schema of these tables so...

Hi All As per my previous posting, I'm having trouble getting my schema out of my DB so you will have to bear with me on this. Basically I...

Can anyone tell me how I go about making one list in a form only show relevant details depending what the user chooses in the preceeding list box....

Greetings, I have a question about a database query from an asp page. My query is functional and produces the data that I need; however, one...