Sharing Ideas And Solutions <a href="index.cfm?fuseaction=idea.newsletter_subscribe">Our Newsletter</a> Downloadable Solutions PHP Classes For Small &amp; 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 &amp; Partners -Enhancing Business With Trust CF_FixWidth2Query Custom Tag: CF_FixWidth2QueryVersion: 1.0(c) 2007, MasRizal &amp; 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 &lt;cffile&gt; 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 <h1> Easy to use! Support all kind of fixed width string.</h1>[h1] Fast process Create ColdFusion compatible query, just like querying a database using &lt;cfquery&gt; 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. &lt;cf_fixwidth2query fixedwidth=&quot;fixed width string you want to convert to CF query &quot; result=&quot;[resulted query name]&quot; report=&quot;[detailed report on result query, the default name is #yourresultname#_report]&quot; linebreak=&quot;[linebreak, default is carriage return followed by line feed (chr(13) &amp; chr(10))]&quot; startrow=&quot;[the first row to process]&quot; endrow=&quot;[the last row to process, if 0 all the rest rows will be processed]&quot;&gt; &lt;cf_fw2q_column Field=&quot;column name&quot; Width=&quot;widht of column&quot; FillChar=&quot;filler character. Default is space&quot; Trim=&quot;true|false. Default is true: trim the column&quot;&gt; &lt;cf_fw2q_column ...&gt; &lt;cf_fw2q_column ...&gt; &lt;/cf_fixwidth2query&gt; 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 &amp; 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 &amp; Partners solutions. Click here to see their reasons Featured Customers More than 6850 companies rely on MasRizal &amp; 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.
fixed,fix,fusion,file,convert,string,custom,import,width,coldfusion,cold,excel,cf,delimiter,tag,fillerSharing Ideas And Solutions

Our Newsletter
Downloadable Solutions
Free For Non-Profit Organization
Customer Feedback
Contact Us
Image Compressor 2008.
Batch recompress, resize, rotate and watermark your image.
Save up to 10x more in any storage.
Speed up upload, download, and e-mail transmission time.
Featured Web Template
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_FixWidth2Query
Version: 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.
(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

2Checkout.com accepts PayPal 2Checkout.com accepts PayPal Pay Later 2Checkout.com accepts these debit and credit cards

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.
© Copyright 1999-2024 MasRizal & Partners
All Rights Reserved.
OISV - Organization of Independent Software Vendors - Contributing Member    Solutions for designers provided by TemplateMonster.com    Payment processing by 2Checkout    2Checkout.com supports Master Card Secure Code    2Checkout.com is verified by Visa
HALF PRICE SLASH TODAY!
Get 50% Discount
on Premium Component Collection

+ FREE Lifetime Upgrade.
Best Investment.


Offer valid until March 31, 2024

Use Coupon: HALFPRICE3
(Copy this coupon and use it during checkout)

Buy Premium Component Collection With 50% Discount

[ X Close This Window ]