Click to See Complete Forum and Search --> : Insert 2 form fields to one DB field


mdb
12-07-2004, 09:47 PM
I came across this before but I can't find it when I need it.
I would like to join or merge 2 form fields and insert them into one field in the database.
How would I do this?
Thanks.

candelbc
12-07-2004, 11:31 PM
tmpStr = Request.Form("field1") & " " & Request.Form("field2")

Write the tmpStr to the database or cut the variable out by just doing the string concatenation directly in your SQL or Recordset.

Hope this helps..
-Brad