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


Pin It
Posted in Uncategorized | Leave a comment

Check out @DPaswaters’s Tweet: https://twitter.com/DPaswaters/status/445298845899948032

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

REST Sample with Database

I was looking into creating a REST API, but what is a REST API? It is a Representational state transfer (REST). Whatever that means. To me, it is a way to interface with an application.

I’m going to demonstrate a simple application that uses a MySQL database to serve the names of the books of the bible and then show some basic information about those books.

I based this code on a tutorial created by Jason Everett.

Rest API – A simple PHP tutorial.

I was inspired to create a tutorial that showed how to connect the application to a database. What I am about to present is very similar to the application that Jason Created.

It has two functions named get_app_by_id() and get_app_list().

Here is the code for the Client

The code for the Server is where all the exciting database code is.  Of course you will need to change some of the values for your database, such as the username, password, and the name of the database.

Here is a link to the working demo:


Pin It
Posted in code, MySQL, SQL | Leave a comment

Update MySQL table from Another Table

Lets say that you have two tables.

One table called tblUser and another table called tblBookTypes.

You have the Number of chapters in the tblUser table as the MAX of ChapterNum.

Now, lets say that you want to update the table tblBookTypes with the value in MaxChapter.

Here is how you would do it.

And that is how you can perform an Update Query in MySQL on one table, with the MAX value of a field from another table.

Pin It
Posted in code, MySQL | Tagged , | Leave a comment

Using Graphviz to display a picture in a node

Here is a simple example of how to display an image inside of a node.


Pin It
Posted in Uncategorized | Leave a comment