pageok
Executive Education, Inc. - Scheduled Public Seminars
[Executive Education, Inc. - Seminars for Corporate Financial Managers & Management Advisory Services]

Scheduled Public Seminars

Here are your search results. To search again, return to the Find Public Seminars page. Click on the seminar title to see a detailed description of the material that will be covered. For further questions you may call us at (734) 475-0600.

If you would like to register for an Executive Education seminar, please click on the link to the seminar sponsor's website.

 

<% function ConstructWhereClause(startDate, endDate, location, leader, semList) dim currClause ' if all parameters are set to some version of "give me everything", then just ' return an empty string. if startDate = "" and endDate = "" and location = anyString and leader = anyString and semList = anyString then ConstructWhereClause = "" exit function end if currClause = " WHERE " dim clauseCount clauseCount = 0 ' All comparisons are from seminarDates table which is abbriviated ' sd in the query. currClause = AddClause(currClause, "sd.Date >=", startDate, clauseCount, false, true) currClause = AddClause(currClause, "sd.Date <=", endDate, clauseCount, false, true) currClause = AddClause(currClause, "sd.StateProv =", location, clauseCount, true, false) currClause = AddClause(currClause, "sd.DiscussionLeader =", leader, clauseCount, true, false) currClause = AddClause(currClause, "sd.Seminar =", semList, clauseCount,true, false) ConstructWhereClause = currClause end function function AddClause(byref currString, dbCheck, toAdd, byRef clauseCount, quoteType, dateType) dim newClause newClause = "" if toAdd <> "" and toAdd <> anyString then if clauseCount > 0 then newClause = " AND " end if clauseCount = clauseCount + 1 if quoteType then toAdd = """" + toAdd + """" elseif dateType then toAdd = "#" + toAdd + "#" end if newClause = newClause + " " + dbCheck + " " + " " + toAdd end if AddClause = currString + " " + newClause end function dim semList dim leader dim location dim startDate dim endDate dim anyString anyString = "--Any--" semList = request.QueryString("seminarlist") leader = Request.QueryString("DLList") location = Request.QueryString("LocationList") startDate = Request.QueryString("StartDate") endDate = Request.QueryString("EndDate") dim query 'query = "SELECT * FROM SeminarDates " + ConstructWhereClause(startDate, endDate, location, leader, semList) dim whereClause whereClause = ConstructWhereClause(startDate, endDate, location, leader, semList) 'FOR DEBUGGING 'response.Write("

where clause - " + whereClause + "

") if len(whereClause) > 0 then whereClause = whereClause + " AND sd.Client = ass.AssocCode " else whereClause = "WHERE sd.Client = ass.AssocCode " end if query = "SELECT sd.*, ass.AssocCode as assid, ass.AssociationName as assname , " + _ "ass.WebSite as assurl, ass.StateProv as assloc FROM SeminarDates AS sd, Associations AS ass " + whereClause ListMatchingSeminars query + " ORDER BY DATE" %>