SELECT SecLink FROM Security WHERE SecLink=16 AND UserLink=;OUTPUT NIL
.
INSERT INTO Office (OfficeName) VALUES ();FINISH
UPDATE Race SET OfficeLink= WHERE Office=;FINISH
SELECT DISTINCT Office DOffice FROM Race ORDER BY Office;OUTPUT EachOffice
INSERT INTO OfficeHonorific (OfficeLink,Honorific,HonorificAbbr) values (,,);OUTPUT NIL
SELECT OfficeID OfficeLink FROM Office WHERE OfficeName=;OUTPUT NIL
INSERT INTO Office (OfficeName,Honorific,HonorificAbbr) VALUES (,,);FINISH
eq '*Other - Enter Below'>
SELECT ContainerID as GeoC,ParentLink as GeoP,CategoryType FROM Container as c JOIN ContainerCategory as cc ON ContainerID= AND ContainerCategoryID=CategoryLink;OUTPUT NIL
SELECT * FROM Race WHERE RaceID=;OUTPUT NIL
INSERT INTO RaceLog (LogDate,RaceID,PartyLimit,PollStart,PollEnd,Title,Description,IsHTML,Type,LastModified,LMBy,KeyRace,
ParentContainer,GeoContainer,TakeOffice,Winner,FileDeadline,OfficeLink,HonorificLink,TermEnd,WinVotes,SecondVotes,AllVotes,Runoff,TakesSeat,Winner2,Precincts,
RPrecincts,IncParty,LeanPred,MaxWinners,ParentRace,KeyLevel,DataSources,Silly,FirstBy) VALUES (,
,,,,,
,,,,
,,,,,
,,,,,
,,,,,
,,,,
,,,,
,,);FINISH
UPDATE Race SET PartyLimit=,OfficeLink=,HonorificLink=,Type=,Title=,Description=,IsHTML=,Silly=,PollStart=,
PollEnd=,TakeOffice=,TermEnd=,FileDeadline=,LMBy=,LastModified=,
KeyRace=,GeoContainer=,Runoff=,TakesSeat=,MaxWinners=,ParentRace= WHERE RaceID=;OUTPUT NIL - Saved Changes
INSERT INTO Race (PartyLimit,OfficeLink,HonorificLink,Type,Title,Description,IsHTML,Silly,PollStart,PollEnd,TakeOffice,TermEnd,FileDeadline,FirstBy,FirstEnter,LMBy,LastModified,ParentContainer,GeoContainer,ParentRace,KeyRace,Runoff,TakesSeat,MaxWinners) VALUES
(,,,,,,,,,,,,
,,,,,,,,,,,);OUTPUT NIL
- Saved New Race
Adding Yes and No Candidates to Initiative Race.
INSERT INTO RaceMember (RaceLink,CandidateLink,PartyLink,Incumbent) VALUES (,4666,362,'');FINISH
INSERT INTO RaceMember (RaceLink,CandidateLink,PartyLink,Incumbent) VALUES (,4667,361,'Y');FINISH
SELECT RaceID,MaxWinners,Color,Name,CandidateID,FirstName,LastName,Photo,PollEnd,TakeOffice,TermEnd,WinVotes,SecondVotes,AllVotes FROM Race,Candidate,RaceMember,Party
WHERE ParentContainer= AND Type!='Primary Election' AND Type!='Primary Runoff' AND Type!='Run-Off' AND TakeOffice <=
AND CandidateID=Winner AND RaceLink=RaceID AND CandidateLink=Winner AND PartyID=RaceMember.PartyLink ORDER BY PollEnd DESC LIMIT 1;OUTPUT NIL
ne '0E0'>
INSERT INTO RaceMember (RaceLink,CandidateLink,PartyLink,Incumbent) VALUES (,,,'Y');OUTPUT NIL
SELECT FinalVoteTotal WinVotes,PartyID,Color,Name,CandidateID,FirstName,LastName,Photo FROM RaceMember,Candidate,Party WHERE RaceLink= AND CandidateID=CandidateLink AND PartyID=RaceMember.PartyLink ORDER BY Won DESC,FinalVoteTotal DESC LIMIT ;OUTPUT EachIncumbent
&HonorificLink=&PartyLimit=&Type=&Title=&Runoff=&TakesSeat=&MaxWinners=&FileDeadline=&PollStart=&PollEnd=&TakeOffice=&TermEnd=~>
UPDATE User SET MemorySave= WHERE UserID=;FINISH
UPDATE Race SET PartyLimit= WHERE RaceID=;FINISH
&URLFullDecode($in{Session_MemorySave});
SELECT * FROM Race WHERE RaceID=;OUTPUT NIL
SELECT ContainerID CID,Name CName FROM Container WHERE ContainerID=;OUTPUT NIL
SELECT ContainerID TCID,ParentLink PTC,Category PCCT FROM Container WHERE ContainerID=;OUTPUT NIL
SELECT EndDate RFiling FROM Event WHERE AttachTo='Container' AND AttachID= AND Type='Filing Deadline' AND TO_DAYS(EndDate) > (TO_DAYS(Now())-365) ORDER BY EndDate DESC LIMIT 1;OUTPUT NIL
SELECT StartDate RPOpen,EndDate RPClose FROM Event WHERE AttachTo='Container' AND AttachID= AND Type='Primary Election' AND TO_DAYS(EndDate) > (TO_DAYS(Now())-365) ORDER BY EndDate DESC LIMIT 1;OUTPUT NIL
SELECT StartDate RPOpenTime,EndDate RPCloseTime FROM Event WHERE AttachTo='Container' AND AttachID= AND Type='Primary Election' ORDER BY EndDate DESC LIMIT 1;OUTPUT NIL
SELECT StartDate RGOpen,EndDate RGClose FROM Event WHERE AttachTo='Container' AND AttachID= AND Type='General Election' AND TO_DAYS(EndDate) > (TO_DAYS(Now())-365) ORDER BY EndDate DESC LIMIT 1;OUTPUT NIL
SELECT StartDate RGOpenTime,EndDate RGCloseTime FROM Event WHERE AttachTo='Container' AND AttachID= AND Type='General Election' ORDER BY EndDate DESC LIMIT 1;OUTPUT NIL
,
,
SELECT Name LPtyName,Color LPtyColor FROM Party WHERE PartyID=;OUTPUT NIL
ne ''>
Add New Race
Return To Race Details Edit Candidates
|