im trying to build a custom webBlog interface with asp language and javascript embedded htmleditor. im using htmlTextArea to permit user to edit html code onthe fly (with IE 6+)
the address to the current site is URL you can check out the admin interface by clicking on login and validating with pass***
you can try editing an existing record in the first table (you click on the [...]to open the table) Code:
I'm trying to update my database fields Employee, Status and Location with values from a form. Is this going to work?
Dim strEmployee, strStatus, strLocation
strEmployee= request.form("Employee")
strStatus = Request.Form("Status")
strLocation = Request.Form("Location")
SQLstmt = "UPDATE Table SET "
SQLstmt = SQLstmt & "RS("Employee")= strEmployee"
SQLstmt = SQLstmt & "RS("Status")= strStatus"
SQLstmt = SQLstmt & "RS("Location")= strLocation"
I am creating a form that uses a postcode lookup that opens in another window to confirm an address how would I pass back the address and populate the form?
View Replies View RelatedIs it possible to do an update on a recordset like this?display all the fields in a form and let the user pick which ones to update? What happens if they pick, say, two of the total to update, and leave the rest of the form fields blank? Would that update the chosen records and leave the rest of them blank or null?
View Replies View Relateddocument.forms[0].Update.value='yes';
document.myForm.submit;
in a routine.
I have declared a Hidden field called Update in my form. I have checked before the submit that the value does actually get set, but after Submission the value of Update is empty. I have checked everywhere and this is the only place in the page that this value is set.
Does anybody have any idea why my value is being lost on submit. My form is declared :
<FORM NAME="myForm" action="AgentDetail.asp" method="post">
how to update and retrieve ntext fields in my asp code:
View Replies View RelatedWithout writing a bible on what I'm trying to do I'll see if someone
can answer a quick question.
I have a form that the user writes a value in a test field. I need to
put a hidden value that will take the same number the user inputs and
insert it in a form.
Basically, I need ...
<input name="hdndkqty" type="hidden" id="hdndkqty" value = ??? />
the value of the hidden field to = <input name="num" type="text"
id="num2" />
I have made several Access-based CMSs but now I am using SQL Server. I can read the records but my first attempts at writing are resulting in new records (with new ID) but all the fields are null.
I am posting the data from a form to the same page and an if /then statement catches the flag in the URL and runs the update script below. All the field names are correct. Code:
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
I am looking for an ASP script that let me to serach all database contents with only one textfield in search page. eg: I have a database with five columns for lessons: Mat, physics, geography, history and sport. Each field have numbers 1 thr 5. I want to search only those students have number eg:3. with entering the number in textfield in serach page. I have no problem in result page.
View Replies View RelatedIs their a way to check with asp-code if a database field is relational with another field (from another table)?
For example:
If fieldname = relational Then...
End If
I'm trying to set up a quick if/then/else statement for when the database field returns no results. I'm not getting an error but when the field is EMPTY it still executes the ELSE statement.
<%
If rsOffice("FloorPlan") = Empty Then
Response.Write ("Not Available")
Else
Response.Write ("<a href=" _
& rsOffice("FloorPlan") _
& ">View</a>")
End If
%>
At the moment in time I have a product database being displayed. I could do with including another column to the database which allows me to enter a specific quantity for that product line. All the quantitys fields need to be calculated to their specific product cost value.
Finally all the sub totals need to be calculated together to give a grand total, which will be displayed on another page.
how to compare one Database field against another which both have a date and time in them (DateTime format) using VB in WebMatrix. or just comparing Database fields of DateTime aginst each other in VB.
View Replies View Relatedi have a form with fields that contain data from a db. the fields can then be edited, and on the click of the "submit" button, the updated information is returned to the database, replacing the old. a bonus would be arrow buttons allowing navigation from one record to the next, with the information populating the form each time. i'm having a hard time with this.
View Replies View RelatedI'm trying to retrieve information from a field in a database, which contains data, some of which are the same. ex:
let's say the table is called "Person_info" and there are 5 rows of info with a different person's info.
let's say i want to display the info in the fields called "City" but there are duplicates ex:
Toronto
Vancouver
Toronto
New York
Atlanta
I'd like it to display all the cities in there on a web page, but, I don't want it to display the same city twice:
so it'll display this:
Toronto
Vancouver
New York
Atlanta
I just can't get it to work? it keeps displaying duplicates.
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:
How can I specify formatting restrictions for special fields like Postal Code
(format X1X 2C2) or date input field MM/DD/YYYY? I have Acces DB with these specs, but when I used FP2002 Database Interface Wizard, it ignores these. Also I am unable to "edit" any of the records utilizing pages generated by this wizard.
There is an error that it will not accept empty fields. I have no problem adding data (even if some fields are empty) or deleting records.
I am using a repeated field to bring in to my page repeated records, and I have been able to retrieve values that are entered into text boxes that are associated with these repeated fields. I would like to post these values into a database, but I'm not sure how to set up my table as I know that each employee's values as well as number of fields will be different.
I thought about setting up two tables. One that houses the dynamic question and the other to house the answers, but I'm not sure if that will work. I could really use help as to the syntax to write a loop statement that will insert my returned variables and create the field names dynamically into my database table. I believe this is what i need to do.
I have a an issue that I would love to solve. The below code adds 111111111111111111 to the field when I want it to sum the amount which in this case totals 18 and then add that total (18) to the field! Code:
View Replies View RelatedI am currently working on a document management system for my company's Marketing department. They wish to be able to upload files to the server.
Rather than deal with the many permissions issues we have had in the past with saving and deleting these files to the server's file system, this time we are trying to use SQL server BLOB fields to store the files.
The premise is simple -- a user clicks on the link and the file is then shown in the browser. The documents are mostly word, Quark, and Adobe Illustrator documents. I was thinking the code would go something like this: Code:
I have announcements down the left hand column of a site and want to display contact info if it is available - if it is entered into the database. So I only want to display a space plus the data if there is data in the field. Code:
View Replies View RelatedI have a simple database. I can get the data from the database and display them on a web page without any probs.
My problem comes when im trying to insert new records into it. When i submit the data i get an Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot Update.
Database or Object is read-only.
I've tried looking at the properties of the db but i can't figure out why it is read-only.
i have one .htm page passing the info onto an ASP page and then showing the results on another page. The code for my two pages are (if it helps): Code:
how its mossible to someone update may database, for now we have a database
and time to time, someone update a record, changing the information.
what can i do to avoid this?
can any one provide me with script where i can add to my database table using csv file and web form.
View Replies View RelatedI have an employee directory asp application. Everything works the way its designed but I want to make some changes. When someone does a search it of course comes up with a list based on their search.From there they click on the persons name and it opens the edit asp page which they do and update.
What I'm hoping to accomplish is to some how save the search criteria and one they update the page it will return to the previous page and redo the search so they don't have to redo the search to do another update.
I have a table called WGDeliveryNotes which has a field in called TrackFlag1.I would like to update the TrackFlag1 field to contain a value of 1 when the page is loaded..... I currently have this set within the ASP tags at the top of the page, thinking that this would update the field as the page loads however this doesn't seem to be happening.
View Replies View RelatedOn a database how can i update has i tried RS update and it does not work.
View Replies View Relatedi have 2 databae files in MS ACCESS format and i have already connected them from 1 ASP file and now i need 2 update the econt 1 from the firt
in another words :
i have 2 access databases
the first which is called 1st.mdb i allowed my visitors 2 rigseter and edit their membership in it across my website.
the second which is called 2nd.mdb have the same structure of the first(tables and fields) but in another url. hat is the best way 2 update the 2nd.mdb from 1st.mdb of course i donot wanna caopy and replace i need some programmatical method.
I don't know how to upload word doc, images and other files into Oracle Blob fields with binary format.
I tried with the following code, normally it's inserting, suppose if i try to convery binary. Code:
I have found out that when using dreamweaver MX 2004 to update databases, and specialy for amatures such as myself, it is easier to update one field at the time. Other wise you will get an error message on the line stringname.execute (usually line 111).
The problem is solved by updating only one field at the time. It might time a little longer but saves headaches when you don't know exactly how to work with the code.
I need help with fixing my code below. It doesn;t work correctly. It works fine when there are 4 featured records. But I want to be able to change one to not be featured (equal to 0). This is not possible with my current code. It shows the same message about me not being able to have more than 4 featured records. Can someone please help me with this?
Code: ....
I have a problem when i try to update a database!!! I am requesting a firstname text field from a form and an id number to find the row in the database.
But when i execute the following code to update the firstname i get the error:
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. Code: