ColdFusion

Hello everyone, I have question about inserting records in two different tables at the same time, what I'm looking for is passing unique id that gets created in first insert statement to second insert statement. Example for this problem:<cfquery name="addRecords1" datasource="test">      Insert Into Table1(Name, Date, Age)      Values (<cfqueryparam cfsqltype="cf_sql_char" value="#arguments.Name#">,                  <cfqueryparam cfsqltype="cf_sql_date" value="#arguments.Date#">,                  <cfqueryparam cfsqltype="cf_sql_int" value="#arguments.Age#">);      Select SCOPE_IDENTITY() As RecID;  </cfquery>  <cfquery name="addRecords2" datasource="test">       Insert I

Hello everyone, I have a question about inserting dynamic table with time values. Here is example of the table that I have to insert in db:Schedule for 10/05/201609:30 AM - 10:00 AMRemove10:00 AM - 10:30 AMRemove10:30 AM - 11:00 AMRemove11:00 AM - 11:30 AMRemove11:30 AM - 12:00 PMRemove05:00 PM - 05:30 PMRemove05:30 PM - 06:00 PMRemove06:00 PM - 06:30 PMRemove06:30 PM - 07:00 PMRemoveI do not have a problem to insert values if my time difference in always the same. Like first few time slots are increased for 30 min but then I have a gap from 12:00pm all the way until 5:00pm. My problem is there. I do not know what is the best way to save these values. Since values are created dynamically and all of them are under the same date. If I do not have time breaks that would be really easy but in this case where I have time gap looks really complicated. If anyone can tell me what si the best way to store this in database please let me know. Thanks in advance.

