that fixed it
pass the dunces cap
-----Original Message-----
From: Neculai Macarie [mailto:[EMAIL PROTECTED]
Sent: 22 March 2004 13:11
To: CF-Talk
Subject: Re: db error
Replace { with (:
<cfquery name="update_funds" datasource="#request.dsn#">
insert into fundprevious
(
thisday,
fundid,
fundvalue,
timeofchange
)
values
(
#thisfundday#,
#get_funds.fundid#,
'#previousValue#',
#Now()#
)
</cfquery>
<mack />
> Morning,
>
> I keep getting the following error when trying to update a database,
> haven't had any problems when doing this before but this error is
> peristent and I can't work out what the problem is:
>
> It appears to be a problem with the query as opposed to the data, the
> query is as follows:
>
> <!--- save current value into previous value --->
> <cfquery name="update_funds" datasource="#request.dsn#">
> insert into fundprevious
> {
> thisday,
> fundid,
> fundvalue,
> timeofchange
> }
> values
> {
> #thisfundday#,
> #get_funds.fundid#,
> '#previousValue#',
> #Now()#
> }
> </cfquery>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
