Skip navigation
Currently Being Moderated

Sql version of CF

May 6, 2011 5:20 AM

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

 
Replies
  • Currently Being Moderated
    May 6, 2011 5:24 AM   in reply to jimfid45

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

     

    --

    Adam

     
    |
    Mark as:
  • Currently Being Moderated
    May 26, 2011 7:02 PM   in reply to jimfid45

    @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 />

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points