>I just saw a code sample, and verified it on the livedocs, basically: > ><cfquery datasource="dsn" sql="insert into ..."> > >Since when did cfquery have a sql attribute, and is this deprecated or >what?
Sure enough, I just found these docs on CF 1: http://docs.varda.nl/coldfusion/ch7b.htm#_Toc328065209 DBQUERY Attribute Explanation NAME A name which you assign to the query. Query names must begin with a letter and may consist of letters, numbers, and the underscore character (spaces are not allowed). The query name is used later in the template to reference the queries result set. DATASOURCE The name of the ODBC Data Source from which this query should retrieve data. SQL An SQL statement to be processed by the database. MAXROWS An optional attribute specifying the maximum number of rows you want returned in the result set. DEBUG An optional attribute used for debugging queries. Specifying this attribute causes the SQL statement actually submitted to the data source and the number of records returned from the query to be output. PS - It's funny to look back and see just how little functionality was in the first versions of ColdFusion: http://docs.varda.nl/coldfusion/ch7.htm -Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4