Skip to content
  • Twitter
  • LinkedIn
  • GitHub
  • Instagram

Mark Fennell

Azure Architect / DBA / Web Developer

  • Resume
  • About Me
  • Creative
  • Contact

Month: March 2009

Oracle Function to Create CFQuery

10 March 200911 March 2009 mark fennellColdFusion

Rather than creating insert and update queries in ColdFusion against an Oracle database, this function can generate the code for you. I haven’t added cfqueryparam to check the datatypes, but that would be ideal at helping prevent SQL Injection attacks.

Oracle Function to Create CFForm

10 March 200911 March 2009 mark fennellColdFusion

If you use table and column comments, you can create an Oracle function that will create insert and update forms for you complete with table formatting and data type form fields that are limited to the number of chars in a column.

Mark Fennell

exceptional IT professional; motivated, insightful, customer-focused; curious listener; database administrator; web application developer; models complex business processes;

Latest Tweets

  • mfdba
    @mfdba
    What do you get when your snowflake model melts? A data lake.

    8 months ago
  • mfdba
    @mfdba
    Obfuscation: It's what happens to the ketchup when you know it's in the fridge but it's been moved from the shelf o… https://t.co/TOR3Tp119R

    1 year ago
  • mfdba
    @mfdba
    It's really quite amazing how far web browsers have come and how far web developers push the boundaries. https://t.co/r4C3BijwpS

    2 years ago
  • mfdba
    @mfdba
    Hiija 9 in 1 Network Crystal Light Kit Professional Cat6 Earrings Rj45 Crimp Tool Mahjongg Tiles - Read the descrip… https://t.co/TS73CXAMV5

    2 years ago
  • mfdba
    @mfdba
    I don't usually stumble across an article from 1996, but when I do, it's because I'm dealing with an AS400. https://t.co/bsKWQawjMX

    2 years ago
  • mfdba
    @mfdba
    Spent some time with #mssql 2008 R2 today. Support ends in a few short months. https://t.co/i0p8ZJoRyr

    2 years ago

Tags

JavaScript ColdFusion Oracle Programming NoSQL Linux Azure PowerShell Personal Other General SQL Server Aquariums CSS

Admin

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress | Theme: Amadeus by FlyFreeMedia.