Error in [sql set]?

[Nicholas Albright <albrnick@bobcat.ent.ohiou.edu>]

******    message to minivend-users from Nicholas Albright <albrnick@bobcat.ent.ohiou.edu>     ******



  I'm trying to use sql set, and get this error in the error.log:

-----Begin Error 1-----
 /cart.cgi/admin/insert3 Runtime error: parse error at line 5 near ") ;"
>  at /usr/www/vianexus/mvend/lib/Vend/Data.pm line 356
-----End Error 1-----


  Here is the line from the HTML file.  

-----Begin Minivend Code-----
[sql type=set base=ca2g_test]
  insert into ca2g_test
  values
  ( '101', 'short', 'long', 'key', '100.00', '10.00'
  );
[/sql ca2g_test]
-----End Minivend Code-----


  I originally had it with out a ';' on the 5th line, and got this error:

-----Begin Error 2-----
 /cart.cgi/admin/insert3 Runtime error: parse error at line 6 near ") ["
>  at /usr/www/vianexus/mvend/lib/Vend/Data.pm line 356
-----End Error 2-----

  I also get error #2 when I remove the apostrophes from around the
numbers.

  Here is my database definition:

-----Begin DB def-----
Database        ca2g_test       COLUMN_DEF      internal_code=int
Database        ca2g_test       COLUMN_DEF      short_desc=text(80)
Database        ca2g_test       COLUMN_DEF      long_desc=text(256)
Database        ca2g_test       COLUMN_DEF      key_words=text(80)
Database        ca2g_test       COLUMN_DEF      list_price=money
Database        ca2g_test       COLUMN_DEF      our_price=money
Database        ca2g_test       NUMERIC         internal_code, list_price, our_\price
-----Begin DB def-----

  
  Does anyone know what exactly is causing this?

  Thanks for your time,
   -Nick

-- 

"Five out every four people have trouble with fractions."
		-- Unknown


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list