danarashad 17 Light Poster

I am working on trying to secure some coldfusion servers. I've seen the lockdown guides all over the net. But those guides are for new installs. Is there a way to lockdown coldfusion after the install?

danarashad 17 Light Poster

Yes this is still relevant, I will give that a shot and hopefully that works.
Thanks for the advice.

danarashad 17 Light Poster

Here is what is happening. I have to click the select all box twice before it works.
Not Working

danarashad 17 Light Poster

I am using an ajax to load form fields. When the you select the school, the grade fields load. When you select the grade, the show name check box appears. When the select all box appears, I have to click the select all box twice for it to work. I am not really sure what the issue is. I've took all of the coldfusion pages out and substituted them with html pages.
Can someone take a look at tell me what I am doing wrong.
I also posted the code to paste bin.
MainPage
ShowGrade
ShowName
ShowCourse

<html>
<head>
<title>Score</title>
<meta content="text/html; charset=iso-8859-1" http-equiv="Content-Type">
<meta content="no-cache" http-equiv="Pragma">
<meta content="no-cache, must-revalidate" http-equiv="Cache-Control">
<style type="text/css">
A.nav {
    text-decoration: none;
    color: black;
    font-weight:bold;
}
</style>
</head>
<body topmargin="0" bottommargin="0" rightmargin="0" leftmargin="0">
<script type="text/javascript">
function CustomajaxFunction(ajaxAction,getPage,doReturn,returnID)
{
    var xmlHttp;
    try
    {
        // Firefox, Opera 8.0+, Safari
        xmlHttp=new XMLHttpRequest();
    }
    catch (e)
    {
        // Internet Explorer
        try
        {
            xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
        }
        catch (e)
        {
            try
            {
                xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
            }
            catch (e)
            {
                alert("Your browser does not support AJAX!");
                return false;
            }
        }
    }

    xmlHttp.onreadystatechange=function()
    {
        if(xmlHttp.readyState==4)
        {
            if ( document.getElementById(returnID) )
            {
                document.getElementById(returnID).innerHTML=xmlHttp.responseText;
                return false;
            }
        }
    }
    xmlHttp.open(ajaxAction,getPage,true);
    xmlHttp.send(null);
}
</script>

<script language="javascript">
function FirstCheck()
{
    var g=document.report.school.value;
    if (g.length)
    {
        document.getElementById('shwschool3').style.display='';
        document.getElementById('shwschoollbl3').style.display='';
        CustomajaxFunction('get','showgrade.html?gradec='+g,1,'shwschool3');        
        document.getElementById('shwteacherlbl3').style.display='none';
        document.getElementById('shwteacher3').style.display='none' 
    }
    else
    {
        document.getElementById('shwschool3').style.display='none';
        document.getElementById('shwschoollbl3').style.display='none';      
        document.getElementById('shwteacher3').style.display='none';
        document.getElementById('shwteacherlbl3').style.display='none';     
        document.getElementById('shwcourselbl3').style.display='none';
        document.getElementById('shwcourse3').style.display='none'; 
    }
}

