Search results for query: *

Hi, I have the following script that works for the most part except the chained select. I think i have distinct id's for everything but when I add a new row the chained select fails. Can I someone lend a hand. Thank You I have add, remove, up, down, top, bottom working in the fiddle; and...

Can someone shed some light on what I am missing..I am trying to clone a select box that shows/hides div based on the value of the selection. I can get the first drop down to work and show the correct div..but when I clone a div the next select does not show the div..I am pulling my hair out...

Hi..I am using the following script to enable a scrollable table(fixed header). But with large amounts of data I cannot save my scroll bar position. Can someone please assist with how to modify script to save the scroll position on page reload. (function() { var flag=false; var tid...

Hello, Been working on arranging data below in desired format in SQL Db. DateTime TagName Value 4/19/2013 8:03:36.806 machine5_Dat_badge 63430 4/19/2013 8:04:37.368 machine4_Dat_badge 29549 4/19/2013 8:05:30.943 machine6_Dat_badge 29023 4/19/2013 8:06:10.919...

Hi I am having difficulty today with my SQL pivot. My current data looks like this. datetime machine number status 3/26/13 7:46 14 1 3/26/13 7:47 14 0 3/26/13 7:48 13 1 3/26/13 7:49 13 0 3/26/13 7:50 7 1 3/26/13 7:52 7 0 I am attempting to format data like...

Hi Im trying to popluate all the input fields in my form in one shot. Is it possible to do what I am attemping to do below? I am lost on what I am doing incorrectly now? I get no errors but my form fields are not populated either.. Thank You <cfquery name="_data" datasource="db"> SELECT *...

Hi could someone help me understand why the follow code is not working? <cfset Pcount1 = ''> <cfset Pcount2 = ''> <!-- Start Loop --> <cfloop index="Add" from="1" to="2"> <cfset "Pcount_#add#" = "Pcount_#add#" + #add#> <cfoutput>#evaluate("Pcount_#add#")#</cfoutput><br> </cfloop>

Hi, I would like to update "Perc" with the first select below & "Time" with the second select below :both with an OnChange event: Can i get some assistance; I am at a loss..I can get an onchange to other input fields but cannot figure this one out.. First Select: <td> <select...

Hi, I have a question regarding duplicate data entries. I would like to zero out all duplicate entries of '62945' but machine2 on Nov 18 2009. Is this possible? And how would you go about this? date_id machine1 machine2 machine3 Nov 18 2009 12:00AM 62945 62945 53214 Nov 19...

Hi could I get a hand on how I would sum the following number sequence. The datetimes can change as well as the values. Im trying to get a handle on just summing these values. I have a starting value of 78913 and an ending value of 3212. Datetime Value 3/22/12 15:40 78913 3/22/12 15:42 78913...

Hi i am attempting gather the amount of minutes that have occurred in the duplicate values in the following data. The column headers are my Db column names. I am trying to count the minutes between "start count here" & "end count here" only. I am ordering my datetime column desc order. If i...

Hi I am trying to figure how to get the top 5 records through my query below but am unable to come to the right solution in SQL. Can someone lend a hand please? SELECT sum(isnull(value_2,0)-isnull(value_1,0)) as "Weight Difference" FROM ( select(select top 1 nullif(isnull(value,0),0)...

Hi, I have the following data and am trying to calculate the count based on start & end times..but i cannot think of how to start in SQL. Can someone help me Please? 1.start time "2011-03-07 07:18:36.0000000" 61862 2.end time "2011-03-07 08:03:04.2920000" 471 Around 7:30 the data values...

Hi All, I would like some assistance with the following code: I am try to get the percentage of 2 inputted times and have another field auto populate but I am not that familiar with JavaScript and "times",(i can get two numbers to work but not the times). Any help would be great or if someone...

I have the follwoing query can someone help explain how I can get the results i need? I get an "Invalid column name 'max_value2'" error. Thanks SELECT tagname, sum(max_value1-max_value2) FROM ( select tagname, max(value) as max_value1 from analoghistory where tagname =...

Hi, I am looking for help/advice on a problem i am trying to resolve. I have badge swipes that have the employee badge number and a time stamp. machine badge number date/time 01 00001 09/25/09 08:00 - swiped in 01 00001 09/25/09 08:25 -...

Hi, I think i'm in need for some serious help. I am trying to write an app that will generate a work order based on the tasknumber and the next due date of the work order. I seem to be running into issues with generating the correct next due date to be inserted back into the database. Could...

Hi, Could someone lead me the right direction. I am trying to figure out how to add 5 blank fields of my choosing to a form when a user clicks add another item. I am trying to create a parts requisition form so when a user adds his QTY, Eaches, description, cost the form will calculate the cost...