Where's the "insert into" clause?
**********************
Thanks for your help. I have another question. Normally this query works
(in Access):
<cfquery name="insertinfo" datasource="test1">
.... something is missing here ... like "insert into mytable" ...
(FirstName, LastName, Email, Address, City, State, ZipCode, DOB, Phone,
QuestionOne, QuestionTwo, QuestionThree, QuestionFour, QuestionFive)
Values
('#form.first#', '#form.last#', '#form.address#', '#form.city#',
'#form.state#', '#form.zip#', '#variables.dob#', '#variables.phone#',
'#form.cupsaday#', '#form.howoften#', '#form.typesofcoffee#',
'#form.percentprepared#', '#form.otherbrands#')
</cfquery>
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
