Hi guys

I need to insert multiple fields. Let say 20 Text boxes displayed on a page, but only 10 get filled in. I need to ignore the empty ones and insert only the ones with something on them. Also, how do I insert multiple items into a DB....eg

txt1 into tblName , txt2 into tblPostcode, txt3 into tblDate
txt4 into tblName , txt5 into tblPostcode, etc......

so far you guys have been awesome

Hello,

If multiple insert statements exist, write out separate insert statements, and do: Connection.Execute(strSQL)

TO ignore the empty fields, either provide null for that field, or only insert the fields into the SQL string that exist, which you can do something like:

if ( txt5 <> "" ) then
  strParamSQL = strParamSQL & "Value, "
  strValueSQL = strValueSQL & "'" & txt5.text & "', "
end if

That way the values that exist only get's inserted. At the end, strip of the last ", " because that will cause problems, and call the execute method for the SQL as such:

Connection.Execute("insert into tblPostCode (" & strParamSQL & ") values (" & strValueSQL & ")"

I hope this is what you were looking for...

Brian

WOOOAAAAHHHHHH!!!! bit complicated for me. Any ideas where I could find some tutorials on this? I really need the "Dummy's guide to ASP" kind of thing