DaniWeb IT Discussion Community - ColdFusion http://www.daniweb.com/forums/ en-US Sat, 21 Nov 2009 09:31:59 GMT vBulletin 60 http://www.daniweb.com/alphaimages/misc/rss.jpg DaniWeb IT Discussion Community - ColdFusion http://www.daniweb.com/forums/ 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 Coldfusion http://www.daniweb.com/forums/thread224775.html Tue, 22 Sep 2009 06:08:43 GMT ]]> Hi Everyone,

Could any one please advise me if this language is still feasible to go for?
Is there still a market for it?

Mr RenaldoB
<FAKE SIGNATURE> ]]> ColdFusion Renaldob http://www.daniweb.com/forums/thread224775.html Update several changes in several rows with one button. http://www.daniweb.com/forums/thread224650.html Mon, 21 Sep 2009 18:38:59 GMT Hi Guys, I’m panicking for this issue. Please help. I have a form that all the rows of the table are dynamic and there are text areas in each row that the value could change. The only thing that makes each row unique is the Month row belongs to Month 1 , month 2 adn...). Therefore I... Hi Guys, I’m panicking for this issue. Please help.

I have a form that all the rows of the table are dynamic and there are text areas in each row that the value could change.


The only thing that makes each row unique is the Month row belongs to Month 1 , month 2 adn...). Therefore I created a hidden field in the form that its value will change to the Month belongs to that row. 
(onChange="document.getElementById('Saved_RowID').value ='#MO_CD#';)

<form name="update" action="main.cfm" method="post">

<table class="projectodowoborder" >

<thead>

<tr>

<th colspan="7" align="center"  id="locked">

<input type="submit" border="0" align="middle" value=" Save "  class="def" onclick="document.update.RowID.value='#getRevenue.currentrow#';document.updateRev.action.value = 'Save'</th>        

<th colspan="7" align="center" id="locked">

<input type="Reset" border="0" align="middle" value=" Cancel "class="def">

</th>        

</tr>



       <tr>

<th class="projcapheaderborder" id="locked">Month</td>

<th class="projcapheaderborder" id="locked">Public Ag</td>

</tr>

<cfoutput query='MyQ">

<tr>

<td>



<input name="collections_#MO_CD#" onChange="document.getElementById('Saved_RowID').value ='#MO_CD#';_CF_checkinteger();">

</td>

<td >

<input name="REFUNDED_#MO_CD#" type="text"  onChange="document.getElementById('Saved_RowID').value ='#MO_CD#'>

</td>

</tr>

</cfoutput>

</table>

<input type="hidden" name="Saved_RowID" value="">

</form>

What should I do if they change several rows at the same time which is the case. I have a procedure that receives the string of the data that has been changed for each row.
the value of form.Saved_RowID on the action page is the the Month for example if the value of the 1st row which belongs to Month 12 is changed then the form.Saved_RowID is 12.
I don't know how to get the values fo the changed fields if several rows changed. I really appreciate your help.
Thank you so much. ]]> ColdFusion cfcoder2 http://www.daniweb.com/forums/thread224650.html Coldfusion Report Problem http://www.daniweb.com/forums/thread223808.html Thu, 17 Sep 2009 16:04:06 GMT Hi Guys, I just done an upgrade on my coldfusion server to the latest version now its giving couple of issues. Can anyone please help me out. Thanks The page popup is coming up with this error. Error is: the argument p_day passed to function f_convert_day() is not of type numeric. if the... Hi Guys,

I just done an upgrade on my coldfusion server to the latest version now its giving couple of issues. Can anyone please help me out. Thanks

The page popup is coming up with this error.
Error is:

the argument p_day passed to function f_convert_day() is not of type numeric. if the component name is specified as a type of this argument, the reason for this error might be that a definition file for such component cannot be found or is not accessible.

Thanks ]]> ColdFusion amri5h http://www.daniweb.com/forums/thread223808.html dateDiff problem http://www.daniweb.com/forums/thread223041.html Mon, 14 Sep 2009 23:23:20 GMT ...]]> Hi Folks
In my db i have a datelisted column formatted to short date ie dd/mm/yyyy)

My theory is that say if that datepart year is 2007 i want to list all dates that are then due on the same date in the year 2009.

I can make this work manually by using: 
<cfset getdate = Now()> 

<!---Get date for listing period---> 

<cfset renewYear = #DatePart("yyyy", getdate)# -1

What i want to do is make this dynamic. and i am trying to now is use dateDiff to work out the -1 part of the above.

I currently have:
a query as follows: 
<cfquery name="getrenew" datasource="#dsn#"> 

SELECT  ID, datelisted, renewaldue, region, area, hitcount, webcount, category, busname, buscontact, busphone, mailto, paymethod 

FROM listings 

WHERE  Year(datelisted) = #DatePart("yyyy", Now())# - #dateDiff("yyyy",datelisted,Now())#

in theory this should give me (as an example only)
if the year datelisted is 2007
Year(datelisted) = 2009-2

I am getting an error though that tells me that datelisted is undefined in the dateDiff function

Can anyone please help or see another way to do this

cheers and thanks in advance
Grabit ]]> ColdFusion grabit http://www.daniweb.com/forums/thread223041.html CFGrid and checkboxes http://www.daniweb.com/forums/thread222254.html Fri, 11 Sep 2009 14:12:45 GMT I have included the code. My problem is that I am always getting the error exception thrown and not caught despite adding cftry/cfcatch blocks. If I don't set selectmode="edit" and include OnChange my grid displays except I get the word false displayed instead of a checkbox.


<cfgrid format="html"  name="grid_Tables" pagesize="10" autowidth="true" striperows="yes" width = "99%" selectmode="edit" bind="CFC:qry_GetUser.getAllUsers({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{c fgridsortdirection})"onchange="cfc:qry_GetUser.editData({cfgridaction},{cfgridrow},{cfgridchanged})">

   <cfgridcolumn name="UserID" display="No"/>

   <cfgridcolumn name="opt" header="" type="boolean" width="46"/>

   <cfgridcolumn name="Name" header="Name" width="150" type="string_nocase" select="no" />

   <cfgridcolumn name="Email" header="EMail" width="150" type="string_nocase" select="no" />

   <cfgridcolumn name="RegistrationDate" header="Registration Date" width="150" type="string_nocase" select="no" />

</cfgrid>



<cffunction name="editData" access="remote">

                <cfargument name="gridaction" required="yes">

                <cfargument name="gridrow" required="yes" type="Struct">

                <cfargument name="gridchanged" required="yes" type="Struct">

                 

        </cffunction>

The problem is that in edit mode I get an error thrown so the grid
doesn't display at all. I am wondering if I have a problem with:

onchange="cfc:qry_GetUser.editData({cfgridaction},{cfgridrow},{cfgridchanged})


Right now the editData function does nothing it is empty yet an error is still being thrown. I haven't been able to figure out where the error is being thrown. I have added catch/try blocks around the cfgrid as well as in the editData function but nothing is caught. ]]> ColdFusion akraus http://www.daniweb.com/forums/thread222254.html <![CDATA[Simultaneous Data Update - "Record Locking"]]> http://www.daniweb.com/forums/thread222249.html Fri, 11 Sep 2009 13:44:44 GMT What is the best way to update a record when 2 users of my site happen to edit it simultaneously?

For example, assume the following scenario:
Let's say users John Doe and Jane Doe log into my site and happen to view the below record simultaneously.
---------------------------------------------------------------------------------
Bruce Wayne | Gotham City | (910)000-0000
---------------------------------------------------------------------------------
If John edits the above phone number to (910)000-0001 and Jane changes it to (910)000-0002 - at the same time - what value do I update the DB with?

How do I prevent users overwriting each others' updates? Is something like <cflock> useful in this case or is it purely an SQL thing?

Thanks! ]]> ColdFusion SQL_n00b http://www.daniweb.com/forums/thread222249.html Ajax Issue http://www.daniweb.com/forums/thread221979.html Thu, 10 Sep 2009 10:12:00 GMT ]]> Does anyone know if there its possible to use a cfform within a cflayout, using type="tab"? I'd like to use the ajax calendar for a date input within the cflayoutarea but it doesn't seem to work.

Thanks
Avi Reiter
<FAKE SIGNATURE> ]]> ColdFusion avi-reiter http://www.daniweb.com/forums/thread221979.html CFQUERY http://www.daniweb.com/forums/thread221930.html Thu, 10 Sep 2009 07:06:00 GMT hi all, I am new to cold fusion please help me i am using the cfquery tag for executing a select query and getting the system name and system is from that........ But i want an extra system name and system id to add to the result of that query with out changing the data base ................. hi all,