function SecondCheck()
{
    var g=document.report.DistrictGrade.value;
    var b=document.report.school.value;

    if (g.length)
    {
        document.getElementById('shwteacher3').style.display='';
        document.getElementById('shwteacherlbl3').style.display='';
        CustomajaxFunction('get','showname.html?tgrade='+g+'&amp;sch='+b,1,'shwteacher3');     
    }
    else
    {
        document.getElementById('shwteacher3').style.display='none'; …
danarashad 17 Light Poster

You might be able to do this with ajax. Below is a good example.
http://blog.nitorsys.com/ajax-call-to-coldfusion-component-using-jquery/

danarashad 17 Light Poster

I am using an ajax to load form fields. When the you select the school, the grade fields load. When you select the grade, the show name check box appears. When the select all box appears, I have to click the select all box twice for it to work. I am not really sure what the issue is.
I also posted the code to paste bin.
Click Here
showGrade
showname
showcourse

<html>
<head>
<title>Scoring</title>
<meta content="text/html; charset=iso-8859-1" http-equiv="Content-Type">
<meta content="no-cache" http-equiv="Pragma">
<meta content="no-cache, must-revalidate" http-equiv="Cache-Control">
<style type="text/css">
A.nav {
    text-decoration: none;
    color: black;
    font-weight:bold;
}
</style>
</head>
<body topmargin="0" bottommargin="0" rightmargin="0" leftmargin="0">
<script type="text/javascript">
function CustomajaxFunction(ajaxAction,getPage,doReturn,returnID)
{
    var xmlHttp;
    try
    {
        // Firefox, Opera 8.0+, Safari
        xmlHttp=new XMLHttpRequest();
    }
    catch (e)
    {
        // Internet Explorer
        try
        {
            xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
        }
        catch (e)
        {
            try
            {
                xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
            }
            catch (e)
            {
                alert("Your browser does not support AJAX!");
                return false;
            }
        }
    }

    xmlHttp.onreadystatechange=function()
    {
        if(xmlHttp.readyState==4)
        {
            if ( document.getElementById(returnID) )
            {
                document.getElementById(returnID).innerHTML=xmlHttp.responseText;
                return false;
            }
        }
    }
    xmlHttp.open(ajaxAction,getPage,true);
    xmlHttp.send(null);
}
</script>

<script language="javascript">
function FirstCheck()
{
    var g=document.report.school.value;
    if (g.length)
    {
        document.getElementById('shwschool3').style.display='';
        document.getElementById('shwschoollbl3').style.display='';
        CustomajaxFunction('get','showgrade.html?gradec='+g,1,'shwschool3');        
        document.getElementById('shwteacherlbl3').style.display='none';
        document.getElementById('shwteacher3').style.display='none' 
    }
    else
    {
        document.getElementById('shwschool3').style.display='none';
        document.getElementById('shwschoollbl3').style.display='none';      
        document.getElementById('shwteacher3').style.display='none';
        document.getElementById('shwteacherlbl3').style.display='none';     
        document.getElementById('shwcourselbl3').style.display='none';
        document.getElementById('shwcourse3').style.display='none'; 
    }
}

function SecondCheck()
{
    var g=document.report.DistrictGrade.value;
    var b=document.report.school.value;

    if (g.length)
    {
        document.getElementById('shwteacher3').style.display='';
        document.getElementById('shwteacherlbl3').style.display='';
        CustomajaxFunction('get','showname.html?tgrade='+g+'&amp;sch='+b,1,'shwteacher3');     
    }
    else
    {
        document.getElementById('shwteacher3').style.display='none';
        document.getElementById('shwteacherlbl3').style.display='none';     
        document.getElementById('shwcourselbl3').style.display='none';
        document.getElementById('shwcourse3').style.display='none';         
    }
}

function ThirdCheck()
{
    var g=document.report.DistrictGrade.value;
    var b=document.report.school.value;
    var cou = '';
    if ($('input[name=coursereportcheckall][type=checkbox]') && $('input[name=coursereportcheckall]:checked').length >= 1)
    {   
        //alert('');        
    }

    $(document).on('click', …
danarashad 17 Light Poster
danarashad 17 Light Poster

This will help.
Click Here

danarashad 17 Light Poster

I was looking for something that was already built. But the bosses went another way. Thanks for advice.

danarashad 17 Light Poster

you could do something like pagination. That is basically what you are asking for.
http://www.raymondcamden.com/index.cfm/2012/6/22/ColdFusion-and-Pagination--Six-Years-Later

danarashad 17 Light Poster

maxlength should work, but javascript could also work.

danarashad 17 Light Poster

Does anyone know of a job application system that can be used with Coldfusion.

danarashad 17 Light Poster

I used google's api.
http://imagecharteditor.appspot.com/
Google creates a png file on the fly.

danarashad 17 Light Poster

I am some reports I am using google charts for, but when I create a pdf the charts are not being created in the pdf. Is there away around this, or has anyone ran into this issue. I am using google charts because CF charts gives me a image expired error, if I run to many reports at once.

danarashad 17 Light Poster

Is there a way to change the mail spool location? The location is on the c drive. Is there a way I could change the location to another drive?

danarashad 17 Light Poster

I've found a fix.
In the ISAPI Filters on the default web site was missing the tomcat dll. For some reason during the installation the tomcat dll did not get loaded. Thanks for all of the help.

danarashad 17 Light Poster

I can't access the CF Administrator to change the settings. After the install when you launch the CF Admin page, that is when I receive the error. I've uninstalled and reinstalled a couple of times, but I keep getting the same error.

danarashad 17 Light Poster

I am having a problem installing CF 10. I keep getting an HTTP 500 Internal Server Error.

Detailed Error Information
    **Module:**         IsapiModule
    **Notification:**   ExecuteRequestHandler
    **Handler **        cfmHandler
    **Error Code:**     0x80004005
   ** Requested URL**   http://127.0.0.1:80/CFIDE/administrator/index.cfm
    **Physical Path**   C:\ColdFusion10\cfusion\wwwroot\CFIDE\administrator\index.cfm
    **Logon Method**    Anonymous
    **Logon User**      Anonymous
danarashad 17 Light Poster

Is anyone running Coldfusion on a virtual server. If so, are their any problems with running CF on a virtual server?
Thanks

danarashad 17 Light Poster

I've figured it out. I used the jquery ajax call, and called the configureboxes function. The assessmentdisplay is the id of a table, to display.

$.ajax({
url: "test.html,
success: function(assessmentdisplay){
$('##assessmentdisplay').html(assessmentdisplay);
$.configureBoxes();
}
});
danarashad 17 Light Poster

My Jquery dual list box isn't working when I call a page via ajax. But if I navigate to the page, the Jquery works. I've used the .live code but that doesn't seem to work. Any suggestions. The below code, I thought would work, but it doesn't.

$(function(){
    $('.button').live('click', function(){ 
		$(function() {$.configureBoxes();});
	} );
});

Here is the dual list box I am using.
http://www.meadmiracle.com/dlb/DLBPlugin.aspx

http://www.meadmiracle.com/dlb/DLBDocumentation.aspx

danarashad 17 Light Poster

I used the one from Ray Camden.

danarashad 17 Light Poster

I am trying to figure out how to have a certain value as my selected value in a cfselect that is running a cfc?
I am running a cfc, but when someone saves that answer in the database, when they go back into the form. I want the answer they saved to be the selected answer. Has anyone done this before.

danarashad 17 Light Poster

It's caused by the default YUI settings (javascript lib). It only returns stuff that start with whatever you typed. See the bottom comments for how to fix it.
http://www.coldfusionjedi.com/index.cfm/2007/7/23/A-Gotcha-with-Auto-Suggestions-in-ColdFusion-8

Thank you for the information.

danarashad 17 Light Poster

I am having a weird issue. I am using cfautosuggest, when I type child into the search box the cfc should return "Other Minor Child in Custody,Grandchild, Great Grandchild", but it doesn't. The weird part is when the query runs I do a dump in the cfc and it does return "Other Minor Child in Custody,Grandchild", but when json takes over to return it back to the screen, I get nothing. has anyone ran into this issue?

SELECT question
FROM lookup
Where question like <cfqueryparam cfsqltype="cf_sql_varchar" value="%#trim(arguments.search)#%" />
		and lookupname=<cfqueryparam cfsqltype="cf_sql_integer" value="#trim(arguments.keyname)#">
        and responsetype= <cfqueryparam cfsqltype="cf_sql_varchar" value="#ucase(arguments.responseid)#" />
danarashad 17 Light Poster

Try posting all of your code so I can see what going on. :)

I corrected the error, I had a javascript error that I did not see.

danarashad 17 Light Poster

I am running into a problem. I am trying to use coldfusion's form validation. When I use the name and id fields in the form tag. The validation is skipped. Can you not name the form while using CF's form validation?

<cfform action="page.cfm" enctype="multipart/form-data" method="post" name="conferenceForm" id="conferenceForm" >
danarashad 17 Light Poster

Can anyone tell me whats wrong. The error I keep getting is "Access to the Exchange server denied. Ensure that the user name and password are correct."

I've done all of this.
adobe

<cfexchangeConnection
action="open"
connection="sample"
server="mailserver"
protocol="https"
username="username"
password="pasword"
formbasedauthentication="true"
formBasedAuthenticationURL="https://webaddress.com"
/>

    <cfexchangecalendar action="get" name="mycal" connection="sample">
        <cfexchangefilter name="startTime" from="#theDate#" to="#theEndDate#">
    </cfexchangecalendar>

<cfexchangeConnection action="close" connection="sample" />
danarashad 17 Light Poster
danarashad 17 Light Poster

Has anyone got this working?
http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?href=00001369.htm

http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?href=00001371.htm
If so, could you let me know how to get it working?
I can't even get Form.employee_grid.rowstatus.action to be defined.

danarashad 17 Light Poster

Is there a way to execute an SSIS packing via coldfusion?

danarashad 17 Light Poster

I've corrected the issue, I just had to remove the multiple="yes".

I am having an issue with cfselect. When I submit the form, I don't get a value from my 2nd cfselect. I am binding. I do get a value from the first select, but the second select does not exist in form data.
I do get values from this form field.

<cfselect name="AdminID" bind="cfc:folder.components.forms.getProjects()" display="ProjectName" value="id" bindonload="true" />

The following does not even exist.

<cfselect name="AdminName" bind="cfc:folder.components.forms.getAdminInfo({AdminID})" display="FullName" value="FullName" multiple="yes" class="customStyleSelectBox"  />

When I do a dump of the form variable I do get adminID, but AdminName is not there? Any suggestions.

danarashad 17 Light Poster

I am having an issue with cfselect. When I submit the form, I don't get a value from my 2nd cfselect. I am binding. I do get a value from the first select, but the second select does not exist in form data.
I do get values from this form field.

<cfselect name="AdminID" bind="cfc:folder.components.forms.getProjects()" display="ProjectName" value="id" bindonload="true" />

The following does not even exist.

<cfselect name="AdminName" bind="cfc:folder.components.forms.getAdminInfo({AdminID})" display="FullName" value="FullName" multiple="yes" class="customStyleSelectBox"  />

When I do a dump of the form variable I do get adminID, but AdminName is not there? Any suggestions.

danarashad 17 Light Poster

Dan,

First, just in case you dont know, the three statements will obtain exacltly the same value but I guess you have a reason.

OK, there are a few of ways to do what you want.

If id1 , id2 , id3 are global variables, then they are equivalent to window['id'+1] , window['id'+2] , window['id'+3] . This is so because (in the browser environment) all javascript global members (eg. variables, arrays, functions, objects) are properties of window.

If your vars are properties of some other object O , then they can be similarly addressed O['id'+1] , O['id'+2] , O['id'+3] .

Within a constructor function, you can similarly use this to create properties, eg :

for (i=1; i<=3; i++) {
  this["id" + i] = document.getElementById("sid").value;
}

where this stands for each particular instance of the constructor ("class" by any other name).

Local vars within a standard (non-constructor) function are different because they aren't properties of an accessible object in the same way as globals (without resorting to eval() which is kinda evil). The way round this is to create a local object (or associative array) to give yourself something that can be addressed, eg :

var O = {}; //object
/* or var O = []; for an array */
for (i=1; i<=3; i++) {
  O["id" + i] = document.getElementById("sid").value;
}

Airshow

Thanks Airshow, I got a better understanding. Yeah I know they will have the same value.

danarashad 17 Light Poster

It doesn't make much sense to return _multiple_ results to a cfinput box. Perhaps you're thinking of something different, like an auto-suggest maybe..?

Yeah I had to end up using an auto-suggest.

danarashad 17 Light Poster

1. Read a book or blog on basic Javascript syntax.
2. You can't create variables in this manner. Instead create an array and add your values to that (your reading on basic syntax will help you here).
3. Your counter isn't initialized to have a value so your loop will not iterate.

Thanks for the smart comments, but I did create the variables. The following code did exactly what I wanted. I miscopied the jscounter variable. I did set it to a number. I just didn't paste it. But thanks.

var jscounter=5;
var i=0;
var sid='sid';
for (i=0;i<=jscounter;i++)
{
eval("var id" + i + "=document.getElementById("+sid+").value;");
}
danarashad 17 Light Poster

I am pretty sure this is easy to figure out, but I don't know javascript that good. I am trying to declare variables dynamically but what I have below does not work.
What I want to accomplish is the following.
var id1 = document.getElementById("sid").value;
var id2 = document.getElementById("sid").value;
var id3 = document.getElementById("sid").value;

This is what I have so are but its not working.

var jscounter
for (i=0;i<=jscounter;i++)
{
var "id" + i + = document.getElementById("sid").value;
}

The above does not work. Help.

danarashad 17 Light Poster
Federal Projects:
<cfselect name="AdminID" bind="cfc:folder.components.forms.getProjects()" display="ProjectName" value="AdminID" bindonload="true" />
Administrators:
<cfselect name="AdminName" bind="cfc:folder.components.forms.getAdminInfo({AdminID})" display="FullName" value="PrincipalID" />

The Code above queries a cfc and returns the results to the second cfselect. My question would be how to return the result to a cfinput box? Is that even possible.

danarashad 17 Light Poster
<cfldap server="my.ldap.server" PORT="389" action="query" name="GetEmployee" 
start = "cn=users,dc=directory,dc=school,dc=org" 
attributes = "cn,sn,uid,givenName,mail,position,telephonenumber,memberUid"
username="cn=username" password="pass">

When I run my code, I get an error. First is the code correct or do I not have the correct permissions.

Authentication failed:[LDAP: error code 49 - Invalid Credentials]
danarashad 17 Light Poster

Does anyone know if it is possible to format the Excel spreadsheet (dynamically created using ColdFusion and pulling from a MySQL database) to have the Excel file automatically set to landscape, rather than portrait for printing. My client wants that Excel spreadsheet formatted for him. I have the borders and colors and headers set, but I'm told they've seen this done before, so I was hoping someone could tell me how, or point me in the right direction. I've done a google search, but can't find anything about this. The only way that I can imagine it could be done, is if the data is being put into an Excel file that is acting as a template, with all the features set in advance, but I don't know if that's possible using ColdFusion, nor have I ever seen it done. Any help is greatly appreciated.

Thank you in advance.
elizabeth

I am currently doing this, but I don't use landscape. I am changing font colors, cell shading. The following links should work.

http://www.bennadel.com/blog/484-Adding-Basic-CSS-Support-To-My-POI-Utility-ColdFusion-Component-For-Excel-Creation.htm

http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Read-And-Write-Excel-Files.htm

http://www.d-ross.org/index.cfm?objectid=9C65ECEC-508B-E116-6F8A9F878188D7CA

http://www.bennadel.com/blog/865-POIUtility-cfc-Examples-For-Reading-And-Writing-Excel-Files-In-ColdFusion.htm
danarashad 17 Light Poster

I am having a problem with autosuggest. That creates a list with ',' in them.
Example the list values of my query is.

6-7 Reading (AMS, BMS, RMS)
6-7 Teaching Reading (CMS, KMS, NMS)
6-8 BD
6-8 Computer Applications & Computer Integrators

But when I am typing in my box for auto suggest. it cuts off after the first ,
So 6-7 should read 6-7 Reading (AMS, BMS, RMS), instead it reads 6-7 Reading (AMS
Is there away around this.
This is how I am returning, my list from the cfc.

<cfset getsearch = ValueList(q.audiencename)>
<cfreturn getsearch>
danarashad 17 Light Poster

Found a solution. I used DeMoronize function.
http://www.cflib.org/udf/DeMoronize

peter_budo commented: Thanx for sharing solution +17
danarashad 17 Light Poster

I have users insert text on pages. When they do a copy paste from word. With a bullet point or a '. It shows up on the pages as []. Can someone help. Is there a safe html insert for coldfusion or a safe text insert. That would strip out invalid characters.

danarashad 17 Light Poster

It worked when I installed the patch.

danarashad 17 Light Poster

I am getting odd query results. I should be getting a list of students, over 100, but I am only getting 3. Here is my connection and sql, please help. It works excellent on PC, but the client is using a Mac. Please advise. On PC, I get all 100 rows, but on the Mac the client gets only 3 rows. With the exact same code.

<?php  $conn=odbc_connect('sitepoint','sitepoint','sitepoint'); if (!$conn) {exit("Connection Failed: " . $conn);} $sql="SELECT fname, lname FROM table1"; $rs=odbc_exec($conn,$sql);  if (!$rs) {exit("Error in SQL");} echo "<table><tr>"; echo "<th>First Name</th>"; echo "<th>Last Name</th></tr>"; while (odbc_fetch_row($rs)) {  $fname=odbc_result($rs,"fname");  $lname=odbc_result($rs,"lname"); echo "<tr><td>$fname</td>"; echo "<td>$lname</td></tr>"; }  odbc_close($conn); echo "</table>";  ?>
danarashad 17 Light Poster

I am getting the following error sometimes. When the user load gets heavy I'll receive the following error. Would puting cftransaction around my update statements work?
ODBC Error Code = 40001 (Serialization failure)
DiagnosticsODBC Error Code = 40001 (Serialization failure Microsoft ODBC SQL Server Driver SQL Server Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim.
The update statement I am using is really simple.
What is a serialzation error, and how to prevent them.

<cfquery name="update" datasource="#db#">
UPDATE sumDemo SET 
Level = <cfqueryparam value="#form.level#" cfsqltype="cf_sql_char">, 
hobbies = <cfqueryparam value="#form.hobbies#" cfsqltype="cf_sql_varchar">,
address = <cfqueryparam value="#form.address#" cfsqltype="cf_sql_varchar">,	
phone = <cfqueryparam value="#form.phone#" cfsqltype="cf_sql_varchar">,
email = <cfqueryparam value="#form.email#" cfsqltype="cf_sql_varchar">,	
colleges = <cfqueryparam value="#form.colleges#" cfsqltype="cf_sql_varchar">,
employ1 = <cfqueryparam value="#form.employ1#" cfsqltype="cf_sql_varchar">,	
employ2 = <cfqueryparam value="#form.employ2#" cfsqltype="cf_sql_varchar">,
employ3 = <cfqueryparam value="#form.employ3#" cfsqltype="cf_sql_varchar">,	
job1 = <cfqueryparam value="#form.job1#" cfsqltype="cf_sql_varchar">,
job2 = <cfqueryparam value="#form.job2#" cfsqltype="cf_sql_varchar">, 
job3 = <cfqueryparam value="#form.job3#" cfsqltype="cf_sql_varchar">
where userid=<cfqueryparam value="#form.userid#" cfsqltype="cf_sql_varchar">
</cfquery><cfquery name="update" datasource="#db#">
UPDATE sumDemo SET 
Level = <cfqueryparam value="#form.level#" cfsqltype="cf_sql_char">, 
hobbies = <cfqueryparam value="#form.hobbies#" cfsqltype="cf_sql_varchar">,
address = <cfqueryparam value="#form.address#" cfsqltype="cf_sql_varchar">,	
phone = <cfqueryparam value="#form.phone#" cfsqltype="cf_sql_varchar">,
email = <cfqueryparam value="#form.email#" cfsqltype="cf_sql_varchar">,	
colleges = <cfqueryparam value="#form.colleges#" cfsqltype="cf_sql_varchar">,
employ1 = <cfqueryparam value="#form.employ1#" cfsqltype="cf_sql_varchar">,	
employ2 = <cfqueryparam value="#form.employ2#" cfsqltype="cf_sql_varchar">,
employ3 = <cfqueryparam value="#form.employ3#" cfsqltype="cf_sql_varchar">,	
job1 = <cfqueryparam value="#form.job1#" cfsqltype="cf_sql_varchar">,
job2 = <cfqueryparam value="#form.job2#" cfsqltype="cf_sql_varchar">, 
job3 = <cfqueryparam value="#form.job3#" cfsqltype="cf_sql_varchar">
where userid=<cfqueryparam value="#form.userid#" cfsqltype="cf_sql_varchar">
</cfquery>
danarashad 17 Light Poster

I am getting the following error sometimes. When the user load gets heavy I'll receive the following error. Would puting cftransaction around my update statements work?
ODBC Error Code = 40001 (Serialization failure)
DiagnosticsODBC Error Code = 40001 (Serialization failure Microsoft ODBC SQL Server Driver SQL Server Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim.
The update statement I am using is really simple.

<cfquery name="update" datasource="#db#">
UPDATE sumDemo SET 
Level = <cfqueryparam value="#form.level#" cfsqltype="cf_sql_char">, 
hobbies = <cfqueryparam value="#form.hobbies#" cfsqltype="cf_sql_varchar">,
address = <cfqueryparam value="#form.address#" cfsqltype="cf_sql_varchar">,	
phone = <cfqueryparam value="#form.phone#" cfsqltype="cf_sql_varchar">,
email = <cfqueryparam value="#form.email#" cfsqltype="cf_sql_varchar">,	
colleges = <cfqueryparam value="#form.colleges#" cfsqltype="cf_sql_varchar">,
employ1 = <cfqueryparam value="#form.employ1#" cfsqltype="cf_sql_varchar">,	
employ2 = <cfqueryparam value="#form.employ2#" cfsqltype="cf_sql_varchar">,
employ3 = <cfqueryparam value="#form.employ3#" cfsqltype="cf_sql_varchar">,	
job1 = <cfqueryparam value="#form.job1#" cfsqltype="cf_sql_varchar">,
job2 = <cfqueryparam value="#form.job2#" cfsqltype="cf_sql_varchar">, 
job3 = <cfqueryparam value="#form.job3#" cfsqltype="cf_sql_varchar">
where userid=<cfqueryparam value="#form.userid#" cfsqltype="cf_sql_varchar">
</cfquery>
danarashad 17 Light Poster

Here's the code. Its just the resize code.

<cfimage action="resize" height="400" width="600" source="f:\webfolder\sites\#dirName#\#userlogin#\gallery\#filename#.#filedata[x].serverfileext#" 
destination="f:\webfolder\sites\#dirName#\#userlogin#\gallery\#filename#.#filedata[x].serverfileext#" overwrite="true"/>
danarashad 17 Light Poster

I am having trouble resizing images. It works with normal smaller images. I am resizing them to 400 x 600. If someone uploads a 1000 x 1000 photo it works. But some people are uploading images 2300 x 3000 and it doesn't work.
I've used this but it doesnt seem to work.
http://kb.adobe.com/selfservice/viewContent.do?externalId=kb403411

danarashad 17 Light Poster

I would assume the

url.sitename

should extract what you want.