I can't get the tables to update using the following syntax:
<CFQUERY NAME="qUpdateRecords" DATASOURCE="#APPLICATION.DSN#">
UPDATE dbo.phone
SET Lname = '#ListGetAt(Lname,x)#',
Fname = '#ListGetAt(Fname,x)#',
Title = '#ListGetAt(Title,x)#',
Department = '#ListGetAt(Department,x)#',
Office = '#ListGetAt(Office,x)#',
<CFIF trim(ListGetAt(Phone,x)) contains 'n/a'>
Phone = NULL
<CFELSE>
Phone = '#ListGetAt(Phone,x)#'
</CFIF>
WHERE ID = #ListGetAt(UpdateTheseRecords,x)#
</CFQUERY>
Thanks Again,
Dave
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
