<cfquery name="update_funds" datasource="#request.dsn#">
UPDATE fundprevious
Set thisday=#thisfundday#,fundid=#get_funds.fundid#,
fundvalue='#previousValue#',
timeofchange=#CreateODBCDate( Now())#
</cfquery>
Jim Louis
[EMAIL PROTECTED]
Best Meetings Inc.
>Things you could try:
>1. Run the query in the query analyzer to see if it works
>2. If it works, verify you can do a select of these fields in CF
>3. Verify restrictions in the advanced settings of your connection (in
>the CF admin)
>4. make sure the user for the connection has the proper rights on the
>table.
>
>>
If you are updating this should work, if you are inserting then, what is the name of the form or query this information if comming from. Try #form.thisfundday# possibly?
<cfquery name="update_funds" datasource="#request.dsn#">
UPDATE fundprevious
Set thisday=#thisfundday#,fundid=#get_funds.fundid#,
fundvalue='#previousValue#',
timeofchange=#CreateODBCDate( Now())#
</cfquery>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
