Hello EveryBody,
I have a little problem in Sql Statement .. When I am adding a Where condtion to my sql statement ..I got an error shown in the pic blew :
I am waiting for your solution
Best regards,
It means that you have an error in your WHERE clause.
What is the complete SELECT statement?
Don
|||Good eveningdonkiely
,
This is my SQL Statement:
SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued
FROM Products
WHERE CategoryID= @.CategoryID
and this is the erro shown in pic :-
Thank you for your concern
|||
Ah. I'm glad you sent the image. There cannot be a space between the @. and the CategoryID on the right side of the = sign.
Don
Unfortunately, I was trying with no space ..but the same error happen >>
Shown in pic blew:-
Thanks Don
|||
ban:
This is my SQL Statement:
SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued
FROM Products
WHERE CategoryID= @.CategoryID
When I copy and paste that into Query Analyzer and run it against the Northwind database I receive no error. Are you sure that is your exact SQL statement?
|||Dear tmorton,
yes , I am .It is the exact SQL Statemet .
but I am thinking maybe there is missing file on my program or somthing wrong with my keyboard.
I do not konw ,but this is not the first time that error happen to me ,every time I use WHERE Cluase .
I hop to find the solution for it .
anyway thanks to trying help me
Just a silly question, and don't kill me if it sounds really stupid to ask this please!
You are using SQL Server with the default sql server provider, yes?
|||shados
OoOoOOOOOh God I am just a beginner programmer in ASP.NET ... I am so confuse
I did not get it your Q , but I am using a Microsoft Visual Studio .Net 2005 (Full Edition)
This version include Microsoft SQL Server 2005
Note : I can run SQL Statement with this program but I can not use WHERE Clause when it is taking a parameter
I appreciateyour help
|||Okie, that answer my question, you are. All good then, I really don't get what the issue is. I was asking, because different databases have issues with SQL statements like the one you're writting (with parameters in the where clause), so I thought... But thats not the problem, so back to the drawining board >.<
|||shados,
so back to the drawining board
What do you mean by that ?
|||I just meant that my idea was wrong :)|||
Hellow again,
I find the solution for my problem>>>shown in pic blew :-
Not: I am using Microsoft Acess DataBase.
Speical Thanks to >>donkiely ,tmorton,shados
for more info:-
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=874535&SiteID=1&mode=1
Have a nice day!
|||
That's great!!
I find the solution for my problem
Not: I am using Microsoft Acess DataBase.
This is the SQL Server forum. Next time please post in the Access forum. You would have had an answer days ago
Gah, thats why I asked if you were using SQL Server :) In databases like MS Access, PervasiveSQL, a lot of databases accessed through ODBC, etc, you have to use the ? placeholder instead of @.variablename...
Indeed, since this is a SQL Server forum, we all assumed you were using SQL Server, hahahaha. Ahh well, glad you found your problem.
sql