Hi,
just to make it easier, I am on DNN 7. Im using X Mod Pro to create a file upload system where a user comes on, fills out a quick form with Name, Email etc, and then they are taken to a fileupload page where they can upload their March Madness Brackets onto my server for a contest. Im having an issue with associating the user EmailAddress to the file they upload.
My Code:
<addForm>
<table>
<tr>
<td>
<label for="uplFile" text="Upload File" style="font-weight: bold;"/>
<fileupload id="uplFile" path="~/ConcordHondaMarchMadness/" extensions="gif,jpg,zip,tif" UseUniqueFileName="True" visible="True" datafield="uplFile" datatype="string" style="margin-left: 35px;"/>
</td>
</tr>
</table>
<SelectCommand CommandText="SELECT [EmailAddress] FROM [dnn_ahno_HondaMarchMadness] WHERE [EmailAddress]=@Bracket">
<parameter name="Bracket" value=[[Form:EmailAddress]] />
</SelectCommand>
<SubmitCommand CommandText="UPDATE [dnn_ahno_HondaMarchMadness] SET [EmailAddress]=@Bracket WHERE [Bracket]=@EmailAddress" />
dfsdfdfc [[EmailAddress]]
</addForm>
I tried to add a Bracket field in my SQL table, but it keeps coming back saying it cant inset nulls.
Anyone have any ideas?