Skip to main content
J
jimfid45
Known Participant
May 6, 2011
Question

Sql version of CF

  • May 6, 2011
  • 2 replies
  • 755 views

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

This topic has been closed for replies.

2 replies

A
Anonymous
May 27, 2011

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

A
Adam Cameron.
Inspiring
May 6, 2011

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

--

Adam

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices