Re: DBI SQL Syntax Problem

[jerrygarciuh]

I was asked to supply more info so here is the table schema, the db is mySQL, and I am doing lots of INSERTS and single col+val updates successfully, dunno what is up here.
Thx for looking!
jg

+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| year        | int(11)      | YES  |     | NULL    |       |
| month       | int(11)      | YES  |     | NULL    |       |
| day         | int(11)      | YES  |     | NULL    |       |
| time_start  | varchar(20)  | YES  |     | NULL    |       |
| time_end    | varchar(20)  | YES  |     | NULL    |       |
| title       | varchar(50)  | YES  |     | NULL    |       |
| location    | varchar(255) | YES  |     | NULL    |       |
| description | varchar(255) | YES  |     | NULL    |       |
| category    | varchar(255) | YES  |     | NULL    |       |
| posted_by   | varchar(255) | YES  |     | NULL    |       |
| post_date   | varchar(255) | YES  |     | NULL    |       |
| b_time      | time         | YES  |     | NULL    |       |
| e_time      | time         | YES  |     | NULL    |       |
+-------------+--------------+------+-----+---------+-------+

_____________________________________________________
Think a race on a horse on a ball with a fish! TG