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.
<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;"/>
<SelectCommand CommandText="SELECT [EmailAddress] FROM [dnn_ahno_HondaMarchMadness] WHERE [EmailAddress][email protected]">
<parameter name="Bracket" value=[[Form:EmailAddress]] />
<SubmitCommand CommandText="UPDATE [dnn_ahno_HondaMarchMadness] SET [EmailAddress][email protected] WHERE [Bracket][email protected]" />
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?