access queries
update clients set lastresult='Answering Machine' and dialresult='202' where lastresult='none' and dialresult='01' and clientid<5567 Dialing by order name alpabetically: SELECT * from Clients WHERE DialResult = '01' ORDER BY Name DESC Dialing by specific zip code: The first query would be: select * from clients where dialresult='01' and zipcode='75001' the second query would be select * from clients where dialresult='01' and zipcode>75001 and zipcode<75205Related Articles
- Importing a national DNC file with ListMaker Pro (MySQL) version of SpitFire.
- Custom Query in SpitFire
- How to manually put a person’s number into the nocalls list. Pro version.
- Advanced Configuration Settings for SpitFire Predictive
- Names Not Showing on SpitFire Agent Software
Attachments
No attachments were found.Visitor Comments
No visitor comments posted. Post a commentPost Comment for "access queries"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.Article Details
Last Updated
20th of August, 2008
