Your code continues to be truncated. If you are using email to reply please consider using the forum's web page instead. I have found that code is frequently mangled when posting to the forum by email. ... View more

Your code was truncated.  Please also post both the upload.cfm and process.cfm pages. ... View more

Please post your code. ... View more

Did you check the ColdFusion log to see what errors, if any, were logged? ... View more

You may find this blog post helpful as a temporay band-aid: http://wardlawclaims.blogspot.com/2011/01/connecting-to-access-2007-database.html I also agree with Adam Cameron.  MS Access is generally not a good choice as the backend to a web site and I would recommend that you migrate your data to a different database. ... View more

On upload.cfm: <cffileupload hideuploadbutton="no" progressbar= "no" stoponerror="yes" title="Upload Closeout Pictures" url="process.cfm" wmode="transparent" maxfileselect=6> On process.cfm <cfset targetPath="X:\a-file-storage-directory"> <cffile action="uploadall" destination="#targetPath#" nameconflict="overwrite" result="uploadedFiles"> <!--- iterate over uploadedFiles result array and perform an insert for each record ---> <cfif IsDefined("uploadedFiles") and IsArray(uploadedFiles) and ArrayLen(uploadedFiles) gt 0>     <cfloop from="1" to="#ArrayLen(uploadedFiles)#" index="idx">             <cfquery name="insertFileRecord">                         INSERT INTO FileHistory ( DirectoryName, FileName  )             VALUES (                 <cfqueryparam value="#uploadedFiles[idx].serverDirectory#" cfsqltype="cf_sql_varchar">                  ,<cfqueryparam value="#uploadedFiles[idx].serverFile#" cfsqltype="cf_sql_varchar">                 );         </cfquery>         </cfloop> </cfif> ... View more

Bear in mind that the Flash based file upload operates asynchronously rather than on a syncronous form post and response used with a form based file upload. I agree with the other poster that your database update logic should be handled on the process.cfm page. If you must have the client handle data processing you can try the onError, onComplete, and onUploadComplete features of cffileupload, but I would recommend against having the client be responsible for this kind of logic. ... View more

What do you mean when you write "I get nothing in the myImage variable."  Is an exception thrown, is the array empty, etc? ... View more

If the upload succeds you should have something your myImage variable. Try something like this in process.cfm to see what is captured in the result variable: <cffile action="uploadall" destination="#path#" nameconflict="overwrite" result="myImage"> <cfif IsDefined("myImage")>     <cflog text="Upload complete" type="information">      <cfif IsArray(myImage)>            <cflog text="#ArrayLen(myImage)# files uploaded" type="information">      </cfif> </cfif> ... View more

Are any errors logged? It sounds like the file upload process is failing. You might try setting stoponerror="false" and use onError to gather information about the upload process from the cffileupload tag. ... View more

Start by reviewing the CF documentation on AJAX.  Then try some code.  If you run into problems create a new question and include the code you have tried and any error messages you receive. CF docs: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cdd70508c-8000.html ... View more

Take a look at the CF documentation.  It states: After a file upload is completed, this tag creates an array of structures specified by the result parameter. Each structure in the array contains upload result information for one file. For information on the result structure contents, see cffile action = "upload". http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7388.html ... View more

In my experience CFQUERYPARAM can be used in queries which contain an ORDER BY clause.  I suspect your error is related to a bug either in mySQL or the database driver.  Try using a JDBC driver rather than the ODBC driver. ... View more

I would advise against using global temporary table across multiple CF pages.   CF data sources don't give you the fine control you would need to guarantee that connections across separate page requests will use the same database connection session. Global temporary tables will be dropped (in MS SQL) as soon as the session which created them is closed, assuming they are not currently in use by another session.  In CF the underlying server controls the closing of connections, not the developer. An alternate approach, as previously suggested, would be to use standard tables. ... View more

If the JavaScript doesn't "fire" I suspect that process.cfm page is either failing or not being called at all. Things to check: 1. The contents of the cffile result variable. 2. Put a try/catch around the cffile and see any exceptions are thrown. Examine the exception error message for any information. 3. Have you posted all of your code? ... View more

