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 also get the same message for w3-msql when trying from an html page.
(from input page)
<TR><TD>Year:<TD><INPUT name="year">
(from referenced page)
$err = msqlQuery ($db, "insert into sport_card values('$year_id',
'$sport_id', '$makers_id', '$condition_id', '$description', '$name',
'$qty', '$cardnum', '$money')");
I am trying to pull data from other tables, the first four values. In
the years table where year_id is from it was placed as INT.
Help!
Thanks,
eric
-------------------------------------------------------------------------
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