
August 27th, 2004, 04:39 AM
|
|
Registered User
|
|
Join Date: Aug 2004
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
SQL Insert statement help
I'm trying to using a databound checkboxlist to insert a bunch of entries to a table, completely dependant upon which checkbox's are checked. Most of the information is static (for this statement at least). I fixed a couple quirks, however this one has me a bit stumped as to what I'm missing. Help would be greatly appreciated.
Dim queryString As String = "INSERT INTO [LOGS] ([Servername], [Date], [Tape], [Rotation #], [Action], [Comments]) VALUES (@Servername, datetime.now, "First", 1, "Initial Load", @Comments)"
I'm getting Compiler error message BC30205 error message, End of statement expected. I see an opening and a close to each section, what am i missing? or am i just going blind?
~John T.
|