DaniWeb IT Discussion Community - ColdFusion http://www.daniweb.com/forums/ en-US Wed, 23 Dec 2009 09:22:04 GMT vBulletin 60 http://www.daniweb.com/alphaimages/misc/rss.jpg DaniWeb IT Discussion Community - ColdFusion http://www.daniweb.com/forums/ Multiple Related Selects using coldfusion and Javascript http://www.daniweb.com/forums/thread248068.html Mon, 21 Dec 2009 16:57:55 GMT Hi I am trying multiple related selects using coldfusion and javascript. I have four dropdown list first one is related to the second one and thrid one is related to the first one. It is working as per expected if i have two drop down lists which are related to each other , but if I add third and... Hi
I am trying multiple related selects using coldfusion and javascript. I have four dropdown list first one is related to the second one and thrid one is related to the first one. It is working as per expected if i have two drop down lists which are related to each other , but if I add third and fourth one and then I select the first one the fourth dropdown is getting selected and if I try the thrid one nothing is happening the second dropdown is not displaying the data which should be populated automatically if i select the first one and if I select the third one fourth should be display data automatically

Please help me get the other selects working. Thank you in advance


Here is the code
<cfquery name="Offices" datasource="Ps"> 

        Select OName, Ocode 

        From Office 

        Where Area = '01'  

        Order by OName 

</cfquery> 

<cfquery name="Districts" datasource="ds"> 

        Select OName, OCode 

        From office 

        Where Area = '01' and OType = 'F1' 

        Order by OName 

</cfquery> 

  

  <SCRIPT LANGUAGE="JavaScript1.1">

<!--

if (typeof(Option)+"" != "undefined") v=true;

//-->

</SCRIPT>

<SCRIPT LANGUAGE="JavaScript"> 

 

if(v){a=new Array();aln=0;} 

function getFormNum (formName) { 

formNum =-1; 

for (i=0;i<document.forms.length;i++){ 

tempForm = document.forms[i]; 

if (formName == tempForm) { 

formNum = i; 

correctForm = tempForm; 

break; 

   } 

} 

return formNum; 

} 

function jmp(formName,elementNum) { 

getFormNum(formName); 

if (formNum>=0) { 

with (document.f2.myChoice) { 

i=selectedIndex; 

if (i>=0) location=options[i].value; 

      } 

   } 

} 

function O(txt,url) { 

a[k]=new Option(txt,url);k++; 

} 

function relate(formName,elementNum,j) { 

if(v) { 

        k=1; 

  

                if(j==0) { // 1st category items 

                        a=new Array(); 

                         

                                O("-------------------","---"); 

                         

                        } 

                         

                if(j==1) { // 1st category items 

                        a=new Array(); 

                         

                                O("-------------------","---"); 

                         

                        } 

         

                if(j==2) { // 1st category items 

                        a=new Array(); 

                        <cfoutput query="Offices"> 

                                O("#Oname#","#Ocode#"); 

                        </cfoutput> 

                        } 

         

                if(j==3) { // 2nd category items 

                        a=new Array(); 

                        <cfoutput query="Districts"> 

                                O("#Oname#","#Ocode#"); 

                        </cfoutput> 

                        } 

         

        aln2=a.length; 

        getFormNum(f2); 

        if (formNum>=0) { 

                formNum = formNum + 1; 

                with (document.f2.myChoice) { 

                        for (var i=options.length-1;i>0;i--) options[i]=null; 

                        for (var i=1;i<aln2;i++) options[i-1]=a[i]; 

                        options[0].selected=true; 

                    } 

                        } 

        }  

else { 

        jmp(f2,elementNum); 

                } 

document.f2.myChoice.focus(); 

} 

</SCRIPT> 





<SCRIPT LANGUAGE="JavaScript1.1">

<!--

if (typeof(Option)+"" != "undefined") v=true;

//-->

</SCRIPT>



<SCRIPT LANGUAGE="JavaScript">



<!-- Original:  webreference.com  -->

<!-- Web Site:  http://webreference.com  -->



<!-- This script and many more are available free online at -->

<!-- The JavaScript Source!! http://javascript.internet.com -->



<!--  Begin

if(v){a=new Array();aln=0;}

function getFormNum (formName) {

formNum =-1;

for (i=0;i<document.forms.length;i++){

tempForm = document.forms[i];

if (formName == tempForm) {

formNum = i;

correctForm = tempForm;

break;

   }

}

return formNum;

}

function jmp(formName,elementNum) {

getFormNum(formName);

if (formNum>=0) {

with (document.f2.mySelect) {

i=selectedIndex1;

if (i>=0) location=options[i].value;

      }

   }

}

function O(txt,url) {

a[k]=new Option(txt,url);k++;

}

function relate(formName,elementNum,j) {

if(v) {

        k=1;



          if(j==0) { // 1st category items 

                        a=new Array(); 

                         

                                O("-------------------","---"); 

                         

                        } 

                         

                if(j==1) { // 1st category items 

                        a=new Array(); 

                         

                                O("-------------------","---"); 

                         

                        } 

         

                if(j==2) { // 1st category items 

                        a=new Array(); 

                        <cfoutput query="Offices"> 

                                O("#Oname#","#Ocode#"); 

                        </cfoutput> 

                        } 

         

                if(j==3) { // 2nd category items 

                        a=new Array(); 

                        <cfoutput query="Districts"> 

                                O("#Oname#","#Ocode#"); 

                        </cfoutput> 

                        } 

        aln2=a.length;

        getFormNum(f2);

        if (formNum>=0) {

                formNum = formNum + 1;

                with (document.f2.mySelect) {

                        for (var i=options.length-1;i>0;i--) options[i]=null;

                        for (var i=1;i<aln2;i++) options[i-1]=a[i];

                        options[0].selected=true;

                    }

                          }

        } 

else {

        jmp(f2,elementNum);

                  }

document.f2.mySelect.focus();

}

// End -->

</SCRIPT>





  

<cfform name=f2 action="display.cfm"> 

<cfif '0' is not "Reg">

        <p><label for=ReportLevel class="style3"><span class="style6">Report Level:</span></label> 

                <select name=ReportLevel id=ReportLevel onChange="relate(this.form,2,this.selectedIndex);"> 

                        <option value="Reg" selected>Reg Summary&nbsp;</option> 

                        <option value="Area" selected>Area Summary&nbsp;</option> 

                        <option value="Office">Office&nbsp;&nbsp;&nbsp;&nbsp;</option> 

                        <option value="District">District&nbsp;</option> 

                </select> 

          </p>                   

                                 

         

        <p><label for=myChoice><span class="style6">Select Office: (if applicable)</span></label>  

        <select         name=myChoice 

                                ID=myChoice 

                                > 

                         

                                <option value="---">-------------------</option> 

                </select> 

        </p> 

     <p><label for=ReportLevelz class="style3"><span class="style6">Assigned Component:</span></label>

                <select name=ReportLevelz id=ReportLevelz onChange="relate(this.form,2,this.selectedIndex1);">

            <option value="Reg" selected>Reg Summary&nbsp;</option> 

                        <option value="Area" selected>Area Summary&nbsp;</option> 

                        <option value="Office">Office&nbsp;&nbsp;&nbsp;&nbsp;</option> 

                        <option value="District">District&nbsp;</option> 

                </select>

          </p>                        

                                

        

        <p><label for=mySelect><span class="style6">Assinged Office </span></label> 

        <select         name=mySelect

                                ID=mySelect

                                >

                        

                                <option value="---">-------------------</option>

                </select>

        </p>

     

    <cfelse>

        <input type="hidden" name="Home Office " value="Reg">

        <input type="hidden" name="myChoice" value="---">

    <input type="hidden" name="mySelect" value="---">

</cfif>

            

