Recent content by deeciple

Hi All, I am trying to send some values to a python script using an AJAX call. The AJAX is calling the script properly because if I plug the values directly into the script it executes properly. The problem I am having is when I try to send the values to my script by embedding them in the...

I got it working. I had to import the cgi library to my python script. #!C:\Python27\python.exe -u import cgi import kipro client = kipro.Client('http://10.221.14.161') client.play() This leads me to another question about retrieving URL parameters but I will post again for this. Thanks

Hi feherke, Thanks for pointing that out. I had not thought about that link being on the client and thus being invalid. I changed the link but it's still not working for some reason. I am using WAMP server for my development. It supports cgi. I will do some more research on getting CGI...

Hi All, I have been wrestling with trying to get a simple python script to run on the click event of an HTML button. Here is the python script: #!C:\Python27 import kipro client = kipro.Client('http://10.221.14.161') client.play() It issues a "play" command to a remote VTR. I have the...

Never mind. It was simpler than I thought: function deleteRow(r) { var i = r.parentNode.parentNode.rowIndex; document.getElementById("dataTable").deleteRow(i); }

Hi jpadie, I tried this: { var node = this; while ( node.tagName != "TR" ) { node = node.parentNode; if ( node == null ) return; // ??? something went wrong } node.parentNode.removeChild( node ); } ...but it doesn't seem to be doing anything :( Is this...

Hi All, I have a script that runs on my page load and pulls some data from a database to build a table with. function makeTable(tableID){ var str = "<?php echo $row_rstRequestDetails['tblEquipRequestID']; ?>"; var body = document.getElementsByTagName("fieldset")[0]; var tbl =...

I'll give it a try when I get into the office tomorrow. Thanks!

That's interesting. I tried looping through the records in a similar fashion but the issue I ran into is I don't know in advance which users' records were going to be returned by the query? How would the counter be able to know when one user's records ended and another user's records began?

How would you make this query more efficient and still achieve the same output? I am not very experienced with SQL so unfortunately I have to use a gui like Access. I agree, like most front ends the code that it generates is not very efficient.

I got it working. MS Access lets you construct queries using a gui then you can switch to the SQL view. It needed some tweaking afterward but here is the query as it is in my PHP page: if(isset($_POST['ReportTitle'])) {$ReportTitle = $_POST['ReportTitle'];} if(isset($_POST['Interval']))...

Hi All, Thanks for your replies. When I remove the GROUP BY clause I get: VTR | Broken | 6/14 | 6/15 | Larry | 6 TV | Gone | 6/17 | 6/18 | Larry | 6 Spkr| Blown | 6/20 | 6/21 | Larry | 6 Mic | Broken | 6/15 | 6/16 | Tom | 6 Mic | Broken | 6/14 | 6/16 | Sarah | 6 Spkr| Blown | 6/15 | 6/16...

Hi Everyone, I have this query to count how many support requests are made within a given date range: SELECT tblequipissues.EquipType, tblequipissues.Issue, tblequipissues.IssueDate, tblequipissues.FixedDate, tblequipissues.EnteredBy, COUNT(tblequipissues.EnteredBy) FROM tblequipissues WHERE...

Thanks Guys for all your replys! Skip I see where it works in Access I am not sure how to translate that to MySQL though. This is the intended result, however. I am wanting to return records where any of the check boxes are checked. In my table, the values stored for the check boxes are...

Hi All, I have a table with three checkboxes that I want to query. I need to be able to check any box (or boxes) and return records where the box/boxes is checked, but not records where it is unchecked. I tried this but it keeps returning all records, regardless of the checked status: (chk1...