ColdFusion

Hi All,I have this query in CF9://create an empty query to work withvariables.qryFoo = queryNew("myID","DOUBLE");//add a row and fill it with some dataqueryAddRow(qryFoo);querySetCell(qryFoo,"myID","1");queryAddRow(qryFoo);querySetCell(qryFoo,"myID","2");Here is my update statement:<cfset myIDs = valueList( qryFoo.myID ) /><cfquery datasource="#application.str_dsn#">    update myOtherTable     set trueValue = 1     where myID in ( #myIDs# )</cfquery>It works fine until it reaches more than 1000 ids. I am getting this error:ORA-01795: maximum number of expressions in a list is 1000I found this statement: "You cannot have more than 1000 literals in an IN clause. You can, however, have SELECT statements in your IN clause which can return an unlimited number of elements i.e."I try to do an update inside of Q of Q but i cannot do it:There was an error processing the update. <br><b>Query Of Queries syntax er

Hello, I want to ask a question, i want to build a website and includes flash articles and subjects.for example https://www.tonerizmir.com , i maked this site by ready webpage tools, but i want to make flash sites. where can i learn from ? and is there ready program for this and where can i buy ?thank you so much

For those of you who don't know the "pleasure", upon installing .NET on your server (we had to, a 3rd party app we need uses it), Microsoft sees fit to propagate a "aspnet_client" folder into the root of every site on IIS as well as randomly through each site's subdirectories.  Truly, if I find the person responsible for this imbecile-ry, the b*tch-slapping will be pride obliterating.But that aside, I have created a scheduled task to find all instances of this folder for a directory and below (the web root) and to remove it.  Well, the problem is that doing a <cfdirectory> listing, even when just specifying "dir" for type and "aspnet_client" for the filter, ColdFusion takes over 30 seconds and times out before it can get a complete listing of where these folders exist.Can anyone think of an alternate way to get a listing of these folder locations?  Maybe directly through Java for a faster reading?  I run this script every hour on the hour, and it's just been t

This ocurred next error in my installation, but I installed all frameworks in Features.Please, can I help me.

I am recreating a web application that serves up search results in a CSV file.  I'm able to create the csv fil from a database query, then offer a download link to grab it from.Question 1: In order to make the CSV files unique, I am appending them with the session id.  Is this a bad idea?  Should I use an encrypted session id instead?Question 2: In order to prevent the server from filling up with csv files, I want to delete the file once it's been downloaded.  I'd like to do this on session end, but the session variable I used to name the file will be gone when the session ends, so this might not be the best idea.  Any suggestions?Thanks!

Hi,So I have Win 2008 R2 Server running coldfusion10 and when I try to get it to connect to this https webservice I get Error creating web service. Please ensure that you have entered a correct Web Service name or URLI have the SSL cert in the keystore and I can browse to the service from the broweser on the server not really sure what else might be causeing it I though maybe some XML version issues but it it able to connect to other services with this XML version that are not HTTPS.Thanks for all the help ^^

Can i use <Cfquery   dbtype =:dynamic Connectstring=""> if so, where can I get examples of the Connectstringif not what other options are available

Where can I download 6.1 Updater and Hot Fix patch 57510?