</cfform>
]]> ColdFusion sanm http://www.daniweb.com/forums/thread248068.html <![CDATA[SMTP server replied "5.7.1 Unable to relay for]]> http://www.daniweb.com/forums/thread246735.html Wed, 16 Dec 2009 02:06:34 GMT Hi;
Error in cold fusion 5. Failed to send the spooled mail file, E:\CFusion\Mail\spool\BD81.cfmail. SMTP server replied "5.7.1 Unable to relay for aaaa@bbbb.com" Moved file to E:\CFusion\Mail\undelivr\BD84.cfmail.
Can someone help me. ]]> ColdFusion satar http://www.daniweb.com/forums/thread246735.html Help Needed!! http://www.daniweb.com/forums/thread243331.html Thu, 03 Dec 2009 11:36:33 GMT :?:Hi! I am in search for some technical newsletters to subscribe.. Can someone provide me with a list?? :?:Hi! I am in search for some technical newsletters to subscribe.. Can someone provide me with a list?? ]]> ColdFusion suryakantb http://www.daniweb.com/forums/thread243331.html Coldfusion Clustering issue - Images are not loading properly http://www.daniweb.com/forums/thread241826.html Fri, 27 Nov 2009 15:15:31 GMT Hi, I am new to coldfusion. I installed CF7 in multiserver configuration. I created two instances on same box and created a cluster. I can browse to the two instances seperately and thru the cluster. I am having an issue. When I access instances directly the site is working fine, but when I... Hi,

I am new to coldfusion. I installed CF7 in multiserver configuration. I created two instances on same box and created a cluster. I can browse to the two instances seperately and thru the cluster.

I am having an issue. When I access instances directly the site is working fine, but when I access it thru cluster, the images, javascript are not loading. I am getting error on jjQuery also( jQuery is undefined error).

I might have missed a basic thing in the installation but do not know what.

Could anyone help me to resolve this issue?

Thanks in advance. ]]> ColdFusion sathish009 http://www.daniweb.com/forums/thread241826.html Does ColdFusion MX 7 have cfselect bind option? http://www.daniweb.com/forums/thread240488.html Sun, 22 Nov 2009 19:17:48 GMT Hi everyone, In coldfsuion mx 7 does cfselect supports bind option which is supported by coldfusion 8.I have seen live docs for cfselect but in live docs it dint show any bind option for cfselect tag. If bind attribute is not present how we need implement related selects.... Hi everyone,

In coldfsuion mx 7 does cfselect supports bind option which is supported by coldfusion 8.I have seen live docs for cfselect but in live docs it dint show any bind option for cfselect tag. If bind attribute is not present how we need implement related selects.

I have two cfselects in which the second should populate values by executing a query where the query takes the value that is selected in first cfselect.....how i need to approach this problem....for some reason bind option doesnt worked in coldfusion mx 7 which worked fine in coldfusion 8 ]]> ColdFusion coolcold http://www.daniweb.com/forums/thread240488.html Simple addition not working - can anyone help? http://www.daniweb.com/forums/thread239084.html Tue, 17 Nov 2009 02:09:23 GMT First I run a simple query to get the max ID from the table, which
returns a number 10284. To which I would like to add a randomly generated number. So I get a number like '2' and it adds it and I get 10287 - which is INCORRECT! I was expecting 10286. So what am I doing wrong? I've run this dozens of times and I can't find a pattern to it...the random number is generating nicely but the results of the two values are rarely what I expect. Thanks for any help!

 

<cfquery name="Find_Max" datasource="#application.dbfile#">

   SELECT max(MainID) as maxID

   FROM Main

</cfquery>



Returns a number from the table like 10284.



<cfset total =  val(#Find_Max.MaxID#) + val(#RandRange(1,10)#)>

 

<cfoutput>val(#RandRange(1,10)#)</cfoutput><br />

<CFOUTPUT>#Find_Max.MaxID# + random number = #total#</CFOUTPUT>
]]> ColdFusion oldnewbee http://www.daniweb.com/forums/thread239084.html limit access to Coldfusion on Windows 2003 (iis) server http://www.daniweb.com/forums/thread239026.html Mon, 16 Nov 2009 20:18:23 GMT I have 3-4 sites that do not need access to Coldfusion. I want to block their ability to use it. How can I do this? I want to especially ensure that these sites will not be able to call on any of the data sources set up in coldfusion. galaxygal I have 3-4 sites that do not need access to Coldfusion. I want to block their ability to use it. How can I do this? I want to especially ensure that these sites will not be able to call on any of the data sources set up in coldfusion.

