Good SQL Statement Excute No Go

[JordanR]

I have a sql statement that looks correct when I print it out but when I execute it I get a Syntax error:
Syntax error in INSERT INTO statement.
I have been getting this problem all week with other insert, update statements and it is frustrating.
Please help? here is the code
<%
Set conn=Server.CreateObject(&quot;ADODB.Connection&quot
conn.open (&quot;ABFAtlanta&quot

myArray=split(request.form(&quot;MultiSelect&quot,&quot;,&quot
for i=0 to Ubound(myArray)
strSql=&quot;INSERT tblProductcolors (color) Values ('&quot; & myArray(i) & &quot;')&quot;
SET pcolors = conn.execute(strSql)
response.Write(strSql)
Next
conn.close
set conn=nothing
%>

 

[LV]

What happens if you change
SET pcolors = conn.execute(strSql)
to just
conn.execute(strSql)

 

[shaddow]

When you post a multiple select the form field it's already an array you dont need to split it up.
you can walk tha array with
for i=0 to request.form(&quot;MultiSelect&quot.Count-1
and get values with
request.form(&quot;MultiSelect&quot.Items(i)
Also your code looks ok but you can have 1 posible error: could have a quote character.

Try with this

strSql="INSERT tblProductcolors (color) Values ('" & Replace(myArray(i),"'","''") & "')"

________
George, M

 

[jaredmcguire]

I see nothing wrong with your code. Check the permissions on your database. INSERT statements require write access and you will get this error if write permissions are not set.

FYI:
On the the line: SET pcolors = conn.execute(strSql)
You can simply shorten this to: conn.execute(strSql)
INSERT and DELETE statement don't return a anything.