i am getting a prob. in database id is a autonumber .i want to update value after retriving the va,lue from database .that is going on i mean retriving valuue from database but not update. Code:
View Repliesi need to update an SQL Table when user select or unselect a checkbox control.
View Replies View RelatedI'm using a database to store the products in a basket.
It's this scenario:
A visitor already has some products in his basket and wants add some new ones.
Now, first I want to check if the selected products aren't already in the database.
1. if they are -> update the product when the amount number is changed
2. if the product is not in the database then insert it.
I'm stuck at the point that I can't retrieve if the database is updated, so I can either stop the query or insert the new product.
Java has a statement like getUpdateCount(), but ASP/VBSCRIPT??
I want the fastest solution, i dont want to retrieve the data twice and compare them to check if it changed..
is there any one know how to make function to update db field and to be called on checking a check books.
View Replies View RelatedI had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
how asp script when I want to check two different tables in database if data in table in different
example:
in table sent_sms where status sent but no receive_sms, i want insert status in status "Not OK"
I have setup a database for user to upload product image and it name and desciption. Since there is no product upload by user, it will display this error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/i-Metz/iMetzAdminADs.asp, line 295
Therefore i wrote this script to counter the error:
there is any way i can check if the database Exists. I mean from the code side. I dont want it to throw me any error thats the reason.
View Replies View RelatedI have to check wether the database connection is opened or not.I am using ASP with sql server database.
I can open connection and do all the transaction with the database,when multiple users are connected to that same sql server instance,i got an error like sql server not exist or access denide.So i want to check my status of the connection.
Now i got problem in my ASP page using VBScript that is implemented for IP Phone Service.I am trying to do directory service in IP Phone.So user key in the first name or last name.
According to user input, it will go n look for the name in MySQL database.If the name is not found,it will return the error.My VBscript programming is bad.I cant check it out how i check the return for Record set from database. Code:
How can i check if a vlaue exists ? Sample to get the idea: Code:
set con=server.createobject("adodb.connection")
con.open "Menu1"
sTempquery ="Select * FROM Voorkeur Where gebruikersnaam = '"& Request.Servervariables("LOGON_USER") &"'"
Set autor=Server.CreateObject("adodb.recordset")
autor.Open STempquery, Con
The idea is that if the "LOGON_USER" does not exist in the Dbase he must execute code. How can i do that?
I have a directory website which is having more than 20000 company details. Anyone can search the directory for the company. Everything works fine, but if someone misspells the word it returns 0 company found.
So i want to add a spell checker to the word user types in the textbox to the companies in the Access database. I need something similar to the google search.
i'm going to ask the way to use database to check user permission level in asp..
View Replies View RelatedI have a simple database. I can get the data from the database and display them on a web page without any probs.
My problem comes when im trying to insert new records into it. When i submit the data i get an Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot Update.
Database or Object is read-only.
I've tried looking at the properties of the db but i can't figure out why it is read-only.
i have one .htm page passing the info onto an ASP page and then showing the results on another page. The code for my two pages are (if it helps): Code:
how its mossible to someone update may database, for now we have a database
and time to time, someone update a record, changing the information.
what can i do to avoid this?
can any one provide me with script where i can add to my database table using csv file and web form.
View Replies View RelatedI have an employee directory asp application. Everything works the way its designed but I want to make some changes. When someone does a search it of course comes up with a list based on their search.From there they click on the persons name and it opens the edit asp page which they do and update.
What I'm hoping to accomplish is to some how save the search criteria and one they update the page it will return to the previous page and redo the search so they don't have to redo the search to do another update.
I have a table called WGDeliveryNotes which has a field in called TrackFlag1.I would like to update the TrackFlag1 field to contain a value of 1 when the page is loaded..... I currently have this set within the ASP tags at the top of the page, thinking that this would update the field as the page loads however this doesn't seem to be happening.
View Replies View RelatedOn a database how can i update has i tried RS update and it does not work.
View Replies View Relatedi have 2 databae files in MS ACCESS format and i have already connected them from 1 ASP file and now i need 2 update the econt 1 from the firt
in another words :
i have 2 access databases
the first which is called 1st.mdb i allowed my visitors 2 rigseter and edit their membership in it across my website.
the second which is called 2nd.mdb have the same structure of the first(tables and fields) but in another url. hat is the best way 2 update the 2nd.mdb from 1st.mdb of course i donot wanna caopy and replace i need some programmatical method.
I am having trouble trying to detect if no records are retrieved by the search. There doesn't seem to be a problem with the connection to the database or the SQL query. I think the problem is somewhere in my If statement. Code:
View Replies View RelatedI have found out that when using dreamweaver MX 2004 to update databases, and specialy for amatures such as myself, it is easier to update one field at the time. Other wise you will get an error message on the line stringname.execute (usually line 111).
The problem is solved by updating only one field at the time. It might time a little longer but saves headaches when you don't know exactly how to work with the code.
I need help with fixing my code below. It doesn;t work correctly. It works fine when there are 4 featured records. But I want to be able to change one to not be featured (equal to 0). This is not possible with my current code. It shows the same message about me not being able to have more than 4 featured records. Can someone please help me with this?
Code: ....
I have a problem when i try to update a database!!! I am requesting a firstname text field from a form and an id number to find the row in the database.
But when i execute the following code to update the firstname i get the error:
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. Code:
The code that i have presenting allows me to view the database entries and to choose what i want to edit and then to do an update. Its not allowing me to save my new changes back to the database. Code:
View Replies View RelatedWhat i want to do is, I have an excel speadsheet that scans items and then fills in other fields (if that makes sense), what i want to know is I want to insert that info from the spreadsheet into a database used on a web site, line by line would be fine, i can do the insert bits fine, and the loops but, first is it possible and how do i link to the spreadsheet and get the info?
View Replies View RelatedI'm having a spot of trouble trying to update fields in a access database using asp. I can delete and add fields thru the asp page but when i attempt to modify the fields i get a page not found error message. Code:
View Replies View Relatedhow do you create a link that will add 1 or subtract 1 from a number in the database?would it have to call a function that would do it or would i have to use buttons that did it?
View Replies View RelatedWe have a fairly large datbase containing thousands of part numbers, product names and pricing. We used to update new pricing changes individually by hand. However, now that our database has grown substantially, I'm wondering what the best method would be to keep the pricing current on our database?
We can obtain new price lists in excel format, however, the part numbers the mfgs use may not necessarily coincide with the part numbers we have. Should I just write some SQL script? Look into using XML? What would be the most efficient way to tackle this problem?
I want my users to be able to update their data(they store hours spend in different courses per week) stored in the Access database. So far they are able to update only one record(i.e. for only one week).....all they do is search for their records using their User_Id and click the WeekNo they want to update.
when there are (e.g. WeekNo1, WeekNo2.....) the user can only update data for WeekNo1 and when they click WeekNo2 the link takes them to WeekNo1 data.Please guys I need help cos I've been trying so hard to figure out what might be the problem and failed.
Basically I'm looking to update the contents of an access databse from an input in XML format, is is possible?
View Replies View RelatedI'm trying to update a database and some of the answers are check boxes. If I don't change the value of the check box the database is not updated. That is, if I had the checkbox checked when I first submitted the survey it would show ON in the database, when I try to update if I leave the checkbox blank, it will not clear the result in the database.
View Replies View RelatedI got problem to insert or update new record into the Access database. For your information, I run my ASP program on Win XP Professional SP1(service pack 1)with IIS 5.1 and ASP.NET v1.1. I''m using Access database version 2002.
I can read the database file, but can''t add new record to it although I was set the folder which database files reside to permissioan access to be write in IIS. My ASP program(program to add new record with ASP) work fine with other pc but got an errors with my pc. Code: