I haven't done CF in a long time but I didn't think I'd have issues with this simple task. I'm using a simple form, simple table in a database, & simple <cfquery> with insert statement. I can't figure out this issue.
My form code (portion):
<form action="submitform.cfm" method="post" name="sponsorform">
<td>First Name: </td>
<td> <input type="text" name="firstname" size="50" /></td>
<cfquery name="sponsorsubmit" datasource="webmas5_sponsor">
INSERT INTO sponsorship
(firstname, lastname, email, hittype, amount, maxamount, message)
VALUES ('#sponsorform.firstname#', '#sponsorform.lastname#', '#sponsorform.email#', '#sponsorform.hittype#', '#sponsorform.amount#', '#sponsorform.maxamount#', '#sponsorform.message#')
I'm getting that 'firstname' is UNDEFINED. I've done a dump of the form and that comes back as empty.
I feel stupid because I can't figure this out!!