davidwaterston

var now = (function() {

  // Returns the number of milliseconds elapsed since either the browser navigationStart event or 
  // the UNIX epoch, depending on availability.
  // Where the browser supports 'performance' we use that as it is more accurate (microsoeconds
  // will be returned in the fractional part) and more reliable as it does not rely on the system time. 
  // Where 'performance' is not available, we will fall back to Date().getTime().

  // jsFiddle: http://jsfiddle.net/davidwaterston/xCXvJ

davidwaterston

<cfcomponent name="geoPlugin" output="no">

    <cffunction name="ipLocation" access="remote" returntype="struct" displayname="ipLocation" output="no">
        
        <!--- 
        This function takes an IP address and passes it to http://www.geoplugin.net, a free GeoLocation service that
        returns info about where that IP address is located i.e. city, country, etc. The returned data from geoPlugin 
        is cleaned up and returned as a ColdFusion structure.
        Where the IP address is not passed in then geoPlugin.net will use the IP of the calling page. The IP used is 
        always returned in the 'geoplugin.request' variable.

davidwaterston

select table_name as found
from information_schema.tables 
where table_schema = '__database_name__' 
  and table_name = '__table_name__'

davidwaterston

select column_name
from information_schema.columns 
where table_schema = '__database_name__' 
  and table_name = '__table_name__'
  and column_name = '__column_name__'

davidwaterston

show tables like '__table_name__'

davidwaterston

select 1 
from __table_name__ 
limit 1

davidwaterston

select table_name as found
from information_schema.tables 
where table_schema = SCHEMA() 
  and table_name = '__table_name__'

davidwaterston

select table_name
from user_tables
where table_name = '__TABLE_NAME__'

davidwaterston

select column_name as found
from user_tab_cols
where table_name = '__TABLE_NAME__'
and column_name = '__COLUMN_NAME__'

davidwaterston

select 1
from __TABLE_NAME__
where rownum = 1