what type of struct are you talking about here? a query resultset? a structure? doing any QoQ in your cfc? when you say "i am loading a from from a cfc" i presume you are talking about form's default values? where exactly are they coming from - direct db query, or a QoQ, or a querynew() or a manual structnew() creation some other query?
you can try adding a space in front of the value wherever the value is gotten from (i.e. in a query using your db's appropraite string concatenation function/operator)... then trim() it at output/insert... hth Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Jeremy Keith wrote: > I'm loading a form from a cfc, one of those fields is zipcode which up here > mostly contain a leading 0. > > The db object is varchar, and short of checking the string length upon return > and padding the 0 if it's only has a lenth of 4, is there any way to force > the struct data type to a string before it gets passed back to the calling > page? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
