ColdFusion

I'm writing a script to copy BLOB data from a table in one database to a table in another database.  I'm able to copy non-binary data without any issues but I haven't figured out how to move binary.  I would think that I could just grab it out of one database via <cfquery> and put it in the other one via <cfquery> with no manipulation but it's giving me errors.  Specifically: ByteArray objects cannot be converted to stringsI've tried converting it back and forth between Base64 and strings and messing with it but I'm not having any luck.  Why doesn't this work if both columns are BLOB (this is a simple demo)?<cfquery name="get" datasource="#db1#">SELECT file_binary FROM old_table WHERE id = 1</cfquery><cfquery name="set" datasource="#db2#">INSERT INTO new_table (id, file_binary) VALUES (1, #get.file_binary#)</cfquery>Thanks! 

So as i was opening my presents with my family Christmas morning when my web server emailed me to let me know that a file had been created in my /CFIDE/ folder. This file was h.cfm and it was a nifty little tool used to scan files - copy files - dump SQL passwords - run commands - upload files ect....My setup is CF9.0.1 on win server 2008 with mySQL5.5 . The servers only purpose is to host a few websites for my company. I poured over my IIS logs and could not find any trace of a connection to the webserver while this was happening. I then started looking at the http.log file in coldfusion server and found that it contained 2 entries at the time of the attack. Both looked like this... note i've removed the IP of the server. This file is the file that was uploaded to my server.25-Dec-2012    6:54 AM    Information    jrpp-6969  Starting HTTP request {URL='http://IPAddress:80/CFIDE/h9.txt', method='get'} There was nothing before this conne

Hello,I have been banging my head on this CF8 issue for too long now.   I have a string thatis of the form [~]'trespes[~] where I need to replace [~] with the escaped backslash\   I have tried coldfusion replace, and java ReplaceAll but whenever I put any escaped html into the fuction, replace(string,"[~]","\") I get an error from CFMissing argument name. When using named parameters to a function, every parameter must have a name.If I use java ReplaceALL I get the same result.  Any insight to this problem wouldbe greatly appreciated, driving me batty..   I know it must be simple..  ugh.Thanks,Bob

hi,I was trying to install cold fusion 9 on Microsoft IIS server and i was unable to install it.....due to errors like HTTP error 404.2,404.3,500.0,500.19.if i am trying to solve on error i'm finding a new one so pls help me.Need a detail explanation on installing cold fusion on IIS server

i have the following query that worked just fine on CF7 and SQL server 2000<cfquery name="getColumns" datasource="ds">SELECT Column_Name, Data_TypeFROM INFORMATION_SCHEMA.ColumnsWHERE Table_Name = 'Fields'AND Table_Catalog = 'databasename'</cfquery>now that have upgraded to CF 9 and SQL 2012 - this query does not work"Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'FROM'. Any ideas - trying to export from SQL database to an excel file - THANKS!

EnvironmentColdFusion version: CF9 32-bit (NOT the 9.01 Patch yet)Hotfix version Noneserver OS : Windows 2003 Server 64 Bitwebserver: Apache/2.2.14 (W32) 32 bitdatabase: MSSQL 2008 Express with Advanced Services 32 bitBackground1.  Porting an old cold fusion code base from 2002-2006 to CF92.  I am randomly but quite frequently getting 503 errors in the browser on the above environment AND a development environment running WinXP, Apache 2.2 32 bit, CF9 32 bit, MSSQL 2008 Express with Advanced Services 32 bit.The 503 errors seem random and they are frequent.These 503 errors are happening on both the application and on the CFIDE/Administrator (though not as often).No one is using this application but me.  It is under test and development.  Obviously, can't go to production with this problem.3.  The 503 errors are showing up in the apache access and error log.Access Log70.125.50.86 - - [12/Jan/2011:06:02:55 +0000] "GET /generalsignup.cfm HTTP/1.1" 503 222 "http://w

My web service is written XML and its in dev but my coldfusion is not able to call url, I have to use CF9.1.any suggetion?

CF 10 Application Server set to automatic. It NEVER starts automatically. All other CF 10 services do start automatically.Running Windows 7.My host, running Windows Server, has the same problem.Any idea what's up?

