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]
