Andy Jarrett andyj

To install

$ git clone https://github.com/andyj/blogcfc2html.git
$ cd blogcfc2html
$ npm install

Once set up you need to edit the MySQL and outPath settings in the config.js file

	<html>
	<head>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="expires" content="mon, 01 jan 2010 00:00:01 gmt">
	<meta http-equiv="cache-control" content="no-cache">
	</head>
	<body>
	<!-- stuff here -->
	</body>
	</html>

	<cfsetting showdebugoutput="false" requesttimeout="10000" />
	<h1>Update Soundings UUID values to INT</h1>

	<cfset dsn = "YOUR_DSN_HERE" />


	<cfquery datasource="#dsn#">DROP TABLE IF EXISTS `uuids`</cfquery>

	<!--- Create the UUID table --->
	<cfquery datasource="#dsn#">

	<html>
	<head>
	<title>Look at WebSQL</title>
	<script>
	// Through the code below remember essentialy there are just 3 core methods we tend to use
	// openDatabase
	// transaction
	// executeSql

	// Opening a connection

	component persistent="true" table="tableWithTwoIds" alias="tableWithTwoIds"
	{
	property name="id" ormtype="int" generated="never" fieldtype="id" index="true";
	property name="typeofaddress" ormtype="int" fieldtype="id" index="true" ;

	}

	<cfset o2 = GetHttpRequestData() >
	<table>
	<cfloop collection="#o2.headers#" item="key" >
	<tr>
	<cfoutput>
	<th>#key#</th>
	<td>
	<cfif trim( key ) EQ "x-up-calling-line-id" >
	<span class="label important" >#o2.headers[key]#</span>
	<cfelse>

	$ mkdir expressWithLess && cd expressWithLess

	$ express --css less-middleware && npm install

	$ mv public/stylesheets/ public/styles

	$ nano public/styles/style.less

	@color: #00B7FF;
	body { padding: 200px; font: 18px "Lucida Grande", Helvetica, Arial, sans-serif; }

	// add the class "disabled" to the form
	$("form.disabled").find("input:not(:disabled), select:not(:disabled), textarea:not(:disabled)").prop("disabled",true);