Where Clause

I am trying to modify the code in an existing ASP page that displays records when it runs. The code in the where clause I wish to change is as follows:

where_clause = where_clause & "[DateWOCancelled] Is Null And IsNull([ACT_IS]) And ([PROP_IS] < Now())"

This works fine, but I need to have the clause also evaluate another field (Rev_IS) to see if it contains a date, and if it does check to see if it is < Now(). If the Rev_IS is not null, I don't care any longer about the date contained in Prop_IS. I only want to evaluate if Rev_IS < Now().

View Replies


ADVERTISEMENT

Limit Clause

I'm starting in asp and I'm trying to do a simple sql query to display a number of records on a page using the limit clause. I keep getting a syntax error in my from clause. Here's what I'm doing:Code:

rstProd.Source = "SELECT * from TBL_PRODUITS LIMIT 0,10"

I have no problem using this clause with PHP so I was wondering if there's some restrictions with it in ASP??

View Replies View Related

WHERE Clause Calculation

I am using the DateDiff function to compare two dates in a query on a page. I then need to use the "Expression" created from that DateDiff function in a WHERE clause calculation, but it is not working correctly.

The page loads successfully with thre recordset populated, but the WHERE clause has no effect on the data. I'm guessing that I am doing something very wrong, but I have been staring at this for hours with no avail!

CODE:

View Replies View Related

Process IF Clause

Got a bit of code, which I want to loop through, unless the current value is "", in which case I need it to skip to the next one, but how do I do it?


Response.Write "<br />" & vbCrLf
For Each strItem In Request.Form
If strItem = "" THEN
'these next two lines, I only want to be processed if the above does
have a value in it
Response.Write "-" & strItem & "-" & vbCrLf
Response.Write "-" & Request.Form(strItem) & "<br />" & vbCrLf
End If
Next
Response.Write "<br />" & vbCrLf

View Replies View Related

Order By Clause Conflicts

Im getting this error below:

Microsoft JET Database Engineerror '80004005'

ORDER BY clause (cat_ID) conflicts with DISTINCT. /Artists.asp, line 102

From this code:

strsql = "SELECT distinct art_Artist FROM " &_
"eventDisplay " &_
"ORDER BY cat_ID "

View Replies View Related

Syntax Error In FROM Clause

I am trying to connect Flash with ASP. I did few examples successfully, but I am stack on this one and I get error from the sql statement. I dont see anything wrong with it. The code is:

set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("example.mdb")
conn.Open
set record = Server.CreateObject("ADODB.Recordset")
query = "SELECT * from TABLE WHERE NAME= " &action1
record.Open query, conn

The error which I get is:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

View Replies View Related

MoveNext Does Not Work When Using ORDER BY Clause?

When I create a ADODB.RecordSet object and then try to loop through the results, everything works fine, unless when I am done looping through the results I need to call the movefirst on the recordset object. If I happen to have used an ORDER BY in my SQL, it bombs out. Code:

View Replies View Related

Displaying Query Results Per Where Clause

I am trying to design a page that displays data from a query in groups of a field in the where clause and then displays a 'total' per each group. Code:

View Replies View Related

Syntax Error FROM CLAUSE LINE 26

What does this error means?

View Replies View Related

Select Statement Where Clause = Date

i got a field named register_date, its input a table named member when a user register in my system, What im trying to do is i want to display daily registration in seperate table, anyway the database im using is mdb file, and data type for register_date is data/time.

so below is my coding, but i can get the table to be displayed, can someone tell me what wrong with my coding? Code:

View Replies View Related

Empty Recordset When Using Array Element In WHERE Clause

I have created the following code to create the recordset rsToBeApprovedLocalItemID. Unfortunately, the for next loop works properly only on the first cycle. The response.write(arrToBeApprovedCatSub(0)&arrToBeApprovedCatSub(1)&"<br>")works for each loop but the SQL statement sqlToBeApprovedLocalItemID returns a populated recordset only on the first loop.

On subsequent loops it is empty even though the arrToBeApprovedCatSub(0) and arrToBeApprovedCatSub(1) are alive and well. What's going on? This is truly weird behaviour. I have not come across something this funky before. Code:

View Replies View Related

LEFT JOIN On A Date Field And A Numerical Field - Using WHERE Clause

I am using a Relational database for my site and i have the following tables:

FIXTURES, GAMEDATES

the fields in FIXTURES are:

GameDate
Home
Away

(All of the above are numerical fields)

the fields in GAMEDATES are:

DateID(integer)
GameDate(#Date Field#)

What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)

The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:

WHERE Fixtures.GameDate<=(Date())

obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.

The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.

Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data

View Replies View Related

"where" Clause :: ODBC Drivers Error '80040e14'

Why is it that whenever I press "search" it's saying:

SELECT * FROM bible WHERE verse_spoke LIKE '%jehovah%'%' AND ( spokes = '004') AND ( recordType = 'gn' OR recordType = 'is' OR recordType = 'ro')
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression 'verse_spoke LIKE '%jehovah%'%' AND ( spokes = '004') AND ( recordType = 'gn' OR recordType = 'is' OR recordType = 'ro')'.

/amos.asp, line 161

Here is the code: ......

View Replies View Related

Error: Syntax Error In FROM Clause

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
----------------------------------------------------------------------------------

Yes, I know this question has been answered a million times, however, I've already searched through this forum and my problem still hasn't been resolved.

Basically, I keep getting the error above whenever I try to execute this code. This code is from a search page entitled search.asp.

Here's my code:

View Replies View Related

Error :: Syntax Error From Clause

What does this error means? 'Syntax Error From Clause'.

View Replies View Related

"IN" Clause

I'm developing an ASP app where a user can choose from several categories (selecting multiple), and display results of records that contain these categories. Each Record has the fields Category1, Category2, Category3, Category4. I created a script to parse the selected categories, and include them with an "IN" clause in the SQL query (using ACESS 2000 database). Here is an example:

Select * From [Members] where (category1 IN ('Photography/Video',' E-Learning',' PR/Marketing/Media Relations')) or (category2 IN ('Photography/Video',' E-Learning',' PR/Marketing/Media Relations')) or (category3 IN ('Photography/Video',' E-Learning',' PR/Marketing/Media Relations')) or (category4 IN ('Photography/Video',' E-Learning',' PR/Marketing/Media Relations'));

when I select more than 1 Category, not all records appear. For instance, in the above statement, all records with "E-Learning" as one of the categories do not appear in the recordset. Perhaps there is a better way of writing the SQL statement that I am not aware of.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved