Search results for query: *

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

Thanks for your reply r937. This worked for me: (IssueDate >= '$FromIssueDate' OR '$FromIssueDate' = '') AND (IssueDate <= '$ToIssueDate' OR '$ToIssueDate' = '') Switching from NULL to an empty string did the trick. I also went from the BETWEEN evaluation to two separate tests...

Hi All, I have a form that populates search criteria in a query query. I want the user to be able to select a date range if they want to but also be able to use other search criteria and not use the range. My query seems to only be working if the date range fields are filled. Otherwise no...

I know it wasn't what you were referring to with this but I placed the db connection inside the function and it worked. Thanks for your tip on closing the connection. I removed that line too. Kind regards, Ken

Just an update: As a troubleshooting measure I modified the query line as follows: $result=mysql_query("SELECT * FROM `tblusers` WHERE adUserName = '$strUser'") or die(mysql_error()); Now the mysql error I am getting is "No database selected", which is odd because line 1 of my script...

Hi All, I have this code to authenticate users on an active directory server and then query a table on my database that contains their user level. For some reason I am not getting any records returned when I run the query in my script but if I run it directly in MySQL i get back the expected...