CFTABLE Can One Field Feed Many Columns

[metaphiz]

I'm trying to divide one database field across many columns without cutting off words in the middle, like on this page:

http://www.asheville-mortgage.com/ashford_mortgage_asheville_citizen_times4.cfm

I want to see if <cftable> will provide a solution. The tricky part is all the text is in one field, so <cftable> would have to be able to determine where to cut off the string so that no words are truncated.

 

[tlhawkins]

This can probably be accomplished with your SQL.
depending on your database you may be able to use SCALAR functions that will allow you to split a text field up into multiple fields thus feeding <cftable> multiple fields to populate your columns with.

some of the SCALARS that I know of are:
MID(c,start[,end])
LEN(c)
INSTR(c)
LEFT(c,number_of_char)
RIGHT(c,number_of_char)

where "c" is the name of your database field.

I hope that helps
Travis Hawkins
BeachBum Software

http://www.cfm2asp.com