The problem (and I've tried to modify the code unsuccessfully) is that
I don't want to "Add a New Record" and I most definitely do not want to
"Delete"....I only need to edit....
I need to have a Search page for Customer Service Reps to search for a
customer by last name, and then edit the customer's record with an
updated status on fixing the customer's problem... Code:
I need to develop a web application using asp, which ideally should do the following
1. Generate a word document combining templates with dynamic data from a sql server. (I was thinking about generating xml docs)
2. Let the user see and modify the generated document on-line, from he browser
3. Save the (possibly) modified document to a table in SQL server.
I already know how to download/upload files, and save them into a DB.
The problem is I would like to automatize the whole thing, and not forcing the user to download the file, open, edit, save and finally upload.
Any idea would be appreciated.
PS: Even more ideal would be to come up with a general solution, in order to be able to open any kind of doc with the right app, and then automatically post it to my app. Or maybe someway to allow to edit it right from the server.
how to creat a page that will allow the user to edit and save a text file on the server.
View Replies View Relatedhow to get past this error message?
ADODB.Recordset error '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/Legal/Tools/Phonebook/SavedataYA.asp, line 60
here is the code from SavedataYA with line 60 highlighted. Code:
i have a very simple online store/shop which is still in development, once payment has been accepted the contents of the shopping cart is written to a database what i want to do is also write this info to a text or html file so i can then send it via email using cdosys i have all ready tried to do this using .creatmhtmlbody() but this will not work due to the way i am using session variables.
the main program i am using is Dreamweaver, i am using access as the database this is all running/testing on a windows server 2003 the code is in JScript (before you all start shouting at me i know i should have used VB script and SQL but too late for me now) but either way i am just asking for roughly how to do this, even if it can be done.
I've got a simple recordset which writes a html table. I've put the following code at the top of my asp page:Code:
response.ContentType = "application/vnd.ms-excel"
response.AddHeader "content-disposition", "inline; filename=filename.xls"
...then done a response.write to write the table.
This should output an Excel file, but it doesn't? It just writes the table to my browser as a standard HTML page. Can anyone see how to solve this problem?
After creating a recordset from an Access table, can I issue a select (SQL) on that recordset? For example: Select * from rsAccessRecordset
View Replies View RelatedI have a query that retrieves only one record for the recordset. I'd like to take a field value and compare it to a number in an If...ElseIf...Else statement.
Here is my vbscript code:
Code:
Dim X
X = rs("Ticket_NO")
If X = 0 Then
Do something
ElseIf 0 < X < 10
Do something different
Else
Do this
End If
The problem I am having is regardless of the value of x, the first condition is being executed. I believe my problem is simply I am not initializing X with the actual value of the recordset but I'm not sure how to fix this.
If I already have a recordset how do I further query the recordset with SQL with aggregate functions? Example say I want to find the average age in an existing recordset (this recordset has many uses so it was created as such) Code:
View Replies View RelatedI 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 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 RelatedLast week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
I'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 Related