Add/Edit/Delete Record
i have found various example scripts to add/edit from database, but how can i show all the db records by id on a page, then have a form with a box to choose which record to edit/delete by id, and then when chosen, it shows the info for the record in a form, which then can be just edited and updated?
I want it to be just like as if you had just typed the details into the form itself before you registered.
View Replies
ADVERTISEMENT
how i can edit and delete records?
View Replies
View Related
I have a table which views fields from database to users. I have the edit and delete links in each row. My question is how do I get the id of the row in the url to use in the action page?
View Replies
View Related
I am having difficulty with an edit page with a form to edit/delete records in a database in ASP. User clicks a button that corresponds to the record to be edited/deleted. I have managed to eliminate error messages, but the Edit page comes up blank. I think there might be something wrong in the "rs.Open" statement. Code:
View Replies
View Related
I'm currently thinking of a good way to edit records from using an ASP page.
I got the page to display the table (all records) and next to each record, there's a button to "Edit" and "Delete", so basically the GUI is sort of ready to go.
But for the functionality part, I'm pretty much stuck. Please give me some ideas in how to make this work. Here's what I've got so far:
View Replies
View Related
I have built a set of forms to add delete and edit records on my database for asp pages the add and delete are working fine but the edit form opens and I can change the field but if I try to update the record I get the following error MM_editCmd.
View Replies
View Related
I been working on this code for a long time, code doesn't work and It also doesn't show any error. All I am trying to do is delete record. I click on id number from first page that brings me to this page. Code:
View Replies
View Related
I am trying to delete a chosen record out of my Access database using the ID field as the parameter. I can get the script to output the record so I know it has the record, it just won't delete! Code:
View Replies
View Related
I'm simply trying to check if the categoryid is currently being used by any catalogue/product items.
Ok, I've created a mini site content management system and I'm stuck on this function that will ensure data integrity...
I'm trying to check if the categoryid I'm trying to delete has any related 'catalogue' items (products); and if so display a message 'Sorry, there are items currently listed under this category. Move the items before trying to delete'. Basically disallow the delete function if any catalogue items share the categoryid. That's it! Simple... right???
Code:
View Replies
View Related
I have news type thing on my website that displays news items that are entered using a simple html form. they go to a database (real simple so far)I also have an edit form where it loads up the entries from the database onto html forms and you can edit them and then click submit and it applies the changes to the sql database.
simple as well.one thing I can't figure out is how to add a delete button or a delete checkmark so that I can go and delete the entry out of the Database?
View Replies
View Related
I have a microsoft sql database and some tables. One table of them has some dealer's requests for giving to them a mastercode for viewing some special prices. The dealer's informations appears to an asp page in a table.
i want to put a button or an link (query string) to delete separately each record. (the primary key is "clientID"). How i can do this. Which is the command?
View Replies
View Related
In our database, we have a table which contains numbered items. Here is what I'm talking about: Code:
VBKey ChargeCount
12 1
12 2
12 3
12 4
19 1
19 2
When we need to delete a particular Charge (From the ChargeCount column), how can I get the remaining charges to be renumbered. For example, if I delete VBKey=12 and ChargeCount=2, how can I make ChargeCounts 3 & 4 turn into 2 & 3? I'm a little lost at making a query for it?
View Replies
View Related
I'm trying to delete a record by ID. When the user clicks on the record they want deleted from website form it should delete this one record only. But I'm getting this error. Code:
View Replies
View Related
how do you delete data using asp, let's say i have a data listing page and by every record i want to have a delete button ?
View Replies
View Related
I get this weird error when I try to delete a record...
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Cal_EventID ='.
/calendar.asp, line 1596
Here is this code on line 1596.
Code:
SQL = "SELECT * FROM Cal_Events WHERE Cal_EventID = " & SafeSQL(request.querystring("eventid"))
Set RS=dbc.execute(SQL)
View Replies
View Related
I have written an events diary for a client .. and they wish to have a system of multiple deletes so they simply use a check box to select the items to delete and then hit a button to remove the selected records form the database. as all iget is scripting errors. Is there a simple way to do this?
Someone advised me to use an IN statement to Delete multiple records, but all I get is :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ID In ()'.
I have followed several different tutorials but I get the same outcome! It doesn't seem to like the IN statement.... any ideas anyone ???
View Replies
View Related
im trying to add the delete record behaviour with dreamweaver. iv set up all the text fields and the recordsets but when the behaviour is generated the error "the original recordset in the script was not found". i have the add record server behaviour working, but this is not .
View Replies
View Related
I'm trying to build a web page that will automatically delete records (in Access 2k) after a certain amount of time. I need to delete records that are older than a month of the current date.
I've searched all over the internet trying to find examples of how to do this and the few that I've found don't seem to work for me. Does anyone have an example that works? Either using an sql query or programmatically. I'm using Classic ASP (VBScript).
View Replies
View Related
Im trying to setup a delete record thing and it keeps telling me before using this server behavior please create a record set. However I already have a recordset on that page named rsDelete.
View Replies
View Related
I have a search page ( below is some of the code). I am currently displaying records from my Access database. At the end of each row, I am printing out a delete.gif. On click of this image I would like to Delete the printed record. How do I do this? Can you point me in the right direction? Code:
View Replies
View Related
I just need to know the DateDiff function for what I need to do...
I will store the date of the database record in a variable called 'sDate' what now? (Also, the format is xx/xx/xx 2:4:56 PM/AM)
View Replies
View Related
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
View Replies
View Related
I want to display a recordset in an editable form. The TblID can be a listbox and the content related to the id will be displayed where i can edit them i've tried everything and nothing is workin so if some1 can help me i will be gr8full. (w/ VBscript Only)
PS: If some has a URL or a code to share i will appriciate it . i know it's so much to ask but i really need it and i've reached a dead end .
View Replies
View Related
I need to be able to edit a drop down box is asp. On my web app I
populate a drop down box from a databse. The user can then select an
option that will then be saved to a Database for example
Mr
Mrs
Miss
but if the option is not their e.g Dr, Prof etc then I want them to be
able to enter in the drop down box and then I will save this to the
database.
I know that I will have to have a function to dynamically re-populate
the Drop down box to include this option once the new value has been
entered, so that it will be included in the POST method.
But I can't even edit the text. I have tried
<SELECT>
<OPTION selected contenteditable=true> value="Mr">Mr</OPTION>
</SELECT>
and
<SELECT contenteditable=true>
<OPTION selected> value="Mr">Mr</OPTION>
</SELECT>
View Replies
View Related
I have a form which I would like to allow a customer to edit/update. I need to populate the text boxes with retrieved data and then allow customer to select 'update' button. I can't figure out the syntax to place the retrieved value within an input box.
I have this so far, which obviously doesn't work - double quotes etc. Tried double and single quotes but no value appears.
Also tried placing retrieved value within variable, but didn';t work either.
<input type="text" name="FirstName" value="<%=rsdetails("FirstName")%>"
View Replies
View Related
I m trying to edit forms like "Record Insertion Form" and "Master Detail Page Set",
once i click ok, i don't know how to bring up the dialogues again.
My question is how can i bring the "Record Insertion Form"/"Master Detail Page Set" dialogue up again so i can change some settings after i clicked ok.
View Replies
View Related
I'm currently working on cms gallery. I need a component that can take images +/- 800kb and resize them into tumbnails.
I have used AspJpeg until now, but I think it's a little slow.. Do any of you have any suggestion about what's the best upload component and image component to put together in a app?
View Replies
View Related
I have an edit page that works successfully except for two dates at the bottom.
I'm trying to pull the dates out of the database so that they can be edited, if necessary.
At the moment when you go to the edit page the date fields are blank. This causes problems because if you update the page and leave the date fields blank then a default value of 1/1/1900 will overwrite your existing date - pain in the butt.
Therefore I need the date fields in my edit page to be filled from the existing dates in the database.
View Replies
View Related
I have a DataGrid which has checkbox columns. The data source is a run-time created data set that I store in a session so I can rebind it during postbacks. I don't have a database or xml file, etc.if it's possible to edit a dataset directly? So when I click on a checkbox it will change the value in the dataset and store it back into session?
If this is not possible how can I use arrays or vectors to temporary store my checkbox statuses? I guess it's not possible to have one DataGrid have more than one datasource
View Replies
View Related
I have recently started a new programming job with a new company. One of the tasks they have me working on is editing and maintaining an ASP web application. Two of the problems they need me to fix with this application, involve editing a previously created com+ object.
There is no documentation on this com object, however, that is where the application bombs. I can only find very old versions of the class(.cls) file that was used to compile the com+ dll.
I don't have very much knowledge of com+ objects, is there an easy way that I can edit this com+ object that I am missing?? I have been trying to decompile and unassemble this thing, but it can't be as difficult as all that, can it??
View Replies
View Related
I want to open an excel xls file with asp and edit some cells of it and save it back.
The excel file contains 2 worksheets.How can i do so?
View Replies
View Related
users around the internet need to edit the same spreadsheet. I don't want to code a bunch of pages for each spreadsheet we create. I know that a spreadsheet will open in a browser, but is it possible to save it back to the server, without downloading and re-uploading? What is the shortest path to success on this?
View Replies
View Related
I have HTML documents. Nothing fancy. I want the ability to edit them, via a web interface, without a DB backend. I also want the ability to create HTML pages from a template. but how?
View Replies
View Related