Questions

I would like to design an audit system for our department's intranet, please keep in mind, that I am not a programmer.How I invision it is audit templates would be created, there would be questions that are asked and will always have a response of yes / no / NA, plus a small window to type note.  If there is a no, it will likely also need a corrective action.  There may be 1 question or 25, each audit will be different.Then when the audit is created I would select one of the templates and create an audit for a user to perform.  The responses need to be stored electronically.  Again ir there is a "no" response, it will need an entry in another table for a corrective action.Each template will be used many times.Using a crude method I could create a table for each audit template, but that doesn't make it a very flexible system.How do I create the tables for something like this?  I'm using MS SQL.Thank you for any tips on getting this started.

CF11 ColdFusion.Window.Create has no scrollbars. I have even tried overflow: scroll in the tag attributes and can't get it to work.I'm on a Windows 2012 R2 Server.<cfajaximport tags="cfwindow"><TABLE> <TR>     <TD><img  border="1" src="/Utilities/Images/Icons/folders.ico" onclick="ColdFusion.Window.create('Window123','Sample Window','http://www.blueprintcss.org/tests/parts/sample.html',        {x:100,y:100,height:500,width:500,modal:false,closable:true,        draggable:true,resizable:true,center:true,initshow:true,refreshOnShow:false,        minheight:200,minwidth:50,overflow: scroll})"/></TD>    </TR></TABLE>

It has now been about 5 years since this bug has been in cold fusion. It won't populate cold fusion flash forms in chrome. Bug#3556744 - Flash forms created with CFFORM format="flash" do not render properly in Google ChromeCan I request that this is sorted out asap, it is pathetic that is hasn't been fixed yet!

I'm having problems getting cfpdfform to render the text-field font as it exists in the source pdf form.The source pdf form was created in Acrobat 9 Standard.When I download the pdf from the server using cfcontent, the text-fields look as expected, retaining their designated font (and the pdf has the desired fonts embedded).However, when I do a cfpdfform action="populate", the text-field font is switched with Courier (even though the desired fonts remain embedded).This happens regardless of what font I pick.I have verified that the font exists on the server and in cf admin.Here's my code:<!--- populate ---><cfpdfform action="populate"            source="#pdfPathFile#"            destination = "#pdfPathFile#"            overwrite = "yes">    <cfpdfformparam name="student_name" value="first name and last name"

Google Maps has a restriction on how many map markers can be requested per second.  The limit is ten per second.  I am looking for the "best Practice" on how coldfusion developers address this limitation.  I am looking to display a map of the US with 125 location markers.  Ideally I would like to cache the map for retrieval for both efficiency purposes and to avoid depletion of the total requests that Google allows per day.  Thanks in advance for any insight that you can lend.

