Frontrange HEAT API – CallTicket GridField Collection

I’m trying to get a list of all the fields in the CallTicket Recordset.

I used Administrator New Field Wizard to Add two additional fields that I want to track.

I am able to successfully get all the fields except for one field. In the screenshot below, you can see two CheckListBoxes. One has the fields found and the other the fields needed. For some reason, I have to manually add the EmailTime field.


Pin It
Posted in Uncategorized | 2 Comments

Frontrange HEAT user Preferences

Where is the information for this User Preferences dialog stored?


Pin It
Posted in Uncategorized | Leave a comment

Expert System Research

This is the beginning of a project to create a simple expert system using Excel.

Rule Based Expert System PDF
Excel Test Engine

Pin It
Posted in Uncategorized | Leave a comment

Obama’s Benghazi Corrupt Media Family Tree: Check out this lineage of connections – Great Graphic!! |

Pin It
Posted in Uncategorized | Leave a comment

Check out @DPaswaters’s Tweet:

Pin It
Posted in Uncategorized | Leave a comment

Trey Gowdy Demands Answers On Benghazi


Pin It
Posted in Uncategorized | Leave a comment

MS SQL Query XML with namespaces

In the past, I have not been a huge fan of Namespaces. If you don’t understand them, it is difficult to grasp the concept.

This link from Microsoft TechNet is a good start. I just needed a more real world example.

First, look at the Microsoft TechNet Article, then look at the more complex example I have below.

Also, take a look at the W3Schools page about xml namespaces. They do have a purpose.

So, here is an example. Complete with a small sample of XML and a SQL code.

This code as been tested Microsoft SQL Server 2005.


If there were no namespace, then the path would be much simpler.

Pin It
Posted in code, SQL, xml | 1 Comment

Tickld Mobile – 45 Ultimate Tips For Men. Number 40 Will Help You Go Far In Life.

Pin It
Posted in Uncategorized | Leave a comment

Crazy Field Names In the Database


I don’t know who named these fields, but it made me think of the Ack Cat when I worked with the following code.

Of particular interest is the variable named pod_pu_ack_diff.

Do you have any funny code that you have worked with? Any funny photos to go along with it?

Pin It
Posted in code, SQL | Leave a comment

VBScript Rest API

This week, I created a REST API to get the books of the bible.

Now, I know that this isn’t following all the rules, but the concept is getting closer. Instead of returning HTML, it may make sense to simply return JSON or XML and parse programmatically.

To illustrate, check out this VBScript.

Then, the resulting output is HTML, which could be parsed too, but could be done better.

Pin It
Posted in Uncategorized | Leave a comment