Flash 5, ASP & Access Database

[chuksted]

I keep getting Syntax errors when I try to send form input from Flash5 to my Access DB using ASP. Such as:

(1) Microsoft OLE DB Provider for ODBC Drivers error '80040e14' . [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '* myClub where EMail = 'sent to database' and OtherString = '''. /ASP/myClub.asp, line 10.

(2) INSERT INTO myClub(ID, FirstName, LastName, EMail, OtherString) VALUES (,'','','','') . Microsoft OLE DB Provider for ODBC Drivers error '80040e14' . [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. . /ASP/AddRecord.asp, line 16

Please someone help!

[tg]

(1) Microsoft OLE DB Provider for ODBC Drivers error '80040e14' . [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '* myClub where EMail = 'sent to database' and OtherString = '''. /ASP/myClub.asp, line 10.

is this first query supposed to be a select query? try.
"SELECT * FROM myCLub WHERE EMail =' "& variable & " ';"
(notice the single quotes inside the double quotes surrounding the email variable- they are important).
can you show us the specific query that is triggering this error?



(2):
your second query will depend on how you have the myClub table defined. if ID the key field? is it 'Autonumber'?
if so, then remove the ID field from your insert statement, and remove the first ',' from your values list. access will insert the next available number with autonumber. if it is not your key field, but is a number, it probably does not like inserting a null value into that field, try zero(0).