I'm having a problem With Query5, inserting the 'HF' variable into the DB, PF and HF both print out correct values when asked to do so. I think its a problem with my SQL query syntax but i'm at a loss as to what could be wrong.
The Error the Browser sends is - "Expected end of statement" Code:
I just decided to leave Mssql and start using Mysql. I am having some problems with my queries; is there anyone here who has a knowledge of query syntax in Mysql?
Is it possible to use IIF function in SQL query?like that for example:
objCommand.CommandText = "Select WCUST, IIF(Sum(WQTY2002) Is Not Null, ((Sum(WQTY2003)-Sum(WQTY2002)) * 100/Sum(WQTY2002)),Null) AS ChangeUnits, IFF(Sum(WAMT2002) Is Not Null, ((Sum(WAMT2003)-Sum(WAMT2002)) * 100/Sum(WAMT2002)), Null) from tabTest group by WCUST;"
I'm working on a page so that a user can change their password. I thought might be a simple update of a database, but everytime I do it I get the following error message. I've put x's where my ID would be showing for security purposes. Code:
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
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
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 execute the following SQL Statement:
SqlApp1 = "INSERT INTO LeagueStore (Team, Played, Wins, Loses, Draws, For, Against, Points) SELECT (Team, Played, Wins, Loses, Draws, For, Against, Points) from HomeWins WHERE postponed=''"
But i am getting the following error message:
Syntax error (comma) in query expression '(Team, Played, Wins, Loses, Draws, For, Against, Points)'.
And i dont know why. All of the fields are numerical apart from TEAM is that helps.
All i want to do is Insert data from one table into another but i cant use SELECT * because one table has one extra field to the other and when i tried to amend the SQL to look like this:
SqlApp1 = "INSERT INTO LeagueStore (Team, Played, Wins, Loses, Draws, For, Against, Points) SELECT * from HomeWins WHERE postponed=''"
i get this error:
Number of query values and destination fields are not the same
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:
I 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:
I'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.
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().
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
In Access you use "*" + [passed variable] + "*", + can be replaced with & Calling a parameterized query in Access requires % be used in place of *, however, all that I have read show dynamic SQL passed to Access:
WHERE [some column] LIKE '" & ASPvar & "' % ORDER BY ...
However, my call is similar to:
conn.qMyLookup strVar, rs
If I modify the query in Access to:
"%" & [passed variable] & "%"
I get all records. If I only put it at the end, as suggested, I only get matches at the end, not throughout the column. Code:
I'm just trying to display a user's FIRST name and the FIRST INITIAL of the last name on my asp web page. This works to displays their "firstName" and "lastName":
Code: <%=oUsers("firstName")%> <%=oUsers("lastName")%> But I get a variety of vbscript or asp syntax errors when I try to trim the "lastName" using something like
Code: <%=oUsers("firstName")%> <%=oUsers(replace(left("lastName",1))%> How do get this simple task done?
(If it makes any difference, the whole thing is inside html <td></td> tags as part of a table)
The WHERE part of my select needs to pull out where the date column is empty. If there isn't a date, it shows NULL in the database (SQL7)."WHERE eligibility_dt <> NULL" doesn't work. what am i forgetting?
I believed that there is a wrong syntax on the window.open line...Can anyone spot it ? Code: strLocation = "Sch_As_FollowAct.asp?drvid=" & request("drv") & "&u=" & uday(0)
i am having some trouble rembering the correct syntax for a If Then Statement here is my code.
<% If Request.QueryString("access") = "false" Then %> <tr> <td colspan="2" bgcolor="#FFFFFF" class="mediumRed">The User ID and Password combination has failed.<br> <br> Please try again.</td> </tr> <% Else If rsGettblCouples.Fields.Item("StopDate") = "1/1/1900" Then %> <tr> <td colspan="2" bgcolor="FFFFFF" class="mediumRed"> The User has already<br> completed the online scoring.<br>Please Contact your facilitator.</td> </tr> <% End If %> <% End If %>
Can someone direct me a set of rules for building strings in ASP? I'm always getting stuck on when to use a quote (") or apostrophe{'} or both. This simple string is giving me fits...