Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Exit
weezerboy
Participant
weezerboy
Participant
Activity
Apr 10, 2020
11:19 AM
Is there a way with ColdFusion to configure a website for access without the 'www' domain name prefix? I know you normally would change the DNS settings to do this. But is there a way that if someone goes here https://mywebsite.com/ That Coldfusion can redirect them to here https://www.mywebsite.com/
... View more
Apr 09, 2020
03:52 PM
Thank you, Charlie, Wolf, and Dave. You each have answered dozens of questions for me over the years. On this yes I remember now that MSSQL with CF, I need to get the drivers, etc. You are all correct! Last question on this: Is there a best link for reference on how to set up a CF DSN with MSSQL?
... View more
Mar 22, 2020
04:30 PM
Last week I spent a week trying to get a MySQL DSN setup. I gave up after 12 hours of trying. Last month I spent hours trying to set up a cf DSN in access. That didn't work. This weekend I've tried to set up a CF DSN using MS SQL Server 15.0. Again I can't get it to work. Is there a database that I can easily connect CF to anymore? Should I use windows authentication for the MS SQL or SQL Server authentication, do I need a connection string, what do I need to do? It seems like its harder than ever just to get going using CF.
... View more
Feb 21, 2020
08:44 AM
1 Upvote
I've switched to MySQL. Thank you !
... View more
Feb 19, 2020
04:44 PM
I am trying to set up a CF DSN using Access 365 (accdb) on win10 CF 2018 and I get this error message Unable to update the NT registry. Variable DRIVERPATH is undefined. The google results are all over the board. Change the Registry key, change to 32 bit, etc. Is there a known solution to setting up this dsn?
... View more
Aug 16, 2019
06:59 AM
1 Upvote
The master has spoken. Thank you, Charlie!
... View more
Aug 15, 2019
02:50 PM
I have a form that submits to itself like this <form action="" method="post"> <table > <tr> <td width="50"><input type="checkbox" name="client_id_C" value="#client_id#" ></td> <td width="50"><input type="text" name="#client_id#_Fee" value=""> </td> </tr> </table> </form> The client_IDs are 101,102,103 etc So when I fill out the form I get form values like this 101_Fee = 1000 102_Fee = 2000 103_Fee = 3000 I also get a list of the client_id's like client_id_C = 20864,21238,21284 My question is once the form is submitted and the form reloads. I want the fee values to populate the #client_id#_Fee text boxes, like this <form action="" method="post"> <table > <tr> <td width="50"><input type="checkbox" name="client_id_C" value="#client_id#" ></td> <td width="50"><input type="text" name="#client_id#_Fee" value="#(#client_id#_Fee)#"> </td> </tr> </table> </form> Obviously what I have in red doesn't work The problem is how do I code to get the value? For example I want the value for client_ID 101 to be 1000 Like this <form action="" method="post"> <table > <tr> <td width="50"><input type="checkbox" name="client_id_C" value="101" ></td> <td width="50"><input type="text" name="101_Fee" value="1000"> </td> </tr> <tr> <td width="50"><input type="checkbox" name="client_id_C" value="102" ></td> <td width="50"><input type="text" name="102_Fee" value="2000"> </td> </tr> </table> </form> What code goes in the value where the red text is.? Because the variable already contains # tags.
... View more
Aug 13, 2019
06:46 AM
I have a web page where users submit a form and info is sent to a 3rd party vendor. The issue I have is that it takes a few seconds for the process to complete and my users are hitting the submit button multiple times. and its causing issues with multiple submissions to the 3rd party vendor. QUESTION: Is there a way to send the user to the next page as soon as they hit the submit button while the code processing takes place? So they cant hit the submit button more than once Like this Submit button Send the user to the next page Continue processing code with 3rd part vendor
... View more
Jun 06, 2019
08:40 AM
I have this code <cfif len(trim(form.fileUpload))> <cffile action="upload" fileField="fileUpload" destination="#FileDirectory#" nameconflict="makeunique"> <cfset FileName ="#FORM.lname#_#FORM.file_type#_#FORM.key#"> <cffile action="rename" source="#FileDirectory##cffile.serverfile#" destination="#FileDirectory##variables.filename#-0.#cffile.serverFileExt#" nameconflict="makeunique"> </cfif> It is code where users upload files and they get uploaded. If there are files with the same name they get renamed and made unique. For example Upload 1 = REV-D_166032-0.docx Upload 2 = REV-D_166032-01.docx Upload 3 = REV-D_166032-02.docx I have this on a Railo server and it works fine. But I have the exact same code on a windows server and it works differently. It overwrites the existing file. Like this Upload 1 = REV-D_166032-0.docx Upload 2 = REV-D_166032-0.docx Upload 3 = REV-D_166032-0.docx Is there some server setting on the windows server that I need to change? Is there some change in the code I need to make?
... View more
May 15, 2019
06:29 AM
So is the consensus that I should surround strings with quotes. For example, Like this? <cfset AuthKey = "#mid(line1,19)#"> <cfset RefToken = "#mid(line2,15)#"> <cfset RefToken = "239hy9uiw784fbew43y7"> What does this mean? There is no need, and no value added, to use both hashes and quotes to call CF expressions that return strings I have changed all of the values used in this example. They aren't real credentials.
... View more
May 14, 2019
03:24 PM
I have this code Example #1 <cffile action = "read" file = "./config.txt" variable = "fileContents"> <cfset line1 = listGetAt(fileContents, 1, chr(10))> <cfset line2 = listGetAt(fileContents, 2, chr(10))> <cfset AuthKey = #mid(line1,19)#> <cfset RefToken = #mid(line2,15)#> <cfset contentBody = "grant_type=refresh_token&client_id=bcbb1365893&client_secret=62b5a8a84567992666tf986a3f474791e&refresh_token=9312beb987fbd8efebf6dc&scope=read%2Bwrite" /> <cfhttp method="POST" url="https://api.wedoo.com/oauth2/access_token"> <cfhttpparam type="header" name="Content-Type" value="application/x-www-form-urlencoded" /> <cfhttpparam type="formfield" name="grant_type" value="refresh_token" /> <cfhttpparam type="formfield" name="client_id" value="bcqq13f2d1d320543524"> <cfhttpparam type="formfield" name="client_secret" value="62b5a8a84567992666tf986a3f474791e" /> <cfhttpparam type="formfield" name="scope" value="read+write" /> <cfhttpparam type="formfield" name="refresh_token" value="#RefToken#" /> </cfhttp> <cfset cfData = cfhttp.filecontent /> <cfoutput>#cfData#</cfoutput> When I run this code I get a 500 error. I'm on a Railo server so I don't get any more info. I can confirm the RefToken value from line 5 is 239hy9uiw784fbew43y7 ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- But when I actually put the RefToken value in the code it works fine..like this Example #2 <cffile action = "read" file = "./config.txt" variable = "fileContents"> <cfset line1 = listGetAt(fileContents, 1, chr(10))> <cfset line2 = listGetAt(fileContents, 2, chr(10))> <cfset AuthKey = #mid(line1,19)#> <cfset RefToken = #mid(line2,15)#> <cfset RefToken = 239hy9uiw784fbew43y7> <cfset contentBody = "grant_type=refresh_token&client_id=bcbb1365893&client_secret=62b5a8a84567992666tf986a3f474791e&refresh_token=9312beb987fbd8efebf6dc&scope=read%2Bwrite" /> <cfhttp method="POST" url="https://api.wedoo.com/oauth2/access_token"> <cfhttpparam type="header" name="Content-Type" value="application/x-www-form-urlencoded" /> <cfhttpparam type="formfield" name="grant_type" value="refresh_token" /> <cfhttpparam type="formfield" name="client_id" value="bcqq13f2d1d320543524"> <cfhttpparam type="formfield" name="client_secret" value="62b5a8a84567992666tf986a3f474791e" /> <cfhttpparam type="formfield" name="scope" value="read+write" /> <cfhttpparam type="formfield" name="refresh_token" value="239hy9uiw784fbew43y7" /> </cfhttp> <cfset cfData = cfhttp.filecontent /> <cfoutput>#cfData#</cfoutput> When I actually put the refresh_token value in the code like in example #2 it works fine. Has anyone ever encountered this? Do I have a single quote double quote issue? Do I need to encode the RefToken value when its inside cfhttp tag? Are there other parameters that I could add to the cfhttpparam tag? Is there another step I need to take when setting the RefToken value?
... View more
Mar 28, 2019
04:11 PM
Sorry I've got some issue with my document body code that's not allowing me to do what you suggested. So I was thinking now to somehow loop through and create and save individual pdf for each idx and then once I have all of the pdfs from the list created then create a new pdf and combine all of the pdfs together to create 1 document. Any suggestions on how to create and save the pdfs to a directory? Once they are there I can do the pdf merge to put them into 1 document.
... View more
Mar 28, 2019
06:20 AM
sorry, Eddie. I thought I was replying to BKBK. On your suggestion. I tried this too but I've got some cached content that is causing issues when I try it the way you suggested. Anyway I'll try it again
... View more
Mar 28, 2019
06:15 AM
This is exactly what I have now and it only generates 1 pdf form the list
... View more
Mar 27, 2019
03:20 PM
I have code to create a pdf like this. It works great <cfdocument format="pdf" localUrl="yes" orientation="landscape" marginleft="0.10" marginright=".10" margintop="0.15" > <cfdocumentitem type="footer"> <cfoutput>Page #cfdocument.currentpagenumber# of #cfdocument.totalpagecount#</cfoutput> </cfdocumentitem> <cfquery name="Loads" datasource="dsn"> SELECT [company_id] FROM datatable WHERE ID =16598 </cfquery> Rest of code based on ID </cfdocument> Now I want to loop through a list of ID's and create a combined pdf of all of the ID's in the list like this <cfloop list="16958,17019,17020" index="idx"> <cfdocument format="pdf" localUrl="yes" orientation="landscape" marginleft="0.10" marginright=".10" margintop="0.15" > <cfdocumentitem type="footer"> <cfoutput>Page #cfdocument.currentpagenumber# of #cfdocument.totalpagecount#</cfoutput> </cfdocumentitem> <cfquery name="Loads" datasource="dsn"> SELECT [company_id] FROM datatable WHERE ID =#idx# </cfquery> Rest of code based on ID </cfdocument> </cfloop> But when I do this only the first pdf prints. So in my example, the pdf for 16958 is generated but not 17019 or 17020 What am I doing wrong?
... View more
Feb 13, 2019
09:06 AM
Excellent. You deserve 2 stars for this one. I appreciate your diligence!
... View more
Feb 13, 2019
08:14 AM
Here is the file list All works well except when the number preceding the dash is 3 digits This is the current code I am using. <cfif LEFT(filename,5) EQ 'PGHAB'> <cfset thisNumber = REreplaceNoCase(trim(fileName),"(\w{4,5}\d{4}\w+)(\d{2,3})(-\d{1,2}?\.docx)",'\2','all') /> </cfif> <cfif LEFT(filename,4) EQ 'PGHA'> <cfset thisNumber = REreplaceNoCase(trim(fileName),"(\w{3,4}\d{4}\w+)(\d{2,3})(-\d{1,2}?\.docx)",'\2','all') /> </cfif>
... View more
Feb 13, 2019
07:27 AM
Sorry about the vars changing So everything works except when the var is like this ( 3 digits before the dash-) PGHA2019MarchSDRR101-01.docx This is my code <cfset thisNumber = REreplaceNoCase(fileName,"(\w{3,4}\d{4}\w+)(\d{2,3})(-\d{1,2}?\.docx)",'\2','all') />
... View more
Feb 13, 2019
06:50 AM
This works great except for these vars (2 digits after the dash -) PGHA2019MarchSDRR73-01.docx PGHA2019MarchSDRR73-02.docx But does not when the var is this (1 digit after the dash -) PGHA2019MarchSDRR73-0.docx Here is the code I have <cfset thisNumber = REreplaceNoCase(fileName,"(\w{4}\d{4}\w+)(\d{2,3})(-0\d{1}?\.docx)",'\2','all') />
... View more
Feb 12, 2019
04:28 PM
Wolf, OK were very close here. It looks like the file names can go like this. More variation than I indicated earlier. So your Regex works for some and not others PGHA2019MarchSDRR99-0.docx PGHA2019MarchRES73-0.docx PGHAB2019MarchREC73-01.docx PGHAB2019MarchREC73-0.docx PGHAB2019MarchCA73-02.docx PGHAB2019MarchCA73-01.docx PGHAB2019MarchCA101-0.docx Knowing this is regex still the answer? The number I need is still the 2 or 3 digit number to the left of -0.
... View more
Feb 12, 2019
01:55 PM
Wolf When I do this, I get (\w{3}\d{4}\w+)(\d{2,3})(-01?\.docx) as thisnumber Actually I get (\w{3}\d{4}\w+)(\d{2,3})(-01?\.docx) no matter what variable I use
... View more
Feb 12, 2019
12:48 PM
I have strings like this PGH2019AprilPA73-01.docx PGH2019AprilPA73-0.docx PGH2019AprilREC73-0.docx I need to extract the number 73 from the string. The number could be 2 or 3 digits long, like 99 or 101 EG: PGH2019AprilPA99-01.docx or PGH2019AprilPA101-01.docx The number is always right before the -0 PGH2019AprilPA73-01.docx PGH2019AprilPA73-0.docx PGH2019AprilREC73-0.docx How would I extract this 2 or 3 digit number that precedes the -0?
... View more
Jan 25, 2019
01:17 PM
Like this: This is from this CF Forum in 2008 Where user wants to create a 5 question forms like this name address city stat zip The application would create the MySQL table and the front end and the insert logic into the database Dynamic Form Builder raymajoran MAR 26, 2008 3:34 PM 10 We are a company that has been building ColdFusion apps and content managements systems since v3.1. That said, I am (and have been for the last 2 years) in desperate need for a good “dynamic form builder”. I was hoping the Adobe would incorporate something like this into v8 (with the acquisition of Interakt), but it never seemed to happen. Basically, I need an open-source module that I can integrate into a non-profit application that we’re working on. We need to give our users (about 3,000) the ability to create their own forms (for event registration, contact submissions, donations, etc.) and have the data stored dynamically into a SQL Server database. Additionally, some sort of reporting and payment option integration would be nice as well. Does anyone know anything out there like this that exists? I've seen lots of great apps out there (like JotForm, etc.), but I can't seem to find a good ColdFusion one that I can use in my application. I am more than willing to pay for it. Thank you in advance. Sincerely, Ray
... View more
Jan 25, 2019
08:39 AM
I am in need of a good “dynamic form builder” that integrates well with ColdFusion 2016/2018. Any suggestions?
... View more
Jan 21, 2019
12:08 PM
As always - thank you
... View more
Jan 21, 2019
11:03 AM
I have a query that returns results like this Row 1 -C,HU,NU,PO, CY, CAB Row 2 - A,AB,AB,ABC,TY,GYU So I need to combine these results into one string and then see if the string 'CAB' is in the new combined string. If it is, then output Yes How do I do this easily?
... View more
Jan 11, 2019
03:40 PM
I created the email on server#2 and sent an email with the attachment to the user. Thank you
... View more
Jan 10, 2019
01:49 PM
I have an application that is on 2 servers where form data from server #1 populates and creates a fill-in PDF on server #2 Server #1 - Railo server (Cant do PDF stuff) Enter Info into Form > Submit Form to Server #2 Server #2 -Windows server with CF16 on it Gets form field info and creates a PDF. Now I want that PDF to be copied back to server #1. How can I do that? Do I save it on server #2 and then do some file transfer or can I save it back to server #1?
... View more
Dec 21, 2018
06:56 AM
I have code like this <cfoutput>#calculated_value# </cfoutput> Then More code................... Then the Calculations code is done here to get the calculated value. Then More code................... The issue I have is that I need to output the calculated_value before I calculate it later in the page. I guess I could move the Calculations code to above the cfoutput, but it's not as easy as it sounds. Is there a way for the entire page to load, but not output.... do the calculations code to get the calculated_value and then output the entire page with the calculated_value shown at the top?
... View more
Copyright © 2025 Adobe. All rights reserved.
AdChoices