I am relatively new to ASP but am fairly familiar with PHP and ASP.NET and JavaScript.
My problem is this:
I have a drop down box which is populated from the database (Access), it sets the value to the ID of a hospital ward, and the text to the name of the ward.
I then use the ID to look up an email address for the manager of the ward from another table in the database. My un-optimised code is as follows: Code:
iam having problem ,relating to update a column in Access file in ASP 'Change' is column name , rs is recordset object ,and i want to update the values in 'Change' column by return values from a function .Iam using vb script in asp
rs ("Change").value = function() this is generating error, and won't work
I have a simple table "Line" with Columns Key, OrderNumb, Panels, Gates, Posts, Color, Memo, Comp. A user enters the information into the powder.asp page. It is then added to the database. The Comp Column is populated NO by a hidden input type. The data is then displayed on a page in a table and the last column has a submit button.
When the user Presses that button I would like it to update that record in the database to change Comp to YES. Some code snipits are below. The first is where the data is presented and where the submit button is. It then will go to the next snippet that hypotheticly will change just the Comp on that record to YES. I am not sure if I am not executing the SQL correctly or something but it will not change that order number row comp to 'yes'. Code:
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx 4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
I am receiving the following error when attempting to insert a new record into my database
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
The code below works 1st time through, but on the 2nd invocation (with TOTALLY different data), I get the above error message.
My database is an Access 2003 database, and everything else works fine !
Also, if I'm really trying to write a duplicate record, why doesn't it fall into my duplicate trap? Code:
A page I'm working on contains a registration form which is supposed to a) update an Access database using ASP and b) email the contents of the submitted form to the camp administrator.
This is my first experience with ASP, and with any kind of database interfacing language, for that matter. Currently I'm struggling with the record insertion. I'll worry about email afterwards.
I'm using Dreamweaver 8, which is generating all the code for me. I have a testing server set up on my local machine (in my working directory, in fact). I've told DW to connect to the databse (located in %siteroot%/database) through the testing server using a DSN (same DSN as on the web server). Code:
i have a access DB, and a asp page to add the records to the database, i work on visual interdev, i get error when i run the code as:
ADODB.Recordset (0x800A0CB3) object.provider is not compatible of performing requested operation. /project/addprocess.asp, line 37 'points to rs.addnew line
I have a very simple Access database with these fields:
ID | Team | Score
I want a user to enter the new score of the team into a form and then it's updated. All pretty straighforward - except I'm getting an error at the bottom of this page:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
I'm trying to create a piece of code that randomly selects a record from a database (providing the record has not already been chosen for any of the previous 4 sections). Here is my code:
I have a booking form, called classroomform. On this form the user requests a classroom number, location, date, start/end time and number of students.
As it stands, the data is submitted via a submit button and an insert query created using Dreamweaver.
I already have various validation on the form, such as javascript which error checks for invalid times etc and asp validation which checks for correct dates etc.
However, the final touch that I'm looking to do is to add some code to the form which checks for duplicate entries that are in the database. I basically want an error check which doesn't allow the user to enter a duplicate record that is based on classroom number, location, date, start/end time.
Code: SELECT * From Product WHERE CatId = 14 AND CatSubId = 13 AND CatSubSubId = 9 Now if i change this query to either of the below it reults in an error as nothing is puled from the database. Now if i run this query directly in Access, these 2 execute fine:
Code: SELECT Size From Product WHERE CatId = 14 AND CatSubId = 13 AND CatSubSubId = 9 Or to
Code: SELECT Distinct Size From Product WHERE CatId = 14 AND CatSubId = 13 AND CatSubSubId = 9 Size is a number (long integer) field.
Err.Number is -2147467259 Err.Description is blank. no description Err.HelpContext is 5003251
I have increased the script time out and command time out time and still the same thing.
I am using a Replace function to replace single quotes with double when submitting a text field in the database i.e. Replace (q, "'", "' ' ") which works fine. When I retrieve the field from the database which has apostrophe I am getting 'Object expected' error message. Is there a way to fix this?
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /changeprofile.asp, line 44
Last night, 6 pm dedicated windows 2000 server rebooted and ever since I get an error with all my sites on that box that says:
ASP Error occurred 8/16/2005 10:39:16 AM in Microsoft JET Database Engine
Error number: -2147467259 (0x80004005) File: /demo3/funcs.asp, line 100 Unspecified error
The funcs.asp is the file that opens the access database to read from. I have tried all sorts of things to fix this and I need your help. I searched for this error but can't find any more than people having the problem.
Im recieving the following error, which I cant really see what im supposed to do.
Im making a simple form page to insert a record into my access database. I dont get why there is a problem cause i used a stock Dreamweaver object (dialog) to create the code...
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
I've written an asp page to transfer values from a form into an Access .mdb file, and I'm getting this error:
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xe68 Thread 0x798 DBC 0x15c1024 Jet'.
I'm running Win XP with pretty much all critical and recommended updates.
I'm trying to learn from a book "Sams Teach Yourself E-Commerce Programming with ASP in 21 Days". I'm doing very poorly BTW.
Anyway, I am trying to create a login script so I can password protect a page but when I test the page in IIS, I get the following error:
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'. /TEST/checkpassword.asp, line 12
I have a problem which is doing my head in. Basically I have 2 pages which use the same connection to open the database and an SQL statement to select records from 2 different tables. The code for the first page is as follows: Code:
I have an ASP page (deleteselect.asp) that is set up to query an Access database, list the records in the table, and then create a link for each record that calls on another asp page (deletepublication.asp) and deletes the record from the database using the primary key (ID) field.
I got this exact same code to work for another page to delete users from the database. I copied the code exactly to create the delete publication page but then I started getting the error (the delete user page still works, just not the deletepublication page). Basically I have 2 tables in the dB, one called "users" and one called "publications", so I just changed the code accordingly and started getting the error.
This sounds quite complicated, but basically I can't figure out why one works, and the exact same code for another page doesn't work and generates this error: Code:
I m getting the following error when executing the below given code:
==== Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. =====
Error: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query.
I have xp professional with iis6.the folder is under wwwroot with asp file and mdb file. Is there something with permission and LDB?I have try everything with permission.
I am suffering with an asp error, I am not sure what is causing the error, I have tried a number of diferent possibilities and still no solution.The error is as follows:
HTTP: 500.100 internal error Microsoft JET Database Engine (0x80004005) system resources have been exceeded.
I thought a possibility could be that too many db connections were open, but I have been through all the pages to verify this is not the case.