I have a asp form that has a dynamic drop-down box that a user selects a value from. Once the user makes a selection I use the onChange event to capture the selection and pass this value to a vbscript sub.
The sub then makes a adsi query using this value to retrieve additional information. This all works. I used a msgbox to display the retrieved value and it is correct. My problem is how do I update a field on the form with this retrieved value?
I have a form where the first field is a dynamic drop-down that pulls from a db (Access). The fields associated with the query are task_id, task_name and task_rate. The field has the value of "task_id" and the label of "task_name".
In the second form field, I would like the default value to be determined by the selection made in the first field. Based on the selection of the first form field, I would like the default value of the this field (task_rate) to be populated with the associated task_rate value of the selection chosen above.
I am trying to pass a hidden field value on a form into another field on the
form so that it can then be inserted in the database, to enable me then to
reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the
other input field.)
The code for the text field that allows users to type an number into it for
submission to the db is below, but what code do i need within the hidden
field to populate this text field below so that users do not have to type the
number in? Code:
Okay there is an unique EventRegID for every registration. When people first register they get pre-registered. Then an admin comes in and confirms or wait list them (based on whatever requirements). My question is how can I tie the EventRegID to a form with multipule ID's so they can batch confirm or wait list the PreReg list? Code:
View Replies View Relatedthis is a problem that is cropping up for the other developer here and i can't seem to find anything wrong. this code has worked for months and then the last couple of days it started sporadically not working. i'm thinking that it has to do with a performance issue but i'm not sure.
i don't use the ado .addnew or .update, so i'm a bit unfamiliar with the workings of it. here is a brief overview of the code.
ordRs.AddNew
... do the field updates
ordRs.Update
order = cint(ordRS.fields("order_id")
the problem is that order sometimes ends up as null, it's not getting the order_id field after the update. like is said, it's sporadic. anyone have any thoughts here?
ive got a table filled by a recordset with a column named "STATUS"
each record is a sale transaction. the status of this transaction is either open or closed. right now the table displays whats in the database as is, but i want to add the functionality to be able to close a transaction from the table.
i was thinking of 2 methods, one would be a check to see if the field = open, and if it is, make that field a link to a small popup that verifies the user wants to close the transaction then does its lil sql thing aand updates the table.
the other way i was thinking was to check if its open and make it a drop down list that will update table when submitted.
im veering more toward the former idea(not a fan of drop downs)
I have a list of names and a box with the age like this:
Name [20]
Name [26]
Name [15]
So i have his code:
Why is it that this does not work in MySql?
RS.Fields("Fullname").value = "Bob"
Is it because MySql does not support this?
The code below is a bit more representative of what I'm doing:
<!--#INCLUDE FILE="Database_Open.asp"-->
<%
sql ="SELECT * FROM CustomerBase WHERE " & _
"UserName='" & username & "' AND " & _
"SECRETWORD='" & password & "' "
RS.Open Sql, Connection, 3
IF RS.EOF THEN
'redirect code here
ELSE
RS.Fields("Fullname").value = "Bob"
RS.Update
%><!--#INCLUDE FILE="Database_Close.asp"--><%
Response.Redirect ("Menu_Account.asp")
END IF
%>
I'm having a spot of trouble trying to update fields in a access database using asp. I can delete and add fields thru the asp page but when i attempt to modify the fields i get a page not found error message. Code:
View Replies View Relatedi have a phone field in one of my tables. the data is pretty ate up. there's some numbers with .,- and extra spaces among other things. how can i do a mass update i would like to have all the phone numbers formated like this 555-555-5555 .
View Replies View RelatedMy products table has a weight field that I need to populate. A bunch of them have it and a bunch of them don't, but I need them all to have one. The weight is the same, 3, for all the records. I also have an Include field in that table. I want to make the weight field 3 for all records where the include field is true (it's a yes/no checkbox in access.)
I'm using Dreamweaver and I can build the SQL statement just fine but I'm not sure of how to loop through this to set the field for each of these records.
I am developing small asp application.There is a database called db.mdb and there are three tables(tblUser,tbsImport,tblcitylist) In tblcitylist there are two fiedls
1.Town
2.LReg
According to the relevent town there is a LReg (Lreg is a name already assign to the town)
this part is ok.
In my tblUser there is a field called Town and LReg (Same as above table)
But here LReg is empty.I mean there is a default value called "N/A"
I need to create a asp page for following purpose
* i need to read tblcitylist table and according to that I need to fill the LReg fields of TblUser Code:
i'm trying to figure out why i can not update a record if in the text box there is a ' anywhere in the field..
View Replies View RelatedOkay Whenever a user logs in we want to track the last time they logged in. My login script worked perfect before this now I can figure it out. All I did was add the way the table opens and the objRS.Update. Code:
View Replies View RelatedTrying to update 2 fields. my database is read only..
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
/sendd.asp, line 16
this is line 16: rsAddComments.AddNew
is this something to do with my server directory permissions?
code .....
I've declared a variable for the current date and want to use the UPDATE function to update the date field in a single record.
UPDATE lms_users Set leaver_date ="&MakeDate" WHERE user_id="473"
I know I have the date format in the variable as if I response.write it to the screen is displays correctly (28/08/2004). I must be doing something really silly, but can't see it.
is there any one know how to make function to update db field and to be called on checking a check books.
View Replies View Relatedhow to update a database from a dynamic table with checkbox. Their is only one field I would like to change and that is the one with the checkbox.
I am using Dreamweaver and I create a dynamic table, add the update record and I get BOF EOF error. The database does have data in it. Code:
What I would like to happen on this page is that when a user selects a company name from a drop down list, his selection autopopulates the cID field based on the selection. The drop down list is getting its choices from the customer table.
As I am still a novice, I am sure there is a way to do it I have not been able to get it right. Code:
I have a form that has approximately 7 text fields and 1 checkbox.
Generally when this form is submitted(to itself BTW) it works fine,
however, when the checkbox is only field that has been
modified/clicked the form doesn't always submit. When it does work, a
Stored procedure is passed form variables and updates to the db are
made. When it doesn't, its as if the form wasn't submitted, it
reloads and resets the page, but the stored procedure isn't triggered.
I have been creating an update table. When the form calls the current information in the database, it calls up a number of the item relationship rather than the actual name.
Example: In the database there is a table called Countries. Australia is country number 5. The update form shows number 5 rather than the text Australia.
I have a form and some links that are generated dynamically make up the one of the columns in my form. Here is the entire source for the form: Code:
View Replies View RelatedI 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 RelatedThe problem I have is that I need to be able to allow users select from a drop down list, but if they select other from the list, I need to show a text box where they can enter the details, otherwise keep it hidden. here is my code so far: Code:
View Replies View RelatedI want to allow users to send information from their local database to my web form. Their local database has a dsn, I am hoping that will help. Basically I am doing this because I do not want them to have to enter information twice. If I can get help populating a form on screen I can take it from there to my online database.
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'm new to ASP so I'm using DWMX as a crutch. It created the db connection and recordset code for me and all I want to do is have the page update the db with the result of a variable.
In plain English, I'm trying to update a field called Score in the table quizOne with the results of the variable score where the username field matches the session variable MM_Username. The recordset is called update_score.
Based on other tutorials and forums, I tried this: ....
I have a page that is populated from a db. It consists of lots of drop downs (dynamic - could be 20 or 32 or...) with the option value set as a number.
Basically they represent the skill level someone has in a skill which is you guessed it - written beside mr drop down.
So once i click on update i awnt them to all go off to the db and update. Any idea of an algorithm on how to do this. Im aware of for loops etc but i just dont see how it would work out.
How do you make a form field's value be determined based on the page URL?I've seen sites that you can change the URL like this (given "UserName" is the name of the field):
Code:
http://www.yoursite.com/page.asp?UserName=baseballdude_
Then when I clicked to visit this page, when it loaded, the value of the UserName field would be preset to baseballdude_.I've tried doing this for one of my sites, but it doesn't work. Is there some way of enabling this?
Ive got a session("name") and the following form in my website:
<form action="updateName.asp" method="post" name="myform">
<label>Name</label><br />
<input type="text" name="Name" size="25" maxlength="60" style="width: 50%"><br />
<br />
<input type="submit" name="submit" value="Update Password">
</form>
How can I equal the value of the form field name with the value of the session so the name will be displayed on the text field?
I have a form that users fill in, thefirst field is a username, which
must be unique.Currently only when I attempt the Insert into the DB does the restaint
inform the user that it already exists.Is there any way i can check , let say onblur, if that username exists, so that they dont have to complete the whole form before being
informed?
I have an asp page that has a form and only 1 field which is know as the ID field.
I only want users to enter an Integer value in the field. If they enter anything else it should come up with a pop up box error and not allow them to process the page.
I'm trying to make a simple Feedback Form using that CDONTS thing I read about (in that "How to use CDONTS" thread). Every works like it should until I try to step it up a little and get the information from a Form... Code: