Skip to main content

ColdFusion

The official community for ColdFusion.

10000+ Posts
I
inked_koiParticipant
 Questions
P
pirlo89Known Participant
 Questions
If checkbox is checked value="0" if is not checked value="1"?

Hello all,I'm trying to get my checkbox functionality to work depends on if check box is checked or not. If I click on the checkbox and is Checked I should send value="0" with my Ajax call. In other case if I unchecked my checkbox I should send value="1" with my Ajax. Here is the code that I have so far: <td><input type="checkbox" name="block" id="block" onChange="updateTable('#CustomerID#')"></td>function updateTable(CustomerID){     if(document.getElementById('block').checked == true){           var blocked = 0;           var whObj = {"url":"/apps/StudentAdmin/ParentTeacherConfScheduler/PTCAjaxFunction.cfc?method=UpdateSchedule&returnformat=json"};           gwAjaxPost(whObj,{"CustomerID":CustomerID,"blocked":block},Result);      }else if(document.getElementById('block').chec

16022
P
D
doncxKnown Participant
 Questions
S
shuij86252296Participant
 Questions
CFDOCUMENT- only the first PDF has the background image displayed in a loop

Here is the sample code. The first PDF file is created just fine, but the rest files are missing background image. Similar issue was reported here Very odd CFDOCUMENT Bug | Raymond Camden's Blog, but I could not find a solution to this issue. Would appreciate any input!<cfloop query = "MyQuery"> <cfdocument    format = "PDF" filename="./docs/#filename#"         overwrite="yes"        localurl="true"><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html><head>    <style type="text/css">        body                {                background-image:url('image.jpg');      &

32311
S
E
EwokStudKnown Participant
 Questions
I've an SQL Statement Which works in Access, but not in Coldfusion

I've an SQL Statement Which works in MS Access 2010, but not in Coldfusion 7.  It's a way to achieve a display of most recent prices for my services, from a table of prices, which includethe date of each new price for each service; there are many services.  I have 2 tables.  the first table lists the services, one record for each service.  The 2nd table lists multiple instances of many of the services from the first table, each instance being a new price.  I do this to keep track of my price history.  The webpage throws an error, stating that: A CFML variable name cannot end with a "." character. SELECT SH1.rpr_srvc_hst_dt, rpr_srvcs.[rpr_srvc], SH1.[rpr_srvc_hst_amt_] FROM rpr_srvc_hst AS SH1 INNER JOIN rpr_srvcs ON SH1.[rpr_srvc_hst_srvc_] = rpr_srvcs.[rpr_srvcID] WHERE (((SH1.[rpr_srvc_hst_dt])=(SELECT MAX(rpr_srvc_hst_dt)     FROM rpr_srvc_hst AS SH2     WHERE SH2.[rpr_srvc_hst_srvc_] = SH1.[rpr_srvc_hst_srvc_]))

4671
Carl Von Stetten
A
alabamaarchivesParticipant
 Questions
E
EwokStudKnown Participant
 Questions
P
pirlo89Known Participant
 Questions
The data types time and datetime are incompatible in the equal to operator?

I have my simple cfquery that should delete records base on the date, start time and end time that have been passed with the arguments. My cfquery looks like this:<cfquery name="qryDelete" datasource="test">   Delete From Table   Where DateS = <cfqueryparam cfsqltype="cf_sql_date" value="#arguments.DateSch#">   and Start = <cfqueryparam cfsqltype="cf_sql_time" value="#arguments.Stime#">   and End = <cfqueryparam cfsqltype="cf_sql_time" value="#arguments.Etime#"></cfquery>I tried to output my argument values, they look like this:DateSch 12/10/2015Etime  08:25 AMStime  08:00 AMFor some reason after I tried to delete records I got an error that looks like this:"The data types time and datetime are incompatible in the equal to operator"I'm wondering why my date and times can not be compared with values in database. Should I convert or format my argument values differently before I pass them in my cfquery for de

13961
Carl Von Stetten
felixm71880667
felixm71880667Participating Frequently
 Questions
K
karenh99274100Participant
 Questions
programmherT
programmherTParticipant
 Questions
Question About CFFormGateway

I'm testing an upgrade to CF11.  Everything is working except my flash form.  When I check the web.xml file, the CFFormGateway servlet mapping is commented out as well as the CFFormGateway filter-mapping.  The CFFormGateway servlet description indicates that this servlet "allows flash forms to connect to CFML and CFC templates".I found references to a possible work-around created by Josh Koop with the HouseofFusion but can't find details about that possible solution; especially since HoF is defunct.I've checked and verified the necessary .js, .cfm, and .swc files are in the CFIDE directory.  I've also verified there is a specified height and width indicated within the cfform tag. Will un-commenting the CFFormGateway servlet and filter resolve this issue with the cfform format="flash"?The pages render but a 404 error - file or directory not found - message is what is actually being displayed.Under the current version, the cfform successfully renders.

9171
BKBK
Community Expert
J
jdavenportctcParticipant
 Questions
After CF 10 Hotfix 18, Postgres datasources would not connect

After installing CF 10 Hotfix 18, our PostgreSQL (9.2.14) datasources would not verify.   All gave error "timed out waiting for connection".  The log of hotfix install said it installed driver postgresql-9.3-1101.jdbc41.jar in the CF lib folder and modified script postgresql.cfm in the CFIDE/administrator/datasources folder. As a workaround, I saved the previous postgresql.cfm script, and saved the driver we were using successfully before the hotfix (postgresql-9.4-1202.jdbc4.jar).  After applying the hotfix, I replaced the postgresql.cfm script with the previous version.  I also got rid of the new postgresql-9.3-1101.jdbc41.jar driver and kept our previous driver postgresql-9.4-1202.jdbc4.jar in the lib folder.   Then I restarted Coldfusion, and after this all of our postgresql datasources did verify.  I have tested multiple CF scripts that use our postgres databases and all seems to be working fine. The last time we installed a hotfix (hotfix 1

2640
J
A
antonellob52317904Participant
 Questions
phongn69753823
phongn69753823Participant
 Questions
L
leDukeParticipant
 Questions
I am having a problem looping over an array created from Groupon JSON file.

I'm sure this is a simple thing to do, sadly I'm stuck! Any help would be appreciated.I need to create a query from a json file from Groupon. I can get the file, deserialize it but then I just run into a brick wall!<!--- Make the request to the API ---><!--- Get the JSON Feed ---> <cfhttp url="https://partner-int-api.groupon.com/deals.json?country_code=IE&tsToken=IE_AFF_0_200012_212556_0&division_id=dublin&offset=0&limit=20"> <!--- Strip the function wrapper. ---> <cfset theData=REReplace(cfhttp.FileContent,          "^\s*[[:word:]]*\s*\(\s*","")> <cfset theData=REReplace(theData, "\s*\)\s*$", "")> <!--- Test JSON data. ---> <cfif !IsJSON(theData)>     <h3>The URL you requested does not provide valid JSON</h3> <cfelse> <cfdump var="#theData#"> </cfif>The file is at: http://www.thefuture.tv/grouponJSON.cfm

3833
BKBK
Community Expert
F
fredp60157821Inspiring
 Questions
cfapplication parameters fail

I have ColdFusion 9 running on a Windows 10 Pro computer.  I am using ColdFusion's built-in server.  Everything runs perfectly.  However, when I run it from another computer on the same network, I get an error I have never seen before.  It balks at one of CFAPPLICATIONS's parameters in the Application.cfm file.  As I mentioned, this Application.cfm file works perfectly locally.  (In fact it is the same Application.cfm file I have been using since Coldfusion 5 running on a Win 2000 Pro machine.)  Here is a bit from that file:<CFAPPLICATION     name             = "FredsWebApps"     clientManagement    = "YES"     setClientCookies    = "YES"    sessionManagement    = "YES"    setDomainCookies    = "NO">but on the local machine I get this error:The system ha

6803
BKBK
Community Expert
U
userCold9Inspiring
 Questions
theRealGoofus
theRealGoofusParticipant
 Questions
K
KamHeyParticipating Frequently
 Questions
sarithap7169542
sarithap7169542Participant
 Questions
E
EWC-abahmerParticipant
 Questions
<cfdocument> css, pdf, and table borders

I'm using <cfdocument> to generate a PDF that contains tables. I have all of my style declarations within the <cfdocument> and those styles are being read properly.My problem is that if I set a background-color for a row, that color overflows onto about half of the right and bottom table borders. Here's an image of what I'm seeing on the PDF document, colors are for visual identification of each border. The PDF prints with the same anomalies.The table border is 1.5pt red line, which you can see on the left and top just fine, but the right and bottom borders are thinner. The rows numbered 1, 2, and 4 all have a class applied to the <tr> providing a background-color (#fff or #eee). To prove what I thought was happening, I adjusted row 3 so that there is no background-color declared at all. Note that row 3 has the proper width for the right table border. Other testing has shown that the background-color is affecting the bottom table border as well.Can I do something to t

37981
James Moberg
WolfShade
WolfShadeLegend
 Questions
P
pirlo89Known Participant
 Questions
Why my cfloop stop after inserting first id?

I created cfloop that goes through query that I created above the loop. Inside of the loop I have another loop that defines values and then cfquery with insert statement. I tested my loops before I tried to insert my records in database and everything looked good. After I tried to apply that to my cfquery insert, only first ID from cfloop qryRecords is inserted and inserting stops after that. Here is example of my code:<cfloop query="qryRecords">      <cfloop condition="TimeStart LTE meetingLength">           <cfset TimeEnd = dateAdd("n", arguments.meeting, TimeStart)>           <cfquery name="addRecords" datasource="test">                Insert Into(Date,Name,Location)                Values(<cfqueryparam cfsqltyp

3951
P
timy94110837
timy94110837Participant
 Questions
Chakri
ChakriParticipant
 Questions
Coldfusion generated WSDL showing wrong targetNameSpace

We recently migration our application from CF 8 to CF 11 Update 3. There is a ColdFusion web service that is being consumed by a .NET application. The cfcomponent tag is specified with the following attributes<cfcomponentstyle = "rpc"bindingname = "component1.cfcSoapBinding"namespace="http://#cgi.host_name#/<webservicefolder>/component1.cfc"serviceaddress="http://#cgi.host_name#/<webservicefolder>/component1.cfc"porttypename = "component1"serviceportname = "component1.cfc">In Our Test server (same CF version), the webservice is invoked by the .NET application successfully. However, in Production server, the .NET application is getting error when trying to invoke the service. The error information at .NET end is :  There is an error in XML document (31, 31). at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)     at System.Xml.Serialization.XmlSerializer.Deserialize(X

12882
Chakri
Show more posts
Firefly Community Gallery
Adobe Firefly

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Explore now
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices