RE: CF Upgrades

Thanks for the response. Jeff Polaski Webmaster Office of Research Office of Graduate Studies University of California, Irvine http://www.rgs.uci.edu/ 949.824.6363 -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, March 08, 2007 3:06 PM To: CF-Talk

CF Upgrades

Does any one know when the next CF upgrade is supposed to be released? It's time for us to renew out license for another year, and I'd rather not if there isn't going to be a decent upgrade. Jeff Polaski Webmaster Office of Research Office of Graduate Studies University of California,

RE: cfstoredproc vs cfquery

Just to add a bit to the thread: cfstoredproc is, in general, a little more secure. It allows you to specify the data type of parameters, which can help with security. Stored procedures are generally harder to break out of during a SQL injection attack. Also, a stored procedure can have more

RE: cfstoredproc vs cfquery

I've always done sorting in the query or sp, by adding an order by clause. If I need a special ordering then I usually add a sort order column where I plug in numbers to order it on. If I'm doing paging then I pass in an offset, too. Jeff Polaski Webmaster Office of Research Office of

CF Verity and Accented Characters

Does anyone know how to set up Verity searches so that characters with accents are equivalent to the non-accented character? For example, if someone was searching for Jose it should return results indexed under José. I can't seem to find much about it online... We're running CF MX, so have K2

Trouble with Verisign's cfx_payflowpro tag

Has any one else had this problem... I've installed Verisign's PayFlowPro by their instructions, but when I get to a page that uses their custom tag, cfx_payflowpro, I keep getting an error: 500 com/Verisign/payment/PFProAPI com/Verisign/payment/PFProAPI It hasn't worked since we upgraded to

RE: Trouble with Verisign's cfx_payflowpro tag -- fixed

needed were slightly different than the instructions... Sorry I can't remember the solution in any more detail, but I'm sure you can find my archived messages. --Ferg Jeffrey Polaski wrote: Has any one else had this problem... I've installed Verisign's PayFlowPro by their instructions, but when

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

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

RE: Error: [Macromedia][SQLServer JDBC Driver]No more data availa ble to read

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

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

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

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

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

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

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

[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:

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

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

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

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

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

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

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

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.

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

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

RE: Coldfusion Apps You've Built

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

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

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

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

RE: At my new job

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

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

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

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

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

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

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.

RE: Coldfusion Server

One other thing to look for is typos in cf tags. For example: cfinsert datasource=data_source tablename= dbtype=ODBC dbserver=db_server dbname='db_name username user_name

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

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

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

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

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

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

RE: Credit Card Encryption

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

RE: Help! Verity Error: Collection failed to open and VdkColle ctio nSubmit failed Error Code: -23 -- SOLVED

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

RE: Help! Verity Error: Collection failed to open and VdkColle ctio nSubmit failed Error Code: -23

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

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,