ColdFusion

While working on various feature with adobe the database access suddenly couldn't connect, I've seen same issue on other sites such as http://stackoverflow.com  http://moverstovirginia.com http://utteraccess.com.any solution?

I am running CF9 64bit on windows 7. I created the database on mySQL 5.6 server. I created the datasource, theough the CF Admin, for kalendar and it verified. I then tried using the following code to create 2 table, but I recevied an error that just says "Error!" when I tried running the script. I posted the script on  mySQL forums and was told the code ran fine. What am I not seeing?<cfquery name="qCreateTable"  datasource="kalendar">CREATE TABLE  tblkalendar (  EventID varchar(100) NOT NULL,  CategoryID int(10) NOT NULL,  IsDeleted tinyint(1) NOT NULL default '0',  IsPublished tinyint(1) NOT NULL default '0',  IsFeatured tinyint(1) NOT NULL default '0',  DateTimeCreated timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  StartDate datetime NOT NULL,  EndDate datetime NOT NULL,  StartTime varchar(50) default NULL,  EndTime varchar(50) default NULL,  ContactPhone varchar(50) default NULL,

I know I can use the following line to change the column name: alter table tablename change "First Name" (Parenthesis used for clarification only) FirstName varchar (10) ;my problem is the column name has a space in it, ie: First Name . So mySQL thinks it is changing "First" to "Name" then it hits the name I want it changed to and goes berserk. How can I change this? I can't even delete it. It happened when I imported Microsft SQL into  mySQL database.

I currently have 2 servers.  Server 1 runs Win 2003 with CF9 and IIS.  Server 2 runs Win 2008 R2 64bit with CF10 and Apache 2.2 with virtual hosts.For years, on Server 1 when it ran CF7, CF8, and now CF9, if I were to run 'expandPath' this is the behavior I would see:expandPath("/")  -  web site root directory  (D:\sites\mysite\htdocs\)expandPath("/myDir/")  -  directory under web site root (D:\sites\mysite\htdocs\myDir\)expandPath("/../storage/")  -  directory above web site root  (D:\sites\mysite\storage\)But, now on my Server 2, the behavior has changed to:expandPath("/")  -  web site root directory  (D:\sites\mysite\htdocs\)expandPath("/myDir/")  -  directory under web site root (D:\sites\mysite\htdocs\myDir\)expandPath("/../storage/")  -  directory above web site root  (C:\ColdFusion10\cffusion2\bin\)I can't figure out if this is an issue in my configuration/setup or if this is a CF10 bug.&nb

I need to create a DSN to connect a SSL MS SQL server using ColdFusion server for RDS server.I tried to use ColdFsuion admin page to creat a DSN, but I got error message  like following:connection verification failed for data sourcejava.sql.SQLNonTransientConnectionexception:[Macromedia][SQLServer JDBC Driver]The SQL Server login requires SSL Conection.Any suggestions to connect SSS MS SQL server is great appreciated,Regards,Iccsi,

I am trying to get into the Ask Jan a question on the Janome.com site and a screen comes up saying to check my Cold Fusion documentation to make sure that I am using the correct syntax.  I do not understand this at all.  HELP!!!

Yes, I know cflayout is the worst but I am trying to use it nonetheless. It's working fine (providing I realise its limits) ... on two web sites on one piece of hardware (server).  We have our own servers. We're trying to add a 3rd virtual host.  So we can production, preview and r and d.  Our production server is working fine ... as is our r and d server. So, on the exact same box, I made a copy of the folders that run production.  Same db source, same files, same CF server; same everything, except different folder. Same paths. When I run the preview site, the site itself work perfectly until it comes time to display a cflayout. Tabs do not show. Tab content does show, one underneath the other.  But where the real site show with a width of say 800, I barely get 200. No errors. I can only assume that maybe something in IIS is not mapped correctly? Happy to share screen shots by PM.

I recently Migrated our sharepoint from windows 2003 to 2008. In doing so I lost Cold fusion and a directory Wizard, This wizard was put in place to create a folder directory out on our network drive when used. Now I have Coldfusion 10 installed on my new sharepoint server, I have brought over all of these directory wizard files but it still does not work. Its like I am missing a certain link in the chain here. Can anyone shed some light on the topic?The wizard opens up to the first page, which it says next to continue. You would select a company which the code is written to pull a companies list from the network drive, then it creates a folder directory with files in the on that network drive. Now when you lick the initital next button it buttons and takes us to a The website cannot display the page. I still have all the original code files, placed into the same exact directory on the sharepoint server. The sharepoint server is an identical match, but its like somewhere something isnt

I am having some trouble getting coldfusion 10 to connect to a webservice and the error is not helpful at all I was wondering if coldfusion has any error log files for webservices. Thanks,

i am using a eclipse with 2 different plugins - cfeclipse and Team Foundation ServerI  have a project in TFS, and have the same project created in a workspace:Sue_workspace - workspace name     .metadata     Sue_Project          .project           file1.cfm          file2.cfmso that is what my directory looks likeI have set it up with Team/Share to connect it with TFSi can manually check out a file by right clicking and choosing check out file - this will add it to the pending changes in the the Team Foundation perspective2 problems with the cfeclipse perspective1 - the files in the cfeclipse persepctive are not set up as read only (there is no little red dot on the icon) - i have another project that is set up this way but i have no idea how they did it2- how do i make the files automatically check out - if

I have installed coldfusion8 configured as built in web server.  I am using dreamweaver to develop dynamic web pages.  I have created a simple static page with .cfm extention.  When I put the page to the test server to view in a browser, first time, there is no problem.  When I make changes to my page and test it again, I do not see the changes.  The same old page comes up without the changes.  If I change the file name and try it again, the page with all my changes shows up fine. It appears the coldfusion8 built in test server keeps showing my original from memory and is not refreshing unless I change the file name.I will appreciate any help to solve this problem.Thanks,Mohanlg

I am wanting to know if I can use CFLOOP through a query and if a field is not empty create a new div for each of the database records content.  Is this possible or do I need to use just the normal cfoutput? 

Hello,If there is a better way to go about this (which is quite likely), please let me know how to go about it.I'm working on some code that is supposed to dynamically set the form variables as regular variables so that we can be lazy and not have to refer to the variable with form.somevariable name.That part works perfectly.  Until I start testing for URL conflicts in which a URL variable has the same name.  For instance. . .I have a form that passes two variables; FirstName and LastName.  If I hit the page, the form shows up, I input a first and last name and click submit.  The code works perfectly.However, if I have URL variables with the same names, the code reports the url variable values instead of the form values. Some sample values;url.FirstName = Joeurl.LastName = Blackform.FirstName = Steveform.LastName = WhiteMy code that exposes the form variable will correctly find the form field names, but then when I 'evaluate' the value of the given form field, it wi

I'm having trouble pinpointing if anything changed with the cffile upload mime type in CF10.  It was working fine in 9, but I'm getting the following error when uploading a jpg file type in CF10.The MIME type or the Extension of the uploaded file image/jpeg was not accepted by the server. Error detail - Only files of type image/* can be uploaded. <cffile             action="upload"             filefield="Picture"             destination="\\#expandpath('/')#CompanyPictures\"             nameconflict="overwrite"            accept="image/*">

How do I create a document on my I pad; I'm frustrated because what I create is page by page?  I have four pages; I want a four + page pdf.

Is there a way to apply an Access Control List to ORM components? Or maybe another methodology to limit record access depending on the users role(s)? I couldn't find anything on the Web about this. Thanks!

    I am not sure how to do it.  I have the augosugess working fine from the first input field.  When i start enter the name into this box, i want other information automatic to  populate into other text boxses as well  like company , descp for this name.  Can some some pleae help?<cffunction name="lookupItem" access="remote" returntype="array">    <cfargument name="search" type="any" required="false" default="">                <!--- Define variables --->        <cfset var qArt="">        <cfset var result=ArrayNew(1)>                <!--- Do search --->      <cfquery name="qArt" datasource="art">          select *

CFCHART is not rendering on our server for some reason. We  cache to disk and are generating a .SWF file. The. SWF is in the chart cache folder ok, and can be viewed separately, however it will not render within a web page. When we view source we see this <object> tag:<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"  codebase="http://active.macromedia.com/flash2/cabs/swflash.cab#version=4,0,2,0"ID="Images_8879629000100025_SWF" name="Images_8879629000100025_SWF" WIDTH="900" HEIGHT="350"><PARAM NAME="movie" VALUE="/CFIDE/GraphData.cfm?graphCache=wc50&graphID=Images/8879629000100025.SWF"/><PARAM NAME="quality" VALUE="high"/><PARAM NAME="bgcolor" VALUE="#FFFFFF"/><EMBED src="/CFIDE/GraphData.cfm?graphCache=wc50&graphID=Images/8879629000100025.SWF"   quality="high" bgcolor="#FFFFFF" WIDTH="900" HEIGHT="350" TYPE="application/x-shockwave-flash"PLUGINSPAGE="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Versio

Hi,We run CF10 standard on IIS8 Win 2012 and our CF Admin is going haywire. It frequently will not answer on 127.0.0.1 and when it does load it sometimes is missing information in the left nav bar or right hand pane.Today we see "Service Temporary Unavailable!The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.   Jakarta/ISAPI/isapi_redirector/1.2.32 ()"and yet the web site on the server is running fine.We run FusionReactor and when the CF Admin is trying to load there are no running requests to stack trace. How can we debug this?Sometimes, if we press CTRL-R repeatedly, it will load. Individual frames of the admin can be loaded if their address is entered, but the whole thing doesn't load. Most times it just refuses to load in its entirety and if we are lucky enough to get to a login screen, the system will not load after that screen.On Chrome browser we got the Jakarta error, but in MSIE we get in

    Hi,       What i am try to do is when i start enter the name into text box, i want the result is auto refresh or filter  into the cfdiv tag.  My code did not work, can some one please give me a hand?Thanks       <cffunction name="getArtDescription" access="remote" returnType="query">      <cfargument name="name" type="any" required="false">             <cfset var data="">        <cfset var result="">        <!--- Get data --->        <cfquery name="data" datasource="#dsn#">          select * from [dbo].[Arts]        WHERE nam LIKE '#ARGUMENTS.name#%'        </cfquery>&nbsp

<cfif structKeyExists(MyQuery, "MyID")> <CFSET form.MyID= MyQuery.MyID></cfif> <cfif structKeyExists(url, "MyID")> <CFSET form.MyID= url.MyID></cfif>I use above code to check if query ID exists then assign value to my form variable.It seems that it does not work, but it works for url.Can you please help and advise are there any way to check value in query and assign to the form if it is defined?Your help and information is great appreciated,Regards,Iccsi,

HI,I am trying to set up Coldfusion and IIS7. Everything has installed but when I set up a coldfusion website I can see the homepage but when I click to view another page I get a 404 error. The pages are definately there but I cant figure out what is wrong. If I go to the site through the server IP address then everything works fine but not when I use the proper web address.Is there anything else I need to configure to get this to work?any help appreciated!

After a couple of hours of errors and googling, I finally got the dev edition of CF10 to install.  The admin page at localhost/CFIDE/administrator/index.cfm is blank, as with every cfm/cfml page on my server.Can anyone give me some advice to get this running?  Thanks,Mike

Are there any pro/cons I should be aware of in this case?My application has users.  I could create a 'user' object with the appropriate properties and methods to hold the logged in user's information, performing things like: user.getName() and user.logout().   But on the other side of the coin, if I wanted to get the name of a user, I could simply have a structure like SESSION.user.name and just retrieve it's value.  And if I wanted to perform a logout, I could simply call the function in my security component and pass the needed info.I like the idea of using OOP where possible, but is there any issue with going that route vs more simplified non-OOP methodologies?

I'm working on my framework and am at a point where I want to store user information into the SESSION.In my onSessionStart() I've created the default structure, set it into the SESSION scope, and all is well.  To my understanding, if session management is on, ColdFusion attempts to provide a CFID and CFTOKEN value to the user's computer that is tied to the current session, right?  If that user is accepting cookies, those ID's are stored as cookies on their machine, and each time they make a new request to the server, their browser sends those identifiers so that CF can see what session information is tied to that user (due to the stateless nature of HTTP).But if the user has cookies disabled, I'd expect that CF would see that user's subsequent requests as being those from a brand new user, because no IDENTIFIER is being provided in the request, so CF would end up firing off another CFID and CFTOKEN to the user each and everytime they made a request, correct?  This is whe