I'm looking for how do create a date filter for a simple recordset. I've been away from programming for a couple years and I am blown away by how much I've forgotten. This what I have which isn't working of course... strSQL = "SELECT * FROM gigs ORDER BY gigDateTime ASC;" Set rsGigs= Serve...more >>

My Authorware training pieces send data to an Access database via asp pages. I test the system in the IIS package in Win XP. All is currently running well with one exception: the Access database keeps losing two group/user names. After selecting the database file, I right click on Proper...more >>

Hi, I know this is an old question but I don't find the solution on the 'net ... The user enters his data into a multiline textarea field. The data is saved in a TEXT field in a database on a SQL Server. I want to display that data now, but the carriage returns should be replaced with <br>!...more >>

I found this function on the web Function GetSubstringCount(strToSearch, strToLookFor, bolCaseSensative) If bolCaseSensative then GetSubstringCount = UBound(split(strToSearch, strToLookFor)) Else GetSubstringCount = UBound(split(UCase(strToSearch), UCase(strToLookFor))) End If End Function...more >>

I have a SQL Server 2000 table with the following structure: CREATE TABLE [Personal] ( [UserId] [INT] IDENTITY (1, 1) NOT NULL , [Name] [NVARCHAR] (50), [Surname] [NVARCHAR] (50), [SomeDate] [DATETIME] ) UserId is the primary key. The user captures the date in YYYY/MM/DD format in...more >>

Hi Folks, I am a rank amateur at hand coding anything as all I have done to now is use MS Frontpage. I need an application to register a new user on a website. The user's data will be kept in an Acess 2000 db. I do not even know where to begin. I think the logical steps would be : 1. H...more >>

Hello, I have an ASP that should get data from 2 tables located in 2 mdb files. Is it possible to create a liked table in one of them so I will need to open only one connection? If yes, how? Thanks ...more >>

Hi all... I have a text file line by line example: test.txt aaaaaaaa bbbbbbbb ccccccccc bbbbbbbb ccccccccc aaaaaaaa ecc... I wolud wnat to exoprt the realted value from test.txt in the MDB TEST.mdb>Table1 filed1 (aaaaaaaa) filed2 (bbbbbbbb) filed3 (ccccccccc) filed1 (bbbbbbbb ) fil...more >>

Hi all, I'd like to trigger a VBScript by clicking on a push button, but I always get errors and the line number and error description don't make any sense (Line: 29 Char: 6 ';' expected) Line 29 = Response.Write "<H3 ALIGN='center'>Items Found for Category: </H3>" where the building of...more >>

My web-packaged training piece (in Authorware) sends user data to an Access database via an ASP page. I have recently increased the number of variables sent to the database from 25 to 35. Each variable can be a string of 10-15 characters or a numberical value of 2 digits. The number of ch...more >>

