On Mon, 4 Oct 1999, Eric @home wrote:
> 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
What is the field type for year_id? Is it INT? If so you don't need to
quote the value. Any numeric type (int, uint, real, money) values do not
require quotes. Only textual (char, text) or "processed" types (i.e. ones
that use a textual external representation and something else internally,
such as date and time) need to be quoted.
Bambi
...
-------------------------------------------------------------------------
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