Jump to content

davej

Moderator
  • Posts

    3,988
  • Joined

  • Last visited

  • Days Won

    2

Everything posted by davej

  1. So what is the primary usefulness of this? I don't even like the idea of a site being able to mess with the browser history. I have a little demo that pushes and pops but it seems pointless to me. Thanks https://developer.mozilla.org/en-US/docs/DOM/Manipulating_the_browser_history
  2. davej

    HTML5 and IE8

    So far I'm just looking at some basic html5 stuff, but IE8 is recent enough that I think it needs to be handled in some way. Thanks dsonesuk, I'll read this article.
  3. davej

    HTML5 and IE8

    So I'm guessing IE8 doesn't support much HTML5. Is there any work-around?
  4. So how many different methods are there for creating multi-column pages? Does HTML5 have any new options that affect this?
  5. Any image editor will do, such as MS Paint. The coordinate of the mouse cursor is shown on the status bar. The top left corner of the image is 0,0. I think the best approach is to make a copy of the image and then actually mark the points on the copy so that you can see them. Also I believe that if you scale the image this will have an effect on the imagemap.
  6. Is there some trick to getting the HTML setup correct for an applet? I download simple examples that work online but on my desktop they refuse to run. I see ClassNotFoundException or NoClassDefFoundError so I am guessing that I'm not understanding the required setup. Example such as...http://www.w3.org/Pe...ject/java/clock Thanks
  7. You say you have two tables and then you seem to list three tables. You also give no hint regarding your foreign keys.
  8. Yes, I could do that, but since I only have two types and have additional data to store for managers I thought I would have an Employee table for basic employee information and then a Manager table for manager-specific information. They both use Employee_number as the primary key, but I thought I would have the primary key as an autonumber in Employee and as a primary and foreign key in Manager.
  9. I have a hosts file so I never see these ads, but I have to say that the bundling of ads has gotten out of control. I have seen some slimy and dishonest ads appear on sites that you would think would never allow such rubbish.
  10. I've been thinking about the workings of an appointment scheduling system for a class I'm taking where we are not actually doing any programming but just toying with concepts (Systems Analysis) but I'm now kind of confused about how I would actually write such a program. I'm not sure how to make the database an efficient mechanism for correlating available time and reserved time so that you could quickly throw a calendar/chart on the screen that would display available appointment openings. I started off thinking that I would have a table of scheduled appointments where each record would have a start time and an end time and an assigned person. Then I would have a table where each person has their normal availability schedule entered for a typical week. Then maybe I would need an availability_exceptions table where planned holidays, vacations, and out-of-office periods are entered. This all adds up to a fair sized mess that I would not want to process every time someone wants to see when a new appointment could be scheduled, so then I start thinking of other tables where some sort of processed data might be kept, such as perhaps a table containing large boolean arrays of minutes or something. It gets rather messy. Any suggestions? Thanks.
  11. Every time I am forced to use this thing I just end up hating it. When Microsoft is giving SQL Server Express away for free why do they SELL Access? Why not eliminate Access and just provide a nice GUI for SQL Server? My latest headache? How do I create a foreign key that is also a primary key? I can edit the relationship but I can't tell what the direction of the relationship is. In other words I have an Employee table and a Manager table. The managers are obviously limited to employees, so in the Manager table I want to create a foreign key relationship back to the Employee table.
  12. The whole thing is much more confusing than I thought it was. Yeah, you are right that the attempted re-application of the FK constraint would probably fail.
  13. It seems rather natural to me to want this sort of one-way referential integrity. You delete the part so that no one will use it again but you want the part to be retained in all the completed sales invoices. The only solution I can see is to use a trigger procedure to lock the table, remove the foreign key constraint, delete the parent, and then reapply the constraint. Of course the cleaner solution would be to have an "Obsolete" boolean column in the parts table.
  14. That is essentially the source of the confusion. "NO ACTION" might be thought to mean that deletes are not cascaded to child entries, but what it seems to mean is that the deletion of the parent will be refused if there are any children. http://msdn.microsoft.com/en-us/library/aa933119%28v=sql.80%29.aspx
  15. http://en.wikipedia....ational_algebra I'm thinking it shouldn't be all that confusing if you already understand relational algebra. It looks like relational algebra is designed to do this. Are you asking how to interpret the query? SELECT FirstName, LastNameFROM EMPLOYEEWHERE EmployeeNumber IN(SELECT DISTINCT EmployeeNumberFROM ASSIGNMENTWHERE HoursWorked > 50); Output the FirstName and LastName from those records in the table EMPLOYEE where the value in the EmployeeNumber column is equal to one of the values output by query2. query2:Output one of each EmployeeNumber from the table ASSIGNMENT if that row/record contains a value in the HoursWorked column that is greater than 50.
  16. I have not looked at SQL in awhile and now I'm confused on the topic of orphans. Let's say you have two tables: TABLE: STOCKPART_NUM DESC QTY_IN_STK TABLE: INVOICE_LINEINV_NUM PART_NUM QTY_SOLD You want the creation of INVOICE_LINE records to require that the PART_NUM exists in the STOCK table, and you want the deletion of a part from the STOCK table to be possible and have no effect on the existing records in the INVOICE_LINE table. Orphans are to be preserved because they are in completed invoices. The question is: can this really be done? I don't understand how to allow the deletion of the parent and allow orphans to be left behind. It doesn't seem to be possible. http://msdn.microsof...sql.105%29.aspxhttp://msdn.microsof...sql.105%29.aspx
  17. Well, isn't AJAX irrelevant until the key capture event is proved out? I see there are some tricks to get it working: http://www.quirksmode.org/js/keys.html In a Yahoo forum I saw some bozo ask how he might create a keylogger, but the usefulness I see is creating an error beep if a "hunt and peck" typist is not typing in a valid field -- but this introduces the problem of creating an error beep. The following code detects the key event but does not identify the key in Firefox... <!DOCTYPE html><html><head><script type="text/javascript">function myFunction(e){var kc = e.keyCode;var ki = e.keyIdentifiervar kl = e.keyLocation//var c = String.fromCharCode(k);alert("Key [" + kc + " " + ki + " " + kl+ "] was pressed down");//document.getElementFromId("txt1").value = kc +" "+ ki +" "+ kl;}</script></head><body id="body1" onkeypress="myFunction(event)"> Detected keystroke: <input type="text" id="txt1"> </body></html>
  18. http://www.w3schools.com/jsref/event_onkeypress.asphttp://www.w3schools.com/jsref/event_onkeydown.asphttp://www.w3schools.com/jsref/event_onkeyup.asp Is there any way to detect keystrokes when the user has clicked on the form and then entered keystrokes that are otherwise going to be ignored? The user has clicked on the form but not clicked into a textbox. Thanks.
  19. I've changed styles using document.getElementById("id").style.xxx But... Can you apply a different _named_ style to an element?Can you apply a different external stylesheet to a page? Thanks.
  20. I'm sure someone has made a nifty graph of all the delays -- but I couldn't find one in a quick search. If anyone finds or knows of a nice summary please post the link.
  21. Super bland. You need to add a colorful graphic or image. Read More, Comments, Wrong Date -- does what? Can you really own the words "Washington Area Shoe Repairmen" ?
  22. Generally I always see a second or more delay when going to a new address and it certainly isn't the 50kB html file that is requiring a second of transmission time -- because it should require less than 0.025 second.
  23. I thought it seemed to be a monthly limit. Is it quarterly?
×
×
  • Create New...