Exception occurred.

Hi,

can anyone help me out in the file post_message.asp i
i m also sending you both the asp files. plz debug its error ASAP.

i will be very thankfull to you...

Error Type:
(0x80020009)
Exception occurred.
/advice/post_message.asp, line 23

It could be a number of things...

http://www.aspfaq.com/show.asp?id=2421

i m checked that link before and i didnt understand whats the problem with it... thats why i have send you the files and the DB to check what am i doing wrong in the code.

plz help me

Put;

Set myConnection =

in front of code on line 23 and tell me if it works. So it will read...

Set myConnection = obj.execute("SQL STUFF HERE")

Error Type:
Microsoft JET Database Engine (0x80040E14)
The INSERT INTO statement contains the following unknown field name: 'subject'. Make sure you have typed the name correctly, and try the operation again.
/advice/post_message.asp, line 23

that's a pretty straight forward error, you don't have the field 'subject' in your mdb, I just checked. Add it to the Question table and try again.

ok now it is working
thanks a lot...

np.

now it is working only for one select field means Beauty and not for others means the data is not inserting in the DB if i choose any other category other then beauty.

Error Type:
(0x80020009)
Exception occurred.
/advice/post_message.asp, line 23


the same error is comming again

Please restate, I don't understand what you just said.

when i use form to insert data then it only inserts data when Beauty is selected form the select menu on the form other wise it generates the same error.

Ok, here comes the part where you need to do a little leg work. First you need to print the values of each of the form requests to insure the data... example

Response.Write(ecat) & "<br>"
Response.Write(fname) & "<br>"
Reponse.Write(esubject) & "<br>"
Response.Write(email) & "<br>"
Response.Write(emessage) & "<br">
Response.End()

This will show you what data you are actually getting. This is more than likely your issue.

Second, if this looks ok check your sql string by doing...

Response.Write("insert into question (cat_id,member_id,fname,uemail,subject,description ,ques_date) values("& _
ecat &","& rs("memberid") &",'"& fname &"','"& email & "','" & _
esubject &"','"& emessage &"','"& date_input &"') ")

Response.End()

This should help you see what your doing better.