User Profile

Collapse

Profile Sidebar

Collapse
rjd1
rjd1
Last Activity: Oct 3 '14, 02:44 AM
Joined: Feb 15 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Query to Extract Distinct Substring after Specific Character & Provide Count Of Each

    Background: I am using ColdFusion to access an MS-Access database table via SQL.

    I have a membership list database table with four email address fields (email1, email 2, email3, email4) - all in the same table. (Some folks have multiple email addresses, often from different Email Service Providers - ESPs.)

    I need to develop an SQL query to produce a list of all the distinct ESPs (e.g. gmail.com, comcast.net, etc.)...
    See more | Go to post

  • trying to use variables in <cfquery> but they don't convert to values

    I'm not highly technical, and this is probably something simple, but here is

    my dilemma, where I am attempting to retrieve a single record using a variable name in the query.

    First, I define some variables:

    <cfset datasource = 'MyDatabase'>
    <cfset query_tbl = 'MyDatabaseTabl e'>
    <cfset field1 = 'actual_fieldna me1'><!--- FIRST field in MyDatabaseTable --->
    <cfset...
    See more | Go to post
No activity results to display
Show More
Working...