Incorrect Syntax near "," doesnt make sense

[J. Muenchbourg]

IN the code below, I am getting an Incorrect Syntax near "," error (the
sql execute line, and it is pointing to position 1 ) (the display
formatting here may look different than my script):

strSQLStatement = "INSERT INTO
tblArticles(handid,articleid,articleDate,sport,art icleheader,fpick,artic
leText)"_
& "VALUES ('" & handid & "', " _
& articleid & ", '" _
& articledate & "', " _
& sport & ", '" _
& articleheader & "', '" _
& fpick & "', '" _
& articleText & "')"
response.write strSQLstatement
Conn.Execute(strSQLStatement)

????
Thanks in advance
Muench

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

[Aaron Bertrand - MVP]

One of your values is empty. What does the response.write line show (seeing
your SQL statement prior to variable substitution is quite useless).

"J. Muenchbourg" <jo*****@canada.com> wrote in message
news:#u**************@tk2msftngp13.phx.gbl...

IN the code below, I am getting an Incorrect Syntax near "," error (the
sql execute line, and it is pointing to position 1 ) (the display
formatting here may look different than my script):

strSQLStatement = "INSERT INTO
tblArticles(handid,articleid,articleDate,sport,art icleheader,fpick,artic
leText)"_
& "VALUES ('" & handid & "', " _
& articleid & ", '" _
& articledate & "', " _
& sport & ", '" _
& articleheader & "', '" _
& fpick & "', '" _
& articleText & "')"
response.write strSQLstatement
Conn.Execute(strSQLStatement)

????
Thanks in advance
Muench

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

[Curt_C [MVP]]

show us the Response.Write of that statement, also which are string, which
are int
--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
...Offering free scripts & code snippits for everyone...
---------------------------------------------------------
"J. Muenchbourg" <jo*****@canada.com> wrote in message
news:#u**************@tk2msftngp13.phx.gbl...

IN the code below, I am getting an Incorrect Syntax near "," error (the
sql execute line, and it is pointing to position 1 ) (the display
formatting here may look different than my script):

strSQLStatement = "INSERT INTO
tblArticles(handid,articleid,articleDate,sport,art icleheader,fpick,artic
leText)"_
& "VALUES ('" & handid & "', " _
& articleid & ", '" _
& articledate & "', " _
& sport & ", '" _
& articleheader & "', '" _
& fpick & "', '" _
& articleText & "')"
response.write strSQLstatement
Conn.Execute(strSQLStatement)

????
Thanks in advance
Muench

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

[middletree]

What Aaron says is best, but I would add that there is a possibility that
you have a comma(or some other kind of show-stopper) in one of your values.
Bottom line is to do a response.write
"J. Muenchbourg" <jo*****@canada.com> wrote in message
news:#u**************@tk2msftngp13.phx.gbl...

IN the code below, I am getting an Incorrect Syntax near "," error (the
sql execute line, and it is pointing to position 1 ) (the display
formatting here may look different than my script):

strSQLStatement = "INSERT INTO
tblArticles(handid,articleid,articleDate,sport,art icleheader,fpick,artic
leText)"_
& "VALUES ('" & handid & "', " _
& articleid & ", '" _
& articledate & "', " _
& sport & ", '" _
& articleheader & "', '" _
& fpick & "', '" _
& articleText & "')"
response.write strSQLstatement
Conn.Execute(strSQLStatement)

????
Thanks in advance
Muench

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

[Tom B]

It wouldn't hurt to throw some spaces in, I don't think T-SQL cares, but you
have no spaces after your table name or after your closing brace on the
column list.
After you resolve your SQL Problem, I believe this will cause a problem
Conn.Execute(strSQLStatement)

Execute is a function, but since you aren't doing anything with the return
value, you should call it as though it were a subroutine

Conn.Execute strSQLStatement

"J. Muenchbourg" <jo*****@canada.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

IN the code below, I am getting an Incorrect Syntax near "," error (the
sql execute line, and it is pointing to position 1 ) (the display
formatting here may look different than my script):

strSQLStatement = "INSERT INTO
tblArticles(handid,articleid,articleDate,sport,art icleheader,fpick,artic
leText)"_
& "VALUES ('" & handid & "', " _
& articleid & ", '" _
& articledate & "', " _
& sport & ", '" _
& articleheader & "', '" _
& fpick & "', '" _
& articleText & "')"
response.write strSQLstatement
Conn.Execute(strSQLStatement)

????
Thanks in advance
Muench

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

[Bob Barrows]

Tom B wrote:

It wouldn't hurt to throw some spaces in, I don't think T-SQL cares,
but you have no spaces after your table name or after your closing
brace on the column list.
After you resolve your SQL Problem, I believe this will cause a
problem Conn.Execute(strSQLStatement)

Execute is a function, but since you aren't doing anything with the
return value, you should call it as though it were a subroutine

Conn.Execute strSQLStatement

You should also tell ADO what type of command you are executing, and that
you do not want it to construct a recordset:
Conn.Execute strSQLStatement,,129

129 is the addition of two constants: adCmdText and adExecuteNoRecords. If
you have the ADO constants defined, you can do this instead:
Conn.Execute strSQLStatement,,adCmdText + adExecuteNoRecords
HTH,
Bob Barrows