• Home
  • Family
    • Esther
    • Jeremiah
    • Gabe
    • Spencer
    • Brigg
  • Posts
  • Photos
  • Family Histories
  • Files
  • Links
    • Caveman Youth Football
    • FileMaker Hacks
    • FileMaker Solutions
    • Great Mac Software
  • About Me
    • Contact Me
    • Resume
  • Login
Layne Shipley

PERSONAL

Menu

  • Home
  • Family
    • Esther
    • Jeremiah
    • Gabe
    • Spencer
    • Brigg
  • Posts
  • Photos
  • Family Histories
  • Files
  • Links
    • Caveman Youth Football
    • FileMaker Hacks
    • FileMaker Solutions
    • Great Mac Software
  • About Me
    • Contact Me
    • Resume
  • Login
  • Computers,  ExecuteSQL,  FileMaker,  General

    ExecuteSQL Show 1 Row of Search Results

    05/01/2025 / No Comments

    I have query that do a find, sort the records, then I want to show only the first record:

    Read More
    Layne

    You May Also Like

    Importing JSON Data Into FileMaker

    07/10/2014

    Where You Can Find Your Plex App Downloads

    01/28/2022

    Have you ever wanted to Quote in a calculation field?

    07/10/2014
  • Computers,  ExecuteSQL,  FileMaker

    Multi Join FileMaker ExecuteSQL Query

    12/17/2024 / No Comments

    I have a client with a database that was over engineered. Rather build a set of overly complex relationships to find this data I attempted my first multi inner join query with SQL. The result was highly successful! Greatly reducing the speeding on reporting pages. The query finds country names, groups them by name, and sums the days the user is in country.

    Read More
    Layne

    You May Also Like

    Parsing JSON in FileMaker

    05/10/2022

    Gabe JV Football Videos

    05/02/2025

    Maximum hits/per minute or second

    07/10/2014
  • Computers,  FileMaker

    Missing FileMaker ExecuteSQL Documentation

    11/18/2024 / No Comments

    https://filemakerhacks.com/2012/10/19/the-missing-fm-12-executesql-reference/ Very useful article!

    Read More
    Layne

    You May Also Like

    Unicode Information

    07/10/2014

    Downloading the Free U2 Album in iTunes

    09/10/2014

    Sending Email via FileMaker and Gmail

    07/10/2014
  • Computers,  ExecuteSQL,  FileMaker,  General

    ExcuteSQL Dashboards and Charts

    03/13/2023 / No Comments

    Read More
    Layne

    You May Also Like

    WordPress Front-end Editor Error

    10/10/2014

    XML parsing error: whitespace expected

    07/10/2014

    Emron

    04/01/2014
  • Computers,  FileMaker,  General

    ExecuteSQL Function Basics: free training webinar for FileMaker

    03/11/2023 / No Comments

    Read More
    Layne

    You May Also Like

    XML parsing error: whitespace expected

    07/10/2014

    Why We Shoot Deer in the Wild

    03/15/2021

    WordPress Front-end Editor Error

    10/10/2014
  • Computers,  MacOS

    Software Company to Keep an Eye On for Mac Users

    05/18/2022 / No Comments

    They make a email server, web server, webdav server, dns server, and more. All very affordable and fairly easy to use. From their website… “Art & Technology – A New Unity? Even PC users concede that the Mac’s great for art, graphics and design. But packed into even a tiny Mac Mini is everything that is needed to run a business on—host a web site, share your ideas, create a community, market your services, execute transactions, account for cash flows, coordinate a project team, share calendars, etc.  There’s a whole lot of powerful technologies built into every Mac – Apache, WebDav, Postfix, SMTP, POP, IMAP, Fetchmail, iCal, MySQL, SQLite, SSL,…

    Read More
    Layne

    You May Also Like

    Have you ever wanted to output quotes from a FileMaker calculation?

    07/17/2014
    BYU vs Utah Ruby

    Going to the Rugby National Championships!

    05/02/2014

    Sunday School Book of Mormon Disscussion

    04/13/2014
  • Computers,  FileMaker

    Parsing JSON in FileMaker

    05/10/2022 / No Comments

    https://www.soliantconsulting.com/blog/parsing-json-filemaker-16/

    Read More
    Layne

    You May Also Like

    Importing JSON Data Into FileMaker

    07/10/2014

    XML parsing error: whitespace expected

    07/10/2014

    Maximum hits/per minute or second

    07/10/2014
  • Computers,  Plex

    Where You Can Find Your Plex App Downloads

    01/28/2022 / No Comments

    I’ve recently added the Plex App to my Mac. One of the great new feature is that I can download files and it will save them locally. Generally, not a problem but on a phone or something it is great for spotty network connections. Download your music and go to the gym… don’t work about bad networks. One of the first questions i asked is where are these files saved? We’ll here’s the location for a mac: To view this i used the tool “Commander One” utility. You can keep this directory clean by just using the Plex App. You delete listened too or unused files.

    Read More
    Layne

    You May Also Like

    Sunday School Book of Mormon Disscussion

    04/13/2014

    Maximum hits/per minute or second

    07/10/2014

    Hosted FileMaker File Make Pre Upload Tips

    07/10/2014
  • Computers,  MU Wordpress,  Wordpress

    MU WordPress Lost Roles on One of the Sites

    06/26/2019 / No Comments

    I run a MU WordPress with several websites. One day I noticed that I was unable to add roles to the people on one of my sites. No matter what I did couldn’t get any roles to appear in the selector. Some how in one of my updates the prefix for this particular site wasn’t updated. I found a post telling me this: Following this line of thinking led me to change that particular database table name. Sure enough renaming the table worked! Previously it was named wp_89_user_roles. It needed to be named 64d_89_user_roles. Problems solved!

    Read More
    Layne

    You May Also Like

    Where You Can Find Your Plex App Downloads

    01/28/2022

    Maximum hits/per minute or second

    07/10/2014

    Sunday School Book of Mormon Disscussion

    04/13/2014
  • Computers,  General,  MacOS

    Creating Mac OS X Installer Flash Drives

    11/18/2017 / No Comments

    https://support.apple.com/en-us/HT201372

    Read More
    Layne

    You May Also Like

    Unicode Information

    07/10/2014

    Remove Duplicates from List() function

    07/10/2014

    Maximum hits/per minute or second

    07/10/2014
123

Menu

Recent Posts

  • Gabe Freshman Highlights
  • Gabe JV Football Videos
  • Gabe Mission Photos
  • ExecuteSQL Show 1 Row of Search Results
  • Multi Join FileMaker ExecuteSQL Query

Categories

  • American Fork
  • Baseball
  • Bitcoin
  • Blog
  • Brigg
  • BTCPayServer
  • Computers
  • Documents
  • ExecuteSQL
  • FileMaker
  • Football
  • Football
  • Gabe
  • Gardening
  • General
  • Laugh
  • MacOS
  • Mission
  • Moodle
  • MU Wordpress
  • Music
  • OS X Server
  • Plex
  • Religion
  • Rugby
  • Shipley
  • Spencer
  • Sports
  • Wordpress
  • WPLMS

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org