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!

Register Log in
  • Congratulations Chriss Miller 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. chandler

    executing *.sql file for mysql

    ...from a single script. What's the trick? (I've verified that my connection works and I can execute queries to the mysql server.) lcServer = '***' lcDatabase = "***" lcUser = '***' lcPassWord = '***' sqlfile = FILETOSTR("r:\imb\imbsetup.sql") ?sqlfile * run .sql script GetConnHandle =...
  2. chandler

    Need some help with SQL

    I have a similar data layout for some of our shop operations. I basically created a view in the cross-tab looking format and then query that with a web service for my client app. However, how do I go about updating the events? In my client app each "record" has a field for every event and I...
  3. chandler

    Skip Labels.

    I've got a .lbx pulling in data to print out to a sheet of 2 columns of 2"x4" labels. Everything works great, but I'd like to have the ability to skip labels in order to avoid wasting labels and having to use a new sheet of labels every time. The only way I can think of right now is to insert...
  4. chandler

    Search on "Excel" not working in this forum?

    Actually, it looks like the search function isn't working period. Chandler I ran over my dogma with karma!
  5. chandler

    Search on "Excel" not working in this forum?

    When I search for "Excel" or "excel" I get no returns. Yet I know they're in here! What's up with that? Chandler I ran over my dogma with karma!
  6. chandler

    Naming an Excel workbook and worksheets

    Worked like a charm. Muchas Gracias. Chandler I ran over my dogma with karma!
  7. chandler

    Naming an Excel workbook and worksheets

    I've been looking for a way to name the workbooks and worksheets I create using VFP 9.0 So far I've found ways to create and select, but not to name. Any help is much appreciated. Chandler I ran over my dogma with karma!
  8. chandler

    fputs() and control characters

    FSEEK( _splits, 0, 2) That's it. Thanks. Chandler I ran over my dogma with karma!
  9. chandler

    fputs() and control characters

    I'm using the fputs() function to send text to a text file, but the beginning of each line in the text file is showing 2 squares for some control characters. Am I missing a parameter? FSEEK(_splits,2,2) fputs(_splits,ALLTRIM(pname)) Chandler I ran over my dogma with karma!
  10. chandler

    STRTOFILE() but variable is >255 characters

    Thanks everyone. I'm going to end up putting the header in a text file because that takes care of making the change in quite a few other processes all over the department. Chandler I ran over my dogma with karma!
  11. chandler

    STRTOFILE() but variable is >255 characters

    I'm trying to create a header row for a comma delimited file using STRTOFILE(), but the variable for the cExpression property is greater than 255 characters. Is there a workaround? && Header Row hdr='"FIRST","LAST","OR CURRENT RESIDENT","STREET","CITY","ST","ZIP4","JOBNUM","PART","OPT...
  12. chandler

    Skip elements in an aray

    ...$up1_Data[$i] = $closeData[$i] + $stdev; $dn1_Data[$i] = $closeData[$i] - $stdev; $up2_Data[$i] = $closeData[$i] + $stdev * 2; $dn2_Data[$i] = $closeData[$i] - $stdev * 2; } I'm guessing I need adjust in both the function for standard_deviation adn the for... loop. I've tried manipulating...
  13. chandler

    Passing referrer info using winow.open

    Hmm.... well, I understand that it is left to the discretion of the browser and that's acceptable to me at this time. I have another method to "secure" content using the Joomla session variables. But having 2 methods can't hurt either. Using just the standard <a href="url link"...
  14. chandler

    Passing referrer info using winow.open

    I'm trying to create a new window with window.open, but I need to pass the referrer info so that the request doesn't get "locked out" by my .htaccess file. Is there a way in php to pass that info? Chandler I ran over my dogma with karma!
  15. chandler

    Conditional Cell Formatting

    Thanks Rob. That'll do nicely. Muchas Gracias. Chandler I ran over my dogma with karma!
  16. chandler

    Conditional Cell Formatting

    Rob, I'm very interested in that code because that is exactly something I was going to implement for another part of the page. Thanks. Chandler I ran over my dogma with karma!
  17. chandler

    Conditional Cell Formatting

    Is it possible to do conditional cell formatting in HTML tables similar to Excel? I'm trying to change the cell's background color depending on the value in the cell. The table cell values will come from PHP returned values. Chandler I ran over my dogma with karma!
  18. chandler

    multiple arrays from CSV file

    found it. ($row-1) should be -2 to account for header row. Chandler I ran over my dogma with karma!
  19. chandler

    multiple arrays from CSV file

    For the life of me, I couldn't get it to work. But I did find some code that did work... but the only bug is that the created array has no value at $array[0]. And the first elemnt is at $array[1]. Can somebody see where I need to change the code? <?php // Name of the file to read/ //...
  20. chandler

    multiple arrays from CSV file

    Hi, I'm trying to take a csv file and create an array for each "column". So far, everything I"ve seen deals with creating a multiple dimension array, but what I need are multiple arrays. Thanks. Chandler I ran over my dogma with karma!

Part and Inventory Search

Back
Top