> is it possible you're overriding the function name somewhere? Suggestion on this front is to put all your functions in a structure somewhere that won't get overwritten, something like "function" and then call it via:
Function.webdate(date) You can put functions into the request scope too, and that makes them available over all custom tags. As is said above, check you aren't overwriting "fixeddate" parameter anywhere. Paul > > -----Original Message----- > > From: David Phipps [mailto:[EMAIL PROTECTED]] > > Sent: 03 February 2003 15:30 > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] UDF problem > > > > > > Hi, > > > > I have a page that is running two update queries and both > > make use of a UDF > > which is cfincluded in the Application.cfm > > > > The first query uses the function and updates the db with no > > problem but > > the second call to the function thrwows the following error: > > > > Error Diagnostic Information > > > > An error occurred while evaluating the expression: > > > > > > "#fixedDate(attributes.webDate)#" > > > > Error near line 56, column 95. > > > > The symbol you have provided (fixedDate) is not the name of a > > function... > > > > Why am I able to call the function the first time and then > > not a second time? > > > > Is this a bug with UDF's? > > > > The two queries look like: > > > > This one works: > > > > <cfquery name="updateReleaseManagerPress" datasource="#request.dsn#" > > dbtype="ODBC"> > > UPDATE releaseManager > > SET releaseDate = <cfif > > attributes.immediateRelease EQ 1 > > AND attributes.isReleased NEQ 1><cfqueryparam > cfsqltype="CF_SQL_DATE" > > value="#Now()#"><cfelse><cfqueryparam cfsqltype="CF_SQL_DATE" > > value="#fixedDate(attributes.releaseDate)#"></cfif>, > > releaseTime = <cfqueryparam > > cfsqltype="CF_SQL_TIME" value="#attributes.releaseTime#">, > > immediateRelease = > > #attributes.immediateRelease#, > > releasedBy = > > '#session.currentuser.realname#', > > processedDate = <cfqueryparam > > cfsqltype="CF_SQL_DATE" value="#Now()#">, > > isReleased = 1 > > WHERE releaseid = '#attributes.releaseid#' > > </cfquery> > > > > This throws the error: > > > > <cfquery name="updateReleaseManagerWeb" datasource="#request.dsn#" > > dbtype="ODBC"> > > UPDATE releaseManager > > SET webRelease = #attributes.webRelease#, > > webDate = <cfif attributes.webDate IS NOT > > ""><cfqueryparam cfsqltype="CF_SQL_DATE" > > value="#fixedDate(attributes.webDate)#"><cfelse><cfqueryparam > > cfsqltype="CF_SQL_DATE" value="#Now()#"></cfif> > > WHERE releaseid = '#attributes.releaseid#' > > </cfquery> > > > > attributes.releaseDate = 03/02/03 > > attributes.webDate = 3/2/2003 > > > > > > > > > > Thanks > > > > Dave > > > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] For > > human help, e-mail: [EMAIL PROTECTED] > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
