I set up a page which allows the user to add data to a table. I would like to then re-load the page to display all of the data in a list including the data the user entered. I currently have fields which are able to re-load the page by using the OnChange event and firing the following java script:
function OnChangeField()
{
document.frmKPI ActMaintReg_01. submit();
}
Is there a way to programmaticall y accomplish this from within vbscript so that after the user enters the data and I insert it in the table, I somehow from within vbScript fire the submit() event
6 4133 jhardman 3,406
Recognized Expert Specialist
You can't actually fire a submit from asp, the closest thing is put a onload=submit in using asp, or redirect including form data in a querystring. Do you need help doing either of those things?
Jared
You can't actually fire a submit from asp, the closest thing is put a onload=submit in using asp, or redirect including form data in a querystring. Do you need help doing either of those things?
Jared
Yes. Could you post a sample code.
Thanks,
Ralph
jhardman 3,406
Recognized Expert Specialist
Yes. Could you post a sample code.
Thanks,
Ralph
Ralph,
Sure, let me get a better idea of what you're doing. You enter one row of data, after each input is added a submit() is called form javascript which posts this data to a formhandler which updates the database. Am I right so far?
Then you want the form handler to re-display all of the data that has been entered? Is this right?
Jared
Yes that's it. In vbscript I do the following:
<%
Insert new record into table ....
Select * from table for all records in same time period and location and display on screen ....
I think before I do the select, I have to execute some type of Javascript which clears the screen.
jhardman 3,406
Recognized Expert Specialist @rmurgia
I don't think anything related to clearing the screen is necessary, everyt ime you submit the form, the page will need to be reloaded. I would just do this all on one page, no need to redirect or clear the screen. At the top of the page, check to see if the user has added new data. If he has, go ahead and save that to the db. Then query the db and build the table of data that needs to be displayed. As long as you save any recently added data first, it will be included in the table that is generated, probably at the bottom (depending on what kind of sorting you use). Finally, add the form that allows the user to enter new data. I think this accomplishes everything you are looking for.
Jared
Jared,
I re-wrote the program as per your suggestion and everything is now working.
Thanks for the help,
Ralph
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Nel |
last post by:
I have a question related to the "security" issues posed by Globals ON.
It is good programming technique IMO to initialise variables, even if it's
just
$foo = 0;
$bar = "";
Surely it would be better to promote better programming than rely on PHP to
compensate for lazy programming?
|
by: Craig Bailey |
last post by:
Anyone recommend a good script editor for Mac OS X?
Just finished a 4-day PHP class in front of a Windows machine, and liked
the editor we used. Don't recall the name, but it gave line numbers as
well as some color coding, etc.
Having trouble finding the same in an editor that'll run on OS X.
--
Floydian Slip(tm) - "Broadcasting from...
|
by: Chris |
last post by:
Sorry to post so much code all at once but I'm banging my head against
the wall trying to get this to work!
Does anyone have any idea where I'm going wrong?
Thanks in advance and sorry again for adding so much code...
<TABLE border="1" bordercolor="#000000" cellspacing="0">
<TR>
|
by: Alan Walkington |
last post by:
Folks:
How can I get an /exec'ed/ process to run in the background on an XP box?
I have a monitor-like process which I am starting as
'exec("something.exe");' and, of course the exec function blocks until
something.exe terminates. Just what I /don't/ want. (Wouldn't an & be
nice here! Sigh)
I need something.exe to disconnect and...
|
by: John Ryan |
last post by:
What PHP code would I use to check if submitted sites to my directory
actually exist?? I want to use something that can return the server
code to me, ie HTTP 300 OK, or whatever. Can I do this with sockets??
| |
by: James |
last post by:
What is the best method for creating a Web Page that uses both
PHP and HTML ?
<HTML>
BLA
BLA
BLA
BLA
BLA
|
by: Beowulf |
last post by:
Hi Guru's,
I have a query regarding using PHP to maintain a user profiles list. I
want to be able to have a form where users can fill in their profile
info (Name, hobbies etc) and attach an image, which will upload the
record to a mySql db so users can then either view all profiles or
query.. I.e. show all males in UK, all femails over 35...
|
by: Lothar Scholz |
last post by:
Because PHP5 does not include the mysql extension any more is there
a chance that we will see more Providers offering webspace with
Firebird or Postgres Databases ?
What is your opinion ? I must say that i like it to see mysql replaced
by a real database (stored procedures etc.)
|
by: joost |
last post by:
Hello,
I'm kind of new to mySQL but more used to Sybase/PHP
What is illegal about this query or can i not use combined query's in mySQL?
DELETE FROM manufacturers
WHERE manufacturers_id NOT IN ( SELECT manufacturers_id
FROM
products )
|
by: sky2070 |
last post by:
i have two file with jobapp.html calling jobapp_action.php
<HTML>
<!-- jobapp.html -->
<BODY>
<H1>Phop's Bicycles Job Application</H1>
<P>Are you looking for an exciting career in the world of cyclery?
Look no further!
</P>
<FORM NAME='frmJobApp' METHOD=post ACTION="jobapp_action.php">
Please enter your name:
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |