<td><input type="text" name="City" size="20"></td><BR>'pass this data to next processing page:<BR>'Contents of next page is exactly the following:<BR><%<BR>' Write record to the database<BR> Set Cm = Server.CreateObject("ADODB.Command")<BR> Cm.CommandType = 1<BR> Cm.ActiveConnection = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=g:(path to your database).mdb;"<BR> City=request("City")<BR> Cm.CommandText = "INSERT INTO YourTable(FieldCity) VALUES ('"&City&"');" 'separate all values with commas, the value will be identical to the "request("City") above<BR> 'Response.write(Cm.CommandText) 'check to see what was passed<BR> Cm.Execute<BR>%><BR><BR>Let me know if this doesn't help... or does.<BR>
Maybe my question ws confusing. I didn't intend to add a record to a table but to add a field to the table. With your exampe:<BR><BR>if in YourTable FieldCity does not exist yet, how do I create it "on the fly?"
Does the column exist in the database at all? If not, I don't know of any way to fill a field that doesn't exist, if that's what you mean.<BR><BR>If the field is simply blank, then I would just use an <input type="text" value=<%=database info%> blah blah blah> to modify the field then re-submit.