Re: CFMX errs on Java class .isAuthenticated() method
Hi all It's possible to use .class file with CF MX 6.1? How can I do that? Cheers MD 2006/1/19, RADEMAKERS Tanguy [EMAIL PROTECTED]: -Original Message- Folks--- How do I get around this one? In my CFMX6.1 template I instantiate userObj from a Java User class used for authentication. I want to determine if authentication was successful so I use the Java class's .isAuthenticated() method which fails because MX thinks I'm trying to use the old CF5.0 isAuthenticated() function. Any ideas? Thanks.--- Rob if you have access to the java source, you can look into changing the method name. Otherwise, you could write a little java wrapper for your User class and then call that. Finally, you could mess about with the java reflection APIs from within CF (in theory... YMMV) /t ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231236 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: CFMX errs on Java class .isAuthenticated() method
Sorry to contribute to the hijack of your thread Rob. Michel, start here: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/java.htm On 2/3/06, Michel Deloux [EMAIL PROTECTED] wrote: Hi all It's possible to use .class file with CF MX 6.1? How can I do that? -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231237 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 Encapsulation?
Well, first of all, I didn't read his initial question to be one of pagination, which is what you're implying. I read it as one of reusing query results in multiple ways. In that scenario, you could very easily cache your object, either in the application or the session scope. So, you'd be storing more in memory, but only making a single trip to the database. It's all trade-offs. Obviously, if you're working with millions of rows of data, this might not be the best approach. But, it seemed reasonable to me that if he's indicating that the where clause could have hundreds of lines of complex logic based on passed in arguments that he'd ultimately be returning a relatively small result set. Honestly, I'd be doing my best not to design an app that has hundreds of lines of complex logic for a single query, as I'd find that seriously unmaintainable. But, without knowing more specifics about what he's actually trying to acomplish, we're just tossing out potential solution scenarios. We don't really know the paramaters of the problem we're trying to solve. On 2/2/06, Brian Peddle [EMAIL PROTECTED] wrote: Using this method you would be bringing back potentially hundreds of thousands of records. He only needs 50 at a time. Why pass 100,000 or more maybe when you can send 50 records back to ColdFusion. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 2:39 PM To: CF-Talk Subject: Re: SQL Encapsulation? pseudo-code... cfcomponent displayname=mystuff hint=Get's all my stuff cfset variables.allrows = cffunction access=public name=init returntype=mystuff output=false hint=Initializes the object. !--- Do big complex query here and set it to the variables.allrows var --- cfquery Select blah blah From Blah blah WHERE blah blah /cfquery cfset variables.allrows = myquery cfreturn this / /cffunction cffunction access=public name=getTotal output=false returntype=numeric cfreturn variables.allrows.recordcount /cffunction cffunction access=public name=getNext output=false returntype=query cfargument name=start required=false default=1 type=numeric cfargument name=end required=false default=50 type=numeric cfset var getit = cfquery name=getit dbtype=query select * from variables.allrows WHERE start = #arguments.start# AND end = #arguments.end# /cfquery cfreturn getit /cffunction /cfcomponent On 2/2/06, Brian Peddle [EMAIL PROTECTED] wrote: I don't believe that will get him what he wants. He has query #1 which will get the total records for a query. Query #2 just returns 50 records of the total. So when you display results you see. Total: Records 4530 Displaying Records: 101-150. Instead of one query returning all 4530 records just to display 50 he is just bringing back what he needs. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 1:43 PM To: CF-Talk Subject: Re: SQL Encapsulation? I'd go the cfc route, where I would instantiate a single CFC that would run your base query with all your where and from clauses. Then, I'd have multiple functions that would do query of query against that base query. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231238 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: Doctype
I'm confused as to how the doctype affects css. I have some tools I made and wanted to plug them into Lighthouse Pro and the doctype on lighthouse pro is strict. So when I put my tools into it, the rendered differently than they did under a different doctype. Where do I go to learn more about the differences. I understand what it is, just not what I'm supposed to do to make it look correct. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231239 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: OT: Doctype
this http://hsivonen.iki.fi/doctype/ gives a pretty good explanation, jb On 03/02/06, Robert Everland III [EMAIL PROTECTED] wrote: I'm confused as to how the doctype affects css. I have some tools I made and wanted to plug them into Lighthouse Pro and the doctype on lighthouse pro is strict. So when I put my tools into it, the rendered differently than they did under a different doctype. Where do I go to learn more about the differences. I understand what it is, just not what I'm supposed to do to make it look correct. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231240 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 Encapsulation?
I was basing my assumptions on writing these same things over and over from job to job for past 10 years. I assumed with the top 50 he is paging. I am also assuming he built up his where clause using a series of 'if' or 'case' statements so it won't always be the same. So if someone has 50 dropdowns for a report generator the person could pick no options or pick all 50. But it seems as though he has disappeared from our discussion so your are right, its us guessing what he want. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 8:08 AM To: CF-Talk Subject: Re: SQL Encapsulation? Well, first of all, I didn't read his initial question to be one of pagination, which is what you're implying. I read it as one of reusing query results in multiple ways. In that scenario, you could very easily cache your object, either in the application or the session scope. So, you'd be storing more in memory, but only making a single trip to the database. It's all trade-offs. Obviously, if you're working with millions of rows of data, this might not be the best approach. But, it seemed reasonable to me that if he's indicating that the where clause could have hundreds of lines of complex logic based on passed in arguments that he'd ultimately be returning a relatively small result set. Honestly, I'd be doing my best not to design an app that has hundreds of lines of complex logic for a single query, as I'd find that seriously unmaintainable. But, without knowing more specifics about what he's actually trying to acomplish, we're just tossing out potential solution scenarios. We don't really know the paramaters of the problem we're trying to solve. On 2/2/06, Brian Peddle [EMAIL PROTECTED] wrote: Using this method you would be bringing back potentially hundreds of thousands of records. He only needs 50 at a time. Why pass 100,000 or more maybe when you can send 50 records back to ColdFusion. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 2:39 PM To: CF-Talk Subject: Re: SQL Encapsulation? pseudo-code... cfcomponent displayname=mystuff hint=Get's all my stuff cfset variables.allrows = cffunction access=public name=init returntype=mystuff output=false hint=Initializes the object. !--- Do big complex query here and set it to the variables.allrows var --- cfquery Select blah blah From Blah blah WHERE blah blah /cfquery cfset variables.allrows = myquery cfreturn this / /cffunction cffunction access=public name=getTotal output=false returntype=numeric cfreturn variables.allrows.recordcount /cffunction cffunction access=public name=getNext output=false returntype=query cfargument name=start required=false default=1 type=numeric cfargument name=end required=false default=50 type=numeric cfset var getit = cfquery name=getit dbtype=query select * from variables.allrows WHERE start = #arguments.start# AND end = #arguments.end# /cfquery cfreturn getit /cffunction /cfcomponent On 2/2/06, Brian Peddle [EMAIL PROTECTED] wrote: I don't believe that will get him what he wants. He has query #1 which will get the total records for a query. Query #2 just returns 50 records of the total. So when you display results you see. Total: Records 4530 Displaying Records: 101-150. Instead of one query returning all 4530 records just to display 50 he is just bringing back what he needs. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 1:43 PM To: CF-Talk Subject: Re: SQL Encapsulation? I'd go the cfc route, where I would instantiate a single CFC that would run your base query with all your where and from clauses. Then, I'd have multiple functions that would do query of query against that base query. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231241 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: Coldfusion and Active Directory
That worked thanks !! Just one more small point, I need to create a web form that will allow certain users based on their permissions to update/modify the user information stored in the AD. In the ldap attributes of the modify what is the LDAP equivalent of the SQL Where clause ? I.E. If I wanted to update a users details how would the AD know which user record I would be referring to ? The sAMAccountName would be the unique field equivalent to a primary key in a database table cfldap username=#ldap_user# password=#ldap_password# action=modify server=#ldap_server modifyType=replace delimiter=; dn=CN=AD-SOME-GROUP;OU=Groups;OU=SOME;dc=ads;dc=somedomain;dc=com attributes= sAMAccountName=form.sAMAccountName, sn=form.sn,givenName=form.givenName -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 02 February 2006 16:35 To: CF-Talk Subject: RE: Coldfusion and Active Directory I was thinking something like: cfset filter = ((objectClass=user) cfif len(trim(form.email)) cfset filter = filter (mail=#form.email#) /cfif cfif len(trim(form.lastName)) cfset filter = filter (sn=#form.lastName#) /cfif cfset filter = filter ) Then, cfldap ... filter=#filter# ... M!ke -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 9:20 AM To: CF-Talk Subject: RE: Coldfusion and Active Directory That's correct, even though the fields are optional, when some of the fields are populated fields all are required. Could you explain what you mean by you would need some logic to decide how to build the actual filter. Do you mean setting variables called filter below cfset filter = ((objectClass=user) cfset filter = filter (mail=#form.mail#) cfset filter = filter (sn=#form.sn#) Etc.. Then in the ldap query in the filter field just have cfldap action=query . filter=#filter# . ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231242 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: Doctype
Here's a decent intro article. http://www.alistapart.com/stories/doctype/ --- Kevin Graeme Cooperative Extension Technology Services University of Wisconsin-Extension -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 6:44 AM To: CF-Talk Subject: OT: Doctype I'm confused as to how the doctype affects css. I have some tools I made and wanted to plug them into Lighthouse Pro and the doctype on lighthouse pro is strict. So when I put my tools into it, the rendered differently than they did under a different doctype. Where do I go to learn more about the differences. I understand what it is, just not what I'm supposed to do to make it look correct. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231243 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: ValueList and Dynamic Query and Column
Michael, I think I remember this being a problem, but I'm trying to create a value list from a dynamic query and column. Something like this: function(query, column) { return valueList(query.column); } That's the gist of it, but it doesn't work. Any suggestions? Here's my blog entry addressing the issue: http://blog.pengoworks.com/blogger/index.cfm?action=blog:437 In a nutshell, go grab the DynamicValueList UDF over at CFLIB.org: http://www.cflib.org/udf.cfm?ID=745 -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231244 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 Encapsulation?
Hi Gang, Found your messages in my Junk Mail - was wondering why no-one responded! Brian you're right on all fronts. The example I gave was a paging one, but it's only an example, the real issue is re-using *portions* of SQL code in other queries - and not the query result itself. Here is a way that I have re-used *portions* of SQL code in 1 CFC: ** Search() ** cfquery SELECT COUNT(OrderID) as TotalRows FROM #getFrom()# WHERE CustomerName like '%Keywords%' /cfquery ** Count() ** cfquery SELECT #getSelect()# FROM #getFrom()# WHERE StatusID 5 /cfquery ** getSelect() ** DISTINCT OrderID, CustomerID, BillingAddressID, ShippingAddressID, OrderDate, OrderFile, OrderPrescriptionFile, OrderInvoicePrintedDate, OrderAgreementSigned, OrderShippingPrice, OrderDiscount, OrderComment, OrderProblem, OrderCancelled, StatusID, Status, StatusPhrased, CustomerID, CustomerName ** getFrom() ** Order INNER JOIN OrderStatus ON `Order`.OrderID = OrderStatus.OrderID INNER JOIN Status ON OrderStatus.StatusID = Status.StatusID INNER JOIN Customer ON `Order`.CustomerID = Customer.CustomerID The preceding methods all live in the same CFC. You will notice that the Search() method and Count() method share the same FROM clause by getting it from another method. But they have a different SELECT, WHERE, GROUP BY, and so forth, so the query results will be very different. Other methods may share the same WHERE but not the same SELECT and even more methods may SHARE different parts. So you see, it's not a matter of caching queries, but building queries using encapsulated SQL. I am finding that my gateways CFCs (those that return queries) are generally using the same SQL for each method in the CFC. And that makes sense because if you want a COUNT it usually is for a record-set you want I the future. Same for SUM, GROUP, etc... These are all different representations of the same base. So SQL being a form of code like any other, should be re-used and encapsulated like any other. It doesn't seem proper to have to find and paste the same changes in 15-20 methods just because a little logic in the SQL changes. Thoughts? Baz -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 9:07 AM To: CF-Talk Subject: RE: SQL Encapsulation? I was basing my assumptions on writing these same things over and over from job to job for past 10 years. I assumed with the top 50 he is paging. I am also assuming he built up his where clause using a series of 'if' or 'case' statements so it won't always be the same. So if someone has 50 dropdowns for a report generator the person could pick no options or pick all 50. But it seems as though he has disappeared from our discussion so your are right, its us guessing what he want. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 8:08 AM To: CF-Talk Subject: Re: SQL Encapsulation? Well, first of all, I didn't read his initial question to be one of pagination, which is what you're implying. I read it as one of reusing query results in multiple ways. In that scenario, you could very easily cache your object, either in the application or the session scope. So, you'd be storing more in memory, but only making a single trip to the database. It's all trade-offs. Obviously, if you're working with millions of rows of data, this might not be the best approach. But, it seemed reasonable to me that if he's indicating that the where clause could have hundreds of lines of complex logic based on passed in arguments that he'd ultimately be returning a relatively small result set. Honestly, I'd be doing my best not to design an app that has hundreds of lines of complex logic for a single query, as I'd find that seriously unmaintainable. But, without knowing more specifics about what he's actually trying to acomplish, we're just tossing out potential solution scenarios. We don't really know the paramaters of the problem we're trying to solve. On 2/2/06, Brian Peddle [EMAIL PROTECTED] wrote: Using this method you would be bringing back potentially hundreds of thousands of records. He only needs 50 at a time. Why pass 100,000 or more maybe when you can send 50 records back to ColdFusion. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 2:39 PM To: CF-Talk Subject: Re: SQL Encapsulation? pseudo-code... cfcomponent displayname=mystuff hint=Get's all my stuff cfset variables.allrows = cffunction access=public name=init returntype=mystuff output=false hint=Initializes the object. !--- Do big complex query here and set it to the variables.allrows var --- cfquery Select blah blah From Blah blah WHERE blah blah /cfquery cfset variables.allrows = myquery cfreturn this / /cffunction cffunction access=public name=getTotal
CFGRID And HREF?
Has anyone gotten this to work? I have a flash form, with a CFGRID in it. The grid comes up fine, but double clicking on any of the rows fails to bring me to the new page. Can someone provide a link to a tutorial on how to make this work? The Macromedia documentation does not work, and has several comments after the example advising them of such. I am flummoxed. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231246 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
Sending an attached file with a unique name
I'm sending an attached pdf via cfmail/cfmailpart to a recipient. Right now, I'm naming the files in storage via uuid. I'd like to send the file along with a friendlier name (e.g. your_file.pdf). Is this possible without copying/renaming the file? Thanks, Rich ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231247 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
SOT Best way to identify if a form was change
Hi All, What is the best way to identify if a form has been changed? Currently I set up a hidden field on the form on every onChange event. Then on the onUnload I check the status of the hidden field and let the user know. Is this the best (only) way to do it? Thanks Victor ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231248 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: SOT Best way to identify if a form was change
From: Victor Moore [mailto:[EMAIL PROTECTED] What is the best way to identify if a form has been changed? Currently I set up a hidden field on the form on every onChange event. Then on the onUnload I check the status of the hidden field and let the user know. Is this the best (only) way to do it? I'd check out qForms from Pengoworks. http://pengoworks.com/qforms/docs/objects_qform.htm#hasChanged Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231249 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: SOT Best way to identify if a form was change
On 2/3/06, Victor Moore [EMAIL PROTECTED] wrote: Hi All, What is the best way to identify if a form has been changed? Currently I set up a hidden field on the form on every onChange event. Then on the onUnload I check the status of the hidden field and let the user know. Is this the best (only) way to do it? Your easiest solution (obviously, my opinion) would be to head over to Dan Switzer's site and use his amazing qForms JavaScript library. It takes all the pain out of doing JS validation and it's incredibly robust. His API literally has a changedFields() method that does all the work for you. You would simply do: objForm = new qForm(myFormName); alert( objForm.changedFields ); That's it. No need for your own hidden fields or anything. I'm telling you, Dan has done an incredible job of abstracting away the complexities of JavaScript: http://www.pengoworks.com/index.cfm?action=get:qforms Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231250 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
Los Angeles CFUG reforming - for real
I have, in a moment of enthusiastic madness, taken on reestablishing the Los Angeles CFUG, formerly part of SCFUG. If you would be interested in presenting at a meeting in the next few months, please let me know. There will be no charge for membership or attendance, although we will try to have a low cost food option, if folks want it. Meeting day is not set, but will probably be Tuesday or Wednesday evenings at 6:30 PMI am currently looking for a meeting place, most likely on the West side of Los Angeles. Please contact me off list is you can provide: A meeting place; A speaker (such as yourself); and/or You are with an organization that would be interested in underwriting the group, which would not be very expensive, as most fixed expenses like the Web site, etc. are already covered. The site should be up later this week. Thanks! Cary Gordon The Cherry Hill Company cgordon attt chillco ddott com 310-397-2999 (v) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231251 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: SQL Encapsulation?
Well, we were both interpreting your request a bit incorrectly then. But, I'm not sure I have an answer for you on this one. It's not something I'd do. I'd be more apt to make a view that encapsulated the generic joined data, and then pull the columns (selects) under the conditions (wheres) that I wanted. I find the method you're using below to be difficult to read, and while I understand the concept, it's one of those places where I fail to see the benefit of doing it that way. On 2/3/06, Baz [EMAIL PROTECTED] wrote: Hi Gang, Found your messages in my Junk Mail - was wondering why no-one responded! Brian you're right on all fronts. The example I gave was a paging one, but it's only an example, the real issue is re-using *portions* of SQL code in other queries - and not the query result itself. Here is a way that I have re-used *portions* of SQL code in 1 CFC: ** Search() ** cfquery SELECT COUNT(OrderID) as TotalRows FROM #getFrom()# WHERE CustomerName like '%Keywords%' /cfquery ** Count() ** cfquery SELECT #getSelect()# FROM #getFrom()# WHERE StatusID 5 /cfquery ** getSelect() ** DISTINCT OrderID, CustomerID, BillingAddressID, ShippingAddressID, OrderDate, OrderFile, OrderPrescriptionFile, OrderInvoicePrintedDate, OrderAgreementSigned, OrderShippingPrice, OrderDiscount, OrderComment, OrderProblem, OrderCancelled, StatusID, Status, StatusPhrased, CustomerID, CustomerName ** getFrom() ** Order INNER JOIN OrderStatus ON `Order`.OrderID = OrderStatus.OrderID INNER JOIN Status ON OrderStatus.StatusID = Status.StatusID INNER JOIN Customer ON `Order`.CustomerID = Customer.CustomerID The preceding methods all live in the same CFC. You will notice that the Search() method and Count() method share the same FROM clause by getting it from another method. But they have a different SELECT, WHERE, GROUP BY, and so forth, so the query results will be very different. Other methods may share the same WHERE but not the same SELECT and even more methods may SHARE different parts. So you see, it's not a matter of caching queries, but building queries using encapsulated SQL. I am finding that my gateways CFCs (those that return queries) are generally using the same SQL for each method in the CFC. And that makes sense because if you want a COUNT it usually is for a record-set you want I the future. Same for SUM, GROUP, etc... These are all different representations of the same base. So SQL being a form of code like any other, should be re-used and encapsulated like any other. It doesn't seem proper to have to find and paste the same changes in 15-20 methods just because a little logic in the SQL changes. Thoughts? Baz -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 9:07 AM To: CF-Talk Subject: RE: SQL Encapsulation? I was basing my assumptions on writing these same things over and over from job to job for past 10 years. I assumed with the top 50 he is paging. I am also assuming he built up his where clause using a series of 'if' or 'case' statements so it won't always be the same. So if someone has 50 dropdowns for a report generator the person could pick no options or pick all 50. But it seems as though he has disappeared from our discussion so your are right, its us guessing what he want. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 8:08 AM To: CF-Talk Subject: Re: SQL Encapsulation? Well, first of all, I didn't read his initial question to be one of pagination, which is what you're implying. I read it as one of reusing query results in multiple ways. In that scenario, you could very easily cache your object, either in the application or the session scope. So, you'd be storing more in memory, but only making a single trip to the database. It's all trade-offs. Obviously, if you're working with millions of rows of data, this might not be the best approach. But, it seemed reasonable to me that if he's indicating that the where clause could have hundreds of lines of complex logic based on passed in arguments that he'd ultimately be returning a relatively small result set. Honestly, I'd be doing my best not to design an app that has hundreds of lines of complex logic for a single query, as I'd find that seriously unmaintainable. But, without knowing more specifics about what he's actually trying to acomplish, we're just tossing out potential solution scenarios. We don't really know the paramaters of the problem we're trying to solve. On 2/2/06, Brian Peddle [EMAIL PROTECTED] wrote: Using this method you would be bringing back potentially hundreds of thousands of records. He only needs 50 at a time. Why pass 100,000 or more maybe when you can send 50 records back to ColdFusion. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday,
Re: SOT Best way to identify if a form was change
Looks good. I will check it out in more details... Thanks, Victor On 2/3/06, Dave Carabetta [EMAIL PROTECTED] wrote: On 2/3/06, Victor Moore [EMAIL PROTECTED] wrote: Hi All, What is the best way to identify if a form has been changed? Currently I set up a hidden field on the form on every onChange event. Then on the onUnload I check the status of the hidden field and let the user know. Is this the best (only) way to do it? Your easiest solution (obviously, my opinion) would be to head over to Dan Switzer's site and use his amazing qForms JavaScript library. It takes all the pain out of doing JS validation and it's incredibly robust. His API literally has a changedFields() method that does all the work for you. You would simply do: objForm = new qForm(myFormName); alert( objForm.changedFields ); That's it. No need for your own hidden fields or anything. I'm telling you, Dan has done an incredible job of abstracting away the complexities of JavaScript: http://www.pengoworks.com/index.cfm?action=get:qforms Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231253 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: JRun Web Server Config display problem
I have the multiserver CF MX7 running on our live server, and have a small problem with the Web Server Configuration app. We have about 50 sites setup there, and because there is no scrollbar for the site list, the buttons down the bottom of the list are now off the desktop. Is this a known issue? Is there a workaround for it? I believe you can pass the desired parameters to it directly from the command line, rather than using the GUI at all. 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! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231254 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: SQL Encapsulation?
I'm not such a big fan of that method either - that's why I wrote the post! :) Maybe I should just make better use of views... In any case, I appreciate the time you spent giving it thought. Cheers, Baz -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 11:25 AM To: CF-Talk Subject: Re: SQL Encapsulation? Well, we were both interpreting your request a bit incorrectly then. But, I'm not sure I have an answer for you on this one. It's not something I'd do. I'd be more apt to make a view that encapsulated the generic joined data, and then pull the columns (selects) under the conditions (wheres) that I wanted. I find the method you're using below to be difficult to read, and while I understand the concept, it's one of those places where I fail to see the benefit of doing it that way. On 2/3/06, Baz [EMAIL PROTECTED] wrote: Hi Gang, Found your messages in my Junk Mail - was wondering why no-one responded! Brian you're right on all fronts. The example I gave was a paging one, but it's only an example, the real issue is re-using *portions* of SQL code in other queries - and not the query result itself. Here is a way that I have re-used *portions* of SQL code in 1 CFC: ** Search() ** cfquery SELECT COUNT(OrderID) as TotalRows FROM #getFrom()# WHERE CustomerName like '%Keywords%' /cfquery ** Count() ** cfquery SELECT #getSelect()# FROM #getFrom()# WHERE StatusID 5 /cfquery ** getSelect() ** DISTINCT OrderID, CustomerID, BillingAddressID, ShippingAddressID, OrderDate, OrderFile, OrderPrescriptionFile, OrderInvoicePrintedDate, OrderAgreementSigned, OrderShippingPrice, OrderDiscount, OrderComment, OrderProblem, OrderCancelled, StatusID, Status, StatusPhrased, CustomerID, CustomerName ** getFrom() ** Order INNER JOIN OrderStatus ON `Order`.OrderID = OrderStatus.OrderID INNER JOIN Status ON OrderStatus.StatusID = Status.StatusID INNER JOIN Customer ON `Order`.CustomerID = Customer.CustomerID The preceding methods all live in the same CFC. You will notice that the Search() method and Count() method share the same FROM clause by getting it from another method. But they have a different SELECT, WHERE, GROUP BY, and so forth, so the query results will be very different. Other methods may share the same WHERE but not the same SELECT and even more methods may SHARE different parts. So you see, it's not a matter of caching queries, but building queries using encapsulated SQL. I am finding that my gateways CFCs (those that return queries) are generally using the same SQL for each method in the CFC. And that makes sense because if you want a COUNT it usually is for a record-set you want I the future. Same for SUM, GROUP, etc... These are all different representations of the same base. So SQL being a form of code like any other, should be re-used and encapsulated like any other. It doesn't seem proper to have to find and paste the same changes in 15-20 methods just because a little logic in the SQL changes. Thoughts? Baz -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 9:07 AM To: CF-Talk Subject: RE: SQL Encapsulation? I was basing my assumptions on writing these same things over and over from job to job for past 10 years. I assumed with the top 50 he is paging. I am also assuming he built up his where clause using a series of 'if' or 'case' statements so it won't always be the same. So if someone has 50 dropdowns for a report generator the person could pick no options or pick all 50. But it seems as though he has disappeared from our discussion so your are right, its us guessing what he want. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 8:08 AM To: CF-Talk Subject: Re: SQL Encapsulation? Well, first of all, I didn't read his initial question to be one of pagination, which is what you're implying. I read it as one of reusing query results in multiple ways. In that scenario, you could very easily cache your object, either in the application or the session scope. So, you'd be storing more in memory, but only making a single trip to the database. It's all trade-offs. Obviously, if you're working with millions of rows of data, this might not be the best approach. But, it seemed reasonable to me that if he's indicating that the where clause could have hundreds of lines of complex logic based on passed in arguments that he'd ultimately be returning a relatively small result set. Honestly, I'd be doing my best not to design an app that has hundreds of lines of complex logic for a single query, as I'd find that seriously unmaintainable. But, without knowing more specifics about what he's actually trying to acomplish, we're just tossing out potential solution scenarios. We don't really know the paramaters of the problem we're trying
RE: RJustify Question
Table and div solutions are good. For some reasons if they don't work, using the tag below will solve the issue. cfprocessingDirective suppressWhitespace=No pre !--- Align nicely without CF codes here --- /pre /cfprocessingDirective HTH Pine -Original Message- From: Eric Roberts [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 8:54 PM To: CF-Talk Subject: RE: RJustify Question Use a table and right align the columns... Eric -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, 02 February 2006 19:03 To: CF-Talk Subject: RJustify Question Trying to align a column of integers 9 11 999 77 3 So, the below does nothing: #RJustify(9, 3)# #RJustify(11, 3)# #RJustify(999, 3)# Suggestions? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231256 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
setting up network data source
I'm trying to connect my local CF instance to a database on another server in my network, and I'm having trouble. Here's what I know. On my dev machine, I can successfully set up a System DSN using Win XP's admin tools. On my dev machine, I can successfully connect to the database using Enterprise Mgr. On the remote server, I can successfully create a datasource in CF Administrator to this database locally. On my dev machine, I cannot create a data source in CF Administrator. It times out trying to establish a connection. I suspect I may be making a stupid mistake - does anyone spot it? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231257 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 network data source
SQL server i guess? What authentication is the server using - NT authenication or SQL authentication, that's usually the best place to start looking. jb. On 03/02/06, Paul [EMAIL PROTECTED] wrote: I'm trying to connect my local CF instance to a database on another server in my network, and I'm having trouble. Here's what I know. On my dev machine, I can successfully set up a System DSN using Win XP's admin tools. On my dev machine, I can successfully connect to the database using Enterprise Mgr. On the remote server, I can successfully create a datasource in CF Administrator to this database locally. On my dev machine, I cannot create a data source in CF Administrator. It times out trying to establish a connection. I suspect I may be making a stupid mistake - does anyone spot it? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231258 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: RJustify Question
You could also wrap the text in a PRE tag. Keeps space formatting. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: PINE Phyo Z [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 11:06 AM To: CF-Talk Subject: RE: RJustify Question Table and div solutions are good. For some reasons if they don't work, using the tag below will solve the issue. cfprocessingDirective suppressWhitespace=No pre !--- Align nicely without CF codes here --- /pre /cfprocessingDirective HTH Pine -Original Message- From: Eric Roberts [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 8:54 PM To: CF-Talk Subject: RE: RJustify Question Use a table and right align the columns... Eric -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, 02 February 2006 19:03 To: CF-Talk Subject: RJustify Question Trying to align a column of integers 9 11 999 77 3 So, the below does nothing: #RJustify(9, 3)# #RJustify(11, 3)# #RJustify(999, 3)# Suggestions? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231259 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: Load Balancing issues
Russ, Where can I find information on either of these? I'm using a hardware load balancer and we've been fiddling with the Affinity settings but nothings working better than 70% of the time (while both servers are up). I'm supposing these are Enterprise-only features? Also you can set up the loadbalancer to do sticky sessions (You can do this in coldfusion as well). This won't prevent people from losing their session if one of the servers fails, but it will send them to the same server as long as both servers are up. Russ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231260 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
Code Analyzer Desktop Program?
I was wondering if there was a software written that analyzes code like the Admin tool does? The problem I'm having with the admin tool is that when I view a report, it asks me to login again. When I login, it tells me the data has expired... I've tried everything and I can't view the details. So I was hoping there might be a desktop application written that just analyzes for parse errors and such. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231261 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 network data source
Sorry I didn't specify... SQL Server, yes. The server is using SQL authentication, which works when I connect using enterprise mgr but not cf admin. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 10:23 AM To: CF-Talk Subject: Re: setting up network data source SQL server i guess? What authentication is the server using - NT authenication or SQL authentication, that's usually the best place to start looking. jb. On 03/02/06, Paul [EMAIL PROTECTED] wrote: I'm trying to connect my local CF instance to a database on another server in my network, and I'm having trouble. Here's what I know. On my dev machine, I can successfully set up a System DSN using Win XP's admin tools. On my dev machine, I can successfully connect to the database using Enterprise Mgr. On the remote server, I can successfully create a datasource in CF Administrator to this database locally. On my dev machine, I cannot create a data source in CF Administrator. It times out trying to establish a connection. I suspect I may be making a stupid mistake - does anyone spot it? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231262 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: SQL Encapsulation?
Wouldn't this be easier in a Stored Procedure? Well, SQL Encapsulation I mean... This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Baz [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Fri Feb 03 15:14:27 2006 Subject: RE: SQL Encapsulation? Hi Gang, Found your messages in my Junk Mail - was wondering why no-one responded! Brian you're right on all fronts. The example I gave was a paging one, but it's only an example, the real issue is re-using *portions* of SQL code in other queries - and not the query result itself. Here is a way that I have re-used *portions* of SQL code in 1 CFC: ** Search() ** cfquery SELECT COUNT(OrderID) as TotalRows FROM #getFrom()# WHERE CustomerName like '%Keywords%' /cfquery ** Count() ** cfquery SELECT #getSelect()# FROM #getFrom()# WHERE StatusID 5 /cfquery ** getSelect() ** DISTINCT OrderID, CustomerID, BillingAddressID, ShippingAddressID, OrderDate, OrderFile, OrderPrescriptionFile, OrderInvoicePrintedDate, OrderAgreementSigned, OrderShippingPrice, OrderDiscount, OrderComment, OrderProblem, OrderCancelled, StatusID, Status, StatusPhrased, CustomerID, CustomerName ** getFrom() ** Order INNER JOIN OrderStatus ON `Order`.OrderID = OrderStatus.OrderID INNER JOIN Status ON OrderStatus.StatusID = Status.StatusID INNER JOIN Customer ON `Order`.CustomerID = Customer.CustomerID The preceding methods all live in the same CFC. You will notice that the Search() method and Count() method share the same FROM clause by getting it from another method. But they have a different SELECT, WHERE, GROUP BY, and so forth, so the query results will be very different. Other methods may share the same WHERE but not the same SELECT and even more methods may SHARE different parts. So you see, it's not a matter of caching queries, but building queries using encapsulated SQL. I am finding that my gateways CFCs (those that return queries) are generally using the same SQL for each method in the CFC. And that makes sense because if you want a COUNT it usually is for a record-set you want I the future. Same for SUM, GROUP, etc... These are all different representations of the same base. So SQL being a form of code like any other, should be re-used and encapsulated like any other. It doesn't seem proper to have to find and paste the same changes in 15-20 methods just because a little logic in the SQL changes. Thoughts? Baz -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 9:07 AM To: CF-Talk Subject: RE: SQL Encapsulation? I was basing my assumptions on writing these same things over and over from job to job for past 10 years. I assumed with the top 50 he is paging. I am also assuming he built up his where clause using a series of 'if' or 'case' statements so it won't always be the same. So if someone has 50 dropdowns for a report generator the person could pick no options or pick all 50. But it seems as though he has disappeared from our discussion so your are right, its us guessing what he want. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 8:08 AM To: CF-Talk Subject: Re: SQL Encapsulation? Well, first of all, I didn't read his initial question to be one of pagination, which is what you're implying. I read it as one of reusing query results in multiple ways. In that scenario, you could very easily cache your object, either in the application or the session scope. So, you'd be storing more in memory, but only making a single trip to the database. It's all trade-offs. Obviously, if you're working with millions of rows of data, this might not be the best approach. But, it seemed reasonable to me that if he's indicating that the where clause could have hundreds of lines of complex logic based on passed in arguments that he'd ultimately be returning a relatively small result set. Honestly, I'd be doing my best not to design an app that has hundreds of lines of complex logic for a single query, as I'd find that seriously unmaintainable. But, without knowing more specifics about what he's actually trying to acomplish, we're just tossing out potential solution scenarios. We don't really know
RE: Load Balancing issues
The load balancer has to specifically support sticky sessions. I think it does this via some sort of cookie, but I'm not entirely sure. If you have clustering in coldfusion with session replication enabled, then you can also set the load balancing algorithm to either enable sticky session in JRUn proxy (which handles the connection from IIS or apache), or not enable them. If you do enable them, it used the JSESSIONID (which must be enabled for this to work) to send the request to the proper server. If you don't have sticky sessions enabled, it won't necessarily go to the same server, but it won't matter since sessions are replicated (session CFC's are currently not replicated, but I believe all other variables are). Now, session replication in CF is enterprise only, but I've been able to get it to work with CF7 Standard. This is not documented or supported by Macromedia AFAIK, but I don't think it's against the EULA. I am planning to write an article on it sometime soon. Look for it in the next few issues of Fusion Authority. Russ -Original Message- From: Tony Hicks [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 11:35 AM To: CF-Talk Subject: Re: Load Balancing issues Russ, Where can I find information on either of these? I'm using a hardware load balancer and we've been fiddling with the Affinity settings but nothings working better than 70% of the time (while both servers are up). I'm supposing these are Enterprise-only features? Also you can set up the loadbalancer to do sticky sessions (You can do this in coldfusion as well). This won't prevent people from losing their session if one of the servers fails, but it will send them to the same server as long as both servers are up. Russ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231264 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: MySQL 5 and CFMX7
Using JDBC drivers all of my MySQL data sources show a field length of 65535 regardless of data type. This is not specific to MySQL 5 with CFMX 7, I have had this problem since CF6.1 MySQL 4. I would love to resolve this issue! Have you tried one of the newer Mysql JDBC or ODBC drivers? http://www.mysql.com/products/connector/j/ http://dev.mysql.com/downloads/connector/odbc/ Also check to see if Mysql is actually running on port 3306. Dave On Feb 2, 2006, at 11:07 AM, Adkins, Randy wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231265 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: setting up network data source
Are you running SQL server on a standard port? Do you have some kind of firewall preventing access to the network for the cf service? Try running CF as a user or at least check 'allow to interact with desktop' checkbox. If you have any sort of firewall locally, disable it and see if that helps. Note, that windows SP2 comes with a firewall, and sometimes you might not even know that it's there and enabled. Russ -Original Message- From: Paul [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 12:39 PM To: CF-Talk Subject: RE: setting up network data source Sorry I didn't specify... SQL Server, yes. The server is using SQL authentication, which works when I connect using enterprise mgr but not cf admin. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 10:23 AM To: CF-Talk Subject: Re: setting up network data source SQL server i guess? What authentication is the server using - NT authenication or SQL authentication, that's usually the best place to start looking. jb. On 03/02/06, Paul [EMAIL PROTECTED] wrote: I'm trying to connect my local CF instance to a database on another server in my network, and I'm having trouble. Here's what I know. On my dev machine, I can successfully set up a System DSN using Win XP's admin tools. On my dev machine, I can successfully connect to the database using Enterprise Mgr. On the remote server, I can successfully create a datasource in CF Administrator to this database locally. On my dev machine, I cannot create a data source in CF Administrator. It times out trying to establish a connection. I suspect I may be making a stupid mistake - does anyone spot it? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231266 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
SMS Gateways
I heard some stuff when Macromedia first came out with the gateways for CFMX about the costs of SMS Gateways. Does anyone have round about figures for that? Pricing for the gateway account and then prices per message? I thought that it was pretty expensive but wanted to know if it's changed or if anyone knows more details. I don't need exact numbers, just an idea. Thanks! John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231267 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: Load Balancing issues
On 2/3/06, Russ [EMAIL PROTECTED] wrote: The load balancer has to specifically support sticky sessions. I think it does this via some sort of cookie, but I'm not entirely sure. Yes, depending on your HWLB device, it can set a cookie, go by IP address or segment, URL params, etc., aka, literally anything that can be used to identify the end-user. Smart ones will use a combination of these tricks. Now, session replication in CF is enterprise only, but I've been able to get it to work with CF7 Standard. This is not documented or supported by Macromedia AFAIK, but I don't think it's against the EULA. I am planning to write an article on it sometime soon. Look for it in the next few issues of Fusion Authority. You've peaked my interest. I'm wondering how it would be possible... of course there are always workarounds like client variables (yuck!) or other DB storage mechanisms, and at one point i'd thought up a plan to allow web service session lookups between servers. In any event, I'd love to hear what you've got. :) -nathan strutz http://www.dopefly.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231268 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: Load Balancing issues
Down these lines, does anyone have a recommendation for a good hardware load balancer? Doesn't have to be top of the line or have a ton of features. Just something reliable with decent features at a good price. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:50 PM To: CF-Talk Subject: Re: Load Balancing issues On 2/3/06, Russ [EMAIL PROTECTED] wrote: The load balancer has to specifically support sticky sessions. I think it does this via some sort of cookie, but I'm not entirely sure. Yes, depending on your HWLB device, it can set a cookie, go by IP address or segment, URL params, etc., aka, literally anything that can be used to identify the end-user. Smart ones will use a combination of these tricks. Now, session replication in CF is enterprise only, but I've been able to get it to work with CF7 Standard. This is not documented or supported by Macromedia AFAIK, but I don't think it's against the EULA. I am planning to write an article on it sometime soon. Look for it in the next few issues of Fusion Authority. You've peaked my interest. I'm wondering how it would be possible... of course there are always workarounds like client variables (yuck!) or other DB storage mechanisms, and at one point i'd thought up a plan to allow web service session lookups between servers. In any event, I'd love to hear what you've got. :) -nathan strutz http://www.dopefly.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231269 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: Query a mySQL View?
Works fine for me. --Ferg Rick Root wrote: Les Mizzell wrote: Hmmm - now that I can design a view in mySQL, how do I query the view in Coldfusion? Don't work like it does in SQL Server, where you cn just go: select * from myVIEW That's the way it's supposed to work. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231270 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: MySQL 5 and CFMX7
I've gotten it to work with upgraded ODBC drivers and with the ConnectorJ. --Ferg Scott Stroz wrote: I have been able to connect MySQL 5 and CF 7 using teh JDBC drivers without issue. On 2/2/06, Pete Ruckelshaus [EMAIL PROTECTED] wrote: I was only able to get MySQL to work with MX7 using an ODBC passthrough. It's really too bad that MySQL makes it so difficult for companies like Macromedia to get the Java version of their drivers so that they could update the default support in a point release...I mean it's only been, what, 3 years since mySQL3 was replaced by mySQL4? /SARCASM Seriously, Macromedia, update the darned mySQL drivers already. Pete On 2/2/06, Adkins, Randy [EMAIL PROTECTED] wrote: Does anyone have problems running MySQL 5 with CFMX 7? I have CMFX 7 and MySQL 4.1 but now the ODBC connections bomb out for the following error: Connection verification failed for data source: DEV_THISSITE java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231271 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: Load Balancing issues
We're using ServerIronXL in a shared environment managed by the hosting company. BigIp F5 is also supposed to be pretty good. Personally, I've never managed a loadbalancer, but if I had to go with the cheapest solution, I would roll my own using LVS. There is enough customization to allow you to do what you want. Also the latest version of apache allows it to be used as a loadbalancer. I haven't tested it yet, and I don't know if it supports sticky sessions, but it might very well be possible. Russ -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:53 PM To: CF-Talk Subject: RE: Load Balancing issues Down these lines, does anyone have a recommendation for a good hardware load balancer? Doesn't have to be top of the line or have a ton of features. Just something reliable with decent features at a good price. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:50 PM To: CF-Talk Subject: Re: Load Balancing issues On 2/3/06, Russ [EMAIL PROTECTED] wrote: The load balancer has to specifically support sticky sessions. I think it does this via some sort of cookie, but I'm not entirely sure. Yes, depending on your HWLB device, it can set a cookie, go by IP address or segment, URL params, etc., aka, literally anything that can be used to identify the end-user. Smart ones will use a combination of these tricks. Now, session replication in CF is enterprise only, but I've been able to get it to work with CF7 Standard. This is not documented or supported by Macromedia AFAIK, but I don't think it's against the EULA. I am planning to write an article on it sometime soon. Look for it in the next few issues of Fusion Authority. You've peaked my interest. I'm wondering how it would be possible... of course there are always workarounds like client variables (yuck!) or other DB storage mechanisms, and at one point i'd thought up a plan to allow web service session lookups between servers. In any event, I'd love to hear what you've got. :) -nathan strutz http://www.dopefly.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231272 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: Code Analyzer Desktop Program?
Tony Hicks wrote: I was wondering if there was a software written that analyzes code like the Admin tool does? The problem I'm having with the admin tool is that when I view a report, it asks me to login again. When I login, it tells me the data has expired... I've tried everything and I can't view the details. So I was hoping there might be a desktop application written that just analyzes for parse errors and such. For anything that shows up during compilation you can wire cfcompile.bat into your IDE. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231273 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: Query a mySQL View?
Sorry for the side topic on this, but I am in mysql setting up a new database for one of our new projects right now, and now that I am on mysql 5, I see Views now. I haven't ever used them before. What are they and what can they do? Thanks, On 2/3/06, Ken Ferguson [EMAIL PROTECTED] wrote: Works fine for me. --Ferg Rick Root wrote: Les Mizzell wrote: Hmmm - now that I can design a view in mySQL, how do I query the view in Coldfusion? Don't work like it does in SQL Server, where you cn just go: select * from myVIEW That's the way it's supposed to work. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231274 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: MySQL 5 and CFMX7
How does rds in HomeSite or DW display the field lengths? Are they all 65535? The reason this is important to me is because I have created a cfc wizard for Homesite that works great with SQL Server, but with MySQL data sources it thinks everything is 65535 in length. I have been able to connect MySQL 5 and CF 7 using teh JDBC drivers without issue. On 2/2/06, Pete Ruckelshaus [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231275 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: Query a mySQL View?
Ryan Guill wrote: Sorry for the side topic on this, but I am in mysql setting up a new database for one of our new projects right now, and now that I am on mysql 5, I see Views now. I haven't ever used them before. What are they and what can they do? A view is sort of like a table, except that is is actually a query. You sometimes use views to simplify complex joins. Like if you commonly join 5 tables, your sql query might get exceptionally complicated. But you could create a view, and query it as if it were one table instead of 5... create view myView as SELECT A.field1, A.field2, B.field3, B.field4 FROM table1 A inner join table2 B on A.id=b.id; select * from myView where field1 = 3 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231276 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: MySQL 5 and CFMX7
Pete Ruckelshaus wrote: I was only able to get MySQL to work with MX7 using an ODBC passthrough. It's really too bad that MySQL makes it so difficult for companies like Macromedia to get the Java version of their drivers so that they could update the default support in a point release...I mean it's only been, what, 3 years since mySQL3 was replaced by mySQL4? /SARCASM Seriously, Macromedia, update the darned mySQL drivers already. don't be too hard on Macromedia. From what I undestand, MySQL's modern JDBC drivers are released under a license that basically prohibits macromedia from distributing them. you don't have to do odbc passthru, you can just use Other and install a current MySQL JDBC Driver. That's why I do. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231277 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: Query a mySQL View?
Ah, awesome. Do you know where I could get more information on them? The MySql website is hard to navigate sometimes... On 2/3/06, Rick Root [EMAIL PROTECTED] wrote: Ryan Guill wrote: Sorry for the side topic on this, but I am in mysql setting up a new database for one of our new projects right now, and now that I am on mysql 5, I see Views now. I haven't ever used them before. What are they and what can they do? A view is sort of like a table, except that is is actually a query. You sometimes use views to simplify complex joins. Like if you commonly join 5 tables, your sql query might get exceptionally complicated. But you could create a view, and query it as if it were one table instead of 5... create view myView as SELECT A.field1, A.field2, B.field3, B.field4 FROM table1 A inner join table2 B on A.id=b.id; select * from myView where field1 = 3 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231278 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: MySQL 5 and CFMX7
Are you guys using the same/correct jdbc drivers? CF7 doesn't ship with MySQL drivers for version 4 and 5, you have to install them youself. Have you install the latest ones from the mysql website? Russ -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:21 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 How does rds in HomeSite or DW display the field lengths? Are they all 65535? The reason this is important to me is because I have created a cfc wizard for Homesite that works great with SQL Server, but with MySQL data sources it thinks everything is 65535 in length. I have been able to connect MySQL 5 and CF 7 using teh JDBC drivers without issue. On 2/2/06, Pete Ruckelshaus [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231279 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: Query a mySQL View?
Be honest. The mySQL website is a piece of crap. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:29 PM To: CF-Talk Subject: Re: Query a mySQL View? Ah, awesome. Do you know where I could get more information on them? The MySql website is hard to navigate sometimes... On 2/3/06, Rick Root [EMAIL PROTECTED] wrote: Ryan Guill wrote: Sorry for the side topic on this, but I am in mysql setting up a new database for one of our new projects right now, and now that I am on mysql 5, I see Views now. I haven't ever used them before. What are they and what can they do? A view is sort of like a table, except that is is actually a query. You sometimes use views to simplify complex joins. Like if you commonly join 5 tables, your sql query might get exceptionally complicated. But you could create a view, and query it as if it were one table instead of 5... create view myView as SELECT A.field1, A.field2, B.field3, B.field4 FROM table1 A inner join table2 B on A.id=b.id; select * from myView where field1 = 3 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231280 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: Load Balancing issues
Russ's 2 suggestions are excellent. ServerIron and BigIP. Both can be found for a steal on ebay quite a bit. If your on a budget stick with the ServerIron searches unless you want an old 4u BigIp. Emmet -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 2:02 PM To: CF-Talk Subject: RE: Load Balancing issues We're using ServerIronXL in a shared environment managed by the hosting company. BigIp F5 is also supposed to be pretty good. Personally, I've never managed a loadbalancer, but if I had to go with the cheapest solution, I would roll my own using LVS. There is enough customization to allow you to do what you want. Also the latest version of apache allows it to be used as a loadbalancer. I haven't tested it yet, and I don't know if it supports sticky sessions, but it might very well be possible. Russ -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:53 PM To: CF-Talk Subject: RE: Load Balancing issues Down these lines, does anyone have a recommendation for a good hardware load balancer? Doesn't have to be top of the line or have a ton of features. Just something reliable with decent features at a good price. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:50 PM To: CF-Talk Subject: Re: Load Balancing issues On 2/3/06, Russ [EMAIL PROTECTED] wrote: The load balancer has to specifically support sticky sessions. I think it does this via some sort of cookie, but I'm not entirely sure. Yes, depending on your HWLB device, it can set a cookie, go by IP address or segment, URL params, etc., aka, literally anything that can be used to identify the end-user. Smart ones will use a combination of these tricks. Now, session replication in CF is enterprise only, but I've been able to get it to work with CF7 Standard. This is not documented or supported by Macromedia AFAIK, but I don't think it's against the EULA. I am planning to write an article on it sometime soon. Look for it in the next few issues of Fusion Authority. You've peaked my interest. I'm wondering how it would be possible... of course there are always workarounds like client variables (yuck!) or other DB storage mechanisms, and at one point i'd thought up a plan to allow web service session lookups between servers. In any event, I'd love to hear what you've got. :) -nathan strutz http://www.dopefly.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231281 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
ImageCFC component Available
Hi all, http://www.opensourcecf.com/imagecfc I've got my new image.cfc component ready for public consumption. I'm calling it 2.00 beta 1 right now. 2.00 because it's based on Jim Dew's original work. Beta because it's not thoroughly tested. It *HAS* been tested on CFMX 7 (Windows and Linux) and Bluedragon 6.2 JX (Linux). Should also work on CFMX 6.1. The most important feature is that it supports specifying JPEG compression, allowing you to increase your output quality as long as you're willing to accept he increase in file size. The CFC includes the following methods: getImageInfo(), rotate(), scaleX() scaleY(), resize(), flipHorizontal(), flipVertical(), crop(), and convert() It will read JPG, PNG, and GIF images from local files or from URLS. It will write JPG and PNG files. Any valid readable format can be converted to a valid writeable format. All functions can take a file, URL, or BufferedImage object as input. All functions can output a file OR return a BufferedImage object. all functions optionally accept a JPEG compression argument, a number between 0 and 100. The default is 90. Rick Root ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231282 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: Comcast blacklisting solutions?
Obviously you've never worked for a large ISP help desk that answers complaint after complaint about spam. It's more cost effective to put the hammer down and inconvenience a minority then watch customer satisfaction levels plummet and support costs rise. Emmet -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 8:55 PM To: CF-Talk Subject: Re: Comcast blacklisting solutions? I've sent an email to Comcast with no answer, of course. This is indeed the most stupid thing in the whole story : they black list you, then you cannot even ask them why?. I receive about 200 spams per day, so what ? I get about 99% filtered by Thunderbird, but I'm sure that any of my customers messages will get through. The server my mail was managed before had a spam filter. It ws so busy to analyse all messages that sometimes it took 4 hours to receive a mesage I sent to myself ! Some get paranoïd with spam, and they harm others 10 times more than spam does. This reminds me some Usenet maniacs who spend hours and 1000s of lines in messages to explain others why they should not overload the banwidth ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231283 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: Query a mySQL View?
LOL, I didnt want to be that blunt. But yeah, it sucks. On 2/3/06, Andy Matthews [EMAIL PROTECTED] wrote: Be honest. The mySQL website is a piece of crap. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:29 PM To: CF-Talk Subject: Re: Query a mySQL View? Ah, awesome. Do you know where I could get more information on them? The MySql website is hard to navigate sometimes... -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com Use CF and SQL? Try qBrowser - http://www.ryanguill.com/docs/ www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231284 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: Issue with CSS and doctype
Can anyone help me out. When i change the doctype it completely changes how it looks. I have no idea why. Can anyone explain. Raw css is first. ...container { color: #00; font-family:tahoma, verdana, helvetica; font-size: 11px; background-color: #f1f1ed; width:170px; height: 100%; border-right: buttonshadow 1px solid; border-top: #f5f5f5 1px solid; border-left: #f5f5f5 1px solid; border-bottom: buttonshadow 1px solid; padding-right : 1px; padding-top : 1px; padding-bottom : 1px; } ...leftMenu { color:#006699; text-decoration:none; font-weight:bold; } ...leftMenu:hover { color:#00; text-decoration:none; font-weight:bold; } ...leftMenu:active { color:#00; text-decoration:none; font-weight:bold ; } ...Menu { height: 20px; padding-top : 2px; padding-right : 5px; padding-bottom : 3px; padding-left : 2px; border-right: buttonshadow 1px solid; border-top: #f5f5f5 1px solid; border-left: #f5f5f5 1px solid; border-bottom: buttonshadow 1px solid; background-color: #D4D0C8; cursor:pointer; color:#00; } ...Option { height: 20px; padding-top : 2px; padding-right : 5px; padding-bottom : 3px; padding-left : 16px; background-color: #f5f5f5; border-top : 1px solid #ff; border-bottom : 1px solid #ff; border-left : 1px solid #ff; border-right : 1px solid #ff; cursor:pointer; } ...Options { padding-top : 1px; padding-right : 1px; padding-bottom : 1px; padding-left : 1px; } ...imgPosition { vertical-align: middle; } !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; xml:lang=en lang=en-AU head meta http-equiv=content-type content=application/xhtml+xml; charset=UTF-8 / titleTransportation Scheduler [LOGIN]/title /head body table border=0 cellspacing=0 cellpadding=0 style=height: 100%; tr td valign=top script src=resources/leftMenu/leftmenu.js type= language=JavaScript/script link href=resources/leftMenu/leftmenu.css rel=stylesheet type=text/css / div class=container div id=parent div class=menu onMouseOver=this.style.background='#F9CD75' onMouseOut=this.style.background='#D4D0C8' onClick=TrocaMenu('sub0')img src=resources/leftMenu/icons/txtmenu.gif width=20 height=20 alt=Text Folders class=imgPosition border=0 / Text Folders/div span id=sub0 class=options div class=option onclick=location.href('http://www.yahoo.com'); onmouseover=this.style.background='#D8E4F8' onmouseout=this.style.background='#f5f5f5' img src=resources/leftMenu/icons/txtfolder.gif width=16 height=16 alt=Text Links class=imgPosition hspace=3 border=0 / Text Links/div div class=option onClick=location.href('master.asp?code=modulos'); onMouseOver=this.style.background='#D8E4F8' onMouseOut=this.style.background='#f5f5f5' img src=resources/leftMenu/icons/txtfolder.gif width=16 height=16 alt=Text Links class=imgPosition hspace=3 border=0 / Text Links/div div class=option onClick=location.href('master.asp?code=sobre'); onMouseOver=this.style.background='#D8E4F8' onMouseOut=this.style.background='#f5f5f5' img src=resources/leftMenu/icons/txtfolder.gif width=16 height=16 alt=Text Links class=imgPosition hspace=3 border=0 / Text Links/div /span /div /div /div /td /tr /table /body /html
RE: setting up network data source
On my dev machine, I can successfully set up a System DSN using Win XP's admin tools. On my dev machine, I can successfully connect to the database using Enterprise Mgr. On the remote server, I can successfully create a datasource in CF Administrator to this database locally. On my dev machine, I cannot create a data source in CF Administrator. It times out trying to establish a connection. Are you sure you're connecting using a native SQL login when you're using Enterprise Manager? If so, perhaps you're connecting via Named Pipes instead of via TCP/IP. Make sure that your SQL Server is configured to accept TCP/IP connections. You can do this using the Server Network Utility from the server console. 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! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231286 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: Issue with CSS and doctype
Does it validate as strict? -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:45 PM To: CF-Talk Subject: OT: Issue with CSS and doctype Can anyone help me out. When i change the doctype it completely changes how it looks. I have no idea why. Can anyone explain. Raw css is first. container { color: #00; font-family:tahoma, verdana, helvetica; font-size: 11px; background-color: #f1f1ed; width:170px; height: 100%; border-right: buttonshadow 1px solid; border-top: #f5f5f5 1px solid; border-left: #f5f5f5 1px solid; border-bottom: buttonshadow 1px solid; padding-right : 1px; padding-top : 1px; padding-bottom : 1px; } leftMenu { color:#006699; text-decoration:none; font-weight:bold; } leftMenu:hover { color:#00; text-decoration:none; font-weight:bold; } leftMenu:active { color:#00; text-decoration:none; font-weight:bold ; } Menu { height: 20px; padding-top : 2px; padding-right : 5px; padding-bottom : 3px; padding-left : 2px; border-right: buttonshadow 1px solid; border-top: #f5f5f5 1px solid; border-left: #f5f5f5 1px solid; border-bottom: buttonshadow 1px solid; background-color: #D4D0C8; cursor:pointer; color:#00; } Option { height: 20px; padding-top : 2px; padding-right : 5px; padding-bottom : 3px; padding-left : 16px; background-color: #f5f5f5; border-top : 1px solid #ff; border-bottom : 1px solid #ff; border-left : 1px solid #ff; border-right : 1px solid #ff; cursor:pointer; } Options { padding-top : 1px; padding-right : 1px; padding-bottom : 1px; padding-left : 1px; } imgPosition { vertical-align: middle; } !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; xml:lang=en lang=en-AU head meta http-equiv=content-type content=application/xhtml+xml; charset=UTF-8 / titleTransportation Scheduler [LOGIN]/title /head body table border=0 cellspacing=0 cellpadding=0 style=height: 100%; tr td valign=top script src=resources/leftMenu/leftmenu.js type= language=JavaScript/script link href=resources/leftMenu/leftmenu.css rel=stylesheet type=text/css / div class=container div id=parent div class=menu onMouseOver=this.style.background='#F9CD75' onMouseOut=this.style.background='#D4D0C8' onClick=TrocaMenu('sub0')img src=resources/leftMenu/icons/txtmenu.gif width=20 height=20 alt=Text Folders class=imgPosition border=0 / Text Folders/div span id=sub0 class=options div class=option onclick=location.href('http://www.yahoo.com'); onmouseover=this.style.background='#D8E4F8' onmouseout=this.style.background='#f5f5f5' img src=resources/leftMenu/icons/txtfolder.gif width=16 height=16 alt=Text Links class=imgPosition hspace=3 border=0 / Text Links/div div class=option onClick=location.href('master.asp?code=modulos'); onMouseOver=this.style.background='#D8E4F8' onMouseOut=this.style.background='#f5f5f5' img src=resources/leftMenu/icons/txtfolder.gif width=16 height=16 alt=Text Links class=imgPosition hspace=3 border=0 / Text Links/div div class=option onClick=location.href('master.asp?code=sobre'); onMouseOver=this.style.background='#D8E4F8' onMouseOut=this.style.background='#f5f5f5' img src=resources/leftMenu/icons/txtfolder.gif width=16 height=16 alt=Text Links class=imgPosition hspace=3 border=0 / Text Links/div /span /div /div
RE: Query a mySQL View?
The best thing to do with the MySQL site is search it through google: views site:http://dev.mysql.com/doc/refman/5.1 Then it becomes awesome again ;-) Baz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231288 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: Issue with CSS and doctype
It doesn't validate, but the errors are on the javascript, it's the display that is the issue. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231289 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: setting up network data source
Thanks for the ideas Dave. I double-checked the SQL login - that's what I'm using in enterprise mgr. TCP/IP is also already enabled - I really thought that would be the solution earlier... Doesn't enterprise mgr use port 1433 just like CF? What does CF do differently from enterprise mgr or the System DSN console in establishing database connections? I'm puzzled. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 12:49 PM To: CF-Talk Subject: RE: setting up network data source On my dev machine, I can successfully set up a System DSN using Win XP's admin tools. On my dev machine, I can successfully connect to the database using Enterprise Mgr. On the remote server, I can successfully create a datasource in CF Administrator to this database locally. On my dev machine, I cannot create a data source in CF Administrator. It times out trying to establish a connection. Are you sure you're connecting using a native SQL login when you're using Enterprise Manager? If so, perhaps you're connecting via Named Pipes instead of via TCP/IP. Make sure that your SQL Server is configured to accept TCP/IP connections. You can do this using the Server Network Utility from the server console. 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! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231290 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: OT: Issue with CSS and doctype
You might want to try the css-discuss list: http://www.css-discuss.org They are *very* good at everything css... mike Robert Everland III wrote: Can anyone help me out. When i change the doctype it completely changes how it looks. I have no idea why. Can anyone explain. Raw css is first. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231291 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
Creating a string of len(x)
So I want to create a function to create string of arbitrary length before I put anything into it (well, printable characters anyway) So I'm thinking there must be something better than Loop 1 to x time cfset Thisstring = thisstring+ Loop And it's probably really obvious, but can somebody shoot me a clue. (list? Array of char?) Thanks. -Nate ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231292 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: Creating a string of len(x)
From: Nathan C. Smith [mailto:[EMAIL PROTECTED] So I want to create a function to create string of arbitrary length before I put anything into it (well, printable characters anyway) So I'm thinking there must be something better than Loop 1 to x time cfset Thisstring = thisstring+ Loop And it's probably really obvious, but can somebody shoot me a clue. (list? Array of char?) RepeatString(string,count) :-) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231293 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: MySQL 5 and CFMX7
Yes I've installed the latest drivers from the MySQL site. It never has made a difference. What I've been wondering is what MySQL engine should I be using MyISAM or the default InnoDB? Are you guys using the same/correct jdbc drivers? CF7 doesn't ship with MySQL drivers for version 4 and 5, you have to install them youself. Have you install the latest ones from the mysql website? Russ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231294 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: Creating a string of len(x)
Much better, many thanks. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 2:32 PM To: CF-Talk Subject: RE: Creating a string of len(x) From: Nathan C. Smith [mailto:[EMAIL PROTECTED] So I want to create a function to create string of arbitrary length before I put anything into it (well, printable characters anyway) So I'm thinking there must be something better than Loop 1 to x time cfset Thisstring = thisstring+ Loop And it's probably really obvious, but can somebody shoot me a clue. (list? Array of char?) RepeatString(string,count) :-) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231295 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: MySQL 5 and CFMX7
Stan Winchester wrote: Yes I've installed the latest drivers from the MySQL site. It never has made a difference. What I've been wondering is what MySQL engine should I be using MyISAM or the default InnoDB? From coldfusion's perspective, it doesn't really matter unless you want to use transactions... so you downloaded the new mysql connectorJ, installed the jar file in the appropriatel ocation, and then used the other datasource type instead of the mysql datasource type, and it still didn't work? Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231296 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: Issue with CSS and doctype
Is that triple dot ellipse thing part of the actual CSS markup that I am not familiar with or just an artifact of the email message? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231297 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: Comcast blacklisting solutions?
It's more cost effective to put the hammer down and inconvenience a minority then watch customer satisfaction levels plummet and support costs rise. This is not an excuse for not providing at least one address to which, even black listed people, could mail enquiries about what is the problem. This was my point. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231298 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 network data source
Thanks for the ideas Dave. I double-checked the SQL login - that's what I'm using in enterprise mgr. TCP/IP is also already enabled - I really thought that would be the solution earlier... Doesn't enterprise mgr use port 1433 just like CF? What does CF do differently from enterprise mgr or the System DSN console in establishing database connections? I'm puzzled. Enterprise Manager (and CF) use whatever port they're told to use. The default SQL Server listener is on TCP/1433. You would have to look in your Client Network Utility to see what you're actually using. Enterprise Manager and your System DSN could well be using Named Pipes instead of TCP/IP. 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! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231299 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: Issue with CSS and doctype
What is the nature of the problem? After moving the script tag link tag to the head section where I believe they belong. I ran this sample and I got something, but I don't know if it is a wrong something or a correct something. Using my FF validator function, There where these 7 warnings, but no errors. Some of these warnings may help you out, since they seem to point to improper nesting which could cause all kinds of undesirable behavior. line 6 column 91 - Warning: adjacent hyphens within comment line 25 column 7 - Warning: missing /span before div line 27 column 1 - Warning: inserting implicit span line 36 column 16 - Warning: discarding unexpected /span line 42 column 4 - Warning: discarding unexpected /div line 14 column 1 - Warning: table lacks summary attribute line 27 column 1 - Warning: span anchor sub0 already defined -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231300 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
Flash CFForm Style
I need to be able to set the background color of a Flash CFForm DateField input box. Any idea how to do this? Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231301 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: setting up network data source
Both use the same port here. It must be to do with TCP, assuming the other two are using named pipes. I'll see what I can stir up, I guess. Thanks for taking some time on this. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:53 PM To: CF-Talk Subject: RE: setting up network data source Thanks for the ideas Dave. I double-checked the SQL login - that's what I'm using in enterprise mgr. TCP/IP is also already enabled - I really thought that would be the solution earlier... Doesn't enterprise mgr use port 1433 just like CF? What does CF do differently from enterprise mgr or the System DSN console in establishing database connections? I'm puzzled. Enterprise Manager (and CF) use whatever port they're told to use. The default SQL Server listener is on TCP/1433. You would have to look in your Client Network Utility to see what you're actually using. Enterprise Manager and your System DSN could well be using Named Pipes instead of TCP/IP. 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! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231302 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: Issue with CSS and doctype
Turns out the issue was with the case of one of my css classes. Once I changed it, it was working fine. So now I get it. Thanks for your help. The emails add in the double .. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231303 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: Flash CFForm Style
I have been working on a form with custom colors.. here is the code I found and am using. There are alot of global styles listed below. For background color you only need one, but I figured I will give you all that I have and let you pick out what you need. cfform name=myform height=450 width=465 format=Flash onload=formOnLoad() cfformitem type=script function formOnLoad() { // Do anything that you need to do in the onload Event // call the function that is in charge of applying the styles applyStyles(); } function applyStyles() { _global.styles.CheckBox.setStyle(fillColors, [0xa7a7a7, 0xff]); _global.styles.RadioButton.setStyle(fillColors, [0x006699, 0xff]); _global.styles.Form.setStyle(color, 0x00); _global.styles.Button.setStyle(borderThickness, 1); _global.styles.Panel.setStyle(backgroundColor, 0xE5F0F9); _global.styles.Panel.setStyle(color, 0xff); _global.styles.Panel.setStyle(headerColors, [0x277DC6,0x50ABF7]); _global.styles.HBox.setStyle(backgroundColor, 0x757575); _global.styles.HBox.setStyle(marginTop, 10); _global.styles.HBox.setStyle(marginBottom, 10); _global.styles.HBox.setStyle(marginLeft, 10); _global.styles.Accordion.setStyle(fillColors, [0x547000,0x739802]); _global.styles.Accordion.setStyle(selectedFillColors, [0x84af00,0xa3d800]); _global.styles.Accordion.setStyle(themeColor, 0x0066cc); _global.styles.Accordion.setStyle(color, 0x0ff); _global.styles.TextArea.setStyle(fontSize,14); _global.styles.TextInput.setStyle(fontSize,9); _global.styles.DataGrid.setStyle(rollOverColor, 0xf5ffd7); _global.styles.DataGrid.setStyle(selectionColor, 0x84af00); _global.styles.DataGrid.setStyle(headerColors, [0xa6a6a6,0xe2e2e2]); !--- _global.styles.Tab.setStyle(fillColors, [0x277DC6,0x50ABF7]); _global.styles.Tab.setStyle(selectedFillColors, [0xff6600,0xffcc00]); _global.styles.VBox.setStyle(backgroundColor, 0x507A9C); _global.styles.ComboBox.setStyle(fillColors, [0x006699, 0xff]); _global.styles.ComboBox.setStyle(backgroundColor, 0x006699); _global.styles.CalendarLayout.setStyle(rollOverColor,0x996699); _global.styles.CalendarLayout.setStyle(selectionColor,0xcc33ff); _global.styles.CalendarLayout.setStyle(todayColor,0xcc33ff); _global.styles.ErrorTip.setStyle( borderColor, 0x339900); _global.styles.ErrorTip.setStyle( color, 0x00); _global.styles.DataGrid.setStyle(alternatingRowColors, [0xff,0xf5ffd7]); --- } /cfformitem cfformgroup type=hBox cfformgroup type=accordion width=435 height=420 label=Containers cfformgroup type=page label=employee accounts !--- onchange=getUrl('WizEmployeeReview.cfm?userid=' + grid.dataProvider[grid.selectedIndex]['userid']); --- cfgrid name=grid height=320 width=405 query=ListUsers insert=No delete=No sort=No autowidth=true appendkey=No highlighthref=No enabled=Yes visible=Yes griddataalign=LEFT gridlines=no rowheaders=No rowheaderalign=LEFT rowheaderitalic=No rowheaderbold=No colheaders=Yes colheaderalign=LEFT colheaderitalic=No colheaderbold=no selectmode=SINGLE cfgridcolumn name=lname header=Name (last) headeralign=LEFT dataalign=LEFT bold=No italic=No select=Yes display=Yes cfgridcolumn name=fname header=Name (first) headeralign=LEFT dataalign=LEFT bold=No italic=No select=Yes display=Yes headerbold=No headeritalic=No cfgridcolumn name=location_title header=Location headeralign=LEFT dataalign=LEFT bold=No italic=No select=Yes display=Yes headerbold=No headeritalic=No /cfgrid /cfformgroup cfformgroup type=page label=account review / edit cfformgroup type=horizontal label=Name (first/last): visible=Yes enabled=Yes cfinput type=Text name=fname bind={grid.selectedItem.fname} width=100 message=First Name is required validate=noblanks required=Yes visible=Yes enabled=Yes cfinput type=text name=lname bind={grid.selectedItem.lname} width=100 required=true validate=noblanks message=Last name is required /cfformgroup cfinput type=text name=email label=Email: bind={grid.selectedItem.email} width=210 required=true cfformgroup
Re: setting up network data source
I would still look into firewall issues...Named Pipes uses the same ports as File and Print sharing, so some firewall may be letting that through, but not 1433 (TCP). -jim On 2/3/06, Paul [EMAIL PROTECTED] wrote: Both use the same port here. It must be to do with TCP, assuming the other two are using named pipes. I'll see what I can stir up, I guess. Thanks for taking some time on this. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231305 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: Flash CFForm Style
Great, thanks! Mike -Original Message- From: Michael Grove [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 2:21 PM To: CF-Talk Subject: Re: Flash CFForm Style I have been working on a form with custom colors.. here is the code I found and am using. There are alot of global styles listed below. For background color you only need one, but I figured I will give you all that I have and let you pick out what you need. cfform name=myform height=450 width=465 format=Flash onload=formOnLoad() cfformitem type=script function formOnLoad() { // Do anything that you need to do in the onload Event // call the function that is in charge of applying the styles applyStyles(); } function applyStyles() { _global.styles.CheckBox.setStyle(fillColors, [0xa7a7a7, 0xff]); _global.styles.RadioButton.setStyle(fillColors, [0x006699, 0xff]); _global.styles.Form.setStyle(color, 0x00); _global.styles.Button.setStyle(borderThickness, 1); _global.styles.Panel.setStyle(backgroundColor, 0xE5F0F9); _global.styles.Panel.setStyle(color, 0xff); _global.styles.Panel.setStyle(headerColors, [0x277DC6,0x50ABF7]); _global.styles.HBox.setStyle(backgroundColor, 0x757575); _global.styles.HBox.setStyle(marginTop, 10); _global.styles.HBox.setStyle(marginBottom, 10); _global.styles.HBox.setStyle(marginLeft, 10); _global.styles.Accordion.setStyle(fillColors, [0x547000,0x739802]); _global.styles.Accordion.setStyle(selectedFillColors, [0x84af00,0xa3d800]); _global.styles.Accordion.setStyle(themeColor, 0x0066cc); _global.styles.Accordion.setStyle(color, 0x0ff); _global.styles.TextArea.setStyle(fontSize,14); _global.styles.TextInput.setStyle(fontSize,9); _global.styles.DataGrid.setStyle(rollOverColor, 0xf5ffd7); _global.styles.DataGrid.setStyle(selectionColor, 0x84af00); _global.styles.DataGrid.setStyle(headerColors, [0xa6a6a6,0xe2e2e2]); !--- _global.styles.Tab.setStyle(fillColors, [0x277DC6,0x50ABF7]); _global.styles.Tab.setStyle(selectedFillColors, [0xff6600,0xffcc00]); _global.styles.VBox.setStyle(backgroundColor, 0x507A9C); _global.styles.ComboBox.setStyle(fillColors, [0x006699, 0xff]); _global.styles.ComboBox.setStyle(backgroundColor, 0x006699); _global.styles.CalendarLayout.setStyle(rollOverColor,0x996699); _global.styles.CalendarLayout.setStyle(selectionColor,0xcc33ff); _global.styles.CalendarLayout.setStyle(todayColor,0xcc33ff); _global.styles.ErrorTip.setStyle( borderColor, 0x339900); _global.styles.ErrorTip.setStyle( color, 0x00); _global.styles.DataGrid.setStyle(alternatingRowColors, [0xff,0xf5ffd7]); --- } /cfformitem cfformgroup type=hBox cfformgroup type=accordion width=435 height=420 label=Containers cfformgroup type=page label=employee accounts !--- onchange=getUrl('WizEmployeeReview.cfm?userid=' + grid.dataProvider[grid.selectedIndex]['userid']); --- cfgrid name=grid height=320 width=405 query=ListUsers insert=No delete=No sort=No autowidth=true appendkey=No highlighthref=No enabled=Yes visible=Yes griddataalign=LEFT gridlines=no rowheaders=No rowheaderalign=LEFT rowheaderitalic=No rowheaderbold=No colheaders=Yes colheaderalign=LEFT colheaderitalic=No colheaderbold=no selectmode=SINGLE cfgridcolumn name=lname header=Name (last) headeralign=LEFT dataalign=LEFT bold=No italic=No select=Yes display=Yes cfgridcolumn name=fname header=Name (first) headeralign=LEFT dataalign=LEFT bold=No italic=No select=Yes display=Yes headerbold=No headeritalic=No cfgridcolumn name=location_title header=Location headeralign=LEFT dataalign=LEFT bold=No italic=No select=Yes display=Yes headerbold=No headeritalic=No /cfgrid /cfformgroup cfformgroup type=page label=account review / edit cfformgroup type=horizontal label=Name (first/last): visible=Yes enabled=Yes cfinput type=Text name=fname bind={grid.selectedItem.fname} width=100 message=First Name is required validate=noblanks required=Yes visible=Yes enabled=Yes cfinput type=text name=lname bind={grid.selectedItem.lname} width=100 required=true validate=noblanks message=Last name is required /cfformgroup cfinput
passing mulitple values from the same form field
Does anyone know how I can pass multiple values for an insert from grouped radio inputs? Not sure if I'm explaining it correctly but here it goes. I'm using a query group to group the radio inputs. I set up a counter for the group heading so each group can have a unique name. input name=option#count# value=#option_ID# type=radio / cfset counter = 0 example: group cfset counter = counter + 1 option1 option1 option1 group cfset counter = counter + 1 option2 option2 option2 I want to pass the form fields option#count# to a custom tag: cfmodule template=addOption.cfm action = add option = #FORM.option#counter## other1 = #FORM.other1# other1 = #FORM.other1# How can I pass the form option variables which can be many with the other(s) form variables which can on be one each? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231307 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: ImageCFC component Available
Thanks Rick:) ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Rick Root [EMAIL PROTECTED] Sent: Friday, February 03, 2006 2:39 PM To: CF-Talk cf-talk@houseoffusion.com Subject: ImageCFC component Available Hi all, http://www.opensourcecf.com/imagecfc I've got my new image.cfc component ready for public consumption. I'm calling it 2.00 beta 1 right now. 2.00 because it's based on Jim Dew's original work. Beta because it's not thoroughly tested. It *HAS* been tested on CFMX 7 (Windows and Linux) and Bluedragon 6.2 JX (Linux). Should also work on CFMX 6.1. The most important feature is that it supports specifying JPEG compression, allowing you to increase your output quality as long as you're willing to accept he increase in file size. The CFC includes the following methods: getImageInfo(), rotate(), scaleX() scaleY(), resize(), flipHorizontal(), flipVertical(), crop(), and convert() It will read JPG, PNG, and GIF images from local files or from URLS. It will write JPG and PNG files. Any valid readable format can be converted to a valid writeable format. All functions can take a file, URL, or BufferedImage object as input. All functions can output a file OR return a BufferedImage object. all functions optionally accept a JPEG compression argument, a number between 0 and 100. The default is 90. Rick Root ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231308 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: passing multiple values from the same form field
I have no idea what you are really trying to do. It sounds very convoluted. But hopefully the answer to your question is the array notation for form data. It usually is for these kinds of serially numbered fields. #form[fieldname counter]# HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231309 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
evaluate hell
Could someone translate this (and how to get out of it) #Evaluate(GetInventory.#GetListingFields.DBColName[GetListingFields.currentRow]#[#GetInventory.CurrentRow#])# TIA, Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231310 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: evaluate hell
I guess GetInventory is a query so: GetInventory[GetListingFields.DBColName[GetListingFields.CurrentRow]][GetInv entory.CurrentRow] With GetListingFields.DBColName[GetListingFields.CurrentRow] equating to a column in GetInventory. Is that the sort of explaination you were after? Adrian -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: 03 February 2006 22:32 To: CF-Talk Subject: evaluate hell Could someone translate this (and how to get out of it) #Evaluate(GetInventory.#GetListingFields.DBColName[GetListingFields.current Row]#[#GetInventory.CurrentRow#])# TIA, Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231311 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: evaluate hell
Could someone translate this (and how to get out of it) #Evaluate(GetInventory.#GetListingFields.DBColName[GetListingFields.currentRow]#[#GetInventory.CurrentRow#])# TIA, Cutter U maybe ... cfscript aField = GetListingFields.DBColName[GetListingFields.currentRow]; aRow = GetInventory.CurrentRow something = GetInventory[aField][aRow]; /cfscript -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231312 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: evaluate hell
GetInventory[GetListingFields.DBColName[GetListingFields.CurrentRow]][GetInv entory.CurrentRow] Adrian I wonder if that nested square brackets is allowed. It may have been the reason to do with that convoluted evaluate version. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231313 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
evaluate hell Pt2
Need serious help rewriting this statement without using evaluate: cfif isdefined(GetInventory.#GetListingFields.DBColName#) and evaluate(GetInventory.#GetListingFields.DBColName#[#GetInventory.currentrow#]) NEQ 0 AND Trim(evaluate(GetInventory.#GetListingFields.DBColName#[#GetInventory.currentrow#])) NEQ (I'm confused???) Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231314 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 network data source
I fixed it... It was the security policy on the db server; I had enabled port 1433 but not the SQL Server listener... or something. I'm not very familiar with Win2k3's security config stuff just yet. Thanks again for your advice. -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 2:23 PM To: CF-Talk Subject: Re: setting up network data source I would still look into firewall issues...Named Pipes uses the same ports as File and Print sharing, so some firewall may be letting that through, but not 1433 (TCP). -jim On 2/3/06, Paul [EMAIL PROTECTED] wrote: Both use the same port here. It must be to do with TCP, assuming the other two are using named pipes. I'll see what I can stir up, I guess. Thanks for taking some time on this. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231315 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: evaluate hell
Yeah, you can nest sqaure brackets. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 03 February 2006 22:43 To: CF-Talk Subject: RE: evaluate hell GetInventory[GetListingFields.DBColName[GetListingFields.CurrentRow]][GetInv entory.CurrentRow] Adrian I wonder if that nested square brackets is allowed. It may have been the reason to do with that convoluted evaluate version. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231316 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: OT: Issue with CSS and doctype
Browsers have two rendering modes. quirks mode, is where a browser attempts to render a page in the way it used to (think Best viewed with) Standards mode is where a browser attempts to render a page according to web standards mode (which basically is close to the same in each browser, tho each browser does have bugs) Browsers use DocTypes to sniff the rendering mode it will use. No DocType will always a revert a browser to quirks mode. Unfortunately, different browsers sniff different doctypes into different modes. The only doctypes that render standards mode across all browsers are: HTML 4.x Strict !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01//EN http://www.w3.org/TR/html4/strict.dtd; HTML 4.01 Transitional !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd; XHTML 1.0 Strict (no xml Declaration) !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; XHTML 1.0 Transitional (no xml Declaration) !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; the XHTML 1.1 doctypes will also force Standards mode, but IE has problems with it. Using an xml declaration with the DocType will Force IE6 and opera into Quirks Mode. Avoid using ?xml version=1.0 encoding=UTF-8? An example of what might be different is that IE 5.x and IE6 in quirks mode use a broken box model. In standards mode, IE6 will use the CSS standards box model. Its a major difference. The standard box model says that the width property is equal to the content width and all padding, borders and margins are in addition to the width. The broken box model that IE uses says the width property is equal to the content width, plus all padding and borders. so using that, if for example I had the following: div{ width: 10em; padding: 1em; border: .1em; } IE would actually subtract 2.2em from the 10em leaving just 7.8em for your content. Standards rendering would use 10em and the padding and border would be on their own. Hope that helps Sandy Clark -Original Message- From: Mike Soultanian [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 3:26 PM To: CF-Talk Subject: Re: OT: Issue with CSS and doctype You might want to try the css-discuss list: http://www.css-discuss.org They are *very* good at everything css... mike Robert Everland III wrote: Can anyone help me out. When i change the doctype it completely changes how it looks. I have no idea why. Can anyone explain. Raw css is first. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231317 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: evaluate hell Pt2
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] cfif isdefined(GetInventory.#GetListingFields.DBColName#) and evaluate(GetInventory.#GetListingFields.DBColName#[#GetInvent ory.currentrow#]) NEQ 0 AND Trim(evaluate(GetInventory.#GetListingFields.DBColName#[#GetI nventory.currentrow#])) NEQ Is GetListingFields a query also? Just off the top of my head isdefined(GetInventory[GetListingFields[DBColName]]) and val(GetInventory[GetListingFields[DBColName]][GetInventory.currentrow]) neq 0 and len(trim(GetInventory[GetListingFields[DBColName]][GetInventory.currentrow]) ) neq 0 Tango ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231319 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: MySQL 5 and CFMX7 (New Problem)
Now I removed MySQL 5 and ran regClean to clean the registries. Then re-installed MySQL 5. Downloaded the Connectors/J for 5.0 from MySQL copied the mysql-connector-java-5.0.0-beta-bin.jar into CfusionMX7 \ wwwroot \ web-inf\ lib folder. Restarted ColdFusion. Added the datasource using Other: jdbc:mysql://localhost:3306/myTest com.mysql.jdbc.Driver and now I have this error. Yes... MySQL is running on Port 3306 Yes... I can connect to MySQL 5.0 using NaviCat using Localhost:3306 Any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231320 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: MySQL 5 and CFMX7 (New Problem)
what error? On 2/3/06, ColdFusion [EMAIL PROTECTED] wrote: Now I removed MySQL 5 and ran regClean to clean the registries. Then re-installed MySQL 5. Downloaded the Connectors/J for 5.0 from MySQL copied the mysql-connector-java-5.0.0-beta-bin.jar into CfusionMX7 \ wwwroot \ web-inf\ lib folder. Restarted ColdFusion. Added the datasource using Other: jdbc:mysql://localhost:3306/myTest com.mysql.jdbc.Driver and now I have this error. Yes... MySQL is running on Port 3306 Yes... I can connect to MySQL 5.0 using NaviCat using Localhost:3306 Any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231321 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: MySQL 5 and CFMX7 (New Problem)
Guess that would help java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 6:53 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) what error? On 2/3/06, ColdFusion [EMAIL PROTECTED] wrote: Now I removed MySQL 5 and ran regClean to clean the registries. Then re-installed MySQL 5. Downloaded the Connectors/J for 5.0 from MySQL copied the mysql-connector-java-5.0.0-beta-bin.jar into CfusionMX7 \ wwwroot \ web-inf\ lib folder. Restarted ColdFusion. Added the datasource using Other: jdbc:mysql://localhost:3306/myTest com.mysql.jdbc.Driver and now I have this error. Yes... MySQL is running on Port 3306 Yes... I can connect to MySQL 5.0 using NaviCat using Localhost:3306 Any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231322 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: MySQL 5 and CFMX7 (New Problem)
Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class path? You have to restart CF after you add it so that the jdbc driver gets loaded in. Here is a link to how to install the postgress driver. The mysql setup should be similar. http://cfguru.daemon.com.au/archives/82.html Dave ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231323 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
Equivalent to Java 'import package.class;'?
Is there an equivalent to Java's 'import package.class;' statement? I do not want to write cfinvoke component=... ... all the time. -- Oleg Gunkin Email: [EMAIL PROTECTED] Phone: (604) 666-9392 Emerging Technologies / Pacific Web Services Information Technology Services Public Works and Government Services Canada (Pacific) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231324 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 network data source
A useful trick if you're having this types of issue is to firstly ping the machine and then try telneting to the port. telnet ip.add.ress.here 1433 The ping tells you the routing is fine, the telnet tells you whether it's a firewall issue. (Telnet also works with mail servers (port 110 pop, 143 imap, 25 smtp.) Glad you got it sorted, Jenny -Original Message- From: Paul [mailto:[EMAIL PROTECTED] Sent: 03 February 2006 23:26 To: CF-Talk Subject: RE: setting up network data source I fixed it... It was the security policy on the db server; I had enabled port 1433 but not the SQL Server listener... or something. I'm not very familiar with Win2k3's security config stuff just yet. Thanks again for your advice. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231325 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: Equivalent to Java 'import package.class;'?
Is there an equivalent to Java's 'import package.class;' statement? I do not want to write cfinvoke component=... ... all the time. Depends on what you are looking for. A lot of the time people will write createObject(component,myComponent) -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231326 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: MySQL 5 and CFMX7 (New Problem)
Yes, it is displayed under System Information in CF Admin -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:07 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class path? You have to restart CF after you add it so that the jdbc driver gets loaded in. Here is a link to how to install the postgress driver. The mysql setup should be similar. http://cfguru.daemon.com.au/archives/82.html Dave ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231327 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: evaluate hell Pt2
cfif IsDefined(GetInventory.#GetListingFields.DBColName#) AND GetInventory[GetListingFields.DBColName][GetInventory.currentrow] NEQ 0 AND Trim(GetInventory[GetListingFields.DBColName][GetInventory.currentrow]) NEQ -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: 03 February 2006 22:58 To: CF-Talk Subject: evaluate hell Pt2 Need serious help rewriting this statement without using evaluate: cfif isdefined(GetInventory.#GetListingFields.DBColName#) and evaluate(GetInventory.#GetListingFields.DBColName#[#GetInventory.currentrow #]) NEQ 0 AND Trim(evaluate(GetInventory.#GetListingFields.DBColName#[#GetInventory.curre ntrow#])) NEQ (I'm confused???) Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231318 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: Equivalent to Java 'import package.class;'?
I want to be able to call all the functions of this component without cfinvoke component=... -- Oleg Gunkin Email: [EMAIL PROTECTED] Phone: (604) 666-9392 Emerging Technologies / Pacific Web Services Information Technology Services Public Works and Government Services Canada (Pacific) -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 16:17 To: CF-Talk Subject: RE: Equivalent to Java 'import package.class;'? Is there an equivalent to Java's 'import package.class;' statement? I do not want to write cfinvoke component=... ... all the time. Depends on what you are looking for. A lot of the time people will write createObject(component,myComponent) -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231328 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: MySQL 5 and CFMX7 (New Problem)
In your users table do have your machine or sub-net entered to accept a connection from your machine/user that is having trouble connecting? Is MySQL installed on the same machine as CF? If not then jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to use the mysql boxes ip instead of local host. Sorry if I'm stating the obvious and not helping. The error basically says it cant connect to the port. Which doesn't sound like a CF issue but a network issue. Is the machine that you are using Navicat to connect with also the machine you have CF installed on? The only other thing I would suggest is check the cf and mysql logs to see if the provide any lower lever details/clues. Dave On Feb 3, 2006, at 6:26 PM, ColdFusion wrote: Yes, it is displayed under System Information in CF Admin -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:07 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class path? You have to restart CF after you add it so that the jdbc driver gets loaded in. Here is a link to how to install the postgress driver. The mysql setup should be similar. http://cfguru.daemon.com.au/archives/82.html Dave ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231329 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: Equivalent to Java 'import package.class;'?
Is there an equivalent to Java's 'import package.class;' statement? I do not want to write cfinvoke component=... ... all the time. No, there isn't. The CFIMPORT tag allows you to import JSP tag libraries and assign them prefixes, but that's not the same thing at all, really. 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! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231330 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: MySQL 5 and CFMX7
It works fine, it just shows all the datatypes as having a field length of 65535 in rds. The reason this is a problem is my HomeSite/CF Studio cfc wizard (http://www.aftershockweb.net/forums/messages.cfm/ThreadId/50) gets all the qForm cfc validation rules wrong because rds says all the field lengths are 65535. the appropriatel ocation, and then used the other datasource type instead of the mysql datasource type, and it still didn't work? Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231331 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: ImageCFC component Available
SWEET! Thanks dude! Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231332 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: Equivalent to Java 'import package.class;'?
cfset x = theJavaClassYouCreated.whicheverMethod(someArgument) will do it. You don't need cfinvoke. On 2/4/06, Oleg Gunkin [EMAIL PROTECTED] wrote: I want to be able to call all the functions of this component without cfinvoke component=... -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231333 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: MySQL 5 and CFMX7 (New Problem)
Localhost is where the MySQL Database is at. It is all one machine -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:49 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) In your users table do have your machine or sub-net entered to accept a connection from your machine/user that is having trouble connecting? Is MySQL installed on the same machine as CF? If not then jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to use the mysql boxes ip instead of local host. Sorry if I'm stating the obvious and not helping. The error basically says it cant connect to the port. Which doesn't sound like a CF issue but a network issue. Is the machine that you are using Navicat to connect with also the machine you have CF installed on? The only other thing I would suggest is check the cf and mysql logs to see if the provide any lower lever details/clues. Dave On Feb 3, 2006, at 6:26 PM, ColdFusion wrote: Yes, it is displayed under System Information in CF Admin -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:07 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class path? You have to restart CF after you add it so that the jdbc driver gets loaded in. Here is a link to how to install the postgress driver. The mysql setup should be similar. http://cfguru.daemon.com.au/archives/82.html Dave ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231334 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: MySQL 5 and CFMX7 (New Problem)
I have CFMX7, MySQL 5.0 and NaviCat all running locally -Original Message- From: ColdFusion [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 9:33 PM To: CF-Talk Subject: RE: MySQL 5 and CFMX7 (New Problem) Localhost is where the MySQL Database is at. It is all one machine -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:49 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) In your users table do have your machine or sub-net entered to accept a connection from your machine/user that is having trouble connecting? Is MySQL installed on the same machine as CF? If not then jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to use the mysql boxes ip instead of local host. Sorry if I'm stating the obvious and not helping. The error basically says it cant connect to the port. Which doesn't sound like a CF issue but a network issue. Is the machine that you are using Navicat to connect with also the machine you have CF installed on? The only other thing I would suggest is check the cf and mysql logs to see if the provide any lower lever details/clues. Dave On Feb 3, 2006, at 6:26 PM, ColdFusion wrote: Yes, it is displayed under System Information in CF Admin -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:07 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class path? You have to restart CF after you add it so that the jdbc driver gets loaded in. Here is a link to how to install the postgress driver. The mysql setup should be similar. http://cfguru.daemon.com.au/archives/82.html Dave ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231335 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