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!

Search results for query: *

  • Users: StuartBombay
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. StuartBombay

    Function to build drop down controlls

    I'm trying to build a function to use for creating drop downs. PHP 5, MySQL 5, Apache2. The configuration: configdb.inc <?php // Configure database $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'password'; $dbname = 'sitedata'; ?> The connection: opendb.inc <?php // Open the database...
  9. StuartBombay

    Create files 'on the fly'

    I have a recordset with information on about 20,000 people, and each of those people belong to one of about 30 different post offices. I would like to create a tab del file for each post office with the file named after the post office and populated with the people who belong to it. I would like...
  10. StuartBombay

    SUBSTRING limitation

    I know I may catch some flack for parsing strings in a SP, but it must be done. I'm having an issue with SUBSTRING, in the following code, if I up the '23' to '24' I get no results. If I up it to '25' I get the error "Invalid length parameter passed to the SUBSTRING function" DECLARE @TheOU...
  11. StuartBombay

    Update field based on join

    Help! I'm so close to creating this simple thing. I need to set a boolean in Table A to true based on a date in Table B. UPDATE message_recipient SET is_email_sent = '1' WHERE EXISTS ( SELECT * FROM user_message INNER JOIN message_recipient ON message_recipient.message_guid =...
  12. StuartBombay

    Select A Directory And Place Its Path Into A Field

    I'm using access 2003, I would like my users to be able to, from a form, browse to a file, then by selecting that file store the file's full path in a bound field of the underlying table. Starting with, what is the best method for browsing to the directory in the first place? Once I've...
  13. StuartBombay

    Create View with key field

    This may have been the wrong way to go about this, but here is what I've already done. I have a database that tracks support tickets. There is an incident table and other tables for notes, assignments, reminders, etc. that are stored in other related tables. In order to see these entries in...
  14. StuartBombay

    Search Database, results to list then open form

    Thanks to direction received on this forum, I now have a customer form with an orders sub-form. They are bound forms, they can be used to look up, change, or add customer and/or orders. The orders are plaques that can say just about anything on them. I would like to be able to hit a search...
  15. StuartBombay

    adding new records overwrites existing record

    My client wants all customer/order information on one form - they do now want to open a new form to add customers or orders. I created an unbound form for customers, I used unbound because I found that when using a bound form adding a new customer would overwrite existing ones. I have this...
  16. StuartBombay

    New Record, form query

    I have a company table and a sponsor table. Not all sponsors belong with a company, so I created a company called '*No Company' (asterisk so it will show first in list). My form is based on a query. The form has 2 combo boxes for selecting a record. Company (defaults to '*No Company) and Last...
  17. StuartBombay

    Find inactive customers

    We have a customer table, orders table, and customer plan table. We need to find customers on a certain plan that have not placed an order in over 3 months. Some customers have never placed an order at all, we need to know who they are too. Here is my code, the problem is if a customer has...

Part and Inventory Search

Back
Top