Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multiple table insert
JHoarty, Thanks for the help! I have added the single quote as you suggested. I am now returning another error: Error Diagnostic Information ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3. Hint: The cause of this... -
Multiple table insert
Thanks for the reply. This is what I have setup so far: 'Admin Page' <FORM action="insert.cfm" method="post"> <select type="text" name="section1"> <option>less than 15 minutes</option> <option>less than 30 minutes</option>... -
Multiple table insert
Also, the information on the form is a drop-down list that the user selects from. I try to get the form to submit but I keep getting the error Syntax Error(missing operator) in query expression. Help -
Multiple table insert
Sorry, I should add more details. A bit brain dead right now... I have a form that submits four values to be added to four different tables. -
Multiple table insert
Is it possible to cfinsert to multiple tables? How would I do this? Newbie
