Unfortunately I don't use CF2016 (or CF2018) so I don't know the answer to your question. In either case, it would not be a problem to download CFB separately from the Adobe Web site. ... View more

PDFInfo is an object. If you want to see its properties, don't output it that way, use <cfdump var="#PDFInfo#"> ... View more

Please confirm that you are NOT using to_date in Oracle when you pass the parameter as a timestamp type. ... View more

Please answer my question. It appears to have been lost in the flurry of responses. I'm guessing you need to either pass the parameter as a varchar and then use the to_date function in Oracle to convert it, or you need to pass the parameter as a timestamp and not use the to_date function in Oracle. ... View more

IQ1  wrote in the backend in Oracle , If I use to_date its not working Why are you doing that? From what you show, the date fields are already in date format. ... View more

It's best to use the following syntax: <cfset AuthKey = mid(line1,19)> <cfset RefToken = mid(line2,15)> <cfset RefToken = "239hy9uiw784fbew43y7"> What Dave is talking about is that the following two lines are functionally equivalent, but the first line makes the parser work harder: <cfset AuthKey = "#mid(line1,19)#"> <cfset AuthKey = mid(line1,19)> ... View more

What is the value of #period#? It is not in your variables scope. ... View more

Please wrap your query in a try/catch block and post the result. For example: <cftry>   <cfstoredproc procedure="dbo.multi_report_pkg.run_multi_report" datasource="#datasource#" username="#Session.UserName#" password="#Session.password#">     <cfprocparam cfsqltype="CF_SQL_NUMERIC" value="#Session.multi_rep_id#">     <cfprocparam cfsqltype="CF_SQL_VARCHAR" value="#Session.UserName#">     <cfprocparam cfsqltype="CF_SQL_NUMERIC" value="#multi_report_def_id#">     <cfprocparam cfsqltype="CF_SQL_VARCHAR" value="TO_DATE('#datefrom#', 'DD-MM-YYYY HH24:MI:SS', 'AMERICAN')">     <cfprocparam cfsqltype="CF_SQL_VARCHAR" value="TO_DATE('#toDateTime#', 'DD-MM-YYYY HH24:MI:SS', 'AMERICAN')">     <cfprocparam cfsqltype="CF_SQL_VARCHAR" value="#period#">   </cfstoredproc>   <cfcatch type="any">   <cfdump var="#cfcatch#" label="cfcatch" >   <cfdump var="#variables#" label="variables" showudfs="false" >   </cfcatch> </cftry> ... View more

It's impossible to help with so few details. Please use trycf.com​ or cffiddle.org to provide an example that produces the error you mention. ... View more

What is the value of the time1 variable on the development server, and what is its value on the production server? ... View more

I don't think this is a ColdFusion issue. It's a logic issue. How would you structure your logic in a language that you are more familiar with, for example C++? ... View more

A very basic example: <cfquery datasource="#variables.MyDS#">   BULK INSERT #variables.TableName#   FROM '#variables.CsvPathAndFile#'   WITH   (     FIELDTERMINATOR = ',',     ROWTERMINATOR = '\n'   ) </cfquery> ... View more

https://forums.adobe.com/people/ACS+LLC  wrote What I'm trying to figure out is, once I have the CSV file on the server, what's the best way to problematically read all of those records and insert them into the SQL database. The link I gave you shows you how. Look at the "bulk insert" example query. You can run that query from your ColdFusion code, you do not need to "read all those records" at all. ... View more

SQL is a language, not a database engine, so you can't import something into SQL. The method of importing external data into a database depends on the database engine you're using. If you're using Microsoft SQL Server, then this article may answer your question: Import CSV file into SQL Server using T-SQL query ... View more

weezerboy  wrote Sorry I've got some issue with my document body code that's not allowing me to do what you suggested. That doesn't make sense to me. Whether you write to a single file or multiple files doesn't change the document body, only where the loop goes. weezerboy  wrote 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. Use the filename attribute of the cfdocument tag to write to a file. ... View more

weezerboy  wrote This is exactly what I have now and it only generates 1 pdf form the list Not according to the code your provided. You have the cfdocument tag inside the cfloop tag. You need it to be the other way around. ... View more

WolfShade  wrote Will and bk, did you guys kiss that I had shared this same link and fix info here yesterday? Sorry for seeming thick.. huh? The "k" is right above the "m" on the qwerty keyboard. ... View more

https://forums.adobe.com/people/ACS+LLC  wrote Looking on here there does not appear to be an argument that would display a € euro sign ColdFusion Help | LSEuroCurrencyFormat If you copy the example from that documentation page and paste it into https://cffiddle.org/ and run it, you will see it does produce a euro symbol, but it has a space before the number much like you found with the numberFormat() function. ... View more

Sorry I wasn't clear. I would be interested in seeing the contents of the variables scope before the line that causes the error. In other words, put it after the cfquery tag, but before the cfset tag. You may need to use the "output" parameter of cfdump to write it to a file, in case the generated content is not visible to you in your error information. ... View more

Have you cfdumped the query name before the line that gives an error? If that also causes an error, cfdump the variables scope. It would be very interesting to see the state of the variables scope before the line that causes the error. ... View more

Yes, you need to replace all CF_SQL_STRING occurrences, because it is not a valid option. ... View more

If you paste your example code into cfFiddle you will see it works as expected, however, you should probably use the CreateDateTime() function to initialize the unformattedTime variable. ... View more

What is the value of the pass field in the database? If it is not the same as the encryptedpassword variable then you are not storing the value in the database correctly. ... View more

That sounds like a JavaScript issue in your browser. Which browsers have you tried using while troubleshooting the issue? ... View more

rasonj77  wrote I am not a developer by any stretch of the imagination. This is a problem. Even if you are shown how to add HTML to add a form field that will accept a percentage, what are you going to add to the ColdFusion code that processes the submitted form? There is more to this than adding a bit of HTML. I strongly suggest you hire a programmer. ... View more

FETCH FIRST is ANSI SQL, but I realise I don't know to what level MySQL is ANSI compliant. You're going to have to do some more research. ... View more