• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Sql version of CF

Community Beginner ,
May 06, 2011 May 06, 2011

Copy link to clipboard

Copied

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

TOPICS
Database access

Views

679

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
May 06, 2011 May 06, 2011

Copy link to clipboard

Copied

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

--

Adam

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
May 26, 2011 May 26, 2011

Copy link to clipboard

Copied

LATEST

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation