Re: Long running process - cflock & cfthread
You could use java to manage this, take a look at creating a "guarded block": http://java.sun.com/docs/books/tutorial/essential/concurrency/guardmeth.html HTH, Rich ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309782 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: writing protected CF with CFStoredProc
In your example you are altering the behavior of the query based upon input which does not affect injection attacks. The idea of protecting against injection attacks is to stop invalid values from being executed within the query/SP. Take for example this query: delete from customer where customerId = 1 if this query were parameterized from CF without cfqueryparam you would have: delete from customer where customerId = #customerId# If someone were trying to inject sql they could inject "1;drop customers;" as the parameter and without the queryparam, it would be executed literally as the following and drop the customers table: delete from customer where lastname = 1; drop customers; To prevent this we utilize cfqueryparam which parameterizes the query that is passed. As I understand it, this informs the database that the value being passed is of a specific datatype. So in the previous example: delete from customer where customerId = In essense, the database sees this as: declare @custId int set @custId = 1 delete from customer where customerId = @custId This has the benefit of not allowing the additional SQL to be injected, and I just learned recently, it also creates a parameterized query which on SQL server creates a cached query execution plan, minimially increasing performance. HTH, Rich ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309467 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Easy way to dump contents of a CFC?
>> Is there an easy way to see the values stored in CFC? In my CFCs I place all instance variables into an "instance" struct. Then I can use: If you place everything in the variables scope, you can use: Keep in mind that this will also display all methods of the CFC as well. >> Does it work recursively, so if a cfc member points to another cfc instance, then that cfc is "dumped" in the same way? Unfortunately, any composite CFCs will display in their 'object' representation, unless you build a recursive getMemento method, and each child object would have to support that interface. HTH, Rich ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309463 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Why do I need getters/setters?
Will, Many of the ideas within OO are to promote encapsulation, easy reuse, and increased maintainabilty. In your example, it may be much easier to submit a form to a page that takes those values and adds them to the database. But for example lets say you are storing a "customer", and that you must ensure that there are no illeagal characters in their name. In your example, this can easily be done inline in the page, but what if you have multiple places where a customer can be entered? What about the SQL necessary to store this customer? Using OO, each of these operations is in exactly one place, and all your other code leverages that single place. This is one of a myrid of problems that OO attempts to solve. You gain flexibility and maintainability but at the cost of an increased learning curve and additional complexity. HTH, Rich ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307978 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC confusion. please help!
Lori, The reason that some people discourage the use of a query object as a return type is due to the fact that it binds whatever uses that query object directly to the database (more specifically, to the columns in the database). The use of setter/getter beans should be familiar to your boss; under the java design pattern "Transfer Object", and are used as a mechanism to transfer the data in an encapsulated fashion. Return types are used in CFCs to create a strongly typed system. There are many debates on strong typing variables within CF (see duck typing), so you will have decide what best fits your team and development style. "Gateway objects" refer to a design pattern that has grown within the CF community, and refers to an object that manages all aggregate database interaction, while a DAO (data access object) manages persisting a single object. Many of the problems that come up in traditional java OO application development apply directly to CF and many can be solved using the same solutions and design patterns. Conversly, there are also new prolbems that are introduced using CF that must be solved in much different ways. A concrete example would be in java it is typical to create large object graphs (nested sets of objects), where in CF you must limit the depth of the graph as there are high object instantiation costs. Good luck! Rich Kroll ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307956 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SMS Event Gateway - encoding problem?
> > Hi Rich, > > this is coz charactor map supported by carrier > > when i faced such issue wiht other charactor at that time i just ask them > about this only like what exatly charactor map they are supporting > > if they are supporting GSM default then you will need to see if this > charator comes under if yes then they have problem while decoding if it is > not there then you will send to as 8 bit msg > > hope this will help > > regards > > Jignesh Kakkad The character is present under GSM 03.38. Under the existing solution we utilize a java SDK provided from our aggregator and it gets delivered just fine (which from sniffing the traffic is an HTTP POST). When we attempt to submit the same message bound to the aggregator via SMPP, we encounter the problem. >From a CF perspective, we are sending the exact same string using each method with the default encoding. Any Ideas? Rich ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307110 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Asynchronous Web Service Response
> One step in the CFC involves adding a record to a table which will be > processed later during a scheduled batch process. Is there anyway to > send a final response back to the client after this record has been > processed via the batch? If your clients are more technical, you could have the client provide a 'callback' web service when they invoke the original call. So for example, if your web service method signature looked like: updateEmployee(employee_id, first_name, last_name) you could update it to: updateEmployee(employee_id, first_name, last_name, callback_url) It is now possible when you run your batch, to return an xml packet to the callback url (you could include status, etc. in the packet). If this solution is to technical for your clients, then Bryan's suggestion of a getStatus(employeeId) which would allow your clients to poll the application seems to be the best solution. HTH, Rich ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SMS Event Gateway - encoding problem?
Hello all, Has anyone run into a problem delivering a US dollar sign through the SMS Event gateway? A coworker is trying to move a legacy app to utilize the SMPP SMS gateway from a proprietary API, and has found that when trying to send a '$' that there is some type of encoding problem. On some carriers the '$' is replace with '?', while on other carriers the message simply cuts off where the '$' was encountered. Is there a different way we need to encode the text to get around this? Thanks for the help! Rich ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Spry validation
Hey all, Does anyone know a way within Spry to invoke the default validations from within a custom validation function? What I am trying to do is verify that the end date is prior to the start date: The problem with the above code is that it does validate that the current date is greater than the end date, but it fails to check that the entered date is valid. For example, if startDateInput.value = '3/18/2008' and the value passed in to this function is '3/39/2008'. Spry's built in validation would flag this value as invalid while JS parses the date as April 8th, 2008. What I'd like to do is to utilize the existing date validation offered by Spry, but to add additional logic for each specific use case. I would like to add something like: if ( endDate.validate() ) { // use spry to test validation first return false; } ⦠continue with custom validation Has anyone found a way to accomplish this? Thanks! Rich ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301494 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Java Dependencies - CF7 to CF8
Hello all, In our environment, we are using an open source java application to manage some job scheduling (http://www.opensymphony.com/quartz) and are now experiencing problems when upgrading to CF8. The problem revolves around the required dependencies for Quartz (namely the Apache Commons libs). These libraries were not present in CF7, but are in CF8, except that they are an older version than what is required by Quartz. We do not want to upgrade the versions used by coldfusion for obvious reasons. Can anyone recommend an approach to how we can make these libs available to Quartz yet not change the CF install? Is a way to put these classes / libs into a different classloader and still expose them to CF? Rich Kroll ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Java Dependencies - CF7 to CF8
Sorry if this is a duplicate, my post has not appeared after an hour. Hello all, In our environment, we are using an open source java application to manage some job scheduling (http://www.opensymphony.com/quartz) and are now experiencing problems when upgrading to CF8. The problem revolves around the required dependencies for Quartz (namely the Apache Commons libs). These libraries were not present in CF7, but are in CF8, except that they are an older version than what is required by Quartz. We do not want to upgrade the versions used by coldfusion for obvious reasons. Can anyone recommend an approach to how we can make these libs available to Quartz yet not change the CF install? Is a way to put these classes / libs into a different classloader and still expose them to CF? Rich Kroll ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: In totally over my head with OOP and extends (OT?)
I recently ran into a lot of the same head scratching that you are currently tackling. I'm going to preface this with the fact that I am relatively new to OO in CF as well and this is by no means gospel! I started by modeling the domain, that is creating the objects I could easily identify. In your case, I would begin by modeling a single user, then creating the more specific objects like worker and manager, then move on to creating a project and an assignment. After creating each of the specific objects that model "things" in my app, I then created DAO objects. Once you have all the pieces, it then becomes a job of how they fit together. In my case I created two objects to manage aggregate access and another to manage access to that specific object type; a gateway and a service object. The gateway is intended to process all aggregate information on each object, and the service object is used to interact with the individual object. Here is a possible object architecture (indented items are composited objects): project.cfc - Project Bean - ManagerArray (will store the manager object(s) of this project) projectDAO.cfc - Data access object for a project projectService.cfc - Manages access to the project data (an example method would be projectDAO.read(project) - projectDAO - project projectGateway - Manages aggregate access to projects user - Generic user object that contains: - projectArray userDAO - Data Access Object for users userService - generic user access service - user - userDAO userGateway - Manages aggregate access to users manager extends user - more specific manager object - WorkersArray managerDAO extends userDAO - data access object for managers managerService - manages access to manager object managerGateway - Manages aggregate access to managers worker extends user - assignmentArray workerDAO - worker DAO object workerService - manages access to worker object assignment - specific assignment object assignmentDAO - DAO object for assignments assignmentService - manages access to the assignment assignmentGateway - manages aggregate access to assignments With this method, once all objects are created and populated with data, you can access the data in flexible ways. You asked how you could get the following structure: Worker Project1 Assignment1a Assignment1b Project2 Assignment2a Assignment2b Considering the worker has an array of it's project stored internally you can loop over that array, and then use the assignment service to return the assignments for that specific project. Something like: #worker.getName()# project: #projects[i].getName()# assignments: #assignements.name# I hope this gives you some ideas that will help you move forward. If anyone else has any input on this type of an architecture, I'd be glad to hear about it! Rich Kroll Application Developer -Original Message- From: Joelle Tegwen [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 10, 2006 10:06 AM To: CF-Talk Subject: In totally over my head with OOP and extends (OT?) I'm a (soon to be) former ASP programmer with a little training in Java trying to do OOP as I learn CF and I've got a "how the heck does this work" question. I'm happy to go RTFM if I only knew the question I'm asking. So if there's some FM I should go read just point the way. :) And maybe it's just totally off topic and I should go to some other list with this question (or some kind soul will pity me and help me anyway). I'm learning CF with this little time tracking application. It's got Manager.cfc (extends User) and Worker.cfc (extends User). There are Projects, Managers administer Projects and Workers contribute Effort to meet a given (percent effort) Assignment. So the way I'm looking at this is that Managers have Projects, but so do Workers. But a WorkerProject (extends Project) has Assignments (which have Effort) and a ManagerProject (extends Project) has workers. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240096 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF, OO, & Thread Safety
Dave, I guess I did a bit too much snipping when I put my code in the email, but I always var scope all variables. Next time I guess I'll just put the full code in ;). You said that the only time I'd need a lock would be when I've got an instance stored in shared scope. So considering that my user object in this case is not stored in any shared scope, as long as I'm correctly var'ing each query for the read / write operations, I won't have to worry about any type of race conditions? Rich Kroll Application Developer |-Original Message- |From: Dave Ross [mailto:[EMAIL PROTECTED] |Sent: Saturday, April 29, 2006 10:42 PM |To: CF-Talk |Subject: Re: CF, OO, & Thread Safety | |Ouch, no!!! where/who told you to lock like that? You are making your |application single-threaded by doing that! | |You need to var-scope the name of your query. This will make your DAO's |read thread-safe without syncronizing the calls (making it single |threaded). The ironic thing is that the read() method you posted ISN'T |actually thread-safe, because you didn't local var scope the "user" |variable, thus it becomes an instance variable of the DAO and then could be |overwritten by another request before your method gets a chance to return |it. Here's an example of thread-safe code: | | | | | | | | -- query user | | | | | | | | | |So, no, you don't need to lock anywhere. The only reason to use a lock is |when you have a CFC instance stored in a shared scope (e.g. application |scope) and that CFC has properties (aka members aka instance data) which |you need to read and write after the object has been created. You'd need to |syncronize the access to those properties and thus you would use a named |lock for the writes. This usually isn't the case with shared-scope objects |like gateways, DAOs, services, etc because their methods don't modify |instance data, thus you hardly ever need locking in an OO CFC app. | |Also, I'm not sure why your "gateway" would be calling a DAO. While it's |just naming, it would confuse me if I was looking at your code. Gateways |provide aggregated access to data (e.g., they return queries or similar |datasets), while DAOs provide persistance methods (CRUD) for individual |objects. | |Hope that helps... | |Dave Ross |http://www.d-ross.org |http://www.coldspringframework.org ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239137 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CF, OO, & Thread Safety
Hello all, I have a question about thread safety and some objects I'm developing. Lets say for example that I've got 3 objects: user.cfc, userDAO.cfc, userGateway.cfc. My user.cfc acts as a bean, only populated with data from my userDAO object. The DAO object has basic querys to the db based on a user_id. It has code something like this: -- query user The gateway object has code similar to the following: If I put the gateway object into the application scope, I know that I'll have to lock the query to get the user data from the userDAO, but is there going to be any issues with thread safety from the userGateway object when calling the getUser function? Rich Kroll Application Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239074 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Question about counting in SQL
Chris, This should get you the results your after: SELECT a.AuthorID, a.AuthorName, COUNT(b.book_id) AS NumBooks FROMAuthor a INNER JOIN Book b ONa.AuthorID = b.AuthorID WHERE b.ACTIVE = 1 GROUP BYa.AuthorID, a.AuthorName HTH, Rich Kroll Application Developer > I have a table of authors, and a table of books. They are joined on an > AuthorID. I am trying to display a page that contains a list of > authors and the number of books that each author has written, and the > only way I've found to do this seems entirely inelegant. > > Here's is essentially how I have these queries set up: > > > SELECT AuthorID, AuthorName > FROM Authors > > > > > SELECT COUNT(*) AS NumBooks > FROM Books > WHERE Book.AuthorID = #qAuthors.AuthorID# > AND Book.Active = 1 > > #qAuthors.AuthorName# (#qBooks.NumBooks#) > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238871 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: invoking components in sibling folders
Is components directly off the web root? If so you will be able to access it. In your cfinvoke, you have "component" instead of "components", that might be your problem. HTH, Rich Kroll Application Developer > I have a folder structure that looks like this: > components > -actions > f createUser.cfc > -controller > f createUser.cfc > -view > f roles.cfc > > I'm trying to call roles.findAll from controller.createUser > > I thought it would just be this: > returnvariable="roleStruct.roles"> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238779 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF not seeing tables
I know we've been having intermittent problems with the standard MM JDBC drivers that shipped with CF. In random spots it would choke on tags (from what I've been able to google anyhow). I'm hoping that when we move to the MS JDBC drivers that it will clear up this issue as well, I'll let you know. Rich Kroll Application Developer -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 04, 2006 5:49 PM To: CF-Talk Subject: Re: CF not seeing tables > Hey all, > I've been seeing some strange behavior from our CF server > over the past week > and I was hoping someone here could shed some light on > what's going on. > We're currently running CF 7 on a win 2k box attached to a > MS SQL 2000 > database. Periodically our pages will throw an error > saying that a table > does not exist. I can query this table through QA, and > when I restart the > CF service, all returns to normal. Has anyone else > experienced anything > like this? > Rich Kroll > Application Developer Like this, yes. Have a solution, no. I know that I've seen instances where the JDBC connection will produce an empty resultset when fetching the column information for a table which I know exists. Recreating the JDBC connection object and executing the same statement again with the new object produces the desired results, which I'm guessing is basically what's happening when you restart the CF server service (since as I understand it CF maintains one open connection for each dsn and of course they all go away when the CF service shuts down). If you have any luck isolating your issue, please let me know. :) s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236969 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CF not seeing tables
Hey all, I've been seeing some strange behavior from our CF server over the past week and I was hoping someone here could shed some light on what's going on. We're currently running CF 7 on a win 2k box attached to a MS SQL 2000 database. Periodically our pages will throw an error saying that a table does not exist. I can query this table through QA, and when I restart the CF service, all returns to normal. Has anyone else experienced anything like this? Rich Kroll Application Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236961 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cftransaction
Doing well, lots of fun new things on the horizon! How've you been? Btw, it's good to see you on here. Rich Kroll Application Developer -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 04, 2006 10:56 AM To: CF-Talk Subject: RE: cftransaction Hey Rich, how are things at Site? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236959 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cftransaction
In MS SQL I've seen two ways to handle returning the last inserted primary key: INSERT INTO t_doctors (#ColNames#) VALUES (#preserveSingleQuotes(ColValues)#); SELECT SCOPE_IDENTITY() AS newpkey; This will return the last inserted primary key for the current scope (session), so there is no concern of race conditions. INSERT INTO t_doctors (#ColNames#) VALUES (#preserveSingleQuotes(ColValues)#); SELECT @@identity AS newpkey; While this will return the last inserted primary key across scopes (sessions). Using @@identity will leave you open to potential problems with race conditions. This is from information I've read in the BOL as well as been informed from our DBA. I can say that when using SCOPE_IDENTITY() I've never found any errors under load, but if anyone else has any input I'd love to hear it. Rich Kroll Application Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236877 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: More Sorce Control
I think I understand now, thanks for the clarification on how this process would work. I can now see how this process would work as well as the true benefits of getting this set up correctly. Thanks all -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 28, 2006 7:20 PM To: CF-Talk Subject: Re: More Sorce Control Regarding your different workspaces, every developer and QA person should have their own personal working directory checked out. The QA people will be switching their working directories between branches all the time, while the developers will be switching far less (primarily back and forth between the trunk and their active branch). cheers, barneyb ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236371 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: More Sorce Control
Michael, Thanks for your response. Can I ask how you implement promoting branches to a QA environment? As it stands for us now, we have one set of code in a directory on another server that we use for testing, and have built a CF engine to roll back files if they fail QA. We currently have quite a few people working in QA that are testing different tasks yet all work on the one unified code set. If we promote these branches to testing, would it still be one code set, or would we need different virtual directories to test the different branches? We're currently using DW8, but are considering moving everyone over to eclipse for it's integration and amazing price point ;) Again, thanks for your help in getting me to understand the theory of how this type of setup would work. Rich -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 2:20 PM To: CF-Talk Subject: Re: More Sorce Control Hi Rich, You need to consider using branches. These let you isolate a set of changes from the trunk. A branch can be developed and tested and QA'd separately then when signed off can be merged back to the trunk. At this point it does need retesting because of an subsequent changes. Small issues can be fixed on the trunk. You then tag the trunk at a stable point for a release of one or more merged changes. This way different changes can be merged only when they are ready and until then stay on their branch. This is how we work and our pattern of releases sounds similar to you. There are other patterns for using branches that suit other development modes. BTW Eclipse makes the merges nice and easy! On 3/27/06, Rich Kroll <[EMAIL PROTECTED]> wrote: > > Hello all, > We are currently working on implementing a new source control system and > are > turning to SVN as our original VSS system was not meeting out needs. We > -- Mike T Blog http://www.socialpoints.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236367 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
More Sorce Control
Hello all, We are currently working on implementing a new source control system and are turning to SVN as our original VSS system was not meeting out needs. We have the development side worked out, but our problem comes when we start to consider QA. The way our codebase and development works is that we have continuous development and QA. We don't have any specific type "release". We generally have more of a tag release type of promotion, where sets of pages / objects get promoted daily. While one tag is being QA'd, someone else might create another tag that uses some of the same files. To exemplify our problem consider the following example: Developer A creates a tag set with the following files: - FileA.cfm - FileB.cfm - FileC.cfm Developer A then sends his tag to QA, and QA starts testing this tag. Developer B creates a tag set with the following files: - FileC.cfm - FileD.cfm - FileE.cfm Developer B finishes their changes and merges their changes back to the trunk. Then sends his/her task to QA. At this point QA finds a problem with Developer A's tag set and pushes it back to the developer to fix. In this scenario, Developer B has finished their work on the tag set, but it has inherent problems because of the problem with developer A's work. When developer A returns to fix their problems, the code has changed and now contains developer B's code, which has not passed QA, so you cannot promote one without the other being included. Am I over thinking this problem? I can't seem to see a way to allow this type of incremental release structure without opening a can of worms once code starts to get to QA. Has anyone else run into this type of problem before? Rich Kroll Application Developer SITE Manageware, Inc. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236268 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Odd Error with Dreamweaver8
I've run into a similar problem before, and if it's the same problem, it's not DW8, its CF. We had to delete the class files that CF had generated before the server would "see" the new file and process the changes. HTH, Rich Kroll Application Developer -Original Message- From: Eric Roberts [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 3:32 PM To: CF-Talk Subject: Odd Error with Dreamweaver8 I am getting a very odd error with DW8. I save a file after making a change. The file and changes are definitely on the server (checked it with notepad), but when i fire it up in IE, I get the old code...sometimes even an old error with the new code. It's not a browser chche issue as I have my cache shut off and it was also the same on a different computer. Here's some examples... I made an oops and forgot to change a value from get_table.form to get_table.recordcount. I get an error saying that form is not an element of get_table. I change it to rcordcount and I get the same error, but the new code is listed on the error page. Another problem is a change just doesn't come up and it shows the old code. It's seems like a caching issue, but nothing is getting cached as far as i know. This does not happen when we are using DWMX. i am not sure what the correlation is, but it is bizarre. Eric ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233758 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
and includes
Hello all, I'm getting this error when trying to include a page that includes a tag You have called CFFLUSH in an invalid location, such as inside a CFQUERY or between a CFML custom tag start and end tag. Inside the page, the offending area of code is: Is there a way to get this page to run via an include call? Rich Kroll Application Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229227 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: A Contractor or Two
One thing I've found that you should watch out for is the concept of giving away "free" or "low flat-fee" type projects is the clients will be blown away by your work, and then expect to receive the same fees when coming back with further work. In my experience, I've found it better to charge the full amount as a line item, then to give a "new account" discount on those first few projects to help build loyalty, that way they get a feel for what the project would have cost without the discount, and that in the future know that this discount will not be applied. Rich Kroll Application Developer -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 28, 2005 6:30 PM To: CF-Talk Subject: Re: A Contractor or Two Matt, I've been asking a similar question to no avail. I'm glad someone started this thread over here. As it seems from your post that you have quite some experience doing this on your own. I just wanted to ask some advice of you. Do you suggest having a set hourly rate, set in stone? Like for example, $35/hour. I guess what I am wondering is if there should be different rates based on, project planning, as opposed to actual development? Next, should there be a different rate for database development, versus application development (PHP, ColdFusion, Java coding), versus graphic design, versus straight html. Also do you recommend "padding" hours, based on the above (padding slightly higher for database, or CF Code, as opposed to html). I'm trying to establish a loyal customer base, in baby steps. I'll sometimes do small projects for free, or for a very low flat-fee, to start. I'm hoping that once they are blown away by the results, I'll get referrals, and the clients will be more than happy to pay a higher rate based on proven results. Cheers --Ali >If the issue is whether or not you can quote a standardized rate to a >client, my answer is an emphatic "yes", and no, don't be greedy as in >set the price on a job-specific basis. > >Often my clients hear me say that there are only two types of jobs: >"Brain surgery" and "Legwork". Brain surgery equates to "I don't know >how I'll deliver that but having been a paid programmer for 23 years, >I'll be able to figure it out." Legwork is "yeah been there done >that... no problem." > >Either way this, to me, is just a function of time spent. I place a >value on my time that I am happy earning no matter the task presented >to me. So I make money. More importantly, the client comes back for >the next job (and the next and the next...) because you have given >them a baseline that they know they can count on. Your code spoke for >itself so between the two you get customer loyalty that becomes a >snowball rolling downhill. > >This strategy -- billing straight time at a single rate -- has worked >so well for me that I'm now consistently booked solid. Actually have >more work than I can handle, and all from long-term clients. First >tried stemming the tide with a judiciously applied 50% rate increase. >When that didn't work, I had to stop taking new clients. I'm still >backed up at least a month. > >-- >--mattRobertson-- >Janitor, MSB Web Systems >mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227856 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Running a DTS package with CF
I found this when trying to accomplish the same thing, applies to CF / ASP http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS Rich Kroll Application Developer SITE Manageware, Inc. 2841 W. Cypress Creek Rd. Fort Lauderdale, FL 33309 [EMAIL PROTECTED] 954-944-9020 x716 -Original Message- From: Anthony Prato [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 28, 2005 6:49 PM To: CF-Talk Subject: Re: Running a DTS package with CF try searching google for DTS and asp, I think I saw a solution that way that may be applicable to CF too. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227855 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Java substring
I stumbled onto a site that had a few of these undocumented features of CF. The URL for any that are interested is http://www.activsoftware.com/mx/undocumentation/ Rich Kroll Application Developer -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 27, 2005 7:01 PM To: CF-Talk Subject: RE: Java substring Well there u go, learn something new every day, I didn't know you could directly access java functions like that. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227749 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Java substring
I got the function to work, it was a matter of needing to javacast() the numbers before passing them to the substring() function, here is the final code for anyone interested. I am using this function to get specific html elements from a page. In my case the needed elements are wrapped with specific tags. For example: function stripPrice(pageHtml, prePriceString, postPriceString) { // look for the prePriceString preStringLoc = pageHtml.indexOf(prePriceString); if(preStringLoc eq -1) { msg = "Coulden't find the prePriceString " + prePriceString; throw(msg); } // Found the prePriceString, so look for the post postStringLoc = pageHtml.indexOf(postPriceString, preStringLoc); if(postStringLoc eq -1) { msg = "Coulen't find the postPriceString " + postPriceString; throw(msg); } returnPrice = pageHtml.substring(javaCast("int",preStringLoc + prePriceString.length()), javaCast("int", postStringLoc)); return returnPrice; } Hth, Rich ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227727 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Java substring
This is where I'm currently at: function stripPrice(pageHtml, prePriceString, postPriceString) { // look for the prePriceString preStringLoc = pageHtml.indexOf(prePriceString); if(preStringLoc eq -1) { msg = "Coulden't find the prePriceString " + prePriceString; throw(msg); } // Found the prePriceString, so look for the post postStringLoc = pageHtml.indexOf(postPriceString, preStringLoc); if(postStringLoc eq -1) { msg = "Coulen't find the postPriceString " + postPriceString; throw(msg); } returnPrice = pageHtml.substring(preStringLoc + prePriceString.length(), postStringLoc); return returnPrice; } And I keep getting errors that "The selected method substring was not found", any ideas? Rich -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 27, 2005 5:22 PM To: CF-Talk Subject: RE: Java substring This works for me: #str.subString(0, 8)# WriteOutput(str.subString(0, 6)); Post your code, it might be something else. Ade ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227724 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Java substring
Hello all, I'm trying to return a portion of a string and thought that someContent.subString(startPos, endPos) would work via cfscript. But I get an error that the selected method does not exist. Is there an easy way to access this function through Java and cfscript? Rich ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227718 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
OT: MSSQL DTS Help
Hello all, Sorry for the OT, just hoping someone here might have some experience with this. I'm trying to create a DTS workflow, and am not sure if this is possible or not. We have three servers, development, staging, and live. I'm looking to promote certain elements of a database to the next server via DTS. I can create a package inside the specific database, and run it and the upload works as expected. Considering I have hundreds of individual databases, I'm hoping I can create one DTS package and somehow pass it a database name to run against to promote these elements. Has anyone worked with this type of thing, or can someone point me in a direction to find some info on this type of dynamic DTS? Thanks Rich Kroll Application Developer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226607 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Passed Varchar list
I'm getting these values passed from an existing form. And they are passed as '1,2,3'. And treated as a nvarchar(100) when passed to the existing sp. I've got to handle these inside my UDF (unfortunately). Any ideas on how I can transform them to '1','2','3' from the string '1,2,3' that's passed? Rich Kroll Application Developer -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 06, 2005 1:42 PM To: CF-Talk Subject: RE: SQL Passed Varchar list If you are using CF to pass in your list, you can use CFQUERYPARAM's LIST attribute. Otherwise, you need to have single quotes around each element such as: ('1','2','3') M!ke ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SQL Passed Varchar list
Hey all, This seems really simple but I'm a bit stuck and was hoping someone could help. I've got a SQL UDF in MSSQL that has a variable @list that is declared as nvarchar(100), and I want to be able to pass a value list to it (eg. 1,2,3). I'm using this in my where clause in my query (eg. WHERE ID IN (@list)). My problem is that since it's treating the list of integers as a string I get errors in the query. If I manually set ID IN (1,2,3) the query works as expected, but not as ('1,2,3'). Is there a valuelist type function in SQL to convert this? Or is there perhaps a regex type solution? Thanks, Rich ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226244 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: bye MM :( :: welcome Adobe :)
Wow, you gave your boyfriend a ColdfusionMX shirt, that's pretty cool. Your really cute, but you really need to work on your taste in guys..... Rich Kroll Application Developer -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Monday, December 05, 2005 4:30 PM To: CF-Talk Subject: Re: bye MM :( :: welcome Adobe :) yes will I forget how umm *choke* "handsome" ur lol lets see now, the disruptor hangs with girls like http://www.jamwerx.com/da_mega_stud.jpg and now lets see your jeri-curled delight hehe ~Dave the disruptor~ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226108 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Strange CFC behavior
Yes, all the methods are in the same component. I'm getting no errors at all, which is whats making me pull my hair out. When I test this I'm doing the following: #user.getLogin()# This will display the user name "test" on the page, and will not error when I run the create user function. When I look at the database, the dates have been inserted, and spaces for the login / pass / name(s), not null values. I'm at a complete loss why this is happening. Rich Kroll Application Developer SITE Manageware, Inc. -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Friday, November 18, 2005 2:17 PM To: CF-Talk Subject: Re: Strange CFC behavior Are the methods you are calling in the same component as the createUser method? I guess they must be if you can call variables.instance.something and get the value... You arent getting any errors thrown? On 11/18/05, Rich Kroll <[EMAIL PROTECTED]> wrote: > Hello all, > I'm having a weird problem. I've crated a user.cfc that manages all my user > information. When the object is created I put all relevant information into > the variables scope like: > > > > > Then I have crud operations to populate the variables: > > > > > > > > > > > All of this works as expected when I create a new user object. If I set the > login with user.setLogin("test"), I can call user.getLogin(), and it returns > the value that I stored via setLogin(). > > My problem comes when I try to write this to the database. I've got a > createUser function that does an insert statement, and when I force it to > error, the generated SQL is correct, I can run it in query analyzer and it > inserts correctly, but when I run the function, some functions are inserting > the correct data, while anything with a string is not. I also created a > checkUser() function to ensure that the functions are not being returned > empty. Below is my createUser function: > > > > > INSERT INTO users (login, > password, > first_name, > last_name, > date_expires, > date_created, > created_by, > updated_by) > VALUES ('#getLogin()#', > '#getPassword()#', > '#getFirstName()#', > '#getLastName()#', > "">NULL#getDateExpires()#, > #getDateCreated()#, > #getCreatedBy()#, > #getUpdatedBy()# > ) > > > > > > > > When I run this query, the login, password, first_name, and last_name are > inserted as empty strings. If I change for example getLogin() to > variables.instance.login it will insert correctly, and all this function > does is return the exact same thing. Anyone have any ideas whats going on > here? > > Rich Kroll > Application Developer > SITE Manageware, Inc. > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224677 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Strange CFC behavior
Hello all, I'm having a weird problem. I've crated a user.cfc that manages all my user information. When the object is created I put all relevant information into the variables scope like: Then I have crud operations to populate the variables: All of this works as expected when I create a new user object. If I set the login with user.setLogin("test"), I can call user.getLogin(), and it returns the value that I stored via setLogin(). My problem comes when I try to write this to the database. I've got a createUser function that does an insert statement, and when I force it to error, the generated SQL is correct, I can run it in query analyzer and it inserts correctly, but when I run the function, some functions are inserting the correct data, while anything with a string is not. I also created a checkUser() function to ensure that the functions are not being returned empty. Below is my createUser function: INSERT INTO users (login, password, first_name, last_name, date_expires, date_created, created_by, updated_by) VALUES ('#getLogin()#', '#getPassword()#', '#getFirstName()#', '#getLastName()#', NULL#getDateExpires()#, #getDateCreated()#, #getCreatedBy()#, #getUpdatedBy()# ) When I run this query, the login, password, first_name, and last_name are inserted as empty strings. If I change for example getLogin() to variables.instance.login it will insert correctly, and all this function does is return the exact same thing. Anyone have any ideas whats going on here? Rich Kroll Application Developer SITE Manageware, Inc. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224665 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: and application.cfm
*looks sheepish* Next time I'll be _fully_ reading the docs before I post. Anyone have a way that I can enable the custom prefix of a tag library within every page of my site, including includes? Rich Kroll Application Developer SITE Manageware, Inc. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, November 17, 2005 10:58 AM To: CF-Talk Subject: RE: and application.cfm > Does anyone know of a reason why a would fail when > moved to the application.cfm? Yes, the docs say exactly that: http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h tml/wwhelp.htm?context=ColdFusion_Documentation&file=part_cfm.htm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224504 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
and application.cfm
Does anyone know of a reason why a would fail when moved to the application.cfm? I've created a set of UI components that we're going to be using site wide, and am importing them as and then using them in pages via and when I had the cfimport calls at the top of the page, it worked fine, but when I move it to the application.cfm it is no longer functioning. Anyone have any ideas? Rich Kroll Application Developer SITE Manageware ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224498 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Module Security
Can you give me some more info on your framework (url?). Is this an open source project, as I would love to see how you've developed some of this functionality? Rich Kroll Application Developer -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Monday, November 14, 2005 10:07 AM To: CF-Talk Subject: RE: Module Security I have created a roles based security model that is part of my framework. Create a resource. Create permissions for that resource. Create groups. Assign resourecs and permissions to that group. Assigns a user to groups. When a user logs in, all the permissions for the groups they are a member of are loaded into a session variable. I then have a UDF that checks permissions, which I can wrap around an entire resource, a page, or an object on a page. E.g. Do this #request.noaccess# And I have developed a nice UI for managing it all. -- Russ -Original Message- From: Rich Kroll [mailto:[EMAIL PROTECTED] Sent: 14 November 2005 14:23 To: CF-Talk Subject: Module Security Hello all, I am in the process of trying to develop a new security model for a project I am working on. I've developed the base model with a hierarchy of permissions to access areas of the application. My problem is that now I need to extend this to control certain modules within a page. These modules are not consistent to a specific page, or even a sequence of pages. My first thought is to have each specific module register with the system and then authenticate against that. Has anyone set up something along these lines and have any gotcha's I may be overlooking? One fear is, since this will be managed by end users, how to communicate what each "module" actually is for them to know if they want their users to have access. For example, within an existing workflow, on the third page in the process is an graph meant for administrators. Trying to explain "Process 1 step 3 graph" might get cumbersome. Any ideas? Rich Rich Kroll Application Developer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224103 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Module Security
It was mandated that I build in group permissions that could be overridden by specific user permissions, similar to the NT security model. Unfortunately, AD won't work for me because I need to lock down parts of a specific page, while still having the containing page respect different rights. Rich Kroll Application Developer -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, November 14, 2005 9:39 AM To: CF-Talk Subject: RE: Module Security Rather than create a hierarchical structure of permissions, I only use Active Directory group membership. If you are in the appropriate AD group, you have access. I can pass in multiple groups if that applies as well. It works quite well for me since our organizational structure is not very deep. Well, not deep in the respect that my security method has caused any issues. Next, I am going to give department managers the ability to add/remove members from groups. That way, they can control the security themselves. M!ke -Original Message- From: Rich Kroll [mailto:[EMAIL PROTECTED] Sent: Monday, November 14, 2005 8:23 AM To: CF-Talk Subject: Module Security Hello all, I am in the process of trying to develop a new security model for a project I am working on. I've developed the base model with a hierarchy of permissions to access areas of the application. My problem is that now I need to extend this to control certain modules within a page. These modules are not consistent to a specific page, or even a sequence of pages. My first thought is to have each specific module register with the system and then authenticate against that. Has anyone set up something along these lines and have any gotcha's I may be overlooking? One fear is, since this will be managed by end users, how to communicate what each "module" actually is for them to know if they want their users to have access. For example, within an existing workflow, on the third page in the process is an graph meant for administrators. Trying to explain "Process 1 step 3 graph" might get cumbersome. Any ideas? Rich Rich Kroll Application Developer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224065 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Module Security
Hello all, I am in the process of trying to develop a new security model for a project I am working on. I've developed the base model with a hierarchy of permissions to access areas of the application. My problem is that now I need to extend this to control certain modules within a page. These modules are not consistent to a specific page, or even a sequence of pages. My first thought is to have each specific module register with the system and then authenticate against that. Has anyone set up something along these lines and have any gotcha's I may be overlooking? One fear is, since this will be managed by end users, how to communicate what each "module" actually is for them to know if they want their users to have access. For example, within an existing workflow, on the third page in the process is an graph meant for administrators. Trying to explain "Process 1 step 3 graph" might get cumbersome. Any ideas? Rich Rich Kroll Application Developer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224061 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: We're Okay
Ike, Glad to hear you got in safe and sorry to hear about the car troubles. Hope you get settled soon so I can pester you with more pointless questions (though it will be hard since your not in yelling range). Rich Rich Kroll Application Developer -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Saturday, November 12, 2005 12:02 PM To: CF-Talk Subject: OT: We're Okay Hi all, Tiff and I are now home safe after our move. Hurricane Wilma caused more damage than we'd expected on October 24th and we were without power for our last week in Ft Lauderdale Florida (with no real hope of receiving power soon). We left on Nov. 2nd for our move to Charlottesville Virginia and promptly lost the transmission in our car and were stranded in St Augustine Florida for the following week. We're now unpacking in our new apartment and have a bed (we slept on the floor the first night and an air-matress the 2nd) and a serviceable desk and were able to achieve internet connectivity late last night. I'm just now sifting through large amounts of email before I get back to some programming tasks I've been unable to work on for the past two weeks. s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224057 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SMS Gateway
Hello all, I'm attempting to create a simple SMS gateway example for something I'm working on. I'm trying to find a carrier that can be used to test this app against. Has anyone worked with the SMS gateway and perhaps point me in the direction of more information / example code? And does anyone know a SMS service provider that has developer accounts that I can test this against? Thanks for the help, Rich Kroll Application Developer SITE Manageware, Inc. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223601 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
OT: SP & UDF parameter meta data
Hello All, I was wondering if anyone knows how I can access parameters expected by a UDF in MSSQL? I know that I can use the following to retrieve the expected parameters for a SP, but how can I do the same for a UDF? select name FROM syscolumns WHERE id = OBJECT_ID('sp_myProcedure') Anyone have any ideas? Rich Kroll Application Developer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223240 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54