Ferindo
One problem is:
employment_status_id INTEGER REFERENCES employment_statuses(id) NOT
NULL,
NOT NULL should be before REFERENCES.
Also, in:
last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
(i) NOT NULL is superfluous since the default is given by
CURRENT_TIMESTAMP.
Thanks Peter. I did originally use this table in a Postgresql db. Thanks
for you advice. Your suggestions below allowed me to create this table
and I learned a thing t two about proper usage of the TIMESTAMP data
type. The intended effect is to get a timestamp field that inserts the
current
Hi Ferindo
The intended effect is to get a timestamp field that inserts the
current system
time on inserts and continues to update the field with the current
timestamp
on updates without the application or use needing to specify it
are you
saying that the timestamp attribute alone will
Ok, so I can't get the FAQ to load. It gives forth lots of PHP errors.
Meanwhile, I have not been able to get very far in the tutorial due to
these parse errors on the examples. I am entering them correctly, I
think. Case should not matter, and here is what I get:
mysql select version();
Hmmm.. could be something as simple as a line break - but that is often hard
to diagnose via email
Please send me the relevant files (off-list) - I should be able to find the
error quickly.
--zak
Barry C. Hawkins wrote:
on 6/7/01 17:58, Zak Greant at [EMAIL PROTECTED] wrote:
Barry C.
Barry C. Hawkins wrote:
Esteemed colleagues,
The php list is down, and I am sure someone knows what to do about
this
in this list. The issue is that I receive the error
Parse error: parse error in config.inc.php3 on line 1
upon trying to access phpMyAdmin 2.1.0 from the web.
on 6/7/01 17:58, Zak Greant at [EMAIL PROTECTED] wrote:
Barry C. Hawkins wrote:
Esteemed colleagues,
The php list is down, and I am sure someone knows what to do about
this
in this list. The issue is that I receive the error
Parse error: parse error in config.inc.php3 on line 1
upon
Shouldn't you have on line 7
print (OK 2 );
and not
print (OK 2 )
Im not a PHP person but thats what I noticed in your code. And if ;
terminates a command that can't be helping
magic words sql database
-Original Message-
From: MTF [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16,
You should be using echo in place of print.
echo OK 2;
Robert Henkel
Shouldn't you have on line 7
print (OK 2 );
and not
print (OK 2 )
Im not a PHP person but thats what I noticed in your code. And if ;
terminates a command that can't be helping
magic words sql database
-Original
In Addation,
Print (OK 3) line is also missed ':'.
^^
magic words sql database
- Original Message -
From: MTF [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 16, 2001 12:13 PM
Subject: Parse error?
I am new to MySQL and am using Paul DuBois's book to MySQL guide me.
Petra,
You have a close '}' with no open '{'. Maybe you should move the If
statement to the next line, then it won't be commented out.
len.
-Original Message-
From: Petra [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 27 March 2001 13:21
To: [EMAIL PROTECTED]
Subject: parse error
11 matches
Mail list logo