I am having an issue with the installer on ColdFusion 8.01 in Win2008 server.  I have done 5 or 6 identical installs with no problem so this caught me by surprise,  The server OS is Server 2008 R2 Enterprise service pack1.  I am running the install (coldfusion-801-win.exe) as an administrator in emulation mode (Windows Server 2003 service pack 1). The following is the error i get.   As I stated earlier I have done this exact install, both single & multi-server, on 5 or 6 Win2008 servers with no issue.  Any help would be appreciated.

Hello.When a <cfinput> field attribute is set to "datefield" it displays an associated calendar icon. It appears that a viewer must click on the actual icon to display the calendar for date selection. Is it possible to have the calendar display when the viewer clicks on the form field itself or when focus is on the form field?Thanks in advance.Leonard B

I have 2 CFINPUT DateField on the form, one is Start ate and one is End Dated. Start Date is on top of End Date.The Start Date Calendar goes behind End Date when users enter start date using Start Date control that users is unable to use calendar to enter date.I would like to know how I can control that make Start Date Calendar in front of End Date Control while user enter information.Your help and information is great appreciated,regards,Iccsi

I have a utility that lets users store custom fields (first name, favorite color, address, URL, etc).One of those fields is used to store the contact's work/personal URL.In addition, users can send their contacts an email including these fields. So an email might say: "Dear *fname*, Your *URL* is pretty cool!"Now my client wants to re-write the URL so they can track it using Google Analytics, and that's where I'm stuck.Basically, I'm struggling with how to re-write the URLs since there can be other fields for one contact that may need to be re-written.In other words, I need to check every field to see if there's an href, and if there is, replace it with another href, for *every contact*.The code below re-writes the URL only for one field and for one contact, but not if there's more than one field with an href and/or more than one contact being returned.Here is the code I'm using:<!---get user defined field info---><cfquery name="getUDFields" datasource="#attributes.dsn#">SE

During the processing of a request, we need to perform an ORM statement and a non-ORM cftransaction on 2 different data sources.Example:# Note, 'someObject' is a persistent CFC with a datasource attribute of 'DSN1'.<cftransaction>     <cfset myObjects = EntityLoad('someObject') /></cftransaction><cftransaction>     <cfquery name="test" datasource="DSN2">           INSERT INTO ...     </cfquery></cftransaction>Whenever we hit the 2nd cftranaction block, we get the following error:Message=A transaction cannot be started on more than one datasource.This works in CF 9.0.1, but fails on CF 9.0.1 HF3, CF 9.0.2, and on CF 10.

We are upgrading from CF8 to 10 and our major application a content management software is now broken.  It uses Javascript, CF,  and XML. This code work perfect in CF 7, 8 and 9, but now in 10 we are screwed! I can provide more detail.Trying to debug code in firebug.  The post looks like this<methodCall> <methodName>display.lock</methodName><params><param><value><string>9C7bd8c93CaCbc6A</string></value></param><param><value><string>mlongwell</string></value></param><param><value><string>31559-73666-19542</string></value></param></params></methodCall>The error we are getting is below.Webpage error detailsUser Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; BRI/1; .NET4.0E; InfoPath.2)Timestamp: Fri, 7 Jun

I went to upload a file using "Synchronize" and all the options were dimmed.  So I go to the File pane and see that ALL of my saved FTP sites are gone.  I back up everything regularly, so I tried restoring both Program Files(x86)/Adobe/Adobe ColdFusion Builder2 and %USERPROFILE%/Adobe ColdFusion Builder 2.0.1 Configuration folders.  No luck.  They're gone.  Does anybody have any idea where this information is stored, if not in either of those folders?  I'll re-create all of the connections, but just in case this happens again, it would be good know.  Thanks.

I am trying to decide between Contribute or purchasing ColdFusion.  Because I do not currently own ColdFusion I have no way to read the .cfm files, and would to save the money on my purchase if possible.

Query Of Queries runtime error.Table named users was not found in memory. The name is misspelled or the table is not defined.======================================================Just got the error above after I connected the website to a new MySQL server. The connection is verified in Admin but I'm unable to get the database connection working. The query is working just fine with a connection to our old SQL server and it works in MySQL WorkBench.even simple query like this<cfquery name="GetUser" datasource="#datasource#" dbtype="#dbtype#" username="#username#" password="#password#">SELECT    *FROM      users</cfquery>Any ideas?

