ColdFusion

Hello, everyone.I've been tasked with a project that will involve querying a table on one server, then sending the data to a remote server that will take the data and insert it into another database (the two db cannot communicate directly with each other.)I've never had to do something like this, before.  What is the best way to achieve the desired results?  Is there a way to "submit" a query (anywhere from 1 to 5 records at any given time) to the remote server without incorporating WDDX?CF9 environment, soon to be CF10.V/r,^_^

I have a series of forms that send information to various web services.One is a login form, which consists of a username/password combo, and some other credentials specified in the code.  My CF code looks like this:<cfinvoke    webservice="https://my.web.service.url/login?wsdl"    method="userLookupBySession"    returnvariable="appauth">        <cfinvokeargument name="applicationName" value="MYAPP" />        <cfinvokeargument name="accessCode" value="123456" />        <cfinvokeargument name="sessionId" value="#session.appid#" />        <cfinvokeargument name="endUserIPAddress" value="#CGI.REMOTE_ADDR#" /></cfinvoke>And that works quite well.Another form is a registration form.  Like the one above, it accepts four arguments.Application nameAccess codeUser data

Hi     I am beginning to start learn coldfusion now i want to know the site url where diff type coldfusion projects exist like Hospital management system,School management system,etc.

Hi,I have a question on Cold Fusion license.Have Cold Fusion 9 Enterprise but cannot find the license key.Have Cold Fusion 10 Enterprise and have the license key.Can the license key for CF 10 be used for the CF 9 key?Can the license key for CF9 be obtained somewhere?Thanks,Mike

Does cffeed cache http responses?  Two servers with the same code return different content (one is current and the other is out-of-date).Thank you.

Hi All,I just had a heck of a week recovering our Coldfusion production environment. I think it convinced us to create a high availability/failover for the site. My question is is CF 9/10 enterprise required to create a failover cluster? ThanksMark

Like Following .Net Class how to make component in coldfusion10?public class ViewModelSearch    {        public List<PropertyAttributeGroup> PropertyAttributeGroups { get; set; }        public List<Product> Products { get; set; }    }Where PropertyAttributeGroups  ia s class autogenerate using Entity Framwork in .NET.

Does someone knows if there is a limitation with Chrome about create variable session when the domain name is long?For example I have domain like this onehttp://www.abcdefghijklmnopqrstuxyz12345678.com.mx/I have my index with user login  and when I validate the account If it is correct I create the variable session and I do a cflocation to the user home page.<CFSET SESSION.AuthCte = StructNew()>                      <CFSET SESSION.AuthCte.IsLoggedIn = "Yes"><cflocation url="userhome.cfm" addtoken="no">But the userhome.cfm detects that the SESSION.AuthCte.IsLoggedIn variable is not defined.If i use the IP instead of domain name it works.It works too if I put addtoken="yes".If I use the IE browser with the domain name it works.Regards!

I just 'upgraded' (if you consider DW CC an upgrade) from CS6 to CC, and am having problems with .cfm files.I have followed all the instructions to get DW CC to open and edit .cfm files..... and it does this just fine. I have also installed the server behaviours and databases panel extension.However heres the BIG problem: when I want to upload a .cfm file to a server, I am no longer getting a prompt to upload dependent files! It prompts me fine if I upload a .html file, but not .cfm.I mostly work with .cfm files and make changes to CSS files regularly. Whenever I upload a .cfm it is essential that DW also uploads the dependent files associated with it.Please how can I fix this issues? I have gone into preferences and all the boxes are checked correctly to prompt for dependent files when putting/getting. I'm so stuck I'm thinking about cancelling my CC products and going back to CS6.

I am currently on coldfusion 9 with win serv 2003. We are moving everything to a new server with win server 2012. Is 9 compatible? If I have to upgrade to 10, then what is the best way to do it. Can I install v. 9 on the win 2012, then immediately upgrade with v 10? or will, I have to purchase a full copy of 10 and do a fresh install. I am thinking, there should be an upgrade path, and not require me to buy it all over again.

