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...

...0, iniFormsCount: 1, nestedForms: [ ] }); }); </script> <script type="text/javascript"> /*<![CDATA[*/ function Select(sel,id,nu){ document.getElementById(id).style.display=sel.selectedIndex==nu?'block':'none'; } /*]]>*/ </script> <script...

Sorry i am not too swift as script or Jquery. Could you exaplin how to inplement into my currently used script. Thank You

...var twp=tbDiv.width; var twi=parseInt(twp); if(twp.indexOf("%") > 0) { twi=((ge$('Scroller:fx:OuterDiv').offsetWidth * twi) / 100)-20; twp=twi+'px'; tbDiv.style.width=twp; } var fh=ge$('Scroller:fx'); var...

Wow..thank you so much for the explaination..That helped so much.

hi sorry i did not get back sooner. I tried your qry as is and works for the data in the order it is. If I put a qualifier in such as order by or even more "tagname = 'machine5_Dat_badge'" then the qry fails. How would you modify the qry to handle when a tagname is being defined or the value...

...0) insert into #dttest values ('2013-03-26 07:50:15', 07, 1) insert into #dttest values ('2013-03-26 07:52:11', 07, 0) ; with Data As ( Select *, Row_Number() Over (Partition By mn, stat Order By dt) As RowId From #dttest ) Select A.mn, A.dt As StartFill, B.dt as EndFill From Data...

Awesome thanks for everything.. Works great.. Both of you.. your qry's worked well but gmmastros's worked best for my situation..

This is the expected result: if another dupe occurs in this case a dupe "#7" mn dt dt 7 3/26/2013 7:46:07 3/26/2013 7:47:49 13 3/26/2013 7:48:04 3/26/2013 7:49:57 7 3/26/2013 7:50:15 3/26/2013 7:52:11

Yes it does work with and d1.mn = 14..I got the qry to work the error was on my part sorry.. But.. What I am seing is this .. When duplicate mn's occure the qry fails..How do I over come this. There will be multiple mn's. create table #dttest (dt datetime, mn integer, [stat] integer) insert...

Simi you qry works well with your prefilled data.. If I need to add a parameter to view a certain "MN" I am unable.. select d1.mn, d1.dt, d2.dt from dttest d1 join dttest d2 on d1.mn =d2.mn and d1.stat <> d2.stat where d1.stat=1 and d1.mn like '%14%' <--- Adding this does not work.. any...

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...

...am doing incorrectly now? I get no errors but my form fields are not populated either.. Thank You <cfquery name="_data" datasource="db"> SELECT * from PerformanceBoard </cfquery> <cfset xx = QuotedValueList(_data.tagname)> <script type="text/javascript"> function loadIt(){ var...

I think I got it...Used "Evaluate" in the second part of the equation. <cfset "dtime#right(hours.machine,2)#" = "#evaluate("dtime#right(hours.machine,2)#")#" + downtime> Thanks for the assist...It's good to talk things through with someone!

Below is the test I am running..I removed the "underscores"...But I still receive the error "The value "dtime01" cannot be converted to a number".. The problem is probably so right in front of me but I cannot see it! <cfset dtime01 = ''> <cfset dtime02 = ''> <cfset dtime03 = ''> <cfquery...

Sorry, not getting I guess what your trying to explain? Could you be more specific or supply an example. Thank you

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>

<script language="javascript"> function ShowMyDialog() { var obj = new Object(); obj.data1 = document.getElementById('percentage01'); obj.data2 = document.getElementById('time01'); showModalDialog('_eff_insert.cfm', obj, ''); } </script> First Select: <td>...

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, Your qry removes all entires for 'Nov 18 2009 12:00AM'. I need all entries for '62945' to be zero'd out but machine2 on 'Nov 18 2009 12:00AM' Thank You.