Problems When Adding,deleting,editing Data In The Database
actually, I have a problem while i want to add, delete, or edit a record to a database through a asp page, I can read well but when i want to submit changes using rds object , the data does not change on the source database,
I tried hard to get a solution but i think that the actual problem is only on one figure which is the server value of the data control when i use my own iis server, I do not know this value and microsoft is saying use an empty value but it does not work either.
View Replies
ADVERTISEMENT
I am having trouble with the edit, update and deleting of records. I got the codes from a user in a different forum. Now I can't find ant help from that forum. Here is a link to a zip file with the pages and database in it.
bkdphoto.com/problem.zip
Simply open the listings.asp page then click on one of the Edit or Delete labels. I am getting the following message when I do:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/Tests/New Folder2/delete.asp, line 7
View Replies
View Related
Basically i have a form on a HTML page which someone fills out with a few IDs, then i have a .asp file which is meant to add the info to a database.
However it just wont work, the field names in the database are correct. - i hope the if statement is correct too. Code:
View Replies
View Related
I may have made a typo somewhere. I am trying to delete collections from RelProdCollection Table that has a certain record with Product ID number of __ and then readd them based on the user's choices on the edit form. Code:
View Replies
View Related
Can I do the following things in the global.asa file?
When sessions starts:
Add a record into my database
When session ends:
delete it where rs("sessionid") = Session.SessionID...
?
I'm pretty sure I can, but...I've heard not ALL things can be done in global.asa...
Do I create an object, and a connection? How would I do it? Since I want a database in MY database, not in memory like I've seen...
View Replies
View Related
I got an asp page that supposed to add,delete records from access 2000 mdb file. It loads all the records but when i try to delete or update i get these errrors. Code:
View Replies
View Related
What is the best Method, for deleting or editing existing XML Data? I have a form that submits to XML via ASP using VBScript. I now need to pull data into another ASP page which allows for either Editing or Deleting Individual fields.
I know I can use XSL but is there any better methods as the original form imports data into the Drop Down lists?
View Replies
View Related
I can edit information in tables no problem with insert delete etc etc. My question: is it possible to edit the tables themselves ie make new fields, tables etc! If so can someone provide a simple example or point me to a tutorial im sure I will pick it up pretty quick but I have no idea where to start!
View Replies
View Related
I have a roster of people from a db showing up in a frame containing ans asp page. In order for the client to edit a record on the roster, I have an edit page opening up in a javascript pop-up.
I know how to edit the db but what I don't know is how to 'bind' the text boxes in the pop up to the correct record in the db (based on which record they selected to edit). Here is how it looks:
John Smith 12 123 Main Street Your Town State edit this
the 'edit this' is a link that opens the pop-up. How can I get the correct record to show up in the pop up?
View Replies
View Related
I'm new to programming databases with MS Access. I'd like to know how I get user input for a database, in a form, read from it and do "if" statements. Does anyone know how to do this? I've tried ASP approaches (with the FSO function and .txt files) but none are as effiecient and organized as databases appear to be.
View Replies
View Related
I have two tables: Table-A and Table-B. I extract info into a page from Table-A, Row-1. This displayes nicely into a page. I would then like this info to be inputted into Table-B Row-4 remembering that it came from Row-1.
[so far no problems]
I then want at a later stage, Row-4 to update Table-A, Row-1 with it's contents AND for Table-B, Row-4 to change a value in itself. Hope that makes sense, if so how would I go about it? Otherwise I can really go into detail.
View Replies
View Related
This is the code that I am using to delete from the database, but it doesnt seem to work any ideas people?
<%
SQL = "DELETE FROM jobs WHERE date = #" & personaldeletejobs & "#"
set Rs = Conn.Execute(SQL)
%>
the "personaldeletejobs" contains a date element.
View Replies
View Related
I am having considerable difficulty figuring out how to delete more than one entry in my online database at a time. I thought I had it
Sub Delete()
SET Conn = SERVER.CREATEOBJECT("ADODB.Connection")
Conn.OPEN "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/db/database.mdb")
sqlWhere = ""
aSelected = request.form("Select")
sqlWhere = "ProspectId IN ('" & aSelected & "')"
sql = "Delete * from tblProspect where " & sqlWhere
Conn.Execute sql
Conn.Close
Set Conn = Nothing
RESPONSE.REDIRECT("prospects.asp")
End Sub
View Replies
View Related
I have an online store with a database (windows 2003 small business server) and i want to delete a product or a dealer from my database via asp with a button or a link. how can i do this?
View Replies
View Related
i have a registration form in my website. the requests are going to the database (windows 2003 small business server). I have an other page who the entries are displayied. how i can delete the each entry separately with a button?
View Replies
View Related
If I have an access database with the fields Title, Artist, Description, DiscNo, TrackNo, Price and ID(Autonumber)
What would be a single-page script to remove only records where DiscNo= string entered into a text field in a form?
Example: I enter into the text field "SC8200" which relates to 18 records in the database. I click submit and all 18 records are deleted. Code:
View Replies
View Related
I get this message when trying to delete:
The column prefix 'username' does not match with a table name or alias name used in the query. I am not sure what this error is. I checked all over the place for the problem.
View Replies
View Related
I have a database that is for E-Cards. I want it to delete all of the entries that are more than a month old. I have the date stored in a field called "dags" (without the quotes). Please help me on this!
*******************************************
Also, I would also like to have an option for "Send the E-Card Later" and then have the options possible dates. What script(s) could I use to do the actual sending on a later date?
********************************************
View Replies
View Related
I get an error message when deleting an table from a Access database. The code is as follows and the error message is after it. Code:
View Replies
View Related
I want to fix this problem, i dont no how. Bassicly there is blank data appearing in my database, for no apparant reason! Code:
View Replies
View Related
I have discovered that in my website,when a user tries to add data to the Access DB via a form,there is an error if the data contains an apostrophe,For e.g.If the user were to add the user Martin O'Neill to the DB,this would cause an error OR if the user were to add a book called User's Guide,this would also cause an error.
Does anyone know of a generic way to resolve this problem,preferably within the SQL statements which add the data to the DB?
View Replies
View Related
Is it better to use the Recordset methods or make an SQL query string and use conn.Execute() if I want to add to a table? I figure the first might be safer, but it seems weird to someone who learnt on PHP... I'm using SQL Server if that matters.
View Replies
View Related
I have an drop down box.I want a button next to it which says ADD.Once i click that button I get text box where i type my data and after submiting it,it gets added to the drop down box on the page and now i can select that data from the drop down box and proceed ahead with my order.
View Replies
View Related
i have 2 tables;
table01:
fields are
field01,field02,field03,field04,field05
and another table
table02:
fields are
field01,field02
when someone submits the form, i want to add the infos supplied by the user to be added to these 2 tables.
field01 & field02 shall be added to tables 1 & 2;
&
field03,field04 & field05 to table01 only
i tried using this code:
myquery = "INSERT INTO table01 (field01,field02,field03,field04,field05) VALUES ('" & f1 & "','" & f2 & "','" & f3 & "','" & f4 & "','" & f5 & "')"
myquery2 = "INSERT INTO table02 (field01,field02) VALUES ('" & f1 & "','" & f2 & "')"
adocon.execute myquery,myquery2
but this one only adds to the first table.
can someone tell me how to fix the problem?
View Replies
View Related
I have a data base that I wish to add a record to. I have many fields to ender, but I was testing my code with just one and it works just fine : Code:
View Replies
View Related
I am trying to test a form at home which is for registration purposes. I dont have a server connection yet. Im wondering if it is possible to check whether the form is working offline or whether my code just isnt working! ?
I should also say that my html files, asp files and database are in the same folder. Code:
View Replies
View Related
Right now I think I've got the idea on how to work on ASP pages after such a hectic start, then I 've got a small problem . i have contructed my form but i can't seem to add to the dbase, i can fill the info but i see nothing on my dbase.
View Replies
View Related
I have been working on this form for a couple of weeks already but I keep running into errors after errors. Can someone try to test it on their computer and see if it works? My guess is that our server's setting is causing all these problems. All the files are uploaded.
View Replies
View Related
I am trying to run a script that will add users to a database so they can register with the site. ive got it working so that the users are added however i am trying to prevent people from registering the same username or email address and this is not working.
the script firstly checks that the user has filled out all the fields in the form from the previous page then the script is supposed to check the database for the username and email then adds the user if it is all ok however if the fields have all been filled out it simply adds the users anyway. here is one of the check scripts i am using VBscript and an access database .....
View Replies
View Related
I am trying to add entries in a database together and place the summed value into a text box. Like a total ordered type function for an ecommerce site. I have a field called ArmChairs in my database and based on how many people buy them, I want to know how many I need to have shipped.
I am really struggling with this last bit and would be really appreciative if someone has some code examples.
View Replies
View Related
i cant add a record to my access database! i think the code is right which i used asp script but then only blank record was added! It added a record but then no data in it! Code:
View Replies
View Related
This code has worked in the past on this same page, and for some reason it doesn't want to calculate the numbers anymore. Anyone see anything that is out of whack?
Basically I am taking the input numbers for each field and adding them up on one column, then taking the totals of all of those columns and adding it up to display as an overall total. Code:
View Replies
View Related
I'm trying to add a record to an access database using asp. I create the database, the input form where i put the information, the asp code where i process the information and last the asp code to view the record added but when i press the submit button it show me a Downloading box for a downloaing process.
View Replies
View Related