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

    Using GET() parameters in a python script

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

    Help calling a python script through AJAX

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

    Help calling a python script through AJAX

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

    Help calling a python script through AJAX

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

    Strange row number behaviour with javascript generated table

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

    Strange row number behaviour with javascript generated table

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

    Strange row number behaviour with javascript generated table

    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 =...
  8. deeciple

    Need help with COUNT() function

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

    Need help with COUNT() function

    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?
  10. deeciple

    Need help with COUNT() function

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

    Need help with COUNT() function

    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']))...
  12. deeciple

    Need help with COUNT() function

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

    Need help with COUNT() function

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

    Querying multiple checkboxes in different states

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

    Querying multiple checkboxes in different states

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

    MySQL Date range or IS NULL

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

    MySQL Date range or IS NULL

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

    Need help with a query in PHP (not returning any records)

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

    Need help with a query in PHP (not returning any records)

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

    Need help with a query in PHP (not returning any records)

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

Part and Inventory Search

Back
Top