ColdFusion

Hello,Is anyone else seeing this on startup / login to ColdFusion ServerManager?CONFIRM!"Failed to read the scheduled tasks from myServerName.Continue to read charting settings from myServerName?"I'm running Coldfusion Standard 10.0.5.283319 on a remote Win 2008R2 64 bit webserver.ServerManager version is v1 but this seems different than the one that came with CF9 where it worked just fine.Thanks,Jack Ring

I have the queries that get values from other two tables and then insert those values into the final tables.  My code below did not inserted the correct record.Thanks<!---list all  purNo, padNo where purNo = 3215---><Cfquery name="getDetails" datasource="#dsn#">select purNo, padNo    from tbl_details    where purNo = 3215</Cfquery><!---list all cusNO where purNo = 3215---><Cfquery name="getCust" datasource="#dsn#">select cusNO    from tbl_customer    where purNo = 3215</Cfquery>From the form, I have one text box for user to enter new date then hit submit.  Once submit button is clicked, I would like to get the results from above two queries to insert into tblOrder.<cfset note ="new date changed from" /><cfloop query="getDetails"><cfloop query="getCust"><cfquery name="insert" datasource="#dsn#">         insert into

Hi,I have the simple query for select * from the table and try to display results into cfgrid but i got nothing show on the page. what's wrong with this?Thanks<cfform>   <cfgrid name = "FirstGrid" format="flash"      height="320" width="580"      font="Tahoma" fontsize="12"      query = "qname">   </cfgrid></cfform>

HelloI have an app running with approx 6,000 signees. I try to ensure their email going in the DB is validated via javascript- but this not totally effective.What code could I write in the CFmail tag that would ignore bad emails, send the meassage without errors, and perhaps even list the bad mail addresses?Thanks in advanceNorman B.

Take time to let Adobe know your choice of platform for ColdFusion by taking part in the ColdFusion Platform survey.Here's the link for the survey: https://www.surveymonkey.com/s/HMQG62Y

Hi there,I inherited a website that was developed in CFMX & MS SQL several years ago. The site was moved to a CF10 server with a MySQL DB which seems to have caused a few issues here and there. One issue I am currently experiencing is decrypting information stored in a SQL database. I have the key it was inserted with, and I know that it was inserted via AES.So here's the query I'm trying to run:Select *, AES_DECRYPT(cardnumber,'#cckey#') as ccnumber from orderinfo where orderno='123'When I output the query and try to pull up #ccnumber# it throws the hatred generic "Internal Server Error 500" and gets me nowhere. If I try to output #cardnumber# instead, the actual column name in the database, I am given a long string of jarbled letters, numbers, and symbols. I figured that mabe I could use the Decrypt() function in ColdFusion to decrypt that if it's not working at the database level, but I don't get anywhere with this method either; I get the same generic error.What would you recom

I have a couple of ColdFusion 10 servers running on WindowsServer 2008r2 and IIS 7.5. Both of the boxes are running a couple different applications. The only significant difference I'm aware of between the 2 is that one is running the application all on one site just under different directories the other has inidividual sites and IP's configured under IIS for each application.  I upgraded the first box to Java 7u9 and it worked fine but when I tried to upgrade the second the box the coldfusion service wouldn't restart.  I can point the cold fusion back to Java 6u37 and it works does anyone have any ideas as to what may be causing this.Thanks,Scott

Hi,I've just installed CF 10 in demo mode on a fresh Windows 2008 R2 64 bit VM. I'm using IIS 7.5 as my web server. After completing the setup wizard I am unable to access the cfadmin at :http://127.0.0.1/CFIDE/administrator/enter.cfmI'm getting a message that my password is invalid.I have used the password reset batch file in cfusion/bin with no luck. I have restarted the CF service.Any advice is appreciated.Thanks!

Issue:  The names comes across like this: Hausmann, Alan *I want to strip an asterisk out of the name. I was using the Replace function.But I do not understand what the error means (Error:  Invalid construct: Either argument or name is missing.)This is the code I am using.<cfoutput>#Replace(form.name,*,"")#</cfoutput>Thanks,Al Hausmann

Good morning I have a situation wherein  during an insert into my database, the variable that I created from an cfif/cfset throws an error. Am I missing something? My code is below...<cfset gradepoint =VAL('#fcnpoint#') + VAL('#attitudepoint#') +VAL('#guestpoint#') + VAL('#contactpoint#') + VAL('#attendancepoint#')+ VAL('#nspoint#') + VAL('#foidpoint#') + VAL('#otherpoint#')><cfif "#gradepoint#" GTE "-20.45" AND "#gradepoint#" LTE "11.1"><cfsetmaingrade= 'F'></cfif>INSERT INTO squadreport (squid,  squgrade)VALUES ('00', '#maingrade#')</cfquery>

Hello,Last week we began seeing some timeout errors, but today there have been much more of them and I’m not sure how to proceed in troubleshooting.We have 2 load balanced app servers:Windows Server 2008 R2 (virtualized)ColdFusion 8, EnterpriseAnd a database server:Windows Server 2008 R2SQL 2012The error in “coldfusion-out.log” is:A non-SQL error occurred while requesting a connection from <DSN>.Timed out trying to establish connectionThis only happens on one of the web servers, but it happens more frequently when the app servers is under a heavier load. Most of the day it works fine, but 4 or 5 times throughout the day we will have 1 – 15 requests timeout in a row(always varies), and then things will be fine again w/out restarting or doing anything.The database server is much more powerful than the app server, and I don't believe the issue involves long running queries or the DB server being under heavy load.I’m a DBA who is temporarily handling System Admin responsibilities, an

