2 Replies Latest reply: May 26, 2011 7:02 PM by cfwild RSS

    Sql version of CF

    jimfid45 Community Member

      Hello,

       

      The SQL commands one would execute in CF would be considered proprietary?  Are they T-SQL? ANSI SQL?

       

      Another words if you had to define the syntax of a SQL statements inside a cquery tag, what what you call that SQL?

       

      Thanks,

      Jim

        • 1. Re: Sql version of CF
          Adam Cameron. Community Member

          They're just passed, unmolested, to the DB driver, which passes them to the DB.  CF itself doesn't execute the SQL.

           

          --

          Adam

          • 2. Re: Sql version of CF
            cfwild Community Member

            @Jim

             

            The syntax of the query you have within a cfquery tag really depends on the type of database that you're querying.  So inside the cfquery tag, you're identifying the datasource="db_name".  Over in the CF Administrator, you're setting up the type of database (Access, MS SQL), defining the correct driver, and naming the db, e.g. "db_name".

             

            e.g. If you're writing a query for Access, you would use syntax appropriate for Access.  SQL

             

            e.g. If you're writing a query for MS SQL 2008, would use syntax appropriate for MS SQL 2008. T-SQL

             

            <cfwild />