Or alternatively, (as I read it), use a char(0). Poss. Values NULL or ''
(empty string).
Kyle
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 11:04 AM
To: [EMAIL PROTECTED]
Subject: Re: general questions
Actually, the ideal type for boo
Hi all,
I'm trying to load a 1:M table with rows. I've been thru the manual
and discussion list and each comes close but not quite. I'm trying to
load a full table with 4 cols, but one of them needs to be a key to
another table SELECTed enroute. 'LAST_INSERT_ID()' doesn't help because
the main ta
That makes sense.
Thank you Tore.
Kyle
-Original Message-
From: Tore Bostrup [mailto:[EMAIL PROTECTED]]
Sent: Friday, 21 February 2003 01:12
To: Kyle Lange; [EMAIL PROTECTED]
Subject: Re: INSERT ... SELECT - A slightly different question
The typical syntax for this would be:
INSERT
Hi,
Try as I might, I can't seem to work out the SQL for this query. Can you
help please?
I need to retrieve a list of products within a certain category with
their relevant prices obtained from a specific (date-based) *valid*
pricelist relevant to a particular person.
TABLE: persons - perID
T
Sorry people. I switched the receipt off originally, but the filter on
the server sent it back and I just replied forgetting the receipt 2nd
time round.
Apologies.
Kyle
-Original Message-
From: Kyle Lange [mailto:[EMAIL PROTECTED]
Sent: Friday, 14 March 2003 15:46
To: [EMAIL PROTECTED
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Friday, 14 March 2003 16:48
To: [EMAIL PROTECTED]
Cc: Kyle Lange
Subject: Re: How to implement this query - can you help pls?
* Kyle Lange
> Try as I might, I can't seem to work out the SQL for this qu
--Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Friday, 14 March 2003 16:48
To: [EMAIL PROTECTED]
Cc: Kyle Lange
Subject: Re: How to implement this query - can you help pls?
* Kyle Lange
> Try as I might, I can't seem to work out the SQL for this query. Can
I think you probably need to do one of the following;
Insert into info set referer = ?
Or
Insert into info (referer) values (?)
But I could be wrong.
-Original Message-
From: jsp [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 25 March 2003 07:17
To: 'Tomcat Users List'
Cc: [EMAIL PROTECT
As I understand it,
You're actually better off, if not HAVE TO, just putting the 3.0.6 connector jar file
into your /common/lib directory in order for Tomcat to be able to see
it.
K
-Original Message-
From: Todd O'Bryan [mailto:[EMAIL PROTECTED]
Sent: Saturday, 5 April 2003 19:44
To
