473,574 Members | 17,882 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Query update process

3 New Member
I am running a mysql query thru php that takes long time to execute. I want to see which field is getting updated on the status bar dynamically. Progress bar will not help. In foxpro i used to use wait window. I have come to know that this is not possbile thru php can it be done with java
Sep 7 '08 #1
2 1281
gits
5,390 Recognized Expert Moderator Expert
in case you really mean java then you should have posted this question in the java-forum(i could even move this thread for you to that forum?) ... java and javascript have very different purposes and capabilities. but when you mean javascript and you want to display something on a website then you should probably give a step-by-step example for your requirement ... so that it is easier to understand what you need ...

kind regards
Sep 7 '08 #2
suddu
3 New Member
in case you really mean java then you should have posted this question in the java-forum(i could even move this thread for you to that forum?) ... java and javascript have very different purposes and capabilities. but when you mean javascript and you want to display something on a website then you should probably give a step-by-step example for your requirement ... so that it is easier to understand what you need ...

kind regards
I am new to this forum. I meant javascript only. To make it clear i have a mdule written in php. In it i have one option where data is calculated to get the position of the selected date. I copy all the records from the table to another temporarary table and then do all the reversals of entries made after the salected date. There are 1.5 lac record in the main file and 25000 record in another table out of which some are to be reversed. This complete process takes around 3 min. In the meantime the user feels that the process is hanged and he disconnects the same. I want the user the see the query status.
I have worked if foxpro 2.5 where i used to use wait window function. I wan't something like that.
I had posted this question on PHP forum , but i recieved the message from the moderator that it is not possible.

I would be helpful if someone can help me out. The solution will be helpful whereever the query processing takes long time. Progress bar doesn't give a clear cut idea.

Thanking u in advance
Sep 7 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

11
3744
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows 2003 Server or ADO or ODBC issue, I am posting this on all of the three newsgroups. That's the setup: Windows 2003 Server with IIS and ASP.NET...
22
3026
by: Robert Brown | last post by:
suppose I have the following table: CREATE TABLE (int level, color varchar, length int, width int, height int) It has the following rows 1, "RED", 8, 10, 12 2, NULL, NULL, NULL, 20 3, NULL, 9, 82, 25
4
3389
by: John Baker | last post by:
Hi: I have two tables, a setup table (TblSetup) and a purchase order table (tblPO). When i construct a query with ONLY the tblPO shown, and a type in parameter for the PO number, I an update the original tblPO. However, when I introduce the setup file into the query I cannot update the result. THis is true if I make a link to Setup or not....
3
1823
by: Nicolae Fieraru | last post by:
Hi All, I have a select query which is based on tblOne and tblTwo. The query selects some of the records in tblOne and tblTwo, based on a Where condition. What I need to do is to change the value in Field9 in tblOne for all the records found by the query. I am not sure if I should use an update query or if I use some vba code. In case I...
7
5082
by: rednexgfx_k | last post by:
All, Problem Summary: I've running about 30 make table queries via VBA in Access 2000, and my database goes from 14,000k to over 2,000,000k. In addition, the longer the procedure runs, the bigger the performance hit VBA takes. I'm wondering how to prevent or reduce this. Details: I have a database table of queries I want to run. This...
12
3409
by: strict9 | last post by:
Hello all, I'm writing several queries which need to do various string formating, including changing a phone number from (123) 456-7890. After some problem with data mismatches, I finally got it to work only to see that it takes 30-60 seconds to run the query, instead of the usual .5 seconds when I use a query without a function. Here is...
8
3703
by: Maxi | last post by:
There is a lotto system which picks 21 numbers every day out of 80 numbers. I have a table (name:Lotto) with 22 fields (name:Date,P1,P2....P21) Here is the structure and sample data: "Date","P1","P2","P3","P4","P5","P6","P7","P8","P9","P10","P11","P12","P13","P14","P15","P16","P17","P18","P19","P20","P21"...
2
4426
by: ILCSP | last post by:
Hello, I'm in the process of changing our 'normal' Access 2000 update queries to Update Pass Through Queries. We have a SQL server 2000 database and we're using an Access 2000 database as our front end. In the criteria of one of our update query fields, we use both the isnull(field1) and Not IsNull(field2) then Field3, otherwise, set the...
1
1491
by: G Gerard | last post by:
Hello I am trying to update a table (TableB) using records from a second table (TableA)
1
2616
by: rdemyan via AccessMonster.com | last post by:
My application has a table that contains information on buildings. The building data comes from another database and is imported from a spreadsheet into my application. Originally, I thought that when a building data update is available, I would simply delete the existing data and import the new data into the table. However, now it seems...
0
7738
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...
0
8081
Oralloy
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. ...
0
8258
jinu1996
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...
0
8121
tracyyun
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...
0
5325
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3777
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2255
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
1
1360
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1084
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.