I am trying to sort my data based on two values at the same time.  One is a

constant pclientid should always equal shorma.  So I am trying to search for

patients info by their last name for one client so that client will not see

all of my clients patients.  My current sql statement is as follows



strSQL = "SELECT pdebtrno, PSSN, plastname, pfirstname, pclientid FROM

tblPatient where Plastname LIKE '" & name & "%' "





name is being brought from a form but I also want the filter to be sorted

where pclientid is "shorma"  how do I do both filters on one sort?







--- 

NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?

Visit EarthWeb for the latest in IT Management, Software Development, 

Web Development, Networking & Communications, and Hardware & Systems.  

Click on http://www.earthweb.com for FREE articles, tutorials,

and discussions from the experts.

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Use:



strSQL = "SELECT pdebtrno, PSSN, plastname, pfirstname, pclientid FROM

tblPatient where Plastname LIKE '" & name & "%' AND pclientid = '" & shorma 

& "' "



where shorma is a variable that contains the client name.



Wally Burfine



>From: "Matthew Lohr" <mlohr@t...>

>Reply-To: "ASP Databases" <asp_databases@p...>

>To: "ASP Databases" <asp_databases@p...>

>Subject: [asp_databases] data search

>Date: Fri, 29 Dec 2000 14:07:05 -0500

>

>

>I am trying to sort my data based on two values at the same time.  One is a

>constant pclientid should always equal shorma.  So I am trying to search 

>for

>patients info by their last name for one client so that client will not see

>all of my clients patients.  My current sql statement is as follows

>

>strSQL = "SELECT pdebtrno, PSSN, plastname, pfirstname, pclientid FROM

>tblPatient where Plastname LIKE '" & name & "%' "

>

>

>name is being brought from a form but I also want the filter to be sorted

>where pclientid is "shorma"  how do I do both filters on one sort?





--- 

FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

INSIGHTS IN YOUR INBOX!

Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb?s

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com