"WHERE" to now ??

	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

"WHERE" to now ??

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 >> "WHERE" to now ??

Page: [1]

baldcat

Posts: 41
Joined: 6/30/2005
Status: offline

"WHERE" to now ?? - 7/21/2005 1:55:53

righto,,,

Getting the hang on this.. But have come across another little snag..

I have this SQL that filters certain data for me... Now there is a column that has 3 different entries... 'O', 'I', and 'S'
O = On order
I = In Stock
S = Sold

My SQL is as follows,

SELECT *
FROM EMMG.VDM
WHERE stock_no LIKE 'R%' AND stk_status = ???

I did have

stk_status = 'I'

But I need to display stuff on order as well.
So how can I just get so it filters out everything with 'S'


rubyaim Posts: 757 Joined: 6/22/2005 Status: offline	RE: "WHERE" to now ?? - 7/21/2005 2:05:30 Maybe use stk_status <> 'S' ? Worth a shot, I've got that on a query here and it works Sally (in reply to baldcat)


baldcat Posts: 41 Joined: 6/30/2005 Status: offline	RE: "WHERE" to now ?? - 7/21/2005 2:17:01 It is a beautiful thing Sal,, SELECT * FROM EMMG.VDM WHERE stock_no LIKE 'R%' AND stk_status <> 'S' Cheers (in reply to rubyaim)

Page: [1]

All Forums >> Web Development >> ASP and Database >> "WHERE" to now ??

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts