SQL Statement searching 1 table for a lot of diff fields :\ need help

ASP Free Forums Sponsor:

September 6th, 2004, 10:02 PM

asp_rin

Registered User

Join Date: Sep 2004

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

SQL Statement searching 1 table for a lot of diff fields :\ need help

SELECT *
FROM Results_Public
WHERE Animal_Identifier LIKE 'varanimalid%' AND
Breed LIKE 'varbreed%'AND
Gender LIKE 'vargender1' AND ' checkbox if selected show male
Gender LIKE 'vargender2' AND ' checkbox if selected show female BUT if both are selected show all records for both male & female right now it shows all if none selected & none if both selected
ShortName LIKE 'varshortname%' AND
RegName LIKE '%varregname%' AND
RegNumber LIKE 'varregnumber%' AND

Any help if need more info please let me know AIM = nidplaydo

September 6th, 2004, 11:59 PM

sbaxter

Moderator: Access, SQL

Join Date: Oct 2003

Posts: 5,126

Time spent in forums: 4 Days 1 h 2 m 51 sec
Reputation Power: 13

What exactly is the problem?

Post all the code you are using with the SQl statement

S-

Viewing: ASP Free Forums > Database > SQL Development > SQL Statement searching 1 table for a lot of diff fields :\ need help

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump