> 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? Also Check your types of fields are they
> text or numbers do the need a ' on each site of the tag.
>
> <cfquery name="update_funds" datasource="#request.dsn#">
> UPDATE fundprevious
> Set thisday=#thisfundday#,fundid=#get_funds.fundid#,
> fundvalue='#previousValue#',
> timeofchange=#CreateODBCDate( Now())#
Where Record_id= #RecordID#? Changed them to what it really is.
> </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]