I have an older functioning form that creates a new "Order" record in my "tblCOM" tableI added two new text type fields called: "HowManyData" & "HowManyVoice" (see image above) and a new field called "pvType"Question: How can I adapt my page to handle the following scenario:-------------------------------------------------------------------------------------------- the user types in a qty of "4" for field "HowManyData" - the user types in a qty of "2" for field "HowManyVoice" When the Submit button is pressed: ------------------------------------------------ the main record is added to "tblCOM" (this is already working fine)- four (4) related  "Data" records are added to the "tblProvisioning" table (and pvType is saved w/value of "Data")- four (2) related "Voice" records are added to the "tblProvisioning" table (and pvType is saved w/value of "Voice")I know this requires something similar to the following:-----------------------------------------------------------------------&

I'm trying to get single select options in a dropdown menu.The data is coming from two database.My CFQuery looks like <cfquery name="related" datasource="ISSUE">SELECT sparprodFROM Relatedwhere Active = 'Yes'union all select sparprod from TBL_issueWHERE issue_number = <cfqueryparam value="#URL.issue_number#" cfsqltype="cf_sql_numeric"> ORDER BY sparprod ASC </cfquery>  <td>        <select name="sparprod" id="sparprod" >          <cfoutput query="related">            <option value="#related.sparprod#" <cfif (isDefined("rs_issue.sparprod") AND related.sparprod EQ rs_issue.sparprod)>selected="selected"</cfif>>#related.sparprod#</option>          </cfoutput>        </select>And the output in the dropdow

I am counting the number of lines on code in .cfm pages. But i want to exclude the lines between the CF and Javascript commenting tags while doing this.I tried replacing the lines in between the commenting tags with empty string like the below one.For CF commenting tags :  <cfset filecontent=rereplacenocase(filecontent,"<![^<]*>","","all")> For Js Commenting tags  :  <cfset filecontent=rereplacenocase(filecontent,"/*[^<]*/","","all")>But mostly the above method does not exclude the codes. can anyone suggest any alternate method to achieve this.

Hi,I urgently required 2 ColdFusion Developer for 2 permanent roles based in central London. Ideally you will have 3+ years experience but less is considered if recent. Please send me an email if you are interested or if you know someone who is. ThanksDavid.hughes@nakgroup.co.uk

A big problem, I cannot anymore use my new CF datasource.I use to declare CF datasource on a C F9 64bits , Windows serveur 2008 64bits environment.I have around 80 datasources declared (Access mdb files).I use the same procedure to create my datasource.create the ODBC32 datasource.Then create the CF datasource linked to the created ODBC datasource.As I always do.When I verify the datasource in the CF admin, it says OK. all seems goodAnd when I do a query to that datasource,I have this message :Security: The requested template has been denied access to allergan_prof_sante. The following is the internal exception message: access denied (coldfusion.sql.DataSourcePermission allergan_prof_sante) I tried to create an other datasource.Same behaviour. OK in the CF admin.And "access denied" when doing a query.So now, any datasource created cannot be accessed.I did not change anything on the Windows serverThe only change, is my client PC which ftp the mdb file.It was Vista, and is now windows 7.

How to use "#" sign in jQuery For id? When i try to use it like ($('#PropertyAttributeValue').css('color', 'red');)  i got error like following:The CFML compiler was processing:An expression that began on line 64, column 37.The expression might be missing an ending #, for example, #expr instead of #expr#.The body of a cfoutput tag beginning on line 19, column 18.

I need to detect whether a browser has flash installed and active, and if not I will switch to an alternative set of code.Can anybody tell me how I can test for an active flash installation? (on CF8)ThanksMark

Hi,I am running CF9 standard on a production environment. We had a disk crash this week and had to rebuild our server as the backup was corrupted as well.I installed IIS and CF 9, and now have an issue with query stringd being truncated.These are short strings that were working before the crashThis is causing errors as values the cold fusion pages are looking for are not being provided to the pages. Here is an example of a truncated URL from the IIS log: redirectionNom=164666-events.html&the correct url would be  redirectionNom=164666-events.html&id2=23456 Note the ampersand where other data would be added to the url. I have validated that this is the issue by dumping out the values for the url and the CGI variables and comparing this to the url in the address bar. We are definitely losing things off of our URLs.These are not very long query strings, so request filtering should not be stopping them, and we are not getting the expected 404 error we would get if it was a req

