Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > WHERE Statement Help

Reply
Thread Tools

WHERE Statement Help

 
 
Simon Gare
Guest
Posts: n/a
 
      06-18-2006
Hi,

cant get to grips with this problem, need to select from dbo.booking_form
all records that meet 2 statements. 1st allocated='completed' and 2nd
account is not 'CASH' , i.e. all records that don't contain the word CASH in
the field 'ACCOUNT' Below is the beginning just don't know the syntax for
NOT, have tried several option but to no avail.

Pricing.Source = "SELECT * FROM dbo.booking_form WHERE allocated =
'COMPLETED' AND

Thanks in advance.

Simon


 
Reply With Quote
 
 
 
 
Mike Brind
Guest
Posts: n/a
 
      06-18-2006

Simon Gare wrote:
> Hi,
>
> cant get to grips with this problem, need to select from dbo.booking_form
> all records that meet 2 statements. 1st allocated='completed' and 2nd
> account is not 'CASH' , i.e. all records that don't contain the word CASH in
> the field 'ACCOUNT' Below is the beginning just don't know the syntax for
> NOT, have tried several option but to no avail.
>
> Pricing.Source = "SELECT * FROM dbo.booking_form WHERE allocated =
> 'COMPLETED' AND
>
> Thanks in advance.
>
> Simon


Pricing.Source = "SELECT * FROM dbo.booking_form WHERE allocated =
'COMPLETED' AND accounts <> 'CASH'

--
Mike Brind

 
Reply With Quote
 
 
 
 
Simon Gare
Guest
Posts: n/a
 
      06-18-2006
Thanks Mike

"Mike Brind" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed) oups.com...
>
> Simon Gare wrote:
> > Hi,
> >
> > cant get to grips with this problem, need to select from

dbo.booking_form
> > all records that meet 2 statements. 1st allocated='completed' and 2nd
> > account is not 'CASH' , i.e. all records that don't contain the word

CASH in
> > the field 'ACCOUNT' Below is the beginning just don't know the syntax

for
> > NOT, have tried several option but to no avail.
> >
> > Pricing.Source = "SELECT * FROM dbo.booking_form WHERE allocated =
> > 'COMPLETED' AND
> >
> > Thanks in advance.
> >
> > Simon

>
> Pricing.Source = "SELECT * FROM dbo.booking_form WHERE allocated =
> 'COMPLETED' AND accounts <> 'CASH'
>
> --
> Mike Brind
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
if statement that, when false, skips first statement in its block, executes second? Jay McGavren Java 11 01-16-2006 05:49 PM
How do I do a conditional statement in a constant statement? tkvhdl@gmail.com VHDL 3 12-16-2005 06:13 PM
Which of switch statement and if-else statement takes less time to execute? swaroophr@gmail.com C Programming 21 08-02-2005 09:24 AM
exec "statement" VS. exec "statement in globals(), locals() Ted Python 1 07-22-2004 08:51 AM
exec "statement" VS. exec "statement" in globals(), locals() tedsuzman Python 2 07-21-2004 08:41 PM



Advertisments