Rather 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
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 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 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 Relatedhow i can edit and delete records?
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 Relatedwhat 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 RelatedI've taken on a website, which seems to use an '.adb' as it's database source. It connects to this using the microsoft Access driver, as it would an Access database.
I've Googled, and can't seem to find out how to open the .adb file and edit it.
I am trying to retrieve and updata a MS Access record with the following code:
View Replies View RelatedI would like to create the facility for admins on my site to be able to edit certain html pages on there site. Is this possible and if so does anyone know of any good urls discussing this matter ?
View Replies View RelatedI 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.
My goal is to have my checkbox lookup the current status and display it to the screen (checked or not checked) and then have the ability to change its status.
Example: It is currently checked in DB, I want to un-check it and update database to un-checked. Here is my code. It is doing the look up fine, when I make the change it all seems okay, but doesnt change the database. Code:
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 RelatedIs there any way to edit a PSD file trough ASP ?For example if I make a templimate with photoshop with a textfield then i want to change the textfields value trough the script and then render the new file as an image.Ive seen alot of components that can render PSD files but none that can edit them.Is it possible ?
View Replies View RelatedI have an html edit button and all I want right now is when a checkbox is checked and the user selects the edit button, the page will redirect to an edit.asp page where the user will input information.
I can't figure out why this code is not working. I'm sure it's probably something simple.
<input id="Editbtn" type="button" value="Edit" language="javascript" onclick="return Button1_onclick()" />
<% If Request.Form("ck")<> "" then
response.Redirect edit.asp
end if
%>
I have a dynamic html table. I want to write the code to edit rows in the table. Right now I can't change anything in the table. How do I make the rows so they can be selected and changed.
View Replies View RelatedI 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.
I am wondering 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.
Now I wanted to do some office automation in my web page. Let say I have the microsoft word named report.doc. In this report.doc , I wanted to put the number in header or footer from the parameter in my asp file. How do I do that?
View Replies View RelatedI am trying to edit data from this form in ASp/HTML but because both the field that I am editing is in the text box that has the same name, it is combining the data from both the field and updating in the table. Is there a way I can change the name of the text box progammically?
View Replies View RelatedI'm keen to learn how to do some simple asp script so that I can access my customer database over the internet from various locations.
I want to know how to write the appropriate script into an html form (I use MS Frontpage as an editor) so that when I log in to my site I will be able to see and edit this database directly on the net without having to download the file for editing, then upload it again until next time.I understand that I will have to save my database as a MS Access file (*.mdb) because this format will work better with asp commands.
If you know of an online Dummies Guide to ASP please let me have the link so I can learn some of the basics without having to bore you with working through all that.
I have tried to edit table in html page with asp, but I havent succeeded in it. The pupose was to check with "if" function that does the variable fit into certain number array. For example:
if data1 < 100 then
"change the colour in a certain cell in a HTML table
end if
Is it possible to change with asp the properties in a html table? The purpose was to change the colour in a certain cell if the condition in the if function does not match. And if it is possible.. how I can point to a certain cell and change the colour in it.
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.
I have a page that has includes in it. I need to automatcally add an include to this page, but the include that is included depends on the request.form item so, for example i need to update the page colours.asp and if request.form=1 i need to add to it include=newcolours.asp and if request.form=2 i need to add include=oldcolours.asp
ok this is a simple example but i just want to know how to add code to other pages.
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