RE: Queries adding table Alias to column name
Select c.* from mytable C is aliasing 'mytable' as 'c' Yes, I know. That's not the problem. The problem is that the COLUMN is being returned as c.columnname. This should NOT happen. If you run your same query in the Access query analyzer you are going to get the exact same results. It is NOT a 'bug' in the Unicode driver. A bug would be returning results that it shouldnt. Since Access itself returns those EXACT same results... the driver does what it should. I don't care what happens in Query Analyzer. Microsoft is know to do things not quite by the book. Why do all other drivers return the actual column name? If it's NOT a bug, then is there is a bug in ALL the other drivers? Here are samples on SQL Server and MySQL. http://www.cf-ezcart.com/bud.cfm http://www.cf-ezcart.com/mysql/bud.cfm Can you show me an example of one (other than the buggy unicode driver) that returns the table name as part of the column name? This is the first time I've seen it since I started coding in 1997. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261986 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Queries adding table Alias to column name
I expected more from you Dave. :) It's an inner join that will always have the same value in both columns or nothing will be returned. * is a standard wildcard to call all columns in all tables. I see experts write sql that way all the time. If it were a left join with the possibility of different values, obviously I'd write my SQL different. That doesn't excuse whoever released this buggy driver making up the rules as they go. Anyway, as with all other bugs, I'll take it into account in the future. While the failure of the Unicode driver to conform to the behavior of other drivers you used previously may well be a bug, the ambiguity within your own code that brought this failure to your attention is also a bug. One of these two bugs can be fixed by you, the other can't. 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! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Queries adding table Alias to column name
Bobby Hartsfield wrote: In my case, using M.*,C.* should return the Main_Category_ID from the M. table since it's specified first. Why? You are asking for both and you are getting both the only way any database engine knows how to give them... with the alias you TOLD it to use for the table names. I didn't tell it to alias the Column. Select Column AS MyAlias is telling it to alias the COLUMN NAME. I DID NOT do that. Select T.Column FROM Table T is NOT telling it to use an alias. It's aliasing the TABLE NAME so I don't have to type Tables.Column. If your 1 and only question is STILL where is the bug then I'd say in your code. Not CF or a DB driver. You're 100% wrong Bobby. It's only the buggy unicode driver that returns these totally unexpected results. I'll certainly alter my code in the future to take this bug into account, but it's still a bug. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261836 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Queries adding table Alias to column name
I don't want to use it like that. That's not the name of the table and this is not the expected behavior. This is a bug in CF or in the driver. I'm trying to find out which. I meant to add try using it aliased like #m.main_category_id# Control + Enter is the worst shortcut ever. :-) ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Friday, November 17, 2006 8:13 AM To: CF-Talk Subject: Queries adding table Alias to column name ARRGGHH!! Is this a CF issue or an Access database driver issue? http://azarflooringgallery.com/bud.cfm This is a very simple, and quite standard query. SELECT M.*,C.* FROM Main_Categories M LEFT OUTER JOIN Categories C on M.Main_Category_ID = C.Main_Category_ID Note the Main_Category_ID is being returned with the alias in it's name. The field is actually named Main_Category_ID C.Main_Category_ID and M.Main_Category_ID I'm getting the error Variable MAIN_CATEGORY_ID is undefined. I can get it to go away, but only if I manually enter all field names and exclude Main_Category_ID from one of the tables. Why would someone change the behavior of something so drastically? This will be affecting code everywhere. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Queries adding table Alias to column name
When you need all of the columns I've found using a wildcard is a speed boost. The larger the table, the greater the boost. Does anyone know if this bug is with CF or the database driver? Bud, I am by no means trying to put salt on your wounds, but usage of wild cards is not really good practice. They is not really any marginal speed boost by not declaring the names of the column, but if you do not use all of the columns, then every column not added to your select clause will save time. Teddy On 11/17/06, Bud [EMAIL PROTECTED] wrote: ARRGGHH!! Is this a CF issue or an Access database driver issue? http://azarflooringgallery.com/bud.cfm This is a very simple, and quite standard query. SELECT M.*,C.* FROM Main_Categories M LEFT OUTER JOIN Categories C on M.Main_Category_ID = C.Main_Category_ID Note the Main_Category_ID is being returned with the alias in it's name. The field is actually named Main_Category_ID C.Main_Category_ID and M.Main_Category_ID I'm getting the error Variable MAIN_CATEGORY_ID is undefined. I can get it to go away, but only if I manually enter all field names and exclude Main_Category_ID from one of the tables. Why would someone change the behavior of something so drastically? This will be affecting code everywhere. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261009 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Queries adding table Alias to column name
Dave Watts wrote: Generally, in most database environments, you can't specify the same field twice unless you alias it at least once. If you could do this before, you shouldn't have been able to. I suspect that the database or driver is renaming both of the fields for you, to prevent an error from occurring - if you dump the query, you might be able to see this. I know you can't specify the same column name twice within the query, unless you specify which table it's from, such as C.Category_ID or Categories.Category_ID. But * is acceptable SQL to get all the columns from all the tables, and M.*,C.* is certainly standard SQL. I've seen it used for years in just about every application I've ever looked at. I've never seen the table name returned as part of the column name. In my case, using M.*,C.* should return the Main_Category_ID from the M. table since it's specified first. Since this is an inner join, they'll be identical anyway. My point is that #Main_Category_ID# should not return an error. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Queries adding table Alias to column name
I guess it's a CF issue, since you're going to see it no matter what database you use. You're selecting two columns called Main_Category_ID and CF doesn't know which one to use. So it uses both, prepending the alias. Why does everyone act like this is the norm? CF has never done this before. It just returns both fields in the order they're called. I've written thousands of queries like this. This is a brand new occurrence. You have three options: 1. Manually enter all the field names, as you described. 2. Change the column name in one of your tables. 3. Use the variables C.Main_Category_ID and M.Main_Category_ID (e.g. cfoutput#C.Main_Category_ID#/cfoutput) Go back through millions of lines of code and hundreds of applications because of a bug in CF or the driver? -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261011 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Queries adding table Alias to column name - update
OK. This is a driver issue. It appears to be a bug in the unicode access driver. Luckily I have few people using Access. We switched to the standard driver and now it's acting like it should and like it always has. http://azarflooringgallery.com/bud.cfm The column is being returned twice. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261012 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Queries adding table Alias to column name
ARRGGHH!! Is this a CF issue or an Access database driver issue? http://azarflooringgallery.com/bud.cfm This is a very simple, and quite standard query. SELECT M.*,C.* FROM Main_Categories M LEFT OUTER JOIN Categories C on M.Main_Category_ID = C.Main_Category_ID Note the Main_Category_ID is being returned with the alias in it's name. The field is actually named Main_Category_ID C.Main_Category_ID and M.Main_Category_ID I'm getting the error Variable MAIN_CATEGORY_ID is undefined. I can get it to go away, but only if I manually enter all field names and exclude Main_Category_ID from one of the tables. Why would someone change the behavior of something so drastically? This will be affecting code everywhere. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Queries adding table Alias to column name
ARRGGHH!! Is this a CF issue or an Access database driver issue? http://azarflooringgallery.com/bud.cfm This is a very simple, and quite standard query. SELECT M.*,C.* FROM Main_Categories M LEFT OUTER JOIN Categories C on M.Main_Category_ID = C.Main_Category_ID Note the Main_Category_ID is being returned with the alias in it's name. The field is actually named Main_Category_ID I could be wrong but I think this is happening because you are specifying all columns from M AND all collumns from C and the only way it can achieve this is to alias the duplicated name. Try SELECT * instead and see if that fixes it. This code is well over 8 years old. I've never seen this issue. Using * doesn't fix it. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260921 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Queries adding table Alias to column name
The point is. This isn't expected behavior. The driver isn't supposed to make up names. I'd alias the column myself if I wanted that. I've never ever seen this. I see many people using just * to grab all the fields in all the tables in a query. When you need all the fields, * is faster than specifying all the field names. Faster to type and the query runs faster. What's changed about it? Anyway, Why can't you just exclude it from one of the tables like you said. My guess is that they are identical values every time anyway. Why have it in there twice? ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Friday, November 17, 2006 8:13 AM To: CF-Talk Subject: Queries adding table Alias to column name ARRGGHH!! Is this a CF issue or an Access database driver issue? http://azarflooringgallery.com/bud.cfm This is a very simple, and quite standard query. SELECT M.*,C.* FROM Main_Categories M LEFT OUTER JOIN Categories C on M.Main_Category_ID = C.Main_Category_ID Note the Main_Category_ID is being returned with the alias in it's name. The field is actually named Main_Category_ID C.Main_Category_ID and M.Main_Category_ID I'm getting the error Variable MAIN_CATEGORY_ID is undefined. I can get it to go away, but only if I manually enter all field names and exclude Main_Category_ID from one of the tables. Why would someone change the behavior of something so drastically? This will be affecting code everywhere. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260923 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfhttp and UPS
Why is it that I STILL cannot use CFHTTP to get the UPS license text with MX 7? All special characters (eacute, etc.) are corrupt. I have to rely on MSXML and I'd rather just use CFHTTP. I've tried the charset attribute to no avail. Thanks. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246484 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
QuickBooks Web Connector Products
Hi everyone. I have 2 new programs to announce, 1 commercial, and another freebie for the CF community. I generally do not tout my wares here, but the freebie is hopefully going to be of great help to some of you. So I'm including my new commercial product also. So shoot me. :) Please ask any questions off list unless you think everyone should hear the answer. If I offend anyone with this post, please admonish me off list also. It's best to use the email address from the Contact page of my web site to contact me rather than this one, but I'll get either. I've been working with the QuickBooks Web Connector. We CF shopping cart developers, and anyone building CF apps for clients where the data eventually ends up in QuickBooks, are losing a lot of money to the QuickBooks Assistant programs. With the Web Connector, you can build your OWN assistants, such as the commercial one I'm about to show you. Then to get you started, I've included a little freebie. cf_ezcart Accounting Assistant - Makes cf_ezcart perhaps THE most QuickBooks compatible shopping cart in existence. If it isn't now, it soon will be. If there is one more so, I'd love to see it. This has been a 6 month long project to date that better fly, because it's just about bankrupted me. :) http://www.cf-ezcart.com/cf_ezcart-accounting-assistant.cfm QWC Starter Kit For ColdFusion - A FREE SOAP web service shell to get you up and running with the QuickBooks Web Connector in minutes. It will take all of the SOAP out of your hands and let you concentrate on coding. BOY OH BOY I could have used this in December when I started my project. I hope it helps someone. http://www.cf-ezcart.com/qwc-starter-kit.cfm As a side note. I've built a really neat support section for my Assistant. Allows for logging requests, viewing CF and QB errors, adding new services, etc. All stuff you will need to add to your program. I'm trying to build and document a version with a simple example service that I can release cheaply for the community which will include the database logging and preferences tables and the complete support section, minus your support content of course. Thanks for listening! -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241566 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
Locked out of administrator
Hi. I asked this and haven't gotten an answer, unless I missed it. I disabled cfcontent in CF Administrator, my dev copy, version 6.1. Now I can't get into the administrator. I assume like 5.0 there is somewhere to enter the unsecuredtags directory, which should be pointing to ...\CFIDE\administrator. Where do I set this manually? I searched through all the XML config files and can't find anything referencing cfcontent or unsecured[tags], etc. What line do I add or change in which config file to set/reset the unsecured tags directory? Thanks. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237892 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: Locked out of admin
No, sorry. It has nothing to do with the password. I disabled cfcontent and the unsecuredtags directory must be pointing somewhere other than the installation. I'm looking for where I would change this or add it back into an XML file. See if this helps: http://www.coldfusioncookbook.com/entry/68/How-do-I-reset-the-ColdFusion-Administrator-password? On 4/4/06, Bud [EMAIL PROTECTED] wrote: Hi. I disabled cfcontent on my developer copy of MX 6.1. Now I'm locked out of admin. Is there an unsecuredtags directory setting? I've searched though all the xml config files but can't find it. Do I need to add it? And if so, where? Thanks. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237195 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
Locked out of admin
Hi. I disabled cfcontent on my developer copy of MX 6.1. Now I'm locked out of admin. Is there an unsecuredtags directory setting? I've searched though all the xml config files but can't find it. Do I need to add it? And if so, where? Thanks. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236888 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
asynchronous messages
Hi. I have a need to do an asynchronous session, which I'm not familiar with. It looks like I have to post raw messages, but it's not a form post and in fact, uses no protocol I guess. Just a raw socket connection. I've attempted to use cfx_rawsocket but that apparently places header information in the post depending on the protocol entered. I need to pass the data I supply, period. There IS a Component DLL, AspSock, which I'd like to try, but they are apparently not supported.The demo is expired when you download it and the company doesn't answer email. http://www.serverobjects.com/comp/aspsock.htm Is there an equivalent of this application somewhere else, or something CF that I'm not aware of? Thanks in advance. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236785 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: Copyright Attorney
Neil Robertson-Ravo wrote: Which site/product? http://www.cf-ezcart.com My guess: http://www.itsgroup.org/ecommerce_main.htm Do me a favor and be careful who you list. I actually do have people selling ecommerce hosting using my cart so I don't want to ruffle any feathers needlessly. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235302 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: Copyright Attorney
This is a plug, but mostly I want to try to help a fellow CF'er The firm I work for is in intellectual property we have several attorneys who specialize in copyright and trademark (as well as many more in patents). At any rate, we have a free 30 minute consult to see what is possible. Give us a call: 515-288-3667 www.ipmvs.com Nate, thanks, I will if the guy I've been talking to doesn't pan out. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235303 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: Copyright Attorney
Did you sell the source as is? If so and if they've altered the program enough, it's not illegal to resell it. My license states that no source code can be used to create a competing application. Don't get me wrong, I think you should definitely pursue this, but after a certain percentage of changes have been made, it's not considered the same source anymore. If it's been altered, I'm sure it's only so it's not recognizable on the surface. Considering the feature set, and considering these companies are advertising that feature set, it can't be altered much. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235176 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: Copyright Attorney
Thanks Mary Jo. :) Did you sell the source as is? If so and if they've altered the program enough, it's not illegal to resell it. Don't get me wrong, I think you should definitely pursue this, but after a certain percentage of changes have been made, it's not considered the same source anymore. This is absolutely incorrect. Copyright law protects derivative use of material as well. The only legal use of copyright material is fair use which has specific guidelines that would need to be met. Of course, if the changes were so significant that the source code was totally unrecognizable, it might be hard to make a case that it was derivative. But it definitely is not legal to do it. The main issue in cases like this is whether the source code is registered or not. While registration is not required by law, your legal recourse is much more limited if you did not register the copyright. It's fairly cheap so I always make sure to register each major release of my software. It's also best to set up your purchasing area so customers must agree to your licensing before purchase so there can be no argument that they know the terms and understood the code was copyrighted. It always amazes me the dishonesty of some people out there. I have dealt with this issue a number of times unfortunately. In the worst case, I actually had someone email me anonymously to blow the whistle on their employer...they were selling copies of my software to their customers without paying for the licenses. These types of people always think they will get away with it, but invariably, someone realizes what's going on and reports them. Good luck. Hopefully this is all a misunderstanding but if not, find a good intellectual property lawyer in your area. Usually a threatening letter from a lawyer is enough for most people to do the right thing. - Mary Jo Sminkey http://www.cfwebstore.com CFWebstore E-Commerce ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235177 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: Copyright Attorney
I don't want to jump the gun. I'm hoping they've simply lifted my source code from my features page. But one of them purchased my cart in '04. That doesn't give me confidence. Can anyone point me to a reasonably priced attorney that will deal with people buying my cf_ezcart, then selling it as their own, even using going so far as using my html source for the features page. I wouldn't doubt it if Ray Horn was the ringleader on this! It's actually kinda sick. I'd liketa see a list of perpetrators, but I guess it'd be a bit tacky to post somethin'like that eh? Heck, whoever did this deserves to be Ray Horn'd though! Would you let me know offlist who it was? Thanks and Good luck Bud! Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235134 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: Copyright Attorney
cf_ezcart is trademarked. But they're not using the name. There is a license with it that says you can't use the code to build a competing application and that you have to pay for each copy you use. Not sure what else you can do. Copying the features page is annoying at the worst. Actually reselling the software as your own seems criminal to me. Bud, If you havent gotten any references yet, consider this: A) Lawyer specialty = intellectual property combined with commercial contract negotiations. B) Lawyers have to pass a Bar exam administered by the state they practice in. Therefore, contacting your state bar association will usually lead you to a 800 number directory with qualifications. Here in NY, when you use the state system they provide you with a first time referral fee of $25 for speaking with the attorney you chose. Not bad huh. Though it can take up to 3 tries to get a good match. C) The best way to protect intellectual property is thru filing for a patient, and/or trademarks etc, as plagiarism / copyright cases are expensive and timely to pursue. Hope that helps. Steve -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Saturday, March 11, 2006 8:59 AM To: CF-Talk Subject: OT: Copyright Attorney Can anyone point me to a reasonably priced attorney that will deal with people buying my cf_ezcart, then selling it as their own, even using going so far as using my html source for the features page. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235135 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: Copyright Attorney
Can anyone point me to a reasonably priced attorney that will deal with people buying my cf_ezcart, then selling it as their own, even using going so far as using my html source for the features page. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235112 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
fusionkart??
Anyone out there using FusionKart? If so can you contact me off list? Thanks a million. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234811 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: Digital Signing a SOAP Request
I searched their documentation for 48 hours to find the URL to post the XML to use their web services. I finally had to find it from google. Ridiculous. All I get back from that is connection failure. When I go to the URL directly, I get a browser alert error. A search for part of that... incorrect or unexpected message reveals that the error is generally related to not having a proper client-side certificate. The SOAP/XML part shouldn't be too hard. I just don't even know where to begin to digitally sign the soap request. Any clues would be very welcome. Hmmm, it could be coincidence that Ben was just blogging this; http://www.forta.com/blog/index.cfm/2006/2/23/Using-PayPal-In-ColdFusion-Applications -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Sunday, 26 February 2006 2:31 AM To: CF-Talk Subject: RE: Digital Signing a SOAP Request https://www.paypal.com/us/cgi-bin/webscr?cmd=_wp-pro-overview-outside This is from their web services documentation. Your security with the PayPal Web Services API relies on a set of public/private security keys issued in the form of digital certificates by PayPal. These keys uniquely identify an API user to prove his authorization to access PayPal Web Services. Each SOAP request is signed by your private key, and PayPal Web Services processes a request only after authentication succeeds. Can you send a link for more info on PayPal Pro? A quick google didn't yield much. This link suggests you don't need digital signing; http://www.paypaldev.org/topic.asp?TOPIC_ID=11264 but it doesn't mention pro specifically. Cheers. -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Saturday, 25 February 2006 3:27 AM To: CF-Talk Subject: Digital Signing a SOAP Request Anyone have any code lying around that will digitally sign a soap request using CF's built-in functions or java classes? Pointers on where to start? I'm wanting to implement PayPal Pro with cf_ezcart. They have an API for MX 7, but it requires jar files be installed and it looks like this may be a problem on shared servers. Their SOAP requests look pretty straight forward, but I have NO idea how to digitally sign a SOAP request. :) Clues? Tips? Pointers? Thanks! :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233499 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: Digital Signing a SOAP Request
https://www.paypal.com/us/cgi-bin/webscr?cmd=_wp-pro-overview-outside This is from their web services documentation. Your security with the PayPal Web Services API relies on a set of public/private security keys issued in the form of digital certificates by PayPal. These keys uniquely identify an API user to prove his authorization to access PayPal Web Services. Each SOAP request is signed by your private key, and PayPal Web Services processes a request only after authentication succeeds. Can you send a link for more info on PayPal Pro? A quick google didn't yield much. This link suggests you don't need digital signing; http://www.paypaldev.org/topic.asp?TOPIC_ID=11264 but it doesn't mention pro specifically. Cheers. -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Saturday, 25 February 2006 3:27 AM To: CF-Talk Subject: Digital Signing a SOAP Request Anyone have any code lying around that will digitally sign a soap request using CF's built-in functions or java classes? Pointers on where to start? I'm wanting to implement PayPal Pro with cf_ezcart. They have an API for MX 7, but it requires jar files be installed and it looks like this may be a problem on shared servers. Their SOAP requests look pretty straight forward, but I have NO idea how to digitally sign a SOAP request. :) Clues? Tips? Pointers? Thanks! :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233462 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
Digital Signing a SOAP Request
Anyone have any code lying around that will digitally sign a soap request using CF's built-in functions or java classes? Pointers on where to start? I'm wanting to implement PayPal Pro with cf_ezcart. They have an API for MX 7, but it requires jar files be installed and it looks like this may be a problem on shared servers. Their SOAP requests look pretty straight forward, but I have NO idea how to digitally sign a SOAP request. :) Clues? Tips? Pointers? Thanks! :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233377 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: Encrypt CC number and store in DB
Hmm... I'm going to look into that Bryan. I didn't know processors generally gave functionality to store and query CC nums by customer - I'll see if mine does it. You can do an AUTH, then a CAPTURE. The main drawbacks are, 1) as one person said, the time frame. You get about a week or 2, depending on the gateway. And 2) if you don't know the amount. Most gateways, I don't believe you can alter the amount before you do the CAPTURE. You definitely can't raise it. The way I handle it in cf_ezcart is with deferred payments. If we can't calculate shipping for whatever reason, or you have custom items that can't be priced, we write the order with an estimated amount, then notify the customer when the total is final and they then go pay with their credit card. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229466 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: AuthorizeNet Recurring Payments?
We have some instances where we have a need for 'subscription' type payments - mostly monthly charges for web hosting for clients. Our main need, however, is for periodic payments for services. For example, someone purchases one year of advertising and the salesperson agrees to allow them to pay quarterly. The only way this is convenient for either us or the customer is to take a CC number. So then we're tasked with how/where this CC number is stored. I've instructed sales to keep CC numbers out of all computer records, as our sales applications reside on systems reachable from the net for telecommuting purposes. But I've found CC numbers in _plain_text_ within notes fields of our contact management application. I use net1 when I need recurring services for my clients, and I use them for my own gateway and for billing my hosting customers. http://www.eftsecure.com/ They have some pretty much unadvertised web services. https://va.eftsecure.net/web_services/vterm_extensions/recurring.asmx You can add, update, delete recurring transactions and schedules. Activate/deactivate transactions. Set how many payments, or indefinite. Run SALE transactions against a customer's card, etc. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229470 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
Building XML
Hi everyone. Happy new (almost) year. I'm curious what you experts think is the best way to create XML. Just taking dummy XML and populating it? cfset myxml ='CustomerRequest BillAddress Addr1#Address1#/Addr1 City#City#/City State#State#/State PostalCode#Zip#/PostalCode /BillAddress /CustomerRequest' cfset myxml = xmlParse(myxml) Or using CF functions? cfset myxml = xmlNew() cfset myxml.xmlRoot = xmlElemNew(myxml, 'CustomerRequest') cfset myxml.CustomerRequest.xmlChidren[1] = xmlElemNew(myxml, 'BillAddress') cfset myxml.CustomerRequest.BillAddress.xmlChidren[1] = xmlElemNew(myxml, 'Addr1') cfset myxml.CustomerRequest.BillAddress.xmlChidren[2] = xmlElemNew(myxml, 'City') cfset myxml.CustomerRequest.BillAddress.xmlChidren[3] = xmlElemNew(myxml, 'State') cfset myxml.CustomerRequest.BillAddress.xmlChidren[4] = xmlElemNew(myxml, 'PostalCode') cfset myxml.CustomerRequest.BillAddress.Addr1.xmlText = Address1 cfset myxml.CustomerRequest.BillAddress.City.xmlText = City cfset myxml.CustomerRequest.BillAddress.State.xmlText = State cfset myxml.CustomerRequest.BillAddress.PostalCode.xmlText = Zip It seems like the first way would take less time, less overhead and be less confusing. But somehow it seems like the second way is the right way. Opinions? -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229536 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: Building XML
I'm curious what you think is the best way to create XML. The easiest way, I think, is usually to use the CFXML tag. A, cool. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229547 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
CFFILE Upload weirdness
Hi. One of the strangest things I've seen yet. This happens on one CF server running 7,0,1,116466 (a client's) but not mine, running the same code and the same version. Simple custom tag. Here is the cffile. cffile action=upload filefield=#filefield# destination=#Attributes.directory##attributes.id# nameconflict=overwrite accept=#accept# When uploading a jpg, named test1.jpg (the name on my computer) to a file named test2.jpg, CF creates a directory named test2.jpg and uploads. If I place the following code right after the cffile. CFOUTPUT#Attributes.directory##attributes.id#/CFOUTPUTcfexit It correctly shows this: C:websites\atip\ezcart\products_tn\test2.jpg Yet the file it places on the server is this: C:websites\atip\ezcart\products_tn\test2.jpg\test1.jpg test2.jpg being a directory created during the process. #file.serverfile# also shows the name as test1.jpg so it's not happening sometime after the initial upload. I've also tried upload a file named as it will be on the server, but then I just get test2.jpg/test2.jpg. I don't get it. Anyone seen this? -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229020 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
If you REALLY want an open-source shopping cart in CF, someone, one person, will just need buckle down and write a feature set, decide on a framework, and CODE MOST OF IT OUT. Hasn't Ben Forta done that? Mine was based on the one out of WACK 4, a lng time ago. :) I've been working on cf_ezcart for 6 years. I've sold well over 500 licenses and I think I've added a new feature for 3 out of 4 of those sales. Every freaking body that buys a shopping carts wants something different. Crazy pricing schemes. And shipping? Unbelievable some of the weird stuff people come up with. Anyway, as a fellow cf developer, I wish everyone luck. As a competitor, I hope your project falls on it's butt. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229033 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: CFFILE Upload weirdness
dave wrote: While it looks like you're experiencing the issue in this TechNote, http://www.macromedia.com/go/f97044e, you should make sure that you have the cumulative updater to Merrimack installed, found here: http://www.macromedia.com/go/aae43964. I think that should resolve things. One thing that has changed in MX 7 is that you can't just use the serial number to determine what patch level you're at. You need to check the Update Level line as well on the System Information page. Yes, I found that after i emailed the list. Thanks. I wish MM would quit changing perfectly logical behaviors for stuff that just doesn't make sense. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229097 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: lets give these ppl hell!
http://myfriendadder.com/faq.html Q: It keeps going back to the login page. What is wrong? A: MySpace.com sometimes has problems loging people in. This is due to their horrible architecture called ColdFusion. You read the FAQ? Whoever wrote it spells like a 2nd grader. And that may be an insult to 2nd graders. Doubt anyone would take it serious. ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228674 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: Web services and cfinvoke
I was assuming you could build the service around the existing
wsdl. In the babelfish examples in the documentation cfinvoke calls a
wsdl file.
cfinvoke
webservice='http://www.xmethods.net/sd/2001/BabelFishService.wsdl'
method='BabelFish'
translationmode=en_es
sourcedata=Hello world, friend
returnVariable='foo'
cfoutput#foo#/cfoutput
Now, I only assume that on the altavista side, the wsdl file itself
does not do the translation, but is passed to a cgi. And I assumed
the cgi would be the one specified in soap:address location.
And on a somewhat related note. I'm still don't understand how I
place the XML that is sent to the service into a variable for
reading. The service is requested initially from the end user's
computer and sends text/xml, not form variables, so I can't grab the
xml with form.xml or whatnot.
soap:address location=http://services.xmethods.net:80/perl/soaplite.cgi/
What I'm asking is, in my CF scenario, would this value be to my cfc
file, or to a cfm that included the cfc, or what?
:)
None of the above, the beauty of a CF web service is that you don't
need to work this hard. You create a CFC that is going to be a web
service. You do this by taking the incredible hard task of putting
access=remote as a parameter into one or more of the functions
{aka methods} of the CFC. Then the ever so nice CF engine creates
the WSDL of this newly minted web service for you.
You could consume this web service with some other piece of
ColdFusion with a cfinvoke tag something like this.
cfinvoke webservice=http://my.webservice.com/doThisStuff.cfc?wsdl ...
But from what I understand, is that you would not be writing this
part, since the QuickBooks application is going to consume the web
service. I would presume somewhere in the configuration that allows
QuickBooks to consume a web service, you would provide an URI to
your CFC web service to be consumed.
What you showed as an example wsdl file is what I presume the
QuickBooks application is expecting to see from a web service. So
you just need to write your web service CFC to provide a wsdl that
meets these expectations.
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
C code. C code run. Run code run. Please!
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228336
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: Web services and cfinvoke
This is kind of backwards. Typically, you write a web service, which generates its own WSDL, and that WSDL is the interface that's used by other programs. I've never heard of anybody giving you a WSDL file and saying, write a program that's compatible with this WSDL - it's kind of a cart-before-the-horse approach. See my babelfish example in the last email. It's called the WSDL First approach from all my reading. http://webservices.xml.com/lpt/a/ws/2003/07/22/wsdlfirst.html Well, SOAP web services send and retrieve XML documents (specifically, SOAP envelopes), but as a SOAP developer you don't typically touch that stuff directly at all. The whole point is to provide a toolset so you don't have to deal with it. Yeah, but how do I get the soap document into an XML document so that I can get the username with say myxml.Envelope.Body.authenticate.strUserName? Everyone keeps telling me I don't have to do anything. But obviously I do because I've been staring at this desktop for a week and the application is still barely started. LOL This is all i want to do, and will probably get me on my way. 1) Place the initial XML post that's sent to my web service into an XML doc. 2) Parse the xml for the username and password. 3) Return XML based on whether the login is successful. Yes, the ASMX file is essentially the equivalent of a CFC web service. I'm not sure what you mean by switch to your WSDL - do you mean the Quickbooks WSDL file or the one auto-generated by your CFC? You might want to compare the two, as well. You'll be able to see how to fill in the different values in the Quickbooks file, or change your CFC to be closer to that WSDL file. I just saved the QB supplied copy and entered the address to my cfc in soap:address location. By switching to my wsdl I just mean switching back and forth for testing between my wsdl and the one at developer.intuit.com. OK then. I'm going to attempt the cfc method. What the heck. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228338 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: Web services and cfinvoke
OK. Initial testing using the cfc as the cfinvoke target is making more sense. Now I need to learn how to read the XML that is being sent. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228340 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: Web services and cfinvoke
OK. Initial testing using the cfc as the cfinvoke target is making more sense. Now I need to learn how to read the XML that is being sent. Sorry to answer my own question, but GetHttpRequestData() is what I was looking for. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228363 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
Web services and cfinvoke
Hi all. Long time no post. Been very busy, but as usual, making no money. :) I'm beginning thusly. cfinvoke webservice =http://192.168.0.50:8500/ezcart_mx/webservice/QBWebConnectorSvc.wsdl; method =authenticate returnVariable=mydoc cfinvokeargument name=strUserName value=cfezcart cfinvokeargument name=strPassword value=test /cfinvoke Inside the wsdl file is the soap:address location element. Am I supposed to point that to my cfc with my methods or should I point that to a cfm file which in turns invokes those methods? My main point of confusion is, I'm specifying the wsdl file with the web service definitions, but how and where do I access the CFC to return my returnVariable? TIA for any help I can get here. If someone can just show me a sample of a web service that specifies a wsdl file and returns output based on the user input, I think I can figure this out. All of the example I've seen point to a cfc with the wsdl being generated dynamically. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228171 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: Web services and cfinvoke
You just use the returned variable mydoc in your code after the cfinvoke tag. But the returned variable mydoc has to be created. I need to parse the XML (username and password) and return a result. That's where I'm stuck. I am building the service from an existing WSDL file provided by Intuit. Inside the file is the element soap:address location. Should I point that directly to my CFC or to a CFM files which then invokes the CFC? And one other question if anyone is listening. :) I've submitted plenty of forms and xml documents using cfhttp, then use xmlparse() on the filecontent to create a XML document. But the service is initiated remotely and I am being passed an XML document. What scope/variable would that document be in so I can access it? It doesn't seem to be in the form scope. Thanks. On 1/3/06, Bud [EMAIL PROTECTED] wrote: Hi all. Long time no post. Been very busy, but as usual, making no money. :) I'm beginning thusly. cfinvoke webservice =http://192.168.0.50:8500/ezcart_mx/webservice/QBWebConnectorSvc.wsdl; method =authenticate returnVariable=mydoc cfinvokeargument name=strUserName value=cfezcart cfinvokeargument name=strPassword value=test /cfinvoke Inside the wsdl file is the soap:address location element. Am I supposed to point that to my cfc with my methods or should I point that to a cfm file which in turns invokes those methods? My main point of confusion is, I'm specifying the wsdl file with the web service definitions, but how and where do I access the CFC to return my returnVariable? TIA for any help I can get here. If someone can just show me a sample of a web service that specifies a wsdl file and returns output based on the user input, I think I can figure this out. All of the example I've seen point to a cfc with the wsdl being generated dynamically. CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228205 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: Web services and cfinvoke
I'm confused as well. Are you writing the web service yourself, or using a CFC web service written by someone else? If so, you don\'t have to create the WSDL file - just let CFMX generate it for you. Assuming you're using a CFC web service, the URL would look something like this: Hi Dave and thanks. And Ian replied also so thanks Ian also. I'll try and make this clear. I'm pretty green still when it comes to XML, SOAP, etc. :) This is the Quickbooks QBWebConnector. It allows Quickbooks to connect to a web service using SOAP. I need to build the web service as defined by the wsdl file. Basically the requests are generated by Quickbooks and I have to respond. http://developer.intuit.com/uploadedFiles/Support/QBWebConnectorSvc.wsdl I have a copy saved locally. I'm under the assumption that the only element I have to change is soap:address location=https://idn.vogelfam.net/QBMSDonorSample/QBWebConnectorSvc.asmx;, which I have pointing to my cfc file in my setup.. If I run my cfinvoke tag using the wsdl above, on the first method of the service authenticate, I am returned a java array (I believe). CFDUMP shows an object with a name of com.intuit.developer.ArrayOfString. I can access the 2 string variables I am expecting like so. mydoc.getString(0) mydoc.getString(1) That's confusing enough to me as I was expecting to see XML. My assumption is that the actual processing of the authentication method's arguments get's done within the asmx file in the soap:address. Is the asmx the equivalent to a cfc in CF? When I switch to my wsdl, which calls my cfc, all I get are apache.axis errors. My head hurts. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228259 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: Web services and cfinvoke
So to double check, you are building a web service that will be contacted by the QuickBooks application using the WSDL like the example from you link? Exactly. If this is so, then you are expected to create a CFC running as remote that will return a wsdl matching the specification. In other words have functions matching the expected functions in the wsdl accepting the parameters defined in the wsdl and returning the data expected in the wsdl. Then you would provide the URI to this cfc?wsdl file in QuickBooks that defines the web service it is looking for. The thing is, it seems as though all the examples I find assume the web service being built first, then cfinvoked using xxx.cfc?wsdl. But the cfinvoke documentation, and the example wsdl I'm using point directly to the wsdl. There are dynamically generated wsdl files, and there are services built around static wsdl files. At least that's the way I understand it. I'm just confused. :) I can't help you much beyond this basic understanding on my part. Unless my basic assumption of you building this web service for the QuickBooks to connect to is wrong. If you are consuming a web service with ColdFusion then that is completely different. HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228303 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: Web services and cfinvoke
Huh? The cfinvoke call creates the variable. You just use it. But the variable has to be populated with a value. The value is based upon whether the authentication was successful and whether their is any data to be passed to quickbooks. I need to run cf code to return the value. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/webser16.htm Yes, you'll see that cfinvoke is calling http://www.xmethods.net/sd/2001/BabelFishService.wsdl. If you go look at that file, you'll see this line. soap:address location=http://services.xmethods.net:80/perl/soaplite.cgi/ What I'm asking is, in my CF scenario, would this value be to my cfc file, or to a cfm that included the cfc, or what? :) On 1/3/06, Bud [EMAIL PROTECTED] wrote: You just use the returned variable mydoc in your code after the cfinvoke tag. But the returned variable mydoc has to be created. I need to parse the XML (username and password) and return a result. That's where I'm stuck. I am building the service from an existing WSDL file provided by Intuit. Inside the file is the element soap:address location. Should I point that directly to my CFC or to a CFM files which then invokes the CFC? CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228304 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
Announcement: cf_ezcart Price Drop
Hi all. I make it a point NOT to use this mailing list to promote my shopping cart (I've mentioned it maybe twice in 5 years), so this will be brief. The price of cf_ezcart has been dropped to $200 and there is still a promo code that can be found in MM's ColdFusion Exchange for an additional $25 off. Of course, my customers will still receive unparalleled support. :) http://www.cf-ezcart.com/ Thanks. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221113 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: Amazon AWS
Hi Brian. I saw this post in CF Talk. Cutter, just FYI I am pretty sure that when Amazon changed over to the new web service API it broke the old web service request I was using in the bookstore. I haven't had a chance to fiddle with the new API or update the example yet. But if someone has a working example using the new API it would definitely speed up my ability to add it in! :-) Have you had a chance to fiddle yet? :) Thanks -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220235 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: Credit card storage
And now they've redone it to Cybersource... I looked over the docs not so long ago and I don't think I have ever seen a more complex payment gateway interface, ever. I just got done integrating my cf_ezcart with Cybersource. This was the worst interface I've worked with out of any so far. UGH -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219057 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: Character encoding
Thanks Paul. And thanks Dave for responding also. The fix was on Roger's Travails page. cfhttp.filecontent.toString(iso-8859-1) They sure make this stuff hard to keep up with. Bud wrote: I'm at wits end. I am trying to get some special characters, é (eacute), etc. to display. This is what exactly is happening? are the chars corrupted (?) or not rendered correctly ([])? or mojibake? cfprocessingdirective pageencoding=iso-8859-1 that box defaulting to utf-8 (which is the default for cf)? what are the other server's that work using? At what point between the UPS server and the page output on the Linux CF server could I be losing the encoded characters? not enough details to really tell. maybe roger's travails might help: http://mxblogspace.journurl.com/users/admin/index.cfm?mode=articleentry=7288 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212689 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
Character encoding
I'm at wits end. I am trying to get some special characters, é (eacute), etc. to display. This is a call to the UPS Online Tools License using cfhttp with a single cfhttpparam of type XML. I've got this working except on the following system: Web Server: Apache/2.0.40 (Red Hat Linux) CF Version: 6,1,0,63958 This server appears to have some different defaults set up or whatnot as if I load a .cfm file, in order for the characters to display properly I have to place the following on the page: cfprocessingdirective pageencoding=iso-8859-1 cfcontent, meta tags, etc. have no effect. Only cfprocessingdirective. Here is the plight. I can manually type those special characters on the same page as where I'm outputting cfhttp.filecontent (containing the License text returned from UPS). They look fine, yet the special characters returned from the UPS server are not displaying properly. I've tried adding charset=iso-8859-1 to the cfhttp tag and have used all the possible combinations of cfprocessingdirective, cfcontent and meta content tags. The characters that are hard coded into the file display properly only with the cfprocessingdirective tag. At what point between the UPS server and the page output on the Linux CF server could I be losing the encoded characters? Thanks many many times in advance. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212546 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: Number formatting issue
Thanks Matthew. I actually didn't want it to round at all. Rey... It has to round either up or down, or it's going to remain 22.995. :) There are 2 functions, INT which rounds DOWN to the nearest integer and CEILING which rounds UP. Neither works on decimals. What Rey is saying is to first multiply by 100 to get rid of the excess decimals. num*100 This will give you 2299.5. Putting that within INT knocks off the .5. int(num * 100) = 2299 Now, divide that by 100 to get back where you started. int(num*100) / 100 = 22.99 Matthew Walker wrote: If you use numberFormat() without a mask, it rounds to the nearest integer (which I think is silly). If you use decimalFormat() or dollarFormat(), it rounds to two decimal places. The standard way of rounding a 5 is to round it up. If you want it to round down, you could do this: int(num*100)/100 -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED] Sent: Monday, 18 July 2005 9:17 a.m. To: CF-Talk Subject: Number formatting issue Guys, I have a number that looks like this. 22.995 But everytime I use DollarFormat() or NumberFormat, it rounds it up to 23.00. I need the value to display as 22.99 not 23.00. How do I get around this? I could just treat the value as a string and cut off the trailing 5 but why are the number formatting functions rounding my value up? This is on CF 5. Rey... -- http://www.ReyBango.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212111 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: This is crazy this is crazy this is crazy!
Hell, I just submitted the customer info and it crapped out! Element SHOPPERINFO is undefined in SESSION. Why is it undefined in session? It's there! Well it WAS there. The damn thing was created when they added somethin to the cart. I'm not doing anything to DELETE it! This is really pissin' me off now. Are you manually setting/deleting CFID and CFTOKEN? Here is the scenario for me to reproduce it on both Mac (NN 7) and PC (IE6). Put an item in the cart and click checkout. Choose payment method, enter billing info and continue. At this point click View Bag or whatnot to get out of checkout. When I click checkout again, it looks like everything is good at this point, but when I look, my CFID cookie is gone, although CFTOKEN is still there at the correct value. Predictably though, on the next click I get the shopperinfo undefined because you've lost your identity without the CFTOKEN. I've got dozens of copies of my cart running over on Crystal Tech so I've had a little experience with their servers. If you can't get this figured out, I'll be happy to take a peek if you want to create a temporary FTP login for me and point me to where your logic is to set/delete cookies. Fell free to email me privately. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210558 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
CFHTTP and character encoding
Hi all. I've built my shopping cart with UPS Online Tools included. I have to use a registration wizard' per their licensing. This has been working fine, except I now have a customer running Apache and MX 6.1 and the special characters French text is not being encoded properly. I found the following release note at MM's site, but using charset=iso-8859-1 on the cfhttp tag apparently has no effect on the text that is returned. Anyone have any tips on this? The cfhttp tag was not properly internationalized. The tag used ISO-8859-1 (Latin-1) as the default character encoding and ignored the charset attribute. The cfhttp tag now supports the charset attribute and uses UTF-8 as the default character encoding. Because the default character encoding has changed, you might encounter errors if you use the cfhttp tag without a charset attribute to retrieve a page or file that uses Latin-1 encoding for a language other than English, such as French, German, or Spanish. If you use these languages, specify the ISO-8859-1 character set in your cfhttp tag, as follows: cfhttp charset=ISO-8859-1 -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209977 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: Help with COM
Dan, where did you get the software? The software and documentation I got from their developer site shows 3 objects being created. I'm trying to convert from ASP examples. There is nothing in the documentation showing class Cybersource.ICS.3. Thanks for your help on this. I'm waiting on a response from their support to see if they have some CF stuff that's not documented. I've found a cfx_cybersource tag but it doesn't look like it's even been tested with CFMX. 1) Create the merchant configuration cfobject type=com action=create class=CyberSourceWS.MerchantConfig name=oMerchantConfig 2) Create the hashtable with the transaction variables. cfobject type=com action=create class=CyberSourceWS.Hashtable name=oRequest 3) Create the client and send the request cfobject type=com action=create class=CyberSourceWS.Client name=oClient I'm dead in the water on number 2. Don't think so - I have coded a cybersource interface before and that is from my code. Are you setting properties in the COM object to submit for CC verification? Is this your object call? cfobject action=create type=com class=Cybersource.ICS.3 name=oRequest Dan On 6/11/05, Bud [EMAIL PROTECTED] wrote: Thanks Dan. I think you may have another tag in mind. Error: Failed attempting to find SETVALUE property/method on the object Bud, I think you have to use their SetValue method: cfset oRequest.SetValue(billTo_firstName, Jane) Dan On 6/11/05, Bud [EMAIL PROTECTED] wrote: Hi all. I'm trying to use a COM object to connect to CyberSource payment gateway. I'm converting their ASP script sample. Here is my problem. I'm trying to set a value within the object (oRequest). The ASP command for this is as follows. oRequest.Value(billTo_firstName) = Jane If I try to use this within cfscript or if I use cfset as follows: cfset oRequest.Value(billTo_firstName) = Jane I get the following error: Illegal left hand side of assignment near line 50, column 7. Left hand side cannot be a function call. I've tried everything in my power to get the property set. Nothing works. Any clues? -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209269 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: Shopping Cart
I have been messing around with Ben Fortaâ*s shopping cart in the WAC book and was wondering what other options are available. Does anyone have recommendations on a Cold Fusion based shopping cart that you can customize. I know Able Commerce is a player in this market but Iâ*m skeptical about them. Any suggestions would be great. Hi Mike. Check out cf_ezcart. http://www.cf-ezcart.com/ The price drops quickly for developers if you start using multiple copies. It's not the most refined cart out there as far as look goes, but it's extremely functional, open source and you'll find it will fit the needs of 95% of your clients. We'll always be right there to get you up and running and provide any help you need. I can pretty much drop the cart into any web site within 30 minutes. I was reading Ben's book in 1999 and asked the same question. I also started messing around with the cart in his book. I'm still messing with it. So be careful. LOL -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209270 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: Help with COM
From Cybersource when I worked on the interface, a little over a year ago. I am not familiar with CyberSourceWS. I think I still have the developer guide I used and I will email to you directly. Thanks Dan. Dan On 6/13/05, Bud [EMAIL PROTECTED] wrote: Dan, where did you get the software? The software and documentation I got from their developer site shows 3 objects being created. I'm trying to convert from ASP examples. There is nothing in the documentation showing class Cybersource.ICS.3. Thanks for your help on this. I'm waiting on a response from their support to see if they have some CF stuff that's not documented. I've found a cfx_cybersource tag but it doesn't look like it's even been tested with CFMX. 1) Create the merchant configuration cfobject type=com action=create class=CyberSourceWS.MerchantConfig name=oMerchantConfig 2) Create the hashtable with the transaction variables. cfobject type=com action=create class=CyberSourceWS.Hashtable name=oRequest 3) Create the client and send the request cfobject type=com action=create class=CyberSourceWS.Client name=oClient I'm dead in the water on number 2. Don't think so - I have coded a cybersource interface before and that is from my code. Are you setting properties in the COM object to submit for CC verification? Is this your object call? cfobject action=create type=com class=Cybersource.ICS.3 name=oRequest Dan On 6/11/05, Bud [EMAIL PROTECTED] wrote: Thanks Dan. I think you may have another tag in mind. Error: Failed attempting to find SETVALUE property/method on the object Bud, I think you have to use their SetValue method: cfset oRequest.SetValue(billTo_firstName, Jane) Dan On 6/11/05, Bud [EMAIL PROTECTED] wrote: Hi all. I'm trying to use a COM object to connect to CyberSource payment gateway. I'm converting their ASP script sample. Here is my problem. I'm trying to set a value within the object (oRequest). The ASP command for this is as follows. oRequest.Value(billTo_firstName) = Jane If I try to use this within cfscript or if I use cfset as follows: cfset oRequest.Value(billTo_firstName) = Jane I get the following error: Illegal left hand side of assignment near line 50, column 7. Left hand side cannot be a function call. I've tried everything in my power to get the property set. Nothing works. Any clues? -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209273 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
Help with COM
Hi all. I'm trying to use a COM object to connect to CyberSource payment gateway. I'm converting their ASP script sample. Here is my problem. I'm trying to set a value within the object (oRequest). The ASP command for this is as follows. oRequest.Value(billTo_firstName) = Jane If I try to use this within cfscript or if I use cfset as follows: cfset oRequest.Value(billTo_firstName) = Jane I get the following error: Illegal left hand side of assignment near line 50, column 7. Left hand side cannot be a function call. I've tried everything in my power to get the property set. Nothing works. Any clues? -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209231 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: Help with COM
Thanks Dan. I think you may have another tag in mind. Error: Failed attempting to find SETVALUE property/method on the object Bud, I think you have to use their SetValue method: cfset oRequest.SetValue(billTo_firstName, Jane) Dan On 6/11/05, Bud [EMAIL PROTECTED] wrote: Hi all. I'm trying to use a COM object to connect to CyberSource payment gateway. I'm converting their ASP script sample. Here is my problem. I'm trying to set a value within the object (oRequest). The ASP command for this is as follows. oRequest.Value(billTo_firstName) = Jane If I try to use this within cfscript or if I use cfset as follows: cfset oRequest.Value(billTo_firstName) = Jane I get the following error: Illegal left hand side of assignment near line 50, column 7. Left hand side cannot be a function call. I've tried everything in my power to get the property set. Nothing works. Any clues? -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209234 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: CrystalTech does not like negative comments!
It is pretty obvious from the things being said the past couple days that CT is all about the $$$ and not about customer service one bit. Cut your losses and move EVERYTHING to HostMySite, they are top notch. I just need to balance out some of the bashing that's going on here. I host a couple hundred sites at CT. In 2 years there have been about 3 instances that have gotten my dander up. That's a pretty good track record as far as I'm concerned because I get riled pretty easy. Of course, if you'd have asked me at the time I'd have told you that they were the bane of the hosting industry. :) Overall their support has been very good. It's not perfect, but nobody is. It's as good as, or better than anyone else I've used in the past 10 years, some at substantially more money. Their servers are fast and uptime is excellent. They have the best control panel in the industry, allowing me to do most things myself. All the major CF tags are available. They use a SQL Server database for client storage (or you can use your own). I will personally continue to host every new customer at CT and recommend them to anyone and everyone that asks. All my clients are happy with the uptime and performance of their sites. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201164 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: CrystalTech does not like negative comments!
The fact that they delete negative posts about their business shows that they're not idiots. The test is whether or not they act on those problems. I got a telephone call from Crystal Tech last night. They were asking if I was satisfied with their services and if I had any ideas what they could do to improve. So apparently they are at least doing some damage control. My thoughts to them were that there needs to be more feedback from their support team. I've had problems in the past that took 3 days to fix also. I've then found out that there was (supposedly) a team working on the issue for those 3 days. Although follow up requests about the problem were seemingly falling on deaf ears and being ignored. Status reports (not just automatic emails) such as Hey Bud, this is where we're at with your issue are needed on problems that are taking more than an hour or 2 to fix. I also explained that for those of us reselling, myself I have 50+ customers running my cf_ezcart on their servers, half of which are on MX, that when there is a problem that arises in a new release of MX or whatnot that affects my cart, I don't just have the stress of trying to fix my own site, I may have 30 sites being affected. Plus maybe another 50-100 of folks hosting their own site at CT running my cart. So I know I'll also be getting support calls from them. That is VERY stressful when you cannot truthfully answer to your OWN customers what the problem is and what is being done to rectify it. So to summarize I told them that even though I'm very happy overall with their service, there have been 2 or 3 instances over the past couple years that could have been communicated MUCH better. Hopefully they'll get some good feedback. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200949 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: CrystalTech does not like negative comments!
dave said but like bud said not long ago about him posting an issue and they threatened to remove all 200+ of his sites. They didn't actually threaten to remove them. Tim U just made it clear that he didn't need my business. To be fair, we were in the midst of a pretty heated argument on the phone at the time. :) I'm happy with their support and service. 99% of the people there are helpful and happy and act appreciative of my business. I do believe that Tim does want to run the best damned web hosting company around. The problem is, he doesn't handle criticism or take suggestion well. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200676 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: So does CF 7 Suck, Or Crystaltech?
Ben Forta wrote: FWIW, Macromedia.com is a very high traffic site, and has been running CFMX7 for quite a while. --- Ben Yes, and suffering the Session Invalid problem also. -Original Message- From: Paul Kenney [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 8:18 PM To: CF-Talk Subject: Re: So does CF 7 Suck, Or Crystaltech? I don't know if this is simply a case of failure under load, but a combination of issues. Besides Michael, how many sites do you have running on the House of Fusion server? I'm guessing that it isn't anything like the number of sites a shared hosting environment has... like somewhere between 60 and 100. A server used for shared hosting isn't (and shouldn't be) set up the same as a dedicated server. There are many more issues that have to be considered and--I'm sure--lots of custom configurations. Basically, the issues going on at CrystalTech are probably not going to be as big a deal if you operate your own machines... there is always a trade-off. On Mon, 14 Mar 2005 19:48:29 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: There were specific cases (such as House of Fusion) where Macromedia allowed production servers to use the beta. I'd say that there was some heavy load testing. Macromedia strongly discouraged beta testers installing CFMX7 on production servers. So many of the things we are seeing could not have been tested if we played by the rules. Most testing was probably done under very light loads. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198797 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: Problems at CrystalTech have gotten ugly!
Jared Rypka-Hauer wrote: I was under the impression that the error came up when the CF session timed out first, but, logically, that makes no sense. If the CF session timed out, it would just ask Jrun for a new one... so the issue pops up when CF expects Jrun to be holding session information and Jrun can only reply with a session undefined error. So I'd set the Jrun sessions to time out, say, 5 minutes past the CF sessions. That way, if CF kills a session and Jrun creates a new one, you've only got a few minutes of overlap. Conversely, since CF sessions will ALWAYS time out before the Jrun sessions, Jrun will never be expected to remember session information for CF that it has already dropped because it times out first. So c'mon, you guys, what's the big issue here? :P That worked for 6.1. That stopped working in version 7. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198647 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: Problems at CrystalTech have gotten ugly!
Has anyone confirmed this works as a workaround on CrystalTech servers? Crystal Tech is where I use it. It won't stop the error, but it becomes more of a glitch rather than just locking the user out entirely. -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 3:39 PM To: CF-Talk Subject: Re: Problems at CrystalTech have gotten ugly! I've had good luck setting my cfapplication tag like so in the MX 7 environment in the 2 sites I have running on it: cftry cfapplication name=#attributes.dsn#_#variables.setup_id# applicationtimeout=#createtimespan(1,0,0,0)# clientmanagement=Yes sessionmanagement=yes sessiontimeout=#createtimespan(0,0,20,0)# setclientcookies=No cfcatch type=Any cfapplication name=#attributes.dsn#_#variables.setup_id# applicationtimeout=#createtimespan(1,0,0,0)# clientmanagement=Yes sessionmanagement=yes sessiontimeout=#createtimespan(0,0,0,0)# setclientcookies=No /cfcatch /cftry basically, the tag inside the cfcatch is identical except the sessiontimeout is 0,0,0,0. This kills the session, hides the error and the next click should start an error-free session. -- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198384 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: Problems at CrystalTech have gotten ugly!
Possibly the server i'm currently assigned to? ... cause if i try the site in another browser the forums are working fine. No, it just happens if YOUR session is timed out. Using another browser will create a new session. Normally a new CF session is created when one doesn't exist. However if the underlying J2EE session still exists, it throws the Session Invalid error at the cfapplication tag which stops the new CF session from being created. It's quite an ugly situation and there is no excuse in my mind for MM not to have addressed this at some point in version 6. You would think they could easily make it so if one session expires, BOTH sessions expire if they are going to rely on each other in order to function. Andy On Fri, 11 Mar 2005 16:40:03 +0700, Paul Hastings [EMAIL PROTECTED] wrote: Andy Allan wrote: Interestingly I'm currently getting the Session is invalid error right now on the Macromedia forums. not seeing that, though somebody has taken a stick to the forums' forums. the i18n, java component forums seem to have gone the way of the brontosaurus. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198387 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: Problems at CrystalTech have gotten ugly!
Matt Robertson writes: Micha brings up a point you guys with the triple-digit site counts should consider, if you are on shared hosting... why on God's green Earth are you putting up with a shared environment? Costwise, the breakeven point is *long* past. snip I've been doing my own dedicated servers for maybe four years and I wouldn't go back to shared hosting for anything. I colo'd for a couple years. For the extra money I made on the hosting, it wasn't worth the stress. Heck. I was scared to go to Dolphin games for 3 hours fearing a server would go down and I'd have to leave at halftime. LOL That coupled with installing a microsoft security patch [what seemed like] every 45 minutes, I had no life. To me, it was MUCH easier to give the hosting, some of the profits and the majority of the headaches to someone else. I did some investigating and asked some questions when I went to CT a couple years ago and their support and service was very good and I'm still happy with them overall. Considering my stress level is down 90% from running a single web server, SQL server and mail server (3 total), I'm glad I made the move. I supposed if I wanted to concentrate solely on the hosting end, that would be different. But I really found I was over my head trying to manage web servers and work at the same time. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198436 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: Problems at CrystalTech have gotten ugly!
They're saying it's a CF7 problem, which I think is BS! I agree though, switching sounds logical, it's just tough when you have so much tied up in one host. Moving makes me wanna toss my cfcookies! I go through hell every time Allaire or Macromedia releases a major version no matter where I'm hosted. Did it with 4.5. Did it with 5.0. MX 6 just about bankrupted me. 7.0 seems to be staying the course and I'm staying far away for at least an updater or 2. There should be ONE freaking setting for sessions. If you set the session to timeout in 30 minutes, dammit the J2EE session should time out in 30 minutes also. If the max time for J2EE sessions to time out is 20 minutes, then you should be ABLE to set CF sessions to 30, and vice-versa. Tim is rude at times. He certainly cannot take any criticism at all. I've got about 200 sites at CT and he's basically threatened to shut me down if I complain in public when I can't get help through the normal channels. I stay off the CT forums now. All in all I'm very happy with their support and service. Although I have had several hair-pulling moments as you are now. I've had good luck setting my cfapplication tag like so in the MX 7 environment in the 2 sites I have running on it: cftry cfapplication name=#attributes.dsn#_#variables.setup_id# applicationtimeout=#createtimespan(1,0,0,0)# clientmanagement=Yes sessionmanagement=yes sessiontimeout=#createtimespan(0,0,20,0)# setclientcookies=No cfcatch type=Any cfapplication name=#attributes.dsn#_#variables.setup_id# applicationtimeout=#createtimespan(1,0,0,0)# clientmanagement=Yes sessionmanagement=yes sessiontimeout=#createtimespan(0,0,0,0)# setclientcookies=No /cfcatch /cftry basically, the tag inside the cfcatch is identical except the sessiontimeout is 0,0,0,0. This kills the session, hides the error and the next click should start an error-free session. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198069 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: Problems at CrystalTech have gotten ugly!
If the max time for J2EE sessions to time out is 20 minutes, then you should be ABLE to set CF sessions to 30, and vice-versa. Sorry. That should have read then you should NOT be ABLE to set CF sessions to 30 -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198070 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: CT still doesn't have sessions fixed!
So from that I'd guess that if my timeout is 30 and the JRun timeout is 40, I have to request the page between those times to get the error? Which would explain why I don't always get it after long waits. I used to get the problem and then didn't notice it any more once I reduced the ColdFusion timeout to 20 minutes. I just upgraded a site to 7.1 though for testing and sure enough, it's coming up even with the CF timeout at 20 minutes. Client vars, what's the deal with those on CT then? Reply off list if you like. Please reply on-list if you can or off-list otherwise. I've got a couple hundred sites with CT. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196721 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: Preventing Malicious Sql without cfquery param
Strings are within single quotes. Can you tamper with '#url.emp_id#' if emp_id is text?? ; DROP * FROM TableName WHERE 1=1 -- If that is within single quotes, why wouldn't SQL read that simply as a string of text? -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193223 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: Preventing Malicious Sql without cfquery param
gabriel l smallman wrote: Realistically, coldfusion automatically escapes any single quotes But if im not mistaken(easily could be) someone might not need to be able to stuff in single quotes to tamper? I think they need the semi colon and parens to insert a sub query to blow something up ;(drop table users) or something of the sort? If your query doesn't already have the single quotes... that's an issue, like this: cfquery .. select * from emp where emp_id=#url.emp_id# /cfquery That would certainly be bad... I use val() select * from emp where emp_id=#val(url.emp_id)# Anything not numeric will be dropped. A totally non-numeric value will return 0. For dates I use ODBCDateFormat. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192559 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: CF5 to CFMX - cfif breaks
I figure this is an ODBC vs. JDBC issue . . . The following cfif has been working fine in CF5 for 3 years but it breaks in MX 6.1 with updater (we are just now migrating CF5 to MX, so I don't know if it would have worked in MX or MX 6.1 pre updater . . .): cfif right(trim(code), 1) is not 0 and trim(code) is not W8 and trim(code) is not W12 and right(trim(code), 3) is not 904 or not isDefined(RS1) closeTransferWindow(); alert(An error has occured within this application, please try again later. cfoutput#code#-#message#/cfoutput); cfelse snip Any ideas why the cfif isn't working on MX? It looks to me like there is a parentheses missing or something, depending on what RS1 is. Maybe MX places different priority on the comparisons. I would think the code should be something like: if RS1 not being defined overrides all the previous comparisons. cfif (right(trim(code), 1) is not 0 and trim(code) is not W8 and trim(code) is not W12 and right(trim(code), 3) is not 904) or not isDefined(RS1) or if RS1 not being defined only overrides if right(trim(code), 3) is not 904. cfif right(trim(code), 1) is not 0 and trim(code) is not W8 and trim(code) is not W12 and (right(trim(code), 3) is not 904 or not isDefined(RS1)) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192624 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: Preventing Malicious Sql without cfquery param
I use val() select * from emp where emp_id=#val(url.emp_id)# Anything not numeric will be dropped. A totally non-numeric value will return 0. For dates I use ODBCDateFormat. That's great for numbers, but what about strings? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Strings are within single quotes. Can you tamper with '#url.emp_id#' if emp_id is text?? -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192627 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
Page stops processing
Hi all. I've got a problem on a site I'm helping with. The cfm pages simply abort processing for no apparent reason. There is no ColdFusion error given and it aborts in random places of any given page. It's like someone simply highlights the last portion of the page and hits delete. The page source will end something like this: input type=hidden Then nothing. MX6.1 with the updater installed. IIS 5 I'm working on finding out how much RAM, CPU, etc. they have now, but I figured I'd throw it out here and see if anyone has seen this. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183475 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: Page stops processing
Jochem, thanks. Great answer. It appears it's not CF. Had this once. CF didn't stop processing but the transfer to the client aborted. Put a cfhtmlhead in your OnRequestEnd.cfm and if it shows up in the header of the page it is not CF stopping, but a data transfer error. Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183498 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
Verified By Visa and MasterCard SecureCode
Hi. Has anyone done any implementation of Verified By Visa and MasterCard SecureCode using CF? I'm trying not to re-invent the wheel here if I don't have to. Thanks! :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
New HOTFIX breaks J2EE sessions!
Hi. I put this out under a different subject but got no response. The new hotfix released on 10/7 does not decode the JSESSIONID cookie. 1) If I manually set a JSESSIONID cookie based on a URL variable or whatnot, which I do when I move from one domain to another (such as a shared SSL URL when collecting payment info), it is URL encoded. 2) CF reads it but does not decode the value. It must think it is an invalid ID since the $ become %24. The session is sufficiently broken. Until now, as with any URL Encoded value, CF will decode it before processing it, comparing it, etc. My only workaround is to set the cookie with _javascript_. I don't want to rely on _javascript_. I need to get this to MM. I've got applications breaking all over the place. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Hot fix and J2EE session cookies: MM Please read
Hi all. I've been so busy and whacked out by all these hurricanes lately that I unsubscribed for awhile. Now I need your help or at least get this message to MM. A hot fix just came out on 10/7 I believe. It will update the Server.ColdFusion.ProductVersion to: 6,1,0,83762 This hot fix just broke a BUNCH of shopping carts on Crystal Tech for me. I'm hoping they are working with MM on this, but sometimes it takes a few days to convince their support team that there is a problem with CF or their servers. To make this short and to the point as possible... A person using my shopping cart may typically move back and forth between secure and non-secure URLs like: http://www.cf-ezcart.com/etc. to https://www229.ssldomain.com/cf-ezcart/etc. If they begin checkout, abort checkout, etc. I ALWAYS pass the urltoken, which will contain the jsessionid when clicking Check Out. This is in order to keep the session alive. Since CF does not set a jsessionid cookie if the jsessionid URL variable is passed, I have always set it manually using CFCOOKIE. This has never been a problem, until the hot fix. The bug in the hot fix is this: The internally generated JSESSIONID has $ symbols in it. When CF writes the cookie itself, it writes the value as raw data. When I duplicate it with CFCOOKIE when moving to the secure URL, it URL Encodes the data so the $ becomes %24. MX has always done this so this is not the problem in itself. The problem is that if I have an internal JSESSIONID of AB$C and a JSESSIONID cookie of AB%24C, my session is dying. Basically, CF is not decoding the cookie value before comparing it as it always have. This has REALLY caused me some grief. The only work around I have found so far is to set the cookies using _javascript_ as that allows me to set a raw value. Thanks for any insight into this is getting it passed on to someone who can get this fixed. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: best CF host for 20 dollars a month
IMO your best bet is probably going to be crystaltech.net, though SQL Server is $27/mo This answer is assuming you are looking for a host for multiple sites. Each additional site hosted at Crystal Tech is an extra 3% off until you get to 30% off (so sign up your $7.95 static sites first if you have any). That's under $20.00 per month including SQL Server after the reseller discount. They also provide a 25 MB MySQL database on the $18.95 plan (about 12 bucks after the discount). -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: web hosting, sql 2000
Yes, worse comes to worse I would script it via CF. I'm comfortable doing that to add and drop a table or a couple fields. But this will have 15-20 tables. I would rather have Enterprise Manager / phpmysql sort of overview. And yes, I suppose I could build my own. ... But why reinvent the wheel? For $16.95 a month you can get a 25 MB MySQL database at Crystal Tech and then you can use phpMyAdmin. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
MySQL and CF 5
Hi. I just got this response to a support request from Crystal Tech. CF 5 does not support DSNs using MySQL. You have to specify a connection string. Obviously this isn't true. I can connect to their MySQL Server from here at home using the same driver (3.51). I tried to explain that the only thing CF 5 can't do is MANAGE the DSNs through the CF Admin. No response yet. Here is the error I get whenever trying to run a cfquery. Any clues on what the problem may be? I've tried from 2 separate servers, but both databases are on mysql5. By the way, the ONLY difference in the error from one servers to another is the '2' (in near '2')is '1' on one of the servers. ODBC Error Code = 37000 (Syntax error or access violation) [MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '2' at line 1 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (4:1) to (4:72). Thanks! -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL and CF 5
On Friday 20 Feb 2004 13:50 pm, Bud wrote: [MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '2' at line 1 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (4:1) to (4:72). And what is the query you are running ? IIRC the error output includes the SQL as it was sent, after any substitutions etc. Any query. Select somerow FROM sometable -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL and CF 5
what does the query you are calling look like It's not the query. It's ALL queries. :) ? -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 13:50 To: CF-Talk Subject: MySQL and CF 5 Hi. I just got this response to a support request from Crystal Tech. CF 5 does not support DSNs using MySQL. You have to specify a connection string. Obviously this isn't true. I can connect to their MySQL Server from here at home using the same driver (3.51). I tried to explain that the only thing CF 5 can't do is MANAGE the DSNs through the CF Admin. No response yet. Here is the error I get whenever trying to run a cfquery. Any clues on what the problem may be? I've tried from 2 separate servers, but both databases are on mysql5. By the way, the ONLY difference in the error from one servers to another is the '2' (in near '2')is '1' on one of the servers. ODBC Error Code = 37000 (Syntax error or access violation) [MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '2' at line 1 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (4:1) to (4:72). Thanks! -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/http://www.twcreations.com/ - http://www.cf-ezcart.com/http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 _ [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL and CF 5
Obviously this isn't true. I can connect to their MySQL Server from here at home using the same driver (3.51). I tried to explain that the only thing CF 5 can't do is MANAGE the DSNs through the CF Admin. Annoyingly its only CF5 on windows that doesn't have the form for managing mySQL DSNsIts there on *nix... :o( [MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '2' at line 1 Like everyone else has asked - whats the query? ;o) CFQUERY username=#username# password=#password# DATASOURCE=#dsn# CREATE TABLE testtable ( Test_ID INT NOT NULL, Test_Field INT, PRIMARY KEY (Test_ID) ) /cfquery Stephen [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL and CF 5
Of course that is not correct.We have been supporting MySQL via DSN from CF 5.0 ever since 5.0 was released.Both on Windows and Linux platforms. CFMX 6.1 also supports MySQL DSNs. They don't have a problem with MX. == Stop spam on your domain, Anti-spam solutions http://www.clickdoug.com/mailfilter.cfmhttp://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.comhttp://www.clickdoug.com == Aspire to Inspire before you Retire or Expire! - Original Message - From: Bud To: CF-Talk Sent: Friday, February 20, 2004 7:50 AM Subject: MySQL and CF 5 Hi. I just got this response to a support request from Crystal Tech. CF 5 does not support DSNs using MySQL. You have to specify a connection string. Obviously this isn't true. I can connect to their MySQL Server from here at home using the same driver (3.51). I tried to explain that the only thing CF 5 can't do is MANAGE the DSNs through the CF Admin. No response yet. Here is the error I get whenever trying to run a cfquery. Any clues on what the problem may be? I've tried from 2 separate servers, but both databases are on mysql5. By the way, the ONLY difference in the error from one servers to another is the '2' (in near '2')is '1' on one of the servers. ODBC Error Code = 37000 (Syntax error or access violation) [MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '2' at line 1 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (4:1) to (4:72). Thanks! -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/http://www.twcreations.com/ - http://www.cf-ezcart.com/http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL and CF 5
Can ou put the whole exception somewhere ? Either here or on a website ? Thanks Tom. In case you want to look: http://216.119.123.68/create.cfm But they've told me now that mySQL won't work with DSNs and CF 5 on their network. I think they just don't feel like looking into the problem since there is a workaround (DSNLESS connection). Thanks again. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Killing clients in one clean sweep!
I'm trying to kill all the client variables in one clean sweep but can't seem to get it right.I kind of worked out how to do one as: cfset temp = DeleteClientVariable(user) But how do I just go through all current client variables and delete them all? Is it something like? cfset temp = DeleteClientVariable(#GetClientVariablesList()#) Close. Try this. It's not exactly a clean sweep but it works. :) cfloop index=i list=#GetClientVariablesList()# cfset temp = DeleteClientVariable(i) /cfloop -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: Legal?
Ok, a client of mine has gone nuts. He is an agent for a few celebrities, and I had offered to create a site for one of his clients free-of-charge provided I was the one running the site. He has now decided to go to another designer, and wants me to give him the site, which as I said he has not paid for. Now, there is no written contract saying that I would do it for him free-of-charge, so I guess he has me there. But at the same time, since there is no contract saying I would do it free-of-charge, since he hasn't paid me, he is not entitled to the site. I told him if he wanted to pay me for the work, I would give it to him, but he keeps threatening me of legal action. Am I wrong here or is he really entitled to the site? Anyone know anything about the law in this case? You had a verbal contract. Verbal contracts are legal. The verbal contract said the site was his as long as you are running/hosting it. You're no longer running/hosting it, so it's not his. He broke the contract. Now if he wants the site, you two can negotiate a new contract. Now that you've discovered this fellow's nature, the new contract should contain $$$, all of them up front. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
WAY OT - Netscreen Firewall (and stuff) For Sale
Hi. Sorry for the OT post. Please respond off list. I'm hoping not to get admonished too bad, but I do try and keep my idle banter to a minimum, so hopefully I've got an OT post coming. :) I'm getting out of the hosting business. Just can't compete with the big boys any more. :) I have a like brand new Netscreen 50 that I'm trying to sell. It has spent it's entire life (December 2001) in an air conditioned, dust-free colo server room. It's been upgraded to Screen OS 4 and reset to factory defaults. I'm looking for 3,000 but will take a reasonable offer. It will ship to you in original packaging with original documentation, etc. I've also got a couple other cools items. Dell 2400, Dell 1500, HP Procurve 12 port Switch, Belkin 8 port KVM Switch. All in like new condition. Again, sorry for the OT post. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Group and CurrentRow MOD
I'm trying to group people by state, with two columns of names under each state heading. This works, other than some states don't always fill the second top column in the group. Some rows display correctly, and others don't. I have some states with 3 names that work correctly. I get STATE name1 name2 STATE name1 name2 name3 etc. How can I force the 2nd column to fill from the top of the group. I'm not sure if this will help or not, but you can check out my cf_recordcount tag. http://www.twcreations.com/recordcount/ It's designed to be able to return the top X number of records or X number of records per page based on any group out of a joined query. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: SQL: Brain Teaser
CFQUERY DATASOURCE=??? NAME=getcomments SELECT U.UserID,Username,CommentID,Comment FROM Users U LEFT OUTER JOIN Comments C ON U.UserID = C.UserID Order By U.UserID, CommentID /CFQUERY CFOUTPUT query=getcomments group=UserID #UserID#,#UserName#CFOUTPUTbr#Comment#/CFOUTPUT /CFOUTPUT Perhaps this is easy for someone so I figured I'd ask. Here's the scenario: USERS TABLE - USER_ID USERNAME etc... COMMENTS TABLE - COMMENT_ID USER_ID COMMENT etc... I know I can query USERS and then loop through the results fetching the comments... but I'd rather not do that. Here's the results I'm trying to get... in a SINGLE query if possible: USER_ID,USERNAME,MERGED_COMMENTS 1,joe,comment1brcomment2brcomment3 2,sam,comment 3,sue,commentbranother commentbretc. Any ideas? -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP! Can't clear the CLIENT scope
I'm having some trouble...I'm using CLIENT scoped variables because
we are in a load-balanced environment. I need to delete some
variables from the client scope and it's just not
working...structClear(CLIENT) seems to work when I refresh the
browser window to load that code, but when I go back, all of the
data that was in the CLIENT scope before is still there. I tried to
go in and delete specific keys by doing
structDelete(CLIENT,client_data), one at a time, but that didn't
work either.
Is there a reliable way to delete values from the CLIENT scope? Or
am I doing something stupid?
I do it like this:
cfset clientlist = GetClientVariablesList()
cfloop index=i list=#clientlist#
cfset temp = DeleteClientVariable('#i#')
/cfloop
--
Bud Schneehagen - Tropical Web Creations, Inc.
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Web Based Solutions / eCommerce Development Hosting
http://www.twcreations.com/ - http://www.cf-ezcart.com/
954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP! MSXML ServerHTTP and CFHTTP alternatives?
Ok, in order to talk to eBay's API, I need to send XML requests with UNENCODED custom headers. So obviously CFHTTP is out. ;( I've been using for the last year or more the MSXML ServerHTTP object and that has been fine. Except now I'm having problems that I can't seem to fix (server crashes when object is instantiated) so I'm looking for another alternative... Any ideas? This is a Win2k server with Apache and CF5. We're also prepping a linux box right now with CF5 and I'll need a solution for that as well since COM doesn't work on that platform (CFEXEC with Curl?)... CFX_RawSocket If you can use MX you can use the new cfhttpparam type=XML -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Please Test??
70 fields returns nothing for me. 10 fields returns 10 fields submitted. Hope this helps, It helps a lot. Thanks. -Novak - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, August 10, 2003 5:38 PM Subject: Please Test?? Can you all please load this page and click to 2 form buttons. https://www363.ssldomain.com/rubylarue/form.cfm This is a page on Crystal Tech that is running MX on Windows 2003/IIS 6.0. The new 6.1 updater has NOT been installed (running 6,0,0,58500). Tech support cannot see a problem. I cannot get the form with 70 fields to work using IE 5 or 6 on PC. I cannot get either form to work running Safari. The exact same page works fine on an MX server running 2000/IIS 5.0. The page should return... 70 fields submitted 10 fields submitted ...respectively. This only manifests itself under the SSL certificate (Instant SSL Wildcard cert). Thanks for the feedback. I've been trying for well over 48 hours to convince the good tech support folk at CT that there is a problem. Below is the page where it does work. https://www229.ssldomain.com/cf-ezcart/form.cfm And if anyone has seen this or can point to any documentation, that would be great. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Please Test??
Bud, I get 10 fields submitted But when I click the 70 button I get a blank page. I am running IE 6.0.2800 on windows xp pro. Not sure if you wanted this feedback, but here it is :-) That's exactly the feedback I want. Tech support says there is no problem. The problem I'm having is, my shopping cart returns a blank page when submitting the billing info. After hours of testing, I narrowed it down to the number of fields. Once there are more than 20, problems start. But only in IE on PC, until I just tested in Safari. Forms don't work at all in that case. -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2003 8:38 PM To: CF-Talk Subject: Please Test?? Can you all please load this page and click to 2 form buttons. https://www363.ssldomain.com/rubylarue/form.cfm This is a page on Crystal Tech that is running MX on Windows 2003/IIS 6.0. The new 6.1 updater has NOT been installed (running 6,0,0,58500). Tech support cannot see a problem. I cannot get the form with 70 fields to work using IE 5 or 6 on PC. I cannot get either form to work running Safari. The exact same page works fine on an MX server running 2000/IIS 5.0. The page should return... 70 fields submitted 10 fields submitted ...respectively. This only manifests itself under the SSL certificate (Instant SSL Wildcard cert). Thanks for the feedback. I've been trying for well over 48 hours to convince the good tech support folk at CT that there is a problem. Below is the page where it does work. https://www229.ssldomain.com/cf-ezcart/form.cfm And if anyone has seen this or can point to any documentation, that would be great. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Please Test??
Can you all please load this page and click to 2 form buttons. https://www363.ssldomain.com/rubylarue/form.cfm This is a page on Crystal Tech that is running MX on Windows 2003/IIS 6.0. The new 6.1 updater has NOT been installed (running 6,0,0,58500). Tech support cannot see a problem. I cannot get the form with 70 fields to work using IE 5 or 6 on PC. I cannot get either form to work running Safari. The exact same page works fine on an MX server running 2000/IIS 5.0. The page should return... 70 fields submitted 10 fields submitted ...respectively. This only manifests itself under the SSL certificate (Instant SSL Wildcard cert). Thanks for the feedback. I've been trying for well over 48 hours to convince the good tech support folk at CT that there is a problem. Below is the page where it does work. https://www229.ssldomain.com/cf-ezcart/form.cfm And if anyone has seen this or can point to any documentation, that would be great. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help with ACCESS and DATES.. Oh The Horror!!
I've got a strange one, its pretty strange to me, maybe not to one of you...
I insert a date for a record using this set statement
cfset form.record_modifieddate=createodbcdate(now())
and inside the database the record looks like this
8/1/2003 2:47:29 AM
CreateODBCDate(now()) would not put that time in the database.
CreateODBCDate(now()) assumes midnight and will always put:
{d '2003-08-01'}
Which will show as 8/1/2003 00:00:00
CreateODBCDateTime(now()) would put the time. So double check that
you're using CreateODBCDate.
If you need the time in there and you need to query for any times
within a date, you'll need to do a range query:
record_modifieddate =
#CreateODBCDateTime(CreateDateTime(year(now()), month(now()),
day(now()), 00, 00, 00))# and
record_modifieddate =
#CreateODBCDateTime(CreateDateTime(year(now()), month(now()),
day(now()), 23, 59, 59))#
--
Bud Schneehagen - Tropical Web Creations, Inc.
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Web Based Solutions / eCommerce Development Hosting
http://www.twcreations.com/ - http://www.cf-ezcart.com/
954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for Tropical Web Dsign list member
Hey All, I'm looking for some contact info from a guy on this list. I think he's from a company along the lines of Tropical Web Design.think his name is Bud...pretty sure he wrotea custom tag to integrate with UPS shipping (WorldShip). Anybody?? Hey, that might be me Bryan. :-D -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for Tropical Web Dsign list member
Hey Bud, What does you're tag do? I'm looking at integrating an e-comm backed so a fulfillment centre can select the orders to ship...which will pass off shipping details to WoldShip (or some other UPS tool I may not know of)this should then send e-mails to the customers with their order nmber and the fact the order has shipped and allow the fulfillment centre to print the shipping labels. Doe that jive with your tag? Any other useful UPS integration info would be greatly appreciated as all I'm getting from UPS and the client is UPS marketing fluff ;-) My tag gets shipping rates using the UPS Online Rates Services tool, so it's really more front end and used during the checkout process. The problem is, it's integrated into my shopping cart and that's all it's licensed for. UPS is pretty weird about their licensing. I think they want people to use USPS and FedEx rather than UPS. I'd really like to make the tag I built to integrate with my shopping cart available for everyone, but UPS told me they're going to start taking legal action against people that offer any sort of modules and/or custom tags, etc. that integrates with their Online Tools, free or otherwise, that isn't expressly licensed for that purpose. That said, I can probably give you some sample code if you need it. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Posting data via SSL - help please
Hi, I've been banging my head for several days on this problem and need some help/advice. Using CFMX, Updater 3 I need to upload a file to one of our vendors for payment processing. They require three form fields in enctype=multipart/form-data format; login, pass, filename. The URL I'm posting to is SSL (https://www.interceptcorporation.com/uploadcsv.icp) When I use cfhttp and cfhttpparam to send the data, I get a -98 error, which the vendor tells me is an invalid login. I have since figured out that cfhttp and cfhttpparam can't do SSL transactions, so, I looked around and found two Custom Tags; CFX_RawSocket (www.iexp.com) and AdvHTTP (www.aspfusion.net). I can't get either of these to work. CFX_RawSocket returns an SSL Implementation not available error. AdvHTTP returns data exactly like using cfhttp and cfhttpparam, which leads me to believe that it is not doing SSL either. There just has to be a way of doing this. Has anyone had any luck in posting a file to a secure site via CF? Are there any other CF tags that will do the trick? I believe you have to have JRE 1.2 and the Secure Socket Extension installed to use SSL with cfx_rawsocket. I've used it with SSL with no problem. Same goes with CFHTTP. I use it to do SSL posts all the time. I'm not sure about uploading a file though. I'm pretty sure you can't specify the enctype in cfhttp. Do you have a test login you can share and a sample upload file? Can't promise anything but I can play around for a bit and see what happens. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
