Re: MySQL Conversion
If you have no gaps in the autoid field in Access, you can create am additional field in MySQL for your Access ID, and order the Access table in ID order, then import it and the MYSQL autonumber field should match the Access ID field. if that is the case, you can then delete the extra field. If you have gaps and id is an essential data element that has relational children, it's a much more complex problem. If that is the case, let me know and I'll try to explain how to do it. On Tue, Apr 19, 2011 at 10:46 PM, Scott Williams myscottwilli...@yahoo.com wrote: Oy -- I shouldn't have started this one until the weekend. I'm converting from MS Access to MySQL on one of my ColdFusion sites, and having problems converting my Autonumbered Access tables to MySQL format. They just won't import at all. If I remove the primary key and change the format to Integer instead of Autonumber, the tables import. The real problem is when I try to add data to these tables later. It will take one additional record (numbering it 0), then won't take anymore because then there would be two 0s. How can I get a MySQL table to autonumber like Access? Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MySQL Conversion
how are you migrating your db? mysql used to have a migration toolkit as part of mysql gui tools bundle which handled access-mysql migration very well. the gui tools have now been replaced by mysql workbench, but you can still download them from mysql website. gui tools: http://dev.mysql.com/downloads/gui-tools/5.0.html workbench: http://dev.mysql.com/downloads/workbench/5.2.html mysql equivalent of access's autonumber type is an Integer column with auto_increment attribute. http://dev.mysql.com/doc/refman/5.5/en/numeric-types.html (bottom of page for auto_increment attr info) you can also set/change the next auto_increment value to use on mysql column: ALTER TABLE t2 AUTO_INCREMENT = value (from http://dev.mysql.com/doc/refman/5.5/en/alter-table.html) all this and much much more is covered in mysql reference manual on mysql website: http://dev.mysql.com/doc/ another point to keep in mind: if you cfqueries used any access-specific syntax you will have to re-write them to use proper sql to work with mysql db. Azadi On 20/04/2011 13:46 , Scott Williams wrote: Oy -- I shouldn't have started this one until the weekend. I'm converting from MS Access to MySQL on one of my ColdFusion sites, and having problems converting my Autonumbered Access tables to MySQL format. They just won't import at all. If I remove the primary key and change the format to Integer instead of Autonumber, the tables import. The real problem is when I try to add data to these tables later. It will take one additional record (numbering it 0), then won't take anymore because then there would be two 0s. How can I get a MySQL table to autonumber like Access? Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFinvoke in a CFfunction in a CFC
Your method isn't written correctly. You don't use cfparam to define arguments, but use the cfargument tag instead. Check the docs for the reference, but basically it is cfargument name=name of argument required='true or false and more args cfset Sanitize() / What then do you use CFParams for? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343864 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFinvoke in a CFfunction in a CFC
CFParam is used for setting and validating the existence of a variable, just not to pass or receive variables with a function. For that you use CFINVOKEARGUMENT when calling the function and CFARGUMENT in the function to receive the value. Also, if you are passing the values of form fields you can pass the form object to the function without needing a separate CFINVOKEARGUMENT or CFARGUMENT by using the argument collection parameter of the cfinvoke tag. cfinvoke component = component name or reference method = method name returnVariable = variable name argumentCollection = #form# ... Better instructions here. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=buildingComponents_28.html On Tue, Apr 19, 2011 at 11:18 PM, Adam Bourg adam.bo...@gmail.com wrote: Your method isn't written correctly. You don't use cfparam to define arguments, but use the cfargument tag instead. Check the docs for the reference, but basically it is cfargument name=name of argument required='true or false and more args cfset Sanitize() / What then do you use CFParams for ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343865 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Writing transparent gifs makes them grey
Thanks, How would I go about saving the image with cfhttp directly? Do you mean using cffile to save the cfhttp.Filecontent? Regards, Stefan On 20 Apr 2011, at 00:00, Leigh wrote: Cfimage has issues with gif files. Any chance of trying png files instead? Saving the image with cfhttp would avoid cfimage altogether. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MySQL Conversion
You would probably find it easier to upgrade to MSSQL, which is better anyway in so many ways than MySQL esp if you are on windows (speed, performance, reliability, scheduled backups, automated maintenance, no table corrupting issues, no horrid SQL dumps to name a few). Presumably if your using Access you must be on a windows host, so MSSQL is probably available to you. If you are choosing MySQL only because it is free, as many do, then remember that MSSQL Express is also FREE. You have an upgrade tool built in to MSACCESS, and Microsoft also provide free migration tools as well. just something to consider. On Wed, Apr 20, 2011 at 7:22 AM, Azadi Saryev azadi.sar...@gmail.comwrote: how are you migrating your db? mysql used to have a migration toolkit as part of mysql gui tools bundle which handled access-mysql migration very well. the gui tools have now been replaced by mysql workbench, but you can still download them from mysql website. gui tools: http://dev.mysql.com/downloads/gui-tools/5.0.html workbench: http://dev.mysql.com/downloads/workbench/5.2.html mysql equivalent of access's autonumber type is an Integer column with auto_increment attribute. http://dev.mysql.com/doc/refman/5.5/en/numeric-types.html (bottom of page for auto_increment attr info) you can also set/change the next auto_increment value to use on mysql column: ALTER TABLE t2 AUTO_INCREMENT = value (from http://dev.mysql.com/doc/refman/5.5/en/alter-table.html) all this and much much more is covered in mysql reference manual on mysql website: http://dev.mysql.com/doc/ another point to keep in mind: if you cfqueries used any access-specific syntax you will have to re-write them to use proper sql to work with mysql db. Azadi On 20/04/2011 13:46 , Scott Williams wrote: Oy -- I shouldn't have started this one until the weekend. I'm converting from MS Access to MySQL on one of my ColdFusion sites, and having problems converting my Autonumbered Access tables to MySQL format. They just won't import at all. If I remove the primary key and change the format to Integer instead of Autonumber, the tables import. The real problem is when I try to add data to these tables later. It will take one additional record (numbering it 0), then won't take anymore because then there would be two 0s. How can I get a MySQL table to autonumber like Access? Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343867 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: MySQL Conversion
then remember that MSSQL Express is also FREE limited to 4GB in size. if you definitely want to end up with MySQL then it would be easier to use the built in wizard to upsize from MSAccess to MSSQL then (if you still want to) ... convert from MSSQL to MySQL i would bother trying to use the MySQL Migration Tool Kit. ive never had much luck with this. I've converted many DBs from MS to My. So many that i bought some third party software to do it for me. takes about 30 seconds. Let me know if i can help out. zac Regards, Zac Wingfield Operations Manager For and on behalf of, Allied Facilities.com Limited 01903 723999 7 Wickham Business Centre Harwood Road Littlehampton West Sussex BN17 7AU For more information about Allied please visit: http://www.allied-facilities.com -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 20 April 2011 11:20 To: cf-talk Subject: Re: MySQL Conversion You would probably find it easier to upgrade to MSSQL, which is better anyway in so many ways than MySQL esp if you are on windows (speed, performance, reliability, scheduled backups, automated maintenance, no table corrupting issues, no horrid SQL dumps to name a few). Presumably if your using Access you must be on a windows host, so MSSQL is probably available to you. If you are choosing MySQL only because it is free, as many do, then remember that MSSQL Express is also FREE. You have an upgrade tool built in to MSACCESS, and Microsoft also provide free migration tools as well. just something to consider. On Wed, Apr 20, 2011 at 7:22 AM, Azadi Saryev azadi.sar...@gmail.comwrote: how are you migrating your db? mysql used to have a migration toolkit as part of mysql gui tools bundle which handled access-mysql migration very well. the gui tools have now been replaced by mysql workbench, but you can still download them from mysql website. gui tools: http://dev.mysql.com/downloads/gui-tools/5.0.html workbench: http://dev.mysql.com/downloads/workbench/5.2.html mysql equivalent of access's autonumber type is an Integer column with auto_increment attribute. http://dev.mysql.com/doc/refman/5.5/en/numeric-types.html (bottom of page for auto_increment attr info) you can also set/change the next auto_increment value to use on mysql column: ALTER TABLE t2 AUTO_INCREMENT = value (from http://dev.mysql.com/doc/refman/5.5/en/alter-table.html) all this and much much more is covered in mysql reference manual on mysql website: http://dev.mysql.com/doc/ another point to keep in mind: if you cfqueries used any access-specific syntax you will have to re-write them to use proper sql to work with mysql db. Azadi On 20/04/2011 13:46 , Scott Williams wrote: Oy -- I shouldn't have started this one until the weekend. I'm converting from MS Access to MySQL on one of my ColdFusion sites, and having problems converting my Autonumbered Access tables to MySQL format. They just won't import at all. If I remove the primary key and change the format to Integer instead of Autonumber, the tables import. The real problem is when I try to add data to these tables later. It will take one additional record (numbering it 0), then won't take anymore because then there would be two 0s. How can I get a MySQL table to autonumber like Access? Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MySQL Conversion
Yes mysql has a 4gb limit, for MSSQL there is also a limit of 10GB, please see this url http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx which is more than enough for most people. In fact we have been hosting SQL Server express since 2005, which did have a 4GB limit also, and no-one EVER came close to exceeding this. In fact the average databases are only a few hundred mb in size, so it really is not a problem. MySQL and MySQL also has limitations which require you to purchase the enterprise editions. But as with MSSQL express, these limitations do not affect your average user with a website and a database. If you need an enterprise solution, expect to pay for it. The very fact that you are upgrading from MSACCESS should really tell you that your database requirements are quite simple, so the limitations are unlikely to affects you. What I will say is that we have been hosting MSSQL for 10+ years (since MSSQL 2000) without any major issues and is pretty trouble free. We have been hosting mysql since v4 and some customers regularly have issues with tables getting corrupted (common issue), performance issues where 1 database can cause mysql to consume 100% cpu, row locking issues etc and certainly requires a lot more support, tweaking and trouble shooting. Clearly I have a preference for MSSQL, but issues like the above also lead me to generally recommend MSSQL over MySQL for anyone on windows, especially when both are free. You also need to make sure you understand the difference with the MySQL storage engines (MyISAM, INNODB) and use the appropriate one, otherwise this can cause many performance issues as well. You don't have any such issue with MSSQL, there are no different storage engines to learn, MSSQL pretty much just handles everything for you. The GUI tools that come with MSSQL also give you a lot more control out of the box, most people resort to using PHPMyAdmin instead for mysql, which is a web based tool. There are other free mysql GUI's. but in my experience to get the same level of features or control you really need to buy a copy of a commercial product like Navicat or similar. I think the overall biggest thing that makes a difference for me is backups. With MSSQL it is easy, setup a scheduled maintenance plan via the GUI to backup your database and also perform various tasks, such as optimise imdexes, shrink database, and much more. The backups whether done manually or scheduled are created very quick and are a single file which can be restored in seconds. In case of disaster a raw MSSQL database can also be copied to another server and attached. With MySQL (up to v5) you have to create a DUMP file of the entire database as SQL statements which re-insert the data. It is pretty clunky to say the least and can take hours to create or restore a dump if you have a large database. However you can at least do it via PHPMyAdmin or remote tools and save the dump locally. This is however the only way you can restore a MySQL database, if you backup the raw files, you cannot do much with them without a lot of hassle. On Wed, Apr 20, 2011 at 11:26 AM, Zac Wingfield z...@allied-facilities.comwrote: then remember that MSSQL Express is also FREE limited to 4GB in size. if you definitely want to end up with MySQL then it would be easier to use the built in wizard to upsize from MSAccess to MSSQL then (if you still want to) ... convert from MSSQL to MySQL i would bother trying to use the MySQL Migration Tool Kit. ive never had much luck with this. I've converted many DBs from MS to My. So many that i bought some third party software to do it for me. takes about 30 seconds. Let me know if i can help out. zac Regards, Zac Wingfield Operations Manager For and on behalf of, Allied Facilities.com Limited 01903 723999 7 Wickham Business Centre Harwood Road Littlehampton West Sussex BN17 7AU For more information about Allied please visit: http://www.allied-facilities.com -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 20 April 2011 11:20 To: cf-talk Subject: Re: MySQL Conversion You would probably find it easier to upgrade to MSSQL, which is better anyway in so many ways than MySQL esp if you are on windows (speed, performance, reliability, scheduled backups, automated maintenance, no table corrupting issues, no horrid SQL dumps to name a few). Presumably if your using Access you must be on a windows host, so MSSQL is probably available to you. If you are choosing MySQL only because it is free, as many do, then remember that MSSQL Express is also FREE. You have an upgrade tool built in to MSACCESS, and Microsoft also provide free migration tools as well. just something to consider. On Wed, Apr 20, 2011 at 7:22 AM, Azadi Saryev azadi.sar...@gmail.comwrote: how are you migrating your db? mysql used to have a
RE: Real head Scratcher
Richard, This error might occur when you make any changes to the ipi_photographer table adding or deleting a column. Are you changing that table at all? Also, is arguments .photographerID a numeric value? Do you qualify it somehow - perhaps by cfargument? -Mark -Original Message- From: Richard Steele [mailto:r...@photoeye.com] Sent: Wednesday, April 20, 2011 12:04 AM To: cf-talk Subject: Real head Scratcher Ok, I have a page that loads most of the time. However, occasionally it gives an error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. In verbose debugging the query that fails should be no problem whatsoever and in fact in runs fine in SQL but only 70% of the time when the page is refreshed. We are on CF8 Enterprise with two instances. What could be happening? Here's the verbose error message: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. The error occurred in C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 321 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 205 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 197 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 165 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 162 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results. cfm: line 63 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results. cfm: line 54 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results. cfm: line 1 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_ page.cfm: line 210 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm: line 5 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 321 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 205 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 197 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 165 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 162 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results. cfm: line 63 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results. cfm: line 54 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results. cfm: line 1 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_ page.cfm: line 210 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm: line 5 319 : cfquery name=qPhotographer dataSource=#ipi_dsn# 320 : SELECT * FROM ipi_photographers 321 : WHERE id = cfqueryparam CFSQLType=CF_SQL_INTEGER value=#arguments.photographerid# / 322 : /cfquery 323 : cfreturn qPhotographer / SQLSTATE HY000 SQLSELECT * FROM ipi_photographers WHERE id = (param 1) DATASOURCEphotoeyecom Resources: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 Remote Address 10.10.47.254 Referrer Date/Time 20-Apr-11 01:08 AM Stack Trace at cfsearch_brain2ecfc271777505$funcGETPHOTOGRAPHER.runFunction(C:\inetpub\wwwr oot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:321) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor1(C:\inetpub \wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:205) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor2(C:\inetpub \wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:197) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor3(C:\inetpub \wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:165) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR.runFunction(C:\inet pub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:162) at cfdsp_search_results2ecfm265917465.._factor0(C:\inetpub\wwwroot\Clients\phot oeyecom\html\iPi\includes\dsp_search_results.cfm:63) at cfdsp_search_results2ecfm265917465._factor6(C:\inetpub\wwwroot\Clients\photo eyecom\html\iPi\includes\dsp_search_results.cfm:54) at cfdsp_search_results2ecfm265917465.runPage(C:\inetpub\wwwroot\Clients\photoe yecom\html\iPi\includes\dsp_search_results.cfm:1) at cfdsp_search_results_page2ecfm2071414576.runPage(C:\inetpub\wwwroot\Clients\ photoeyecom\html\iPi\includes\dsp_search_results_page.cfm:210) at
Re: Writing transparent gifs makes them grey
How would I go about saving the image with cfhttp directly? Do you mean using cffile to save the cfhttp.Filecontent? Use the PATH and FILE attributes of CFHTTP to save the file directly. No need to use CFFILE here at all. http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7ffc.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Writing transparent gifs makes them grey
Great, thanks Dave. On 20 Apr 2011, at 15:07, Dave Watts wrote: How would I go about saving the image with cfhttp directly? Do you mean using cffile to save the cfhttp.Filecontent? Use the PATH and FILE attributes of CFHTTP to save the file directly. No need to use CFFILE here at all. http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7ffc.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Real head Scratcher
Try adding Val() around the arguments.photographerid as 319 : cfquery name=qPhotographer dataSource=#ipi_dsn# 320 : SELECT * FROM ipi_photographers 321 : WHERE id = cfqueryparam CFSQLType=CF_SQL_INTEGER value=#val(arguments.photographerid)# / 322 : /cfquery 323 : cfreturn qPhotographer / IF it works, it means occasionally you are sending in a blank value when it requires an integer ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343873 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Modal Color of CFWindow
I am trying to figure out how to change the color of the background when you open a new cfwindow in modal mode. I want to make it darker so you cannot see the stuff behind it as well. How can I do that? Any help would be great. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343874 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Creating COM object - troubleshooting
Isn't all code in existence based off of code originally written by Ben Nadel? .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Eric Roberts [mailto:ow...@threeravensconsulting.com] Sent: Tuesday, April 19, 2011 11:26 AM To: cf-talk Subject: RE: Creating COM object - troubleshooting Here are the cfcs we developed based off of code originally developed by ben Nadel...some of the modification ideas were based off another site as well and I am drawing a complete blank, at the moment, who that blogger was...so if you remember the convo we had, please pop up ;-) Banner.cfc has some of the functions in imageUtils...tweaked a bit so as to work abit more efficiently. Some of the simpler functions can be replicated using the cfimage tag directly. !---Begin ImageUtils.cfc--- !--- Modified code developed by Eric Roberts based off of code originally developed by Ben Nadel --- cfcomponent output=false hint=Image utility functions that abstract out complex ColdFusion image manipulation processes. cffunction name=Init access=public returntype=any output=false hint=Returns an initialized component. !--- Return This reference. --- cfreturn THIS / /cffunction !--- Function: aspectCrop Author: Emmet McGovern http://www.illequipped.com/blog em...@fullcitymedia.com 2/29/2008 - Leap Day! --- cffunction name=aspectCrop access=public returntype=any output=false hint= !--- Define arguments. --- cfargument name=image type=any required=true hint=The ColdFusion image object or path to an image file. / cfargument name=cropwidth type=numeric required=true hint=The pixel width of the final cropped image / cfargument name=cropheight type=numeric required=true hint=The pixel height of the final cropped image / cfargument name=position type=string required=true default=center hint=The y origin of the crop area. / !--- Define local variables. --- cfset var nPercent = / cfset var wPercent = / cfset var hPercent = / cfset var px = / cfset var ycrop = / cfset var xcrop = / !--- If not image, assume path. --- cfif ( (NOT isImage(arguments.image)) AND (NOT isImageFile(arguments.image)) ) cfthrow message=The value passed to aspectCrop was not an image. / /cfif !--- If we were given a path to an image, read the image into a ColdFusion image object. --- cfif isImageFile(arguments.image) cfset arguments.image = imageRead(arguments.image) / /cfif !--- Resize image without going over crop dimensions--- cfset wPercent = arguments.cropwidth / arguments.image.width cfset hPercent = arguments.cropheight / arguments.image.height cfif wPercent gt hPercent cfset nPercent = wPercent cfset px = arguments.image.width * nPercent + 1 cfset ycrop = ((arguments.image.height - arguments.cropheight)/2) cfset imageResize(arguments.image,px,) / cfelse cfset nPercent = hPercent cfset px = arguments.image.height * nPercent + 1 cfset xcrop = ((arguments.image.width - arguments.cropwidth)/2) cfset imageResize(arguments.image,,px) / /cfif !--- Set the xy offset for cropping, if not provided defaults to center --- cfif listfindnocase(topleft,left,bottomleft, arguments.position) cfset xcrop = 0 cfelseif listfindnocase(topcenter,center,bottomcenter, arguments.position) cfset xcrop = (arguments.image.width - arguments.cropwidth)/2 cfelseif listfindnocase(topright,right,bottomright, arguments.position) cfset xcrop = arguments.image.width - arguments.cropwidth cfelse cfset xcrop = (arguments.image.width - arguments.cropwidth)/2 /cfif cfif listfindnocase(topleft,topcenter,topright, arguments.position) cfset ycrop = 0 cfelseif listfindnocase(left,center,right, arguments.position) cfset ycrop = (arguments.image.height -
will not export excel to excel
I am trying to output the results of a query to Excel, but instead, it opens CF Builder. Please advise. TNX. cfquery name=gettemp datasource=#application.datasource# select location,score from SPDOut where SPDINput_id=#url.id# order by location /cfquery cfsetting enablecfoutputonly=yes !--- Required for CSV export to function properly --- cfset delim = 44 !--- Use a comma for a field delimitter, Excel will open CSV files --- cfcontent type=application/msexcel cfheader name=Content-Disposition value=#url.id#-export.csv !--- Output Column Headers --- cfoutputLocation#chr(delim)#Score#chr(delim)#/cfoutput cfoutput#chr(13)#/cfoutput !--- line break after column header --- !--- Spill out data from a query --- cfloop query=gettempcfoutput#location##chr(delim)##score##chr(13)#/cfoutput/cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Creating COM object - troubleshooting
Only that which is not based on code written by Ben Forta or Ray Camden. On Wed, Apr 20, 2011 at 2:43 PM, Bobby Hartsfield bo...@acoderslife.com wrote: Isn't all code in existence based off of code originally written by Ben Nadel? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343877 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
OT question - is this real or phishing?
Has anyone received emails like this for any of their domains? I'm trying to decide if this is some far fetched phishing expedition or a serious inquiry. I do own the domain in question and it's also registered as business in the state of Minnesota under my name. I may reply to this anyways, but with extreme caution. Dear PresidentCEO, This is a Network Service Company which is the domain name registration center in HongKong,China. On April.19, 2011, we received an application from Meihua Holdings Group requestedchristianmp3 as their internet trademark keyword and China (CN) domain names. But after checking ,we find this name is conflict with your company's name or trademark. In order to deal with this issue better, it's necessary to send this email to you and confirm with your company whether this company is your distributor or business partner in China? If you did not authorize, please let us know within 7 workdays, so that we will handle this issue better. Looking forward to your reply Best regards, Linda Linda Zhou Checking Department HongKong Office(Head Office) HongKong China Technology Ltd Thanks, Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343878 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OT question - is this real or phishing?
It screams scam... Especially considering China is hardly known for caring about intellectual property rights. It couldn't hurt to contact them back and say No, I don't know them. And then see what happens. My guess is this email was step one in a scam to solicit money from you. =] -- Alan Rother Manager, Phoenix Cold Fusion User Group, www.AZCFUG.org Twitter: @AlanRother ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343879 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OT question - is this real or phishing?
On Wed, Apr 20, 2011 at 6:27 PM, Wil Genovese jugg...@trunkful.com wrote: Has anyone received emails like this for any of their domains? I'm trying to decide if this is some far fetched phishing expedition or a serious inquiry. I do own the domain in question and it's also registered as business in the state of Minnesota under my name. I may reply to this anyways, but with extreme caution. They are trying to drum up business, I had one similar to that the other day for dvsdjtv.com Right to the trash bin, I don't need a .cn or .com.cn and don't care if someone registers it in China * Dear Manager: This email is from China domain name registration center, which mainly deal with the domain name registration and dispute internationally in China and Asia. On April 10th 2011, We received HAITONG company's application that they are registering the name dvsdjtv as their Internet Keyword and dvsdjtv .cnã dvsdjtv .com.cn ã dvsdjtv .asia domain names etc.., It is China and ASIA domain names. But after auditing we found the brand name been used by your company. As the domain name registrar in China, it is our duty to notice you, so I am sending you this Email to check. According to the principle in China, your company is the owner of the trademark, In our auditing time we can keep the domain names safe for you firstly, but our audit period is limited, if you object the third party application these domain names and need to protect the brand in china and Asia by yourself, please let the responsible officer contact us as soon as possible. Thank you! Best regards, John Oversea marketing manager * ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343880 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OT question - is this real or phishing?
We get them all the time for several B-to-B domains that are popular in China. Just DELETE and move on. It's spam. On 4/20/2011 6:37 PM, Casey Dougall wrote: On Wed, Apr 20, 2011 at 6:27 PM, Wil Genovesejugg...@trunkful.com wrote: Has anyone received emails like this for any of their domains? I'm trying to decide if this is some far fetched phishing expedition or a serious inquiry. I do own the domain in question and it's also registered as business in the state of Minnesota under my name. I may reply to this anyways, but with extreme caution. They are trying to drum up business, I had one similar to that the other day for dvsdjtv.com Right to the trash bin, I don't need a .cn or .com.cn and don't care if someone registers it in China * Dear Manager: This email is from China domain name registration center, which mainly deal with the domain name registration and dispute internationally in China and Asia. On April 10th 2011, We received HAITONG company's application that they are registering the name dvsdjtv as their Internet Keyword and dvsdjtv .cnã dvsdjtv .com.cn ã dvsdjtv .asia domain names etc.., It is China and ASIA domain names. But after auditing we found the brand name been used by your company. As the domain name registrar in China, it is our duty to notice you, so I am sending you this Email to check. According to the principle in China, your company is the owner of the trademark, In our auditing time we can keep the domain names safe for you firstly, but our audit period is limited, if you object the third party application these domain names and need to protect the brand in china and Asia by yourself, please let the responsible officer contact us as soon as possible. Thank you! Best regards, John Oversea marketing manager * ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343881 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Creating COM object - troubleshooting
or the many others who have open source projects at www.riaforge.org On Wed, Apr 20, 2011 at 11:19 PM, Maureen mamamaur...@gmail.com wrote: Only that which is not based on code written by Ben Forta or Ray Camden. On Wed, Apr 20, 2011 at 2:43 PM, Bobby Hartsfield bo...@acoderslife.com wrote: Isn't all code in existence based off of code originally written by Ben Nadel? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OT question - is this real or phishing?
Think about it this way. Do a CBA: What is the most you lose if you don't answer the email. What is the most you could lose if you do. Probably nothing, but chances are that this email is of nefarious origin. My $0.02 and worth every penny. G! On Wed, Apr 20, 2011 at 6:47 PM, Jason Fisher ja...@wanax.com wrote: We get them all the time for several B-to-B domains that are popular in China. Just DELETE and move on. It's spam. On 4/20/2011 6:37 PM, Casey Dougall wrote: On Wed, Apr 20, 2011 at 6:27 PM, Wil Genovesejugg...@trunkful.com wrote: Has anyone received emails like this for any of their domains? I'm trying to decide if this is some far fetched phishing expedition or a serious inquiry. I do own the domain in question and it's also registered as business in the state of Minnesota under my name. I may reply to this anyways, but with extreme caution. They are trying to drum up business, I had one similar to that the other day for dvsdjtv.com Right to the trash bin, I don't need a .cn or .com.cn and don't care if someone registers it in China * Dear Manager: This email is from China domain name registration center, which mainly deal with the domain name registration and dispute internationally in China and Asia. On April 10th 2011, We received HAITONG company's application that they are registering the name dvsdjtv as their Internet Keyword and dvsdjtv .cnã dvsdjtv .com.cn ã dvsdjtv .asia domain names etc.., It is China and ASIA domain names. But after auditing we found the brand name been used by your company. As the domain name registrar in China, it is our duty to notice you, so I am sending you this Email to check. According to the principle in China, your company is the owner of the trademark, In our auditing time we can keep the domain names safe for you firstly, but our audit period is limited, if you object the third party application these domain names and need to protect the brand in china and Asia by yourself, please let the responsible officer contact us as soon as possible. Thank you! Best regards, John Oversea marketing manager * ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OT question - is this real or phishing?
anyone can register any domain, it is an automated system, seriously, do you think someone manually checks every single domain to see whether it might be infringing on anyone else's name or copyright. It is a scam, just like the letters you get from Domain registrar of America telling you your domain is about to expire. On Thu, Apr 21, 2011 at 12:03 AM, Gerald Guido gerald.gu...@gmail.comwrote: Think about it this way. Do a CBA: What is the most you lose if you don't answer the email. What is the most you could lose if you do. Probably nothing, but chances are that this email is of nefarious origin. My $0.02 and worth every penny. G! On Wed, Apr 20, 2011 at 6:47 PM, Jason Fisher ja...@wanax.com wrote: We get them all the time for several B-to-B domains that are popular in China. Just DELETE and move on. It's spam. On 4/20/2011 6:37 PM, Casey Dougall wrote: On Wed, Apr 20, 2011 at 6:27 PM, Wil Genovesejugg...@trunkful.com wrote: Has anyone received emails like this for any of their domains? I'm trying to decide if this is some far fetched phishing expedition or a serious inquiry. I do own the domain in question and it's also registered as business in the state of Minnesota under my name. I may reply to this anyways, but with extreme caution. They are trying to drum up business, I had one similar to that the other day for dvsdjtv.com Right to the trash bin, I don't need a .cn or .com.cn and don't care if someone registers it in China * Dear Manager: This email is from China domain name registration center, which mainly deal with the domain name registration and dispute internationally in China and Asia. On April 10th 2011, We received HAITONG company's application that they are registering the name dvsdjtv as their Internet Keyword and dvsdjtv .cnã dvsdjtv .com.cn ã dvsdjtv .asia domain names etc.., It is China and ASIA domain names. But after auditing we found the brand name been used by your company. As the domain name registrar in China, it is our duty to notice you, so I am sending you this Email to check. According to the principle in China, your company is the owner of the trademark, In our auditing time we can keep the domain names safe for you firstly, but our audit period is limited, if you object the third party application these domain names and need to protect the brand in china and Asia by yourself, please let the responsible officer contact us as soon as possible. Thank you! Best regards, John Oversea marketing manager * ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OT question - is this real or phishing?
It is fake...NO registrar works in this manner. For fun I have followed up with the senders asking for proof that the other company is really asking to do what they sayonly had one guy actually reply...and it didn't go well for him ;-) In the end, anyone can register any domain they want...regardless of it conflicting with your registered domain or brands Cheers On Wed, 2011-04-20 at 17:27 -0500, Wil Genovese wrote: Has anyone received emails like this for any of their domains? I'm trying to decide if this is some far fetched phishing expedition or a serious inquiry. I do own the domain in question and it's also registered as business in the state of Minnesota under my name. I may reply to this anyways, but with extreme caution. Dear PresidentCEO, This is a Network Service Company which is the domain name registration center in HongKong,China. On April.19, 2011, we received an application from Meihua Holdings Group requestedchristianmp3 as their internet trademark keyword and China (CN) domain names. But after checking ,we find this name is conflict with your company's name or trademark. In order to deal with this issue better, it's necessary to send this email to you and confirm with your company whether this company is your distributor or business partner in China? If you did not authorize, please let us know within 7 workdays, so that we will handle this issue better. Looking forward to your reply Best regards, Linda Linda Zhou Checking Department HongKong Office(Head Office) HongKong China Technology Ltd Thanks, Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343885 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OT question - is this real or phishing?
They are just trying to get you to register all versions of your domain with them to block this fictitious other company On Wed, 2011-04-20 at 18:37 -0400, Casey Dougall wrote: On Wed, Apr 20, 2011 at 6:27 PM, Wil Genovese jugg...@trunkful.com wrote: Has anyone received emails like this for any of their domains? I'm trying to decide if this is some far fetched phishing expedition or a serious inquiry. I do own the domain in question and it's also registered as business in the state of Minnesota under my name. I may reply to this anyways, but with extreme caution. They are trying to drum up business, I had one similar to that the other day for dvsdjtv.com Right to the trash bin, I don't need a .cn or .com.cn and don't care if someone registers it in China * Dear Manager: This email is from China domain name registration center, which mainly deal with the domain name registration and dispute internationally in China and Asia. On April 10th 2011, We received HAITONG company's application that they are registering the name dvsdjtv as their Internet Keyword and dvsdjtv .cnã⬠dvsdjtv .com.cn ã⬠dvsdjtv .asia domain names etc.., It is China and ASIA domain names. But after auditing we found the brand name been used by your company. As the domain name registrar in China, it is our duty to notice you, so I am sending you this Email to check. According to the principle in China, your company is the owner of the trademark, In our auditing time we can keep the domain names safe for you firstly, but our audit period is limited, if you object the third party application these domain names and need to protect the brand in china and Asia by yourself, please let the responsible officer contact us as soon as possible. Thank you! Best regards, John Oversea marketing manager * ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343886 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: will not export query to excel
this works: cfquery name=gettemp datasource=#application.datasource# select location,score from SPDOut where SPDINput_id=#url.id# order by location /cfquery cfsetting enablecfoutputonly=yes !--- Required for CSV export to function properly --- cfset delim = 44 !--- Use a comma for a field delimitter, Excel will open CSV files --- !--- cfcontent type=application/msexcel cfheader name=Content-Disposition value=attachment; #url.id#-export.csv --- cfset thefile=Location#chr(delim)#Score#chr(delim)# cfset thefile= #thefile# #chr(13)#!--- line break after column header --- !--- Spill out data from a query --- cfloop query=gettemp cfset thefile= #thefile# #location##chr(delim)##score##chr(13)# /cfloop cfset exportallfile=#GetDirectoryFromPath(GetBaseTemplatePath())##url.id#-export.csv CFFILE ACTION=write FILE=#exportallfile# OUTPUT=#thefile# cfoutputcfset savefilename=#url.id#-export.csv/cfoutput !--- Push file to Client Browser --- CFHEADER NAME=Content-disposition VALUE=attachment; filename=#savefilename# cfcontent file=#exportallfile# type=application/ms-excel deletefile=no On 4/20/2011 2:50 PM, Rick Colman wrote: I am trying to output the results of a query to Excel, but instead, it opens CF Builder. Please advise. TNX. cfquery name=gettemp datasource=#application.datasource# select location,score from SPDOut where SPDINput_id=#url.id# order by location /cfquery cfsetting enablecfoutputonly=yes !--- Required for CSV export to function properly --- cfset delim = 44 !--- Use a comma for a field delimitter, Excel will open CSV files --- cfcontent type=application/msexcel cfheader name=Content-Disposition value=#url.id#-export.csv !--- Output Column Headers --- cfoutputLocation#chr(delim)#Score#chr(delim)#/cfoutput cfoutput#chr(13)#/cfoutput !--- line break after column header --- !--- Spill out data from a query --- cfloop query=gettempcfoutput#location##chr(delim)##score##chr(13)#/cfoutput/cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343887 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: will not export query to excel
this works: cfquery name=gettemp datasource=#application.datasource# select location,score from SPDOut where SPDINput_id=#url.id# order by location /cfquery cfsetting enablecfoutputonly=yes !--- Required for CSV export to function properly --- cfset delim = 44 !--- Use a comma for a field delimitter, Excel will open CSV files --- !--- cfcontent type=application/msexcel cfheader name=Content-Disposition value=attachment; #url.id#-export.csv --- cfset thefile=Location#chr(delim)#Score#chr(delim)# cfset thefile= #thefile# #chr(13)#!--- line break after column header --- !--- Spill out data from a query --- cfloop query=gettemp cfset thefile= #thefile# #location##chr(delim)##score##chr(13)# /cfloop cfset exportallfile=#GetDirectoryFromPath(GetBaseTemplatePath())##url.id#-export.csv CFFILE ACTION=write FILE=#exportallfile# OUTPUT=#thefile# cfoutputcfset savefilename=#url.id#-export.csv/cfoutput !--- Push file to Client Browser --- CFHEADER NAME=Content-disposition VALUE=attachment; filename=#savefilename# cfcontent file=#exportallfile# type=application/ms-excel deletefile=no On 4/20/2011 2:50 PM, Rick Colman wrote: I am trying to output the results of a query to Excel, but instead, it opens CF Builder. Please advise. TNX. cfquery name=gettemp datasource=#application.datasource# select location,score from SPDOut where SPDINput_id=#url.id# order by location /cfquery cfsetting enablecfoutputonly=yes !--- Required for CSV export to function properly --- cfset delim = 44 !--- Use a comma for a field delimitter, Excel will open CSV files --- cfcontent type=application/msexcel cfheader name=Content-Disposition value=#url.id#-export.csv !--- Output Column Headers --- cfoutputLocation#chr(delim)#Score#chr(delim)#/cfoutput cfoutput#chr(13)#/cfoutput !--- line break after column header --- !--- Spill out data from a query --- cfloop query=gettempcfoutput#location##chr(delim)##score##chr(13)#/cfoutput/cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OT question - is this real or phishing?
I highly suspected this as a phishing expedition. I did find out that Meihua Holdings Group is a maize processing company in China. The make corn based products. I doubt they are getting in the the Christian Music business. I've seen a lot of spam and phishing emails, but this one was the first one like this and it has the initial appearance of being legitimate. At least on the surface. Thanks all.. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Apr 20, 2011, at 6:50 PM, Bryan Stevenson wrote: They are just trying to get you to register all versions of your domain with them to block this fictitious other company On Wed, 2011-04-20 at 18:37 -0400, Casey Dougall wrote: On Wed, Apr 20, 2011 at 6:27 PM, Wil Genovese jugg...@trunkful.com wrote: Has anyone received emails like this for any of their domains? I'm trying to decide if this is some far fetched phishing expedition or a serious inquiry. I do own the domain in question and it's also registered as business in the state of Minnesota under my name. I may reply to this anyways, but with extreme caution. They are trying to drum up business, I had one similar to that the other day for dvsdjtv.com Right to the trash bin, I don't need a .cn or .com.cn and don't care if someone registers it in China * Dear Manager: This email is from China domain name registration center, which mainly deal with the domain name registration and dispute internationally in China and Asia. On April 10th 2011, We received HAITONG company's application that they are registering the name dvsdjtv as their Internet Keyword and dvsdjtv .cnã⬠dvsdjtv .com.cn ã⬠dvsdjtv .asia domain names etc.., It is China and ASIA domain names. But after auditing we found the brand name been used by your company. As the domain name registrar in China, it is our duty to notice you, so I am sending you this Email to check. According to the principle in China, your company is the owner of the trademark, In our auditing time we can keep the domain names safe for you firstly, but our audit period is limited, if you object the third party application these domain names and need to protect the brand in china and Asia by yourself, please let the responsible officer contact us as soon as possible. Thank you! Best regards, John Oversea marketing manager * ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343889 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OT question - is this real or phishing?
It is fake...NO registrar works in this manner. I got one of these too. I offered to sell them the domain in question for $25,000 US if they wanted it. Even offered to take four equal payments over the period of a year. Needless to say, they didn't go for it!!! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343890 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OT question - is this real or phishing?
On 21/04/2011 09:49, Russ Michaels wrote: anyone can register any domain, it is an automated system, seriously, do you think someone manually checks every single domain to see whether it might be infringing on anyone else's name or copyright. sorry to disillusion you but that is exactly what happens in some countries, not everyone is a casual as the USA :-) Try registering a .com.au without a registered company name in Australia, you'll be questioned by the registrar as to your bona-fides. -- Yours, Kym Kovan mbcomms.net.au ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343891 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OT question - is this real or phishing?
sorry to disillusion you but that is exactly what happens in some countries, not everyone is a casual as the USA :-) Try registering a .com.au without a registered company name in Australia, you'll be questioned by the registrar as to your bona-fides. But that's not really just a matter of the country; it's a matter of the namespace in which you're trying to register a domain. Anybody can register a domain within a public gTLD (com, net, org), but location-specific domains are generally more tightly controlled. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343892 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm