Hi- I am stymied, I'm trying to do a very simple thing, but I must be making a basic error somewhere. I have a page, http://dev.mywebsite.com/customers/index.cfm?fuseaction=newsletter
to allow customers to sign up for our newsletter. I want the form to enter their name and email in a table called newsletter. The form action="act_newsletter.cfm
In act_newsletter.cfm, I have this simple code (trying to make it as simple as possible):
sn#" name ="insertemail">
INSERT INTO newsletter (name, email_address)
Thanks! You have been added to the mailing list!
And I get the error, Element MAINDSN is undefined in REQUEST. I don't understand, for two reasons:
1. Another, much more complex form, http://dev.mywebsite.com//customers/index.cfm?fuseaction=newuser
, which goes to act_add_member,
has this code, and it works:
INSERT INTO users
SELECT @@IDENTITY AS 'id'
and 2. App_local in this folder points to app_global, which points to app_server, which says, in part:
Could someone kindly help me out with this? Thanks so much!