galaxygal ]]> ColdFusion galaxygal http://www.daniweb.com/forums/thread239026.html Simple? SQL insert problem http://www.daniweb.com/forums/thread238355.html Fri, 13 Nov 2009 18:46:29 GMT I am building a site for my hockey league. I have been dealing with CF for a number of years, but would in no way class myself as any sort of expert. I am not sure if I am just having a brainfart, or what with this one! I have a simple form that pulls the rosters of a team based on the schedule... I am building a site for my hockey league. I have been dealing with CF for a number of years, but would in no way class myself as any sort of expert. I am not sure if I am just having a brainfart, or what with this one!

I have a simple form that pulls the rosters of a team based on the schedule and whether or not they are the home team or the away team.

I then want to insert (if checked) their player_id and (if player_id checked), the jersey number in which they wore from a populated list menu. This needs to be inserted into another table called scoresheet. The only thing that is important is that they are split between roster_home and roster_away (the team_id's have to be unique to the proper team)

The checkbox holds the player_id list as "roster_away or roster_home"
The list menu holds potential jersey numbers;

Seems simple enough, but I can't get the insert to work properly and align the player_id with the jersey numbers.

Help?

Here is my form:
<form name="game_rosters" action="" method="POST">

<table width="300" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>

        <td width="70" colspan="3" align="center"><cfoutput>#getGameInfo.away_team#</cfoutput> Game Roster</td> 

</tr>

<tr>

        <td>Played?</td>

        <td>Jersey</td>

        <td>Player</td>

</tr>



        <cfoutput query="getAwayRoster">

<tr>

        <td width="70" align="center">

            <input name="roster_away" type="checkbox" value="#getAwayRoster.player_id#"></td>

        <td width="80"> 

        <select name="away_player_jersey_number">

        <option value="#getAwayRoster2.player_jersey_number#" selected>#getAwayRoster2.player_jersey_number#</option>

        <cfloop index="awj" from="0" to="99">

        <option value="#awj#">#awj#</option>

        </cfloop>

        </select>

     </td>

         <td width="150">#getAwayRoster.player_fname#&nbsp;#getAwayRoster.player_lname#</td>

</tr>

<tr>

      <td colspan="3" align="center">&nbsp;</td>

</tr>

              

        </cfoutput>

</table>



<table width="300" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>

        <td width="70" colspan="3" align="center"><cfoutput>#getGameInfo.home_team#</cfoutput> Game Roster</td> 

</tr>

<tr>

        <td>Played?</td>

        <td>Jersey</td>

        <td>Player</td>

</tr>



        <cfoutput query="getHomeRoster">

<tr>

        <td width="70" align="center">

            <input name="roster_home" type="checkbox" value="#getHomeRoster.player_id#"></td>

        <td width="80"> 

        <select name="home_player_jersey_number">

        <option value="#getHomeRoster2.player_jersey_number#" selected>#getHomeRoster2.player_jersey_number#</option>

        <cfloop index="hj" from="0" to="99">

        <option value="#hj#">#hj#</option>

        </cfloop>

        </select>

     </td>

         <td width="150">#getHomeRoster.player_fname#&nbsp;#getHomeRoster.player_lname#</td>

</tr>

<tr>

      <td colspan="3" align="center"><input name="submit" type="submit" value="Submit" /></td>

</tr>

              

        </cfoutput>

</table>

</form>
]]> ColdFusion fatlip http://www.daniweb.com/forums/thread238355.html Cold Fusion Display FAQ http://www.daniweb.com/forums/thread237127.html Mon, 09 Nov 2009 04:48:45 GMT Hi All, I am new to this Coldfusion and i am creating a FAQ page. My Database is MS ACCESS. It is working but with some code error as i am displaying 5 FAQ on first page then next 5 FAQ on the other page and so on. The PROBLEM i am having is lets say my Database has 18 faqs. it would... Hi All,

