Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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