Sharing Ideas And Solutions <a href="index.cfm?fuseaction=idea.newsletter_subscribe">Our Newsletter</a> Downloadable Solutions PHP Classes For Small & Medium Enterprise Free For Non-Profit Organization Customer Feedback Contact Us Featured Web Template View More Templates MasRizal In Numbers * 25 years in business. * 6856 corporations in 67 countries have chosen our products and service. * 73.20% are using more than one solutions from us. - MasRizal & Partners -Enhancing Business With Trust CF_Query2FixWidth Custom Tag: CF_Query2FixWidthVersion: 1.0(c) 2007, MasRizal & Partners CF_Query2FixWidth is a quick solution to export ColdFusion query into a fixed width string.This tag doesn't require any COM, or DLL object. Just put the tag in your CF working directory and you're done! This tag supports all kind of fixed width data, including: Saving fixed width data to file. You can import CF Query to fixed width string using this tag and then write the data using <cffile>. Support UNIX and DOS file mode, as well as other line break delimiters. Support any kind of filler character. Support for left and right justification. Features Requirements Usage Application Example <h1> Easy to use! Support all kind of fixed width string.</h1>[h1] Support left and right justification.[/h1][h1] Support all kind of filler character.[/h1][h1] Fast process.[/h1][h1] Plain CF custom tag.[/h1][h1] Shared hosting friendly.[/h1][h1]Just copy this custom tag in your ColdFusion script directory, and you're set [/h1]Supported ColdFusion Server: ColdFusion MX 6, 6.1 ColdFusion 7 ColdFusion 8 on all operating systems.Note: #createobject# function must be allowed for this tag to run. Supported browsers:Since this tag is working on server side, all browsers are compatible. <cf_query2fixwidth query="ColdFusion query " result="variable that holds resulting fixed width string" header="[header text]" footer="[footer text]" linebreak="[linebreak, default is carriage return followed by line feed (chr(13) & chr(10))]" startrow="[the first row to process]" endrow="[the last row to process, if 0 all the rest rows will be processed]"> <cf_q2fw_column Field="column name" Width="widht of column" FillChar="filler character. Default is space" Justify="left|right. Default is left "> <cf_q2fw_column ...> <cf_q2fw_column ...> </cf_query2fixwidth> This tag comes in handy when you need to export ColdFusion query to fixed width string for other system.Fixed width file is one of the most widely used file format for interchanging data. Most popular applications, such as Microsoft Excel is capable of reading and storing their data into a fixed width file. Below is list of applications where this tag will be useful: CF website that needs to export data to Excel and other applications capable of reading fix width filee. Check the word fixed width file to make sure that the target application can import fix width string. CF website that needs to write data to other data source. Most popular database, such as Microsoft Access, SQL Server, Oracle, mySQL has a tool to convert fixed width file to their data format. For a complete example please click this link (Open in new window) (Tabbed page powered by CF_Tab) Price License Purchase $50.00 1 Single developer $500.00 1 Site license $750.00 1 Corporate license Licensing Information Goods and services provided by MasRizal Sold by 2CheckOut.com Inc. (Ohio, USA). 2Checkout & MasRizal accepts customer orders via online checks, Visa, MasterCard, Discover, American Express, Dinners, JCB and debit cards with the Visa and MasterCard logo. PayPal and purchasing using your existing bank account are limited to US currency. CF_Query2FixWidth is available for immediate download. After you complete the order, you will receive a confirmation email with your download link. Please ensure your email address is entered correctly during the order process. Customers Who Purchased CF_Query2FixWidth Usually Purchased These Products Too 1. CFX_Excel 2. CF_FixWidth2Query 3. CF_Tab 4. Query2CSV MX 5. Verify Image 6. CFX_ZipPassword 7. CSV2Query Why Customers Choose Us Find out why our valued customers choose MasRizal & Partners solutions. Click here to see their reasons Featured Customers More than 6850 companies rely on MasRizal & Partners solutions. Click here to see our featured customers Free For Non-Profit Organization MasRizal Charity program allows eligible nonprofit organizations to get MasRizal's products at no cost. Click here for program detail Testimonials Take the word of our clients Top Selling Products See our top selling products Let Us Help You Can't find solution you need? Click here to get solution from MasRizal.
CF_Query2FixWidth is a quick solution to export ColdFusion query into a fixed width string. This tag doesn't require any COM, or DLL object. Just put the tag in your CF working directory and you're done!
This tag supports all kind of fixed width data, including:
Saving fixed width data to file. You can import CF Query to fixed width string using this tag and then write the data using <cffile>.
Support UNIX and DOS file mode, as well as other line break delimiters.
Plain CF custom tag. Shared hosting friendly. Just copy this custom tag in your ColdFusion script directory, and you're set
Supported ColdFusion Server:
ColdFusion MX 6, 6.1
ColdFusion 7
ColdFusion 8
on all operating systems. Note: #createobject# function must be allowed for this tag to run.
Supported browsers: Since this tag is working on server side, all browsers are compatible.
<cf_query2fixwidth
query="ColdFusion query "
result="variable that holds resulting fixed width string"
header="[header text]"
footer="[footer text]"
linebreak="[linebreak, default is carriage return followed by line feed (chr(13) & chr(10))]"
startrow="[the first row to process]"
endrow="[the last row to process, if 0 all the rest rows will be processed]">
<cf_q2fw_column
Field="column name" Width="widht of column" FillChar="filler character. Default is space" Justify="left|right. Default is left ">
<cf_q2fw_column
...>
<cf_q2fw_column
...>
</cf_query2fixwidth>
This tag comes in handy when you need to export ColdFusion query to fixed width string for other system. Fixed width file is one of the most widely used file format for interchanging data. Most popular applications, such as Microsoft Excel is capable of reading and storing their data into a fixed width file.
Below is list of applications where this tag will be useful:
CF website that needs to export data to Excel and other applications capable of reading fix width filee. Check the word fixed width file to make sure that the target application can import fix width string.
CF website that needs to write data to other data source. Most popular database, such as Microsoft Access, SQL Server, Oracle, mySQL has a tool to convert fixed width file to their data format.
Goods and services provided by MasRizal
Sold by 2CheckOut.com Inc. (Ohio, USA).
2Checkout & MasRizal accepts customer orders via online checks, Visa, MasterCard, Discover, American Express, Dinners, JCB and debit cards with the Visa and MasterCard logo.
PayPal and purchasing using your existing bank account are limited to US currency.
CF_Query2FixWidth is available for immediate download.
After you complete the order, you will receive a confirmation email with your download link.
Please ensure your email address is entered correctly during the order process.
Customers Who Purchased CF_Query2FixWidth Usually Purchased These Products Too
Free For Non-Profit Organization
MasRizal Charity program allows eligible nonprofit organizations to get MasRizal's products at no cost. Click here for program detail
Sharing Ideas And Solutions
For Designers!
Image Compressor 5
Featured Web Template
Features
Requirements
Usage
Application
Example
Licensing Information
