473,405 Members | 2,294 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Any update in table i need a popup window

subashini Thiyagarajan
whenever any update in a access table, i need a popup window to be opened automatically without clicking anything.At the same time that pop up window should contain a last record details..


Any one can help me
Dec 28 '06 #1
6 1493
karthi84
271 100+
hi,
can u tell from where the data is added to the table. i.e, is it from an asp page or any where else. and the pop up window in the client side or in the server side.
regards...........
Dec 28 '06 #2
hi,
Pop up window should be in the client side.server has asp database.

just consider this is IVR setup as soon as any person call i mean get into IVR auotmatically server will fetch the caller details from another database as per the user telephone no.

when the caller is not hangup that means he is trying to speak to some customer care agent.the agent will get the call landed in their desk.by the same time that popup should open and show the user details in fact the same user suppost to be last record owner.

hope u got what i am saying...using trigger we can do this,


but in access and ASP how to do please explain
Dec 28 '06 #3
karthi84
271 100+
hi,
i dont have any idea about the IVR but i have done a project in which i have poped up a new window on a button press with the details corresponding to that button from the database. this i have done with the help of javascript. if you think that this may help you then i will be posting the coding for you.

regards......
Dec 29 '06 #4
karthi84
271 100+
hi,
i got one more idea, is it possible for you to get the phone number in a taxt box. if so you can use the onchange property of the textbox to call a javascript function and retrive the details of the respective caller.

i think this may help you...

have a good day.
Dec 29 '06 #5
Hi ,
thanks a lot for your reply.

Your First Idea is the right one.but we need to manually press a button.but i need to automatically.Anyway If u provide your codings to me.i ll have a glance on that ,also i may get some idea of making it automatically.

But your Second idea is a very good one.Actually the wholesome i am trying to see the caller tel no only.if u want me to bring it before a popup window i met my requirement their itself.

i am thinking if i display a table content and make it autorefresh of 5 sec definately i can see the last record in fact if i give link to each record no i can see the caller details but my intension is autopopup.how to achieve i am trying.

can i have a look of your idea your codings with your permission.
Jan 2 '07 #6
karthi84
271 100+
sure,

but i am not sure how much my coding is going to help u. here is my coding.....
Expand|Select|Wrap|Line Numbers
  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
  2. <% response.Write("<center>welcome "&session("user"))%>
  3. <script language="javascript">
  4. function Approved(CreditRequestID)
  5. {
  6.   //alert(MemNo);
  7.     var urls="ApprovedPage.asp?CreditRequestID="+CreditRequestID;
  8.     window.open (urls,"mywindow","location=1,status=1,scrollbars=1,width=400,height=400");
  9.  
  10. }
  11. </script>
  12. <%
  13. <html>
  14. <head>
  15. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  16. <title>Untitled Document</title>
  17. </head>
  18. <body>
  19. <form name="form1" method="post" action="ReviewCreditPage.asp">
  20. <input name="btnApprove" type="button" class="button" id="btnApprove" onClick='Approved("<% Response.Write(objRS(0))%>")' value="Approve"/>
  21. </body>
  22. </html>
  23.  
here as u can see <% Response.Write(objRS(0))%> this part is used to send the value to the javascript whose details are to be extracted from the database.

in ur case it will be the phone no. so here instead of the button u can use the text box with the property of on change to send the value to the javascript part.

can u tell me which database are u using.

hope this helps u.....

regards.....
Jan 2 '07 #7

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

Similar topics

2
by: umashd | last post by:
Hi, I am doing a web based project for my graduation. I studied bit of java for backend processesing and javascript for the client. Here is the scenario. In the FORM, I use INPUT TYPE=text...
3
by: Doug O'Leary | last post by:
Hey, all; Apparently, I'm missing the concept. I'm writing a web app in perl to manage nagios configuration files. One of the things I'd like to do is to confirm an update via a popup window...
5
by: Hemanth | last post by:
Hello there, I'm running a script that opens a popup window (which is basically a form with checkboxes and a submit button). When I click the submit button I want to run a PHP script and target...
5
by: Chris | last post by:
Hi, I have been trying for days, yes days, to use the calender from the asp.net timetracker starter kit. I am now frustrated. I finally get the popup calender to popup but when I click ok to...
2
by: Raed Sawalha | last post by:
I have the following table in ascx , when I click the button the table style not showing in the popup , it is ONLY showing on the page not in the popup...WHY? <TABLE style="BACKGROUND:...
1
by: laredotornado | last post by:
Hi, I have a data table on my page (buried amidst other images and extraneous text). I would like to spawn a new window that automatically prints the content of my data table, and only that...
6
subashini Thiyagarajan
by: subashini Thiyagarajan | last post by:
Hi, Any one can help me in this. I need a popup even my application minimized in the status bar.whenever any update happens suddnely one popup window should appear in the desktop with the last...
3
by: udayanu | last post by:
hi, can anybody help me to how to create bubble popup window with table row on mouseover with all the data of that row in popup and position of popup window will left side near that row. in...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
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,...
0
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...
0
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,...
0
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.