I am new to cold fusion please help me

i am using the cfquery tag for executing a select query and getting the system name and system is from that........

But i want an extra system name and system id to add to the result of that query with out changing the data base ..............

please any one suggest me ...........IT's URGENT

Thanks in advance
Sudheer ]]> ColdFusion sudheerkeshetty http://www.daniweb.com/forums/thread221930.html Radio button problem and cfloop http://www.daniweb.com/forums/thread214944.html Sun, 30 Aug 2009 01:32:06 GMT How can I use cfloop or query my database so I can select home game and away game for multiple selections. I need to select 1 selection for home and away game but have to be able to select 1 of each. here is my output

http://67.219.102.67/wcfootball/index2.cfm

<script language="JavaScript" type="text/JavaScript">

<!--

function uncheckRadio() {

 var choice = document.form1.RadioGroup1;

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

  if ( choice[i].checked = true ) 

   choice[i].checked = false; 

 }

}

//-->





        <script language="JavaScript">

function checkRegex(object_value, regex) {

        return regex.test(object_value);

}



function validateform (f) {



if (f.Team1.checked == false && f.Team2.checked == false ) {

        alert("Please select at least one type of service you are interested in.");

        return false;

} else if (f.Team1.checked == true && f.Team2.checked == true ) {

        alert("You Must Select only Economy Buster or Lawn Treatment Please un-check one.");

        return false;

} else if (f.Team1.value == "") {

        alert("Please enter your first name.");

        return false;

} else if (f.Team2.value == "") {

        alert("Please enter your last name.");

        return false;

}

        return true;

}



function doValidateForm() {

        if (validateform(document.frmTeam)) document.frmTeam.submit();

}





</script>



<cfquery name="Get_members" datasource="#application.dsn#">

SELECT * FROM members

</cfquery>





        <table cellspacing="0" cellpadding="0" border="0" width="523">

                                        <cfoutput>

                                        <table cellspacing="0" cellpadding="0" border="0">

                                        <tr>Name<br></td>

                                                <td class="infoBoxShaded">#get_members.first_name# #get_members.last_name#</td>

                    </tr>

                    <tr>

                                                <td class="infoBoxShaded">#get_members.address# #get_members.city# #get_members.zip#</td>

                                                <td class="infoBoxShaded"><img src="images/spacer.gif" width="20" height="1" alt="" border="0"></td>

                                                <td class="infoBoxShaded"></td>

                                                <td class="infoBoxShaded" colspan="3"></td>

                                        </tr>

                                        <tr>

                                                <td class="infoBoxShaded">SCORE: #get_members.score#</td>

                                                <td class="infoBoxShaded"><br><br>#session.sessionID#</td>

                                                <td class="infoBoxShaded" colspan="5"></td>

                                        </tr>

                                        

                                        </table>

                                        </cfoutput>

</table>

<p>&nbsp;</p>



<p><strong>Week 1</strong></p>









<tr>

        

</tr>







<cfform action="getEstimate_step2.cfm" method="post" name="frmWon">

<input type="Hidden" name="action" value="continue">

<table border="0" cellpadding="1" cellspacing="0" bordercolor="#000000" width="45%">

<tr>

    <td><div class="content_black">Game</div></td>

    <td><div class="content_black">Week</div></td>

        <td><div class="content_black">Home Team</div></td>

        <td><div class="content_black">Away</div></td>



               <cfquery name="Picks" datasource="#application.dsn#">

                SELECT distinct Games.game, games.week, games.home_team, games.away_team FROM Games

                where games.week = '1'

                



               </cfquery>

        

</tr>

<cfloop query="Picks">

<cfoutput>

<tr>

        <td><div class="content_black">Game #Game#&nbsp;</td>

        <td><div class="content_black">Week #Week#&nbsp;</td>

        <td><div class="content_black"><cfinput type="radio" name="mainloop" value="1" required="yes" message="Please select the right option">#Home_team#&nbsp;</td>

        <td><div class="content_black"><cfinput type="radio" name="mainloop" value="0" required="yes" message="Please select the right option">#Away_team#&nbsp;</td>

   

</tr>

</cfoutput>

</cfloop>

<INPUT type="submit" name="mysubmit" value="Submit">

</cfform>

