RE: CF Credit Card Verification/ Authorization Question
I've had great success with Verisign. Their processing is fast, stable, and easy to set up. They're also cheaper, (at least as of a year or so ago) and have good support. One word of advice, though, when you look for a processor, make sure that they can process your transaction in under 5 seconds, or your users will start to double click, etc... which will cause a lot of support nightmares. Jeff Polaski "The cow is of the bovine ilk; One end is moo, the other, milk." -- Ogden Nash -Original Message- From: CF-Ross [mailto:cf-ross@;carolina.rr.com] Sent: Sunday, October 20, 2002 5:29 PM To: CF-Talk Subject: CF Credit Card Verification/ Authorization Question Anyone have suggestions on which Credit Card Authorization/ Verification systems are best suited for CF. I have the shopping cart built and all is set up but I'm not familiar with the actual CC Verification Process. Any comments, links, suggestions? Thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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.
RE: SQL vs PL/SQL
If you're just converting queries into Oracle stored procedures, I think it would be fair to estimate a weekend to a week to get up to speed (depending on your experience with SQL and the time you put in to it). But to get good at what you're doing will take a longer... I'd just like to point out that, while closely related, PL/SQL and SQL are two very different languages. PL/SQL is more of a "regular" procedural programming language and the things you do with it are different than the things you do with straight SQL. PL/SQL is used more for the things you do with CF, Java or any other "regular" programming language. PL/SQL was just designed for a particular niche, the Oracle database, so it has db specific features, too. SQL is a (fairly) standard way to interact with databases and is more of a functional language. When you write PL/SQL you'll use SQL. I you can download Oracle from their web site (or at least you used to be able to) and play around with it. That and the docs should be a good start... Jeff Polaski "The cow is of the bovine ilk; One end is moo, the other, milk." -- Ogden Nash -Original Message- From: Casey C Cook [mailto:ccook22@;csc.com] Sent: Thursday, November 14, 2002 8:34 AM To: CF-Talk Subject: OT: SQL vs PL/SQL If someone came to you and said we need someone to work with Oracle and PL/SQL to write some queries, but all you knew was SQL, how much of PL/SQL would you say you already knew, knowing there are some syntax differences between the two query writing languages? Im just trying to gauge how much work I will have to do to to pick up PL/SQL, a weekenda week...a month? Thanks, Casey Cook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Java in CF (CFMX)
Personally, I'd like to see CF Script expanded to deal with strongly typed code. It would be extremely cool to be able to run code from a different languages in a cfscript block (kinda' like MS's Scripting Host). I can see a couple of other benefits to having inline Java code: Stronger types for variables. (well, stronger types for /values/). Sometimes it's extremely useful to have strong types. For example, I worked on using native COM datasets in CF a few years back and we had a lot of problems converting the native COM dataset into a CF query. was a huge performance hit for a CF script to loop over each field, convert it, and stuff it in a CF query. If CF could (optionally) deal with different types I think it would have been a lot easier to do, and a cfscript block would be a great place for this. Also, it would be *great* to be able to pass functions around as values--that alone would certainly simplify my code in places. One of CF's great benefits is it's simplicity, but sometimes it's important to be able to get out of the simple tag-based techniques of CF and into more "advanced" techniques. When I'm developing, sometimes I want to be able to just dump some code on a page and thrash away. It gets in the way to have to develop separate components. After I'm done thrashing out some code, I want to make sure it's clean and maintainable, and put it into components, though. It's just nice to have the option. I know basically nothing about the actual behind-the-scenes architecture of CF, so take this with a grain of salt, but I don't see why CF couldn't just automatically compile a cfscript block as a separate class if you added a keyword to it, like: . There is already a lot of code generation going on when CF creates the class files from a CF page. Well, just my $0.02... Jeff Polaski "The cow is of the bovine ilk; One end is moo, the other, milk." -- Ogden Nash -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 9:30 PM To: CF-Talk Subject: Re: Java in CF (CFMX) I am really late to this thread -- been doin' other interesting stuff. There are one (or two, or forty) reasons that have not been mentioned, that make inline Java code a benefit. 1) Where needed in an app, you can get strong typing and nulls -- say you want to communicate with a JDBC driver and retrieve Table/Column attributes from a db -- most JDBC drivers provide this info, but you can't get at it directly form CMFX. 2) Where CFMX can act as a gentle introduction to Java -- certainly this hybrid code would not be the best, but it would allow Java neophytes, like myself, to learn Java gracefully, without having to learn all the rules first. -- There is something about the fact that we can learn our native language, better, by the age of 5, than a person with 4 years of college courses on that language -- simple introduction, constant use, familiarity-- a lot of us "Learn by Doing!" 3) This would put /keep CF at the head of the pack -- one more significant reason to choose CF over the competition -- EasyJava -- choose the language/implementation that makes the most sense for an application and/or a tier. Dick P.S. while I am asking for things, I'd like to see a ... tag -- does the same thing (and does not deprecate the tag-- just a lot easier to type (and pretty self-documenting, and makes a lot more sense than that <%= crap!) On Friday, November 22, 2002, at 08:56 AM, Rob Rohan wrote: > I understand your decision but I have a couple more things to add, > then I'll > shut up. > > 1) To me CFSCRIPT is to Cold Fusion 5 what CFJAVA would've been to > CFMX. > > 2) I also don't think people would just use a cfjava block to just use > it. > There would have to be a need. (I.E. a custom java tag that doesn't > need to > be installed) > > 3) I would like to play with inner classes / threads on a page and > casting > to thing (like a CF list to a hashtable - don't even know if that would > work, but you get the idea). > > 4) There could be performance gains beyond code execution. For > example, when > you make a cfm page into a class it adds a bunch of \r\t which is > necessary > in almost all cases (but certain blocks could be controlled) > > Thanks for listening Phil and all you wacky MM guys > > Rob > > Certified Organic > "When you put things in quotes, people think someone actually said it." > http://treebeard.sourceforge.net > http://ruinworld.sourceforge.net > Scientia Est Potentia > > -Original Message- > From: Phil Costa [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 22, 2002 6:09 AM > To: CF-Talk > Subject: RE: Java in CF (CFMX) > > > The decision to disallow inline java code was definitely not a cut and > dry > one. One reason was definitely to enforce a cleaner separation of > syntax; > the other, which I hadn't mentioned, was to remove some addi
RE: Get List of tables in a DB
If you're using MS SQL server, you can also run the following SQL from Query Analyzer: -- get all tables for a db select left(so.name, 27) as tableName ,left(sc.name, 20) as columnName ,left(st.name, 10) as dataType ,sc.length as dataLength from sysobjects so ,syscolumns sc ,systypes st where so.id = sc.id and sc.xtype = st.xtype and so.xtype = 'U' order by so.name, sc.name -- get all stored procedures for a db SELECT sysobjects.name as name ,sysusers.name as PROCEDURE_SCHEMA FROM sysobjects ,sysusers WHERE sysobjects.uid = sysusers.uid AND sysobjects.type = 'P' ORDER BY name When I'm developing I use the first one all the time to tell me about the tables and datatypes and data sizes for the fields, etc... it's very useful, and a lot faster than messing around with the Enterprise manager. Usually I just run the top SQL statement when I start working on a db, and copy/paste everything into a text editor (UltraEdit) so I don't have to keep running it. Every once in a while I need to adjust the "left()" statements to get a long name or something, but, all-in-all, these values work really well. Jeff Polaski "The cow is of the bovine ilk; One end is moo, the other, milk." -- Ogden Nash -Original Message- From: James Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 4:26 PM To: CF-Talk Subject: Get List of tables in a DB Hi, Is there a CF function or SQL statement that returns a list of table in an Access DB? Thanks *** James Johnson SMB-Studios Innovative Online Learning for Spirit, Mind and Body www.smb-studios.com [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: OT? Easy data entry util for SQL?
Just my $0.02... I'd have to agree with Dave Watts, that, if you are a developer, editing data in a database manually is rarely a good idea. If you're going to do web development, it's important to be able manipulate data in a db through SQL. (Ben Forta's _SQL in 10 Minutes_ is a good start. _Joe Celko's SQL for Smarties: Advanced SQL Programming_ is also an excellent book when you get past the basics.) One of the good things you get from being able to use the standard SQL data manipulation commands (select, insert, update, delete) is that you can write scripts to do all of the work for you. For example, you can write a SQL statement to /generate/ insert statements, or write a python script to make updating a table easier. I can save you hours and hours of tedious work better done by a computer. Probably the most important reason to write all your own SQL is that you become more aware of what you can do with the database. You can better judge what kind of code belongs on the db (for example, as a stored procedure). Jeff Polaski "The cow is of the bovine ilk; One end is moo, the other, milk." -- Ogden Nash -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 5:52 PM To: CF-Talk Subject: OT? Easy data entry util for SQL? We have been using Access for so long now I got used to being able to enter/edit data with a few mouse clicks, just opened up the table and started typing or making corrections (to users, parameters files, or erroneous transactions during development). Now that development has been ported to SQL, I dread the command-line data entry of ISQL 6.5. Is there an easier way to do what I got used to doing with Access? A recent article, I believe it was in CFDJ, talked about interfacing the Access front-end to an SQL database thru ODBC. Have you actually tried it? Any tips/tricks? Thanks In Advance Ed Gordon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
RE: end.cfm?
At a place I worked at several years ago we switched from Win2K to Linux because Linux was a lot easier to administer remotely. All the production servers were in a rack about 30 miles away and it was too much of a pain for the admins to drive up there when the servers would get wedged. (On Linux (and Unix in general) you can easily administer a box over a telnet session. Good luck doing that w/Windows...) Anyway, to put this back on topic, we had some trouble with "Application.cfm" vs. "application.cfm". It was resolved pretty quickly, though. Everything else went really well, except we ended up having trouble because of Red Hat Linux not locking files on remote shares correctly. That was a pain to code around... So, in general, if you're going to write a CF app, I try to keep all the files names lower case, and put most of the paths in Application.cfm to make it as cross platform as possible. I don't go too crazy about it, though... But you never know where you application going to end up--you could start licensing your code, or the company could be sold, or your admins might want to switch OS's. Jeff Polaski "The cow is of the bovine ilk; One end is moo, the other, milk." -- Ogden Nash -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 12:59 PM To: CF-Talk Subject: RE: end.cfm? why switch from windows to *nix :) jk, no flame war please!!! really, I use application.cfm interchangeably with Application.cfm honestly...i do use it either way. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -Original Message- From: Lincoln Milner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 3:53 PM To: CF-Talk Subject: RE: end.cfm? I think the case thing is more *nix specific, but every training material I've ever read on CF indicates that, regardless of platform, you should use Application.cfm and OnRequestEnd.cfm. So, even if you're in Windows, should you ever port your CF app to Unix, you're prepared. -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 3:40 PM To: CF-Talk Subject: RE: end.cfm? Does case count for application.cfm too? Or is that just for *nix systems? > -Original Message- > From: Lincoln Milner [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 11, 2003 3:42 PM > To: CF-Talk > Subject: RE: end.cfm? > > > Case counts, Tony. OnRequestEnd.cfm > > Shame on you...*grin* > > -lincoln > > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 11, 2003 3:26 PM > To: CF-Talk > Subject: RE: end.cfm? > > > onrequestend.cfm > > ...tony > > Tony Weeg > Senior Web Developer > UnCertified Advanced ColdFusion Developer > Information System Design > Navtrak, Inc. > Mobile workforce monitoring, mapping & reporting > www.navtrak.net > 410.548.2337 > > -Original Message- > From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 11, 2003 3:11 PM > To: CF-Talk > Subject: end.cfm? > > > What is the file that automatically loads when a page loads? (the one > I'm looking for is the opposite of application.cfm) > > > Scott Wilhelm > Computer Technician/Web Developer > St. Lawrence-Lewis BOCES > PO Box 231, Outer State Street > Canton, NY 13617 > > P. 315-386-4504 x 164 > F. 315-386-3395 > W. http://www.sllboces.org > E.[EMAIL PROTECTED] > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: end.cfm?
Yes, that's all true about managing Windows. I just waned to illustrate how you never really know where you code will end up, and it's good to keep in mind cross-platform issues. As far as keeping on Windows, at the time, the admins didn't want to go that way. The application was started on a Win2k box and the admins, who were hired later, were into Linux and Solaris. We couldn't really pay for Solaris on everything, so they got Linux. It really wasn't a good idea, though. The lead developer was off-site, stayed on Win2K and I had to continually trouble shoot for problems. Jeff Polaski "The cow is of the bovine ilk; One end is moo, the other, milk." -- Ogden Nash -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 9:35 AM To: CF-Talk Subject: RE: end.cfm? > At a place I worked at several years ago we switched > from Win2K to Linux because Linux was a lot easier to > administer remotely. All the production servers were > in a rack about 30 miles away and it was too much of > a pain for the admins to drive up there when the > servers would get wedged. (On Linux (and Unix in general) > you can easily administer a box over a telnet session. > Good luck doing that w/Windows...) I'll grant that it's easier to remotely manage Unices using telnet or ssh, but you can actually get where you want to go with Windows - it's easier/cheaper/quicker to set up remote administration on Windows than it is to switch OSs, I'd guess. There are graphical management tools, like Terminal Server; there are also command-line tools to perform nearly every administrative task, and you can use those with the built-in Win2K telnet server or with a third-party ssh server. I've been satisfied with VShell, from Van Dyke Software (http://www.vandyke.com/). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Payment Gateway
I've been using VeriSign for while now on different projects, and I've always been really happy with them. Their servers are really fast, which prevents a lot of problems with users double-clicking. Their reporting tools are good, and I've been happy with their support when I've had a problem (the trouble was with an account number between the processor and the bank getting screwed up). Also, once you take into account the per-transaction charge, they aren't that expensive. I don't work for them--I'm just a satisfied customer. If you search the archive you should find some pre-written code I posted a year or two ago. -Original Message- From: Hamm, Greg [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 12:55 PM To: CF-Talk Subject: Payment Gateway Anybody have recommendations regarding a payment gateway, that easily integrates with Coldfusion? Preferably (if possible) to have reoccurring billing. I've been looking at Payflow Pro from Verisign, 2checkout, and some others. Tips? Tricks? Pre-written code ;) Is Verisign worth the $$$? thanks Greg Hamm Partner Coreillia Development [EMAIL PROTECTED] http://www.coreillia.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
[OT] Flash Kid, CF in Forbes
I know it's OT, but it's nice to read about CF is getting mentioned in Forbes. http://forbes.com/forbes/2003/0317/039.html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: reverse engineering database structure
Can't you use SQL Server's Enterprise Manager to generate a diagram? "Diagrams" is the first entry under the db icon. It's been a while since I've used it, it'll do everything you want as far as a diagram goes. Enterprise Manager is usually installed with Query Analyser when you install the client tools. Jeff Polaski Webmaster Research & Graduate Studies University California, Irvine -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 3:32 PM To: CF-Talk Subject: reverse engineering database structure We're building a site for a company that uses a very complex inventory and accounting system that's based on SQL Server. We'd like to use only a few fields from the database maybe a dozen or so to display some items on the web. There are a lot of tables, a 100 or so. There aren't very many relationships; a table might have four foreign keys but only one realtionship. Lots of SPs and Views. There is no diagram. How should I go about understanding this structure? Remember, I only need a few fields. Reading the MCSE book, it looked as if maybe a trace would be the way to go. As always, all suggestions are appreciated. TIA, Doug Jordon __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: At my new job
I'm fan of UltraEdit. It has a "column mode" which can save a lot of typing. Sometime I use XEmacs, another great editor, but I don't use it as much as I use UltraEdit. I've used it to edit some pretty big files, but It loads the whole file into memory, though. It sounds like you have a very specific task in mind for your editor. Depending on what you want to do, you might be able to write a Sed|Awk|Perl|Python|etc... script to do what you want. While we're on the topic of text editing, I also Python to do a lot of repetitive text generation. For example I can feed a table, a list of columns, and their type and size into a Python script and get back an insert and update statements, formatted like I want and with trim() and isdefined() where I want it. It's so much easier than doing it all by hand for data-entry type apps. Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 8:00 AM To: CF-Talk Subject: At my new job Well i'm now settled in at my new job :) WHOO HOO!! After my boss tried to have me arrested for "HACKING" his servers and all that was fun my old boss was a threatster :) OK OK now to the point i need to find a win32 textbased editor that does not have to load the whole damn file into memory first. I remember it being on here before so i'm curious. Any help would be appreciated! Bill Wheatley Senior Database Developer Ediets.com Macromedia Certified Coldfusion Developer 954.360.9022 X159 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: At my new job
You want to take a look at sed and/or awk. awk is good at extracting, say, one column of text from a text file. sed (for Stream EDitor") is better for making changes to the text after it's been extracted by awk. For example, to print the first column of text in the file "t.txt" use: awk '{print $1}' t.txt. (note the single quotes). If you're on a windows box you can find them in the free Unix toolset at: http://www.cygwin.com/. There's a bunch of useful tools in Cygwin, so it's worth checking it out. There's a lot more than I can explain here, but if you get the chance take a look at "Unix Power Tools", an O'Reilly book. It gives you a lot of tricks that'll save a lot of time. For sed and awk, check out "sed & awk", also from O'Reilly. You know, If anyone wants, I can start posting tips and tricks that I've picked up... I'd love to hear about the time savers other people have come up with. Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 11:09 AM To: CF-Talk Subject: RE: At my new job I have a similar question. (I'm about to date myself now.) Many years ago I worked on a Wang VS system. There was a utility called CREATE which would allow you to take just about any data file or files and pull specific columns and rows from it to create a new file. For example, if I had 2 files (A and B) I could say: Start with file A, column 5 for a length of 4, but only for the first 10 rows. Add to the end of that row from file B, starting at position 19, length of 12, for the first 10 rows. Then add the characters "ABC" at the end of the row for 10 rows. Now start on row 11, etc. All of this was in a great utility that was easy to use. Is there anything out there today which would do a similar task? Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Jeffrey Polaski [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 12:50 PM To: CF-Talk Subject: FW: At my new job I'm fan of UltraEdit. It has a "column mode" which can save a lot of typing. Sometime I use XEmacs, another great editor, but I don't use it as much as I use UltraEdit. I've used it to edit some pretty big files, but It loads the whole file into memory, though. It sounds like you have a very specific task in mind for your editor. Depending on what you want to do, you might be able to write a Sed|Awk|Perl|Python|etc... script to do what you want. While we're on the topic of text editing, I also Python to do a lot of repetitive text generation. For example I can feed a table, a list of columns, and their type and size into a Python script and get back an insert and update statements, formatted like I want and with trim() and isdefined() where I want it. It's so much easier than doing it all by hand for data-entry type apps. Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 8:00 AM To: CF-Talk Subject: At my new job Well i'm now settled in at my new job :) WHOO HOO!! After my boss tried to have me arrested for "HACKING" his servers and all that was fun my old boss was a threatster :) OK OK now to the point i need to find a win32 textbased editor that does not have to load the whole damn file into memory first. I remember it being on here before so i'm curious. Any help would be appreciated! Bill Wheatley Senior Database Developer Ediets.com Macromedia Certified Coldfusion Developer 954.360.9022 X159 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Error: [Macromedia][SQLServer JDBC Driver]No more data available to read
I just upgraded my CF server from 6.0 to 6.1 and I keep getting this error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]No more data available to read. I don't get it all the time, just occasionally. It seems to happen with pages that have been sitting for awhile (like when I refresh a page after going to lunch) It's running on Win2k with JRUN also installed. During the CF upgrade I upgraded MDAC to 2.8. I didn't have any problems with CF 6.0. I have no idea what to do about it... Except to dump CF 6.1 and go back to CF 6.0. There doesn't seem to be much on Macromedia's site, or the net about this particular problem. Any one from the esteemed CF-Talk list have any ideas? Suggestions? Candy? Cigars? Cigarettes? Jeff Polaski RGS Webmaster "Eye halve a spelling chequer It came with my pea sea It plainly marques four my revue Miss steaks eye kin knot sea." -Sauce unknown [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Error: [Macromedia][SQLServer JDBC Driver]No more data availa ble to read
I tried replacing /lib/macromedia_drivers.jar and then I couldn't start CF MX ODBC Agent or Server. After a little searching, I tried removing the trace files in: C:\CFusionMX\db\slserver52\tracing\. Even still, the Agent and Server wouldn't start. I put the old macromedia_drivers.jar back, and they still wouldn't start. I just don't have the time right now to keep messing with it, so I ended up removing CFMX 6.1 and reinstalling CFMX 6.0. I know it happens--Macromedia can't control or predict everything, but I am disappointed with the trouble this upgrade caused. At least uninstalling it should have been a little easier. Thanks for the help, though (and Nathan, too). Jeff Polaski RGS Webmaster -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 8:23 AM To: CF-Talk Subject: RE: Error: [Macromedia][SQLServer JDBC Driver]No more data availa ble to read Hi Jeff, Make sure you apply the 3.1+ drivers from this article: http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_sqlserv er_c pu.htm ver_ cpu.htm> . If you apply the drivers and still see this issue post back! Christine Lawson Macromedia Technical Support -Original Message- From: Jeffrey Polaski [mailto:[EMAIL PROTECTED] Sent: Monday, February 09, 2004 7:41 PM To: CF-Talk Subject: Error: [Macromedia][SQLServer JDBC Driver]No more data available to read I just upgraded my CF server from 6.0 to 6.1 and I keep getting this error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]No more data available to read. I don't get it all the time, just occasionally. It seems to happen with pages that have been sitting for awhile (like when I refresh a page after going to lunch) It's running on Win2k with JRUN also installed. During the CF upgrade I upgraded MDAC to 2.8. I didn't have any problems with CF 6.0. I have no idea what to do about it... Except to dump CF 6.1 and go back to CF 6.0. There doesn't seem to be much on Macromedia's site, or the net about this particular problem. Any one from the esteemed CF-Talk list have any ideas? Suggestions? Candy? Cigars? Cigarettes? Jeff Polaski RGS Webmaster "Eye halve a spelling chequer It came with my pea sea It plainly marques four my revue Miss steaks eye kin knot sea." -Sauce unknown _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Windows 2000 image serving
Well, I think the problem is from all those images. It's a lot for a browser to manage. The whole page (w/out mouseover graphics) is less than 100k -- fairly good for the amount of graphics on that page, so I have trouble believing that the problem is with transmitting the files. Try making a screen shot of the page, stuffing it in a .htm and load that to see how long it takes to load one image. It might give you a better idea if, for some reason, you server is indeed having problems serving images. If you really want to keep the design (w/ so many small files), you could try merging some of the split-up images. You might end up with a larger overall page weight, but it could load faster. You might get the page smaller if you used gif's for the solid color graphics ( the color blocks: "Dixon", "Prang", etc...). Just use 8 or fewer colors for your .gif. You might also try loading the images from a different server, that just serves graphics. Also, do a script include for the JavaScript, and see if you can make the maps external files, too. It'll let the browser download those files in parallel to the html, and will speed loading up a little bit. All-in-all, I think you'll get the biggest load-time gains from reducing the number of images on a page. Jeff Polaski "The cow is of the bovine ilk; One end is moo, the other, milk." -- Ogden Nash -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 3:48 PM To: CF-Talk Subject: RE: Windows 2000 image serving It's not the server speed at all. It's the speed of the client computer as far as I can tell. The table you have assembling the images is quite complicated, and the images won't render until the table is completely layed-out. Hence, you have the browser working overtime. Check the processor level in the task manager as you load the page. - j -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 6:34 PM To: CF-Talk Subject: OT: Windows 2000 image serving I have a windows 2000 server that is serving up images very slowly, at first I thought it was because our old site has graphics that aren't optimized very well, so now I have a new site with highly optimized graphics and it downloads slower than a tart rolling up hill on the fourth of july. Anyone have any recomendations as to why a server with plenty of processor and memory and is on a digital T-1 line would serve up images slow? The webpage seems to execute fast just the images, you can check out our old site here http://www.dixonusa.com , this is a fairly new server, wasn't upgraded, everything factory installed, also switched out network cards too in case that was the problem. bob everland __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Future of Coldfusion
A language that is productive early in the learning stage it is said to have a low "hacktivation energy" (well, at least in the Perl community). I thought Python did a really good job of supporting that progression... easy to pick up and write little procedural scripts. As they grew, it's easy to switch them to be object-oriented. There is even some neat functional programming support in python that, as I get more familiar with it, use more and more. Now that I think about it, scheme is kind of like that, too. Well, at least for simple things... I really haven't written anything too complex in Scheme, but I've been working through a couple of scheme books to develop myself as a programmer. I agree about there being more of a Junior/Senior programmer distinction. It used to be that if you could just write simple HTML and JavaScript you were a "programmer". But then, at that time, the web was new and HTML was a mystery to a lot of people. If you had a degree from a junior college and could say the word "web" you were "hot" and getting paid pretty well. Post dot-bomb it's different... Now you really need a lot more skill to pull off most "serious" web development. Just my $0.02... Jeff Polaski "The cow is of the bovine ilk; One end is moo, the other, milk." -- Ogden Nash -Original Message- From: Cravens, Billy [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 10:53 AM To: CF-Talk Subject: RE: Future of Coldfusion I agree. ColdFusion can do pretty much anything that other languages can. The big difference is the overhead on getting started. Most languages have a steep learning curve to build anything other than a "Hello world" app - but with CF, you could build a decent app within an hour of picking up a book for the first time. (Though this is the biggest piece of ammunition for CF-antagonists - since there's a lot of code being written out there because developer don't continue the progression - but everything has a cost) --- Billy Cravens -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 12:10 PM To: CF-Talk Subject: RE: Future of Coldfusion Billy, One thing I will say that I'm seeing is my natural progression into the CF language. The code I'm writing these days compared to my earlier days is drastically different... It's /nice/ to see a language that supports that natural progression, from to something complicated like CFCs (CFCs 'aren't' complicated as you could use it in it's pure simple form, but ... you can make some pretty complicated stuff with it)... and it almost seems to me that I'll probably progress into java sometime into the future. I'm sure that I will since there's a whole slew of java libraries out there that are handy and perhaps one extra thing that CF didn't have, but does now thanks to the re-write. Anyway, back to what I was saying... I think it's pretty rare to find a language that supports that progression, don't you? I think CFMX fits that gap pretty nicely. ~Todd On Fri, 14 Jun 2002, Cravens, Billy wrote: > Gotta have the monthly "future of CF" or "CF is dead" posting every > month.. it's required :-) > > I see CF becoming more in line with other programming languages. I > think there'll be some confusion and turnover as a result. (CFC's - > objects, methods, and inheritance - oh my! Is a great example) You'll > need to be more of a "programmer" than a "scripter", and I think you'll > see more delineation between junior/senior programmers. > > So I think you'll see more enterprise and industry acceptance, with a > reduction in "novice" development (where you only need an access > database, cfinsert, and cfform, and bam, an app in an hour) as the cost. > > --- > Billy Cravens > > > -Original Message- > From: Phoeun Pha [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 14, 2002 11:10 AM > To: CF-Talk > Subject: Future of Coldfusion > > Hey guys, where do you think coldfusion is headed? I mean, when 4.5 > came > out, it was like when AMD came out with their cheap and competitive > Athlons! > > But all of that excitement kind of died down.well, at least for me > anyways. But how about you guys? Maybe the Macromedia merge had > something > to do with it. > > What do you think? > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Apps You've Built
There are a bunch of apps that I would write differently, too. If there weren't any, *then* there would be a *big* problem. It's important that you keep learning and applying what you learn to how you do your job. That's one of the reasons programming is considered a profession and not a craft (although certainly there are a lot of craft-like aspects to programming). It also goes beyond just technical skill. I put a lot more efforts into communication. Things like writing better email, better comments, etc... Lately I've been learning Scheme*, which is a very different language from CF, but it's changed how I think about programming, and, as a result, how I program. Now, I'm much more inclined to think about how I want to represent the problem, and make a conscious decision about how I want to think about the problem domain. *I got through The Little Schemer, now I'm working on Scheme and the Art of Programming, next is "Structure and Interpretation of Computer Programming". SICP is considered by many to be the best book on programming ever written. The full text is available on line: http://www-mitpress.mit.edu/sicp/. Keep reading, and keep learning! "Twice five syllables, Plus seven, can't say much, but ... That's haiku for you." Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 10:31 AM To: CF-Talk Subject: Coldfusion Apps You've Built Hey guys, I'm 2 years in the CF game, and so far I've built a timesheet program, and events administration, countless shopping carts, pharmacy prescription app. But looking back at my code, it was verry bddd! Like I could think of a hundred places to do things differently, either form CF or from the database design. Obviously it was because of lack of experience Was there anything that you guys have built for past clients that you now know could have been coded better? __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Apps You've Built
I think this is it: http://www.terrible.cx/tao/book/1 Good link! Jeff Polaski "The ant has made himself illustrious Through constant industry industrious. So what? Would you be calm and placid If you were full of formic acid?" -- Ogden Nash -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 12:10 PM To: CF-Talk Subject: RE: Coldfusion Apps You've Built This thread reminds me of "The Tao of Programming"... for those of you who have been around long enough to have seen it.. Anyone know a link to it? While it's meant to be humerous, there are some points to ponder in there that relate to this conversation... My thoughts... Shawn Grover -----Original Message- From: Jeffrey Polaski [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 12:37 PM To: CF-Talk Subject: RE: Coldfusion Apps You've Built There are a bunch of apps that I would write differently, too. If there weren't any, *then* there would be a *big* problem. It's important that you keep learning and applying what you learn to how you do your job. That's one of the reasons programming is considered a profession and not a craft (although certainly there are a lot of craft-like aspects to programming). It also goes beyond just technical skill. I put a lot more efforts into communication. Things like writing better email, better comments, etc... Lately I've been learning Scheme*, which is a very different language from CF, but it's changed how I think about programming, and, as a result, how I program. Now, I'm much more inclined to think about how I want to represent the problem, and make a conscious decision about how I want to think about the problem domain. *I got through The Little Schemer, now I'm working on Scheme and the Art of Programming, next is "Structure and Interpretation of Computer Programming". SICP is considered by many to be the best book on programming ever written. The full text is available on line: http://www-mitpress.mit.edu/sicp/. Keep reading, and keep learning! "Twice five syllables, Plus seven, can't say much, but ... That's haiku for you." Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 10:31 AM To: CF-Talk Subject: Coldfusion Apps You've Built Hey guys, I'm 2 years in the CF game, and so far I've built a timesheet program, and events administration, countless shopping carts, pharmacy prescription app. But looking back at my code, it was verry bddd! Like I could think of a hundred places to do things differently, either form CF or from the database design. Obviously it was because of lack of experience Was there anything that you guys have built for past clients that you now know could have been coded better? __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamic variable name
I think you want to use SetVariable(name , value). You could also use evaluate(), but I think it would be more of a pain. Just a word of advice, so please don't take it the wrong way, but you should be very careful of using evaluate() or setvariable(). There is almost always a simpler, faster way to do what you want. (I think it's been two or more years since I've needed to use either.) "Twice five syllables, Plus seven, can't say much, but ... That's haiku for you." Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 3:59 PM To: CF-Talk Subject: dynamic variable name My brain is fried. How do I do this? So that I end up with variables name dynamicName_1 through dynamicName_10? Shawn McKee __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help! Verity Error: "Collection failed to open" and "VdkCollectio nSubmit failed Error Code: -23"
I need help with Verity. This has become a big issue and I'm at wits end... Any help will be appreciated. The problem is that Verity won't work. I can't index collections on either of our two production servers, however, Verity works fine on our (one) development server. As far as I can tell, it's running the exact same version of CF. I get the same errors on both servers. It seems to be a permissions error, but I've opened up the permissions as far as I can on the CFUSION directory and the directories being indexed (and everything below them). I've done everything I can think of. I've opened up the permissions as wide as I can, I've purged/deleted/recreated all of the collections. I've gone in and physically deleted all of the files in the collection. I've even re-installed CF. Is there some secret directory somewhere that I need to give permissions to so Verity will work? Also, I get the same "Collection failed to open" error for collections that are copied over from another server and then mapped, so there is no way to actually use Verity on our production CF servers. All of the servers are exactly the same, except for serial number: Server Information Server Product ColdFusion Server Version 4, 5, 1, SP2 Edition Professional Serial Number CF45PNT-xx Operating System Windows NT OS Version 4.0, Service Pack 6 OS Build Number 1381 Depending on how I run Verity, I get one of the following error messages: 1.) From CF Administrator, if I try to optimize a collection: "Error occurred in tag CFINDEX Collection failed to open: grad_collection" 2.) If I run the following code: SELECT ncd_UC_case_no, ncd_dept, ncd_school, ncd_title, ncd_ncd FROM mktable_ncds_only I get: "Error occurred in tag CFINDEX Internal Error: Key Insert, Type=File, VdkCollectionSubmit failed Error Code: -23" Again, any help would be most appreciated. Jeff Polaski Webmaster Research & Graduate Studies University California, Irvine ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help! Verity Error: "Collection failed to open" and "VdkColle ctio nSubmit failed Error Code: -23"
Thanks, Dave, it helped! I've looked at the registry and the path to the collection wasn't correct. I changed it and now I can optimize and purge the collection from cfadministrator. However, I'm still getting an error. When I use I get the following error: "Error occurred in tag CFINDEX Internal Error: Purge failed Error Code: -23" If I run cfindex to do an update, I get: "Internal Error: Key Insert, Type=File, VdkCollectionSubmit failed Error Code: -23" Any other suggestions? Jeff Polaski Webmaster Research & Graduate Studies University California, Irvine -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 3:35 PM To: CF-Talk Subject: RE: Help! Verity Error: "Collection failed to open" and "VdkCollectio nSubmit failed Error Code: -23" Jeffrey, A stab in the dark, but... Check the registry to ensure that the location of the collection is correct. You'll find this info in the HKLM\Software\Allaire\Coldfusion\Currentversion\collections\collectionname branch. If there's a problem here, then my guess is perhaps the cfregistry tag has been disabled on your production servers, despite being enabled for the CF Administrator folder (this is default setting). HTH, Dave > -Original Message- > From: Jeffrey Polaski [mailto:[EMAIL PROTECTED]] > Sent: 21 November 2001 20:17 > To: CF-Talk > Subject: Help! Verity Error: "Collection failed to open" and > "VdkCollectio nSubmit failed Error Code: -23" > > > I need help with Verity. This has become a big issue and I'm at > wits end... > Any help will be appreciated. > > The problem is that Verity won't work. I can't index collections on either > of our two production servers, however, Verity works fine on our (one) > development server. As far as I can tell, it's running the exact same > version of CF. I get the same errors on both servers. It seems to be a > permissions error, but I've opened up the permissions as far as I > can on the > CFUSION directory and the directories being indexed (and everything below > them). > > I've done everything I can think of. I've opened up the > permissions as wide > as I can, I've purged/deleted/recreated all of the collections. > I've gone in > and physically deleted all of the files in the collection. I've even > re-installed CF. Is there some secret directory somewhere that I need to > give permissions to so Verity will work? > > Also, I get the same "Collection failed to open" error for > collections that > are copied over from another server and then mapped, so there is no way to > actually use Verity on our production CF servers. > > All of the servers are exactly the same, except for serial number: > Server Information > Server Product ColdFusion Server > Version 4, 5, 1, SP2 > Edition Professional > Serial Number CF45PNT-xx > Operating System Windows NT > OS Version 4.0, Service Pack 6 > OS Build Number 1381 > > Depending on how I run Verity, I get one of the following error messages: > 1.) From CF Administrator, if I try to optimize a collection: > "Error occurred in tag CFINDEX > > Collection failed to open: grad_collection" > > > 2.) If I run the following code: > > SELECT ncd_UC_case_no, ncd_dept, ncd_school, ncd_title, > ncd_ncd > FROM mktable_ncds_only > > > ACTION="UPDATE" > TYPE="CUSTOM" > TITLE="ncd_title" > KEY="ncd_UC_case_no" > BODY="ncd_UC_case_no, ncd_dept, ncd_school, ncd_title, > ncd_ncd" > QUERY="all_mktable_ncds"> > I get: > "Error occurred in tag CFINDEX > > Internal Error: Key Insert, Type=File, VdkCollectionSubmit failed > Error Code: -23" > > > Again, any help would be most appreciated. > > > >Jeff Polaski >Webmaster >Research & Graduate Studies >University California, Irvine > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help! Verity Error: "Collection failed to open" and "VdkColle ctio nSubmit failed Error Code: -23" -- SOLVED
With some help from Dhemke, on the MM ColdFusion forums, this has been solved. For some reason, if I created the collections in the default directory (D:\CFUSION\Verity\Collections) all of the files in the collection would be created O.K. and everything would look like it was right. But the collections themselves would not open for a cfindex tag. They were useless. The solution was 1.) create a new directory at C:\verity. 2.) delete all of the old collections in D:\CFUSION\Verity\Collections. 3.) make a new set of collections using the new path c:\verity. The collections all index, purge, etc... just fine now. This issue was especially odd, because there was plenty of available space on either drive, on either production server. Permission were opened up, the registry was pointing to the correct path. I tried deleting and re-creating the collections, going into the directory and physically deleting the files, even re-installing CF. All to no avail. Verity would even work on the development server--it just wouldn't work on either production server. So, now that it's been fixed, I'd like to offer up this summary as a way of saying thanks to Dave Wilson and (again) to Dhemke. Jeff Polaski Webmaster Research & Graduate Studies University California, Irvine -Original Message- From: Jeffrey Polaski [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 12:17 PM To: CF-Talk Subject: Help! Verity Error: "Collection failed to open" and "VdkCollectio nSubmit failed Error Code: -23" I need help with Verity. This has become a big issue and I'm at wits end... Any help will be appreciated. The problem is that Verity won't work. I can't index collections on either of our two production servers, however, Verity works fine on our (one) development server. As far as I can tell, it's running the exact same version of CF. I get the same errors on both servers. It seems to be a permissions error, but I've opened up the permissions as far as I can on the CFUSION directory and the directories being indexed (and everything below them). I've done everything I can think of. I've opened up the permissions as wide as I can, I've purged/deleted/recreated all of the collections. I've gone in and physically deleted all of the files in the collection. I've even re-installed CF. Is there some secret directory somewhere that I need to give permissions to so Verity will work? Also, I get the same "Collection failed to open" error for collections that are copied over from another server and then mapped, so there is no way to actually use Verity on our production CF servers. All of the servers are exactly the same, except for serial number: Server Information Server Product ColdFusion Server Version 4, 5, 1, SP2 Edition Professional Serial Number CF45PNT-xx Operating System Windows NT OS Version 4.0, Service Pack 6 OS Build Number 1381 Depending on how I run Verity, I get one of the following error messages: 1.) From CF Administrator, if I try to optimize a collection: "Error occurred in tag CFINDEX Collection failed to open: grad_collection" 2.) If I run the following code: SELECT ncd_UC_case_no, ncd_dept, ncd_school, ncd_title, ncd_ncd FROM mktable_ncds_only I get: "Error occurred in tag CFINDEX Internal Error: Key Insert, Type=File, VdkCollectionSubmit failed Error Code: -23" Again, any help would be most appreciated. Jeff Polaski Webmaster Research & Graduate Studies University California, Irvine ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and credit card transactions
I've implemented a couple of credit card payment systems, using a few different payment processing services. Of the payment processing services I've used, the only two worth anything were Cybercash and Verisign. And Verisign was so much better than CyC it wasn't even funny. At least as of a year ago, Verisign has better reporting, better rates, they were much more stable (CyC went down something like 20 time over the Christmas season last year. Never for very long, but enough to cause CF to time-out processing the page). Not that I'm trying to put down CyC, it could have been other issues, but when we switched to Verisign a lot of problems went away. One of the biggest was that Verisign's transaction times were consistently under five seconds. Cyc usually took 45 seconds, but sometime would go up to more than two minutes. That's a lot of time for a user to click on the submit button again. That's a lot of time for your users to get pissed off, go to another site, or send an email to tech support. Some pointers on implementing the system: People get really cranky when money is involved, so you need to put a lot of effort into error handling. Keep track of everything... Assume that the processing, as it progresses down the page, can fail for any reason. Use database transactions. cftransaction is useful, too, but it is too aggressive and can cause a lot of problems with a slow CC provider. You can avoid a lot of trouble by using a fast processing service. This is what I settled on: for each transaction, make an timestamp entry to the database for every "stage" of processing. As control progresses down the page: 1.) As soon as they hit the top of the form processing page check to see if there is a "started" status code in the db. That way, if there is already a "started" in the db, you know that the user reloaded and is hitting the form processing page again. Then you can halt processing and show the user a message letting them know they might have been double charged. 2.) Enter a status code of "started" and all of the CC and user info into the db. That way if something fails as the transaction is processed you have a record. And it _will_ fail at some point. The network guys might block port 443, used by SSL, or a router on the way to a bank might suddenly start dropping packets. Anything can, and will, at some point, fail. With all of the CC info in the db, if you need to, you can give a refund, or process the transaction by hand. 3.) Run the tag to process the transaction. 4.) Save all of the returned codes into the db, and change the status to "success" if it completed successfully. You should also be aware that there might be other issues to consider in choosing your payment service, like your OS, your bank, your accounting department. For example, accounting will have to reconcile all of the transactions that go through you processing service with their bank, so reporting becomes important. Anyway, I hope this helps. Good luck! Jeff Polaski Webmaster Research & Graduate Studies University California, Irvine -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 5:15 PM To: CF-Talk Subject: CF and credit card transactions Hi Everyone, I am looking for some insight for processing credit cards with Cold Fusion. I am aware of a few custom tags, but what kind of variety is offered in terms of companies and sites to do the processing. I am not really a fan of going from my site, to another site then back to my site as you do with 2CheckOut.. Open for discussion and ideas. Thanks, Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Credit Card Encryption
You can also remove the CC numbers from the database. We don't process a huge amount of CC's, so we just run some SQL to set all but the last four digits to 'x' after having copied the good cc numbers to a floppy. The floppies go to a locked managers office. That way the numbers aren't even on the network. We don't do it every day, but once a week or so--enough that there aren't very many CC number sitting in the db. One suggestion: write a stored procedure that writes the CC numbers out to disk, then run GnuPG on the file, and then set all but the last four CC digits to 'x'. You could do it with a chron job, or use a scheduled task in CF. I think that would work for you. One note: cfencrypt(), AFAIK, has been cracked. I'm not sure if that's true of recent versions of CF, though. Jeff Polaski Webmaster Research & Graduate Studies University California, Irvine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:43 AM To: CF-Talk Subject: Credit Card Encryption Does anyone have any insight on encrypting data into a Table? A client is asking about storing CC numbers and I want to see what level of protection we can provide. TIA! Hatton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Credit Card Encryption
My mistake--I was talking about CF's file encryption for templates and such. I don't know about cfcrypt(). Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 12:37 PM To: CF-Talk Subject: Re: Credit Card Encryption Are you sure about the cfencrypt() function? I don't think it's "crackable", though any encryption is if you throw enough keys at it. Rather, the encryption for encrypting files (like encrypted custom tags) has been cracked for a long time (since it requires no user selectable key). ----- Original Message - From: "Jeffrey Polaski" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 04, 2001 2:29 PM Subject: RE: Credit Card Encryption > You can also remove the CC numbers from the database. We don't process a > huge amount of CC's, so we just run some SQL to set all but the last four > digits to 'x' after having copied the good cc numbers to a floppy. The > floppies go to a locked managers office. That way the numbers aren't even > on the network. We don't do it every day, but once a week or so--enough that > there aren't very many CC number sitting in the db. > > One suggestion: write a stored procedure that writes the CC numbers out to > disk, then run GnuPG on the file, and then set all but the last four CC > digits to 'x'. You could do it with a chron job, or use a scheduled task in > CF. I think that would work for you. > > One note: cfencrypt(), AFAIK, has been cracked. I'm not sure if that's true > of recent versions of CF, though. > > >Jeff Polaski >Webmaster >Research & Graduate Studies >University California, Irvine > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 29, 2001 9:43 AM > To: CF-Talk > Subject: Credit Card Encryption > > > Does anyone have any insight on encrypting data into a Table? A client is > asking about storing CC numbers and I want to see what level of protection > we can provide. > > TIA! > > Hatton > > ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Cybercash
Verisign is the way you want to go... If you're doing any credit card processing there's some good (IMHO) suggestions in one of my previous messages: "RE: CF and credit card transactions". When I wrote it I didn't know Verisign bought CyberCash... but it's a good thing. Verisign is much better... It's good to see the better solution win. Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 4:18 PM To: CF-Talk Subject: CF and Cybercash Does anyone know where to find the cybercash tag.. I tried the link from the dev exchange and it takes me to verisign, but the link is dead.. Any ideas? Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What the best database structure to do this?
I'd recommend going for the normalized tables first. You can optimize it, if there is a need, later on. You'd be better off sticking with a conservative and _correct_ database design with no funny stuff (i.e. denormalization). Remember, it's important to make sure you have a good design for your database. Everything else flows out from that, and it's a real pain to have to go back and re-code. I've had (by far) better luck starting out with a properly normalized schema and then denormailzing it, but only if I really need to. If you are worried about performance, you'd be better off making sure you have a faster (separate) machine to run the db on. With a normalized table, you won't need to worry about junk data. And it'll be easier to maintain your database after you leave. When the marketing people come asking for reports, you'll be able to provide them more effectively. And when you need to add more features to your system, you'll be able to without going through huge amounts of unnecessary pain. Just my $0.02... Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 8:44 AM To: CF-Talk Subject: RE: What the best database structure to do this? you should be able to cache the query for stuff like that, so as long as you do, you shouldn't have to worry about it. -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 7:37 PM To: CF-Talk Subject: What the best database structure to do this? I've been wrestling with this for the last half hour and I can not decide the best way to structure the database for a function I a programming related to a shopping cart. It get's kind of crazy... Each item can have a variable number of sizes. Each size can have a variable upcharge attached to it. Each item can have a variables number of price levels for different types of customers with variable quantity breaks per price level. All of the above is done. I am now trying to add in the sizes so that I can set variable size/quantity discounts at different price levels. If I totally normalize the new size table, given 500 products, 4 quantity breaks, 4 sizes and 2 pricing levels, I end up with 16000 rows, albeit in a very nicely indexable table. That's an extreme example for the probable use of the software, but I want to make sure it doesn't break under load either. I know 16000 rows is not a big deal for SQL Server, but since the data in the table will be used for displaying the item, I can see it getting hit pretty hard. Should I be worried about this table, or does anyone have any tips? RDBMS == SQL Server jon ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do I handle Large Record Sets from the DB? (o8i)
You could use an Oracle stored procedure to write out the results to a file/files on the web server. Then you are just serving files from a web server--no big deal. You might need to be creative in how you re-assemble the files, or you might need to map a drive so the web server and your db server can share a directory. If the result sets are persistent for all web users, I think a file-caching strategy is a good way to go. Ultimately it'll depend on just how often your data changes, how much data you're grabbing, and how up to date it needs to be, etc... If you have very expensive queries you can save your DB server from a severe thrashing, and keep wait times for your users to a minimum. If you do the cached files trick, you might want to cook up a mechanism to flag old data as dirty whenever there are updates, and schedule a cron job/Scheduled Task to re-publish all of the "semi-dynamic" data from your queries. Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED]] Sent: Friday, December 21, 2001 4:35 PM To: CF-Talk Subject: How do I handle Large Record Sets from the DB? (o8i) All, This is what our environment looks like: Microsoft IIS5 on Windows2000 ColdFusion (4.5.1 SP2) Enterprise Edition Oracle8i (8.1.7) Utilizing the Oracle Native Driver. The Task at hand: Users will be quering the database and in some cases receiving back large recordsets. These large recordsets could be from 0 to 3,000 maybe 4,000. If the recordset exceeds 20 records, it will be broken up into pages of 20 (20 results per page) Does anyone have any thoughts about the best way to go about this? Here are some possible solutions that I have thought of: Solution 1: I could use to query the database and cache the query in server memory. Possible problems with this solution: The CF Server can only cache 100 resultsets at one time. After that, the oldest ones get bumped out of the CF Server's memory. If the result set gets bumped out of memory, then the database has to be queried again and the data has to go across the network wire again. Solution 2: Use to call an Oracle Procedure. The Procedure would return 20 records at a time. Have the procedure store the queried result set into a temp table for a period of time. Send 20 records to the CF Server. Provide the CF Server a unique ID to identify the result set when the CF Server request the next 20 records. The Primary key of the result set table would be the combination of a ResultSetID and RowNumber (rownum column from the original result set in Oracle8i). Possible problems to this solution: During the initial query, I have to wait on the database to write the results to the temp table before sending the first 20 results to the CF Server. The first 20 record talk longer to get. The temp table grows unless we periodically remove the old record sets. I do not believe that I can use Oracle Temporary Tables because the CF Server acts like a single user with a single session on the Oracle Database. The result sets are persistant for all Web Users. When the session closes the data in the temporary tables is removed. The temporary tables are truncated when the session is closed. What should I do? MMm. Thanks for taking the time to read this and for responding. Sincerely, Troy (tds) -- Troy Simpson | North Carolina State University NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 It is better to be hated for what you are than to be loved for what you are not. -- Andre Gide __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Server
One other thing to look for is typos in cf tags. For example: mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 12:36 PM To: CF-Talk Subject: Coldfusion Server I am experiencing 100% CPU usage on my cold fusion server. One reason suggested to me was that large files may be getting uploaded on my server. Can anybody tell me what is considered a large file that would be capable of timing out my server? Any other suggestions about this problem would help a lot. Thanks, Chad McCue Cold Fusion Web Developer Advanced Media Productions 508-647-5151 Ext. 16 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JET
I know this is getting OT, but I am really curious if anyone has been using Interbase or Firebird... a while ago I heard really good things about Firebird/Interbase. What have been your experiences with 'em, good or bad? If you want, email me off-list, at [EMAIL PROTECTED] Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: Mike Alberts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:40 AM To: CF-Talk Subject: Re: JET I think the article you mention gives the answer to 'what's the view in the cf community': "The Access ODBC Driver and Microsoft OLE DB Provider for Microsoft Jet are not intended to be used with high-stress, high-concurrency, 24x7 server applications, such as web, commerce, transactional, messaging servers, and so on." Why use Access at all? If a commercial DBMS isn't a viable solution, why not use MySQL or Postgre or Interbase (or it's open source cousin, Firebird). My .02 >Date: Tue, 29 Jan 2002 15:22:28 +1030 >From: "Parker, Kevin" <[EMAIL PROTECTED]> >Subject: JET >Message-ID: > ><[EMAIL PROTECTED]>.au > >This was drawn to my attention today (extract below) and I >traditionally >use >Access via an ODBC connection for small apps. The full article can be > >found >at http://support.microsoft.com/default.aspx?scid=kb;EN-US;q222135 >*** >When running Microsoft Jet in an IIS environment, it is recommended >that >you use the native Jet OLE DB Provider in place of the Microsoft >Access >ODBC driver. The Microsoft Access ODBC driver (Jet ODBC driver) >can have >stability issues due to the version of Visual Basic for >Applications that >is invoked because the version is not thread safe. As a result, when >multiple concurrent users make requests of a Microsoft Access database, >unpredictable results may occur. The native Jet OLE DB Provider includes >fixes and enhancements for stability, performance, and thread pooling >(including calling a thread-safe version of Visual >Basic for >Applications). >What's the view in the CF Community - should I switch strategies here -> is >this a problem using CF? _ Send and receive Hotmail on your mobile device: http://mobile.msn.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Odd problem - "helper applications" only run from C:, not D:.
I'm sending this quick note out to (hopefully) prevent some frustration for a few people... I've had almost the exact same problem twice... On our CF servers "helper applications" only run from C:, not D:. For example, I just installed Java so we can use Verisign to do our credit card processing. (They have other tools, but there is a custom tag for Java). So I installed Java on the D: drive on the *development* server, along with all the web content and web apps, and everything works fine. However, if I install Java on the D: drive on our *production* servers, Java will not run from CF. If I remove Java from production's D: and then install it on C:, everything runs fine. I was getting the following error: "The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists." even though the path was correct. When I reinstalled Java, I just changed the drive letter in the path, nothing else. Again, everything worked fine, then. A few months ago I had a similar problem with Verity. The collections were on D: on development and worked fine. But on production, they would not work from the D: drive. If I moved the collections to the C: drive, everything would work fine. So, next time you are having a really odd problem that works on one machine, but not another, and involves CF using another application, try switching disks. It might work. Hope it helps someone! P.S. our hardware: Development server: 1 - Intel 333 MHz, Win NT 4.0, SP6, CF Server 4.5.1 running on a no-name clone. Production server: 1 - Intel 333 MHz, Win NT 4.0, SP6, CF Server 4.5.1 1 - Intel 1.0 GHz, Win NT 4.0, SP6, CF Server 4.5.1 Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access -> MS SQL script?
There are a couple of differences in how access and SQL Server deal with some of their datatypes. For example, the date format for SQL Server is '-mm-dd', but the date format for Access is (IIRC) 'mm/dd/yy'. I remember having some problems with moving from Access memo fields to SQL Server text fields, too. I needed to use a stored proc to do large text inserts on SQL Server. The text was getting truncated at 8k if I just went through ODBC, w/o using a stored procedure. With the SP, you can insert multiple Gigs of text. If you'd like the SP's I used, let me know. Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: Louis Klepner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 6:58 AM To: CF-Talk Subject: Access -> MS SQL script? Hello Fellow CF'ers, I was wondering if anyone knew of a script that would analyze a Access Database and replicate the structure in SQL? Something which loops through the tables, checks data types, and creates a MS SQL version of the database- Thanks, Lou Klepner __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best way to do this query
I'd suggest using a stored procedure with a transaction and do it in the database. CF is rather aggressive in how it locks the db, and this can lead to performance problems if the db gets a lot of use. SP's give you a performance boost, and aren't that hard to do, especially once you have the SQL written. And rather than do your increment in a function call, you could do it in SQL:select buildcount + 1 from bbstat where id = #id# and buildtime= #buildtime# Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 12:03 PM To: CF-Talk Subject: Best way to do this query Sorry to ask but I have a dead brain right now. (I hate it when I feel dumb.) X¿x ~~~ I need to check the database to see if a record is there. If it's there then increment it by one, otherwise add the record. If two people hit it at the right time I may get two records. What should I do to prevent this? This is what the code would look like. select * from bbstat where id = #id# and buildtime = #buildtime# update bbstat set buildcount=#IncrementValue(buildcount)# where id=#id# insert into bbstat (id,buildcount) values (#id#,1) Phillip Broussard Tracker Marine Group 417-873-5957 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFX_CyberCash
Just a word of advice--I've had a lot of problems with CyberCash when their servers got heavily loaded. They went down a lot around Christmas time. This was before they were bought by Verisign. After I switched to PayFlowPro, also owned by Verisign, it worked like a champ! So if you are signing up for a new account, I'd suggest giving PayFlowPro a try. There were a lot of benefits, but the main one was that the response times were a lot faster--around five seconds for PayFlowPro, vs. 30--45 seconds for CyberCash. Also, if you are implementing a new credit card system, you might want to look around in the cf-talk archives for a previous post where I wrote a fair amount about implementing a new CC system. Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -Original Message- From: Shawnea Carter [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 12:28 PM To: CF-Talk Subject: CFX_CyberCash It looks like Verisign updated the tag on Tuesday - however now when you click the link to download it - you get an error. Did anyone happen to get the new tag? With the migration to Payflow, all of my customers are timing out. Shawnea __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Datatypes
Access text fields can be varchar, nvarchar, or text. If you are not going to put more than 8k (IIRC) the varchar is the way to go. If you are going to put more than 8k in the field, then text is the way you want to go. It'll take multiple gigs of data, but they are more difficult to use than a memo field in Access. For example, you can't do a select on a text field, and you will need to use some built in functions to do an insert or update on a text field. In general, it's a lot easier if you wrap text field access in a stored procedure. Here's a cleaned-up copy of a text insert sp I wrote a little while ago IF EXISTS (select * from sysobjects where id = object_id('') and sysstat & 0xf = 4) DROP PROCEDURE GO CREATE PROCEDURE @ text, @ int AS /*** *** ** Desc : This procedure is used to update the text field in **It's a real buzz-kill for the users to have their data truncated, or have CF **(sometimes) error out and loose all of the data. Instead of using a **regular insert statement SQL Server needs to use WRITETEXT to manage the text **pointers and junk. ** ** Notes: It's possible for the pointer returned from TEXTPTR(rec_comments) to be **invalid by the time the write occurs, especially if the database is **getting hit hard, so it needs to be wrapped in a transaction to lock the db. ** ** : This script based on the one given in "Inside SQL Server 7.0" by Ron Soukup & Karen Delany ** ** Inputs : @ is text to be inserted. **@ is the @_id value to match for the insert/update ** ** Outputs : None ** ** Created By : Jeff Polaski ** Date : 01/18/01 ** ** Change Hist ** ** Date: ** Developer : ** Description : ** ***/ --- -- Set up environment, declare variables, etc... SET NOCOUNT ON DECLARE @ErrNo int ,@ErrMsgvarchar(255) ,@RetValint ,@ptrvalbinary(16) --Declare a binary object to use as a pointer-to-text --- -- Main body of the stored procedure BEGIN TRANSACTION SELECT @ptrval = TEXTPTR(rec_comments) FROM ender WHERE _id = @ IF ( @@ERROR <> 0 ) BEGIN GOTO major_error_block END -- WRITETEXT will overwrite the value in rec_comments, so there is no need for an update. -- The pointer either will be NULL or it will not be NULL, so every case should be covered in this block IF ( @ptrval IS NOT NULL ) BEGIN WRITETEXT ender.rec_comments @ptrval @ IF ( @@ERROR = 0 ) BEGIN COMMIT TRANSACTION GOTO successfull_completion END ELSE BEGIN ROLLBACK TRANSACTION GOTO major_error_block END END ELSE BEGIN ROLLBACK TRANSACTION SELECT @ErrNo = 10002 SELECT @ErrMsg = 'Writetext failed because Textpointer @ptrval is null (_id not in dbb?)' GOTO minor_error_block END -- Just in case, if control gets to here we roll the transaction back ROLLBACK TRANSACTION SELECT @ErrNo = 10003 SELECT @ErrMsg = 'The text insert failed for an unknown reason' GOTO minor_error_block --- -- Deal with errors minor_error_block: IF ( @ErrNo <> 0 ) BEGIN SELECT @ErrNo = 50501, @ErrMsg = 'Failed to retrieve (SQL Errno: ' + LTRIM(STR( @RetVal )) + ')' RAISERROR @ErrNo @ErrMsg RETURN (1) END major_error_block: IF (@@ERROR <> 0) BEGIN SELECT @ErrMsg = 'Failed to retrieve (SQL Errno: ' + LTRIM(STR( @RetVal )) + ')' RAISERROR @@ERROR @ErrMsg RETURN (@@ERROR) END --- -- If we get here, the stored procedure ran successfully successfull_completion: RETURN (0) --- GO GRANT EXECUTE ON TO GO ==
RE: OT - Problem w/IIS SSL & installing new SSL cert
> OK. You should still be able to create a new certificate request without > uninstalling the previous certificate. Are you renewing a certificate, or > replacing it altogether? I think we have it figured out now... I've been away from the office, on jury duty, so I was hoping to leave more explicit instructions than my rough notes. The admin's have it figured out, though. Thanks for your response! > [Hey, even more OT, you probably don't remember the class, > but I was in one of the classes you taught at Boeing, in > Downey CA, many years ago...] Oh, I remember that class alright. It was the very first class I taught, and after class ended I went skydiving, and saw a naked woman posing for a photoshoot in front of an LA bookstore. So, yeah, I remember that class. How's everyone doing out there? Well, Boeing closed that plant a few years ago. I've heard it's going to be a movie studio. The weather in Southern California is bright and sunny, like it is most of the year. I'm still a working CF programmer, and things are going well! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Problem w/IIS SSL & installing new SSL cert
Sorry, I was wrong about IIS4--it's IIS 5, on WIN2K. [Hey, even more OT, you probably don't remember the class, but I was in one of the classes you taught at Boeing, in Downey CA, many years ago...] Jeff Polaski RGS Webmaster www.rgs.uci.edu -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 8:31 AM To: CF-Talk Subject: RE: OT - Problem w/IIS SSL & installing new SSL cert > Any way, the problem is that I need to install a new SSL > certificate for IIS4, but I can't because the MMC won't let > me install a certificate into a site that already has a > running SSL certificate. I remember that I needed to create a > duplicate site, disable it, make an SSL cert for that one, > delete the site and install the cert into the "real" site. > Can anyone point me to the correct directions? I've been > looking for a while, but I can't get anything useful. I think > the directions were on microsoft.com, or an MS related site, > but I just can't find it. Can anyone help? I don't think you have to go to all that trouble. Within the Key Manager tool, you should be able to generate a new key request, and install a certificate, without assigning it to the site until you're ready. I'm still running an IIS 4 server with SSL, and I didn't have to do anything special to replace certificates. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: credit card add-on
I know this response is a little late (my wife and I just had a baby!), but you should be aware that if you go with Verisign, you should implement some code to track everything that happens during your transactions. This means logging everything, checking for duplicate transactions (from double clicks) and, fraud, etc... I've been a very happy customer of VeriSign for years. You just need to keep track of everything on your end, and make _sure_ the credit card numbers are secure. (We remove the cc numbers to floppy's so they're not even on the network).I posted a fairly long message about my thoughts for processing credit card transactions a year or two ago. If you can't find it I'll see if I can dig it up on my end, if any one's interested. (I should probably take some time and revise the code to take into account changes in CF since it was written... I'll do that with my ample free time ;-) ) Jeff PolaskiRGS Webmaster"I've never seen an abominable snowman, I'm hoping not to see one, I'm also hoping, if I do, That it will be a wee one. " - The Abominable Snowman , by Ogden Nash-Original Message-From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 12:32 PMTo: CF-TalkSubject: credit card add-onHello,Is there an add-on I could use with CF that would link with a service such as Verisign so that Verisign could do a credit card validation for my company? Is it this module listed somewhere or available as freeware? Any suggestions on incorporating this?Thanks.Robert OrliniHW Wilson718-588-8400 x2656ô¿ô [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SSL Cert 40 bit or 128 bit
I just wanted to pitch in my USD $0.02...In the grand scheme of things it seems that the _least_ of the problemsto worry about is someone decrypting your SSL traffic. I could be wrong,but if I was trying to get someone's "secret info", be it credit card,or social security, I would mount an attack on the operating system, orthe database on the computer that held the info. The only way someoneeven gets an opportunity to crack SSL is to be able to sniff the packetsas they travel "over the wire." You'd have to be pretty motivated toeven sort through the packets. Then they'd have to get the right pagetransaction, and then spend at least a week with fairly powerfulcomputers to decrypt that one page. If the transaction was on adifferent page, they'd have to start all over again. Also, there are many targets that are an order of magnitude easier tocrack, and have a much greater payoff than sniffing and decryptingpackets. I haven't heard of a single case of someone getting their infostolen from having a 40 bit key cracked. (If anyone has, let me know!) I'm not saying that SSL encryption isn't important (it is!), but I amsaying that, if money is an issue, 128-bit encryption is an overkill forweb transactions. Also, I'd ditch VeriSign, and go with a GeoTrust cert fromhttp://rackshack.net. We've been using them for about six months andhaven't had a single problem. (Sorry for the late response--my wife and I had a baby and I've beenaway for a while, and I wanted to say something about setting securitypriorities. I hope it was helpful...)Jeff PolaskiRGS Webmaster"I've never seen an abominable snowman, I'm hoping not to see one, I'm also hoping, if I do, That it will be a wee one. " - The Abominable Snowman , by Ogden Nash-Original Message-From: David Fafard [mailto:[EMAIL PROTECTED] Sent: Sunday, September 07, 2003 4:18 PMTo: CF-TalkSubject: SSL Cert 40 bit or 128 bitI'm on the verisign site and I have the optionof getting a 40 bit or 128 bit.Of course the 128 bit is 500.00 more.What do folks usually get? the 128 bit?Thanks,Dave Fafard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SSL Cert 40 bit or 128 bit
I did have trouble with RackShack.net's support, but they just referredme to Geotrust, who was able to help. It was a problem with IIS onWin2k, where you couldn't install renewal certificates. The solutionended up being some foolishness where you had to create a duplicatesite, turn it off, install the approved cert, delete the site, and theninstall cert on the running site. It was due to a very oddimplementation of the key manager by MS. Anyways, I got it running. Next time we renew, I'll be sure to take a look at InstantSSL. Thanksfor the tip! Jeff PolaskiRGS Webmaster"I've never seen an abominable snowman, I'm hoping not to see one, I'm also hoping, if I do, That it will be a wee one. "- The Abominable Snowman , by Ogden Nash -Original Message-From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 1:39 PMTo: CF-TalkSubject: RE: SSL Cert 40 bit or 128 bit How is there support? I know Geotrust is M-F 9-5 I've never had a problem with Geotrust support, they are quick torespond and always have the right answer but I know that something willhappen on a weekend or at 3am and I'll be hating life. Dan Phillipswww.CFXHosting.com1-866-239-4678[EMAIL PROTECTED]-Original Message-From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 4:37 PMTo: CF-TalkSubject: RE: SSL Cert 40 bit or 128 bitJeffrey Polaski wrote:>Also, I'd ditch VeriSign, and go with a GeoTrust cert from>http://rackshack.net. We've been using them for about six months and>haven't had a single problem. I've been using and recommending Rackshack.net myself. This morning Idumped them after setting up a Comodo reseller account atinstantssl.com. Rackshack recently lowered its price to US$29. However one thingunstated is the renewal cert is full price: US$119 at present (its beensteadily going UP). If you try to renew via Rackshack's US$29 formGeotrust will convert the submission to a US$119 renewal.Add to that Rackshack recently started sending annoying renewal noticesevery couple of weeks to the billing contact (me) and the admin contact(the client). This morning I found four notices in my inbox that eachclaimed a certain cert had expired "7 days ago" (none have expired yet).So I dumped them for InstantSSL. I have a reseller account that lets meinstantly issue certs, priced at about $42 each. Over 2 yearsInstantSSL is US$84 and Geotrust is US$148.If you read various charts these certs have better ubiquity thanGeotrust (which needs IE5.01+ and isn't recognized by Opera), although Inever heard any complaints in the roughly 1 1/2 years I used them.Just some Friday OT; sorry :-)-Matt Robertson, [EMAIL PROTECTED]MSB Designs, Inc. http://mysecretbase.com- _ [Todays_ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SSL Cert 40 bit or 128 bit
Once you get an SSL cert installed, there is very little that can gowrong. I suppose you could get a corrupted file of something, but ifthat happens you'll most likely have bigger problems that will need afull system restore to fix. I think the only kind of support most serveradmins would need is installation support. Unless you're in a hurry,with email support, google, and this list you should be fine. If you are in a hurry, you can grab a test certificate from VeriSignthat's good for a week. When VeriSign calls to ask why you didn't buy acert from them, be sure to tell them that you found another vendor thatcharges far less. (I'm hoping that enough people will stop paying suchexorbitant prices that they will drop the cost to something reasonable.) Jeff PolaskiRGS Webmaster"I've never seen an abominable snowman, I'm hoping not to see one, I'm also hoping, if I do, That it will be a wee one. "- The Abominable Snowman , by Ogden Nash -Original Message-From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 1:39 PMTo: CF-TalkSubject: RE: SSL Cert 40 bit or 128 bit How is there support? I know Geotrust is M-F 9-5 I've never had a problem with Geotrust support, they are quick torespond and always have the right answer but I know that something willhappen on a weekend or at 3am and I'll be hating life. Dan Phillipswww.CFXHosting.com1-866-239-4678[EMAIL PROTECTED]-Original Message-From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 4:37 PMTo: CF-TalkSubject: RE: SSL Cert 40 bit or 128 bitJeffrey Polaski wrote:>Also, I'd ditch VeriSign, and go with a GeoTrust cert from>http://rackshack.net. We've been using them for about six months and>haven't had a single problem. I've been using and recommending Rackshack.net myself. This morning Idumped them after setting up a Comodo reseller account atinstantssl.com. Rackshack recently lowered its price to US$29. However one thingunstated is the renewal cert is full price: US$119 at present (its beensteadily going UP). If you try to renew via Rackshack's US$29 formGeotrust will convert the submission to a US$119 renewal.Add to that Rackshack recently started sending annoying renewal noticesevery couple of weeks to the billing contact (me) and the admin contact(the client). This morning I found four notices in my inbox that eachclaimed a certain cert had expired "7 days ago" (none have expired yet).So I dumped them for InstantSSL. I have a reseller account that lets meinstantly issue certs, priced at about $42 each. Over 2 yearsInstantSSL is US$84 and Geotrust is US$148.If you read various charts these certs have better ubiquity thanGeotrust (which needs IE5.01+ and isn't recognized by Opera), although Inever heard any complaints in the roughly 1 1/2 years I used them.Just some Friday OT; sorry :-)-Matt Robertson, [EMAIL PROTECTED]MSB Designs, Inc. http://mysecretbase.com- _ [Todays_ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
I've had very good success with VeriSign's PayFlow pro. I've had consistently fast response times and their servers haven't gone down once since I've been using them. If you want to do all the processing "on-site" (opposed to redirecting to another site) then they are a great way to go. I wouldn't use their SSL certs, or anything else from them, though. Jeff Polaski RGS Webmaster "I've never seen an abominable snowman, I'm hoping not to see one, I'm also hoping, if I do, That it will be a wee one. " - The Abominable Snowman , by Ogden Nash -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 7:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used? I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome. Thank you! --- Ricky Fritzsching _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]