Re: Contract rates
Thanks for the input so far guys. I did wonder about the possibility of leaving the agency but the agency and the client have quite a good working relationship and an understanding or agreement that the client won't take on any staff directly (perhaps for some length of time) after working for the client via the agency. The contact at the agency is also a personal friend of the head of web development at the client. On 4/11/07, Mark A Kruger [EMAIL PROTECTED] wrote: Right That's the rub. Although in my experience it happens all the time. Recruiters rarely enforce that part of the contract because they can't afford to alienate the customer. -Mark -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 11, 2007 11:04 AM To: CF-Talk Subject: RE: Contract rates But check the contract. They usually state you can't work for the end client for a set amount of time after you end the contract with them. Adrian -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: 11 April 2007 16:58 To: CF-Talk Subject: RE: Contract rates Hello Rich, A couple of years back I did a fair amount of contracting, it wasn't for ColdFusion development work, more of a technical type roll doing networking installations and client support, things like that. I know for sure that I was earning more than the other guys on the job, all of them had come in through an umbrella company, and I as an independent. From my experience on many jobs like this, and those experiences of other contractors that I know, you're best bet is to ditch the agency, they serve a purpose in winning you the initial contract, but after winning -yourself- your first extension or renewal the agency should be taken out of the loop. It doesn't cost them much to keep you in that position, so for them to cream a cut off the top for such a long time is a little cheeky. If you were hopping from job to job than its fair enough that they take a profit, but on such a long standing position which let's face it should really be classed as 'permanent' then I think they need to go, room 101 for the agency! *pulls the lever. Hope that helps, Rob -Original Message- From: RichL [mailto:[EMAIL PROTECTED] Sent: 11 April 2007 16:44 To: CF-Talk Subject: Contract rates Hello guys I was hoping to get a feeling from you guys of what the average hourly rate is for a Coldfusion developer working on development and maintenance of fairly complex applications. My situation is that I have been working for the same client for nearly two years with several contract extensions, initially at a rate of £23 an hour, with a rise to £26.50 at some point during my time with the client. There is another contractor here that started just before me and I am fairly sure that we are on a similar hourly rate. We were both new to contracting and took that job at the hourly rate advertised by the agency. I think that the contact at the agency also knows that we are both fairly new to contracting (but not new to Coldfusion) and the agent was very reluctant to offer any more of an increase in hourly rate past £26.50. We are both involved in fairly complex and important applications and now have a proven track record of a fairly decent standard of work here. More recently, a new contractor was taken on to help develop some new work. He is more experienced at contracting and made more demands on the agent in terms of an hourly rate and I have found out from him that he is on a rate of about £35 an hour for doing very similar development work. I am not sure if this extra amount that is being paid is being taken from the agent's cut of the client's payments or whether the agent has negotiated more money from the client. My instinct is that it is perhaps being taken from the agent's cut but I could well be wrong, that is just a guess. The work here is good and I would like to stay here. My contract is up for renewal in May and I have been told that there is a fairly good chance of a fairly lengthy renewal (e.g. 6 months) and the work that I will be involved in is fairly high profile. I would like to get some feedback from people about how to go about negotiating a healthy increase, to be on a similar rate to that of the new contractor. I don't want to play too hardball and risk losing the contract but I do have a proven record of work here and I know that my services will be quite valued for some new development work and I am now also aware that somebody else is being paid quite a lot more money for working on very similar parts of development. The other thing that I am considering doing is working through a limited company as opposed to using an umbrella company to process my payroll, tax etc. I would like to hear some feedback from other contractors who are working mainly for one client, working mainly on the client site about how
Opensource Web Analytics
I'm looking for a free or low cost web analytics tool that I can use on a few sites I host. Does anyone here have any recommendations? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Opensource Web Analytics
From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 12 April 2007 10:01 To: CF-Talk Subject: Opensource Web Analytics I'm looking for a free or low cost web analytics tool that I can use on a few sites I host. Does anyone here have any recommendations? If you're looking for something live, Google Analytics is probably best. If you want to process logs offline, try Analog from www.analog.cx - fast and accurate, IMHO. David Low Senior Developer and Data Manager MyHousePrice.com 3 Wellgreen Lane STIRLING, FK8 2BS tel: +44 (0) 1786 472 186 fax: +44 (0) 1786 472 109 email: [EMAIL PROTECTED] web: www.MyHousePrice.co.uk MyHousePrice.com Every House Sold, Every Price Paid This email is intended only for the person, persons, entity, or entities to which it is addressed. It does not necessarily represent the views of MyHousePrice.com Ltd. This email may contain confidential and/or privileged materials. In the case of confidential and/or privileged materials, any review, retransmission, dissemination or other use, including the taking of any action in reliance upon these materials, by persons or entities other than the intended recipient may be the subject of legal action. If you have received this email in error please contact the sender and delete the material from your computer. Internet e-mails are not necessarily secure. MyHousePrice.com Ltd does not accept responsibility for changes made to this message after it was sent. Many thanks. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Opensource Web Analytics
AWStats is alright. I prefer google analytics though. Adrian -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 12 April 2007 10:01 To: CF-Talk Subject: Opensource Web Analytics I'm looking for a free or low cost web analytics tool that I can use on a few sites I host. Does anyone here have any recommendations? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reading params from a file v/s getting them from a file
On Wednesday 11 Apr 2007, George Abraham wrote: Well, this is an application that will be serving multiple websites (with different vHost names.) When a session is initiated with the application, it determines which site it is. Then there are a host of params that are set according to the site. Since these params don't change much, I decided I would cache them periodically in a site-specific XML file and then read that XML file, instead of going to the database to get these params. Yes, Err, right. So you're not reading it at every request (like your first post said) ? -- Tom Chiverton Helping to adaptively deliver holistic e-business on: http://thefalken.livejournal.com 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 St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Tons of records - archive, or what?
On Wednesday 11 Apr 2007, Will Tomlinson wrote: I have a mySQL db that has lotsa joins, lotsa filters, etc., and could potentially accumulate millions of records over a year or two. The db revolves around school semesters. Will queries always want to include all the data, or only the most recent ? -- Tom Chiverton Helping to globally drive leading-edge experiences on: http://thefalken.livejournal.com 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 St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275059 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cf_htmlemail
Hi all, I was thinking about using the cf_htmlemail tag and was wondering if anyone one had any experience with it (good or bad). Thanks. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Webservice Issue
Hello Guys, I'm having a very strange issue with Web Services, well, maybe it's NOT strange, I'm just new to it :-D I have two identical functions, with different names within the component, yet when I call them, one works, the other doesn't. cfcomponent name=Location displayname=Location Management hint=I handle unit network location details. output=false !--- Update IP Address --- cffunction name=setIP access=remote output=false returntype=boolean hin=I update the units IP address cfargument name=UUID type=string required=true hint=I'm the UUID for the unit calling in. / !--- Set Temporary Local Structure --- cfset var LOCAL = structNew() / !--- Set Units Calling IP Address --- cfset LOCAL.UnitIP = CGI.REMOTE_ADDR / !--- Query To Update System Record --- cfquery name=LOCAL.IpUpdate datasource=#Application.DSN# UPDATE UnitIP SET IP = cfqueryparam value=#LOCAL.UnitIP# cfsqltype=cf_sql_varchar /, Logged = cfqueryparam value=#dateformat(now(),-mm-dd)# #timeformat(now(), HH:MM:SS)# cfsqltype=timestamp / WHERE UnitID = cfqueryparam value=#ARGUMENTS.UUID# cfsqltype=cf_sql_integer / /cfquery cfreturn true / /cffunction !--- Get XML Configuration --- cffunction name=getConfig2 access=remote output=false returntype=boolean hin=I update the units IP address cfargument name=UUID type=string required=true hint=I'm the UUID for the unit calling in. / !--- Set Temporary Local Structure --- cfset var LOCAL = structNew() / !--- Set Units Calling IP Address --- cfset LOCAL.UnitIP = CGI.REMOTE_ADDR / !--- Query To Update System Record --- cfquery name=LOCAL.IpUpdate datasource=#Application.DSN# UPDATE UnitIP SET IP = cfqueryparam value=#LOCAL.UnitIP# cfsqltype=cf_sql_varchar /, Logged = cfqueryparam value=#dateformat(now(),-mm-dd)# #timeformat(now(), HH:MM:SS)# cfsqltype=timestamp / WHERE UnitID = cfqueryparam value=#ARGUMENTS.UUID# cfsqltype=cf_sql_integer / /cfquery cfreturn true / /cffunction /cfcomponent Thats the code from my component, now take a look at these calls cfinvoke webservice=http://www.mydomain.co.uk/webservicetester/ip.cfc?wsdl; method=setIP returnvariable=aResult cfinvokeargument name=UUID value=1/ /cfinvoke cfdump var=#aResult# cfinvoke webservice=http://www.mydomain.co.uk/webservicetester/ip.cfc?wsdl; method=getConfig2 returnvariable=aResult cfinvokeargument name=UUID value=1/ /cfinvoke cfdump var=#aResult# Now the 'setIP' function works fine and returns as expected, but the 'getConfig2' does not for some reason, they are identical in every way, except the name, I'm lost!!! Thanks guys, Rawlins ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using Spry to Page forward and backward through data
I am trying to use spry to page forward and backward through data returned through a query. I have been looking at Bruce Phillips blog about this and I can't get the thing to work. Always get the SPRY spry:region or sprydetailregion attribute has no data set! error. The customer will need to supply search parameters which is then submitted to this CFC. CFFUNCTION name=GetEmployerResults returntype=xml output=false CFARGUMENT name=EmployerName default= / cfset var EmployerQry = cfset var EmployerXML = cfset var parsedEmployerXML = CFQUERY datasource=#request.dsource# name=EmployerQry SELECT rtrim(FirstName) as FirstName, rtrim(LastName) LastName, rtrim(EmailAddress) as EmailAddress FROM AMP_Employers WHERE EmployerID 0 /CFQUERY cfset toXML = createObject(component, toXML) cfset EmployerXML = toXML.queryToXML(EmployerQry, dataset, row) cfset parsedEmployerXML = xmlParse(EmployerXML) CFFILE ACTION=write FILE=Employers.xml OUTPUT=#ToString(parsedEmployerXML)# nameconflict=overwrite //Only used for testing to see if the XML file is produced correctly. cfcontent type=application/xml; charset=UTF-8 CFRETURN parsedEmployerXML / /CFFUNCTION My result page uses the following spry code, I know the #request.EmployerResults# is the problem, but I need to know how to allow a customer to supply search parameters and then pass the results of the query to the result page. I do not want to have to create an actual xml file and store it in a directory. Which will work perfectly if I change #request.EmployerResults# to ../Employers.xml script type=text/javascript //create a basic Spry DataSet var dsEmployers = new Spry.Data.XMLDataSet(#request.EmployerResults#, dataset/row); //create a page-enabled view of the Spry DataSet var pvEmployers = new Spry.Data.PagedView(dsEmployers, { pageSize: 12 }); /script Below is the XML file that is created when I write the file. ?xml version=1.0 encoding=UTF-8? dataset row EMAILADDRESS[EMAIL PROTECTED]/EMAILADDRESS FIRSTNAMETest 1 First Name/FIRSTNAME LASTNAMETest 1 Last Name/LASTNAME /row row EMAILADDRESS[EMAIL PROTECTED]/EMAILADDRESS FIRSTNAMEAnother Test First Name/FIRSTNAME LASTNAMEAnother Test Last Name/LASTNAME /row /dataset I am also using Mach-II and here is where it is called. !-- Query the employer results -- event-handler event=GetEmployerResults access=public notify listener=EmployerManager method=GetEmployerResults resultKey=request.EmployerResults / view-page name=EmployerSearchResults contentKey=request.content / view-page name=mainDisplayPage / /event-handler ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using Spry to Page forward and backward through data
Spry 1.5 will have this kind of functionality build in: http://labs.adobe.com/technologies/spry/preview/samples/data_region/SpryPagedViewSample.html While final release of 1.5 insn't yet available, you can see most of the new features here: http://labs.adobe.com/technologies/spry/preview/ Before the Spry team published the things above, I wrote a Spry paging solution myself: http://www.massimocorner.com/libraries/spry/spry_paging/sample.htm Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using Spry to Page forward and backward through data
My code works if I directly call the XML file, I am trying to avoid this and I want to pass the XML file back as a variable, I don't want to save the XML file to webroot folder. -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 8:29 AM To: CF-Talk Subject: Re: Using Spry to Page forward and backward through data Spry 1.5 will have this kind of functionality build in: http://labs.adobe.com/technologies/spry/preview/samples/data_region/Spry PagedViewSample.html While final release of 1.5 insn't yet available, you can see most of the new features here: http://labs.adobe.com/technologies/spry/preview/ Before the Spry team published the things above, I wrote a Spry paging solution myself: http://www.massimocorner.com/libraries/spry/spry_paging/sample.htm Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: reading params from a file v/s getting them from a file
Yes it is read at every request. For example, the navigational menu for every site is different, so the params XML file will have to be read every request to see what the menu items are. The only thing I store in a session variables is an ID identifying the site. George On 4/12/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Wednesday 11 Apr 2007, George Abraham wrote: Well, this is an application that will be serving multiple websites (with different vHost names.) When a session is initiated with the application, it determines which site it is. Then there are a host of params that are set according to the site. Since these params don't change much, I decided I would cache them periodically in a site-specific XML file and then read that XML file, instead of going to the database to get these params. Yes, Err, right. So you're not reading it at every request (like your first post said) ? -- Tom Chiverton ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using Spry to Page forward and backward through data
My code works if I directly call the XML file, I am trying to avoid this and I want to pass the XML file back as a variable, I don't want to save the XML file to webroot folder. There is no need to save the XML anywhere, the examples use static .xml files, but you can just point them to a .cfm file that output the XML. For a complete application see: http://www.massimocorner.com/spry/dynamic_spry.zip Here you can see a very basic example of how to use CF and a database to drive one of Sprys demos: http://www.adobe.com/devnet/dreamweaver/articles/edit_data_in_ajax.html Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Opensource Web Analytics
+1 for Google Analytics. I've used AWStats also... it was my favorite until G.A. Yves On 4/12/07, Adrian Lynch [EMAIL PROTECTED] wrote: AWStats is alright. I prefer google analytics though. Adrian -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 12 April 2007 10:01 To: CF-Talk Subject: Opensource Web Analytics I'm looking for a free or low cost web analytics tool that I can use on a few sites I host. Does anyone here have any recommendations? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reading params from a file v/s getting them from a file
On Thursday 12 Apr 2007, George Abraham wrote: Yes it is read at every request. For example, the navigational menu for every site is different, so the params XML file will have to be read every request to see what the menu items are. The only thing I store in a session variables is an ID identifying the site. Right. Why can't you store the parsed parameters in the session too ? -- Tom Chiverton Helping to seamlessly grow cross-media infomediaries on: http://thefalken.livejournal.com 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 St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Page to Page Navigation
I have page navigation that shows the number of pages of a search results; 25 per page (Example: Page 1 2 3 4 5 6 7 Show All). Is there a way to condense the numbers like the way Google does it so I don't have 50 numbers going across the page? Page 1 2 3 4 5 6 7 8 9 10 Show All Previous 10 11 12 13 14 15 16 17 18 19 20 And so on My code is: cfset ThisPage = 1 !--- Loop thru row numbers, in increments of RowsPerPage --- cfloop from=1 to=#TotalRows# step=#RowsPerPage# index=PageRow !--- Detect whether this Page currently being viewed --- cfset IsCurrentPage = (PageRow GTE URL.StartRow) AND (PageRow LTE EndRow) !--- If this Page is current page, show without link --- cfif IsCurrentPage cfoutputstrong#ThisPage#/strong/cfoutput !--- Otherwise, show with link so user can go to page --- cfelse cfoutput a href=#CGI.SCRIPT_NAME#?StartRow=#PageRow##ThisPage#/a /cfoutput /cfif !--- Increment ThisPage variable --- cfset ThisPage = ThisPage + 1 /cfloop Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Page to Page Navigation
You could do something simple like this: cfif len(pageList) gt 15 output first 7 page links ... output last 2 page links /cfif Chris Peterson -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 9:04 AM To: CF-Talk Subject: Page to Page Navigation I have page navigation that shows the number of pages of a search results; 25 per page (Example: Page 1 2 3 4 5 6 7 Show All). Is there a way to condense the numbers like the way Google does it so I don't have 50 numbers going across the page? Page 1 2 3 4 5 6 7 8 9 10 Show All Previous 10 11 12 13 14 15 16 17 18 19 20 And so on My code is: cfset ThisPage = 1 !--- Loop thru row numbers, in increments of RowsPerPage --- cfloop from=1 to=#TotalRows# step=#RowsPerPage# index=PageRow !--- Detect whether this Page currently being viewed --- cfset IsCurrentPage = (PageRow GTE URL.StartRow) AND (PageRow LTE EndRow) !--- If this Page is current page, show without link --- cfif IsCurrentPage cfoutputstrong#ThisPage#/strong/cfoutput !--- Otherwise, show with link so user can go to page --- cfelse cfoutput a href=#CGI.SCRIPT_NAME#?StartRow=#PageRow##ThisPage#/a /cfoutput /cfif !--- Increment ThisPage variable --- cfset ThisPage = ThisPage + 1 /cfloop Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Altering display of data from SQL database
I have data in a SQL database that I want displayed with commas on my web page (ex. data is stored as 1234 and I want it displayed as 1,234. Does anyone know how I would go about doing this? I'm assuming I need a cfif statement, but I'm not sure if there is a specific function I should use or not. Please help! ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275071 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 to Page Navigation
Sure, just change your loop parameters - instead of showing the numbers for all of the pages of data determine how many numbers you'll show. Check to see if you have records for all those pages, and loop to your num of records + 1, using the plus one as your next var. On 4/12/07, Steve LaBadie wrote: I have page navigation that shows the number of pages of a search results; 25 per page (Example: Page 1 2 3 4 5 6 7 Show All). Is there a way to condense the numbers like the way Google does it so I don't have 50 numbers going across the page? Page 1 2 3 4 5 6 7 8 9 10 Show All Previous 10 11 12 13 14 15 16 17 18 19 20 And so on My code is: cfset ThisPage = 1 !--- Loop thru row numbers, in increments of RowsPerPage --- cfloop from=1 to=#TotalRows# step=#RowsPerPage# index=PageRow !--- Detect whether this Page currently being viewed --- cfset IsCurrentPage = (PageRow GTE URL.StartRow) AND (PageRow LTE EndRow) !--- If this Page is current page, show without link --- cfif IsCurrentPage cfoutputstrong#ThisPage#/strong/cfoutput !--- Otherwise, show with link so user can go to page --- cfelse cfoutput a href=#CGI.SCRIPT_NAME#?StartRow=#PageRow##ThisPage#/a /cfoutput /cfif !--- Increment ThisPage variable --- cfset ThisPage = ThisPage + 1 /cfloop Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: changing directory
I'm in a shared hosting environment, so I don't have access to the servers at all. That's why I'm trying to do this through cold fusion coding. thank you anyhoo. daniel In IIS look at the properties for that folder and do the following. Redirect to: http://localhost/NewFolderName$S$Q Check Box for exact URL entered above Check Box for permanent redirection for this resource. -- Casey ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Altering display of data from SQL database
Look at the number formatting functions. They'll be one in there that'll do what you're after. cfquickdocs.com Adrian -Original Message- From: Steven Sprouse [mailto:[EMAIL PROTECTED] Sent: 12 April 2007 14:34 To: CF-Talk Subject: Altering display of data from SQL database I have data in a SQL database that I want displayed with commas on my web page (ex. data is stored as 1234 and I want it displayed as 1,234. Does anyone know how I would go about doing this? I'm assuming I need a cfif statement, but I'm not sure if there is a specific function I should use or not. Please help! ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275074 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 to Page Navigation
On 4/12/07, Steve LaBadie wrote: I have page navigation that shows the number of pages of a search results; 25 per page (Example: Page 1 2 3 4 5 6 7 Show All). Is there a way to condense the numbers like the way Google does it so I don't have 50 numbers going across the page? You could use this custom tag and its maxlinks attribute: http://www.olimpo.ch/tmt/tag/querynav/ Sample. http://www.olimpo.ch/tmt/tag/querynav/sample.cfm Using maxlinks: http://www.olimpo.ch/tmt/tag/querynav/sample_maxlinks.cfm Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using Spry to Page forward and backward through data
In my presentation last night I showed multiple examples of pointing Spry to a CFM page. I'm assuming the recording will be up soon at http://www.cfugtoronto.org/ On 4/12/07, Massimo Foti [EMAIL PROTECTED] wrote: My code works if I directly call the XML file, I am trying to avoid this and I want to pass the XML file back as a variable, I don't want to save the XML file to webroot folder. There is no need to save the XML anywhere, the examples use static .xml files, but you can just point them to a .cfm file that output the XML. For a complete application see: http://www.massimocorner.com/spry/dynamic_spry.zip Here you can see a very basic example of how to use CF and a database to drive one of Sprys demos: http://www.adobe.com/devnet/dreamweaver/articles/edit_data_in_ajax.html Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Opensource Web Analytics
I use a modified fusebox framework (all request go through index.cfm) will google analytics still work? -- Original Message -- From: Yves Arsenault [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Apr 2007 09:42:43 -0300 +1 for Google Analytics. I've used AWStats also... it was my favorite until G.A. Yves On 4/12/07, Adrian Lynch [EMAIL PROTECTED] wrote: AWStats is alright. I prefer google analytics though. Adrian -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 12 April 2007 10:01 To: CF-Talk Subject: Opensource Web Analytics I'm looking for a free or low cost web analytics tool that I can use on a few sites I host. Does anyone here have any recommendations? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Altering display of data from SQL database
Thanks so much. I got it working. Had to create some cfsets defining a variable for the data field names and now everything is working great. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using Spry to Page forward and backward through data
Is there now way of returning XML in a variable and have spry read it? I need the customer to search and return results before the page that the spry is located on is displayed. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 9:58 AM To: CF-Talk Subject: Re: Using Spry to Page forward and backward through data In my presentation last night I showed multiple examples of pointing Spry to a CFM page. I'm assuming the recording will be up soon at http://www.cfugtoronto.org/ On 4/12/07, Massimo Foti [EMAIL PROTECTED] wrote: My code works if I directly call the XML file, I am trying to avoid this and I want to pass the XML file back as a variable, I don't want to save the XML file to webroot folder. There is no need to save the XML anywhere, the examples use static .xml files, but you can just point them to a .cfm file that output the XML. For a complete application see: http://www.massimocorner.com/spry/dynamic_spry.zip Here you can see a very basic example of how to use CF and a database to drive one of Sprys demos: http://www.adobe.com/devnet/dreamweaver/articles/edit_data_in_ajax.htm l Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Opensource Web Analytics
On Thursday 12 Apr 2007, Dwayne Cole wrote: I use a modified fusebox framework (all request go through index.cfm) will google analytics still work? Sure. You just need to able to output a slightly different bit of JavaScript at the foot of each page. -- Tom Chiverton Helping to simultaneously orchestrate magnetic architectures on: http://thefalken.livejournal.com 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 St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Access my SessionService from Gateway (MG, CS, Reactor)
From your description, it seems like you are mixing layers (which will IMO bite you later). I would suggest keeping your components as focused as possible. When working on this type of problem, I create services that manage each of the entities in the domain. I generally separate user authentication from authorization / entitlement. Here is some pseudo-code to demonstrate what I'm talking about: UserService - userGateway (table gateway e.g. sets of data) - userDAO (manage single object persistence) getUser(username,password) : UserBean ( userDAO.read(UserBean) ); saveUser(UserBean) : Void ( userDAO.save(UserBean) ) getAll() : Query ( userGateway.getAll() ) UserDAO read(UserBean) : UserBean save(UserBean) : Void UserGateway getAll() { select ... from ... return query; } AuthenticationService - UserService (access to the user) - SessionFacade (access to the session) processLogin(username,password) : Boolean { user = UserService.getUser(username,password); return authenticateUser(user); } authenticateUser(UserBean) { log in user. if (loggedIn ) { sessionFacade.setUser(UserBean); } return UserBean; } EntitlementService - UserService - SessionFacade getEntitlements(UserBean) ... In this type of a setup, you could create accessors (setUserFacade/getUserFacade) for each of the composited items and let CS inject them. HTH, Rich Kroll ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Javascript Question
Hey all, How would I control a select tag based on this. function updateSelectedJournals(responseStruct) { $('selectedJournals').innerHTML = Selected Journals (+responseStruct.total+); $('lstSelectedTerms').innerHTML = responseStruct.lstoutput; I have select name=opoptionOR/optionoptionAND/option/select I want the and to show up if repsonseStruct.total is greater than 1. Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 7241 Jillspring Ct. Springfield, Va. 22152 (703) 220-2835 http://www.sstwebworks.com ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cf_htmlemail
On 4/12/07, richard [EMAIL PROTECTED] wrote: I was thinking about using the cf_htmlemail tag and was wondering if anyone one had any experience with it (good or bad). Never heard of it. Is it different from cfmail type=HTML ? Rick ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Webservice Issue
You might need to clear the service stubs as I've found that sometimes they don't refresh when the service is changed. Watch for wrap... cfobject type=JAVA action=Create name=factory class=coldfusion.server.ServiceFactory cfset RpcService = factory.XmlRpcService cfset RpcService.refreshWebService(http://www.mydomain.co.uk/webservicetester/ip.cfc?wsdl;) Cheers, !k -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 5:57 AM To: CF-Talk Subject: Webservice Issue Hello Guys, I'm having a very strange issue with Web Services, well, maybe it's NOT strange, I'm just new to it :-D I have two identical functions, with different names within the component, yet when I call them, one works, the other doesn't. cfcomponent name=Location displayname=Location Management hint=I handle unit network location details. output=false !--- Update IP Address --- cffunction name=setIP access=remote output=false returntype=boolean hin=I update the units IP address cfargument name=UUID type=string required=true hint=I'm the UUID for the unit calling in. / !--- Set Temporary Local Structure --- cfset var LOCAL = structNew() / !--- Set Units Calling IP Address --- cfset LOCAL.UnitIP = CGI.REMOTE_ADDR / !--- Query To Update System Record --- cfquery name=LOCAL.IpUpdate datasource=#Application.DSN# UPDATE UnitIP SET IP = cfqueryparam value=#LOCAL.UnitIP# cfsqltype=cf_sql_varchar /, Logged = cfqueryparam value=#dateformat(now(),-mm-dd)# #timeformat(now(), HH:MM:SS)# cfsqltype=timestamp / WHERE UnitID = cfqueryparam value=#ARGUMENTS.UUID# cfsqltype=cf_sql_integer / /cfquery cfreturn true / /cffunction !--- Get XML Configuration --- cffunction name=getConfig2 access=remote output=false returntype=boolean hin=I update the units IP address cfargument name=UUID type=string required=true hint=I'm the UUID for the unit calling in. / !--- Set Temporary Local Structure --- cfset var LOCAL = structNew() / !--- Set Units Calling IP Address --- cfset LOCAL.UnitIP = CGI.REMOTE_ADDR / !--- Query To Update System Record --- cfquery name=LOCAL.IpUpdate datasource=#Application.DSN# UPDATE UnitIP SET IP = cfqueryparam value=#LOCAL.UnitIP# cfsqltype=cf_sql_varchar /, Logged = cfqueryparam value=#dateformat(now(),-mm-dd)# #timeformat(now(), HH:MM:SS)# cfsqltype=timestamp / WHERE UnitID = cfqueryparam value=#ARGUMENTS.UUID# cfsqltype=cf_sql_integer / /cfquery cfreturn true / /cffunction /cfcomponent Thats the code from my component, now take a look at these calls cfinvoke webservice=http://www.mydomain.co.uk/webservicetester/ip.cfc?wsdl; method=setIP returnvariable=aResult cfinvokeargument name=UUID value=1/ /cfinvoke cfdump var=#aResult# cfinvoke webservice=http://www.mydomain.co.uk/webservicetester/ip.cfc?wsdl; method=getConfig2 returnvariable=aResult cfinvokeargument name=UUID value=1/ /cfinvoke cfdump var=#aResult# Now the 'setIP' function works fine and returns as expected, but the 'getConfig2' does not for some reason, they are identical in every way, except the name, I'm lost!!! Thanks guys, Rawlins ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Webservice Issue
Thanks Kevin, I rebooted the box a few moment ago and it kicked into life after that, so perhaps you're right. I'll keep that code handy for future, thanks. Rob -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: 12 April 2007 16:04 To: CF-Talk Subject: RE: Webservice Issue You might need to clear the service stubs as I've found that sometimes they don't refresh when the service is changed. Watch for wrap... cfobject type=JAVA action=Create name=factory class=coldfusion.server.ServiceFactory cfset RpcService = factory.XmlRpcService cfset RpcService.refreshWebService(http://www.mydomain.co.uk/webservicetester/ip. cfc?wsdl) Cheers, !k -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 5:57 AM To: CF-Talk Subject: Webservice Issue Hello Guys, I'm having a very strange issue with Web Services, well, maybe it's NOT strange, I'm just new to it :-D I have two identical functions, with different names within the component, yet when I call them, one works, the other doesn't. cfcomponent name=Location displayname=Location Management hint=I handle unit network location details. output=false !--- Update IP Address --- cffunction name=setIP access=remote output=false returntype=boolean hin=I update the units IP address cfargument name=UUID type=string required=true hint=I'm the UUID for the unit calling in. / !--- Set Temporary Local Structure --- cfset var LOCAL = structNew() / !--- Set Units Calling IP Address --- cfset LOCAL.UnitIP = CGI.REMOTE_ADDR / !--- Query To Update System Record --- cfquery name=LOCAL.IpUpdate datasource=#Application.DSN# UPDATE UnitIP SET IP = cfqueryparam value=#LOCAL.UnitIP# cfsqltype=cf_sql_varchar /, Logged = cfqueryparam value=#dateformat(now(),-mm-dd)# #timeformat(now(), HH:MM:SS)# cfsqltype=timestamp / WHERE UnitID = cfqueryparam value=#ARGUMENTS.UUID# cfsqltype=cf_sql_integer / /cfquery cfreturn true / /cffunction !--- Get XML Configuration --- cffunction name=getConfig2 access=remote output=false returntype=boolean hin=I update the units IP address cfargument name=UUID type=string required=true hint=I'm the UUID for the unit calling in. / !--- Set Temporary Local Structure --- cfset var LOCAL = structNew() / !--- Set Units Calling IP Address --- cfset LOCAL.UnitIP = CGI.REMOTE_ADDR / !--- Query To Update System Record --- cfquery name=LOCAL.IpUpdate datasource=#Application.DSN# UPDATE UnitIP SET IP = cfqueryparam value=#LOCAL.UnitIP# cfsqltype=cf_sql_varchar /, Logged = cfqueryparam value=#dateformat(now(),-mm-dd)# #timeformat(now(), HH:MM:SS)# cfsqltype=timestamp / WHERE UnitID = cfqueryparam value=#ARGUMENTS.UUID# cfsqltype=cf_sql_integer / /cfquery cfreturn true / /cffunction /cfcomponent Thats the code from my component, now take a look at these calls cfinvoke webservice=http://www.mydomain.co.uk/webservicetester/ip.cfc?wsdl; method=setIP returnvariable=aResult cfinvokeargument name=UUID value=1/ /cfinvoke cfdump var=#aResult# cfinvoke webservice=http://www.mydomain.co.uk/webservicetester/ip.cfc?wsdl; method=getConfig2 returnvariable=aResult cfinvokeargument name=UUID value=1/ /cfinvoke cfdump var=#aResult# Now the 'setIP' function works fine and returns as expected, but the 'getConfig2' does not for some reason, they are identical in every way, except the name, I'm lost!!! Thanks guys, Rawlins ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Access my SessionService from Gateway (MG, CS, Reactor)
Thanks for that Rich, I've been playing around with this the past couple of days and have a working model. But I'm always interested to learn the most efficient ways to achieve these kinds of things, I'll be playing with your code for sure. Thanks, Rob -Original Message- From: Richard Kroll [mailto:[EMAIL PROTECTED] Sent: 12 April 2007 15:46 To: CF-Talk Subject: RE: Access my SessionService from Gateway (MG, CS, Reactor) From your description, it seems like you are mixing layers (which will IMO bite you later). I would suggest keeping your components as focused as possible. When working on this type of problem, I create services that manage each of the entities in the domain. I generally separate user authentication from authorization / entitlement. Here is some pseudo-code to demonstrate what I'm talking about: UserService - userGateway (table gateway e.g. sets of data) - userDAO (manage single object persistence) getUser(username,password) : UserBean ( userDAO.read(UserBean) ); saveUser(UserBean) : Void ( userDAO.save(UserBean) ) getAll() : Query ( userGateway.getAll() ) UserDAO read(UserBean) : UserBean save(UserBean) : Void UserGateway getAll() { select ... from ... return query; } AuthenticationService - UserService (access to the user) - SessionFacade (access to the session) processLogin(username,password) : Boolean { user = UserService.getUser(username,password); return authenticateUser(user); } authenticateUser(UserBean) { log in user. if (loggedIn ) { sessionFacade.setUser(UserBean); } return UserBean; } EntitlementService - UserService - SessionFacade getEntitlements(UserBean) ... In this type of a setup, you could create accessors (setUserFacade/getUserFacade) for each of the composited items and let CS inject them. HTH, Rich Kroll ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using Spry to Page forward and backward through data
I'm afraid you lost me. You want to return the XML as a variable that Spry can read? Well you know that client side code can't read CF code, right? If your question is - can I include the XML data itself IN the page, then yes, you can. Spry doesn't have to make a HTTP request to get the XML. See this URL: http://labs.adobe.com/technologies/spry/samples/data_region/XMLStringSample.html On 4/12/07, Chad McCue [EMAIL PROTECTED] wrote: Is there now way of returning XML in a variable and have spry read it? I need the customer to search and return results before the page that the spry is located on is displayed. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 9:58 AM To: CF-Talk Subject: Re: Using Spry to Page forward and backward through data In my presentation last night I showed multiple examples of pointing Spry to a CFM page. I'm assuming the recording will be up soon at http://www.cfugtoronto.org/ On 4/12/07, Massimo Foti [EMAIL PROTECTED] wrote: My code works if I directly call the XML file, I am trying to avoid this and I want to pass the XML file back as a variable, I don't want to save the XML file to webroot folder. There is no need to save the XML anywhere, the examples use static .xml files, but you can just point them to a .cfm file that output the XML. For a complete application see: http://www.massimocorner.com/spry/dynamic_spry.zip Here you can see a very basic example of how to use CF and a database to drive one of Sprys demos: http://www.adobe.com/devnet/dreamweaver/articles/edit_data_in_ajax.htm l Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275087 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cftree, formatting the output
Can anyone help me out with formatting the value data of a cftreeitem. I want to be able to bold the text displayed. Any resources for Flash forms would be great also. Cheers. Adrian ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Javascript Question
Never mind, I figured it out -- Scott Stewart ColdFusion Developer SSTWebworks 7241 Jillspring Ct. Springfield, Va. 22152 (703) 220-2835 http://www.sstwebworks.com -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 10:52 AM To: CF-Talk Subject: OT: Javascript Question Hey all, How would I control a select tag based on this. function updateSelectedJournals(responseStruct) { $('selectedJournals').innerHTML = Selected Journals (+responseStruct.total+); $('lstSelectedTerms').innerHTML = responseStruct.lstoutput; I have select name=opoptionOR/optionoptionAND/option/select I want the and to show up if repsonseStruct.total is greater than 1. Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 7241 Jillspring Ct. Springfield, Va. 22152 (703) 220-2835 http://www.sstwebworks.com ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using Spry to Page forward and backward through data
I think I am closer but still am lost. This is what is coming back to my result page and populating spry. I not sure why this is returning like this and not keeping the formatting. wddxPacket version='1.0'header/datastringlt;?xml version=1.0 encoding=UTF-8?gt;char code='0a'/lt;datasetgt;lt;rowgt;lt;EMAILADDRESSgt;[EMAIL PROTECTED] oductions.comlt;/EMAILADDRESS gt;lt;FIRSTNAMEgt;Chadlt;/FIRSTNAMEgt;lt;LASTNAMEgt;McCuelt;/LAS TNAMEgt;lt;/rowgt;lt;row gt;lt;EMAILADDRESSgt;[EMAIL PROTECTED]lt;/EMAILADDRESSgt ;lt;FIRSTNAMEgt;Greglt;/FIRSTNAME gt;lt;LASTNAMEgt;Puglialt;/LASTNAMEgt;lt;/rowgt;lt;/datasetgt; /string/data/wddxPacket -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 12:03 PM To: CF-Talk Subject: Re: Using Spry to Page forward and backward through data I'm afraid you lost me. You want to return the XML as a variable that Spry can read? Well you know that client side code can't read CF code, right? If your question is - can I include the XML data itself IN the page, then yes, you can. Spry doesn't have to make a HTTP request to get the XML. See this URL: http://labs.adobe.com/technologies/spry/samples/data_region/XMLStringSam ple.html On 4/12/07, Chad McCue [EMAIL PROTECTED] wrote: Is there now way of returning XML in a variable and have spry read it? I need the customer to search and return results before the page that the spry is located on is displayed. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 9:58 AM To: CF-Talk Subject: Re: Using Spry to Page forward and backward through data In my presentation last night I showed multiple examples of pointing Spry to a CFM page. I'm assuming the recording will be up soon at http://www.cfugtoronto.org/ On 4/12/07, Massimo Foti [EMAIL PROTECTED] wrote: My code works if I directly call the XML file, I am trying to avoid this and I want to pass the XML file back as a variable, I don't want to save the XML file to webroot folder. There is no need to save the XML anywhere, the examples use static .xml files, but you can just point them to a .cfm file that output the XML. For a complete application see: http://www.massimocorner.com/spry/dynamic_spry.zip Here you can see a very basic example of how to use CF and a database to drive one of Sprys demos: http://www.adobe.com/devnet/dreamweaver/articles/edit_data_in_ajax.h tm l Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFDocument
I have checked the Adobe site but I thought that I would ask the list anyway. I have a page that uses the CFDocument tag. Everything is OK except the page breaks. I had to put manual page breaks where the paper form pages end and the next one starts. Problem is, the user may only enter a couple of lines of information in the form fields or a lot of information, so of course the manual page breaks I put in can leave a lot of white space or the pages run into the next page and part of the text is chopped off. I played around with margins and what not but nothing seems to work. Is this an inherent problem with CFDocument? Do I have to fall back on plain ole HTML to make this work better? Thanks, -- Bruce Sorge I'm a mawg: half man, half dog. I'm my own best friend! ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using Spry to Page forward and backward through data
When I try to put my returntype of my function to XML it goes into an very long loop and comes back with XML error saying the top element needs to be defined. Any ideas? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 12:03 PM To: CF-Talk Subject: Re: Using Spry to Page forward and backward through data I'm afraid you lost me. You want to return the XML as a variable that Spry can read? Well you know that client side code can't read CF code, right? If your question is - can I include the XML data itself IN the page, then yes, you can. Spry doesn't have to make a HTTP request to get the XML. See this URL: http://labs.adobe.com/technologies/spry/samples/data_region/XMLStringSam ple.html On 4/12/07, Chad McCue [EMAIL PROTECTED] wrote: Is there now way of returning XML in a variable and have spry read it? I need the customer to search and return results before the page that the spry is located on is displayed. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 9:58 AM To: CF-Talk Subject: Re: Using Spry to Page forward and backward through data In my presentation last night I showed multiple examples of pointing Spry to a CFM page. I'm assuming the recording will be up soon at http://www.cfugtoronto.org/ On 4/12/07, Massimo Foti [EMAIL PROTECTED] wrote: My code works if I directly call the XML file, I am trying to avoid this and I want to pass the XML file back as a variable, I don't want to save the XML file to webroot folder. There is no need to save the XML anywhere, the examples use static .xml files, but you can just point them to a .cfm file that output the XML. For a complete application see: http://www.massimocorner.com/spry/dynamic_spry.zip Here you can see a very basic example of how to use CF and a database to drive one of Sprys demos: http://www.adobe.com/devnet/dreamweaver/articles/edit_data_in_ajax.h tm l Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275092 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFDocument
It's a cfdocument bug, I thought that CF version 7.02 had a fix for that. I always end up counting rows and inserting a page break when the max rows fit on a page. Also, try decreasing your margins (margintop=.25, etc), see if that helps. Chris -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 12:55 PM To: CF-Talk Subject: CFDocument I have checked the Adobe site but I thought that I would ask the list anyway. I have a page that uses the CFDocument tag. Everything is OK except the page breaks. I had to put manual page breaks where the paper form pages end and the next one starts. Problem is, the user may only enter a couple of lines of information in the form fields or a lot of information, so of course the manual page breaks I put in can leave a lot of white space or the pages run into the next page and part of the text is chopped off. I played around with margins and what not but nothing seems to work. Is this an inherent problem with CFDocument? Do I have to fall back on plain ole HTML to make this work better? Thanks, -- Bruce Sorge I'm a mawg: half man, half dog. I'm my own best friend! ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275093 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Still having SPRY problem
Here are my conclusions and hopefully someone can figure this out for me. Is there anything special I have to do server side to be able to call a cfc? When I do this script type=text/javascript var XML_URL = ../FunctionPages/Employers.cfc?method=GetEmployerResults; //create a basic Spry DataSet var dsEmployers = new Spry.Data.XMLDataSet(XML_URL, dataset/row, { useCache: false }); //create a page-enabled view of the Spry DataSet var pvEmployers = new Spry.Data.PagedView(dsEmployers, { pageSize: 12 }); /script I get a coldfusion time out error and the spry does not load the data. Here is my CFC CFFUNCTION name=GetEmployerResults access=remote returntype=void output=false CFARGUMENT name=EmployerName default= / CFQUERY datasource=#request.dsource# name=EmployerQry SELECT rtrim(FirstName) as FirstName, rtrim(LastName) as LastName, rtrim(EmailAddress) as EmailAddress FROM AMP_Employers WHERE EmployerID 0 /CFQUERY cfset toXML = createObject(component, toXML) cfset EmployerXML = toXML.queryToXML(EmployerQry, dataset, row) cfset parsedEmployerXML = xmlParse(EmployerXML) cfcontent type=application/xml; charset=UTF-8 cfreturn parsedEmployerXML /CFFUNCTION When I do this below (switch the cfc page to a cfm page) it runs perfectly. script type=text/javascript var XML_URL = ../FunctionPages/Employers.cfm; //create a basic Spry DataSet var dsEmployers = new Spry.Data.XMLDataSet(XML_URL, dataset/row, { useCache: false }); //create a page-enabled view of the Spry DataSet var pvEmployers = new Spry.Data.PagedView(dsEmployers, { pageSize: 12 }); /script Here is my cfm file CFQUERY datasource=#request.dsource# name=EmployerQry SELECT rtrim(FirstName) as FirstName, rtrim(LastName) as LastName, rtrim(EmailAddress) as EmailAddress FROM AMP_Employers WHERE EmployerID 0 /CFQUERY cfset toXML = createObject(component, toXML) cfset EmployerXML = toXML.queryToXML(EmployerQry, dataset, row) cfset parsedEmployerXML = xmlParse(EmployerXML) cfcontent type=application/xml; charset=UTF-8 CFOUTPUT#parsedEmployerXML#/CFOUTPUT -Original Message- From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 12:56 PM To: CF-Talk Subject: RE: Using Spry to Page forward and backward through data When I try to put my returntype of my function to XML it goes into an very long loop and comes back with XML error saying the top element needs to be defined. Any ideas? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 12:03 PM To: CF-Talk Subject: Re: Using Spry to Page forward and backward through data I'm afraid you lost me. You want to return the XML as a variable that Spry can read? Well you know that client side code can't read CF code, right? If your question is - can I include the XML data itself IN the page, then yes, you can. Spry doesn't have to make a HTTP request to get the XML. See this URL: http://labs.adobe.com/technologies/spry/samples/data_region/XMLStringSam ple.html On 4/12/07, Chad McCue [EMAIL PROTECTED] wrote: Is there now way of returning XML in a variable and have spry read it? I need the customer to search and return results before the page that the spry is located on is displayed. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 9:58 AM To: CF-Talk Subject: Re: Using Spry to Page forward and backward through data In my presentation last night I showed multiple examples of pointing Spry to a CFM page. I'm assuming the recording will be up soon at http://www.cfugtoronto.org/ On 4/12/07, Massimo Foti [EMAIL PROTECTED] wrote: My code works if I directly call the XML file, I am trying to avoid this and I want to pass the XML file back as a variable, I don't want to save the XML file to webroot folder. There is no need to save the XML anywhere, the examples use static .xml files, but you can just point them to a .cfm file that output the XML. For a complete application see: http://www.massimocorner.com/spry/dynamic_spry.zip Here you can see a very basic example of how to use CF and a database to drive one of Sprys demos: http://www.adobe.com/devnet/dreamweaver/articles/edit_data_in_ajax.h tm l Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity.
Re: Using Spry to Page forward and backward through data
Are you using CF7? Only CF7 supports the Dont wddx encoded a result if returntype is xml. If you aren't using 7, you will need to use a proxy CFM file. On 4/12/07, Chad McCue [EMAIL PROTECTED] wrote: I think I am closer but still am lost. This is what is coming back to my result page and populating spry. I not sure why this is returning like this and not keeping the formatting. wddxPacket version='1.0'header/datastringlt;?xml version=1.0 encoding=UTF-8?gt;char -- === Raymond Camden Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using Spry to Page forward and backward through data
I am using CF7 Chad McCue Advanced Media Productions 251 West Central St. Suite 28 Natick MA, 01760 p: 508.647.5151 ext 16 f: 508.647.5150 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 2:50 PM To: CF-Talk Subject: Re: Using Spry to Page forward and backward through data Are you using CF7? Only CF7 supports the Dont wddx encoded a result if returntype is xml. If you aren't using 7, you will need to use a proxy CFM file. On 4/12/07, Chad McCue [EMAIL PROTECTED] wrote: I think I am closer but still am lost. This is what is coming back to my result page and populating spry. I not sure why this is returning like this and not keeping the formatting. wddxPacket version='1.0'header/datastringlt;?xml version=1.0 encoding=UTF-8?gt;char -- === Raymond Camden Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using Spry to Page forward and backward through data
So are you loading the string in as is or calling it via a url in the dataset? Show me your JS please. On 4/12/07, Chad McCue [EMAIL PROTECTED] wrote: I am using CF7 Chad McCue Advanced Media Productions 251 West Central St. Suite 28 Natick MA, 01760 p: 508.647.5151 ext 16 f: 508.647.5150 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 2:50 PM To: CF-Talk Subject: Re: Using Spry to Page forward and backward through data Are you using CF7? Only CF7 supports the Dont wddx encoded a result if returntype is xml. If you aren't using 7, you will need to use a proxy CFM file. On 4/12/07, Chad McCue [EMAIL PROTECTED] wrote: I think I am closer but still am lost. This is what is coming back to my result page and populating spry. I not sure why this is returning like this and not keeping the formatting. wddxPacket version='1.0'header/datastringlt;?xml version=1.0 encoding=UTF-8?gt;char -- === Raymond Camden Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using Spry to Page forward and backward through data
This should have everything you need. When I use the CFC the page just runs and never loads. I end up with a error because it exceeded the time limit. When I switch to a cfm page it loads instantly. Here are my conclusions and hopefully someone can figure this out for me. Is there anything special I have to do server side to be able to call a cfc? When I do this script type=text/javascript var XML_URL = ../FunctionPages/Employers.cfc?method=GetEmployerResults; //create a basic Spry DataSet var dsEmployers = new Spry.Data.XMLDataSet(XML_URL, dataset/row, { useCache: false }); //create a page-enabled view of the Spry DataSet var pvEmployers = new Spry.Data.PagedView(dsEmployers, { pageSize: 12 }); /script I get a coldfusion time out error and the spry does not load the data. Here is my CFC CFFUNCTION name=GetEmployerResults access=remote returntype=void output=false CFARGUMENT name=EmployerName default= / CFQUERY datasource=#request.dsource# name=EmployerQry SELECT rtrim(FirstName) as FirstName, rtrim(LastName) as LastName, rtrim(EmailAddress) as EmailAddress FROM AMP_Employers WHERE EmployerID 0 /CFQUERY cfset toXML = createObject(component, toXML) cfset EmployerXML = toXML.queryToXML(EmployerQry, dataset, row) cfset parsedEmployerXML = xmlParse(EmployerXML) cfcontent type=application/xml; charset=UTF-8 cfreturn parsedEmployerXML /CFFUNCTION When I do this below (switch the cfc page to a cfm page) it runs perfectly. script type=text/javascript var XML_URL = ../FunctionPages/Employers.cfm; //create a basic Spry DataSet var dsEmployers = new Spry.Data.XMLDataSet(XML_URL, dataset/row, { useCache: false }); //create a page-enabled view of the Spry DataSet var pvEmployers = new Spry.Data.PagedView(dsEmployers, { pageSize: 12 }); /script Here is my cfm file CFQUERY datasource=#request.dsource# name=EmployerQry SELECT rtrim(FirstName) as FirstName, rtrim(LastName) as LastName, rtrim(EmailAddress) as EmailAddress FROM AMP_Employers WHERE EmployerID 0 /CFQUERY cfset toXML = createObject(component, toXML) cfset EmployerXML = toXML.queryToXML(EmployerQry, dataset, row) cfset parsedEmployerXML = xmlParse(EmployerXML) cfcontent type=application/xml; charset=UTF-8 CFOUTPUT#parsedEmployerXML#/CFOUTPUT -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 3:10 PM To: CF-Talk Subject: Re: Using Spry to Page forward and backward through data So are you loading the string in as is or calling it via a url in the dataset? Show me your JS please. On 4/12/07, Chad McCue [EMAIL PROTECTED] wrote: I am using CF7 Chad McCue Advanced Media Productions 251 West Central St. Suite 28 Natick MA, 01760 p: 508.647.5151 ext 16 f: 508.647.5150 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 2:50 PM To: CF-Talk Subject: Re: Using Spry to Page forward and backward through data Are you using CF7? Only CF7 supports the Dont wddx encoded a result if returntype is xml. If you aren't using 7, you will need to use a proxy CFM file. On 4/12/07, Chad McCue [EMAIL PROTECTED] wrote: I think I am closer but still am lost. This is what is coming back to my result page and populating spry. I not sure why this is returning like this and not keeping the formatting. wddxPacket version='1.0'header/datastringlt;?xml version=1.0 encoding=UTF-8?gt;char -- == == === Raymond Camden Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using Spry to Page forward and backward through data
This should have everything you need. When I use the CFC the page just runs and never loads. I end up with a error because it exceeded the time limit. When I switch to a cfm page it loads instantly. //Using CFC call - This does not work script type=text/javascript var XML_URL = ../FunctionPages/Employers.cfc?method=GetEmployerResults; //create a basic Spry DataSet var dsEmployers = new Spry.Data.XMLDataSet(XML_URL, dataset/row, { useCache: false }); //create a page-enabled view of the Spry DataSet var pvEmployers = new Spry.Data.PagedView(dsEmployers, { pageSize: 12 }); /script //This is my CFC CFFUNCTION name=GetEmployerResults access=remote returntype=xml output=false CFARGUMENT name=EmployerName default= / CFQUERY datasource=#request.dsource# name=EmployerQry SELECT rtrim(FirstName) as FirstName, rtrim(LastName) as LastName, rtrim(EmailAddress) as EmailAddress FROM AMP_Employers WHERE EmployerID 0 /CFQUERY cfset toXML = createObject(component, toXML) cfset EmployerXML = toXML.queryToXML(EmployerQry, dataset,row) cfset parsedEmployerXML = xmlParse(EmployerXML) cfcontent type=application/xml; charset=UTF-8 cfreturn parsedEmployerXML /CFFUNCTION //Using CFM call - This works script type=text/javascript var XML_URL = ../FunctionPages/Employers.cfm; //create a basic Spry DataSet var dsEmployers = new Spry.Data.XMLDataSet(XML_URL, dataset/row, {useCache: false }); //create a page-enabled view of the Spry DataSet var pvEmployers = new Spry.Data.PagedView(dsEmployers, { pageSize: 12 }); /script //This is my cfm page CFQUERY datasource=#request.dsource# name=EmployerQry SELECT rtrim(FirstName) as FirstName, rtrim(LastName) as LastName, rtrim(EmailAddress) as EmailAddress FROM AMP_Employers WHERE EmployerID 0 /CFQUERY cfset toXML = createObject(component, toXML) cfset EmployerXML = toXML.queryToXML(EmployerQry, dataset, row) cfset parsedEmployerXML = xmlParse(EmployerXML) cfcontent type=application/xml; charset=UTF-8 CFOUTPUT#parsedEmployerXML#/CFOUTPUT ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Is there anything inherently wrong with this Application.cfm file?
Is there anything inherently wrong with this Application.cfm file? Its for a shared CF hosting account w/ multiple domains (around 10 or so). Could it be improved? FWIW, it does work. :) My goal is to write my code so that I can host many related domains with one set of core code. Only ini files, stylesheets, images and site navigation includes will change from site to site. These site aren't very complicated, so there is no great need for a MVC type app. And yes, much of the code below was modified from Ray Camden's original work. :) Thanks for any input... Che cfsilent !--- determine the domain name. --- cfset strSiteUrl = LCase(Replace(cgi.server_name, www., , ALL)) / cfswitch expression=#strSiteUrl# cfcase value=buickpartspage.com cfapplication name=BuickPartsPage applicationtimeout=#CreateTimeSpan( 1, 0, 0, 0 )# sessionmanagement=false setclientcookies=true/ /cfcase cfcase value=pontiacpartspage.com cfapplication name=PontiacPartsPage applicationtimeout=#CreateTimeSpan( 1, 0, 0, 0 )# sessionmanagement=false setclientcookies=true/ /cfcase cfdefaultcase cfapplication name=ThePartsPages applicationtimeout=#CreateTimeSpan( 1, 0, 0, 0 )# sessionmanagement=false setclientcookies=true/ /cfdefaultcase /cfswitch cfif not isDefined(application.settings) or isDefined(url.reinit) !--- Clear the existing Application to make sure we don't have any old data. --- cfset StructClear(application) cfswitch expression=#strSiteUrl# cfcase value=buickpartspage.com cfset iniFile = expandPath(./ini/buick.ini.cfm) / /cfcase cfdefaultcase cfset iniFile = expandPath(./ini/tpp.ini.cfm) / /cfdefaultcase /cfswitch cfset sections = getProfileSections(iniFile) cfset data = structNew() cfif structKeyExists(sections, default) cfloop index=key list=#sections.default# cfset data[key] = getProfileString(iniFile, default, key) /cfloop cfset application.settings = data cfelse cfthrow message=Ini file has a missing default section! /cfif !--- load and init rss feed. other than writing results to a file, not sure how to cache results. --- cfset application.settings.rssFeed = createObject(component, com.rss).getEntries(xmlData=application.settings.rssFeedURL) !--- load and init flickr feed. let's grab only the latest 8 photos. --- cfset flickr = createobject(component, CFlickr.Flickr) cfset flickr.init(application.settings.apikey, application.settings.secret) cfset pi = flickr.getPhotosInterface() cfset photoSearch = pi.search(text=classic buick, tag_mode=all, sort=date-posted-desc, per_page=12) cfset application.settings.arrayPhotos = photoSearch.getPhotos() !--- We are initialized :) --- cfset application.init = true /cfif !--- cfsetting showdebugoutput=false --- /cfsilent ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Still having SPRY problem
A few things. You don't need to parse the XML. YOu can return the XML data as a string. This isn't the cause of your issue, but will make your code run a tiny bit faster. Secondly - remove Spry from the picture. Just try to go to the URL directly and see what you get in the browser. Or use Firebug. It makes it very easy to see what your AJAX calls are returning. On 4/12/07, Chad McCue [EMAIL PROTECTED] wrote: Here are my conclusions and hopefully someone can figure this out for me. Is there anything special I have to do server side to be able to call a cfc? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cf_htmlemail
That tag is from back when dinosaurs ruled the Earth. My Multimail tag attempted something similar, but it went a step further and converted html into usable, legible plain text... achieving success up to a point. cf_htmlmail requires your input of two different message versions. I dropped attempts at doing this quite some time ago. There were just too many browser-based web mail clients and such that blew a gasket on seeing what was CF's version of multipart mail. Got tired of messing with it and just started relying on cfmail type=HTML and the problems my clients had simply stopped. Haven't had a need to revisit the issue in years. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Opensource Web Analytics
On 4/12/07, Dwayne Cole [EMAIL PROTECTED] wrote: I use a modified fusebox framework (all request go through index.cfm) will google analytics still work? Yes, GA can figure this out. We use GA on the Fusebox site - which is, of course, a Fusebox application - and it works really well. You can - optionally - specify slightly different JS for the GA tracker code if you want labeled pages instead of URLs. We use the fuseaction as the label... -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Tons of records - archive, or what?
If you are properly configured and indexed on your SQL machine it won't be as a big a problem as you may think. For some good insight visit http://go-gaia.com and phpbb.com. The founder of that site posoted some mysql tuning tips but they can apply to other Dbs as well. Go-Gaia is a roleplaying like community with msg boards and games and stuff. At any given time they have something like 3k to 20k people online and sommething like 10 million database records etc. ranted now they are clustered but they weren't at one point. If you still need to go that route the archive table doesn't sound that bad. I've seen an application that only kept 30 days worth of archive in the live system and every night a scheduled task rolled off a day over to the archive mirror table. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Tons of records - archive, or what?
sorry for the typos, I've been under the weather all week lol. anyhow the url is really http://www.gaiaonline.com/ now. sorry. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Report Building? Any Options or Solutions
I am working with RB and have ran into a problem which I am unable to solve. My Report has 6 SubReports which I would like displayed one right under the other however I as a developer do not know how much space to give each subreport and this report will be used as documentation within the educational market. At the present time I have text within various subreports overlapping and would like to know if this can be solved if it can not be solved, is their anything in existence that can create semi-complex reports which will be displayed via the web. The educational agency that this application is for can not afford Crystal Reports so moving to that is out of the question. What are people doing to create professional semi-complex reports for their applications. -- This message has been scanned for viruses and dangerous content by our email content filter. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Webservice Issue
You can also refresh the webservice from within the CF Administrator. On 4/12/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Thanks Kevin, I rebooted the box a few moment ago and it kicked into life after that, so perhaps you're right. I'll keep that code handy for future, thanks. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Hostmysite down...
Thats ok, i dont get here much either. Im not sure what the issue is, I get the errors emailed to me and bring up the site and its all working, just not the cart and the cart has its own db (mysql not access) I would really like to move this site to my vps server and see how it does. back to the thread All the technologies seem to have a hard time with shared servers, what I would like to see is cfm have a special server license for shared servers BUT limit the number of sites it can run. By doing that if makes it more affordable to buy more copies so the hosts can buy more and have less sites on them so they have a chance to run better. Must be the Apple user experience in me speaking out. Say if you could only have 25 sites on a server at once it would (in most cases) make for less crashes and improve the cfm experience which would help make it more desirable instead of cramming a zillion sites on it and having it crash and have ppl thinking its junk. Sorry for the late reply on this, I only check this list over the web interface which has been down. But didn't want to let this go without a response. If you are getting that many timeouts a day, you have something else going on, because that is certainly not typical for my software. Generally when I see this it's due to someone trying to run on Access with too much traffic...or someone else is tying up a shared DB connection regularly and causing the software to timeout getting connections. There's nothing inherent in the software that will cause timeouts but like most really complex ecommerce applications, it's pretty DB intensive and that's always more noticeable in a shared environment. My customers that run on dedicated servers simply don't have the same problems. What is interesting to me though is that code base really hasn't changed in the last 3 years...but I really didn't see this problem much at all until the last year or so. I'm not sure if that's something in CF7 that causes it to not work as well for shared servers, or if web hosts are just loading more sites and it just can't take the load. Or maybe something else altogether about that environment. And yes, I've got a lot of changes to improve performance of the application coming...but they really would have minimal, if any effect on such problems. They make the pages load a lot faster...but if ColdFusion can't get a DB connection, there's not much I can do about that (other than handle the resulting error). There's only so much I can do software-wise, short of dropping the vast majority of features and giving people a bare-bones application that does very little. --- Mary Jo ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Tons of records - archive, or what?
Just joined up thanks for the info dana! I did find some performance info thru googling. I can't even query 200,000 records without my db givin out. Weird! Thanks,Will ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4