INSERT statement contains fewer items than the insert list

[J. Muenchbourg]

The block of code below shows how I am inserting field values into my
dbase table:

strSQLStatement = "INSERT INTO tblArticles
(handid,ArticleDate,sport,articleheader, fpick,articleText) "_
& "SELECT '" & handid & "' As handid, '" _
& ArticleDate & "' As ArticleDate, '" _
& sport & " As sport, " _
& articleheader & "' As articleheader, '" _
& fpick & "' As fpick, '" _
& articleText & "' As articleText;"

Conn.Execute(strSQLStatement)

...but I am getting an "Insert statement contains fewer items than the
insert list" error , when in fact I am not (both 6 field names).

????
Muench

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Turkbear]

On Tue, 30 Sep 2003 13:06:31 -0700, J. Muenchbourg <jodaddy@canada.com> wrote:

>The block of code below shows how I am inserting field values into my
>dbase table:
>
>strSQLStatement = "INSERT INTO tblArticles
>(handid,ArticleDate,sport,articleheader, fpick,articleText) "_
> & "SELECT '" & handid & "' As handid, '" _
> & ArticleDate & "' As ArticleDate, '" _
> & sport & " As sport, " _
> & articleheader & "' As articleheader, '" _
> & fpick & "' As fpick, '" _
> & articleText & "' As articleText;"
>
> Conn.Execute(strSQLStatement)
>
>..but I am getting an "Insert statement contains fewer items than the
>insert list" error , when in fact I am not (both 6 field names).
>
>????
>Muench
>
>*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
>Don't just participate in USENET...get rewarded for it!

Try a
Response.Write (strSQLStatement)
to see if perhaps the quotes or commas are getting misplaced...

[Harry Strybos]

"J. Muenchbourg" <jodaddy@canada.com> wrote in message
news:uMJUY54hDHA.2320@TK2MSFTNGP12.phx.gbl...

> The block of code below shows how I am inserting field values into my
> dbase table:
>
> strSQLStatement = "INSERT INTO tblArticles
> (handid,ArticleDate,sport,articleheader, fpick,articleText) "_
> & "SELECT '" & handid & "' As handid, '" _
> & ArticleDate & "' As ArticleDate, '" _
> & sport & " As sport, " _
> & articleheader & "' As articleheader, '" _
> & fpick & "' As fpick, '" _
> & articleText & "' As articleText;"
>
> Conn.Execute(strSQLStatement)
>
> ..but I am getting an "Insert statement contains fewer items than the
> insert list" error , when in fact I am not (both 6 field names).
>
> ????
> Muench
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

Try this:

strSQLStatement = "INSERT INTO tblArticles

> (handid,ArticleDate,sport,articleheader, fpick,articleText) "_
> & "VALUES (" & handid & ", " _
> & ArticleDate & ", " _
> & sport & ", " _
> & articleheader & ", " _
> & fpick & ", " _
> & articleText & ")"

[Aaron Bertrand - MVP]

Uh, did you mean

strSQLStatement = "INSERT tblArticles (handid, ...) VALUES('" & handid & "',
....)"

(I've never seen As used for aliases in an *insert* statement; not saying
that it wouldn't work, but it looks weird, and bloats your code
unnecessarily.)

Also, a good debugging technique, as always, is

Response.Write (strSQLStatement)

In this case, you are very likely to spot the problem without having to post
a message at all. And when you do have to post a message, you give us more
useful information than an unpopulated SQL statement...







"J. Muenchbourg" <jodaddy@canada.com> wrote in message
news:uMJUY54hDHA.2320@TK2MSFTNGP12.phx.gbl...

> The block of code below shows how I am inserting field values into my
> dbase table:
>
> strSQLStatement = "INSERT INTO tblArticles
> (handid,ArticleDate,sport,articleheader, fpick,articleText) "_
> & "SELECT '" & handid & "' As handid, '" _
> & ArticleDate & "' As ArticleDate, '" _
> & sport & " As sport, " _
> & articleheader & "' As articleheader, '" _
> & fpick & "' As fpick, '" _
> & articleText & "' As articleText;"
>
> Conn.Execute(strSQLStatement)
>
> ..but I am getting an "Insert statement contains fewer items than the
> insert list" error , when in fact I am not (both 6 field names).
>
> ????
> Muench
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!