Submit Record
how can we submit one record at a time
View Replieshow can we submit one record at a time
View RepliesI have a simple table "Line" with Columns Key, OrderNumb, Panels, Gates, Posts, Color, Memo, Comp. A user enters the information into the powder.asp page. It is then added to the database. The Comp Column is populated NO by a hidden input type. The data is then displayed on a page in a table and the last column has a submit button.
When the user Presses that button I would like it to update that record in the database to change Comp to YES. Some code snipits are below. The first is where the data is presented and where the submit button is. It then will go to the next snippet that hypotheticly will change just the Comp on that record to YES. I am not sure if I am not executing the SQL correctly or something but it will not change that order number row comp to 'yes'. Code:
I'm using DreamWeaver MX 2004. I'm wondering is there a way to have 2 (or 3) submit buttons in the one form, each one to insert the record & then redirect to different pages, depending on which button is clicked?
I'm thinking about submitting all forms to one page & have that redirect based on a URL/ Form parameter. Just curious as to other methods.
I am having a problem with an update date query ( there is something wrong with my query both locally and live.
So it has to be the query as my system settings are UK format.
Basically when I go to amend a record without actually doing any changes whatsoever. an click submit, when I see the amend the date switches format, regardless of entering any information.
If I go back and amend the article without doing any changes the date format again is switched back to normal. This is causing big issues, that really need correcting but I cannot figure what I have done wrong. I did previosuly post a message, but this appears to be something diffirent other than local settings. Code:
i'm trying to get a drop down menu to submit automatically when an option is clicked. i've tried various javascripts and they don't seem to work correctly with asp. does anybody know of anything that will work properly?
View Replies View RelatedI'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
View Replies View RelatedI have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
i hv wrote the code for auto generate id and its work. but the problem is, when i click on the submit button, the id number will remain the same value that is the last id number in database. let says before i click on the "New" button(which is use to increment id by 1) the id number is C1234.
once i click on "New" button then the id will increment by 1 as C1235 and that time user need to fill up the other field. but once i press on Submit button, the id number suppose to be C1235. but what i get is that C1234 means that i will display the previous id.
I have 2 buttons on my ASP page:
Insert
Search
When i click on the Insert button it does a form sumbit and calls a page "page1.asp" when i click on the button Search i want it to do a sumbit to another page "page2.asp"
I tried putting 2 form sections in my asp page but it doesn't work..
Is there a way in ASP to programmatically cause an HTML form to submit without clicking a Submit button?
View Replies View Relatedwhat I want to do is have a link to a website that automatically fills in a button and presses submit.
<form method="post" action="blahblah.php">
<input type="radio" checked name="option_id" value="999">
<input type="submit" value="Vote" class="input" name="submit">
Here, the radio button is already checked, but how do I submit
directly to the blahblah.php?
Can I just have it so that the submit button is depressed automatically when
you press a link to the page? i.e. click here! will go to the page with the
form, then automatically submit the data?
I have a submit button - I would like it to submit and then I would go to the next page when the submit button is pressed.
View Replies View RelatedI am creating a page in ASP (I recently taught myself ASP so I'm no expert by any stretch of the imagination).
This page is going to put data in a database, which then an adminstrator needs to approve, and then the data will be moved to a different DB allowing it to be viewed on the web). The issue is that in all reality someone may post data once a month at most. Since I am currently the one who needs to approve the data, and I am not one who will remember to check if any data is in the DB on a regular basis, I would like to know if there is a way I can have the form send me an email everytime data is inputted in the database, this way I know I need to review and approve the data.
I have an intermediate page that takes a querystring, does a query on a
database and writes out hidden values for each returned record. This design
layout is necessary for a variety of reasons and not subject to change.
I need the form to never be seen, essentially it needs to write out the
hidden values and immediately post to another form when it's done. I have
everything accomplished but the posting. Is there a technique to post the
form via code as opposed to a submit button or something of that nature?
i am having problem with my submit function. When i refresh my page or select an option from the drop down list it is submiting the values into the database where it should submit when i click the submit values. Another problem is tat wad ever values i submit it is appearing with comma at the beginning of the value in the database.
View Replies View RelatedCan I put a validation on the standard submit button on the form? I want the user to necessarily select a radio button on the page? Or should I be using a notmal button with an on_Click event? In that case how will I push submit?
View Replies View RelatedI know I have done this but my mind is fried. I have a dynamic dropdown in
a form. I need to pull both the dynamic dropdown's ID and name listed in
the dropdown. Need a little help with grey matter tonight.
I have a question about using a image as a submit button. Basically I have:
<INPUT="image" SRC="c:whateverwhateverutton.jpg" NAME="Login">
Now I have two different buttons in one form. I trying to figure out how to get the page to know what button was pushed, and then do a set of actions. Such as:
If button1 is pushed then
blah
end if
if button2 is pushed then
blah
end if
Thats the basic pseudo code for what Im trying to do. Keep in mind this is a image button.
I have a page with image, image has some image map, I want to submit
form when user mouseover that image map, my code is like this:
<img src="Images/floor4.jpg"usemap="#planetmap" id="IMG1">
<map id="planetmap" name="planetmap">
<area id=f4 shape="circle" coords="65, 93, 11" alt="CF4588"
onmouseover=overf4()>
And I write sub overf4() in vb script
sub overf4()
document.frmSelect.submit()
end sub
when mouse over that point form submit several times until mouse in on
the point I want to sumbit iust one time
i have struck in trouble in some development part, the thing is i am developing one site which collects some information in that i want that when some one fills form and click on submit button then my thanks for submitting mail Autoresponder should response. I want a perfect code for that.
View Replies View RelatedNormally I would do something like
if request.form("submitbutton.x") <"" then
....
end if
But I found a problem when the browser uses the 'alt text' instead of
the image (when the image is not found, or if the browser is not
displaying graphics, etc. How do you detect that? or should I?
I am working with two db's (i.e John and John1) I have a form that when submitted the information goes to the (i.e) Doe table. This table (Doe) is located in both the John db and John1 db, I need to add the functionality so that when the submit button is selected both db's are updated.
View Replies View RelatedI figured out that it is a default feature that if you are in an input box and hit the enter button it will cause the form to sort of 'submit'. I have a page where the form action is the actual page but it does all its variable assigning and such inside of an if then statement.
If Request.Form("submit")<> Then
and at the end of the if then I have a response.redirect to throw the results of my variables in the llink.
So what happens is when I hit the enter button it almost looks like the page is refreshing since the form action is the form itself. And the form doesnt even get into the If then statement. Anyone have any suggestions or direction as to what the easiest way I can do this is?
1. Is there any way of submitting only several variables froma form in
JS ?
I have some constraints in the server side, so I would like to have a
button and when clicked, submit only certain variables.
2. Creating a new form changes my formatting. Is there a way of
creating a form and superimposing it on top of another
I have been go through a lot of different websites to find out the problem but still cannot find a solution for it. I have an HTML email form which use post method to post the form data to an ASP page. It works fine in Outlook 2000 with IE6 or IE7. However, I updated my Outlook to the version 2003. The HTML email form does not work at all. Once the form is submitted, there are blank values in the ASP page. Just only when I refresh the page which a post back, the value is there.
View Replies View RelatedFor example I have a page where users submit records obvisoulsy by clicking on Submit button and by doing so I aslo make sure they have entered all the fields otherwise they can't submit it, if all the fields have been entered clicking on Submit submits it and takes them to the Submit.asp pages just letting them know they have successfully submitted all that data and then will redirect them back.
What I would like to know is how can I submit records in a way that visibly I still stay on that page that I use for entering data so clicking on Submit would submit the data and then clear the entry so a new set of records can be entered straight after?
I am looking at putting a form on one of my pages that inserts data into my database (MySQL)it is possible to submit this form and then when the form is submitted fire an e-mail off to a member of staff to say that a new record has been added
Has anyone had any experience of doing, or trying to do, anything like this (or even know if it's possible)?
This is from a "back-end" page on my site, but have run into a problem I've not had before, first off the form is being generated with some dynamic capabilities. Simply meaning I'm building it based upon so many records from a database.
Now I've isolated the problem down to 1 particluar text field and somehow related to it's name. When the name is present the form refusses to submit, except when I simply delete a reference to the name it works fine. Below you'll see an example of the code:
How do you automatically submit something? I.E. The code executes some stuff then does a form submit to automatically go to the next page? How to do this escapes me right now and I don't feel like waiting for my brain to remember.
View Replies View RelatedI have a form with 4 different Submit buttons. In the action code, I do a
request on the button names to see which one is valued. This all works
great, until the browser is refreshed -- the request shows the name of the
last button pressed. Is there a way to clear all the buttons so they don't
appear to have been pressed when they've only been refreshed?
Can I use "insert" statement without actually having to have the submit button?
View Replies View Relatedusing frontpage i am trying to write a script.
you have 2 dropdown boxes (A and B)
A - gets the data from the query(qryName)
so far so good
B - here i need to use the results from the A which is "contractno" and use it to get my final answer.
Basicly:how do i update a the "contractno" value and stay in the same page.
code example: Code: