Insert Statement

[AdamVerellen]

I have the following issue when trying to insert.

Set cnnSearch = Server.CreateObject("ADODB.Connection&quot

cnnSearch.Open "Provider=SQLOLEDB;Data Source=10.10.10.1;" _
& "Initial Catalog=TraceDB;User Id=sa;Password=;" _
& "Connect Timeout=15;Network Library=dbmssocn;"

strInsert = "Insert into

(dcreate, tcreate, Reason, Part, Qty) values ('" & date() & "','" & now() & "', 'Update','12345678',10 ;"

cnnSearch.Execute strInsert

Insert statement doesn't seem to want to work.
Did I miss anything, I figure maybe I am opening the database in Read Only or something?

 

[onpnt]

have you tried to
Response.Write strInsert
Response.End

then paste the output to Analyzer yet


_____________________________________________________________________

_{The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page}

 

[onpnt]

just to add to that once you do it. that will give you the string value that actually hits the database. when you copy paste it to the analyzer you should rate away see the missing ) and there is no ; in SQL Server for statement termination

believe that is only Jet-SQL

_____________________________________________________________________

_{The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page}

 

[AdamVerellen]

hehe oops
I might have more in a min
This was a slimed down version

 

[AdamVerellen]

I learned a valuable lesson in debugging
Thanks

It helps to do it
hehe

 

[onpnt]

so it be fixed. I was expecting a twenty line query after the alst reply

glad it got you going

_____________________________________________________________________

_{The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page}

 

[AdamVerellen]

With using the response write I figured the 20 line query out.
It ended up being something stupid, I'm sure as most errors are.

I'll put it in anyway.

left(spart,(instr(spart,"P&quot-1)) is where my error was
spart = 123456
it produced an error of course.
spart needs to have the P in it

But anyway, Thanks

 

[onpnt]

@ the 20 line

That's the nice feature of SQL Server and using the Analyzer with debugging the statements. It's a slight irritation to do the same in whatever access calls that SQL Query thing. although it can be useful in the same way also.



_____________________________________________________________________

_{The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page}