I'm having probs with this sql, I know it's something to do with the LIKE operator. I'm tring to see if there are any instances of a single letter from one field in a comma seperated list in another field. Code:
View RepliesI have one string (strWeekday) which contains a single day of the week like 'monday' and another string (strDeldays) which can contain one day of the week or multiple days of the week seperated by commas like 'monday, tuesday, wednesday, thursday, etc'.
I want to execute some lines if strWeekday is equal or may contain one of the days in strDeldays. I do not know what operator and what syntax to use for this.
Does anyone know how to convert this peice of
php code to asp?
Quote:
$xxpop= $variable1|$variable2|$variable3|$variable4
I am having problems understanding the ASP equvilent of the " | " bitwise operator.
I have 6 textboxes where if I fill them up I want the query to search if either one of them has results found. I have this but it's not working: Code:
View Replies View RelatedBasicly I pull the whole column contents and what to test to see if the username is that list. How can I do this in an if statement. I know how to do this kind of thing in SQL (LIKE operator) but I need to test agains two recordsets. Code:
View Replies View Relatediam trying to insert some data into a database but i keep getting the above error msg this is the line that is causing the problems any ideas?
Code:
sql3 = "Insert INTO course_dates ([Course_Id], [Course_Heading], [Course_Title], [Week_No], Status) VALUES ("&courseid&", "&course&", "&title&", "&weekno&", "&status&")"
here is what is printed when I response.write the sql3 statement
Insert INTO course_dates ([Course_Id], [Course_Heading], [Course_Title], [Week_No], Status) VALUES (285, NEBOSH, test, Week One, TBA)
my SQL keeps coming back with the following error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Clients.Area_ID = 3 AND Clients.Category_ID = 7 OR WHERE Clients.Category_ID = 7 AND Clients.All_Areas = true'.
I am trying to pull out all records where area and category match, aswell as all records where category match and all_areas = true
Any suggestions as to where I am going wrong?
Code:
i have a drop down list that populates a table based on the user input. The table than has some products, I'm trying to have the product name link to another page with full details about the product. I'm close but just need some help with the sql. The sql is:
"Select * FROM tablename WHERE ID =" & request.Form("ID")
ID is defined as autonum in the database, the error message i'm getting is:
Syntax error (missing operator) in query expression 'ID ='.
1) I'm getting this error: Syntax error (missing operator) in query
expression on the below statement. Can I get some advice.
2) I searched ASPFAQ and came up blank. Where can find the "rules" for when
and how to use single quotes and double quotes in ASP? Code:
I'm getting this error:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression ''I'm not really sure what all that stuff means. Do you have the divider pages with the tabs to stick in and organize things? If so i'll take 10 of those too. Thanks.''.
/employee_forms/testing/databaseclerical.asp, line 60
when running this code: .....
I'm getting this error:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression ''I'm not really sure what all that stuff means. Do you have the divider pages with the tabs to stick in and organize things? If so i'll take 10 of those too. Thanks.''.
/employee_forms/testing/databaseclerical.asp, line 60
when running this code: ....
Any ideas why im getting this error from these lines of code?
" WHERE [Personnel].p_id = [specialists].[p_id] " & _
" AND*[specialists].spu_id = " & Cint(Request.form("spec"))
valuA = (request.form("toadd"))
If valuA = "" then
SQL = "UPDATE CourseReg SET attended='Active' WHERE ID
IN("&request.form("toadd")&")"
Set RS = MyConn.Execute(SQL)
End If
MyConn.Close
Set RS = Nothing
Set MyConn = Nothing
the error
syntax error (missing operator) query expression ID IN ()
First time poster here but I've spent a while lurking and reading the great threads here
I've got a problem that I've wrapped my head around for a few days and I can't seem to figure it out.
Im using ASP with Access 2000 DB. I want to perform a simple lookup by ID (AutoNumber in Access) and it says I am missing an operator. Code:
I am trying to insert values into a database using an sql statement that i read from a table that contains all my different sql commands. The sql statement is stored in the following way in the table: Code:
View Replies View RelatedI am recieving the Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression when updating data that contains single quote marks, for example: Code:
View Replies View RelatedI'm trying to pass a piece of data i get from a query using a different form's passed values. This is how I get the data into the new form and how I try to pass it to the next asp page query.
<td valign=TOP width="168"><form action="HouseDetail.asp" method="post" name="MLS" id="MLS"><input name="MLS" type="hidden" value='<%=oRs("ML_Number")%>'><input name="Submit2" type="submit" value="Get Details"/></form></td>
The value='<%=oRS(ML_Number")%>' generates a real value like '2403943' - and the field I'm trying to use this value in the qry is expecting a number. But even passing the number without the single ' at both ends generates the same error message. Code:
I am working on a project using an access db. Here is the problem.
Error
Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression 'unit=6400s'
Unit is what it is suppose to be, I don't understand why I am getting this error? Here's the code for this part.
Code:
sql="SELECT * FROM " & tableStr & " WHERE Model=" & unitStr
tableStr and unitStr are variables. Table and unit are passed into the page and are assigned to the two variables through a request.querystring().
This is the sql statement:
sqlquery="SELECT * FROM tblrequest WHERE Req_id= " & Req_id & " "
set rs=con.execute (sqlquery)
Req_id is coming from a form like so:
Req_id=request.form("Req_id")
The error is:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Req_id='.
On the first line of the query.
See anything wrong that would cause this error?
Please help, the Req_id is being sent from previous form via a hidden value hope i'm requesting this properly.
I cant seem to get the LIKE oprator to work in asp.
I am trying to verify e-mail input format by using
request("email") like "*@*.*"
but it returns "sub or function not defined"
any suggestions?