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

 

[Turkbear]

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

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

 

[Harry Strybos]

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

Try this:

strSQLStatement = "INSERT INTO tblArticles

 

[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...