Hi,
You wrote:
> I am trying to input data into a table. I keep getting the following
> error. This is from the monitor.
>
>
> mSQL > insert into sport_card
> -> (year_id, sport_id, makers_id, condition_id,
> -> description, qty, name, cardnum, price)
> -> values ('1', 'Basball', 'Topps', 'GemMint', 'good',
> -> 1, 'Eric', '12', '12.00') \g
>
>
> ERROR : Literal value for 'year_id' is wrong type
I think year_id is of type int, so you have to write "... values (1, ...".
Only strings (and date and time values) must be enclosed in quotes.
Bye,
Georg
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:03:51 EST