help finding thread .net vs cf
Not too long ago there was a discussion on this page that compares dot net to cf. I'm trying to help a friend out and I thought there was a good objective discussion regarding this page. http://msdn.microsoft.com/library/en-us/dnaspp/html/coldfusiontoaspnet.asp?frame=true Does anybody have a link to the thread that I can point him to for a more objective view. Thanks in advance -Joshua O'Connor-Rose -All is Good __ Discover Yahoo! Have fun online with music videos, cool games, IM and more. Check it out! http://discover.yahoo.com/online.html ~| 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:208411 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
cffile without path
my cffile tag isn't bombing when written this way cffile action=append file=Presentations.txt output=blah any thoughts what file is being updated? (access to server is restricted to me so I want to communicate clearly with sysadmin) -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? Yahoo! Small Business - Try our new Resources site http://smallbusiness.yahoo.com/resources/ ~| 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:207465 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
setting up Java in CF5
I'm trying to set up CF5 to do DESEDE encryption and I'm not having much luck. So I find a java library that may do the trick but I haven't set up java objects in Cold fusion 5 before. Has anybody ever set up gnu-crypto java librarys on CF5 or anything other library. If I put the gnu-crypto.jar in the CF5 class path directory how do I initialize the object in Coldfusion or am I not headed in the right direction. The object in question is gnu.crypto.cipher.TripleDES. Any thoughts -Joshua O'Connor-Rose -All is Good __ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail ~| 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:207163 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: setting up Java in CF5
I suppose I should describe where I am now. The gnu-crypto.jar is in the folder listed in the java settings class path. I'm using create object on the page: cfscript // Create DES/ColdFusion Java objects desObj = CreateObject( java, com.gnu.crypto.cipher.TripleDES ); /cfscript and this is the error. Unhandled System exception ! java.lang.ClassNotFoundException: ClassFormatError for class com.gnu.crypto.cipher.TripleDES. Java exception occurred in call to method. Maybe the only issue is that I'm missing librarys (I only put in gnu-crypto.jar there are two javax jar files that I didn't set up because I didn't think they were needed) --- Simon Cornelius P. Umacob [EMAIL PROTECTED] wrote: Joshua, You might want to try looking up the CreateObject() function in the CF docu. I haven't used CF5 though (nor am I very knowledgeable in invoking external Java apps), but I think initializing the library in version 5 looks something like this: DES3 = CreateObject(java, gnu.crypto.cipher.TripleDES); DES3.init(); Regards, [ simon.cpu ] I'm trying to set up CF5 to do DESEDE encryption and I'm not having much luck. So I find a java library that may do the trick but I haven't set up java objects in Cold fusion 5 before. Has anybody ever set up gnu-crypto java librarys on CF5 or anything other library. If I put the gnu-crypto.jar in the CF5 class path directory how do I initialize the object in Coldfusion or am I not headed in the right direction. The object in question is gnu.crypto.cipher.TripleDES. Any thoughts -Joshua O'Connor-Rose -All is Good ~| 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:207177 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
Triple DES pre cfmx
Anybody ever implement triple DES encryption prior to CFMX, I've been using cfx_crypto and having no luck . .. . as far as I can tell. Unfortunately there are too many black boxes in the process. And I can't really provide too much detail. Or if anyone knows that cfx_crypto does what it says it does then I can stop looking as well. But if those folks that have experience could provide the information on padding the string to be encrypted that would be really great too. I was going to provide a snippet but that has keys and links and things that if I remove may still be not enough to determine anything. -Joshua O'Connor-Rose -All is Good __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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:205135 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: macromedia and Adobe?!
I'm wondering what this means for CF most of all in several ways. For instance, how will this affect Blue Dragon. Is adobe only interested in the products that are media related, and now that there is significant capability within CF to integrate PDFs and Flash why would Adobe loose interest in CF. Also what about Flex!!! that's my biggest concern I think since I was intending to head that direction. I know for a lot of folks speculation is a waste of time but I'm curious if we may hear something that would give us perhaps a calming breath. -Joshua O'Connor-Rose -All is Good --- James Edmunds [EMAIL PROTECTED] wrote: I am cancelling my Wednesday afternoon Fireworks lessons and am going take piano instead. -James On 4/18/05, Thomas Chiverton [EMAIL PROTECTED] wrote: On Monday 18 Apr 2005 15:50 pm, Burns, John D wrote: Why not? Adobe doesn't have a competitive server product? It seems good to me. Adobe has better design programs any way. I'd love to get Dreamweaver, Photoshop, Illustrator and flash bundled together instead of Fireworks, Freehand, etc. I'd rather they were kept separate (i.e. cheap). -- Tom Chiverton Advanced ColdFusion Programmer ~| 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:203264 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: Salary change when rolling permanent
Holy Cow!!! I need to reconsider my situation if this is even a high average. I've been developing CF for about 7 years and I only dream of getting the lowest figure you listed. If you want to assume that the contractor is getting paid twice what you are (If you get paid $50 an hour, they are collecting $100). I don't think it is unreasonable to expect $65-75 an hour as a full-time employee. __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.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:11:2273 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Salary change when rolling permanent
Thanks a ton, it relieves only some of my anxiety. Although I'm still below your bottom and I have a range of ability in programming (been working on perl and asp in the last two weeks). I'm still not entirely relieved. But I believe I'm locationally challenged. Chicagoland seems to be tighter on the pocketbook with CF developers. But it certainly helps. I'm giving this one at least till the first review. Thanks again -Joshua --- Charlotte Dodge [EMAIL PROTECTED] wrote: As an HR Manager / Recruiter, my suggestion would be for you to do a salary survey of your local area to determine what the current market rate is for someone with your skill set (look at www.salary.com). This will give you an idea of where to start at least. You will definately not see a salary of $65/$75 per hour as a salaried permanent employee - it is very unreasonable and not realistic. You have to account for the total compensation package including benefits, etc. You can leverege more on the base salary if you do not require medical/dental benefits, etc. This does have a value and cost to the company. On average - the mark-up on a bill rate they are probably billing you out for has been about a 75% mark-up of the rate you are being paid. On the average, CF Developers are seeing anywhere from $65,000 - $85,000 depending on experience and location. Of course, it depends on the size scope of the project, and if you are hired to do one specific thing or more long term. It is unusual to see CF Developers with a base salary of higher than $85,000, but I have seen a few earning $90,000+ that have over 15 years experience as a Developer / Architect. Of course, with the extensive years of experience - 8 or more years typically include other languages (and more often object oriented) outside of CF such as Java, etc. The Developers I tend to see with base salaries of $90,000 and above are J2EE Developers and .Net Developers. This has been the market trend for the past few years. I have seen CF becoming a very popular language and a growing market over the past 8 months. This will drive the salaries higher - as the need for CF folks overtakes the available talent in the market. It will become a candidate driven market. I am far from a Developer - but that is my take from the HR side of the house. Definately do your research on current market salary in the Tampa Bay area, market demand for CF Developers in the Tampa Bay area (often - the demand for the talent will driver the higher salaries), and benefits package being offered. One suggestion is for you to let them make you an offer, and you determine if that offer is acceptable or not based on the research you have done. You can always go back in and state that while you are not comfortable accepting the salary they are offering - you would accept $___. ~| 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:11:2280 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Session Variables
pardon if I'm asking a question that has probably been answered. But I'm wondering where exactly session variables are stored and how they relate to client variables. do CFID and CFTOKEN relate to both and if I'm doing client management with a database how do I find the record of my information in CDATA and CGLOBAL based on the cookies of my machine. -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184477 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 Java/CF dynamic method calls
Ok so things are moving along here with the salesforce api, mixing a significant amount of Java with the CFC and we are making some real progress. So thanks to Spike and Sean and Sam and Guy. A bunch. So I have a new question. I have a java object instatiated through ColdFusion that has methods based on the table that it updates. Like if the table has fields Name, ID, ProductCode then the object has methods setName(), setID(), setProductCode(). what I'm trying to do is call these methods dynamicly based on the fields that exist in the table. heres some code cfset var.field_list = this.getSObjectFields(Product2) cfset var.productArray = arrayNew(1) cfloop index=var.i from=1 to=#arrayLen(createProductArray)# cfset var.productArray[var.i] = this.loader.loadClass(com.sforce.soap.enterprise.sobject.Product2).newInstance() cfloop list=#var.field_list# index=var.fieldName cfif structKeyExists(createProductArray[var.i],#var.fieldName#) cfset var.arg_value = evaluate(createProductArray[#var.i#].#var.fieldName#) !--- Some things already tried: (I don't know why I keep trying this one) cfset var.productArray[#var.i#].#var.fieldName# = var.arg_value (if I could invoke the method using cfinvoke that would be cool but it's a java object) cfinvoke component=var.productArray[#var.i#] method=set#var.fieldName# cfinvokeargument name=#var.fieldName# value=#var.arg_value# /cfinvoke --- /cfif /cfloop /cfloop -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: more Java/CF dynamic method calls
Just to let you know I did manage to figure it out. Sometimes persistance is all you need. this seemed to work fine: cfset var.arg_value = evaluate(createProductArray[#var.i#].#var.fieldName#) cfset var.thisObject = var.productArray[var.i] cfset temp = evaluate(var.thisObject.set#var.fieldName#('#var.arg_value#')) Thanks for looking -Joshua O'Connor-Rose -All is Good --- Joshua OConnor-Rose [EMAIL PROTECTED] wrote: Ok so things are moving along here with the salesforce api, mixing a significant amount of Java with the CFC and we are making some real progress. So thanks to Spike and Sean and Sam and Guy. A bunch. So I have a new question. I have a java object instatiated through ColdFusion that has methods based on the table that it updates. Like if the table has fields Name, ID, ProductCode then the object has methods setName(), setID(), setProductCode(). what I'm trying to do is call these methods dynamicly based on the fields that exist in the table. heres some code cfset var.field_list = this.getSObjectFields(Product2) cfset var.productArray = arrayNew(1) cfloop index=var.i from=1 to=#arrayLen(createProductArray)# cfset var.productArray[var.i] = this.loader.loadClass(com.sforce.soap.enterprise.sobject.Product2).newInstance() cfloop list=#var.field_list# index=var.fieldName cfif structKeyExists(createProductArray[var.i],#var.fieldName#) cfset var.arg_value = evaluate(createProductArray[#var.i#].#var.fieldName#) !--- Some things already tried: (I don't know why I keep trying this one) cfset var.productArray[#var.i#].#var.fieldName# = var.arg_value (if I could invoke the method using cfinvoke that would be cool but it's a java object) cfinvoke component=var.productArray[#var.i#] method=set#var.fieldName# cfinvokeargument name=#var.fieldName# value=#var.arg_value# /cfinvoke --- /cfif /cfloop /cfloop -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
using jars without classpath?
Just got some new information on the project. Evidently the client is using a shared server and they have some rules. Is in possible in CF to use createObject or cfinvoke or cfobject to access java classes or .jar without them being configured in the class path. -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: translating java to CF
Did that, compiled the jar file now I'm able to create the objects . . . now I have other problems. Is there a list where I can discuss create and update issues? for sforce I keep getting this error: Web service operation create with parameters [EMAIL PROTECTED] could not be found. The error occurred in sfproducts.cfc: line 44 42 : cfelse 43 : cfset sObjects[1] = updateProduct 44 : cfset update_result = this.sfdc.create(sObjects) 45 : /cfif 46 : cfreturn update_result - -Joshua O'Connor-Rose -All is Good --- Sean Corfield [EMAIL PROTECTED] wrote: On Mon, 27 Sep 2004 13:58:46 -0700 (PDT), Joshua OConnor-Rose [EMAIL PROTECTED] wrote: We have not. I have a bunch of generated .java files from the sforce web site and I am suggesting that we just use those. Is that the direction I should take with this? You would need to compile those and put them in CFMX's classpath. Doesn't sforce.com have a precompiled JAR of the objects? Easier to put that on the classpath. Either way, CFMX needs to be able to load the sforce.com objects in order for you to be able to create those objects... -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ___ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF Array to Java array : more sforce questions
I'm feeling like I've got a near neighbor to a solution here but I keep getting an error. here's my code most going strait to the sforce example. _ cfset account1 = createObject(java,com.sforce.soap.enterprise.sobject.Account) cfset account2 = createObject(java,com.sforce.soap.enterprise.sobject.Account) cfset account1.setAccountNumber(002DF99ELK9) cfset account1.setBillingCity(Wichita) cfset account1.setBillingCountry(US) cfset account1.setBillingState(KA) cfset account1.setBillingStreet(4322 Haystack Boulevard) cfset account1.setBillingPostalCode(87901) cfset account2.setName(Golden Straw) cfset account2.setAccountNumber(003DF99ELK9) cfset account2.setBillingCity(Oaklanc) cfset account2.setBillingCountry(US) cfset account2.setBillingState(CA) cfset account2.setBillingStreet(666 Raiders Boulevard) cfset account2.setBillingPostalCode(97502) cfset arrObj = createobject(java, java.lang.reflect.Array) cfset jClass = createObject(java,com.sforce.soap.enterprise.sobject.Account) cfset sObjects = arrObj.newInstance(jClass.class, 2) !--- cfset sObjects[0] = account1 cfset sObjects[1] = account2 --- cfset arrObj.set(sObjects, 0, account1) cfset arrObj.set(sObjects, 1, account2) cfdump var=#sObjects# cfinvoke webservice = #this.sfdc# method = create sObjects = #sObjects# returnVariable = saveResults --- the error is --- Could not perform web service invocation create because AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: common.exception.ApiException: sObject type apos;Arrayapos; is not supported. faultActor: faultNode: faultDetail: {urn:fault.enterprise.soap.sforce.com}fault: INVALID_TYPE sObject type 'Array' is not supported. - which is practically infuriating because according to the documentation Creating objects involves the following basic steps: 1. Instantiate one or more individual objects within the object. For each object, you populate its fields with the data that you want to add. 2. Construct an sObject[] array and populate that array with the objects that you want to create. All objects must be of the same object. 3. Call create, passing in the sObject[] array. 4. Process the results in the SaveResult[] object to verify whether the objects have been successfully created. Any help with this would be appreciated. Mostly looking for another set of eyes. -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
translating java to CF
so if the header in Java says this: - import com.sforce.soap.enterprise.sobject.Account; and then the code does this to create the object: Account account1 = new Account(); - Oh and I'm using SOAP In CF I use cfset this.sfdc = createObject(webservice,arguments.wsdluri) / How can I generate the Account object in CF. And it seems that I can't access the Account object (class?) at all or maybe I'm just being dumb. This doesn't work: cfset accountobj = createObject(java,com.sforce.soap.enterprise.sobject.Account) / I can access the methods of the soap object. com.sforce.soap.enterprise.SoapBindingStub Am I missing something basic? -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: translating java to CF
Just the guy I wanted to hear from. We have not. I have a bunch of generated .java files from the sforce web site and I am suggesting that we just use those. Is that the direction I should take with this? It seems to me to be the obvious choice. In fact would adding all the generated java files be a good thing? Since I seem to be only having problems with generating the objects. Actualy we are right now fighting with dreamweaver and a proxy generator to look at sforces wsdl file. -Joshua O'Connor-Rose -All is Good --- Sean Corfield [EMAIL PROTECTED] wrote: Have you added the compiled Java class files to your CFMX class path? On Mon, 27 Sep 2004 13:21:10 -0700 (PDT), Joshua OConnor-Rose [EMAIL PROTECTED] wrote: so if the header in Java says this: - import com.sforce.soap.enterprise.sobject.Account; and then the code does this to create the object: Account account1 = new Account(); - Oh and I'm using SOAP In CF I use cfset this.sfdc = createObject(webservice,arguments.wsdluri) / How can I generate the Account object in CF. And it seems that I can't access the Account object (class?) at all or maybe I'm just being dumb. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Seaching for the coolest dhtml meu
Not just menus but here's a free _javascript_ api for DHTML: http://dynapi.sourceforge.net/dynapi/ You probably will have to do a little work with it this api supports all browsers is completely _javascript_ based and when you combine it with CF there's really a ton of things you can do with it. -Joshua O'Connor-Rose -All is Good --- Sparrow-Hood, Walter [EMAIL PROTECTED] wrote: Coolmenus is the best that we've found. Walt -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 4:04 PM To: CF-Talk Subject: Seaching for the coolest dhtml meu I am trying to find a cool dhtml navigation menu - something really original - but I can't seem to find anything that is blowing my socks off. I've looked on dynamic drive and they have some pretty good ones, but not quite what I am looking for. I'll get to writing my own if I can't find anything cool, but this list has always provided amazing links to stuff. I already tied googles first couple pages of dhtml menus I don't want a dhtml menu builder program, and it has to be free (cost and license) - (no flash or java menus either (_javascript_ ok and encouraged)). any suggestions? Thanks for any help. Rob -- ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~open source XML database~ http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Question about cfqueryparam
Sorry if this question has been answered already. I searched the list but putting that particular tagname returns plenty and most of it is advice to use it. For search pages I started to put the where statement together into a variable request.filter this worked fine but we just upgraded the server from 4.5 to 6.1 and I wanted to start throwing in cfqueryparam. So when I use this: cfset request.filter = where 0=0 cfif len(attributes.office_num) cfset request.filter = request.filter and office_num in (cfqueryparam list='Yes' value='#attributes.office_num#' cfsqltype='CF_SQL_VARCHAR') /cfif And then do this: cfquery datasource=media name=get_office select office_id from office #request.filter# /cfquery I get an error. I can't quite figure out what I'm missing any help? -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Question about cfqueryparam
thanks. gee I thought I had something good going on. ah well. -Joshua O'Connor-Rose -All is Good --- Pascal Peters [EMAIL PROTECTED] wrote: You can't use cfqueryparam like this, it won't get evaluated. It has to be in the cfquery. cfquery datasource=media name=get_office select office_id from office #request.filter# where 0=0 cfif len(attributes.office_num) and office_num in (cfqueryparam list='Yes' value='#attributes.office_num#' cfsqltype='CF_SQL_VARCHAR') /cfif /cfquery -Original Message- From: Joshua OConnor-Rose [mailto:[EMAIL PROTECTED] Sent: 29 July 2004 17:17 To: CF-Talk Subject: Question about cfqueryparam Sorry if this question has been answered already. I searched the list but putting that particular tagname returns plenty and most of it is advice to use it. For search pages I started to put the where statement together into a variable request.filter this worked fine but we just upgraded the server from 4.5 to 6.1 and I wanted to start throwing in cfqueryparam. So when I use this: cfset request.filter = where 0=0 cfif len(attributes.office_num) cfset request.filter = request.filter and office_num in (cfqueryparam list='Yes' value='#attributes.office_num#' cfsqltype='CF_SQL_VARCHAR') /cfif And then do this: cfquery datasource=media name=get_office select office_id from office #request.filter# /cfquery I get an error. I can't quite figure out what I'm missing any help? -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Question about cfqueryparam
I'm back to this now Anybody seen this before? [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query _expression_ 'active = 1 and adcompany = 4 where office_num in (Pa_RaM000,Pa_RaM001,Pa_RaM002)'. it says my sql looks different too: select office.office_id,office.office_num,office.office_name,office.city,state.state from office inner join state on office.state=state.state_id where active = 1 and adcompany = 4 where office_num in ( (param 1) , (param 2) , (param 3) ) order by office.office_num -Joshua O'Connor-Rose -All is Good --- Pascal Peters [EMAIL PROTECTED] wrote: I forgot to delete #request.filter# in the query below -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 29 July 2004 17:23 To: CF-Talk Subject: RE: Question about cfqueryparam You can't use cfqueryparam like this, it won't get evaluated. It has to be in the cfquery. cfquery datasource=media name=get_office select office_id from office #request.filter# where 0=0 cfif len(attributes.office_num) and office_num in (cfqueryparam list='Yes' value='#attributes.office_num#' cfsqltype='CF_SQL_VARCHAR') /cfif /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Question about cfqueryparam
nevermind sorry to be so hasty -joshua o'connor-rose -all is good --- Joshua OConnor-Rose [EMAIL PROTECTED] wrote: I'm back to this now Anybody seen this before? [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query _expression_ 'active = 1 and adcompany = 4 where office_num in (Pa_RaM000,Pa_RaM001,Pa_RaM002)'. it says my sql looks different too: select office.office_id,office.office_num,office.office_name,office.city,state.state from office inner join state on office.state=state.state_id where active = 1 and adcompany = 4 where office_num in ( (param 1) , (param 2) , (param 3) ) order by office.office_num -Joshua O'Connor-Rose -All is Good --- Pascal Peters [EMAIL PROTECTED] wrote: I forgot to delete #request.filter# in the query below -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 29 July 2004 17:23 To: CF-Talk Subject: RE: Question about cfqueryparam You can't use cfqueryparam like this, it won't get evaluated. It has to be in the cfquery. cfquery datasource=media name=get_office select office_id from office #request.filter# where 0=0 cfif len(attributes.office_num) and office_num in (cfqueryparam list='Yes' value='#attributes.office_num#' cfsqltype='CF_SQL_VARCHAR') /cfif /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Duplicate inserts
I'm having an issue with duplicate records being created on a single insert (at least on the debugging side) does anybody know of any issues regarding this. Its not the first time I've seen it. I thought I posted this before but it didn't come up on a search. -Joshua O'Connor-Rose -all is Good __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Duplicate inserts
I do have the code(some things to note) -I claim no credit for this code -I did check debuging and the inserts only list once in the debugging code -The database is access (and unfortunately won't be changed) Oh and while I'm here anybody come up with any solutions around. [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine errors -Joshua O'Connor-Rose -All is Good code below - cfloop list=#form.fieldnames# index=y cfif y contains 'BULLETNEW_' and listgetat(y, 2, '_') eq this_id !--- cfoutput#y# - #evaluate(y)# - #evaluate('BULLETORDERNEW_' this_id '_' listlast(y, '_'))#/cfoutputbr --- cfif trim(evaluate(y)) neq '' cfquery datasource=media name=add_bullets insert into custom_bullets (media_id,custom_ad_id,ordering,content) values (#url.id#,#this_id#,#evaluate('BULLETORDERNEW_' this_id '_' listlast(y, '_'))#,'#evaluate(y)#') /cfquery /cfif cfelseif y contains 'bulletold_' and listgetat(y, 2, '_') eq this_id cfif trim(evaluate(y)) neq '' cfquery datasource=media name=update_bullets update custom_bullets set content = '#evaluate(y)#', ordering = #evaluate('BULLETORDERold_' this_id '_' listlast(y, '_'))# where custom_bullet_id = #listlast(y, '_')# /cfquery cfelse cfquery datasource=media name=update_bullets delete * from custom_bullets where custom_bullet_id = #listlast(y, '_')# /cfquery /cfif /cfif /cfloop --- [EMAIL PROTECTED] wrote: got code? Joshua OConnor-Rose [EMAIL PROTECTED] 06/29/2004 01:07 PM Please respond to cf-talk To:CF-Talk [EMAIL PROTECTED] cc: Subject:Duplicate inserts I'm having an issue with duplicate records being created on a single insert (at least on the debugging side) does anybody know of any issues regarding this. Its not the first time I've seen it. I thought I posted this before but it didn't come up on a search. -Joshua O'Connor-Rose -all is Good [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Duplicate inserts
I don't think thats it. I'm not mapped to the server where the database is. When I refresh I don't get the same error. -Joshua O'Connor-Rose -All is Good --- Barney Boisvert [EMAIL PROTECTED] wrote: The locked by admin error is because you've got the table open in design view in the Access program, so it won't allow anyone to change it. Cheers, barneyb -Original Message- From: Joshua OConnor-Rose [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 10:34 AM To: CF-Talk Subject: Re: Duplicate inserts I do have the code(some things to note) -I claim no credit for this code -I did check debuging and the inserts only list once in the debugging code -The database is access (and unfortunately won't be changed) Oh and while I'm here anybody come up with any solutions around. [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Duplicate inserts
Thanks 2 birds with one stone and unfortunately a troll hides behind them what a headache ok so theres this wintertree spell checking script on this site that I'm working on. it requires the onsubmitbt() script that changes the action of the form and then submits the form. this script is run on every submit button of the page so it explains both the locking and the double inserts. so I take it out. . . bad move it turns out as the spellchecking feature alters the action of the form to popup a spellchecking asp page (that I can't access unfortunately). so I rewrite the script to not submit the form and put it back on the submit buttons. I think this is working (a few tests prove it's ok) yet another monster lurks however. Spellchecking won't run if the enctype of the form is multipart/form-data which sort of defeats the purpose of the added functionality. I guess it's time to look for another spell checker -Joshua O'Connor-Rose -All is Good --- George Abraham [EMAIL PROTECTED] wrote: Pascal's right. I had the same problem and I kept looking at the action page, thinking that was to blame. But the problem was a double submit on the form page. George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
duplicate inserts
So this is a complete mystery to me but I've seen now on a few occasions (mostly on MX(6.1) I think but it may have happend with 5.0 too) But every so often when I'm inserting a record into a database two records get inserted. I check my cf code with debugging and note that it's not actualy happening on the cf side (or at least the code side itself) is there anything I can do to find out why this is happening. The developers here are using access db but I saw it on ms sql once before too. -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Understanding/Defending Coldfusion connections
OK so a friend of mine at an office I used to work at is having trouble defending coldfusion over dot net he tells me that this voice of 'authority' (its strange that a man that speaks with confidence is never questioned) said cold fusion [is no good] because it keeps a database connection open all the time and that slows down the program/app and server This particular web professional is converting all his CF to dot net, because of this defense. I've been briefly looking around so that I can understand database connections better and respond to him with the voice of reason (also to possibly optimise the performance of the access back end I have been stuck with on my current contract). But I keep coming up with help files on configuring datasources instead of information on how cf connects to datasources. Anybody have a good reference I can point to. -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: About Scoping mostly url and form
Thanks I'm sure I'll work with FB again, not happening where I'm at right now. But I've made the recommendation. Love the stuff. -Joshua O'Connor-Rose -All is Good --- Sandy Clark [EMAIL PROTECTED] wrote: I use fusebox, which dumps all form and url values to an attributes scope. You can emulate it if you don't want to make the move to FB. cfscript if (NOT IsDefined(attributes)) attributes=structNew(); StructAppend(attributes, url, yes); StructAppend(attributes, form, yes); /cfscript _ From: Joshua O'Connor-Rose [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 12:47 PM To: CF-Talk Subject: About Scoping mostly url and form At the risk of looking not too bright I have a question maybe I can get help, or someone can put me in my place So about scope. when I started coding CF (about 7 years ago) I really didn't know about scope at all, then I started using cgi session application client query struct form url and request scopes. But then I had a massive problems and had to change lots of code especialy when I had forms and urls passing variables to the same page to do the same thing. (mostly I had to write code to dump them all into request scope but I never put together a script to do it, which right now I'm sure I'll find, working with php fusebox form and url vars were dumped into an attributes array easily and I can probably base it on that) One day I just quit on the whole thing and ever since I realy haven't as many problems. What do you folks do when you want a variable that can be passed over form or url? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]