Coldfusion + MVC Framework
Hi All, I am trying to devlop website using MachII Framework. Can any one have any suggestions for me. Thanks in Advance, Priya ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324014 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion + MVC Framework
forgot to mention.. I am trying todevelop in Mach II Framework Hi All, I am trying to devlop website using MachII Framework. Can any one have any suggestions for me. Thanks in Advance, Priya ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324015 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion + MVC Framework
Thanks all.. May be I should try with the google forum. Priya I would suggest reading the documentation :oD http://www.mach-ii.com/ Mark On Sun, Jun 28, 2009 at 11:42 AM, Gerald Guido gerald.gu...@gmail.comwrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324018 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: redirect page
I tried but it dont know ... wats wrong .. I am sing coldfusion8. On Fri, May 22, 2009 at 4:37 PM, Ryan Letulle bayous...@gmail.com wrote: Hmmm, try cfheader instead of cflocation. Did you say which version of cf u r using? -- Ryan On Fri, May 22, 2009 at 1:17 PM, Pranathi Reddy rk.prana...@gmail.com wrote: /inetpub/project1/application.cfc /inetpub/project1/index.cfm /inetpub/project1/Extradirectory/newfile.cfm Moving from newfile.cfm to index.cfm where is ur application.cfm? -- Ryan On Fri, May 22, 2009 at 12:54 PM, Pranathi Reddy rk.prana...@gmail.com wrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322752 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
reading Querytable Data from struct
Hi All, I am consuming a .net webservice where I am converting dataset. I get the response back with query table in a struct. Generally when we read a query and the return type is query .. but here I have a query table in struct. How do I read the data from the response querytable in struct. Thanks, Priya ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfform
I have a quick question. I have a required radio button in the form with the cfoutput group up with the query: cfform cfoutput Query=Qry1 group=EmpName cfinput type=radio name=Prod1 value=#ID# required=true message=You need to select option/#EmpName# /cfoutput cfinput type=submit name=btn_Previous value=Previousnbsp;nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;nbsp;cfinput type=submit name=btn_Submit value=Continue/td/tr /cfform cfif Isdefined(form.btn_Submit) cflocation url =addinfo.cfm addtoken=no /cfif cfif isdefined(form.btn_Previous) cflocation url=index.cfm /cfif I have the Previous button on that page and the continue button. If I click on the previous button it shows the alert message to select option. Is there anyways we can do that if we hit the previous button , it should not show alert even if we dont select the option and if we hit the continue button it should show an alert if option not selected. Thanks, Priya ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322505 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfform
Thanks for your response but if I use button it is not going to the previous page. Priya. Your previous button is a submit button - it's submitting the form so running the validation code. You need to use a button instead. I have a quick question. I have a required radio button in the form with the cfoutput group up with the query: cfform cfoutput Query=Qry1 group=EmpName cfinput type=radio name=Prod1 value=#ID# required=true message=You need to select option/#EmpName# /cfoutput cfinput type=submit name=btn_Previous value=Previousnbsp;nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;nbsp;cfinput type=submit name=btn_Submit value=Continue/td/tr /cfform cfif Isdefined(form.btn_Submit) cflocation url =addinfo.cfm addtoken=no /cfif cfif isdefined(form.btn_Previous) cflocation url=index.cfm /cfif I have the Previous button on that page and the continue button. If I click on the previous button it shows the alert message to select option. Is there anyways we can do that if we hit the previous button , it should not show alert even if we dont select the option and if we hit the continue button it should show an alert if option not selected. Thanks, Priya ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322510 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfform
sorry.. I was thinking something else... I got it by using Button... Thanks, Priya Thanks for your response but if I use button it is not going to the previous page. Priya. Priya ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322515 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare Strings
Hi Charlie, This post is like long time ago .. but I also have a similar problem for comparision. Let me usse the same example: String1: 0010as1 String2: 10as1 .. this was solved using rereplace() but what if I actually need something like this. String1: 10as1 String1: 10as1121abc or 10as1abc or 10as1121 should be equal or String1: abc201 String1: abc20101 or abc201abc or abc20101dc or abc201dc01 should be equal It means that the string1 charecters should exactly match with String2 but string2 can have equal or more charecters than string1. Thanks in Advance, Priya I'm still learning regex, so i'm less concerned with inefficient and more concerned with holy crap it worked :) I had the + in place of the * initially, but read something that made me think the * would be better in that case. I probably misunderstood (and don't recall what it was specifically, as I read it late last night and I'm typing this early the next morning), but I think I get what you're saying. The + matches 1 or more, whereas the * matches zero or more... so with the asterisk the engine always hits the beginning and end (even in the case of zero zeros). Thanks. Just woke up and learned something. I can go back to bed :) -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare Strings
O yes.. I didnt even thought of it . Thanx Justin. Priya. String1: abc201 String1: abc20101 or abc201abc or abc20101dc or abc201dc01 should be equal cfif string1 is left(string2, len(string1)) they are equal /cfif -Justin ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322280 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Unable to dump checkbox Values
Hi All, I have a checkbox in the cfoutput query and wanna record the values of the checkbox and perform of delete using function. I am unable to dump the checkbox values in it.I believe I am doing someting wrong in the loop..Can anyone help me out with it. cfset count=1 cfoutput query='Qry_getInfo' table tr tdcfinput type=checkbox value=#getData.Name# name=chk_deletePage#count#/td cfparam default= name=form.chk_deletePage#count# td#getData.Address#/td /tr trcfinput type='submit'name='Submit'/tr /table cfif isDefined('form.Submit') cfloop from=1 to=#count# index=i cfif chk_deletePage#count# neq '' cfdump var='#form.chk_deletePage#i##' /cfif /cfloop /cfif what is that I am doing wrong Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322018 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to dump checkbox Values
Please correct this... not 'count' but 'i' cfif chk_deletePage#i# neq '' Hi All, I have a checkbox in the cfoutput query and wanna record the values of the checkbox and perform of delete using function. I am unable to dump the checkbox values in it.I believe I am doing someting wrong in the loop..Can anyone help me out with it. cfset count=1 cfoutput query='Qry_getInfo' table tr tdcfinput type=checkbox value=#getData.Name# name=chk_deletePage#count#/td cfparam default= name=form.chk_deletePage#count# td#getData.Address#/td /tr trcfinput type='submit'name='Submit'/tr /table cfif isDefined('form.Submit') cfloop from=1 to=#count# index=i cfif chk_deletePage#count# neq '' cfdump var='#form.chk_deletePage#i##' /cfif /cfloop /cfif what is that I am doing wrong Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322019 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to dump checkbox Values
Yes..it throghing an error at cfdump.. and its still throught an error right there..at cfdump var=#FORM['chk_deletePage' count']# at form You don't say what's wrong, but from these lines: cfif chk_deletePage#count# neq '' cfdump var='#form.chk_deletePage#i##' /cfif I'm guessing it's throwing an error? cfif FORM[chk_deletePage#count#] neq '' cfdump var=#FORM['chk_deletePage' count']# /cfif Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322028 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to dump checkbox Values
sorry Adrian.. I got it now... Really thanx for your quick response... Priya. You don't say what's wrong, but from these lines: cfif chk_deletePage#count# neq '' cfdump var='#form.chk_deletePage#i##' /cfif I'm guessing it's throwing an error? cfif FORM[chk_deletePage#count#] neq '' cfdump var=#FORM['chk_deletePage' count']# /cfif Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322032 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OnRequest and session timeout
how can I redirect to the homepage once the page is timedout using function in application.cfc and also wanna know how to make a page timeout comparing the present time and the session set time. Thanks a lot for help, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321820 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OnRequest and session timeout
It is a session timeout set in application.cfc. I set the session time out as cfset this.sessiontimeout=#createtimespan(0,0,20,0)# I tried using something like this.. but it is poping up with some error for redirecting a page to home page. cffunction name=OnRequest access=public returntype=void output=true cfargument name=Page type=string required=true / cfif NOT(Arguments.Page IS onSessionEnd) OR (Arguments.Page IS onApplicationEnd) cfinclude template=Arguments.Page / cfelse cfinclude template=index.cfm / /cfif cfreturn / /cffunction Priya, I am not sure what you mean when you say a page has timedout? Do you mean that ColdFusion has thrown a timeout error? -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321823 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OnRequest and session timeout
Ben, Ok, so how do I really redirect the page to home page then... My guessing was wrong it doesnt take the session or application end.. Thanks, Priya, The page value that is send to the OnRequest() method will never be onSessionEnd or onApplicationEnd. I think you are getting confused in how the Application.cfc works. Those two methods (onSessionEnd() and onApplicationEnd()) are executed outside of any page request (they are called directly by the ColdFusion application server). In fact, if a page request ever triggered those, it would be impossible as the very existence of a page request would negate the need for session or application timeout (since these are events fired due to inactivity). I think you need to read up a bit on Application.cfc. Try taking a look at this: http://www.bennadel. com/blog /726-ColdFusion-Application-cfc-Tutorial-And-Application-cfc-Reference. htm Cheers. -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321827 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
autosuggest issue
Hi, Sample code before I say anything about the issue.. cfform Name:cfinput type=textname=lookup autosuggest=cfc:cfcName.getEMPID({cfautosuggestvalue}) br / Department: cfselect name=userID id=userID bind=cfc:cfcName.getName({lookup}) display=userID value=userID bindOnLoad=false / /cfform cfc code.. cfcomponent !---function to retun dept based on user name--- cffunction name=getName access=remote output=false returntype=query cfargument name=route_num cfquery name=get_bnk_name datasource=cfdocexamples SELECT emp_id as UserID FROM Employees where UCase(FirstName) =Ucase('#ARGUMENTS.route_num#') /cfquery cfreturn get_bnk_name /cffunction !---function to retun emp name based on entered letter--- cffunction name=getEMPID access=remote output=false returntype=string cfargument name=route_num cfquery name=get_bnk_name datasource=cfdocexamples SELECT FirstName,emp_id FROM Employees where UCase(FirstName) LIKE Ucase('%#ARGUMENTS.route_num#%') /cfquery cfreturn ValueList(getEMPID.FirstName) /cffunction I am using autosugest to display the data in the text field. as started keying the id and once the id selected..I get name back in the select statement sucessfully. I am done with it But my concern is when I key in the id I should get the dropdownlist in this format id-firstname. ex: if id is 1 and the repective employer name is daniel then the autosugest dropdown shoud show 1-Daniel. I tried using something like this: cffunction name=getEMPID access=remote output=false returntype=string cfargument name=route_num cfquery name=get_bnk_name datasource=cfdocexamples SELECT FirstName,emp_id FROM Employees where UCase(FirstName) LIKE Ucase('%#ARGUMENTS.route_num#%') /cfquery cfset arrayName = listtoarray(ValueList(getEMPID.FirstName)) cfset arrayemp_id = ListtoArray(ValueList(getEMPID.emp_id)) cfset bankname=arraynew(1) cfset empName[i] = listtoarray(arrayName[i] '-' arrayemp_id[i]) cfreturn empName /cffunction I would really appreciate with any suggestion. Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321655 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Client Variables to Session Variables
Hi All, I am trying to merge three textfield values (month,day and year for DOB)into one and trying to store in a session. Javascript is a client side variable and I am unable to store it to session variable . Can anyone help me with this? See below is the code I am trying to do and I also used hidden fields to display the date but it could not work. script language=javascript function datecheck() { if(document.form1.name1.value!='' document.form1.name2.value!='' document.form1.name3.value!='') { var dd= document.form1.name1.value; var mm = document.form1.name2.value; var = document.form1.name3.value; var dat = (mm+'/'+dd+'/'+); document.getElementById(id_name).setAttribute(value,dat); !--- alert(dat); --- } } !--- function autotab(original,destination) { if (original.getAttribute original.value.length==original.getAttribute(maxlength)) destination.focus() ; } --- cfform name=form1 input name=name1 value= type=text maxlength=2/nbsp;nbsp; input name=name2 value= type=text maxlength=2/nbsp;nbsp; input name=name3 value= type=text id=name3 maxlength=4 onBlur=datecheck() input type=hidden name=name3 id=id_name value= cfinput name=Submit value=Submit type=Submit /cfform cfif isDefined('form.Submit') cfset str=#form.name3# cfdump var=#str# /cfif Thanks in Advance ... Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLOOP with Stored Procedure
I have a query and looping the results of a query. I want to display the names from the cfdocexamples when the user enters the first letters of their Names. I am using Ajax here...and the query is cffunction name=getName access=remote output=false returntype=query cffunction name=getEMPID access=remote output=false returntype=array cfargument name=Name_First cfquery name=get_bnk_name datasource=cfdocexamples SELECT FirstName FROM Employees where UCase(FirstName) LIKE Ucase('%#ARGUMENTS.Name_First#%') /cfquery !--- Build result array --- cfset result=ArrayNew(1) cfloop query=get_bnk_name cfset ArrayAppend(result, FirstName) /cfloop cfreturn result /cffunction And now I wrote a stored procedure for this query and when I execute the same code I am getting an error at the cfloop and the code is .. cffunction name=getEMPID access=remote output=false returntype=array cfargument name=Name_First cfstoredproc procedure=GetNameList datasource=cfdocexamples cfprocparam cfsqltype=CF_SQL_VARCHAR value='%#ARGUMENTS.Name_First#%' type=in cfprocresult name=FirstName /cfstoredproc /cffunction !--- Build result array --- cfset result=ArrayNew(1) cfloop query=GetNameList cfset ArrayAppend(result,FirstName) /cfloop cfreturn result What do I need to use at the place of query in cfloop .. I am using stored Procedure name ...? Is it not right. Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Highlight Form Elements
Thanks, Karan. On Sun, Mar 22, 2009 at 11:43 PM, Karan Joshi joshi.ka...@gmail.com wrote: 1) Use a structure to store validation results. 2) Pass this struct back to firstpage incase there are errors 3) Write a css style for highlight say .error {color: red;} 3) Use conditional statement in your html tags to fire this class if the error structure exists. Eg. Text1: input type=text name=txt1 cfif StructKeyExist(REQUEST, stErrors)class = error/cfifbr / Chrz Hi All, I have to validate the form fields form and validation of form fields are in two different pages and it suppose to be like this. I cannot merge it into two pages ... I am validating the form fields and sending the error message back to firstpage.cfm. I can sucessfully display the error message at the top of the form but unable to highight the error fields in it. firstpage.cfm html body cfif isdefined(url.invalidfield) and url.invalidfield neq Following fields are incorrect: ul cfloop index=i list=#invalidfield# delimiters=, cfoutput li#i#/li /cfoutput /cfloop /ul /cfif form name=f1 method=post action=secondpage.cfm Text1: input type=text name=txt1 /br / Text2: input type=text name=txt2 /br / Text3: input type=text name=txt3 /br / input type=submit / /form /body /html !--- here is the webservice response so just using some condition here --- Secondpage.cfm html body cfif form.txt1 neq Text1 cfset lstinvalidfileds = ListAppend(lstinvalidfileds, Error in txt1) /cfif cfif form.txt2 neq Text2 cfset lstinvalidfileds = ListAppend(lstinvalidfileds, Error in txt2) /cfif cfif form.txt3 neq Text3 cfset lstinvalidfileds = ListAppend(lstinvalidfileds, Error in txt3) /cfif cfoutput#ListLen(lstinvalidfileds)#/cfoutput cfif ListLen(lstinvalidfileds) gt 0 cflocation url=firstpage.cfm?invalidfield=#lstinvalidfileds# cfelse cflocation url = thirdpage.cfm /cfif /body /html Can anyone help me out with this ...? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320825 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Highlight Form Elements
Hi All, I have to validate the form fields form and validation of form fields are in two different pages and it suppose to be like this. I cannot merge it into two pages ... I am validating the form fields and sending the error message back to firstpage.cfm. I can sucessfully display the error message at the top of the form but unable to highight the error fields in it. firstpage.cfm html body cfif isdefined(url.invalidfield) and url.invalidfield neq Following fields are incorrect: ul cfloop index=i list=#invalidfield# delimiters=, cfoutput li#i#/li /cfoutput /cfloop /ul /cfif form name=f1 method=post action=secondpage.cfm Text1: input type=text name=txt1 /br / Text2: input type=text name=txt2 /br / Text3: input type=text name=txt3 /br / input type=submit / /form /body /html !--- here is the webservice response so just using some condition here --- Secondpage.cfm html body cfif form.txt1 neq Text1 cfset lstinvalidfileds = ListAppend(lstinvalidfileds, Error in txt1) /cfif cfif form.txt2 neq Text2 cfset lstinvalidfileds = ListAppend(lstinvalidfileds, Error in txt2) /cfif cfif form.txt3 neq Text3 cfset lstinvalidfileds = ListAppend(lstinvalidfileds, Error in txt3) /cfif cfoutput#ListLen(lstinvalidfileds)#/cfoutput cfif ListLen(lstinvalidfileds) gt 0 cflocation url=firstpage.cfm?invalidfield=#lstinvalidfileds# cfelse cflocation url = thirdpage.cfm /cfif /body /html Can anyone help me out with this ...? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DropDown List
I have 2 dropdown and in one I use cfquery and in other I dont... I am working on Dropdown List and was just wondering how to make the dropdown list selected data preserved. cfform prevervedata=yes works for other Formfields but not the drowpdown list? Does your select menu use cfquery data? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Append Arrays with Structures
I am trying to add my Pagelist to the array .. using structure. I am using structure to add everytime pagelist to an array so that I can display my list of pages updated or inserted on every user session. This is wat I am using... cfparam name=session.pageList default=arrayNew() !--- Append a new element to the array. This element is a new structure. --- cfset session.pageList = arrayAppend( session.pageList, structNew() ) !--- Set up a variable to hold the array position that we're inserting into. --- cfset NumberPage = arraylen(session.PageList) !--- Populate the new structure with the item information passed from the form. --- cfset session.cart[NumberPage].PageListInfo = session.page cfloop index=NumberPage from=1 to=#arraylen(sesson.item)# cfset session.item[NumberPage].PageListInfo = session.page /cfloop I get an error: Object of type class java.lang.String cannot be used as an array Can anyone Help with this Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DropDown List
I have the list of data.. say Once user selects I need to preserve that data on page tdselect name = Select_ID id= Default_ID message=Please select the option option value = Select Option.../option option value =David 1234/option option value =Ria 1221/option option value =Kevin 1001/option option value =Jeff 2002/option option value =Hendry 2030/option /select /td and if I use with the cfquery: select name = List_Designations id= Designation_ID message=Please select the option option value = Select Option.../option cfoutput group=Designation query=ReturnDesignations option value=#ReturnDesignations.Designation##ReturnContentData.Title# /option /cfoutput /select These are the two dropdown list I have... On Wed, Mar 11, 2009 at 7:50 AM, Azadi Saryev az...@sabai-dee.com wrote: what do you use in the other one you do not use cfquery in? a cfc binding? something else? which of your select lists do you want to preserve data in? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: I have 2 dropdown and in one I use cfquery and in other I dont... I am working on Dropdown List and was just wondering how to make the dropdown list selected data preserved. cfform prevervedata=yes works for other Formfields but not the drowpdown list ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Append Arrays with Structures
I am getting an error here: *session.pageList = arrayAppend( session.pageList, structNew() ) * Error: Object of type class java.lang.Boolean cannot be used as an array On Wed, Mar 11, 2009 at 9:55 AM, Jason Fisher ja...@wanax.com wrote: You're setting the value of session.pageList to the string arrayNew(), which is throwing your error. If you're using cfparam then you need the # signs and to create an array you need to specify the number of dimensions (in this case 1): cfparam name=session.pageList default=#arrayNew(1)# / If this is not in a loop or something, you could just set directly: cfset session.pageList = arrayNew(1) / ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Append Arrays with Structures
Jason, cfparam name=session.pageList default= arrayNew(1) cfparam name=session.pageList default=#arrayNew(1)# cfparam name=session.pageList default=#arrayNew(1)# cfparam name=session.pageList default=arrayNew(1) cfparam name=session.pageList default=#arrayNew(1)# nothing works I tried with : On Wed, Mar 11, 2009 at 9:16 AM, Ian Skinner h...@ilsweb.com wrote: Jason Fisher wrote: If you're using cfparam then you need the # signs Or get rid of the quotes. cfparam name=session.pageList default=#arrayNew(1)# / I.E. This also works. cfparam name=session.pageList default = arrayNew(1) / !--- note the lack of quotes in the default parameter --- ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320365 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DropDown List
I have submit buttons like Update_submit and Insert_Submit on (select_details.cfm). When I click these buttons it will redirect to next page (updates.cfm) and I have a Home_Submit in the updates.cfm which will redirect to the homepage(select_details.cfm) where we select the dropdown option. Thanks, On Wed, Mar 11, 2009 at 9:37 AM, Azadi Saryev az...@sabai-dee.com wrote: when exactly ( after which condition in your app logic) do u need to display previously entered data? on form submit? on clicking back button in the browser? which condition should trigger the display of rev entered data as opposed to dislaying a blank form? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: I have the list of data.. say Once user selects I need to preserve that data on page tdselect name = Select_ID id= Default_ID message=Please select the option option value = Select Option.../option option value =David 1234/option option value =Ria 1221/option option value =Kevin 1001/option option value =Jeff 2002/option option value =Hendry 2030/option /select /td and if I use with the cfquery: select name = List_Designations id= Designation_ID message=Please select the option option value = Select Option.../option cfoutput group=Designation query=ReturnDesignations option value=#ReturnDesignations.Designation##ReturnContentData.Title# /option /cfoutput /select These are the two dropdown list I have... On Wed, Mar 11, 2009 at 7:50 AM, Azadi Saryev az...@sabai-dee.com wrote: what do you use in the other one you do not use cfquery in? a cfc binding? something else? which of your select lists do you want to preserve data in? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: I have 2 dropdown and in one I use cfquery and in other I dont... I am working on Dropdown List and was just wondering how to make the dropdown list selected data preserved. cfform prevervedata=yes works for other Formfields but not the drowpdown list ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320369 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DropDown List
No Dave it doesnt.. preserve the selected ones... going back to Select option., On Wed, Mar 11, 2009 at 9:35 AM, Dave Watts dwa...@figleaf.com wrote: tdselect name = Select_ID id= Default_ID message=Please select the option You need to use CFSELECT within CFFORM to preserve the selected values. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320370 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DropDown List
ok.. Even if I use the cfif isDefined('form.submit') ... code in the same page then also I dont preserve the data but I can preserve the other field data... On Wed, Mar 11, 2009 at 10:05 AM, Dave Watts dwa...@figleaf.com wrote: No Dave it doesnt.. preserve the selected ones... going back to Select option., To use CFFORM's PRESERVEDATA functionality, you need to POST from your CFFORM to a page which has the same CFFORM on it. You can't POST to another page, then redirect back to the form. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Append Arrays with Structures
Is this right? cfset myarray = arrayNew(1) cfset session.pageList = arrayAppend( myarray, structNew() ) cfset NumberPage = arraylen(session.PageList) for finding out he arraylen?? because this is where it is giving me the error.. On Wed, Mar 11, 2009 at 10:21 AM, Adrian Lynch cont...@adrianlynch.co.ukwrote: Out of interest, I wonder what would have to happen for ArrayAppend to return false?! Adrian -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: 11 March 2009 12:37 To: cf-talk Subject: Re: Append Arrays with Structures ArrayAppend does not return the array - it returns True, on successful completion. (http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/ html/wwhelp.htm?context=ColdFusion_Documentationfile=0381.htm) So: cfparam name=session.pageList default=#arrayNew(1)# / cfset arrayAppend( session.pageList, structNew() ) / ... etc. Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320375 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
DropDown List
I am working on Dropdown List and was just wondering how to make the dropdown list selected data preserved. cfform prevervedata=yes works for other Formfields but not the drowpdown list? Any ideas?? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320343 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare FieldValues with DataBase Values
I appologise if I really confused you and I am still learning the Coldfusion and I am unable to code in a proper way. These are my ColdFuion Fields in the Coldfusion page: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Sql Database Tables: Table1: Employer FirstName, LastName,Address,PhoneNumber, EmployerID (Primary Key) Daniel RayNJ 123-123-2123 1234 Ria ParksNj 124-123-1234 1221 EmloyerID is the Primary key. Table2: Department DepartmentID , DepartmentName, EmployerID, Branch, SNO(Unique Identifier) 12 Economics 1234NJ 111 13 Physics1234NJ 121 12 Economics 1221PA 123 EmployerID can be repeated but not SNO should be unique. I need to do two things. 1. Depending on the entry of the formfield values. The database tables should be either inserted or updated. If the row already exsist then the row should be inserted and if exsist row should be updated. eg: I need to add the Chemistry DepartmentNAme to the EmployerID 1234. I need to check before the insert statement whether or not the data in the table. How do I really check this. 2. Once the action takes place either update or delete, I need to display the list of the action taken place in the user session on the coldfusion page. Session is just the user session here. eg: DepartmentName for 1234 is insesrted Salary for 1221 has been updated . . . Hope I am very clear now... Thanks, Priya I have an issue and I am out of my mind.. to solve it. FieldNames: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Ok, what about these field names? Can you explain for us please? Are these columns in a table? Columns in a result set? Do you realize you have EmployerID in there twice?? Table Employee FirstName, LastName,Address,PhoneNumber, EmployerID Is EmployerID the primary key or a foreign key? I would have expected it to be called EmployeeID if it were the primary key, since an employer employs the employee. Table Department DepartmentID , DepartmentName, EmployerID, Branch I have a FirstName attribute in the table and I want to compare these attribute (FirstName) with the fieldvalue. What field value?? Is this in a ColdFusion page or a SQL statement? Where is the fieldvalue coming from? A form? The Url? In what way do you want to compare? Do you want to compare a single record, or more than one? ? I thought of using arrays but I don't know how to add database date to the array and compare. What is a database date? None of the columns you have mentioned so far seem to have anything to do with dates. Setting a date into an array is easy as cfset myArray = [now()] but I'm not sure where you are going with this. I also have one more issue. I am trying to insert data into the database and once the data is inserted the inserted (FirstName) should be displayed (Primary Key is EmployerID). What table is this? The employee table? If EmployerID is the primary key of the Employee table, why is that column also in the Department table? If two people are in the same department, do you have two department records with the same department name, but different EmployerIds? I'm quite confused. If I add n number of FirstNames in the table in the session then it should display those many New entry values in the main page. How can we do it? Is the table in session, or do you simply mean inserts into the database during a user's session? So you want to have a screen that shows someone the records they entered since their session started? You could store the data in a session variable, or store the primary key of the records they inserted. I'm not sure where you are headed, but this would also be possible if you had a userIDModified in the table and a datetimeCreated column. You could simply query out the records that user had inserted since the time their session started. Can anyone help me with this? Probably, but we need a bit more direction on what it is you are doing. I'm pretty bad at guessing. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare FieldValues with DataBase Values
Yes, I can use select statement but I am able to display only the latest taction taken to the coldfusion page but not all the list of actions taken in a user session. On Mon, Mar 9, 2009 at 9:40 AM, Azadi Saryev az...@sabai-dee.com wrote: one sure-fire way to check if the data exists in a table is to run a SELECT query to select that data. then check the recordcount of the select query - if it is 0 then no such data exists; otherwise the data is already there. depending on your db and exact requirements you may be able to use db-specific ways to do it. i.e. MySQL has a ON DUPLICATE KEY UPDATE clause one can use in an INSERT query which will update rows instead of inserting new rows if specified PK value already exists in a table. but since you seem to need to notify user of exact action taken (insert or update) that may not be useful in your case... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: I appologise if I really confused you and I am still learning the Coldfusion and I am unable to code in a proper way. These are my ColdFuion Fields in the Coldfusion page: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Sql Database Tables: Table1: Employer FirstName, LastName,Address,PhoneNumber, EmployerID (Primary Key) Daniel RayNJ 123-123-2123 1234 Ria ParksNj 124-123-1234 1221 EmloyerID is the Primary key. Table2: Department DepartmentID , DepartmentName, EmployerID, Branch, SNO(Unique Identifier) 12 Economics 1234NJ 111 13 Physics1234NJ 121 12 Economics 1221PA 123 EmployerID can be repeated but not SNO should be unique. I need to do two things. 1. Depending on the entry of the formfield values. The database tables should be either inserted or updated. If the row already exsist then the row should be inserted and if exsist row should be updated. eg: I need to add the Chemistry DepartmentNAme to the EmployerID 1234. I need to check before the insert statement whether or not the data in the table. How do I really check this. 2. Once the action takes place either update or delete, I need to display the list of the action taken place in the user session on the coldfusion page. Session is just the user session here. eg: DepartmentName for 1234 is insesrted Salary for 1221 has been updated . . . Hope I am very clear now... Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Compare FieldValues with DataBase Values
ohh yes.. Thanks a lot. On Mon, Mar 9, 2009 at 10:56 AM, Azadi Saryev az...@sabai-dee.com wrote: that's because you are probably over-writing some variable you created to hold the action with each subsequent action... use an array or structure to hold all your action, append each new action taken to this array/structure, then loop over it to display all actions taken Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: Yes, I can use select statement but I am able to display only the latest taction taken to the coldfusion page but not all the list of actions taken in a user session. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320283 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Compare FieldValues with DataBase Values
Hi All, I have an issue and I am out of my mind.. to solve it. FieldNames: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Table Employee FirstName, LastName,Address,PhoneNumber, EmployerID Table Department DepartmentID , DepartmentName, EmployerID, Branch I have a FirstName attribute in the table and I want to compare these attribute (FirstName) with the fieldvalue. I thought of using arrays but I dont know how to add database date to the array and compare. I also have one more issue. I am trying to insert data into the database and once the data is inserted the inserted (FirstName) should be displayed (Primary Key is EmployerID). If I add n number of FirstNames in the table in the session then it should display those many New entry values in the main page. How can we do it? Can anyone help me with this? Thanks in Advance... Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320248 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare FieldValues with DataBase Values
Any ideas? Hi All, I have an issue and I am out of my mind.. to solve it. FieldNames: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Table Employee FirstName, LastName,Address,PhoneNumber, EmployerID Table Department DepartmentID , DepartmentName, EmployerID, Branch I have a FirstName attribute in the table and I want to compare these attribute (FirstName) with the fieldvalue. I thought of using arrays but I dont know how to add database date to the array and compare. I also have one more issue. I am trying to insert data into the database and once the data is inserted the inserted (FirstName) should be displayed (Primary Key is EmployerID). If I add n number of FirstNames in the table in the session then it should display those many New entry values in the main page. How can we do it? Can anyone help me with this? Thanks in Advance... Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320252 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Page steps list
I am calling a procedure to compare the answers .. if (answer 4) cflocation url= page3 else cflocation url='page4' This is wat is the condition on page2. I want to write a function in the .cfc so that I really dont have to mention on each any every page. Thanks, Pranitha. On Sun, Mar 1, 2009 at 9:29 PM, Azadi Saryev az...@sabai-dee.com wrote: still not clear what exactly determines which pages are to be displayed and which one is not... can you clarify that? If we are on page1 according to the condition it is redirected to page2 or page3. what's this 'condition'??? your 'procedure' just loops over your list of 4 page names and outputs ALL of them - you just need to incorporate your 'condition' into the loop to not display the page that should not be displayed. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Pranathi Reddy wrote: Any ideas? I have 4 pages in my application Page1, Page2, page3 and page4 I am trying to do something like this (saw in some post): cfset pagelist = Page1,Page2,Page3,Page4 cfoutput table align=center cfset stepCounter = 0 cfloop list=#pagelist# index=i cfset stepCounter = stepCounter +1 cfif arguments.pagename EQ #trim(i)# cfset styleclass = HighLight cfelse cfset styleclass = NoHighlight /cfif tr td class=#styleclass# nowrapStep #stepCounter#: /tdtd class=#styleclass# nowrap#getContent('#arguments.PageID#', '#i#').title#/td /tr /cfloop /table /cfoutput I am trying to display the list of the page rendering. If we are on page1 according to the condition it is redirected to page2 or page3. The total number of steps should be only 3 and according to the procedure above it display's 4 steps. It means that it should either be on page2 or page3 and not both. Thanks, Pranathi. On Sun, Mar 1, 2009 at 5:37 PM, Rick Faircloth r...@whitestonemedia.comwrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319978 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Convert Image to Binary
Now I can sucessfully store the Binary data to thedatabase but unable to retreive it. Again it is giving me with the same error. I used cfcontent but sometimes its display and sometimes its not. Also tried sing toString,tobase64 etc but no results. Any ideas? On Thu, Feb 26, 2009 at 9:11 PM, Paul Kukiel pkuk...@gmail.com wrote: cffile action=readbinary file=/store/image.jpg variable=fileContents cfqueryparam cfsqltype=cf_sql_blob value=#fileContents# / Is all you need when the datatype is image or varbinary on MSSQL you don't need the tobase64 that will teach me for responding to fast. Thanks james You also need to check : -- Enable binary large object retrieval (BLOB). in CF admin. On Thu, Feb 26, 2009 at 9:14 PM, James Holmes james.hol...@gmail.com wrote: That would mean you're entering base64 text into a binary field. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/2/27 Paul Kukiel pkuk...@gmail.com: Managing images on disk is a better way but if you must use the data base make sure you are using cfqueryparam scfqltype=CF_SQL_BLOB vale=#toBase64(FinalMergedDisclosure)# / Which should work for you. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319904 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Convert Image to Binary
Now I can sucessfully store the Binary data to thedatabase but unable to retreive it. Again it is giving me with the same error. I used cfcontent but sometimes its display and sometimes its not. Also tried sing toString,tobase64 etc but no results. Any ideas? Agree... store image file location in database that points to the image on the server. From experience, better performance in my opinion. We had plenty of images to test it out... ;-) Managing images on disk is a better way but if you must use the data base make sure you are using cfqueryparam scfqltype=CF_SQL_BLOB vale=#toBase64(FinalMergedDisclosure)# / Which should work for you. On Thu, Feb 26, 2009 at 11:14 AM, Priya Koya priya23...@gmail.com wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319905 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Convert Image to Binary
Thanks, I can retrive the image. On Fri, Feb 27, 2009 at 10:06 AM, Paul Kukiel pkuk...@gmail.com wrote: I agree it adds extra load on the webserver and database and fills the database. Anyway here is the code to get the image back out. cfquery name=imageQuery datasource=mssql select dataFile from file where id = 1 /cfquery cfimage action=writetobrowser source=#imageQuery.dataFile# / or cffile action=write file=c:\imagefromdb.jpg output=#imageQuery.dataFile# / Paul. On Fri, Feb 27, 2009 at 10:39 AM, Jacob ja...@excaliburfilms.com wrote: Agree... store image file location in database that points to the image on the server. From experience, better performance in my opinion. We had plenty of images to test it out... ;-) -Original Message- From: Paul Kukiel [mailto:pkuk...@gmail.com] Sent: Thursday, February 26, 2009 12:15 PM To: cf-talk Subject: Re: Convert Image to Binary Managing images on disk is a better way but if you must use the data base make sure you are using cfqueryparam scfqltype=CF_SQL_BLOB vale=#toBase64(FinalMergedDisclosure)# / Which should work for you. On Thu, Feb 26, 2009 at 11:14 AM, Priya Koya priya23...@gmail.com wrote: cfset thisDir = expandPath(.) cffile action=upload fileField=image destination=#thisDir# result=fileUpload nameconflict=overwrite cfdump var=#thisDir# cfimage action=read source=#fileUpload.serverfile# name=myImage cffile action=readBinary file=#image# variable=FinalImage br/variablecfdump var=#FinalImage# !--- cfset Image_Binary = #toBinary(toBase64(FinalMergedDisclosure))# cfdump var=#Image_Binary# --- cfquery name=Query4 datasource=Platform result=result_1 update table1 set Logo='#FinalImage#' where Name='John' /cfquery I am getting an error: ByteArray objects cannot be converted to strings. I tried with tostring etc.. but didnt work Datatype for this column is varBinary(MAX). Any sugestions Thanks, Priya. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319909 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Convert Image to Binary
cfset thisDir = expandPath(.) cffile action=upload fileField=image destination=#thisDir# result=fileUpload nameconflict=overwrite cfdump var=#thisDir# cfimage action=read source=#fileUpload.serverfile# name=myImage cffile action=readBinary file=#image# variable=FinalImage br/variablecfdump var=#FinalImage# !--- cfset Image_Binary = #toBinary(toBase64(FinalMergedDisclosure))# cfdump var=#Image_Binary# --- cfquery name=Query4 datasource=Platform result=result_1 update table1 set Logo='#FinalImage#' where Name='John' /cfquery I am getting an error: ByteArray objects cannot be converted to strings. I tried with tostring etc.. but didnt work Datatype for this column is varBinary(MAX). Any sugestions Thanks, Priya. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Convert Image to Binary
Hi All, I am trying to store the image file into sql database in a binary form. I can sucessfully browse image, read it and display in the browser but unable to convert it into binary. This is wat I did cfset thisDir = expandPath(.) cffile action=upload fileField=image destination=#thisDir# result=fileUpload nameconflict=overwrite cfdump var=#thisDir# cfimage action=read source=#fileUpload.serverfile# name=myImage cffile action=readBinary file=#image# variable=FinalImage br/variablecfdump var=#FinalImage# !--- cfset Image_Binary = #toBinary(toBase64(FinalMergedDisclosure))# cfdump var=#Image_Binary# --- cfquery name=Query4 datasource=Platform result=result_1 update table1 set Logo='#FinalImage#' where Name='John' /cfquery but I am unable to save into the database and when I am trying to save it pops up say: ByteArray objects cannot be converted to strings. I tried using toString etc.. Datatype for this column is varBinary(MAX). Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: connecting to sql server datasource in CF8
Did you check with th TCP/IP enadled, port number and you should not use windows password but the database password. On Thu, Feb 26, 2009 at 9:37 PM, Mike Little m...@nzsolutions.co.nz wrote: hey guys, i have recently installed coldfusion 8. everything going sweet except creating a datasource to connnect to a remote ms sql server. i get the following... Connection verification failed for data source: xyz123 java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection this worked fine in seven. i have used the exact settings used for the existing connection. i have also made sure all relevant ports are open. any help would be appreciated. mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319889 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: connecting to sql server datasource in CF8
Try this setup: http://www.fusioncube.net/index.php/coldfusion-sql-server-express On Thu, Feb 26, 2009 at 9:37 PM, Mike Little m...@nzsolutions.co.nz wrote: hey guys, i have recently installed coldfusion 8. everything going sweet except creating a datasource to connnect to a remote ms sql server. i get the following... Connection verification failed for data source: xyz123 java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection this worked fine in seven. i have used the exact settings used for the existing connection. i have also made sure all relevant ports are open. any help would be appreciated. mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319891 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
js validation
how to pull 2 fiels from database when you enter account number in edit form which is already entered into database by other. Thanks in advance ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319791 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Error: FIle Not Found
Hi All, I am using COldFusion8 and trying to execute the file but error: File not found: /File1.cfm My project is in path: C:\Inetpub\Project_Folder\somefile.cfm I have created a .cfm page in the path: C:\Inetpub\Project_Folder\folder1\File1.cfm. Any Suggestions? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error: FIle Not Found
This is what the error I get: File not found: /FIle1.cfm Resources: - Check the ColdFusion documentationhttp://www.macromedia.com/go/proddoc_getdocto verify that you are using the correct syntax. - Search the Knowledge Basehttp://www.macromedia.com/support/coldfusion/to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729) Remote Address 127.0.0.1 ReferrerDate/Time 25-Feb-09 12:22 PM Stack Trace (click to expand)javascript:; coldfusion.runtime.TemplateNotFoundException: File not found: /EditSites.cfm at coldfusion.filter.PathFilter.invoke(PathFilter.java:89) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) On Wed, Feb 25, 2009 at 12:00 PM, Cutter (CFRelated) cold.fus...@cutterscrossing.com wrote: /File1.cfm must be located in your site root, so Project_Folder must be defined as the site root. What does the line of code say that is throwing the File not found error? It may be that the function you are calling requires a file system path. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Priya Koya wrote: Hi All, I am using COldFusion8 and trying to execute the file but error: File not found: /File1.cfm My project is in path: C:\Inetpub\Project_Folder\somefile.cfm I have created a .cfm page in the path: C:\Inetpub\Project_Folder\folder1\File1.cfm. Any Suggestions? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Count the number of times page submitted
Hi All, I need to count the number of times a page was submitted continuously with a single user. If I set a count in the page then when ever it reachs the page again it counts to ). so it doesnt work. If the page hits first time count=1 If the page hits second time count=2 . . . Times the page hits.. times the count should be Any ideas...? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319614 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Count the number of times page submitted
Thanks for your help! cfparam name=session.pagecount default=0 cfset session.pagecount = session.pagecount + 1 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319622 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
JavaScript Validation in ColdFusion
Hi all, I have an issue Have a form and have the three raio buttons and I grouped it. Need to select one option and depending on the option need to fill texboxes. I am able to select the radio button and produce the error message. I am trying to disable and enable textboxes and validate them depends on radio button selection. I am able to disable and enable texboxes but unable to validate boxes. If I select Option1 It will disable text boxes If I select option2 or option3 --- enable extboxes and validate boxes textbox1 --- should validate the length=12, should be numeric, should not be empty textbox2 --- should validate the length=10, should be numeric, should not be empty Thanks, Can anyone hel with this cfform name='form1' cfinput type=radio name=rb_deposit value= id =id_check onclick =funcone() required=yes message=Please select optionspanOption1/spanbr/ cfinput type=radio name=rb_deposit value= id =id_check1 onclick=check1()spanOption2/spanbr/ cfinput type=radio name=rb_deposit value= id =id_check2 onclick=check1()spanOption3/spanbr/ input type=text name=text1 value= id =text_id onBlur=check2() spanlabel1/spanbr/ input type=text name=text2 value= id =text_id1 onBlur=check3()spanlabel2/spanbr/ cfinput name=submit value=submit id=submit_1 type='submit'br/ /cfform script type=text/javascript function funcone(){ if(document.form1.id_check.checked) { document.form1.text_id.disabled = true; document.form1.text_id1.disabled = true; return false; } else{return true;} } function check1() { if (document.form1.text_id.disabled = true) { document.form1.text_id.disabled =false; document.form1.text_id1.disabled = false; return false; } else{return true;} } function check2() { if(document.form1.id_check1.checked || document.form1.id_check2.checked) { document.form1.text1.focus(); if(document.form1.text1.value== ||!isNaN(document.form1.text1.value)||document.form1.text1.length !='12') { alert(Please enter BankNumber); document.form1.text1.focus(); }else {return true;} } function check3() { if(document.form1.text1.value!= ||!isNaN(document.form1.text1.value)) { if(document.form1.text2.value= || isNaN(document.form1.text2.value)) { alert(Please enter Routing Number); document.form1.text2.focus(); return false; } else {return true;} } } } /script ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319588 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Looping
cfset arguments.pagename = ReplaceNoCase(trim(arguments.pagename), '/', '') cfset pagelist = page1.cfm,page2.cfm,page3.cfm,page4.cfm cfoutput table align=center cfset stepCounter = 0 cfloop list=#pagelist# index=i cfset stepCounter = stepCounter +1 cfif arguments.pagename EQ #trim(i)# cfset styleclass = StyleClass1 cfelse cfset styleclass = StyleClass2 /cfif tr td class=#styleclass# nowrapStep #stepCounter#: /tdtd class=#styleclass# nowrap#getCustomPageContent('#arguments.info#', '#i#').title#/td /tr /cfloop /table /cfoutput I have like 4 pages any trying to hightlight the active page or the present page. I am sucessful in doing so but what if I really wanted to skip page3.cfm from the table if I am not visiting it. And also wanted to stay the highlight on page2.cfm even if I visit page3.cfm i.e.. page3.cfm is my active page. Thanks, ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319405 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looping
I tried using Session but it didnt work... On Tuesday 17 Feb 2009, Priya Koya wrote: page3.cfm from the table if I am not visiting it. And also wanted to stay the highlight on page2.cfm even if I visit page3.cfm i.e.. page3.cfm is my active page. Sounds like you could just save the 'active' page name to the session scope (or as a cookie). Then you can check that in the loop and skip the 'tr' tags, or adjust the styleclass as needed. -- Tom Chiverton Helping to apprehensively market low-risk m-commerce This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells. co ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Unable to create Datasource ColdFusion8
Hi All, I am using Wista Home edition. I installed ColdFusion8, SQL Server 2005 Express Edition in my PC. I set Protocols enabled in SQL Server 2005 but still I am unable to create a datasource. Can anyone help me with this? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319305 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to create Datasource ColdFusion8
I am using SQL SERVER 2005 to create a datasource. On Sat, Feb 14, 2009 at 6:01 AM, Adrian Lynch cont...@adrianlynch.co.ukwrote: What are you using in the datasource settings in CF? Adrian -Original Message- From: Priya Koya [mailto:priya23...@gmail.com] Sent: 14 February 2009 10:28 To: cf-talk Subject: Unable to create Datasource ColdFusion8 Hi All, I am using Wista Home edition. I installed ColdFusion8, SQL Server 2005 Express Edition in my PC. I set Protocols enabled in SQL Server 2005 but still I am unable to create a datasource. Can anyone help me with this? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319310 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to create Datasource ColdFusion8
This is what the error I get when I try to create DataSource... Connection verification failed for data source: Banking java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. On Sat, Feb 14, 2009 at 6:01 AM, Adrian Lynch cont...@adrianlynch.co.ukwrote: What are you using in the datasource settings in CF? Adrian -Original Message- From: Priya Koya [mailto:priya23...@gmail.com] Sent: 14 February 2009 10:28 To: cf-talk Subject: Unable to create Datasource ColdFusion8 Hi All, I am using Wista Home edition. I installed ColdFusion8, SQL Server 2005 Express Edition in my PC. I set Protocols enabled in SQL Server 2005 but still I am unable to create a datasource. Can anyone help me with this? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to create Datasource ColdFusion8
Yes, I did.. Set tje port 1433..i tested with telnet localhost 1433 .. its connectivity is working fine On Sat, Feb 14, 2009 at 1:51 PM, TJ Downes koldfu...@gmail.com wrote: By default the SQL Server Express port is dynamic, meaning i changes. You need to use the SQL Server configuration tool to set a static port and use the port number, generally 1433, in the DSN admin interface. Have you done this? TJ Downes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319315 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to create Datasource ColdFusion8
Brad, I followed the link and now I am unable to restart service and error I get is sql server(SQLEXPRESS) service on Local Computer started and then stopped. SOme services stop automatically if they are not in use by other services or programs.http://www.uscis.gov/portal/site/uscis/menuitem.5af9bb95919f35e66f614176543f6d1a/?vgnextoid=da75d676b6b6f110VgnVCM104718190aRCRDvgnextchannel=68439c7755cb9010VgnVCM1045f3d6a1RCRD On Sat, Feb 14, 2009 at 2:00 PM, Brad Wood b...@bradwood.com wrote: Did you read any of the Google results that Mark pointed you towards? Chances are since you are using SQL Server Express, you are trying to connect on the wrong port or SQL Server is not configured for TCP connections at all. You can use netstat -a on your machine to verify what ports are being listened on. But firstly, read a few of the many blog entries out there on the topic. http://www.fusioncube.net/index.php/coldfusion-sql-server-express ~Brad - Original Message - From: Priya Koya priya23...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 14, 2009 12:47 PM Subject: Re: Unable to create Datasource ColdFusion8 This is what the error I get when I try to create DataSource... Connection verification failed for data source: Banking java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Array of textboxes in cfform
cfset val = Form.theTextBox_#curIndex# All that does is set val to a string, not the actual form value. Use this: cfset val = form[theTextBox_#curindex#] or if you prefer, this: cfset val = evaluate(form.theTextBox_#curIndex#) But if you evaluate, people with harass you. =) Rick -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319181 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Array of textboxes in cfform
May be this is what you are looking for... cfform cfloop from=1 to=10 index=curIndex cfinput type=text name=theTextBox_#curIndex# value= /br/ /cfloop cfinput type=Submit name=Submit value=Submit / /cfform cfif isDefined(form.Submit) cfloop list=#form.fieldnames# index=i br/ !--- cfoutput#Form[i]#/cfoutput --- cfset va1 = #Form[i]# cfoutput#va1#/cfoutput /cfloop /cfif cfset val = Form.theTextBox_#curIndex# All that does is set val to a string, not the actual form value. Use this: cfset val = form[theTextBox_#curindex#] or if you prefer, this: cfset val = evaluate(form.theTextBox_#curIndex#) But if you evaluate, people with harass you. =) Rick -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Array of textboxes in cfform
cfform cfloop from=1 to=10 index=curIndex cfinput type=text name=theTextBox_#curIndex# value= /br/ /cfloop cfinput type=Submit name=Submit value=Submit / /cfform cfif isDefined(form.Submit) cfloop list=#form.fieldnames# index=i br/ !--- cfoutput#Form[i]#/cfoutput --- cfset va1 = #Form[i]# cfoutput#va1#/cfoutput /cfloop /cfif On Wed, Feb 11, 2009 at 11:32 AM, Priya Koya priya23...@gmail.com wrote: cfset val = Form.theTextBox_#curIndex# All that does is set val to a string, not the actual form value. Use this: cfset val = form[theTextBox_#curindex#] or if you prefer, this: cfset val = evaluate(form.theTextBox_#curIndex#) But if you evaluate, people with harass you. =) Rick -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319185 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Grouping of Radio Button
Yes I did.. but again I am getting the field values along with the submit value.. how do I append it.. I just need the field values. cfloop list=#form.fieldnames# index=i !--- cfoutput#i#/cfoutputBR --- !--- cfoutputform.#i#/cfoutput --- cfset var1 = #Evaluate(form.i)# cfoutput#var1#/cfoutput /cfloop On Mon, Feb 9, 2009 at 12:40 AM, Azadi Saryev az...@sabai-dee.com wrote: just use name=radio#mainloop# instead of name=radio1 for your radio buttons then. that will create a separate radio group for each question: radio1, radio2, etc... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: Yes,Iknow I just wanted to give you an example soI mentioned some value in there.. actually I am takking a session variable there. So I am not worried about the value.. but worried abt the selection of a choice for each question. that is because ALL your radio buttons have same NAME - radio1 - thus you have a group of 9 radio buttons. you need to have a different NAME for each question. you will also, presumably, want a different VALUE for each of your radio button, too, so depending on which one is selected you get its value in the form scope. right now, based on your code, no matter which radio button is selected, you will get 1a as value. try something like this: cfloop index=mainloop from=1 to=3 cfoutputThis id Question#mainloop#/cfoutput cfloop index='loop1' from=1 to=3br/ cfinput type=radio name=radio#mainloop# value=#loop1# required=yes message=Please select the right option/br /cfloop /cfloop with the above code you will have radio groups named radio1, radio2 and radio3, each with possible values 1, 2 or 3. hth Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Grouping of Radio Button
ok.. but here my out put also includes the Submit field name and I dont want to display in my output... How could I do that? I just need: Va1l Val2 Val3 not the Submit field. On Mon, Feb 9, 2009 at 9:01 AM, Peter Boughton bought...@gmail.com wrote: There are very few cases when Evaluate() should be used. Don't do this: cfset var1 = #Evaluate(form.i)# cfoutput#var1#/cfoutput Do this: cfoutput#Form[i]#/cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Grouping of Radio Button
But we cannot use to or from when we use... list. On Mon, Feb 9, 2009 at 10:35 AM, Azadi Saryev az...@sabai-dee.com wrote: are you familiar with cfif...cfelse.../cfif construct? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: ok.. but here my out put also includes the Submit field name and I dont want to display in my output... How could I do that? I just need: Va1l Val2 Val3 not the Submit field. On Mon, Feb 9, 2009 at 9:01 AM, Peter Boughton bought...@gmail.com wrote: There are very few cases when Evaluate() should be used. Don't do this: cfset var1 = #Evaluate(form.i)# cfoutput#var1#/cfoutput Do this: cfoutput#Form[i]#/cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Grouping of Radio Button
How do I save these values in a variables? On Mon, Feb 9, 2009 at 12:35 PM, Azadi Saryev az...@sabai-dee.com wrote: cfoutput cfloop list=#form.fieldnames# index=field cfif left(field, 5) eq radio #field# : #form[field]#br / /cfif /cfloop /cfoutput Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: But we cannot use to or from when we use... list. On Mon, Feb 9, 2009 at 10:35 AM, Azadi Saryev az...@sabai-dee.com wrote: are you familiar with cfif...cfelse.../cfif construct? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: ok.. but here my out put also includes the Submit field name and I dont want to display in my output... How could I do that? I just need: Va1l Val2 Val3 not the Submit field. On Mon, Feb 9, 2009 at 9:01 AM, Peter Boughton bought...@gmail.com wrote: There are very few cases when Evaluate() should be used. Don't do this: cfset var1 = #Evaluate(form.i)# cfoutput#var1#/cfoutput Do this: cfoutput#Form[i]#/cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319111 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Grouping of Radio Button
This is my Code: cfform method=post cfloop index=mainloop from=1 to=3 cfoutputThis id Question#mainloop#/cfoutput cfloop index='loop1' from=1 to=3br/ cfinput type=radio name=radio1 value=1a required=yes message=Please select the right option/br /cfloop /cfloop cfinput type=Submit name=Submit value=Submit /cfform cfif isDefined(form.Submit) cfoutput#form.radio1#/cfoutput /cfif The output for this is Question and 3 choose of radio button. I need to choose one option for each of the question. but now I can choose only one option for all the questions i.e one in 9 radio button. Can any one help with this? Thanks in Advance, Koya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319060 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Grouping of Radio Button
Yes, but how could I really make the radiobutton name unique as it is in the loop. Is there any other way I can do if this is not the best approch?? Thanks, you have to make the name of the radio button unique for every question - hard coded this would give radio1 for question1, radio2 for question2 and radio3 for question3 M This is my Code: cfform method=post cfloop index=mainloop from=1 to=3 cfoutputThis id Question#mainloop#/cfoutput cfloop index='loop1' from=1 to=3br/ cfinput type=radio name=radio1 value=1a required=yes message=Please select the right option/br /cfloop /cfloop cfinput type=Submit name=Submit value=Submit /cfform cfif isDefined(form.Submit) cfoutput#form.radio1#/cfoutput /cfif The output for this is Question and 3 choose of radio button. I need to choose one option for each of the question. but now I can choose only one option for all the questions i.e one in 9 radio button. Can any one help with this? Thanks in Advance, Koya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319062 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Grouping of Radio Button
Yes,Iknow I just wanted to give you an example soI mentioned some value in there.. actually I am takking a session variable there. So I am not worried about the value.. but worried abt the selection of a choice for each question. that is because ALL your radio buttons have same NAME - radio1 - thus you have a group of 9 radio buttons. you need to have a different NAME for each question. you will also, presumably, want a different VALUE for each of your radio button, too, so depending on which one is selected you get its value in the form scope. right now, based on your code, no matter which radio button is selected, you will get 1a as value. try something like this: cfloop index=mainloop from=1 to=3 cfoutputThis id Question#mainloop#/cfoutput cfloop index='loop1' from=1 to=3br/ cfinput type=radio name=radio#mainloop# value=#loop1# required=yes message=Please select the right option/br /cfloop /cfloop with the above code you will have radio groups named radio1, radio2 and radio3, each with possible values 1, 2 or 3. hth Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Priya Koya wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319066 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Writing xml
it should have a root element. cfxml variable=GalDoc xmldoc ?xml version=1.0 ? cfloop index=LC from=1 to=20 cfoutput img src=../160_#z#.jpg width=540 height=360 / cfset z=z+1 /cfoutput /cfloop /xmldoc /cfxml you really dont use it but this is how you write. On Fri, Jan 16, 2009 at 7:28 PM, Les Irvin les.cft...@gmail.com wrote: I'm trying to have CF write a painfully simple xml file, basically just a list of sequentially numbered image tags. I keep getting this error: The markup in the document following the root element must be well-formed. Can anyone help? Thanks, Les cfxml variable=GalDoc ?xml version=1.0 ? cfloop index=LC from=1 to=20 cfoutput img src=../160_#z#.jpg width=540 height=360 / cfset z=z+1 /cfoutput /cfloop /cfxml cffile action=write file=#directory#gallery.xml output=#ToString(GalDoc)# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318122 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Merging of PDFs
This is to pull the data from stored preocedure.Part 1 !--- Store Procedure to get the PDF from the specified Disclosure ID --- cfstoredproc procedure=csp_ONF_GetDisclosureData datasource=Platform cfprocparam cfsqltype=CF_SQL_INTEGER value=#application.banknumber# type=in cfprocparam cfsqltype=CF_SQL_VARCHAR value=#session.get_DisclosureID# type=in cfprocresult name=Disclosure_Data /cfstoredproc !--- cfdump var=#Disclosure_Data# --- !--- cffile action=WRITE file=C:\temp.pdf output=#ToString(Disclosure_Data.DocumentData)# --- cffile action=WRITE file=C:\temp.pdf output=#toString(Disclosure_Data.DocumentData)#/ !--- cffile action=readbinary file=C:\temp.pdf variable=pdf_read/ cffile action=WRITE file=C:\temp.pdf output=#get_PDF#/ --- cfset session.data_pdf=#ToString(Disclosure_Data.DocumentData)# cfcontent file = C:\temp.pdf deleteFile = no !--- cfheader name=temp_PDF value=inline; filename=temp1.pdf --- /body /html This file displays the data pulled from the Database using stored Procedues.Part 2 cfform action=confirmation.cfm cfoutput query=Disclosure_results group=Name b#Disclosure_results.Name# /bbr br cfinput type=checkbox name=cbx_text value=value_text required=yes message=Please accept Disclosure #Disclosure_results.displaytext# brbr cfif #Disclosure_results.DocumentAvailable# eq '1' cfset session.get_DisclosureID=#Disclosure_results.DisclosureID# cfinput type=checkbox name=cbx_pdf value=value_pdfhyper required=yes message=Please accept Disclosure a href=getPDF.cfmPlease Click /abrbr /cfif Now my problem is to merge the Part1 PDF generated in the browser and Part2 (text pulled out from databaseand also have sme form data and I saved in some file which is also to be merged in to single PDF file I am unable to merge using cfpdf. But I cannot even use cfpdf as it can store the file in some location and not opens in browser. Please help me out in merging the contents of the formData, PDF generated in browser (Part1) and the data in the webpage pulled from Database (Part 2.) and saving it in some temp file so that I again save that PDF file in the Database using stored Procedure and also display in the browser. This is my code to save as well as display in the browser. cfsavecontent variable=data cfoutput strong Confirmation /strong table width=500 border=0 align=center tr /tr tr tdFirstName/td td#session.F_name#/td /tr tr tdM.Initial/td td#session.M_initial#/td /tr tr tdLastName/td td#session.L_name#/td /tr tr tdAddress/td td#session.Add1# nbsp;nbsp;#session.Add2#/td tr td/td td#session.City_name# nbsp;nbsp; #session.State_Name# nbsp;nbsp;#session.Zip_Name# /td tr /tr tr tdTIN/td td#session.TIN_number#/td /tr tr tdDOB/td td#session.DOB#/td /tr tr tdE-mail/td td#session.email#/td /tr tr tdPhone/td td#session.Phone#/td /tr br br /table p /cfoutput /cfsavecontent !--- to generate file in any folder--- cfdocument format=pdf overwrite=yes name=info_pdf filename=C:\my.pdf !--- cfdocumentitem type=header fontHeader/font /cfdocumentitem cfdocumentitem type=footer fontFooter/font /cfdocumentitem --- cfoutput#data#/cfoutput cfdocumentitem type=pagebreak/ table align=center tr td div align=center Disclosures: cfoutput query=session.Disclosure_results group=Name /div br b#session.Disclosure_results.name#/b br #session.Disclosure_results.displaytext# br /td /tr /table /cfoutput /cfdocument !--- showing the pdf in window--- cfdocument format=pdf overwrite=yes cfoutput#data#/cfoutput cfdocumentitem type=pagebreak/ table align=center tr td div align=center Disclosures: cfoutput query=session.Disclosure_results group=Name /div br pfont size=2b#session.Disclosure_results.name#:/b/font /p p #session.Disclosure_results.displaytext# /pbr /td /tr /table /cfoutput /cfdocument Please can anyone help me out with this..? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317446 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Merging of PDFs
This is to pull the data from stored preocedure.Part 1 !--- Store Procedure to get the PDF from the specified Disclosure ID --- cfstoredproc procedure=csp_ONF_GetDisclosureData datasource=Platform cfprocparam cfsqltype=CF_SQL_INTEGER value=#application. banknumber# type=in cfprocparam cfsqltype=CF_SQL_VARCHAR value=#session. get_DisclosureID# type=in cfprocresult name=Disclosure_Data /cfstoredproc !--- cfdump var=#Disclosure_Data# --- !--- cffile action=WRITE file=C:\temp.pdf output=#ToString(Disclosure_Data.DocumentData)# --- cffile action=WRITE file=C:\temp.pdf output=#toString(Disclosure_Data.DocumentData)#/ !--- cffile action=readbinary file=C:\temp.pdf variable=pdf_read/ cffile action=WRITE file=C:\temp.pdf output=#get_PDF#/ --- cfset session.data_pdf=#ToString(Disclosure_Data.DocumentData)# cfcontent file = C:\temp.pdf deleteFile = no !--- cfheader name=temp_PDF value=inline; filename=temp1.pdf --- /body /html This file displays the data pulled from the Database using stored Procedues.Part 2 cfform action=confirmation.cfm cfoutput query=Disclosure_results group=Name b#Disclosure_results.Name# /bbr br cfinput type=checkbox name=cbx_text value=value_text required=yes message=Please accept Disclosure #Disclosure_results.displaytext# brbr cfif #Disclosure_results.DocumentAvailable# eq '1' cfset session.get_DisclosureID=#Disclosure_results.DisclosureID# cfinput type=checkbox name=cbx_pdf value=value_pdfhyper required=yes message=Please accept Disclosure a href=getPDF.cfmPlease Click /abrbr /cfif Now my problem is to merge the Part1 PDF generated in the browser and Part2 (text pulled out from databaseand also have sme form data and I saved in some file which is also to be merged in to single PDF file I am unable to merge using cfpdf. But I cannot even use cfpdf as it can store the file in some location and not opens in browser. Please help me out in merging the contents of the formData, PDF generated in browser (Part1) and the data in the webpage pulled from Database (Part 2.) and saving it in some temp file so that I again save that PDF file in the Database using stored Procedure and also display in the browser. This is my code to save as well as display in the browser. cfsavecontent variable=data cfoutput strong Confirmation /strong table width=500 border=0 align=center tr /tr tr tdFirstName/td td#session.F_name#/td /tr tr tdM.Initial/td td#session.M_initial#/td /tr tr tdLastName/td td#session.L_name#/td /tr tr tdAddress/td td#session.Add1# nbsp;nbsp;#session.Add2#/td tr td/td td#session.City_name# nbsp;nbsp; #session.State_Name# nbsp;nbsp;#session.Zip_Name# /td tr /tr tr tdTIN/td td#session.TIN_number#/td /tr tr tdDOB/td td#session.DOB#/td /tr tr tdE-mail/td td#session.email#/td /tr tr tdPhone/td td#session.Phone#/td /tr br br /table p /cfoutput /cfsavecontent !--- to generate file in any folder--- cfdocument format=pdf overwrite=yes name=info_pdf filename=C:\my.pdf !--- cfdocumentitem type=header fontHeader/font /cfdocumentitem cfdocumentitem type=footer fontFooter/font /cfdocumentitem --- cfoutput#data#/cfoutput cfdocumentitem type=pagebreak/ table align=center tr td div align=center Disclosures: cfoutput query=session.Disclosure_results group=Name /div br b#session.Disclosure_results.name#/b br #session.Disclosure_results.displaytext# br /td /tr /table /cfoutput /cfdocument !--- showing the pdf in window--- cfdocument format=pdf overwrite=yes cfoutput#data#/cfoutput cfdocumentitem type=pagebreak/ table align=center tr td div align=center Disclosures: cfoutput query=session.Disclosure_results group=Name /div br pfont size=2b#session.Disclosure_results.name#:/b/font /p p #session.Disclosure_results.displaytext# /pbr /td /tr /table /cfoutput /cfdocument Please can anyone help me out with this..? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317452 Subscription:
Re: Merging of PDFs
Can any one help me put with this? This is to pull the data from stored preocedure.Part 1 !--- Store Procedure to get the PDF from the specified Disclosure ID --- cfstoredproc procedure=csp_ONF_GetDisclosureData datasource=Platform cfprocparam cfsqltype=CF_SQL_INTEGER value=#application. banknumber# type=in cfprocparam cfsqltype=CF_SQL_VARCHAR value=#session. get_DisclosureID# type=in cfprocresult name=Disclosure_Data /cfstoredproc !--- cfdump var=#Disclosure_Data# --- !--- cffile action=WRITE file=C:\temp.pdf output=#ToString(Disclosure_Data.DocumentData)# --- cffile action=WRITE file=C:\temp.pdf output=#toString(Disclosure_Data.DocumentData)#/ !--- cffile action=readbinary file=C:\temp.pdf variable=pdf_read/ cffile action=WRITE file=C:\temp.pdf output=#get_PDF#/ --- cfset session.data_pdf=#ToString(Disclosure_Data.DocumentData)# cfcontent file = C:\temp.pdf deleteFile = no !--- cfheader name=temp_PDF value=inline; filename=temp1.pdf --- /body /html This file displays the data pulled from the Database using stored Procedues.Part 2 cfform action=confirmation.cfm cfoutput query=Disclosure_results group=Name b#Disclosure_results.Name# /bbr br cfinput type=checkbox name=cbx_text value=value_text required=yes message=Please accept Disclosure #Disclosure_results.displaytext# brbr cfif #Disclosure_results.DocumentAvailable# eq '1' cfset session.get_DisclosureID=#Disclosure_results.DisclosureID# cfinput type=checkbox name=cbx_pdf value=value_pdfhyper required=yes message=Please accept Disclosure a href=getPDF.cfmPlease Click /abrbr /cfif Now my problem is to merge the Part1 PDF generated in the browser and Part2 (text pulled out from databaseand also have sme form data and I saved in some file which is also to be merged in to single PDF file I am unable to merge using cfpdf. But I cannot even use cfpdf as it can store the file in some location and not opens in browser. Please help me out in merging the contents of the formData, PDF generated in browser (Part1) and the data in the webpage pulled from Database (Part 2.) and saving it in some temp file so that I again save that PDF file in the Database using stored Procedure and also display in the browser. This is my code to save as well as display in the browser. cfsavecontent variable=data cfoutput strong Confirmation /strong table width=500 border=0 align=center tr /tr tr tdFirstName/td td#session.F_name#/td /tr tr tdM.Initial/td td#session.M_initial#/td /tr tr tdLastName/td td#session.L_name#/td /tr tr tdAddress/td td#session.Add1# nbsp;nbsp;#session.Add2#/td tr td/td td#session.City_name# nbsp;nbsp; #session.State_Name# nbsp;nbsp;#session.Zip_Name# /td tr /tr tr tdTIN/td td#session.TIN_number#/td /tr tr tdDOB/td td#session.DOB#/td /tr tr tdE-mail/td td#session.email#/td /tr tr tdPhone/td td#session.Phone#/td /tr br br /table p /cfoutput /cfsavecontent !--- to generate file in any folder--- cfdocument format=pdf overwrite=yes name=info_pdf filename=C:\my.pdf !--- cfdocumentitem type=header fontHeader/font /cfdocumentitem cfdocumentitem type=footer fontFooter/font /cfdocumentitem --- cfoutput#data#/cfoutput cfdocumentitem type=pagebreak/ table align=center tr td div align=center Disclosures: cfoutput query=session.Disclosure_results group=Name /div br b#session.Disclosure_results.name#/b br #session.Disclosure_results.displaytext# br /td /tr /table /cfoutput /cfdocument !--- showing the pdf in window--- cfdocument format=pdf overwrite=yes cfoutput#data#/cfoutput cfdocumentitem type=pagebreak/ table align=center tr td div align=center Disclosures: cfoutput query=session.Disclosure_results group=Name /div br pfont size=2b#session.Disclosure_results.name#:/b/font /p p #session.Disclosure_results.displaytext# /pbr /td /tr /table /cfoutput /cfdocument Please can anyone help me out with this..? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317453 Subscription: