Reply
What is the meaning of this?
Old 02-11-2008, 11:46 PM What is the meaning of this?
Super Talker

Posts: 115
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
 
When You Register, These Ads Go Away!
     
Old 02-12-2008, 01:45 AM Re: What is the meaning of this?
ADAM Web Design's Avatar
Canadastaninianite

Posts: 5,945
Name: Adam for web page design, not program
Location: Toronto, Ontario, Canada
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.
ADAM Web Design is offline
Reply With Quote
View Public Profile Visit ADAM Web Design's homepage!
 
Old 02-14-2008, 06:59 AM Re: What is the meaning of this?
itHighway's Avatar
Average Talker

Posts: 23
Name: Zeeshan Dar
Location: GUJ
Adam is right, Check column "ID" data type.
__________________
Zeeshan Dar
itHighway - web design development custom e-commerce solution & web based real estate listing software services provider
itHighway is offline
Reply With Quote
View Public Profile
 
Old 02-14-2008, 11:18 AM Re: What is the meaning of this?
Super Talker

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

Thread Tools

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
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.12397 seconds with 13 queries