Hi I am connecting to an Access DB but when trying to retrieve search results from the DB, I am met with the error: Error Type: Response object, ASP 0100 (0x8007000E) Unable to allocate required memory. /sa143/chis/CHIS_View_Results.asp Browser Type: Mozilla/4.0 (compatible; MSIE 6....more >>

I'd like to set up an ASP page where I can add, delete and modify records in a simple and small CSV data base. The data base (table) will only have a few lines and columns. I'm guessing that there is already a sample asp page on the net that I can use as my starting template but I can't for...more >>

My web-packaged training pieces (using Authorware) send data to an Access database via ASP pages. In the past, I have tested the files using the version of Microsoft IIS that came with my Win XP Pro. It worked great. Now, I am having trouble. The files that ran 6 months ago no longer run...more >>

How can I do this... Pretend that this is my SQL statement... SELECT pageData FROM dataTable WHERE pageData LIKE 'winners' Pretend that the text below is what gets returned. "Congratulations to the 51 state-level winners who will take part in the National Cookoff of the National Chicken...more >>

Hi Everyone, I got this code on a .asp page that retrieves data from an AccessDB and shows it in a table. <% Dim DB Set DB = Server.CreateObject ("ADODB.Connection") DB.Open ("Provider=Microsoft.Jet.OLEDB.4.0; DATA SOURCE= " + Server.MapPath("Muziek.mdb")) Dim RS Set RS = Server.Cre...more >>

Hi I run the following code in an include file to set up my asp connection but I keep getting an error on the line "myconn.open mydb". I have tried and re-tried everything I can think of but it's just not running. The db location is correct and all the files are saved to the correct folde...more >>

I have a Server2003 running IIS6, 3GIG RAM, 2 processors. Have written sql to execute within the asp page through odbc connection (no choice here). From within sql query analyzer, takes about 42 seconds to run. But, when rendering large recordset on asp page it takes about 9 minutes. Does ...more >>

Hi, I'm looking into converting a fairly complex application from using ODBC drivers to OLEDB drivers. Judging from some errors I get when just substituting the connection strings I have to do some reprogramming. However, I get a different set of errors from the Microsoft OleDB For Oracle ...more >>

how can i get default value field in a db like .mdb , swl server and mysql with asp programming ?? ...more >>

Hello World, Q. How could I compact MS Access 2000 database on remote web server by using ASP ? Q. Is remote database compact will disable for a moment read and write access for IUSR_ user? NOTE: MS Access not installed on web server. --- In my Windows EXEcutable applications I am usi...more >>

Greetings.. I have a table of Name/Value pairs that I need to report on. They are results from a survey. Format is like: QuestionID, Answer F1,8 F2,9 F3,1 F1,3 F2,4 F3,8 .... etc I need to turn it on it's side I think.. so I get something along the lines of: F1 F2 F3 8 ...more >>

I need to upload files to a server, and place the name, size and some other information into an Access DB at the same time. Can anyone recommend the best and simplest way to do this? Thanks in advance. ...more >>

We are migrating some asp based apps that use MS Access for the back end and we are getting lots of intermittent errors whenever quesries are made and whenever data is added or changed. the app is now on a server that is much much faster than before. Filemon is showing SHARING VIOLATION errors...more >>

Using ASPFileUpload (http://support.microsoft.com/default.aspx?scid=kb;en-us;299692) and works for IE6 and FireFox but not Safari. Thanks in advance for your assistance....more >>

I'm getting the following error message when i try to input the information through the page and then its going to write to database. Please see below for my query. Any Idea? <% 'Dimension variables Dim adoCon 'Holds the Database Connection Object Dim rsAddComments 'Holds the record...more >>

Hi There, I am new to asp, i am creating an app using asp/access2000 my site is live/ http://shopgpbikes.com/sport.asp What I am looking to do is when thumbnail is clicked i want the record set plus the large image to appear in the popup. As it is now just the large image shows in the popup. ...more >>

Hi everyone there, >From time to time, I go back to an ASP project of mine that drives me nuts, now. In an ASP script, I need 1) or to get the "ROWSOURCE" property of an Ms Access table 2) or to get the constraint column of a foreign key (so to say, if my table is Books in which a forei...more >>

I have completed an Web App that accesses numerous databases and want to ensure that connection pooling is being fully utilized The connections are made through OLE DB, and I am uncertain how to actually monitor this through Win Performance Monitor (perfmon.exe) SQL monitors are not a probl...more >>

Is it possible is ASP to set a password on an Access database that previously had no password protection? Thanks! ...more >>

I've got an ASP site querying an Access database to get photo gallery thumbnails. There are two types of queries, all on a single table with 15,000 records. For both types, performance for the first query is poor, and improves on the 2nd and so on. The worst case is the free search query against...more >>

I have developed in ASP in the past and am now getting into ASP.Net and have hit a road block. I've been reading tutorias and documents and am still having problems. I have the following code example: **************************************** Private Sub Page_Load(ByVal sender As System.Ob...more >>

Hi All: I have an ASP page which calls another another page via server.execute, which means that focus is returned the initial page after executing the code in the second page. Both pages call a database, creating different record sets. My doubt is whether it is necessary / recommeded t...more >>

Hello, I am trying to enter data. I have a loop to insert data into 3 tables. the data entered to the first table only once based on the action. Ex: on error resume next if action="dir" then strqry1="insert into issuemain(formid,trdate) values(...) conn.beginTrans ...more >>

Hi I have a asp page with a database connection where I need to export adresses into a MS Word Serial Letter. Is this possible and if how?? Any help is well appreciated Peter ...more >>

I am new to asp, and want to put a simple database on the web so the users can search certain items. I downloaded webmatrix in order to learn more about asp & databases. In order to put it on a webserver, i have made an account with brinkster (www.brinkster.com) because they support asp for fr...more >>

Hi, I'm not sure this is the right group to post this message but.... What would it take Regarding Resources & Technology to shift a public website to a secure private one that only authorized users can enter, after they have entered their Credit card Info ? thanks in advance Romy ...more >>

I'm trying to show the total number of votes for a specific set of employees. I have one access2K DB with a single table called master. In that table is two columns: ID and Vote. The vote column is the only one I'm concerned about. I just need to list their names in one table column then how...more >>

Is there a way to write script inside of an access table/field? Maybe I'm missing the obvious (yes or no), but say I want to enter <%=("hello")%> into a memo field. Is there a way to display hello on my asp page? Of course I want to do more than this (my objective is someting like...more >>

Greetings, I have an ASP/VBScript 'application' that accesses database files through OLE DB. It was developed on Win2k and Win2k server. The script basically opens a connection to a remote drive which is shared, and opens a recordset for reading and writing. The connection is made in fr...more >>

Greetings, I have an ASP/VBScript 'application' that accesses database files through OLE DB. It was developed on Win2k and Win2k server. The script basically opens a connection to a remote drive which is shared, and opens a recordset for reading and writing. The connection is made in fr...more >>

I get the subject message when I try to Open the connectio the database. Scenario: IIServer: Win XP DB Server: Windows server 2003 running SQL Server 2000 Mixed mode is enabled on SQL. Machines are NOT in domain Connectio String = "Provider=SQLOLEDB;Data Source=192.168.0.4;User ID=*...more >>

Hi to everyone, i am building a database application using FrontPage 2003 + Access 2000. I have a date/time field inside my database(birthdate). I use a wizard inside FrontPage to filter my database. At some step the wizard asks me to assign a default value to birthdate. What value should i a...more >>

I'm having a little problem with conditioning formatting. This is a page that, when loaded, puts the Request.ServerVariables("AUTH_USER") into a variable. It then checks to see if that name has already been logged to a table in an access2000 database. If it has, then they should get a messa...more >>

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xb58 Thread 0x1f4 DBC 0xb7d0064 Jet'. /tony/secure/check_user.asp, line 24 getting this error. Anyone ...more >>

Hello All, Windows 2003. IIS 6.0. ActiveX component can't create object: 'CDONTS.NewMail' How to enable this? With best regards, ...more >>

Okay guys and gals, MS communities has never let me down ... I'm not certain which group to post this to, so direct me to the correct on please. I am not cross-posting. I have 200+ PDF files, they have matching HTML files, and they have matching text files. I just want a description, d...more >>

Hi all, I have an application which is trying to create an Excel object via asp, but fails to do so. I get the error message: Microsoft VBScript runtime error '800a0046' Permission denied: 'CreateObject' The line of code looks like this: Set xlApp = CreateObject("Excel.Application") ...more >>

Dear All, I have a question on the db connection when I develop ASP application Now, I have a some methods of ASP product class, search, insert, update and delete I would like to know when will you make the Connection? Make the connection when init class? Or make the connection inside ...more >>

Could someone please tell me what the asp "contains" operator is? In SQL it is LIKE. something is like something else! Thanks! ...more >>

I need to allow a comment field to be written to a small access database through ASP and then retrieved and displayed through a ASP web page. I can't for the life of me remember how to deal with apostrophes and special characters. I'm thinking commentfld=server.htmlencode("formComments") ...more >>