The file upload does not occur via traditional form posts for CFFILEUPLOAD. Rather than use CFDUMP try CFLOG to dump the result of the cffile somewhere where it can be examined. If your process.cfm is never used (there should be a POST to this page in your web logs), then it probably means the files are not being sent to the server. I would verify that any scripts/flash files required by CFFILEUPLOAD are in place and accessible to the browser. You might also try the sample code from the documentation that uses JavaScript to give the browser feedback about the upload process. http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-7a01.html#WSe9cbe5cf462523a0fe521c212308a43ca3-7ffe ... View more

What is contained in a dump of the CFFILE result variable? http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7388.html ... View more

What do your web server logs record? Is anything being uploaded (and possibly failing)? Does your web server have any security options, such as URLScan (for Windows IIS) that might be preventing file uploads? ... View more

The action attribute value on your CFFILE tag should be changed to "uploadall" in order to support multiple files.  If this does not help please post  more complete code samples. ... View more

Do the variables ARGUMENTS.send_*_date and send_*_date refer to the same values? What happens if you use the same variables in both select statements? ... View more

In addition to ilssac's questions it would also be useful to know: 1. The database  you are using, including product and version. 2. The data type of the trade_date_time column. ... View more

Unfortunately CF does not make this easy.  You will need to login to the CF administrator site and go to the System Information page.  One of the items listed is the "Update Level" which will list the latest hotfix you have applied.  For other fixes look at the files listed in the "Java Class Path" section of the Systems Information page.  Hotfix files are generally named hf*.jar where * starts with the CF version number you are running.  You can check the available hotfixes to verify that you have the ones you need. You should also verify that you are running the latest supported JVM: http://kb2.adobe.com/cps/894/cpsid_89440.html CF 9 hotfixes: http://kb2.adobe.com/cps/529/cpsid_52967.html CF 8 hotfixes: http://kb2.adobe.com/cps/402/kb402604.html ... View more

The CFINVOKE tag or CreateObject function will abstract the XML SOAP format away, no use of XML is needed on your part. You will provide CF variables: arrays, structs, etc as arguments where needed. ... View more

It would be helpful to have: 1. The code you have tried, with a description of the expected result and the actual result. 2. The error messages if any you are seeing. 3. The WSDL you are working with. 4. You CF version and platform (Windows, Linux, Apache, etc.) ... View more

You might try looking into Google's APIs: http://code.google.com/intl/en/more/ ... View more

Are you asking how to implement an autosuggest feature or more specifically how to invoke a Google API to return autosuggest results? ... View more

Things to try/check to narrow down your problem's scope. Option 1: See if you are able to run CF using the built-in web server. If CF's built-in web server works, but CF does not work with IIS this may indicate an issue with IIS+CF. http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fd8.html Option 2: Check the logs Look in the Windows logs and in the CF logs for any information that might be related to your issue.  You *should* be able to find the CF log files at: C:\ColdFusion9\logs\  and C:\ColdFusion9\runtime\logs\.  These paths may not match your installation.  If they do not then look for *.log files in your ColdFusion directory. Option 3: IIS Configuration The CodeCurry article you reference may not apply to CF 9.0.1.  In version 9.0.1 the IIS configuration for CF removed the need for the IIS 6 compatibility option in IIS. http://kb2.adobe.com/cps/847/cpsid_84725.html You might try using the command line to remove your CF to IIS mappings, then restore them.  I also suggest that you enable logging with the -l switch and check the log file.  The log file *should* be found at C:\ColdFusion9\runtime\lib\wsconfig\wcsconfig.log. http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fd9.html Does the IIS and/or WWW Publishing service run under a Windows account other than the default on your machine?  Do you have any non-standard file/folder permissions configured on your machine? ... View more

I'm not sure how Access uses aggregate functions. This isn't a product I use. What does the Access documentation say? ... View more

In some databases any columns you include in the SELECT clause (not including aggregate functions such as MAX or COUNT) must also appear in the GROUP BY clause. This may be part of your problem. The subject GROUP BY is correct but the last one (commented out) is possibly incorrect. Knowing your database product and version would assist in troubleshooting. ... View more