<cfquery name="somename" datasource="#application.datasource#">
update said_table
set
field1 = <cfqueryparam cfsqltype="" value="">,
field2 = <cfqueryparam cfsqltype="" value="">,
...
</cfquery>
also within <cf> tags, most of the time, you dont need #'s
<cfset lafile = file.clientfile> will work..
On Fri, 13 Aug 2004 16:11:47 -0400, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Greetings.
>
> I'm having problems with an add/delete/update form.
> The first 2 work great, but the third gives me a problem - the replaced file uploads, but it doesn't get put into the database as the new file name.
>
> Here's my coding:
>
> <CFif url.act eq "update">
> (Checks to see if update is required)
>
> <cfif #form.file_name_new# neq "">
> (Checks to see if the file itself is new or upgraded)
>
> <cfset "file_name" = "#file_name_new#">
> (If so, it gives the new file name value to the variable file_name)
>
> <cffile destination ="e:/Inetpub/wwwroot/newshimadzu/ssisales/#prod_group#/"
> action=""> > nameconflict="overwrite"
> filefield="file_name_new">
> (uploads the file)
>
> <cfset "file_name"="#file.clientfile#">
> (Uses the clientfile value as the new file_name value to be uploaded)
>
> <cfoutput>
> #file_name# and #file.clientfile#
> </cfoutput>
> (Something for my own checking)
>
> <CFUPDATE datasource="ssimain.mdb" tablename = "items" formfields = "ID,prod_group,main_category,prod_category,addl_breakout,apps_market,item_name,file_date,comments,file_name">
>
> (SHOULD update variables, including NEW file_name value, but it keeps the old one)
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
