Can you please help me in asp code. I am display a message when webpage downloading "Please Wait while Schedule Generates" and message should go away when page finished downloading. I appreciate your help. thanks ...more >>

I am in the process of merging approximately 5 databases for development into 1 final database but will for the new merged copy to go live I need to copy over all the data on a live server using a single asp script. In access I can do a copy and paste using structure and data. How can I do...more >>

I am in the process of merging approximately 5 databases for development into 1 final database but will for the new merged copy to go live I need to copy over all the data on a live server using a single asp script. In access I can do a copy and paste using structure and data. How can I do...more >>

I found "Sams Teach Yourself Active Server Pages 3.0 in 21 Days " and wonder if that would be a good book for a beginner. I don't have a programming background and I guress 21 days could turn into weeks or even months. Or is there something better for someone like me? Thanks for any suggestions ...more >>

I use Access database with an ASP frontend. db contains a tabel called 'mytable' containing an unknown number of columns. I want to call the db and find out the names of column 2 och 3 ( out of for example 0, 1 , 2, 3, 4) Or a list or string containing all the names of all the columns (ap...more >>

I need to navigate a recordset like first, prior, next and last commands. How can I do that? I am trying to do like this: rs.cursortype = 2 rs.open sql, connection rs.movefirst rs.find("ID=105") but I got this error "Rowset does not support scrolling backward." in the last line. ...more >>

Using the follow format (or similar) for accessing data from a database and any other required operations. How would I go about an update query? I'm aware it's a case of setting sSQL to "Update [Table] SET" etc but what constants should use and where? myDSN="Provider=Microsoft.Jet.OLEDB.4.0...more >>

I am running 2003 server with abunch of sites, all is well I just dumped some stuff for a new site there and I am getting the good ol' Provider error '80040e4d' Authentication failed. Here's my code... <!-- #include file="db.asp" --> <% MyConn.open MyConnString set rs = MyConn.execu...more >>

Hi, Yesterday I changed my code to add authentication to my Access Databases. Ever since attempting to remove entries from my database are is unsuccessfull. My code-snippets to read/edit the database work like a charm, but it's removing data which gives errors of which I'm not sure how to ge...more >>

Hello, I developed a ASP web application. I created connection to SQL Server 7 by DSN at the begin, however, some experts said that DSN connection was not a good choice. so I changed some of ASP pages to DSNless connection. But the problem happens, I create DSNless connection on every page, no...more >>

Hi I'm a bit out of my depth here but I have successfully managed to extract 2 pieces of information from a MySQL database; sMap & sLocation. These are used on an asp page (below) which is located in a frame and the query is dependent on an id provided from a cgi script! From this page I w...more >>

Hi, I am new to ASP. Is there any editor use to write ASP? SF ...more >>

Hey gang me again. Have a quick ? for ya. Is there a way to update a session? What I mean is this. Let's say I have a site, that uses sessions for login purposes, and lets members gain access based on the session. I have a profile update page, where they can change password, name, email, s...more >>

Hi, which is the best way to handle and keep the (oracle) userid and password in an iis6 and asp intranet environment ? In some articles it is written the the usage of the session object is not recommended. Thanks Holger...more >>

Hi all, Wonder if you can help me with a problem. I've got a database containing 2 tables (one called 'Main' and one called 'View) that are unrelated. When trying to insert values it doesn't like it and produces an Error 438 - Illegal Assignment. Though the table is read/write access and no...more >>

