Search results for query: *

Yes, UNION sounds good, but alas, my web host company has just upgraded to MySQL 3.23. UNION support starts in 4.0. I think I will have to make do with separate queries and separate the org from the individual listings.

COALESCE in the ORDER BY isn't working for me (yet) in MySQL. SELECT id, lname, fname, orgname, affiliation, url, comment FROM endorsers ORDER BY COALESCE(orgname, lname), fname; << Yields list with all orgnames in sort order after sorted individual names. Here is table def: CREATE TABLE...

I may have designed my table wrong, but I have a table with both organization and individual names. I would like for the table to sort by orgname AND individual_lname combined. Is there anyway to combine two columns for an ORDER BY? Something like this: ABC Company << orgname Barry Baker <<...

I am trying to use the FrontPage document check-in/check- out option on a new server. After check-out, during the same session, when I right click on the file to check-in there is no check-in option available. The file appears with a lock symbol and says that [userid] has the file checked out...

Is there anything to be done to prevent the &quot;imgXX is not defined&quot; error on a rollover when the server is slow serving up the images? We know that we have a slow server (client owned, so no help there). The rollovers are navigation buttons. Holding your mouse over them while the page...