Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

ASP.NET Forum


You are currently viewing our ASP.NET Forum as a guest. Please register to participate.
Login



Reply
What is the meaning of this?
Old 02-12-2008, 12:46 AM What is the meaning of this?
Extreme Talker

Posts: 216
Trades: 0
Can you tell me what this error means? And maybe how to resolve it?
thanks

Code:
SELECT * FROM mms_tbl_membershipType WHERE ID = 3 
Microsoft OLE DB Provider for SQL Server error '80040e14' 
Line 1: Incorrect syntax near '='. 
/home/_register_2.asp, line 80
chrisj is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 02-12-2008, 02:45 AM Re: What is the meaning of this?
ADAM Web Design's Avatar
Canadastaninianite

Posts: 5,938
Name: Adam for web page design, not program
Location: Toronto, Ontario, Canada
Trades: 0
Usually it means one of two things:

1) ID is a different data type than you're referencing in the query. In this case, ID appears to be a number, but it could be text...in which case you'd need to say ID='3'.

2) There's nothing after the = sign in the query. Assuming that query you posted is the actual query being used, this doesn't appear to be the case.
__________________

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
(my blog)


Please login or register to view this content. Registration is FREE
(with proof)
ADAM Web Design is offline
Reply With Quote
View Public Profile Visit ADAM Web Design's homepage!
 
Old 02-14-2008, 07:59 AM Re: What is the meaning of this?
itHighway's Avatar
Skilled Talker

Posts: 83
Name: Zeeshan Dar
Location: GUJ
Trades: 0
Adam is right, Check column "ID" data type.
__________________
Zeeshan Dar
itHighway -
Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
itHighway is offline
Reply With Quote
View Public Profile
 
Old 02-14-2008, 12:18 PM Re: What is the meaning of this?
Extreme Talker

Posts: 216
Trades: 0
thank you
chrisj is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to What is the meaning of this?
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.44106 seconds with 12 queries