if you wrap the DIM statment to a second line, then that is probally what your problem is. Try doing one of the following:
add a _ to the end of the first line so the script knows to continue to the next line, ex
Dim Firstname, Secondname, Organisation, Position, Address_1, Address_2, Address_3, Postcode, Telephone, Fax, _
Mobile, Web, E-Mail, Request, Service, Therapies, Events, Training, Comments, theDate,sql
add a second DIM statment, ex
Dim Firstname, Secondname, Organisation, Position, Address_1, Address_2, Address_3, Postcode, Telephone, Fax,
Dim Mobile, Web, E-Mail, Request, Service, Therapies, Events, Training, Comments, theDate,sql
The _ character when used in this fasion is basically a line terminator that tells the script that the line contiues on the next line. If you put anything, including comments, after the _, you will also get an error, as ASP expects nothing after it.