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 Query2CSV MX Custom Tag: CF_Query2CSVMXVersion: 1.0(c) 2007, MasRizal & Partners CF_Query2CSVMX is a quick solution to export your query into CSV data.CF_Query2CSVMX does not need any 3rd party application to be installed on the server.Simply put this tag in the working directory and you're on! Compared to CF_Query2CSV, this CF_Query2CSVMX performs up to 4x faster than the CF 5 compatible tag. Features Requirements Usage Application Example
Convert ColdFusion query to CSV string Query can be from anything.
[h1] ColdFusion query from database, Query Of Query (QoQ), <cfhttp> call, <cfdirectory>, or even code generated query using #querynew# CSV string result.[/h1][h1] Means you can later save this string as text file, send it over to other application using <cfhttp> and so on.[/h1][h1] Works with all type of CSV delimiter Ultra fast performance Ability to select which rows and columns you want to convert Multi-platform.[/h1][h1] Can be installed in any operating system ColdFusion supports.[/h1][h1] Fastest deployment.[/h1][h1] No 3rd party application required.[/h1][h1] No CFX tags to install.[/h1][h1] Shared hosting friendly.[/h1][h1] Just copy this custom tag in the working directory and you are set.[/h1][h1] [/h1]Supported ColdFusion Server: ColdFusion MX 6, 6.1 ColdFusion 7 ColdFusion 8 on all operating systems.Note: For this tag to run, #createobject# function has to be enabled. Supported browsers:This tag works on server side, so all browsers are compatible <cf_query2csvmx query="[queryname you want to convert]" result="[csv string result]" delimiter="[delimiter, default is comma]" linebreak="[linebreak, default is carriage return followed by line feed (chr(13) & chr(10))]" textqualifier="[text qualifier, default is a double quote]" columnlist="[list of column names]" startrow="[the first row to process]" endrow="[the last row to process, if 0 all the rest rows will be processed]"> header="[Text before the CSV data]" footer="[Text after the CSV data]"> This tag comes in handy when you need to export data from your ColdFusion application to other system.Why CSV? CSV is one of the most widely used file format for interchanging data. Most popular applications, such as Microsoft Excel, Microsoft Outlook, Quickbooks, Yahoo Email, etc is capable of reading and storing their data into CSV format. Below is list of applications where this tag will be useful: CF website that needs to export its data tp Excel, Outlook, Quickbooks, and other applications capable of reading CSV data. Check the word 'CSV' or delimited file to make sure that the source application can import CSV data. CF website that needs to export data to other data source. Most popular database, such as Microsoft Access, SQL Server, Oracle, mySQL has a tool to read CSV file and retrieve data from it. Once the data has been exported to CSV, you can then import it to your other datasource. 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. Query2CSV MX 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 Query2CSV MX Usually Purchased These Products Too 1. CFX_Excel 2. CF_USPS_Track 3. CSV2Query 4. Query2CSV 5. Related Select 6. CF_Tab 7. XPToolbar - Encrypted version 8. TrimVars 9. CF_FlashUpload 10. CF_Query2FixWidth 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_Query2CSVMX is a quick solution to export your query into CSV data. CF_Query2CSVMX does not need any 3rd party application to be installed on the server. Simply put this tag in the working directory and you're on!
Compared to CF_Query2CSV, this CF_Query2CSVMX performs up to 4x faster than the CF 5 compatible tag.
Query can be from anything. ColdFusion query from database, Query Of Query (QoQ), <cfhttp> call, <cfdirectory>, or even code generated query using #querynew#
CSV string result. Means you can later save this string as text file, send it over to other application using <cfhttp> and so on...
Works with all type of CSV delimiter
Ultra fast performance
Ability to select which rows and columns you want to convert
Multi-platform. Can be installed in any operating system ColdFusion supports.
Fastest deployment. No 3rd party application required. No CFX tags to install. Shared hosting friendly. Just copy this custom tag in the working directory and you are set.
Supported ColdFusion Server:
ColdFusion MX 6, 6.1
ColdFusion 7
ColdFusion 8
on all operating systems. Note: For this tag to run, #createobject# function has to be enabled.
Supported browsers: This tag works on server side, so all browsers are compatible
<cf_query2csvmx
query="[queryname you want to convert]"
result="[csv string result]"
delimiter="[delimiter, default is comma]"
linebreak="[linebreak, default is carriage return followed by line feed (chr(13) & chr(10))]"
textqualifier="[text qualifier, default is a double quote]"
columnlist="[list of column names]"
startrow="[the first row to process]"
endrow="[the last row to process, if 0 all the rest rows will be processed]">
header="[Text before the CSV data]"
footer="[Text after the CSV data]">
This tag comes in handy when you need to export data from your ColdFusion application to other system. Why CSV? CSV is one of the most widely used file format for interchanging data. Most popular applications, such as Microsoft Excel, Microsoft Outlook, Quickbooks, Yahoo Email, etc is capable of reading and storing their data into CSV format.
Below is list of applications where this tag will be useful:
CF website that needs to export its data tp Excel, Outlook, Quickbooks, and other applications capable of reading CSV data. Check the word 'CSV' or delimited file to make sure that the source application can import CSV data.
CF website that needs to export data to other data source. Most popular database, such as Microsoft Access, SQL Server, Oracle, mySQL has a tool to read CSV file and retrieve data from it. Once the data has been exported to CSV, you can then import it to your other datasource.
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.
Query2CSV MX 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 Query2CSV MX 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