[RESOLVED] SQL INSERT error

[SeanK]

Yes, and its interpreted as placeholders for parameters... the values of which are provided by the parameters collection of the command object.

objCommand.Parameters.Add objCommand.CreateParameter("title",advarchar,50, [b]txtTitle.Text[/b])
objCommand.Parameters.Add objCommand.CreateParameter("actor",advarchar,50, [b]txtactor.Text[/b])
objCommand.Parameters.Add objCommand.CreateParameter("producer",advarchar,50, [b]txtproducer.Text[/b])
objCommand.Parameters.Add objCommand.CreateParameter("comment",advarchar,50, [b]txtComment.Text[/b])

The replacement/update of the values is done by FIFO (first parameter object provides data for the first ?)

After all parameters have values then the query executes without an error.

Ok...cool. I think I'm actually starting to get this (and like it )

So, I would use advarchar for text. What would I use to insert values into a int field?

Also, is this something that is confined to INSERTS or would I do the same thing with UPDATES?