Well no what I'm asking why '#getFN()#' gives ' value '
and x= getFN(); '#x#' gives 'value' in cfquery. Thanks -----Original Message----- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 14 February 2003 10:50 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] FW: resend CFC question Justin, Are you asking why it trims the SQL in the function when called from another function? Paul > > Resend: > > > Hope the whitespace comes out right! > > I have a cfc like with a function like so: > > <cffunction name="save"> > <cfquery... > INSERT INTO Contact > > (ProductionContactBookID,FN) > VALUES > (1,'#getFN()#') > > </cfquery> > </cffunction> > > this produces the following SQL code (note whitespace) > > > INSERT INTO Contact > > (ProductionContactBookID,FN) > VALUES > (1,' > > > > MacCarthy;Justin;Gift;Mr;ESQ.' > ) > > however if a do this > > <cffunction name="save"> > <cfset fn = getFN() > > <cfquery... > INSERT INTO Contact > > (ProductionContactBookID,FN) > VALUES > (1,'#fn#') > > </cfquery> > </cffunction> > > the sql is like so > > INSERT INTO Contact > > (ProductionContactBookID,FN) > VALUES > > (1,'MacCarthy;Justin;Gift;Mr;ESQ.') > > > Why ? > > IF i just do > <cfoutput> > *#myojb.getFN()#* > </cfoutput> > > I get *MacCarthy;Justin;Gift;Mr;ESQ.* .. > > I have <cfcomponent output = "no"> > > Thanks > > > -- > ** 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] -- ** 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]