I am new to this Coldfusion and i am creating a FAQ page.
My Database is MS ACCESS. It is working but with some code error as i am displaying 5 FAQ on first page then next 5 FAQ on the other page and so on. The PROBLEM i am having is lets say my Database has 18 faqs.
it would display
page 1 --- 5 FAQ
page 2 --- 5 FAQ
page 3 --- 5 FAQ
PAGE 4 --- DOESNT SHOW ANY FAQ so the remaining 3 are not retrieved from the database.

I will be very thankful if you guys can please help me with this issue.

Below is the code :
*****************************************************

<html>

<head>

<title>Frequently Asked Questions</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<link href="FAQStylesheet.css" rel="stylesheet" type="text/css">



</head>



<body>

<img src="RMA.JPG" width="960" height="63">

<hr><hr>

<H2>FREQUENTLY ASKED QUESTIONS</H2>

<hr>

<br>

<form action="search.cfm" method="post">

<input type="submit" name="Search" value="Search FAQ"> 

</form>

<br><br><br>



<cfquery name="getfaq" datasource="faqdatabase">

Select *

from qa

order by qarefno desc

</cfquery>



<cfparam name="URL.PageIndex" default="0">

<cfset Recordsperpage=5 >

<cfset totalpages=(getfaq.recordcount/recordsperpage)-1>

<cfset startrow=(URL.pageindex*recordsperpage)+1>

<cfset endrow=(startrow+recordsperpage)-1> 



<cfoutput>

 <cfloop query="getfaq" >

 <cfif currentrow gte startrow> 



<Strong>Qusetion#getfaq.qarefno# :

#getfaq.fquestion#</Strong><br>

<Strong>Answer:</Strong>  <h4>#getfaq.fanswer#</h4>





<br><br><br><br><br>

</cfif>

<cfif currentrow eq endrow>

<cfbreak>

</cfif>

</cfloop>

</cfoutput>

<strong>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Select Page</strong>

<cfloop index="pages" from="0" to="#totalpages#">

<cfoutput> 

|

<cfset displaypgno=pages+1>

<cfif URL.pageindex eq pages>

<strong>#displaypgno#</strong>



<cfelse>

<a href="?pageindex=#pages#">#displaypgno#</a>

</cfif>

|

</cfoutput>

</cfloop>







</body>

</html>

*****************************************************

Pls help! ]]> ColdFusion evilsanta03 http://www.daniweb.com/forums/thread237127.html ColdFusion Current Page + Spry Slider http://www.daniweb.com/forums/thread235778.html Tue, 03 Nov 2009 21:53:10 GMT Hey All,



Question: I have a coldfusion/access database first of all , and I'm using the Dreamweaver Accordion Slider Spry. So I have 4 panels that slide once clicked, here is my issue... I have my database populated on Panel #3, When I hit next or previous it will go to the next 3 records for that recordset but... it will refresh the page and resume back at Panel #1 so Panel #3 will be closed and have to be reopened to view it. How can I set the next/previous to go to a certain Panel ID and stay on it.



I'm no master at coldfusion but I'm just assuming it has something to do with this part of the code with the "#CurrentPage#"
a href="#CurrentPage#?PageNum_Edit=#Min(IncrementValue(PageNum_Edit),TotalPages_E dit)##QueryString_Edit#">Next</a>
]]> ColdFusion dimerbox http://www.daniweb.com/forums/thread235778.html ColdFusion creating Excel file http://www.daniweb.com/forums/thread235763.html Tue, 03 Nov 2009 20:57:46 GMT 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... 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 ]]> ColdFusion elizabeth1 http://www.daniweb.com/forums/thread235763.html Multiple Uploads Help Please http://www.daniweb.com/forums/thread235750.html Tue, 03 Nov 2009 20:07:10 GMT Could someone please help me figure out how to offer multiple upload fields for a CF application? The current app starts with a login, and depending on the role, takes the user to a form that is then filled out. The form processing is done on the same CF page, if all is successful, the resulting... Could someone please help me figure out how to offer multiple upload fields for a CF application? The current app starts with a login, and depending on the role, takes the user to a form that is then filled out. The form processing is done on the same CF page, if all is successful, the resulting code offers the user the ability to then upload an image. This is all working fine. However, now my client wants the user to be able to upload up to 5 images. These images need to each have a restriction on the file type, and the file size. I have that working for the one field, but need to figure out how to do this for multiple fields. Any help is greatly appreciated.

