I have a problem with my SQL, all the other statements i have written work so I can't understand why this one isn't!!
sql = "Select * From Skills Where StampNo = " & Stamno & " Cell = " & cell & " And Op-Number = '" & op & "' "
Syntax error (missing operator) in query expression 'StampNo = Test25 Cell = E&M And Op-Number = '80''.
Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression 'StampNo = Test25 Cell = E&M And Op-Number = '80''.
I can't see what i have got wrong!!
if anyone an see what I have done wrong it would be much appreciated!
It looks like you are missing an operator (AND or OR) in your statement.
This translates to SELECT * FROM skills WHERE StampNo = someValue Cell = cellValue AND Op-Number = opValue.
So you can see you're missing an operator between somevalue and Cell.
If there was no data being returned would i see this error?
but there should be returned data as I am making sure that I am selecting things I know are there!
it will work with an sql command like " select * from skills where StampNo = " & stamno & " "
I changed the name of some of my vairables and column names and it now works!
sql = "Update Skills Set Competence = " & comp & " AND DateAchieved = '" & Adate & "' Where RecordNo = " & record & " "
asp.net password hashing sha1 different from sql server 2008 hasing .