Combining Select and Insert into the same CFQuery tag

So you want to grab some values and insert them into a table.
Here is the hard way.


<cfquery name="selectQuery" datasource="#application.dsn.db2#">
    SELECT Setting1,Setting2,Setting3
    FROM defaultSettings
    WHERE ID = 101
</cfquery>

<cfquery name="insertQuery" datasource="#application.dsn.db#">
INSERT INTO Settings
    (TS,
    Name,
    Setting1,
    Setting2,
    Setting3)
VALUES(GetDate(),
    'Test',
    <cfqueryparam cfsqltype="cf_sql_varchar" value="#selectQuery.Setting1#">,
    <cfqueryparam cfsqltype="cf_sql_varchar" value="#selectQuery.Setting2#">,
    <cfqueryparam cfsqltype="cf_sql_varchar" value="#selectQuery.Setting3#">)
</cfquery>

Here is the easier way, combining both Select and Insert in the same CFQuery block.


<cfquery name="insertQuery" datasource="#application.dsn.db#">
INSERT INTO Settings
    (TS,
    Name,
    Setting1,
    Setting2,
    Setting3)
SELECT GetDate(),
    'Test',
    DS.Setting1,
    DS.Setting2,
    DS.Setting3
FROM defaultSettings DS
WHERE DS.ID = 101
</cfquery>

Comments

Dyson AM09 Fan & Heater H2 Error

No idea what the actual error is and I couldn't find anything useful on the web, so hopefully this will help someone else. I assumed that the H2 error meant that something was dirty, clogged up or that it was overheating because it was dirty or clogged up because the error only showed up when it was in Heater mode. The heater would run for about 30 seconds, then it would show the error and switch over to the high speed fan , I assume to try to blow out the dust. I proceeded to open it up to give it a deep clean because the Dyson instructions for cleaning this thing are ridiculous and don't help at all. Gently wiping down the outside and vacuuming the intake holes....really Dyson, really?! I used cotton swabs and 91% alcohol to clean everything I could get to, starting at the base (in hindsight, this part may not be necessary at all). Then I got to the top of the device where the actual air comes out of and noticed that there was a lot of build up on the heater coils. I could...

ColdFusion to Node.js Conversion : Setup Part 1

This multi-part post will be community comment driven, which basically means that in an effort to not spend too much time on details that might not matter to the viewers out there, I am only going to share the details which I think are important at the time of publishing the posts. If people (or bots) comment and want more details, I will add them to the original post. As always, constructive criticism is always welcome. Since I am currently using the CFWheels framework (which is inspired by Ruby on Rails or RoR), I chose to try out the Sails.js framework for Node.js (which is also similar to Rails). 1st thing I did was get Node and Apache working together by adding this to my Apache vhost(VirtualHost) block: ProxyRequests on ProxyPass / http://localhost:8124/ And adding this to my hosts file (/etc/hosts): 127.0.0.1 mynewapp.node www.mynewapp.node This allows me to setup an alias in my host file and reference the URL as you normally would without adding the portnumber o...

ColdFusion Invalid Image Format Solution

For those who have gotten the following error: "java.awt.color.CMMException: Invalid image format" and tried the solutions posted here with no avail. We are going to use the power of Java's JAI (Java Advanced Imaging) library to tackle this one. <cfscript> //path to image imagePath = "pathToImage"; //create java file object, passing in path to image imageFile = createObject("java","java.io.File").init(imagePath); //create a FileSeekableStream, passing in the image file we created fss = createObject("java","com.sun.media.jai.codec.FileSeekableStream").init(imageFile); //create ParameterBlock object and initialize it (call constructor) pb = createObject("java","java.awt.image.renderable.ParameterBlock").init(); //pass in FileSeekableStream pb.add(fss); //create JAI object that will ultimately do the magic we need JAI = createObject("java","javax.media.jai.JAI"); //...

KraFusion

Search This Blog