</table>
]]> ColdFusion freshfitz http://www.daniweb.com/forums/thread214944.html News Story Sony Tries New Tactics to Gain eBook Marketshare http://www.daniweb.com/news/story220770.html Thu, 27 Aug 2009 15:33:54 GMT You have to give Sony credit, they are really trying new strategies to wrestle eBook marketshare from the Amazon Kindle. This month they announced several new editions (http://news.sel.sony.com/en/press_room/consumer/computer_peripheral/e_book/release/41492.html)of the Sony Reader, including the... You have to give Sony credit, they are really trying new strategies to wrestle eBook marketshare from the Amazon Kindle. This month they announced several new editions of the Sony Reader, including the brand new Reader Daily Edition, which should be in stores in time for the holiday shopping season. This comes on the heels of their recent announcement to support the open ePub ebook standard I wrote about last week in my post, Could Sony Open eBook Decision Pressure Amazon. I'm still not sure either Sony (or Amazon) has lowered the price on these units enough to give them mass appeal, but you have to like the effort.

Reader Daily Edition

The Reader Daily Edition finally gives Sony customers a wireless choice. I could never understand why Sony would require you to tether your Reader to get your eBooks . It's 2009 and consumers want to be able to get their books quickly and easily, and this version of the Reader provides that with wireless access on AT&T’s 3G mobile broadband network. This gives users access to Sony’s eBook store from just about anywhere in the U.S that is covered by AT&T's wireless network, but this new unit comes with a hefty price tag of $399.

The other two units announced this month, the Pocket Reader at $199 and the more feature-rich Touch for $299 give consumers cheaper options, but my take is that all units should be wireless at this point. If it's not dead simple, I'm not convinced Sony can build mass appeal with a minimum $200 investment in this economy.

The Price is Almost Right

Sony is bragging about the $199 price tag, and while it's a decent price, I don't think it's low enough. If Sony (or Amazon for that matter) really wants to capture market share, they need to use the cell phone model. Sell the unit for $99 or less with a two year agreement to buy X number of books. It will be like the Book of the Month club, except eBook owners will have to purchase a certain number of books over the two year period. To ensure they do, they could even charge users a fixed monthly fee, which could consumers could put towards a certain number of books.

Changing Markets

Forrester analyst Sarah Rotman Epps reported in a July post on the Forrester Consumer Products Professional Blog, that Amazon might have captured the early market due to what she calls "a perfect storm of demographics." These were people who liked technology, had commutes or traveled extensively, and most importantly could afford the device. Future users, she says, will be very different:

"They're more likely to be female, less tech optimistic, and they read a lot (on average, 5 books per month) but they buy and borrow books from multiple sources, as opposed to buying lots of books online."

Seize the Day

Epps believes the opportunity is there to grab marketshare from Amazon. You might recall in another time with another device, that Sony once controlled the portable music market with a little unit called the Sony Walkman, but the market changed and Sony lost control of it. Perhaps Sony could be the company to turn the table this time, but if not them, assuming Epps is right, another company could, with the right combination of ease of use and price point. Although Sony is getting closer, I don't think they are quite there yet. ]]> ColdFusion Techwriter10 http://www.daniweb.com/forums/thread220770.html XSS and SQL Injection http://www.daniweb.com/forums/thread214411.html Thu, 27 Aug 2009 14:20:08 GMT Does anyone here have experience using the Acunetix Web Vulnerability Scanner? I happened to use it on my site to check for vulnerabilities and found about 15 HIGH level ones - all of them with basically the same problem: *Cross Site Scripting* and *Cross Site Scripting in URI*. For every input... Does anyone here have experience using the Acunetix Web Vulnerability Scanner? I happened to use it on my site to check for vulnerabilities and found about 15 HIGH level ones - all of them with basically the same problem: Cross Site Scripting and Cross Site Scripting in URI.

For every input on all of my pages, I use the <cfqueryparam> tag. Numbers are meant to be entered in most of the textfields on the site. Therefore, in addition to the 
<cfqueryparam cfsqltype = cf_sql_float>
I also set a maxlength for every text field - usually about 9 characters. Text inputs where 'VARCHAR' type data is expected are also validated on the server side (in addition to the cfqueryparam tag).

Am I still vulnerable to XSS and SQL Injection? Do I need to filter meta-characters? ]]> ColdFusion cheapterp http://www.daniweb.com/forums/thread214411.html