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 Replieshow i can edit and delete records?
View Replies View RelatedI 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 Relatedi 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.
I've a strange problem with Windows Vista, running an ASP page on local
machine (http://localhost/test.asp), the page does not give me any error but
the asp code is not executed (simple code : <% response.write("hello") %),
it show me a blank page, I think I've put all the setttings correctly, but
maybe I must do something obvious to fix that.
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.
I have a members page on my site and want to give the members a way to edit there own pages (either just text or images as well) so they can log into there own members page and then edit text boxes to complete the required info.
May be if you see a page you will understand what I want to do.
Members Page
I want to let the members edit the orange text and the small bit of white text on the right.
I'm trying to setup something that adds/edits records to an access db using vbscript.
I've got an html form with text, select and textarea inputs.
These values get passed to an asp page that UPDATES the record (not INSERT because it's actually appending to an existing record). Because this page is also an EDIT page, I SELECT all the values so as to:
1) display the current value for editing
2) make sure if they're not edited the value is not null when submitted
My questions:
It's no problem populating the values of form "text" inputs, but how do I do the same for
a) the "select" inputs (Make the proper value SELECTED)? and
b) the textarea input?
ie. The user goes to the page for the first time and there aren't any values yet. They use the various form inputs to add values. When they come back to edit the same record I need to display current values of all form fields properly. Code:
I have 2 webs under my default web running win2003
1. A front-page intranet
2. A asp (not .net) web is fine
Both allow anonomous access. My front page web always gets a BLANK Request.ServerVariables("Logon_User"). The asp web gets the logon_user OK. Both webs have a global.asa that has Code:
How to update, add, delete and save any data that has been called to a page. instance, second.page. The update must be done in second.asp too...
View Replies View RelatedI am trying to debug a problem with some ASP pages when accessed via IIS on
Windows 2003 Server SP1.
In summary, the pages are structured as follows:
Root page
Page loaded via IMG SRC
Root Page extract Code:
I have index.asp (Form) & process.asp (submit data from index.asp to Access Database), the Form is running Perfectly.
But, How can I create a login name and page for the applicants to edit the information they submitted?
Let say I have Email (username), Password (password) & lastname on index.asp, then I really have no clue!
I created a feedback form for my website that has only 2 required fields. When you submit the form it calls my asp page which puts the information in a database and then sends me n email with the information that was entered into the form. The problem is that the form only has two required fileds, and if the remaining non required fields are left empty when the asp page is called it does write to the data base, but does not send me any email. However if I go back in and put somethng in every field in the form then when I submit the form and my asp page is called it writes to the data base and sends me an email with the all the information I entered in the feedback form. Is there a way to tell my asp page that it is ok to send the email even if the non required fields are left empty? I really do not want to have to go back through the form and put default values in for each area of the form? Also is there a way to have an error displayed if the email is not sent? My asp code is below....
View Replies View RelatedI have a hudge problem with a DELETE sql statement in my asp page. The delete statement is supposed to delete the user which I have selected to delete. Here is the info on the database tables etc. Code:
View Replies View RelatedHow do you delete a page from the browser history when a user has logged out, it worries me that when a user of mine signs out all you have to do is hit back on the browser and you can see what the user was doing.
I've seen this done befor on the likes of banking websites.
Is it a javascript?
I know the response.expires but that won't delete it from the history.
At the load of an ASP page I would like to delete all records in my MDB that have the value of 'gmp@gmail.com' in the 'email' field. How would I do this using VB? Here is the code I have: Code:
View Replies View RelatedI need to read a SQL Server table into a Web Page and within the Web
Page to permit my users to make changes to the records, delete or add
new records and then save the entire contents back to the SQL Server
table back.
The functionality I am looking is almost the same as In the SQL
Enterprise Manager whereby I can choose a table open the table and
then return all rows and I can maintain the same and save it back to
the SQL Server table. I want almost a similar web interface to such a
functionality.
Even if not a generic functionality as the SQL Enterprise Manager
table maintenance appreciate if somebody can share the code with a
sample how I can do it in ASP pages + T-SQL if need be.
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 .
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>
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")%>"
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.
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?
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:
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
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??
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?
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 RelatedI 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 RelatedRather than deleting I'd much prefer jsut to change a row. What is the rs.adnew as edit (as with VB6) does not seem to work. Code:
adoCon.Execute("DELETE * FROM TableNum")
'
With rs
rs.AddNew
rs.Fields("NextClientID") = vClientID + 1
rs.Update
End With
what is the easiest way to edit records on asp.net page? I have an Access database on a remote server and I want to be able to search through, add, delete and edit the records. Is the easiest way to do this by creating a Data Access Page in Access?- if so is it possible to create ASP pages based on the forms in the database?
I've read through some material on ASP and DataControl but it seems very complicated- does anyone know if there are any good examples of ASP code that lists items in a table and allows the user to edit and delete them?
I am trying to edit text entered in a textbox. I have previously used a function where you can specify certain characters to be removed from a text string but I can't remember what it is.
View Replies View RelatedWhat I need to know is how to click on a button that is labeled NEW, as in new record, and have the current form open to data input. That is a blank record. After the user then inputs the data to all the fields on the screen and hits the SAVE button the record will then be placed into the database table.
View Replies View RelatedI am trying to use AUTH_USER from request.servervariables but the field is
blank. I am using Windoze server 2003 with IIS5. I know there is a fix
because I did it a long time ago with our old NT server running IIS4 but I
cant remember how I got it to work. We are all authenticated users on our
Domain so this is available, I am able to get IP info and such. I seem to
remember some kind of ASP code that did the fix by altering the way the web
server displays info.