Thank you in advance.

elizabeth ;-) ]]> ColdFusion elizabeth1 http://www.daniweb.com/forums/thread235750.html Reporting Style - coldfusion http://www.daniweb.com/forums/thread235703.html Tue, 03 Nov 2009 16:44:59 GMT First of all, am in the process of learning cold-fusion coding. I have a doubt in reporting part of coldfusion code. I need to make a report style such as below A B C Pass x B x Fail First of all, am in the process of learning cold-fusion coding.

I have a doubt in reporting part of coldfusion code.

I need to make a report style such as below



A B C Pass
x B x Fail
A x C Pass
A x x Pass



Presently am able to get display data table like below:


ABC Pass
BFail
ACPass
APass

Where A,B,C are feed group;



My coding specific to looping is below:

<cfoutput query="PromotionInfo" group= RID> <tr>



<cfoutput group="feed_group">



               <cfif IsSimpleValue(Feed_Group) >



                          <td  nowrap><a href="#PromotionInfo.Report#" target="_blank">#PromotionInfo.feed_group#</a></td>



                    <cfelse>



                          <td><strong>N/A</strong></td>



                </cfif>    



  </cfoutput>



I tried for looping, still no sucess so far..



Note: Problem here in looping is When I tried cfif/Cfloop condition's for every column-wise data,

cfoutput for PromotionInfo.feed_group gives ABC (joined values) not separately ie. for each cycle of loop the data queried are shown in one single row. Am not able to split it since they are not having any delimiters.



Am not sure I gave the right picture of my problem, still expecting someone can help me..



Thanks

Keeran ]]> ColdFusion keeran6 http://www.daniweb.com/forums/thread235703.html Scripting Help Needed http://www.daniweb.com/forums/thread235393.html Mon, 02 Nov 2009 15:34:22 GMT I am redesigning a CF site vo2maxtesting.net in html and need to move it to the other server with minimal/no downtime or loss of Page One ranking. Could anyone help me with redirecting script and tell me if I need to make up a page for each .cfm page or just the index, and anything else I might... I am redesigning a CF site vo2maxtesting.net in html and need to move it to the other server with minimal/no downtime or loss of Page One ranking. Could anyone help me with redirecting script and tell me if I need to make up a page for each .cfm page or just the index, and anything else I might need to know to do this. My job depends on getting it right! Thanks. ]]> ColdFusion powersstuff http://www.daniweb.com/forums/thread235393.html Update Cold Fusion site using only html? http://www.daniweb.com/forums/thread235009.html Sun, 01 Nov 2009 03:22:24 GMT I've been asked to make cosmetic changes to a website that was developed in Cold Fusion. Their original web designer has moved on to other things. Is it possible to make simple changes, such as CSS stylesheet adjustments, new logo, new graphics behind navigation links using standard html coding? Or should I tell them to keep looking for someone well-versed in Cold Fusion programming? ]]> ColdFusion sherech http://www.daniweb.com/forums/thread235009.html Run a CF program as a background process? http://www.daniweb.com/forums/thread234707.html Fri, 30 Oct 2009 14:59:58 GMT I want to write a ColdFusion program that sends an email to a list of people whenever a particular column in a database is edited. I know how to do this, but I want it to run automatically everyday, rather than me having to run it myself. Is there a way to do this?? I want to write a ColdFusion program that sends an email to a list of people whenever a particular column in a database is edited. I know how to do this, but I want it to run automatically everyday, rather than me having to run it myself. Is there a way to do this?? ]]> ColdFusion vikingGirl http://www.daniweb.com/forums/thread234707.html SubCookies http://www.daniweb.com/forums/thread234675.html Fri, 30 Oct 2009 12:23:27 GMT hi, Is any one familiar with use of Subcookies with coldfusion? Please help, its urgent. Thanks hi,