Hi. We've had errors logged every few minutes for several years and would like to know how to stop them please? The log path and a file name example is:<drive>\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard130603.logThe first few lines of the latest log are below.2013-06-03 07:59:09 jrISAPI[init:2060]  JRun ISAPI Extension DLL Detaching (FreeLibrary)2013-06-03 08:19:15 jrISAPI[init:3816]  JRun 4.0 (Build 108673) JRun ISAPI Extension - Mar 13 2008 19:48:362013-06-03 08:19:15 jrISAPI[init:3816]  JRun ISAPI Extension DLL Attaching2013-06-03 08:19:30 jrISAPI[5648:3816]  127.0.0.1:51020 connect failed[740]: 10060 Connection timed out2013-06-03 08:19:30 jrISAPI[5648:3816]  Couldn't initialize from remote server, JRun server(s) probably down.2013-06-03 08:20:49 jrISAPI[3712:3816]  127.0.0.1:51020 connect failed[644]: 10060 Connection timed out2013-06-03 08:20:49 jrISAPI[3712:3816]  Couldn't initialize from remote server, JRun server(s) probably down.

Hi,I am trying to add new members to the group using cfldap modify query.i am able replace with one member with the other but the requirement is like that we supposed to add new member with the existing one.query that i have used is <cfldap     ACTION="modify"                      Modifytype="REPLACE"                      DN="#groupdn#"                      ATTRIBUTES="MEMBER=#existingmembers#, cn=XXX, ou=xxx,o=xxxx"                      separator="|"                     &nbsp

In ColdFusion Administrator, Server Settings > Client Variables,  assigning Select Default Storage Mechanism for Client Sessions as Cookle  creates persistent cookies.  Cookie expriration dates are EXPIRES  5/25/2043 7:32:12 PM,  not EXPIRES  At the end of the Session.  Persistent cookes are a security concern.  How are dates for ColdFusion issued cookies (e.g., CFGLOBALS) set to "NOW" so they become session cookies and disappear when browser (IE) is closed? Thanks, GuyCurrently running CF8, but will soon be migrating to CF10.

i am trying to use cfform tag inside cfwindow and it didn't dispaly the anythnig.<cfwindow name="win1"  title="test" center="true" width="200"          height="200" modal="true" initShow="true"> <cfform name="form"  action="test.cfm" method="post">test page</cfform></cfwindow>--Thanks

I am looking for a CFC that will calculate UPS shipping costs to both US and Canada using UPS's new shipping calculation. It should not use the oversize flags as UPS has done away with this. I am using ColdFusion 7 on a dedicated server. Does anyone know of a company/person that has this component? I've searched forums and search engines to no avail. Thanks for your help.

Whether I am logged in or not, when I go to pages like this:http://help.adobe.com/en_US/ColdFusion/10.0/Installing/WSc3ff6d0ea77859461172e0811cdec18c28-7fb8.html#communityand click Discuss This Pagemy adobe id login never works.is there some separate login for this?

Are security vulnerability patches being made available to CF 8.xx license holders until the 31 July 14 "End of Life" schedule on the ADOBE product matrix?

I installed APSB13-13 on several of my DEV and QUA servers and thought all was well.  I had planned to move the update to production this coming weekend but have now hit a block.  Since installing the update, I can no longer create a new CF instance.Running CF 9.01 Enterprise HotFix 10.The Message I get is:This happens on every server I installed the HotFix on.I just attempted that to get a fresh error.  I tried creating an Instance called "Test1" . In the Cfusion-out.log I see this:06/05 12:15:10 Warning [jrpp-471] - GetProfileString: coldfusion.util.IniUtils$InvalidIniPropertyException: Invalid INI property: leadGeneration, section: Global, file: D:\InetPub\ClaytonHomes_Cf\..\ini\claytonnetV2.inijrunx.jmc.management.NoSuchServerException: No server exists with the name test1.    at jrunx.jmc.management.JMCConfiguration.getServer(JMCConfiguration.java:209)    at jrunx.jmc.management.tags.ObjectSpecifyingTag.getAssociatedServerObject(ObjectS