Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ItHurtsWhenIThink

    HTML5 datalist

    using Trident. So it looks like DataList would only work with Gecko. Thanks for the info. For those that asked, here is the rendering from my script (all fictitious data) <input list="frmUsers"> <datalist id="frmUsers"> <option value="1">Tony Adams</option> <option value="6">Anna...
  2. ItHurtsWhenIThink

    HTML5 datalist

    When I click on the list box it populates the list with the 'FullName' values. But as soon as I start typing a name the list drops off. That's because its auto-filling by UID. If I just go down and select a user from the dropdown list, the box displays the UID value (numeric). I need to pass...
  3. ItHurtsWhenIThink

    HTML5 datalist

    I'm just playing around with new html tags. Here is my first experiment, dynamic list box. Here is my code: <input list="frmUsers"> <datalist id="frmUsers"> <% sql="select FName+ ' ' +LName AS FullName, UID from members" Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sql, conn...
  4. ItHurtsWhenIThink

    Grouping Issue

    George, Works great. Great points as well.
  5. ItHurtsWhenIThink

    Grouping Issue

    I hope this helps. I have exported the data from SQL to an MS Access DB. https://www.dropbox.com/s/oyz7ba1caxf0teg/SampleData.accdb
  6. ItHurtsWhenIThink

    Grouping Issue

    Staffing //this table collect data for each day of staffing -SID - PK -SDate -shiftID -DeptID StaffApps //this table allows me to collect daily staffing based on units (where people are assigned) -SAID - PK -SID -UnitID StaffPersonnel //this table allows me to dump personnel...
  7. ItHurtsWhenIThink

    Grouping Issue

    OK, I see where I went wrong. Should have used UserID in query. Here is the result I got: Abell Kevin 4512.000000 OD Allum Simona 1128.000000 OD What I need is the ability to group by Last name and WorkName so result would break hour by user and workName... like Abell Kevin 72.000000 OD...
  8. ItHurtsWhenIThink

    Grouping Issue

    Hoping someone can help. I am trying to create a record set with a list of hours worked. The results should produce a list sorted by last name, first name and total hours worked (by work code) so, I could see same name twice (or more) if they worked say overtime and ExtraDuty. Tables (with...
  9. ItHurtsWhenIThink

    Evaluating the alias

    Got it! thanks for the solution. Both work well and I'll go with the more efficient query. Thanks again.
  10. ItHurtsWhenIThink

    Evaluating the alias

    drlex query works fine. gmmastros, your query produced an error for me: ERROR: Common table expression defined but not used. Error Code: 422 I want to thank both of you very much for helping me out with this solution. Your time and patience is very much appreciated. Have a Merry Christmas...
  11. ItHurtsWhenIThink

    Evaluating the alias

    I assume that each BottleId In SCBABottles can have a different HydroInterval. Yes that is correct. I assume that the Max HydroDate from SCBAHydro can be different for each BottleId as well Yes, that is correct as well The SCBAHydro table may contain many rows with the same BottleID, since...
  12. ItHurtsWhenIThink

    Evaluating the alias

    I get: ERROR: The multi-part identifier "SCBAHydro.HydroDate" could not be bound. ?? looks right. checked the spelling
  13. ItHurtsWhenIThink

    Evaluating the alias

    That worked. Now I have an issue with the results. I tried to change the INNER join to Left but got the same results. I have a table with all the air bottles (SCBABottles). My second table contains all the hydro testing for each bottle. In the query I thought the Max(SCBAHydro.HydroDate) would...
  14. ItHurtsWhenIThink

    Evaluating the alias

    I can't seem to be able to evaluate an alias. I get the following error: ERROR: Invalid column name 'HydroDue'. Error Code: 207 I want to be able to get recordset of all bottle that have past their hydro date. I take the hydro date (last hydro) and then add the interval 'HydroInterval' and...
  15. ItHurtsWhenIThink

    asp/java mix

    Theoretically no, because each 'frmLeaveCode' should have the 'intCount' value concatenated to it. So it might look like: if (window.document.form1.1frmLeaveCode.value==window.document2form1.2frmLeaveCode.value) OR if...
  16. ItHurtsWhenIThink

    asp/java mix

    gk53 correct. In fact that is what I am doing. Essentially, my form has a member drop down list. When the user changes that name to a different user I want to have a new form filed pop up on the form. BUT if they select a new member and then change back to the original member I want to have...
  17. ItHurtsWhenIThink

    asp/java mix

    I need to retrieve a form field name from my page and dump it into some java script. The form fields are created dynamically in an asp page. here are the pertinent parts of the code: chkLeave(var) { if (window.document.form1.frmLeaveCode.value==window.document.form1.frmCode.value) So I...
  18. ItHurtsWhenIThink

    java/asp mix

    I need to retrieve a form field name from my page and dump it into some java script. The form fields are created dynamically in an asp page. here are the pertinent parts of the code: chkLeave(var) { if (window.document.form1.frmLeaveCode.value==window.document.form1.frmCode.value) So I need...
  19. ItHurtsWhenIThink

    Hide/show table rows

    Great tip! Thanks, works great now. The page I posted was just my experiment page. I actually had it working (trying) using dynamic data so the id's were actually alphanumeric values. Now, I'll try putting it to work in my web page. Thank you so very much!
  20. ItHurtsWhenIThink

    Hide/show table rows

    I want to hide a set of table rows and have the ability to open a set as well. I am working with a dynamic table. So the rows I want to hide or open will have the same "id". I want all the rows with the same id to close or open. The problem I have right now, is that only the first row will show...

Part and Inventory Search

Back
Top