Using the OR command in IF

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Using the OR command in IF

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Using the OR command in IF

Page: [1]

awildish

Posts: 6
From: None
Status: offline

Using the OR command in IF - 10/3/2001 20:34:00

I've created an SQL statement which I'm using in ASP but I can't for the life of me remember how to write a long statement with several OR commands. Can anyone help... this is what I've got:

SELECT Author, Title, Date, Context, Description, Location FROM DisasterAudit WHERE Author LIKE '%" + Replace(disasterRSQry__MMColParam, "'", "''") + "%'" or Title LIKE '%" + Replace(disasterRSQry__MMColParam, "'", "''") + "%'" or Date LIKE '%" + Replace(disasterRSQry__MMColParam, "'", "''") + "%'" or Context LIKE '%" + Replace(disasterRSQry__MMColParam, "'", "''") + "%'" or Description LIKE '%" + Replace(disasterRSQry__MMColParam, "'", "''") + "%'" or Location LIKE '%" + Replace(disasterRSQry__MMColParam, "'", "''") + "%'"

I expect it's something quite simple but it's baffling me!!!