Hi, i want to view an OLE-object field (inside an Access database) in my HTML pages with ASP (or PHP..think it's the same). I don't know how can I do this... I obtain the value of the record trough the recordset recordset.Fields('photo').value but I don't know how can I use this... Sorr...more >>

Not sure if this is the right place to ask.. I have a computer with Windows 98 on which I have set it up as a Personal Web Server and I am running/testing a small Access database. I am working from my XP computer in the same room, connected by network cable. I am confused as to which connect...more >>

Hey gang. I have a question or two here. i know this isn't sql NG, but I can't find one for what i want, and since i am also using asp..thought I could try you guys. i am using access db with asp scripting and NOT using asp.net I need to pull 2 things using a query. distinct(username) and...more >>

Hoi, Het gebruik van een JOIN-statement dmv "Microsoft.Jet.OLEDB.4.0" (asp) naar Access blijft me tot frustrering toe foutmeldingen blijft geven. Met een vrij verwarrende syntax (veel geneste haakjes) was het me gelukt om 2 JOINS uit te voeren, maar een 3e lukte dan helemaal niet meer. Het ...more >>

I have a client site where the code below has been working happily for at least four months. Last week an error appeared related to the following SQL statement. The site is using SQL Server 7. The code is ASP.NET An example of the SQL statement is: INSERT INTO OrderItems (ClientID, Prod...more >>

I can't get past this one. I am trying to import an ntext column from one SQL Server table to another. Set RS = Conn.Execute("SELECT * FROM COLL") do while not RS.EOF Set RSOut = Conn.Execute("SELECT ImageNotes FROM Images WHERE (Inventory='" & RS("Inventory") & "')") if not RSOut...more >>

I am having a some problem with ASP reports. When I try to get the information for specific date ranges from the asp page it gives one day less than end date. For example if I want information from 05/02/2005 to 05/07/2005 the report only show the information from 05/002/2005 to 05/06/2005 one...more >>

Hi, Overview of Problem: I'm experiencing some timeout issues that seem to be caused somewhere between the IIS request to SQL and the response back to IIS. The issue seems to me almost like a memory leak where the request responses get worse with time. A restart of IIS seems to clear up ...more >>

Hi, Is it possible to use Request.QueryString in a frame to retrieve a value from a frameset ? Thanks, Neven ...more >>

Can anyone point me to a method of achieving data stored in MS SQL or Access from an ASP page. I want to keep six months of data available and achieve the rest to a seperate table to maximize performance. Thanks. *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi Guys I need some help with the ASP application . I need to make a Grand total based on dates . I have sub totals for dates and need to do the Grand total by same dates . Here is a little example Date Sub Total Grand Total 4/25/2005 $23 4/25/200...more >>

We know that we can use appendchunk() to add new image data to an image field. The question is how can we delete the data or change the data to new one? Thank you ! Frank ...more >>

Granted, I'm a bit rusty with this stuff but looking at everything else i've done for an example, I see no errors but I'm still getting one. Here is the error I'm getting in IE: Error Type: Microsoft JET Database Engine (0x80040E14) Syntax error in INSERT INTO statement. /nogo.asp, line 19...more >>

I need to use some database fields for calculations but I an not certain about the syntax. For example I want the Onhand value to subtract the Qty Committed to sales. In a seperate cell in a table I want the balance to show up. The fields are (1)<%=(rs_stock.Fields.Item("Qtyonhand").Value)%>...more >>

I want to select one record from some table and then insert or update to another table. The next SQL are depending on the values of SQL_1. Database - mysql For example: For i = 0 To number SQL_1 = SELECT product FROM database WHERE category = 1 my_Conn.Execute SQL_1 SQL_2 = I...more >>

Hi all, I am wanting to implement paging with asp & sql server 2000. In mysql i would simply issue a 'Limit clause such as Limit 10,1'. In sql server i know you use SET ROWCOUNT to specify the number of rows to be returned. My difficulty is how do i get the starting row for my paging. ...more >>

hi, Am not able to connect to oracle 9i database from the asp page. I get page cannot be displayed .Can u plz tell me what are the prior settings neccessary to connect. I have created The DSN also for it. Some times i get orace(tm) client and networking component not found and cannot...more >>

Hello all on this group, I hope you can help. I'm developing an asp page that displays (in a table) paint colors. An older version is at: http://tforward.aspfreeserver.com/modeling/paints/paints.asp A popup layer menu on each color will give the option to find similar colors from that l...more >>

Good Morning I am using IIS 6 on a Windows 2000 Server. I get an error "Too many client tasks" Microsoft KB154869 says:- "This behavior is by design. (This is not an issue with Jet 3.0 as used by Visual Basic 4.0 32-bit.) " I am using:- vbscript.dll version 5.6.0.7426 ...more >>

Dear All Hoping anyone can help, recently moved the site onto a new server, site started throwing this error up, worked fine before, any clues ? Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /admin/homes/uhomes.asp, line 52 Where line 52 is:...more >>

Good Morning Any recommendations on books (or Web Sites/Pages) as a quick lead in to using SQL Server in ASP pages please. I have a big web site to migrate from Access DataBases to SQL Server Thank you Pete (Northolt UK) ...more >>

Hi, I have an asp application running on a dozen of winXP machines configured as kiosks. This application stores its data on a MS access db. I have the need to make some reports extracting data from the db, displaying them on screen and exporting to rtf. I've tried several commercial products, l...more >>

Hi, I just moved a site from a Windows 2000 server running SQL Server 2000 to a Win2003 Server with PostGreSQL 8.0 installed. After transferring the data from one DB to the other, I thought that there may not be much difference as all of my database stuff is fairly straight-forward query...more >>

Hi All Wonder if you could help me with the problem I've caused myself!! I have 2 problems both exactly the same and I can't fathom how to get round them. PROBLEM 1 (I am using an Access 2000 DB): I basically poke the codes of team names into a line-by-line history table so I'm not sto...more >>

Hi All As I'm a 'one man bander', I'm really pushed to grab good projects from the big boys, but I've finally managed to get my foot in the door for a project which could be a good one and I've reached an almighty stumbling block. The company that I'm trying to get in with has an established...more >>

After the form is submitted in ASP environment, I would like to call a dos program, but I don't want the ASP to wait. The dos program will run independently. (For example, a dos copy, I don't want to wait under it finish. I would like to let the use know the job is submited, so the user will...more >>