My question is essentially this:How do I transform data from SQL Server and map it in Leaflet?HINT: We are running Coldfusion 11, SQL Server 2000, Leaflet and JQuery if that helps in any way. If I need to download a javascript library I can easily do so.I have ambulance and fire events in a database with xy coordinates. My goal is to query out the current events and place them on a Leaflet map. All of our ambulances and fire trucks have gps in them and they are constantly broadcasting their location and status. Here is my query for getting the latest gps data for each truck;/*SQL Server 2000David Kulpanowski4 June 2015Lee County EMS*/SELECTDateTimeStamp, RTRIM(CallSign) AS [CallSign], RTRIM(UnitStatus) AS [UnitStatus], Latitude, Longitude, CONVERT(VARCHAR(15), DateTimeStamp, 106) AS [CurrentDate], CONVERT(VARCHAR(10), DateTimeStamp, 108) AS [CurrentTime]FROM FireEMSGPSDatabaseRIGHT OUTER JOIN(SELECT  RTRIM(CallSign) AS [Ambulance], MAX(DateTimeStamp) AS [MostRecentTime]FROM HISTOR

Hi,I'm getting this error : Variable ESAPIENCODER is undefined.my code is this:<cfset esapi = CreateObject("java", "org.owasp.esapi.ESAPI") />  <cfset esapiEncoder = esapi.encoder() />not sure what I missed in the configuration.I do appreciate any help.Thanks in advance,rdm

I am using query of query to run against a product search using verity.  I have sort buttons that can sort the results by name or price, asc and desc.  When sorting by price, it is not sorting properly.  Here is an example:$110.00 $110.00 $115.00 $124.00 $24.00 $36.00 $40.00 And so on.  What is going on?  Is there any way to fix this?  Thanks.

I have just bought a Coldfusion license for a client and I realized I need a testing environment. Since I work remotely from my clients site, I would want to have a testing site that is online. What are the rules on this can I install the license on the testing server that is only accessible to my client and not to the general public?

Hi all,I'm getting an issue with rotate header text in pdfim using this css -webkit-transform: rotate(-90deg); code for  rotate header text . it is working fine in cfm page but not working when convert it to pdf using cfdocument tagplease  help to solve this thanks in advanceBibin

Hi. I have a currency field on a form page that gets inserted into a currency field in Access. Is there  a way to check the validation of this field so it's correct before it gets added to the database? I can't use the Integer validation because that requires whole numbers and won't allow decimal points. I also have the $ pre-filled in. I could remove that if I had to. I just want an error to display letting the user know that they entered the dollar value incorrectly. There have been some issues with some people entering a number like 52.00.00 and it errors out and things get all goofed up in the database. Thanks for your help.Andy

I'm developing an app. in CF10. It's been determined that this app. will be opened through a link that is created in a dot net app.Users need to log in & log out through the dot net app.  To see the link, user need to log in then my CF app open up once users click that link so there is no log in/out requirement from my CF app.The link passes a user id through url, I need to use url.userid to create CF session.userid.So I created the session user id in onSessionStart in application.cfc :<cfset session.userid = #Trim(URL.userid)#>The problem is, when I log out and log back in as a different user, my previous session.userid still exists. So I have two different session.userids.In order to avoid this I thought I can do the following in onSessionStart in my application.cfc:<cfset sessionInvalidate() /><cfset session.userid = #Trim(URL.userid)#>Since every time the application start CF has to go through application.cfc first my thought would be that sessionInvalida

Can any one help me out giving a good example to understand when should I scope a query result sets in a session scope.‌

I installed CF11 on a CF9 machine (Windows 2008 R2 Standard).  The website running on CF9 is fine but I can't get to the administrator.  It says the file isn't found and does not exist.

Hi,in CF10, I'm trying to print barcodes with ttf barcode fonts inside a PDF document generated with the cfdocument tag. The barcode is generated, but with wrong spacing.The code printing the barcode is quite simple:<span style='font-family:Code-39-25-DMI;font-size:32.0pt;letter-spacing:0px'>*BKUM70709997B*</span>This is what it should look like:cfdocument renders the barcode like this:The spacing between the individual barcode characters is wrong. The "letter-spacing" CSS option doesn't make andy difference. Any idea for a solution?Regards, Richard

Hi,We have a time clock (time tracking) web application that I need to change the user authentication from a traditional username/password to a fingerprint scanner.Has anybody done this before and is willing to share some insights?We are willing to pay somebody too.I've looked around and could not find a whole lot of information. I did try to jump into some Java SDKs for various devices, but my knowledge of Java is not the greatest.Please let me know if you've done this before.Thank you!!!

I have login code that has worked perfectly for years. It still works in development, but has stopped working in production. The only change has been a recent "upgrade" to ColdFusion 11. Here's what's happening.User logs in.SESSION.login is set.User moves around from page to page and finally clicks a link that's formatted like so, "/admin." (The entire site is configured in IIS to use index.cfm as a default document.)SESSION.login (along with a number of other session variables) disappears so the user is take to the login screen even though he/she has already logged in.Now, if I change the link in step three above to be "/admin/index.cfm." then the session variables do not disappear and the user is simply taken to the page like they should be instead of being prompted to login again. I have no idea why the elimination of the directory's default document the link would trigger ColdFusion to purge session variables (especially when it's always worked fine in the past), but it does. What'

Hello.I'm currently running ColdFusion 9.0 on a Windows Server 2008 R2 machine.  I need to uninstall ColdFusion altogether so that I may reinstall it.  My ColdFusion came with an 'uninstall' directory, which contains the file "Uninstall Adobe ColdFusion 9.exe".  However, when I try to run this program, I get a JVM error.  I've tried running this program as adminstrator, as well as updating my JVM to the newest version (in the case that it was a version mismatch).  This hasn't solved anything.I then turned to the "Programs and Features" section of the control panel, where it shows an "Adobe ColdFusion 9" instance.  But, when I try to uninstall here, I get the message "You do not have sufficient access to uninstall Adobe ColdFusion9.  Please contact your system administrator."  I am logged in as the administrator, and am able to uninstall other programs.Any ideas or information would be greatly appreciated!Thanks,

I have found this page, Adobe ColdFusion 9 * Configuring and using session variables, but I do not know if the way I'm using is correct. In the contact us page, I set the session variable to 1 (for yes the user has turned off java script). In the submission-success.cfm, I tried this:<cfif #session.EmailSuccess# eq 1>  <cfif (form.mailto is not "" AND form.mailfrom is not "" AND form.message is not "" AND form.name is not "")>  <cfset session.myweb.email.success = "true">   <cfmail to = "#form.mailto#" from = "#form.mailfrom#" subject = "Inquiry from Contact Us Form by #form.name#" server="smtp.myweb.com" port="25" type="html">  <cfoutput>   <p>This message was sent by an automatic mailer by #form.name#:</p>  <p>= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =<p>  <p>#form.message#</p>  <p><cfif structkeyexists(form, "phone")>Phone: #form.phone#</cfif&g

I recently migrate code from a CF8.01 instance to a freshly installed/updated CF11 instance. As I was going through some testing I ran into an issue where the "setter" methods within a CFC are not setting the values of the locally scoped instance data within the CFC. The exact same code works on CF8. I read a couple articles which made reference to a new attribute of the cfcomponent tag (accessors=true) that will implicitly create getters/setters. I am not using this attribute so I'm not sure if that has anything to do with it. Below is some sample code.test.cfm:<cfscript>   myObj = CreateObject('component', 'WorkUpBean').init();   myObj.setTypeID(2);</cfscript><cfdump var = "#myObj.getTypeID()#">WorkUpBean.cfc:<cfcomponent name="WorkUpBean" displayname="WorkUpBean" hint="I am a workup bean"><cfscript>  local = StructNew();  local.TYPE_ID = 0;</cfscript><cffunction  name="init" access="public" output="false" retu

I have an order form where my buyers can add items to my form. I am using a loop that adds an extra line when they add a new product. I am storing the info in two different mySQL tables. The first is alll of the personal info, the second is the items. THe personal info saves correctly. However, I get the following error when saving the items:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1, 'wer 2345', 1, 1 )' at line 9 The error occurred in E:\webs\clarkwebhosting.com\SSL\esrc\order_add.cfm Line 74 ++ After storing the personal info I grab the order ID to populate the items table<cflock timeout="5"><cfquery name="qGetorderID" datasource="#application.dsn#">select max(orderID) as oid from orders</cfquery></cflock><cfoutput><cfset getoid = #qGetorderID.oid#></cfoutput>++ this is the loop I am using to populate the items table ++<cfloop from="1" to="#form.n

A ColdFusion 8 project was running under Windows server 2003 which was upgraded to Windows server 2008.The project has frames and client variables stored in the registry.After the Windows upgrade, a few users have had client variables disappear. The variables are assigned and displayed in a template in a frame but lost after being submitted to another template in another frame.The users get an error that "element xx in undefined in client".What are possible causes and solutions?

Hello -We have recently migrated about a dozen sites to a new server running Windows Server 2012 R2 and ColdFusion 11.  Everything seems to be working correctly except for .cfr pages.  IIS throws a generic 404 when attempting to access pages with this extension.  We have the Jakarta virtual directory setup correctly and our file mappings also look to be correct.  Allowing the app pool to run 32-bit applications changes the error from a 404 to an internal server error 500.  Any ideas?  Thank you!

Hi. I have a field in my SQL database that is an integer field. When I try to use this field in my form, it only allows whole numbers to be entered. How can I allow numbers with decimal points to be entered? The field name is called Eng_Hrs. Here's what I have on the Form:<tr><td class="edit" align="left">Engineering Hours:    <input type="text" name="Eng_Hrs" size="12" validate="integer" <!--- required="no" ---> message="You must enter a valid number in the Engineering Hours field"></td></tr>I realize I could make this a text field and it would allow decimal points, but then how could I validate this field to make sure that only whole numbers or numbers with decimal points are entered?Thanks.Andy

Hi,Currently running Cold Fusion 11 on a 32 bit Windows 2008 server.At times receiving the message on the screen "The service is unavailable"Restarted the ColdFuison 11 Application Server service and the application came back.I  looked in the coldfusion-error.log file and found the following message:Caused by: java.lang.OutOfMemoryError: Java heap space] with root causejavax.servlet.ServletException: ROOT CAUSE: coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:309) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:462) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:142) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter