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: *

  • Users: StuartBombay
  • Order by date
  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) {...
  16. StuartBombay

    seperating PHP and HTML

    I have this page, but when it runs on the form with the drop-down there is an error that states it can't fird $name on line 41, and on the results page is states it can't find the variable $display_block on line 50. I'm sure this is a case of I missed keeping the HTML from the PHP somewhere. Can...
  17. StuartBombay

    Trigger update based on another table

    I think I know what's wrong here. The trigger doesn't know what I mean by the small_schools table. I needs someplace to hold the data from that table (cursor??) to check against, rather than checking against the small_schools table. What I'm trying to accomplish is change the prognum for...
  18. StuartBombay

    Simple mailto concat to html

    Yup, that happens. I appreciate the response anyway. I didn't realized my error until I looked at the source in the browser. Once it worked I got brave enough to put it all on one line too. Looking at the source is an easy debugger, but I often forget to use it.
  19. StuartBombay

    Simple mailto concat to html

    Doh, didn't close the mailto. All of the lines after the Principal were disguised as the mailto. $display_block .="<li>Principal: $name"; $display_block .="<a href='mailto:"; $display_block .=$user; $display_block .="@somewhere.com'>Email $name</a>";
  20. StuartBombay

    Simple mailto concat to html

    I don't get an error with this, but I don't get a mailto link either. I'm happy I'm no longer getting parse errors though! caveat: this is an intranet form that will never travel outside the department. Everyone has the same email client, so using a mailto *shouldn't* get me into any trouble...

Part and Inventory Search

Back
Top