Allen Hill

Recent Blog Comments By Allen Hill

• Ask Ben: Creating A Fixed-Field-Width Data File With ColdFusion

  Posted on Dec 6, 2008 at 10:10 PM

  Thanks all for the help. I guess I knew that about browsers but it didn't come to mind. Using CFMAIL, I successfully sent my new fixed width file to the person in charge of the next system for testing. Creating the body of an email doesn't condense the spaces. I may have to go back to 'creating ... read more »

• Ask Ben: Creating A Fixed-Field-Width Data File With ColdFusion

  Posted on Dec 5, 2008 at 2:19 PM

  That was it. The spaces are there in the source. Wow, so what you see is not always what you get. What is the easiest (shortest) way to write this to a file that will keep the spaces. Can I put the functioning <cfoutput inside a <cffile tag? What I am asking; is there a way to avoid the a... read more »

• Ask Ben: Creating A Fixed-Field-Width Data File With ColdFusion

  Posted on Dec 5, 2008 at 2:09 PM

  I am just writing to the screen <cfoutput query='q_DeptBill'> #replace(Ljustify(client,10),' ','.')##replace(Ljustify(matter,10),' ','.')# </cfoutput> or #Ljustify(client,10)##Ljustify(matter,10)# I kept all the complications out of the way that I could. There are of course many more ... read more »

• Ask Ben: Creating A Fixed-Field-Width Data File With ColdFusion

  Posted on Dec 5, 2008 at 1:33 PM

  I did that first (no dots) and it displayed the variable and added 1 space - I just put in the dots to make sure it was just 1 space. Ljustify is clearly not working for me and I don't know how to trouble shoot that . Allen... read more »

• Ask Ben: Creating A Fixed-Field-Width Data File With ColdFusion

  Posted on Dec 5, 2008 at 1:14 PM

  I guess I need CF for dummies disregarding fonts why does this code not work: <CFoutput query='q_DeptBill'> #replace(Ljustify(client,10),' ','.')# #replace(Ljustify(matter,10),' ','.')<br /> </CFoutput> client numbers are typically 6 digits, it outputs the client number and 1 d... read more »

• Ask Ben: Creating A Fixed-Field-Width Data File With ColdFusion

  Posted on Dec 5, 2008 at 11:30 AM

  Ben, I am having trouble duplicating your suggestion. We are on CF7 if that makes a difference. the line <cfset arrData = [] /> generates an error " ColdFusion was looking at the following text: [ " I already have a query but when applying the code to that query I get the same error. On a d... read more »