CFGRIDUPDATE

Used in a CFGRID, CFGRIDUPDATE allows you to perform updates to data sources directly from edited grid data. CFGRIDUPDATE provides a direct interface with your data source.

CFGRIDUPDATE first applies DELETE row actions followed by INSERT row actions and finally UPDATE row actions. Row processing stops if any errors are encountered.

Syntax

<CFGRIDUPDATE GRID="gridname"
    DATASOURCE="data source name"
    DBTYPE="type"
    DBSERVER="dbms"
    DBNAME="database name"
    TABLENAME="table name"
    USERNAME="data source username"
    PASSWORD="data source password"
    TABLEOWNER="table owner"
    TABLEQUALIFIER="qualifier"
    PROVIDER="COMProvider"
    PROVIDERDSN="datasource"
    KEYONLY="Yes" or "No">
GRID

Required. The name of the CFGRID form element that is the source for ...

Get Sams Teach Yourself ColdFusion® in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial