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...
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...
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...
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-
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...
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...
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...
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...
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) {...
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...
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.
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>";
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.