Adding new category names are showing the following error.  Also, it is not allowing me to edit the names at all.  Please help resolve this.  Thank you.Field 'blogCategoryid' doesn't have a default valueRoot cause :java.sql.SQLException: Field 'blogCategoryid' doesn't have a default valueThe error occurred in C:/ColdFusion11/cfusion/wwwroot/learncfinaweek/chapter1solution/admin/content/blog/editcategory.cfm: line 33<cfset ormFlush() />editCategories.cfm:<cfimport taglib="../../customTags" prefix="ct" /><ct:securityCheck redirectPage="#cgi.script_name#"/><cfparam name="url.id" default="0" /><cfparam name="form.submitted" default="0" /><cfparam name="form.id" default="0" /><cfparam name="form.name" default="" />                <cfparam name="form.categories" default="" /><cfset errorBean = createObject('learncfinaweek.chapter1solution.admin.cfc.erro

So I'm using the following code to create a PDF from data from a query.<cfpdfform action="populate" source="test.pdf" destination="GeneratedPDFs/test.pdf" overwrite="yes"><cfpdfformparam name="FirstLine1" value="#Variables.FirstLine#"><cfpdfformparam name="SecondLine1" value="#Variables.SecondLine#"><cfpdfformparam name="AddressBox1" value="#Variables.AddressBox#"><cfpdfformparam name="Body1" value="#Variables.Body1#"><cfpdfformparam name="FirstLine2" value="#Variables.FirstLine#"><cfpdfformparam name="SecondLine2" value="#Variables.SecondLine#"><cfpdfformparam name="AddressBox2" value="#Variables.AddressBox#"><cfpdfformparam name="Body2" value="#Variables.Body2#"></cfpdfform><cfpdf action="write" source="GeneratedPostCards/!PostCard2013-Vipre.pdf" destination="GeneratedPostCards/!PostCard2013-Vipre-flat.pdf" flatten="yes" overwrite="true"></cfpdf>This works fine, and generates the PDF for me, but I've run into thr

I have come across an interesting issue and hopefully I'm not the only one with this scenario.  First the environment: 64-bit Windows Server 2008 (I found the same issue on SP2 and R2), ColdFusion 9.0.1 Enterprise edition, ColdFusion HotFix 1, IIS 7 (native mode), Sun Java 1.6.0_22, Microsoft SQL Server 2005 (on a different server).The issue that I have is I cannot get my datasource to verify.  ColdFusion returns this error:Connection verification failed for data source: clientsjava.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.Now here is what I have found so far.  I think I have finally narrowed this down to an issue with the Sandbox Security and the fact that we are using a database instance on our SQL server.  With the S

Hello,Box.com has an API that allows files/folders to be manipulated programmatically.  The syntax using the curl command to generate a link to a file uploaded to box.com is:curl https://api.box.com/2.0/folders/FOLDER_ID -H "Authorization: Bearer ACCESS_TOKEN" --data '{"shared_link": {"access": "open"}}' -X PUTI'm unable to figure out the correct syntax for sending the --data part of the curl command.  So far, I have this:    <cfhttp method="PUT" url="#web_svc#"  redirect="yes" timeout="30">        <cfhttpparam type="header" name="Authorization" value="Bearer #access_token#"/>        <cfhttpparam type="formField" name="shared_link" encoded="no" value="{"access": "open"}"/>    </cfhttp>But Box throws an error:Invalid value '0={"shared_link": {"access": "open"}}'. Entity body should be a correctly nested resource attribute name/value pairAny suggestio

I migrated my application from CF9 to CF11, and got a serializejson issue. When serialize object data with empty string,  the serializejson function generates invalid string.I have function getConfiguration in A.cfc and function getImageResult in B.cfc. The function getConfiguration would get an object data and serialize them to json, then return the json data. Below are the object data and the generated invalid json. In this case, I would got json parsing error when deserialize json in getImageResult function.Object data: {      RESULT: true       MESSAGE: call function getConfiguration successfully       OBJECT: {          HID: [empty string]          TF_LAB_USE_DOCUMENT_MANAGEMENT: [empty string]          PARENT_HID: [empty string]      }   &

I have several errors that I could use some help on.  Below is just one of them.  I mention that in case I need to bring them all up in order to troubleshoot this correctly.  Maybe it is worth noting that I am going through the learncfinaweek.com hands on (ORM) and have most of the code working except the categories that keep the boxes checked in editBlogPost.cfm and Categories are not saving correctly.  That said, here is the first error:The cfdump showed that title is getting pulled in, so I would like to know why it won't pass the var.  Element TITLE is undefined in BLOGPOST   The error occurred in C:/ColdFusion11/cfusion/wwwroot/learncfinaweek/chapter1solution/admin/content/blog/listblogpost.cfm: line 34listBlogPost.cfm:<cfimport taglib="../../customTags" prefix="ct" /><ct:securityCheck redirectPage="#cgi.script_name#"/><cfset adminPath = createObject('learncfinaweek.chapter1solution.admin.cfc.system').getBasePath(cgi.script_name) />&

Version 3.0.3.292922    Build 292922Running on Windows Server 2008 R2 Standardjava version 1.8.0_66Editing local files (not on a mapped drive or directory)Seems to only happen in components that are using CFSCRIPT, but not all components.I just created this simple component:(note: using ColdBox for dependency injection)<cfscript>component name="facility_service" {     property name="facility_dao" inject="model:facility_dao";     query function getFacilityQuery(string loc_level ="") {          return facility_dao.getFacilityQuery(loc_level:loc_level);     }}</cfscript>This component works fine and does what it should do.But if I attempt to edit the function:     query function getFacilityQuery(string loc_level ="") {          if (loc_level EQ "") {       &nbs

Hi, I installed CF 11 Developer edition on Windows 12R2 and I have Oracle 12c as db. I installed both 32-bit and 64-bit of Oracle 12 clients. I tried to set up a data source using both odbc and jdbc approaches, but none of them is working. I ran the odbcad32.exe file from "C:\Windows\System32\", and odbcad32.exe from "C:\Windows\SysWOW64" to set up my data sources. Both connections are tested successful. For odbc, it said "The specified DSN contains an architecture mismatch between the Driver and Application". For jdbc it said no suitable driver available. Has anyone seen this and solved it? Thanks for any pointer.

ColdFusion‌

What does this mean and how can if fix it?  the message reads "413 Header Length to large."

My CF9 server suddnely stopped proving debug output. Debug output is set to yes and I've got the correct ip addresses. I have even tried  <cfsetting showDebugOutput= "true">, but nothing appears. Any ideas?

I have an old HP ProLiant server with ColdFusion 10 on it.   The server is government provided and is running Windows Server 2003. It is agonizingly slow, especially via my company's VPN.  The SysAdmin at the office spun up a VM Windows 2008 R2 server for me and I'm in the process of transferring everything from the old server to the new one.   It is a development database.   I have downloaded and installed Oracle 11g on the new server, imported the old database and code.  Oracle allows you to download and use the software for free if it's a single user development machine.   I am under the impression that Adobe doesn't do the same with CF.   What is the process to transfer the license?   Since this project is at end of life, my government customer doesn't want to spend money on a new server, or any new software.   Any help would be greatly appreciated.

Can Cold Fusion 9 or 10 be successfully installed on Windows 8?I have a fresh install of Windows 8 with IIS 8. There are no other applications. When I install Cold Fusion 9 or Cold Fusion 10 (with admin rights), I get the same error:This Application has Unexpectedly Quit Invocation of this Java Application has caused an Invocation TargetException. this application will now exit. (LAX) Details...ZeroGur: Windows DLL failed to loadat ZeroGa4.b(DashoA10*..)at ZeroGa4.b(DashoA10*..)at com.zerog.ia.installer.LifeCycleManager.b(DashoA10*..)at com.zerog.ia.installer.LifeCycleManager.a(DashoA10*..)at com.zerog.ia.installer.Main.main(DashoA10*..)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)at com.zerog.lax.LAX.launch(DashoA10*..)at com.zerog.lax.LAX.main(DashoA10

Have there been any issues with installing CF-9 on a Windows Server 2008 R2? Also if there is no issue should I install the JAVA 1.8 JDK Windows Server 2008 R2? I was looking thru the Windows Server 2008 R2 control panel and could not find a instance of Java being installed.I have tested running Java 1.8 with CF-9 on my local workstation Win 7 and see no issues. I need to update the Java so I can process Credit cards with Papal.Any advice is greatly appreciated.

General Availability／End of core support／End of Extended　Supportと以下のサイトに記載がありますが、違いを知りたい。URL：http://www.adobe.com/support/products/enterprise/eol/eol_matrix.htm

Hi,I know this is a stretch, but has anyone run the Sybase Advantage database successfully with Coldfusion 11?  I installed CF 11 in lockdown mode and it appears to be working.  Works fine with an Access test DB on a Windows 2012 R2 server.The developers installed the site, defined the JDBC DSNs and they verified ok.  Some types of queries work: select was ok, insert appeared to be ok, but update queries failed with an HTTP 500 error:HTTP Error 500.0 - Method com/extendedsystems/jdbc/advantage/ADSPreparedStatement.getGeneratedkeys()Ljava/sql/ResultSet; is abstractI've Googled that response but found nothing relevant.So far the Advantage JDBC Drivers from version 8.1 to 11.1 have been tested but same result.Thanks!--Ben

PLEASE NOTE: the fix for this issue is now in all updates for CF11.  If you are experiencing the same problems identified in this thread, you no longer need to contact Adobe to receive the hotfix.  Simply install any of the updates from within CF Administrator and the hotfix will be automatically included.  You may need to start ColdFusion from the command prompt to get into the CF Adminstrator; but once you have successfully entered the Administrator and installed the update, you should be able to close the command prompt and restart the ColdFusion service successfully. --Carl Von Stetten, ModeratorI have 2 Windows Server 2012r2 boxes that I'm setting up. One is an RDS machine for some Devs to log onto and they other one will be a Production server for running scheduled tasks (separate from our main production server). The issue I've run into is that for some reason Coldfusion11 will no longer restart. If I restart the Server it is fine, but a restart after that it just

<cfchart Format="flash"chartHeight="250"chartWidth="400"showXGridlines = "no"showYGridlines = "yes"gridlines="2"xOffset="0"yOffset="0"dataBackgroundColor= "##CECFFF" showborder="no"font="Arial"fontsize="12" fontbold="no" fontitalic="no"labelFormat = "currency"show3D="yes" rotated="no" sortxaxis="no"showlegend="no"seriesplacement="stacked"showmarkers="no"backgroundColor = "##CECFFF">

How can I prevent someone from downloading the web.xml file using a Nessus exploit. I do have access to the ColdFusion administrator and enabled several security settings but WEB-INF/web.xml can still be accessed.I have spent the last 2 hours trying to find the solution online.Sorry if that is an obvious setting but I don't know much about ColdFusion as I am a IBM Notes administrator...

Using ColdFusion Builder Version: 3.0.0, Build: 292922I am having a problem with file encoding.  I have set the encoding to UTF-8 everywhere I can find but files are still in ANSI and words like résumé are saved as Résumé.  You can actually see the corrupted text if you look at the file with Notepad so it's not a content encoding display issue with http headers.  Brand new blank .cfm files created from the "New..." dialog in CF Builder seem to begin as UTF-8 but switch to ANSI if I re-save them.I have set UTF-8 in the following locations in CF Builder, none of which seem to help:Window > Preferences > General > Content Types > Text:  Default encoding set to "UTF-8" in field at bottomWindow > Preferences > General > Workspace > Text File EncodingFrom Navigator window, R-Click my project and click "Properties", Resource, under Text file encoding set to UTF-8 (tried to inherited and explicitly set under "other")Edit > Set EncodingIs there a

I inheirited links ending with .jsp.  The domain is now pointing to my cf9 standard / iis7.5 web server. When I tried to open the my version of the .jsp file or perform a url rewrite, I recevied an error that JSP is not licenced on Standard edition.However, I don't want to run a jsp as a jsp template.  I would like it to run as a .cfm file.  Or ignore the file completely so I can use a url rewrite to point to my cfm file.I tried to disable JSP from the default-web.xml files.  I am now getting an error 403:Forbidden. What else needs to be done to stop Coldfusion from recognizing jsp files?Thanks,Gary

I asked this question over in stack exchange as well but I'm curious to hear the opinions from my fellow CF developers to see if anyone has any insight on this.  If you'd like to chime in on the stack exchange thread instead, click here.I'd like to know the correct/optimal way to create a database schema for a ColdFusion based online store that allows customers to pay their invoices in full or in X number of monthly installments.I've played around with a couple different ways of accomplishing this and the first issue that came up for me was whether the scheduled payments should be calculated on the fly (by ColdFusion) or whether each scheduled payment should exist as a record in a database.I'm going to assume that the best-practices way would be to have a separate database table to store these scheduled payments (even if it's just one record for a pay-in-full situation). Here's the database schema I have been playing around with:The current plan is to create a single invoice when

I know little to nothing about coldfusion. I need to create a form. The info the user enters needs to be encrypted or secure somehow, and this info will be emailed to it's destination. Is this even possible?