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 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 web page with three fields, Name and designation, salary. The name field is a <select> tag which contains all the names present in a tabe. When I select a name, the corresponding designation should be displayed. Then I enter salary and submit the form. There are two submts involved?
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:
Posting variables from an HTML FORM, via the Request.Form function on the receiving ASP page is great. But how can you POST a Form variable to an ASP page -- without a human pushing a Submit button? An ASP page that can decide when to POST and send the Form vaiables, but out without a human in the loop.p.s. the reason I do not want to use a Request.Querysting is because I do not want the user to see the values at the tail-end of the URL (?x=private).
I'm trying to make a script that will process any form you throw at it. Whats the best way decipher how many request.form's (i'm using post) there are and whats the best way to put them into an array since i don't have comma delimiters. Can I change what delimiters the array() function uses? 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:
this 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)
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:
i 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 .
My 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:
Okay 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:
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.
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 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?
The 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:
I 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.
Without 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):
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?