<cftry><cfset jsontxt="{""A"":""Bob"",""B"":123,""C"":null}"><cfset json=deserializejson(jsontxt)><cfdump var="#json#"><cfoutput>    <li>[#structkeylist(json)#]<br>    <li>[#json.a#]<br>    <li>[#json.b#]<br>    <li>[#json.c#]<br></cfoutput><cfcatch type="Any">    <cfdump var="#cfcatch#"></cfcatch></cftry>The documentation states: The JSON null value becomes the string null.http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-79e4.htmlThe above test on CF9 operates as described in the docs, but CF10 errors on #json.c#I found some old code (compacted a bit), which implies that the old behavior was to convert json's null to "null". <cfloop list="#structkeylist(contact)#" index="lp">  <cfset x=evaluate("contact.#lp#")>  <cfif x eq "null"> &n

I have an older application that I have upgraded and I am only having issues with the Search Engine going form Verity to Solr.I have a simple query tht gets the content for each page and indexes it. The code works awesome in Varity - but when I run it on the Solr system I get the following error:Error_opening_new_searcher_exceeded_limit_of_maxWarmingSearchers4_try_again_laterAlso - when this errors out (only this error) - the prowser shows the HTML Source of the error instead of the typical?Any help, please!There are only 207 records that I am trying to index?between 20-25 actually get indexed.<cfindex action="PURGE" collection="#application.stSiteData.objectCollection#">            <cfquery name="qGetData" datasource="#application.stSiteData.datasource#">                SELECT  objectID          

i want to be able to update a table cse_montly_reportsthis is my code right now<cfquery datasource="Intranet" name="reports">  with Employee_cte as (      Select e.*,             (Select SUM(r.execoffice_status)              From intranet.dbo.CSEReduxResponses r              where e.emp_id = r.employee              and YEAR(r.approveddate) = YEAR(GETDATE())                and    MONTH(r.approveddate) = MONTH(GETDATE())-1                    and execoffice_status <> 2        

Im trying to figure out how to approch a problem. what I want to do is generate a new file/link, maybe using 'cffile' or any other way.Right now i have cse_newsletter.cfm , that looks like this(kind of)<html>.......<cfquery>select ....</cfquery>select ....<cfquery></cfquery>....... <cfoutput>      <h1>Starburst Star Award</h1>     <h3>Winner: Department- #highest_dept_name_average#</h3>     <h3>Average:  #hihest_dept_average# </h3>     <h4>Runner-up: Department- #highest_dept_name_runnerup# </h4>     <h4> Average: #highest_dept_name_average_runnerup# </h4>  </cfoutput></html> the query works and give me the correct output i want.(rigth now i use cfshedule to run it, but everytime i will run it will overwrite the old data with the new) what it does it gives me the dat

hii have embeded tv.adobe training videos on my website http://vidzonline.com and i just want to enable replay button only and stop the suggested videos in player box. it is possible the off this feature in player?

Hello, everyone,Is there a way to change the attributes of a .txt file that already exists?For example:  I use CFFILE to write a .txt file that is blank, and supply the "readOnly" attribute.  Later, I want to dynamically add data to the file.  How do I set the .txt file to NOT readOnly so I can add data?  And, conversely, how do I set the attribute back to readOnly?V/r,^_^

I have settle down with my problem of pagination before.But instead of using**<< Previous Page // Next Page >>** I want it to be**<< {Director ID} // {Director ID} >>**Can anyone help me?This is my full code.I just wanted to change Previous/Next with the current Film Director displayed.    <cfquery datasource="#dsn#" name="list">     SELECT          *    FROM          directorList    </cfquery>    <cfquery name="qIDHM" datasource="#dsn#">    SELECT          directorID     FROM          directorList     WHERE          directorID = '#list.directorID#'      GROUP BY