Sharing Ideas And Solutions Our Newsletter 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_FixWidth2Query Custom Tag: CF_FixWidth2QueryVersion: 1.0(c) 2007, MasRizal & Partners CF_FixWidth2Query is a quick solution to import fixed width string to ColdFusion query.This tag doesn't require any COM, DLL, or Java object. Just put the tag in your CF working directory and you're done! This tag supports all kind of fixed width data, including: Fixed width data from file. You can read the data using <cffile> and then import it to CF query using this tag. Support UNIX, Mac and DOS file mode, as well as other line break delimiters. Support any kind of filler character. Support for auto-trim value. Features Requirements Usage Application Example
Easy to use! Support all kind of fixed width string.
[h1] Fast process Create ColdFusion compatible query, just like querying a database using <cfquery> Comes with detailed report.[/h1][h1] It tells which row converted ok, and which is not.[/h1][h1] Support UNIX, Mac and DOS file mode, as well as other line break delimiters.[/h1][h1] Support any kind of filler character.[/h1][h1] Support for auto-trim value.[/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 5 ColdFusion MX 6, 6.1 ColdFusion 7 ColdFusion 8 on all operating systems Supported browsers:Since this tag is working on server side, all browsers are compatible. <cf_fixwidth2query fixedwidth="fixed width string you want to convert to CF query " result="[resulted query name]" report="[detailed report on result query, the default name is #yourresultname#_report]" 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_fw2q_column Field="column name" Width="widht of column" FillChar="filler character. Default is space" Trim="true|false. Default is true: trim the column"> <cf_fw2q_column ...> <cf_fw2q_column ...> </cf_fixwidth2query> This tag comes in handy when you need to import fixed width data from other system to your ColdFusion application.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 import data from Excel and other applications capable of storing its data into fixed width file. Check the word fixed width file to make sure that the source application can export its data to our needs. CF website that needs to read data from other data source. Most popular database, such as Microsoft Access, SQL Server, Oracle, mySQL has a tool to convert their data into plain fixed width file. Once the data has been exported to fixed width file, you can then import it to your application using this tag. 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_FixWidth2Query 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_FixWidth2Query Usually Purchased These Products Too 1. CFX_Excel 2. CF_Tab 3. CF_Query2FixWidth 4. Query2CSV MX 5. CSV2Query 6. Related Select 7. CF_Unzip 8. TrimVars 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_FixWidth2Query is a quick solution to import fixed width string to ColdFusion query. This tag doesn't require any COM, DLL, or Java object. Just put the tag in your CF working directory and you're done!
This tag supports all kind of fixed width data, including:
Fixed width data from file. You can read the data using <cffile> and then import it to CF query using this tag.
Support UNIX, Mac and DOS file mode, as well as other line break delimiters.
Create ColdFusion compatible query, just like querying a database using <cfquery>
Comes with detailed report. It tells which row converted ok, and which is not.
Support UNIX, Mac and DOS file mode, as well as other line break delimiters.
Support any kind of filler character.
Support for auto-trim value.
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 5
ColdFusion MX 6, 6.1
ColdFusion 7
ColdFusion 8
on all operating systems
Supported browsers: Since this tag is working on server side, all browsers are compatible.
<cf_fixwidth2query
fixedwidth="fixed width string you want to convert to CF query "
result="[resulted query name]"
report="[detailed report on result query, the default name is #yourresultname#_report]"
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_fw2q_column
Field="column name" Width="widht of column" FillChar="filler character. Default is space" Trim="true|false. Default is true: trim the column">
<cf_fw2q_column
...>
<cf_fw2q_column
...>
</cf_fixwidth2query>
This tag comes in handy when you need to import fixed width data from other system to your ColdFusion application. 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 import data from Excel and other applications capable of storing its data into fixed width file. Check the word fixed width file to make sure that the source application can export its data to our needs.
CF website that needs to read data from other data source. Most popular database, such as Microsoft Access, SQL Server, Oracle, mySQL has a tool to convert their data into plain fixed width file. Once the data has been exported to fixed width file, you can then import it to your application using this tag.
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_FixWidth2Query 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_FixWidth2Query 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