CCK | the Worx Company

CCK

Mon, 10/19/2009 - 2:50pm

We had a client requirement that a single view be the combination of:

  1. a random list of attorneys with offices in a given state
  2. a random list of attorneys that are licensed in a given state.

There should be no duplications and all of list 1 must precede list 2. We could not accomplish this with views alone. After talking to Earl, we were able to access the created SQL statement within views. Here we built each of the two queries. Then, we defined a 'pre' exit and replaced the query in our view with a new one.

Subscribe to

Our Web development team has developed thousands of websites for clients, both local and national.

We would love to help you in your business.

855.243.2035

Phone Icon

Contact Us

email icon