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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by StuartBombay

  1. StuartBombay

    Add Constraint

    Ran this against the database, no results so there are not any user guids in the insert table that are not in the user table. SELECT NewUserGroups.UserGUID FROM NewUserGroups LEFT JOIN user ON NewUserGroups.UserGUID = user.guid WHERE user.tps_guid) Is Null The data for the insert table...
  2. StuartBombay

    Add Constraint

    I'm not sure what this is doing, but I'm guessing that it is checking the user table to make sure the ID (guid) exists in the user table before adding it to the user_group table? This constraint exists on the user table: ALTER TABLE [user_group] WITH CHECK ADD CONSTRAINT...
  3. StuartBombay

    php output to excel

    COM is a good thought, and I may go that way. Oddly, in at attempt to see if I could get a more descriptive error with the php function on the linux server, I commented out "or die" on the file open command. I now get the Open dialog and can open an instance of Excel, however nothing is written...
  4. StuartBombay

    php output to excel

    I was expecting it to open excel locally, not attempt to open it on the server.
  5. StuartBombay

    php output to excel

    Sadly, when I move from localhost to the linux box it cannot open excel.
  6. StuartBombay

    php output to excel

    Doh!, of course! I never thought of 'exit()'. I also had to move the header into !POST part of the if statement. I have about 5 blank rows at the beginning of the spreadsheet, I don't have empty records in my results... so I'll have to hunt that one down. Thanks again-
  7. StuartBombay

    php output to excel

    I used code authored by jpadie that I found on this forum, but I can't find the thread again. I took his code and made a function, and created a page to send a request to the function. It works, accept the spreadsheet that opens also has the HTML header and footer in it. All I want are the...
  8. StuartBombay

    leaning towards LIKE rather than FULLTEXT

    Doh! 'Go' to add columns! (head slap)
  9. StuartBombay

    leaning towards LIKE rather than FULLTEXT

    Yes, that does make sense. Thank you. I thought I had read that, but I couldn't see how to make MySqlAdmin combine columns in an index using it's interface. So, I could remove those fulltext indexes and use the SQL window to do something like - update people set... FULLTEXT KEY PLPSEARCH...
  10. StuartBombay

    One table with many columns or many tables with a few?

    I used to have the same questions. Then one day I was called upon to create a small app in access. It was a text-book type app that kept track of donations (orders), with forms for entering and reports to notify it's time to ask for more donations. My point is, after 4 re-writes I had a...
  11. StuartBombay

    leaning towards LIKE rather than FULLTEXT

    I thought fulltext sounded like the way to go at first, but now I think it's not the best option when searching for proper names. I want to be able to search against first, last, email username or employee number. Ideally it could find based on part of a name or employee number.I tried putting...
  12. StuartBombay

    array item count puzzle

    Ah! Thanks vacunita and southbeach! mysqli_num_rows($get_name_rs) returns exactly what's needed.
  13. StuartBombay

    array item count puzzle

    I can't figure out why the array count shows 1. If I copy the resulting SQL into the MySQL database I get 2 rows of results, but php is returning a count of 1. More puzzling is the while loop returns 2 names. I'm obviously not understanding something here! $get_name_sql = "SELECT fullname...
  14. StuartBombay

    seperating PHP and HTML

    Thank you - I had a feeling it had something to do with placement.
  15. StuartBombay

    seperating PHP and HTML

    Thanks vacunita, $display_block is initialized on line 8. <?php $page_title = 'PPS Site Summary - Employee Information'; include('header.html'); include('functions/form_functions.inc'); require('../../includes/configdb.inc'); require('../../includes/opendb.inc'); global $conn; if (!$_POST) {...
See more

Part and Inventory Search

Back
Top