Optimized SQL Lookups in Watch My Domains ISP

SQL Lookups: Tips & tricks

Watch My Domains ISP supports the use of SQL queries to control the lookups. You can used SQL queries to decide which domains are looked up and when.

The SQL Lookups ribbon button is meant for configuring and selecting the SQL queries that are used for lookups. The software comes with a number of SQL queries already pre-configured.

No Need to Type in the entire SQL query

Please note that you need not enter the full SQL query. You can enter from after the "WHERE" caluse...

SELECT * FROM [Domains] WHERE [Domain] LIKE '%-%'

may be entered as

[Domain] LIKE '%-%'

(This will find all domains that have a hyphen)

Custom SQL Queries

Watch My Domains ISP supports a few custom SQL queries that may be used to obtain data based on various run-time parameters like the current date or a user selection.

Here are a few examples.

• The [TODAY] parameter will be replaced with the current date.
• [TODAY+30] will be replaced with the date 30 days from today.
• [TODAY-5] will be replaced with the date 5 days prior to today.

An example,

[Registry Expiry] < #[TODAY+30]# ORDER BY [Registry Expiry]

The above SQL query will find all domains that will expire before 30 days from the current date.

Dynamic SQL Queries

You can make the software create SQL queries after prompting the user for a text entry. Here is the format..

{UITEXT:<Title>|<Prompt>:}

If you put the above in the SQL query, the user will get a dialog box with a title and text prompt. Then, whatever was entered by the user will be inserted in place of the above text.

Example

[Domain] LIKE '%{UITEXT:SQL Domain Query|Locate Domains That Match:}%'

will popup a dialog like the one shown on the right. If you enter web into the box and click OK, the following actual SQL statement will be generated.

[Domain] LIKE '%web%'

and all domains that have the term web in them will be found.

Using the user entry in multiple places in the same SQL

You can have the software prompt the user for an input and then use the user entry in multiple places within the SQL. Here is an example...

[NS1] LIKE '%{UITEXT:SQL NS Query|Locate Name Servers That Match:}%' OR [NS2] LIKE '%{UITEXT:}%' OR [NS3] LIKE '%{UITEXT:}%'

The above will prompt the user for "Locate Name Servers That Match:" and if the user enters softnik will create the following SQL query...

[NS1] LIKE '%softnik%' OR [NS2] LIKE '%softnik%' OR [NS3] LIKE '%softnik%'

This will find all domains that have 'softnik' in NS1, NS2 or NS3.