June 8th, 2013, 06:50 PM
[RESOLVED] Error code help needed
Hi Folks.. I am a real newbie to this... no real knowledge about programming but keen to learn. I am playing with some code at the moment that should return a message that a 'category' has been added to an Access Database and another bit checking to see that if a no value is entered it writes an error message. I can't get the **** thing to work and think I may have tried to run before I can walk. saying that if there are no values. The error message I get is ...
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'TypeId ='.
it makes reference to line 67 in the code but I can't find anything there that may be wrong
and the code I am using is
Dim Flag, Query
' If the Category Name field is empty, and the form has been submitted:
If Request("TypeName")="" Then
If Flag Then
Response.Write "<p class='subtitle'>You must enter a cateogry name.</p>"
' If Flag isn't true, show the edit form:
Set CategoryRS = Server.CreateObject("ADODB.Recordset")
CategoryRS.Open "SELECT * FROM Type WHERE TypeId =" & Request("iType"), Connect, 2, 3
Sorry for being such a thicko but can anybody out there please help me ???
thanks to you all who take an interest in these and help us newbies sort things out.....
Tags for this Thread
Click Here to Expand Forum to Full Width