[Gambas-user] MySQL Data

[Pat Collins]

On Wed, Jan 26, 2005 at 06:04:49PM -0800, Eric Damron wrote:
> Thanks!  Does the substitute features of Exec() have any limitations 
> that I should know about?  In the following line I get an error message:
> hConnection.Exec("insert into DISC (title, rating_id, note, 
> genre_primary, genre_secondary, format_code) values (&1, &2, &3, &4, 
> &5)", strTitle, strRatingID, strNote, strGenrePrimary, 
> strGenreSecondary, strFormatCode)
>

Your insert is broken.  You are tring to insert 5 values into 6 columns.

-- 
Pat Collins
http://www.linuxcolumbus.com