I've loved setting scopes in the following manner:<cfset structAppend( VARIABLES, {     'variableName'         = 'value',     'variableName2'       = 'anotherValue',     'variable'                  = 'yetAnotherValue'}, true ) />It allows me to set variables in 1 command using structure notation, and keeping the command in an easy to digest look.  But a problem I've run into is that I cannot do this with the LOCAL scope and also maintain the best practice of using the 'var' keyword to ensure the variables exist only for the duration of the function call.  For example, this currently fails:<cfset structAppend( var LOCAL, {     'variable1'     = 'value1',     'variable2'     = 'v

Hi,It would seem that CF builder2 doesnt have any code assisting for cfscripting.?Surely ive missed something here.If this is the case then im wondering whats going on as DM CC is clearly trying to discourage you from using it for coldfusion (by stripping out previous CF tools).CF builder has no code assist for cfscript..i like to use cfscript in my components as I like the way it resembles other languages im familiar with, eg javascript, c# etc.Im wondering now, why bother, just use the TAGS ank keep life simple?

We have a ColdFusion 10 Standard server out in production on an IIS 7.5 Windows 2008 R2 Datacenter virtualized environment.  Randomly throughout the week, requesting our page will result in a blank white page (viewing source shows absolutely nothing). I remoted into our server and noted that coldfusion.exe was taking up 730MB.  I don't track these things so I don't know if that's a lot or not.  And usually restarting the service takes 15-20 seconds.  This time it took 20 seconds to stop the service and about 30 to start it.I am not familiar with which logs to check in order to provide some useful information, but if anyone has an idea of where to send me looking, it would be greatly appreciated.

how do i download typeviewer.dll file for COM object error exception..where do i get the file?

Coldfusion 10 kicks out the users from the application while request happen. Users again has to login back and work.I migrated coldfusion application server from cf7 to cf10. Before migration there were no issue like this.Any body has an idea why this is happening and how to fix this issue?

I am looking at using cfdbinfo tag that can introspect a Linked SQL Server Setup.The server setup is as follows:Coldfusion as a datasource cftest that points to SQL Server ASQL Server A has an established link to SQL Server BI can query using cfquery information from server B by goingSelect * from SERVERB.Database.dbo.tableHowever, this tag setup does not return the name of the table<cfdbinfo type="columns" name="test" table="table" />This errors out as the table does not exists.Any Advice?

I have a database query that returns a book titile and list it ... however some of the books will have a category to them and I want to list the category and then the books titles under that ... Do I need to create an array or can I do it in a cfloop.SampleBookTitle 1BookTitle 2Category     BookTitle 1     BookTItle 2Booktitle 3

I see hotfixes for version 9 and 10, but how can I fix this vulnerability in Cold Fusion version 8.0.1?

I'm using Solr CF9 and I'm trying to index documents in a folder with various extentions (Mostly the normal stuff .doc, .pdf etc...) I'm running into a problem when trying to index a .aspx web form in the extensions list. It won't work... I also tried using .* to see if that would pick up the file. Nope that doesn't work either.... It seems like it just doen't like this .aspx file. Sooo my question is.... Am I doing something wrong or is there a way to include this into my cfindex????Thanx

I'll try to keep this simple.1.  I have a new page where there are four cfcalendars.  For example, I select a date on each of them and submit.2. All four dates get recorded in the database.3. I go to the edit page that these four cfcalendars reside on.4. I don't edit the dates, but may change something else, such as user information.5. I submit the edit page and one of the dates will update and disappear from the database.6. If I edit again, another one may disappear.This is quite strange and I can not figure out why it is happening.  It is as though if the cfcalendar is not edited, it doesn't pass the existing date for that cfcalendar.Thanks for your help. BCo. 

The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request The  C:/inetpub/wwwroot/Clients/org.onlineaha/REL-20130506/website/wwwroot/../../docs/certificate_templates/prodnum_70-2304-Archived.pdf  file specified in the cfpdfform tag either does not exist or is not  accessible by this tag. Resources:             Enable Robust Exception Information to provide  greater detail about the source of errors.  In the Administrator, click  Debugging & Logging > Debug Output Settings, and select the  Robust Exception Information option.Check the ColdFusion documentation to verify that you are using the correct syntax.Search the Knowledge Base to find a solution to your problem.Browser  Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0Remote Address  76.221.89.202Referrer  http://www.on

Everything was OK with multiple instances of Tomcat and CF10 (big deployment of CF here over 15 years) But I ran the Mandatory Update on the first of the new instances of Tomcat/CF10 and Tomcat cannot complete its startup and CF10 is dead in the water.  It gets to this line and hangs.Oct 14, 2013 2:48:03 PM org.apache.catalina.startup.HostConfig deployWARINFO: Deploying web application archive C:\Apache\330_CFMX1\webapps\cfusion.war"and stops....I set the Tomcat logging to debug level.  Here is the output from the (1) -------------COMMON-DAEMONS LOG----------------[2013-10-14 14:48:02] [debug] ( prunsrv.c:1679) [ 1096] Commons Daemon procrun log initialized[2013-10-14 14:48:02] [info]  ( prunsrv.c:1683) [ 1096] Commons Daemon procrun (1.0.15.0 64-bit) started[2013-10-14 14:48:02] [info]  ( prunsrv.c:1596) [ 1096] Running '330_CFMX1' Service...[2013-10-14 14:48:02] [debug] ( prunsrv.c:1374) [ 3476] Inside ServiceMain...[2013-10-14 14:48:02] [debug] ( prunsrv.c:844 )

Do I first need to upgrade to 9.0.1 and then to 9.0.2 or can I go directly from 9.0.0 to 9.0.2? Or is 9.0.2 a fresh install?Thanks,Dave

Imagine I have 2 objects.  A 'user' object, responsible for handling user functionality, and a 'security' object, responsible for handling authorization and authentication.I would like to hear pros and cons to my current belief of the following.I have a method in the security object called 'canAccess'.  You can pass it 2 optional arguments, a userID and a pageID.  If no userID is passed, it infers the current user object's ID (which is tied to the session scope), and if no pageID is provided, it infers the current request object's page ID (which is tied to the request scope)At first, I thought this might be a security risk, because code could pass a userID that did not belong to them, even though all this method does is determine if the user provided has Access rights to the page provided.I've been thinking about this for quite some time, and my current belief is that this is OK as LONG as the method is not set for remote access (and it is not).  My application supp

what dose embedded scale ratio mean

I am currently working on a web application written in CF running on IIS7 and CF10 server.  We need to replace our login page where our users supply username and password w/ CAC login.  The goial being for users to be prompted to enter thier 6 digit PIN assciated w/ their CAC to login to the application as opposed to the username and password thery are currently using.  If anyone has any suggestions on how to accomplish it would be much appreciated.

Hi all,We are using Amazon CloudSearch service for our site search.  We created a front end which uses jquery to communicate with the server to display search results.The problem we are running into is with creating and updating data on the backend.  We have been creating new domains and uploading whole data sets manually from spreadsheets which is obviously not going to work for us long term.The cloud search uses has an API that we can send JSON to for updating the items.  I have created the nested json like this (the query name and data has been changed to protect the innocent):<cfscript>  variables.dataFields = {};          variables.dataFields['id'] = " #getsdata.id#";          variables.dataFields['lang'] = "en";          variables.dataFields['type'] = "add";          variables.