Hi All!
> Unable to insert [
> insert into match (league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')
> ]: You have an error in your SQL syntax near 'match
>(league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')' at line 1.
(Yes, I see the reserved word comments.)
Debug
Hi,
> Unable to insert [
> insert into match (league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')
> ]: You have an error in your SQL syntax near 'match
>(league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')' at line 1.
MATCH is a keyword... :) How did you manage to c
Chris
Are those columns really character types, or integers ?
The values you list are quoted, which suggests they're character based, but
'id' suggests integers, ie.
insert into match (league_id,round_id,team_id_1,team_id_2) VALUES (1,3,2,3);
Phil
- Original Message -
From: "Chris Ait
hi,
MATCH is a reserved word. Try to rename your table.
HTH.
Anton Tichawa.
> -Original Message-
> From: Chris Aitken [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 25, 2001 1:09 PM
> To: [EMAIL PROTECTED]
> Subject: Weird Error Inserting
>
>
>
