I'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 RepliesI have problem in updating checkbox (true-false) using SQL statement.
View Replies View RelatedI want to use a check box to update a field if it is checked. I have:
<input name="expr_date" type="checkbox" id="expr_date" value="<%=newExprDate%>" />
this doesnt work in either way - the record field stays the same if the box is checked or unchecked.
Is this possible - where am I going wrong?
i've encountered a problem.. which is that when i update the checkbox field, the previous checkbox updates are gone.. how can i go about editing it? Code:
View Replies View RelatedI want to change the existing code of our company e-commerce site so that the pull down menues are now checkboxes (will make life easier for sales to work with).
The pull down menu's must automatically submit, as the pricing changes with each selection.
Is there a way of auto submiting when a checkbox is ticked / unticked? Have tried using the "onChange=" that I nicked from the pull down... Code:
I have a database which contains a field called hide which is a yes/no data type. I have an edit record page which is populated with all the data from the database which can then be changed and updated back to the database. What I am trying to do is set the checkbox based on the value in the database . i.e. if hide = true then set checkbox to true.
View Replies View Relatedwhat Im trying to do is to insert into the database the values of the checked checkboxes of the recordset fields the appear in the table I've written the following code:
View Replies View Relatedi have list of items as a list.Now user can select any item in that list. Now what i do is create checkboxes to enable user to check the item which has to be selected.
1. Checkboxes are dynamic.
2. I create checkboxes with one name assign value = Itemcode value so that when form is submitted i can get the itemcode value as a comma seperated list and which would be easy for me to put it in a database query.
3. the part i have problem is i have to display those checkboxes ticked back to user , ie after form submit i have to make the checkbox which are previously checked, to be in checked state.
request.form("Chkgroup")="1,4,5,6,9,10"
assume this is an arrray i am getting from form element.what is the easiest and efficient method so that i can make those checkbox checked again.
Currently i am using this function to update the database for the values of the checkboxes. Anyidea on how to go about including the values of those not selected.
0= not checked 1=checked
MenuName | Super | IT
Menu1 1 1
Menu2 0 1
Code:
for each chk in Request.Form("opt")
sSQL = "UPDATE GroupAccess SET IT = 1 WHERE MainMenuID = " & chk
Conn.execute(sSQL)
next
The Subscribers on my Web-Site need to Personalize their Settings so as to Only View the Categories(Pertaining to Tendering) of their Interest by Selecting them thru Checking the CheckBoxes, HowEver they may Change the preferences(for Personalization) at any point of time by Re-Selecting few other Categories or Deselecting the Previous Selected Categories. Code:
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.
I have a checkbox the value which goes to a database via a asp page that
builds the sql string.
In the front end asp page, the checkbox code is written as follows:
<i><input type="checkbox" name="chk_Complete" value="<%Response.Write
l_IsChecked%>"<%if cbool(l_IsChecked) then Response.Write " checked"%>>
The code to captures the checkbox value in the asp page that builds the sql
string is follows
l_f_IsChecked = Request.Form("chk_Complete")
With this, when the database is already checked (and the checkbox shows checked) unchecking and saving makes the value of the checkbox value in database unchecked. At this point when the asp front-end page is refreshed it shows the checkbox in unchecked state(should be so). Now if I want to check the checkbox and save in the database, the checkbox value in the database does not get changed to checked.
I am trying to write a basic holiday booking system for the company I work for, it is quite simple in that the user selects the dates they want off work, and they can view if it has been approved or not. It has an admin screen so that the manager can go in and approve the holiday request.
To do this I would like the admin screen to display all the dates in the database that the user has selected off and to have a checkbox next to each that the manager can select to approve it. However I don't know how I would do this, at present all it does is read the info in the database. Code:
I am having problems inserting checkbox data into my database. The string data from the text files in my form have no problems being inserted in the db. Code:
View Replies View Relatedin my web page, i would like to user to see a ticked checkbox should the database = True however, i cannot seems to be getting it. Would anybody be able to help me out? Code:
View Replies View RelatedIs it possible to insert more than 2 checkbox values into 1 field in the SQL database?
I have 5 checkboxes; I would like to insert them all into 1 column in the SQL DB.
If I insert more than 2, it gives an error.
I 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 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 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 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.