This is slightly off topic, per se, but I was hoping that someone might have
an answer.
I recently moved my CGI into the mod_perl environment under Apache. I had,
until this point, never seen the following error with my scripts.
[Tue Feb 19 13:32:28 2002] nul: Database handle destroyed without
I would like to know how people handle foreign keys with mysql.
Has anyone ever created a relationships table for use with other tables? If
so, what types of fields did you find necessary to define the relationships?
How did you handle parent-child relationships -- when parents are deleted
all th
Basically that is what I thought.
However, please define "relation". Do you mean table?
-Original Message-
From: Simon Oliver [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 7:06 AM
To: '[EMAIL PROTECTED]'
Subject: Re: multiple primary keys
Each relation should have one p
: Vuillemot, Ward W
Subject: RE: multiple primary keys
I can't speak for mySQL, but by definition there is only one primary key
allowed per table in Relational Database theory.
You can, however, enforce uniqueness against other columns by using a unique
key.
Not all primary keys have to be bas
I have a question regarding multiple primary keys. Do all DBs handle multple
primary keys? In addition, can only one of the primary keys be
autoincremented?
I am curious how this pertains to mySQL where we have:
$sth->{'mysql_insertid'};
Is there a way to determine the name of column tha
What is the best suggested method for encrypting/decrypting sensitive
material in a DB over the web?
For example, a password column in a users table for checking to see who has
access or not. I know that MySQL provides its own functionality from within
its environment, but I have not seen a metho
I am receiving the following error:
Can't call method "func" on an undefined value at
C:\Inetpub\scripts\convertOptran.pl line 382, line 532.
And the offending line of code is marked by ' <-- BAD CODE! BAD!'. I
checked the passed arguments, which all check out. I do not
