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]
