ASP connecting to Access - Please Help

[MightyMouse]

Afternoon!

I've got the following:

1. A access database.
2. A .htm file that accepts input.
3. A asp (action) page that sql_insert the data into the database.
4. A page showing all entries in the database.

When you enter data on the .htm page and hit "submit" you get the
following...


----------------------------------------------------------------------------
--
Microsoft VBScript compilation error '800a0409'

Unterminated string constant

/form_action.asp, line 35

sql_insert = "insert into appl (name, surname, age, sex, email, currentjob,
livingarea, areacode, telephone, comments) values
----------------------------------------------------------------------------
----------------------

dunno if this is enough information...
Please Help
MightyMouse

[Ed Courtenay]

You've missed the terminating quotation mark...

sql_insert = "insert into appl (name, surname, age, sex, email, currentjob,
livingarea, areacode, telephone, comments) values"


"MightyMouse" <strauss@mighty.co.za> wrote in message
news:3b1b7c6f@news.devx.com...
> Afternoon!
>
> I've got the following:
>
> 1. A access database.
> 2. A .htm file that accepts input.
> 3. A asp (action) page that sql_insert the data into the database.
> 4. A page showing all entries in the database.
>
> When you enter data on the .htm page and hit "submit" you get the
> following...
>
>
> --------------------------------------------------------------------------
--
> --
> Microsoft VBScript compilation error '800a0409'
>
> Unterminated string constant
>
> /form_action.asp, line 35
>
> sql_insert = "insert into appl (name, surname, age, sex, email,
currentjob,
> livingarea, areacode, telephone, comments) values
> --------------------------------------------------------------------------
--
> ----------------------
>
> dunno if this is enough information...
> Please Help
> MightyMouse
>
>

[Andrew King]

Also missing all the values to insert

Values ("John", "Doe", etc )

or if getting the values from the form

VALUES('" & Request("name") & "', '" & Request("surname") & "', etc)


Andrew