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 RepliesI have this form..which has a table (created from stored procedure
values)..once the table is populated..i have some radio buttons (for
each row of the table) and a main submit button.
On clicking submit..i want to loop through the table..pick up the
first <TDbeing the user ID and the value of the radio button clicked
(currently I have my radio button ID set as UserID_0, UserID_1 ..
etc). And pass those into a stored procedure..
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 have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies View RelatedHave an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.
Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies View RelatedI have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
Hello I have a page for registering users.
I am reciveing this error:
The following errors occured:
- An error occured. -2147217904 : No value given for one or more required parameters.
there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students.
I have a form designed to capeture the need information.
in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table.
then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:
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 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 can we submit one record at a time
View Replies View Related