RE: What are you using instead of IDENTITY...Part II

All, What Joe is saying is very simple. - Primary Keys must be made from data elements within the row. Using a number generator to assign an integer value as a key is acceptable. - Since IDENTITY is not a real data element (it's an internal row pointer), it is NOT an appropriate key candidate.

RE: MySQL on UNIX w/ CF on NT4

All, Having done some comparison of both mySQL and PostgreSQL, I would STRONGLY recommend that you have a look at Interbase SQL Server (www.interbase.com). - it supports 98% of possible OS's (NT, Linux, Unix...) - it is a true SQL server (with transactions, triggers, Stored Procedures, referenti

RE: Post Time

On busy servers with large numbers of members, it can take some time for posting to be sent out. I don't know all the details of the server and it's net connection (ISDN, DSL, T1, T3???) so I can't tell you which is being the limiting factor. (perhaps someone in the "know" can enlighten us). -

RE: Avoiding using the MAX function

Nick, Agreeing with you completely regarding the overhead of a DB call. I find it very interesting that people don't recommend the use of UUID as DB keys. In this way, using CreateUUID, CF would already know the key value and the DB INSERT would proceed on it's own. The suggestion, which is of

RE: no one knows vpn?

Jason, While I don't know what "Mabry socketx" is/are, it shouldn't really matter. I don't see your problem. The fact that you are using DUN only means that you need to "setup" your TCP/IP connection properly. After that, the communication is standard TCP/IP messages. The way you want to im

RE: Cisco Local Director/CF and Winnt

Lincoln, How about asking the questions publicly? We are going to be looking at implementing a balancing solution (most probably the Local Director) and would appreciate seeing what issues/questions you have and the responses you get. Sean P.S.Isn't a list-server/newsgroup to allow the co

RE: SQL Max record ID ?

Nick, I would like to earnestly disagree, but would like to read the original thread / Ben's comments first. Where can I find the message archives??? Sean -Original Message- From: Nick Slay [mailto:[EMAIL PROTECTED]] Sent: Friday, May 12, 2000 6:39 PM To: [EMAIL PROTECTED] S

RE: OT: Anyone know about firewall software?

Have a look at www.netmax.com it's inexpensive $99 USD, supports multi-zone/subnets, and you can turn on/off NAT (Network Address Translation) Sean -Original Message- From: Richard Ramos [mailto:[EMAIL PROTECTED]] Sent: Friday, May 12, 2000 7:14 PM To: [EMAIL PROTECTED] Subjec

RE: SQL Max record ID ?

Although technically correct, this approach (using Max ID) is not recommended for large sites. A more appropriate approach would be to use the CreateUUID() function to calculate an ID value (to be stored in a variable), which result id an ID value which would be known "by the page" and elimina