Take out the last , on your set (comments = '#form.comments#')
HTH
Dan
> <CFQUERY NAME="qDoUpdate" DATASOURCE="teleconference">
> UPDATE data
> SET
> conf_name = '#Form.conf_name#',
> conf_purpose = '#Form.conf_purpose#',
> conf_date = #Form.conf_date#,
> occurance = '#Form.occurance#',
> begin_time = '#Form.begin_time#',
> end_time = '#Form.end_time#',
> mod_name = '#Form.mod_name#',
> mod_phone = '#Form.mod_phone#',
> mod_station = '#Form.mod_station#',
> poc_name = '#Form.poc_name#',
> poc_phone = '#Form.poc_phone#',
> poc_station = '#Form.poc_station#',
> facilities = '#Form.facilities#',
> comments = '#Form.comments#',
> WHERE ID = #Form.ID#
> </CFQUERY>
>
> I can add and view records in the database.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