Is any one familiar with use of Subcookies with coldfusion?

Please help, its urgent.

Thanks ]]> ColdFusion kg_ally http://www.daniweb.com/forums/thread234675.html Question and Answer Forum http://www.daniweb.com/forums/thread233091.html Sun, 25 Oct 2009 06:19:37 GMT I need an application like a forum, but only for the purpose of visitors posing questions for attorneys that will respond once a week. The site is in .cfm and is fair credit law group dot com. I'd really like to find someone that can also install it. ]]> ColdFusion ustelephone http://www.daniweb.com/forums/thread233091.html Get referer URL http://www.daniweb.com/forums/thread230808.html Fri, 16 Oct 2009 20:01:04 GMT Hi all,
I have a form where my colleagues enter basic details about participants in a study. The 'action' attribute of the form takes the control to a 'validateForm.cfm' script where, as the name suggests, form validation is done. If there are any problems, I show the errors as well as the form itself, this time populating the fields with the data they entered previously.

To show the form after it has been submitted, I use the 
<cfinclude template />
tag in validateForm.cfm. The validateForm script can be called twice from my site:
1. When the user enters a NEW participant.
2. When the user edits an EXISTING participant data.

Since both times the validation is done by the 'validateForm.cfm' script, I cannot hard-code the template name in <cfinclude>. I tried using 
<cfinclude template=#CGI.HTTP_REFERER# />
too, but I get a 'The filename, directory name, or volume label syntax is incorrect' error.

What am I missing?

Thanks! ]]> ColdFusion cheapterp http://www.daniweb.com/forums/thread230808.html newbie questions on generating Word document from ColdFusion http://www.daniweb.com/forums/thread226581.html Tue, 29 Sep 2009 16:49:18 GMT I am a complete newbie to ColdFusion and Flex. There was a Flex and Coldfusion developer in our project who left so that work has come to me. My programming background is mainly in C,C++, UNIFACE, PL/SQL with some HTML, JavaScript. I have a couple of questions and would appreciate if someone... I am a complete newbie to ColdFusion and Flex. There was a Flex and Coldfusion developer in our project who left so that work has come to me. My programming background is mainly in C,C++, UNIFACE, PL/SQL with some HTML, JavaScript.

I have a couple of questions and would appreciate if someone could respond to them.

The application I am expected to maintain and enhance prints out reports in PDF format which we need to be in MS-Word format. I have looked at the source for the application and see the below lines in one file

<cfdocument format="pdf" filename="#report_filename_format#" orientation="landscape"
pagetype="legal">

Is there a way to do it in the program so that the output is a MS-Word document? I understand the format attribute can take only "PDF" or "flashpaper" as values as per http://livedocs.adobe.com/coldfusion...e=00000236.htm.

I looked at the example at http://tutorial13.easycfm.com/ which shows how you can generate a Word document using ColdFusion.

The first time I ran it it worked well and a word document called Hello.doc was created. The next time, I changed the text to be printed in the Word document from "Hello World" to "Hello World again" it did not and I got the error message "Error Occurred While Processing Request
The SaveAs method was not found. There are no methods with the specified method name and argument types. Check your function and try again. "

I understand the first time, there was no Word document application object so it was created and the text was written to it properly. The next time, ColdFusion is trying to connect to the Word application object which exists, but somehow it is failing. I changed the name of Word file to be written from Hello.doc to Hello123.doc, but it still did not work. I have permissions to write in the directory where the Word file is being created which is why the example ran fine the first time.

The way I am running this example is typing code in a file called helloworld.cfm which is present in my C:\ColdFusion8\wwwroot\CFIDE\administrator\ directory using Editplus editor, then opening a browser and trying to open a page http://127.0.0.1:8500/CFIDE/administ...elloworld.cfm?

1. Is this the proper method?

2. Can someone please clarify where I might be erring in running this example and how can I fix it?

3. Is there an easier way to get the output from ColdFusion in MS-Word format than what I am doing?

Thanks a lot. ]]> ColdFusion H_C http://www.daniweb.com/forums/thread226581.html