Polling Firms

eq ''> SELECT SecLink FROM Security WHERE SecLink=30 AND UserLink=;OUTPUT NIL DELETE FROM Discussion WHERE AttachTo='PollingFirm' AND AttachLink=;FINISH DELETE FROM NewsAttach WHERE AttachType='PollingFirm' AND AttachID=;FINISH DELETE FROM PollFirmBias WHERE PollFirmLink=;FINISH DELETE FROM PollingFirm WHERE PollingFirmID=;FINISHPolling Firm Deleted.
$in{ToFront}=~s/[^a-zA-Z0-9]//g; $in{OrderBy}=~s/[^a-zA-Z0-9\, ]//g; $in{OrderBy}=~s/DESC/ DESC/g; $in{OrderBy}=~s/PollingFirmName/PollingFirm\.Name/g; .SELECT COUNT(*) NC FROM Poll WHERE PollingFirmLink=;OUTPUT NIL UPDATE PollingFirm SET NumConducted= WHERE PollingFirmID=;FINISH SELECT PollingFirmID FROM PollingFirm;OUTPUTDone Counting Polls.
eq 'Search'> eq 'Previous Page'> eq 'Next Page'>

SELECT UserID,Nym FROM User WHERE UserID=;OUTPUT NIL >SELECT count(*) NumRecords FROM PollingFirm,Party WHERE 1=1 ne ''>AND PollingFirm.Name LIKE AND PartyID=PollingFirm.PartyLink;OUTPUT NIL SELECT PollingFirmID,PollingFirm.Name,PollingFirm.LastModified,DefaultContactType,PartyID,Party.Name PName,NumConducted,Points,AvgError,PollingFirm.Website,PollingFirm.LMBy,Points/(NumPointed+.000001) PPP FROM PollingFirm,Party WHERE 1=1 ne ''>AND PollingFirm.Name LIKE AND PartyID=PollingFirm.PartyLink ORDER BY LIMIT ,25;OUTPUT POLLING FIRM LIST +0 > 200> Name Default Contact Type Affiliation # Conducted Points Points per Poll Average Error Website               eq ''>N/A ne ''>Website   - of

Setting Default Contact Type.

SELECT ContactType FROM Poll WHERE PollingFirmLink= AND ContactType!='Unknown' ORDER BY PollStart DESC LIMIT 1OUTPUT NIL UPDATE PollingFirm SET DefaultContactType= WHERE PollingFirmID=;FINISH :
SELECT PollingFirmID,Name FROM PollingFirm ORDER BY NumConducted DESC,Name;OUTPUT