I have a data table which displays data like this:0-11-311-1414-21DEPT3.77 0.94 3.46 11.95 SALESSo I have many columns for the 'valuecolumn', and only one column for the 'itemcolumn'. But it looks like in the tag it will only accept one 'valuecolumn' even though I have many. How would I make this work? <cfchartseries type="bar"query="stats"valuecolumn="0-1"itemcolumn="DEPT"</cfchartseries>As you can see I can't put multiple columns into the valuecolumn attribute

I would like to build my first web site on ColdFusion build in server.I would like to know should I just create a folder on C:\ColdFusion10\cfusion\wwwroot for my site or I can use admin web site to creat a new web site?Your information and help is great appreciated,Regards,Iccsi,

I created a few database source on ColdFusion server and used Dreamweaver or ColdFusion Report Builder to access RDS server.I just realized that I can access all datasource from Dreamweaver and ColdFusion Report Builder.I would like to know is it possible to create user rights which only can access the database rights grant.Your information and help is great appreciated,Regards,Iccsi,

I have ColdFusion 10 Report  isntalled and connected to RDS server.I just see tables and views, but not stored procedures.I would like to know is ti possible to use stored procedures for the report data source.Your help and information is great appreciated,Regards,Iccsi,

I would like to use CFMail to send out email.Does CFMail need SMTP mail server to install or ColdFusion has email server?Yuor help and information is great appreciated,Regards,Iccsi,

I would like to know if is possible to create user role on the CodldFusion server.Your help iand information is great appreciated,Regards,iccsi,

I've successfully installed Tomcat 7 on a Macintosh running 10.7.5.  The ColdFusion WAR file deployed successfully, but when I try to start the service, I get a raft of errors in the Catalina.out log file:INFO: Deploying web application archive /usr/local/Tomcat7/webapps/cfusion.warjava.lang.ExceptionInInitializerError          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)          at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) ...          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)          at java.lang.Thread.run(Thread.java:680)Caused by: org.apache

I would like to know IsUserInRole ColdFusion function to use get user role, but how I can create user role from ColdFusion?Any function to creat euser role or uses ColdFusion server admin to create or create a role in the backend database?Your help and information is great appreciated,Regards,Iccsi,

Hi,the code below is displayed 5 text boxes but how can i made at least one is required?<cfform name="search" action="insert.cfm" method="post"><cfloop index="email" from="1" to="5"> <cfinput type="text" name="email">   </cfloop>    <cfinput type="submit" name="submit" value="Save"></cfform>thanks

Does anyone know how to extract the value of a cftextarea (html and all) without actually submitting the form? **EDIT** Sorry I forgot to say it was a rich text feild

After many years of dire predictions from myself about using MS Access for a production website, my office has finally bitten the bullet and provided me with MSSQL Enterprise.  FINALLY I no longer have to append disclaimers and apologies to my requests for assistance (unless it's about my sloppy coding).One of the changes in this switch is that my 14 or so existing Access databases have been "squished" into one huge MSSQL database.  The resulting database has around 115 tables, and with no MDB file to open up and look at, I decided to build a "table browser" for my coders to use.  Most of the information that we change frequently already has a web interface, but some of the tables we rarely touch.  Still, I wanted a way to "look around" inside the database.The page I've built basically creates an unordered list of table names in a scrolling left column.  When you click a table name, it expands into a nested list of row names. This all works quite well.  Co

i have a table that has two date fields (dateinx and dateoutx) and i need to find all the results for todays date that both fall between and on that date for a given customer: cID.if todays date is 12/2/2012examples of vialable entries:dateinx=12/2/2012 and dateoutx = 12/5/2012dateinx=11/2/2012 and dateoutx = 12/2/2012dateinx=11/2/2012 and dateoutx = 12/25/2012i am using "smalldatetime" in msSQL2005 and also would like to create a mask so that only date: 1/1/2012 would be saved. same for time: 1:30AM in a seperate field. msSQL is saving now as 1/1/2012 01:30:00AM or some such...querey at this point looks like:SELECT *FROM schdlWHERE (cID = #cID#) AND ....tnx in advanceandy

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7fb9.html

Hi!Many of my websites are using an external stylesheet such as this:<link rel="stylesheet" type="text/css" href="test.css" title="This is a test" />In my 2 laptops, 1 has CF8 and the other has CF10, I just downloaded a few minutes ago.My Boss wanted me to compare because he is thinking of upgrading it to CF10.After I'm done setting up everything (IIS, datasource, etc), I launched my website in both laptops and the result on laptop with CF10 is quite surprising.When I took out: <link rel="stylesheet" type="text/css" href="test.css" title="This is a test" /> from <head></head> and replace it with:<style> css codes from test.css </style>  I got my style back.So, for some reason, CF10 ignores <head><link rel="stylesheet" type="text/css" href="test.css" title="This is a test" /></head>Does CF10 can't work with external stylesheet anymore? or is there setting in administrator if I want the old fashion way in using external setting?