Questions

Just so we don't get too far off track, keep in mind the code samples below aren't my true code. I'm stripping things down for illustration purposes only - I realize they're bad examples and lack CFQUERYPARAM. So, to give a little background first... I started my ColdFusion programming career over a decade ago building fairly large e-commerce applications. Not Amazon scale, but not mom-and-pop shopping carts by any means.In those days I often used CFTRANSACTION for situations where multiple INSERT or UPDATE queries relied on each other. For example, a form that inserts a new product into a database table, and inventory counts into a separate table.For example:<cftransaction><cfquery datasource="mydatasource" result="product_inserted">INSERT INTO products (sku, price, title)VALUES ('555-555', 2.50, 'Spider-Man T-Shirt')</cfquery><cfquery datasource="mydatasource">INSERT INTO inventory (product_id, inventory)VALUES (#product_inserted.IDENTITYCOL#, 50)</cfquery&

Hiwe cf 11 enterprise  64 bit installed at window 2008 R2 SP1. try to setup data source for ms. access. getting following error :-Connection verification failed for data source: SARSINFO com.inzoom.jdbcado.JdbcAdoException: could not load izmjniado.dll Can't load library: c:\program files\infozoom\izmjniado.dll The root cause was that: com.inzoom.jdbcado.JdbcAdoException: could not load izmjniado.dll Can't load library: c:\program files\infozoom\izmjniado.dllWhen we installed at 32 bit machine, it work.Pls.help.thanks,

In ColdFusion Report Builder, is there a way to shrink text to fit a particular area? (as opposed to stretching with overflow)Any help would be greatly appreciated!- Chris

Hi,On CF10 web application, I am using CFGRID to show a search result output on the screen.  I found that depending on the number of records returned from the query, CFGRID is not showing any data on the screen.  I have a query that returns more than 3,000 records with 80 columns and it does not show data on the screen.  It may sound stupid to show such many columns on the screen but that's what the user wants.  I have not tried paging with CFGRID but I just want to know if there's anyone who might have encountered the same issue and how they solved such an issue.Thanks.Pacita

Reading lines in a text file,Listing a text file , with value between ;sometime , there is no data between 2 ; which I need to know.In that case, (when there is no value between the delimiter) my array have a different length (smaller)Then the data order is not good.As I want to save in a DataBase, I do not know what data in what field number ?Thanks for any help,Pierre.

Hi ,I am required to install CFB 3 to support multiple users access on a development environment.Developers are working on a same server. Once the CFB 3 get installed, only the admin user can run the program but no other.Whenever the CFB 3 starts, it showed an error message below."Locking is not possible in the directory"C:\ColdFusionBuilder3\configuration\org.eclipse.osgi", A common reason isthat the file system or Runtime Environment does not support file locking forthat location. Please choose a different location, or disable file lockingpassing "-Dosgi.locking=none" as a VM argument.C:\ColdFusionBuilder3\configuration\org.eclipse.osgi\.manager\.fileTableLock (Access is denied)"Any clue on how to get this fixed.Thanks.Oli

Hello, I have a client requirement to install CF 11 Standard on Linux (Debian 7.x) with Plesk 11.x control panelDoes anyone have any experience with this?  Is it a pretty straight forward setup process?  I only know Windows/Coldfusion, so this will be  new.Also, do the same issues still apply with differences between Linux/Windows with filename case.  Is there a current document anywhere that will explain coding differences between the two OSsThank you!

I have following code for my cftextarea and try to make the height and width I need for the form for the users.For some reason, it does not change the size even I modify row and col parameters.Is it something I am missing to adjust the height and width of cftextarea?Your help and information is great appreciated,Regards,Iccsi,<td><CFtextarea name="MytxtArea"  id="MyTextArea"  row="6" col="10"/></td>

Hi everyone,First time caller here.About to get started on a project, but the Host has cf10.Adobe has cf11 Developer.Q : Is cf11 developer backward compatible with CF10 ?CheersBrett

I have following code to get an array from jQuery to pass MS SQL Server stored procedure to update my tables.Is it the right way to access array from passing jQuery function?Your help and information is great appreciated,Regards,Iccsi,<cffunction name="MyFunction" access="remote">  <cfargument name="MyData" type="any" required="true"> <cfif isJSON(arguments.MyData)>        <cfset arguments.MyData = deserializeJSON(arguments.MyData)>    </cfif>    <cfstoredproc procedure = "MySP">   <cfprocparam value = "#arguments.MyData[1]#" CFSQLTYPE = "cf_sql_integer">   <cfprocparam value = "#arguments.MyData[2]#" CFSQLTYPE = "cf_sql_integer">   <cfprocparam value = "#arguments.MyData[3]#" CFSQLTYPE = "cf_sql_integer">   <cfprocparam value = "#arguments.MyData[4]#" CFSQLTYPE = "cf_sql_varchar">   <cfprocparam value = "

I Have a page that displays a series of available items for the public to purchase. each of these items displays an image of the product. My cfimage code is made to scale-to-fit the stored image. normally the displayed results will all shoe different products and their corps pounding images. When I use the code below all of my different products will show the same image instead of showing the images that are linked to each product via a file path stored in the database. Is there a way to set the "name="myImage" dynamically so that each image will display and scale properly?<cfimage source="C:\ColdFusion9\wwwroot\shotthp\#product.proimage#" name="myImage"><!--- Turn on antialiasing. ---><cfset ImageSetAntialiasing(myImage)><cfset ImageScaleToFit(myImage,182,"","highestPerformance")>

I need to query and get all records that have been updated in the past 15 minutes.Ive tried in CF and MS SQLHere is what I have that doesn't workSELECT *    FROM  job_clock WHERE  Job_Time_Out >  dateadd(minute,-15,CURRENT_TIMESTAMP)

I have this code for a generic template:   <cfset fileName="c:\temp\wordTmpDoc"&randRange(1,100000)&".htm">    <cfif fileExists(fileName)><cffile action="delete" file="#fileName#"></cfif>    <cfsavecontent variable="htm"><CFINCLUDE template="#incl#.cfm"></cfsavecontent>    <cffile action="write" file="#fileName#" output="#htm#">    <cfcontent file="#fileName#" deletefile="no" type="application/msword">Note the CFINCLUDE. I also have another template that goes through generating the html in a cfsavecontent and at the bottom it has essentially the same code but uses the HTML generated on the page as the content for the document. The above generic version brings up MS Word but the content is the HTML code, while the page that has local cfsavecontent wrapping the HTML, the document displays properly.

I have seen several questions unanswered.

I have this code: <table cellpadding="0" cellspacing="0" class="tablecolors"> <h2>Stars Counts</h2>   <thead><tr><th>Employee</th><th>Stars</th></tr></thead>   <tbody>   <cfloop query="GetEmployeeTotals3">      <cfif GetEmployeeTotals3.csedept_id eq aFieldValue>   <tr><td>#GetEmployeeTotals3.emp_namefirst# #GetEmployeeTotals3.emp_namelast#</td><td>#GetEmployeeTotals3.employeetotal#</td></tr>   </tbody> <cfelse> <p>no results.</p> </cfif> </cfloop> </table> Here the query will show the cfelse and the results in the query.I just cant seem to figure out how i can get it if there are no results in the getemployeetotals3 to not display the table and show 'no results'.I have try putting in a counter but for some reason it doesn't work and gives me weird results.Maybe im putting it in t

Can anyone point me to an installer file for CF9 windows, 64-bit?  I am upgrading servers and need to reinstall ColdFusion 9 Enterprise.  I can't find the CF9 installers anywhere.Cheers.

I have following cffunction in my cfc and calling from jQuery.I use MS SQL Server 2008 R2 and the field is nvarchar(max) in the database.The function fails to update when the string more than 800 characters.I would like to know are there length limitation for cf_sql_varchar?I tried to changed to CF_SQL_LONGVARCHAR, but it still fails when the text longer than 800 characters.My users need to enter more than 800 characters.Another issue is when the text has '%' then it wipe out all text and pass null to the MS SQL Server.Any suggestion is appreciated,Iccsi,<cffunction name="Myfunction" access="remote">   <cfargument name ="MyField" required="no" default="" hint="My Field">    <cfstoredproc procedure = "MySP">        <cfprocparam value = "#MyField#" CFSQLTYPE = "cf_sql_varchar"> </cfstoredproc></cffunction>

I have a link on the form to modify a table for the drop down select control.The link works to add or modify data, but when I come back data entry form, the drop down does not refresh data. It remains same drop down, it does not add or modify the drop down.It seems the drop down keep cache memory.I would like to know are there any way to refresh the drop down box after user modify the physical drop down table.Your  help and information is great appreciated,Regards,Iccsi,

Below are the steps I went through :. download the installer exe (ColdFusion_11_WWEJ_win.exe) : 571 106 928 octets. launch it --> nothing happen (I can see in tasklanager some cpu activity during few seconds then nothing). then I have tried to open the archive with 7zip and I have found two directories : windows and InstallerData. then I have tried to execute "windows\adobe_cf.exe" and I got immediatly the message : "Impossible to execute LaunchAnywhere - Error Windows 2 when loading Java VM"My java version is :java version "1.7.0_55"Java(TM) SE Runtime Environment (build 1.7.0_55-b14)Java HotSpot(TM) Client VM (build 24.55-b03, mixed mode, sharing)Thank you for your support.Pierre.

In CF11, I'm using cfobject to reference a function in a .NET DLL assembly. I had placed this DLL assembly in \cfusion\wwwroot\web-inf\cfclasses\DotNetProxy folder. The function simply encrypts a string. I had it working perfectly just last week. I then had to re install CF11. I installed it the same exact way I did the first time just 2 weeks ago.Now when the same exact setup and script is run, it fails and I get "Error ajp-bio-8014-exec-x" in the application.log file, where x is an incrementing number. There is also a new .jar file created in that DotNetProxy folder every attempt I make. Looking through other logs, I do not see anything specific about this error so I have no clues on which direction to go. I do not recall "registering" the DLL assembly when I set this up the first time. I simply place the DLL in the DotNetProxy folder. Maybe that is it? Is anyone familiar with the above message when trying to access a DLL assembly, and what to do to fix this?

I have set up a Solr collection in CF 10 Administrator with following settings:File Extensions: .*Directory Path: C:/inetpub/wwwroot/test/Recursively Index Sub Directories: uncheckedReturn URL: http://localhost/test/Language: Default ( I also tried "English" )Inside the "C:/inetpub/wwwroot/test/" directory, I have 4 different types of files:.xls, .gif, .cfm, and .pdf. But every time when I try to update the index, none of the PDF fiels are indexed. All the other types of documents are indexed. I have looked at the PDF files' properties, none of them are "locked" or "protected".I am using the Enterprise trial version with all the updates applied.Anyone has experienced the same issue before?

I have the following code to upload file and using accept file type including "image/x-tiff, multipart/x-zip"The code works for pdf, txt and msword, but I got error message like when I upload zip or tif files.I would like to know if there is any configuration need to be done at server level,Your help and information is great appreciated,Regards,Iccsi, <cffile action="UPLOAD" filefield="fleAttachment" destination="#UploadFolder#" accept ="application/pdf, application/msword, application/vnd.ms-excel, text/plain, image/x-tiff, multipart/x-zip"  nameconflict="MAKEUNIQUE"result="MyUpload">Only files of type application/pdf, application/msword, application/vnd.ms-excel, text/plain, image/x-tiff, multipart/x-zip can be uploaded. Verify that you are uploading a file of the appropriate type.

we are using a coldfusion component to  authenticate Active directory users to give access to intranet websites, below code is working fine in development version of coldfusion 10 but when i move this to production (enterprise edition) , its not working and throwing an error message "class not found jrun.security.ntauth"<CFFUNCTION NAME="authenticateUser" ACCESS="REMOTE" OUTPUT="yes" STATIC="yes" HINT="Authenticates the user.">   <CFARGUMENT NAME="userid" TYPE="string" REQUIRED="true" />   <CFARGUMENT NAME="passwd" TYPE="string" REQUIRED="true" />   <CFARGUMENT NAME="domain" TYPE="string" REQUIRED="true" />   <CFTRY>    <CFSCRIPT>  ntauth = createObject("java", "jrun.security.NTAuth");  ntauth.init(arguments.domain);   ntauth.authenticateUser(arguments.userid, arguments.passwd);  auth = true;   </CFSCRIPT>   <CFCATCH>   <CFSET

  These resets appear to coincide with a clearing of the cached queries for the DSN from memory, breaking all my sub queries that try to use the initial cached one.  I am grasping at straws to discover the reset culprit, the DSN tests always show OK, there is not packet loss at the switch level.  If anyone has some suggestions, I am all ears!  The resets are completely random and under no load.  My sql 2008 r2 box is set to unlimited connections. An example of a DSN setup is :Maintain Connections String Format [ ]Max Pooled Statements 100Timeout 20 Interval 7Query Timeout 0Login Timeout 30CLOB [ ]BLOB [ ]Long Text Buffer 64000Blob Buffer 64000Validate Connection [ ]I am running the following :CF Enterprise 10,0,13,287689Tomcat 7.0.23.0Ubuntu 1204 x64Java VM 20.4-b02Java 1.6 (Sun Microsystems Inc)  I have seen it suggested to uncheck the maintain connections advanced options but this doesn't seem like a good approach to the problem and will cause more stres

I just downloaded both the CF Report builder versions for 8 and 9 and there is no English language help file included.Does anyone know where or how I can download this?Clicking on help just gives you a warning saying 'MS Html Help is not installed on this PC.'Michael