ASP Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsProgrammingASP Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old March 5th, 2004, 07:41 AM
shrry8 shrry8 is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2003
Posts: 32 shrry8 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 43 m 37 sec
Reputation Power: 15
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
Attached Files
File Type: zip error_f.zip (80.3 KB, 364 views)

Reply With Quote
  #2  
Old March 5th, 2004, 08:23 AM
adurstew's Avatar
adurstew adurstew is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2002
Location: Charlotte, NC
Posts: 114 adurstew User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 33 sec
Reputation Power: 16
Send a message via AIM to adurstew Send a message via Yahoo to adurstew
It could be a number of things...

http://www.aspfaq.com/show.asp?id=2421
__________________
Andrew J Durstewitz
ASP.NET,VB.NET,SQL Developer

http://madashellnc.blogspot.com

Reply With Quote
  #3  
Old March 5th, 2004, 08:31 AM
shrry8 shrry8 is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2003
Posts: 32 shrry8 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 43 m 37 sec
Reputation Power: 15
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

Reply With Quote
  #4  
Old March 5th, 2004, 08:36 AM
adurstew's Avatar
adurstew adurstew is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2002
Location: Charlotte, NC
Posts: 114 adurstew User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 33 sec
Reputation Power: 16
Send a message via AIM to adurstew Send a message via Yahoo to adurstew
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")

Reply With Quote
  #5  
Old March 5th, 2004, 08:51 AM
shrry8 shrry8 is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2003
Posts: 32 shrry8 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 43 m 37 sec
Reputation Power: 15
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

Reply With Quote
  #6  
Old March 5th, 2004, 08:55 AM
adurstew's Avatar
adurstew adurstew is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2002
Location: Charlotte, NC
Posts: 114 adurstew User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 33 sec
Reputation Power: 16
Send a message via AIM to adurstew Send a message via Yahoo to adurstew
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.

Reply With Quote
  #7  
Old March 5th, 2004, 08:58 AM
shrry8 shrry8 is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2003
Posts: 32 shrry8 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 43 m 37 sec
Reputation Power: 15
ok now it is working
thanks a lot...

Reply With Quote
  #8  
Old March 5th, 2004, 08:58 AM
adurstew's Avatar
adurstew adurstew is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2002
Location: Charlotte, NC
Posts: 114 adurstew User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 33 sec
Reputation Power: 16
Send a message via AIM to adurstew Send a message via Yahoo to adurstew
np.

Reply With Quote
  #9  
Old March 5th, 2004, 09:13 AM
shrry8 shrry8 is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2003
Posts: 32 shrry8 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 43 m 37 sec
Reputation Power: 15
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

Reply With Quote
  #10  
Old March 5th, 2004, 09:17 AM
adurstew's Avatar
adurstew adurstew is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2002
Location: Charlotte, NC
Posts: 114 adurstew User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 33 sec
Reputation Power: 16
Send a message via AIM to adurstew Send a message via Yahoo to adurstew
Please restate, I don't understand what you just said.

Reply With Quote
  #11  
Old March 5th, 2004, 09:38 AM
shrry8 shrry8 is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2003
Posts: 32 shrry8 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 43 m 37 sec
Reputation Power: 15
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.

Reply With Quote
  #12  
Old March 5th, 2004, 10:09 AM
adurstew's Avatar
adurstew adurstew is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2002
Location: Charlotte, NC
Posts: 114 adurstew User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 33 sec
Reputation Power: 16
Send a message via AIM to adurstew Send a message via Yahoo to adurstew
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.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingASP Development > Exception occurred.


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap