AND / OR paramaters (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

lu lu -> AND / OR paramaters (9/18/2002 16:27:43)

In the Drw i can select AND or OR, these are the search fields:
ID
company_name
city
province
phone_number
fax_number
line_of_business
number_of_employees
sales_volume
occupation
esi_rep

My problem:
if i set occupation to OR, i can' t find out which esi_rep is working on what occupation, IF i set occuaption to AND, i can' t just type in an occupation for search without using another field name in the search. I would like to do both. How would i use occupation on its own for searching and still use occuaption with esi_rep, to display records that esi_rep is associated with?



hhammash -> RE: AND / OR paramaters (9/18/2002 16:41:03)

Hi lulu,

Create a form (Can be HTML also), put in the form all the fields. Give the fields the same names of the DRW (Basically the database fields). Then put the default value in each field as " %" with the quotation marks.

Then post the form to the DRW.

In this case the DRW will neglect the empty fields.

If you have in your fields a combination or Text and numeric, put the default values of all the fields to be the same field name:

Example:
FaxNumber , default value should be FaxNumber

Do this to all fields. Only if you have a combination of text and numeric, otherwise put % as a default value to all fields.

Regards
Hisham



lu lu -> RE: AND / OR paramaters (9/18/2002 16:58:06)

since i have numeric and text field i set the deafults to be the field name of that field and the DRW results isn' t working, well it is displaying all records from the db regardless of query or not, when i try to query teh db nothing happens and the same result list is displayed. Example all db records are being displayed in teh DRW query results section, is i query a record that has a value unlike all the other records, them the DRW results still displayes all records from the db.

What else is there to try?

maybe i' m miss understanding, i have create the form and assigned names to the fields. I post the form to the database. I created a DRW to query the table and display records found.

This is the critera fields that i' m using:
ID
company_name
city
province
phone_number
fax_number
line_of_business
number_of_employees
sales_volume
occupation
esi_rep

i would like to search by occupation only to display records of all occupations matching the search (which is the OR). I would ALSO like to search by occupation and esi_rep, to display all records containing those two search critera (which is the AND).

hope this better explains myself



hhammash -> RE: AND / OR paramaters (9/18/2002 17:27:48)

Hi lulu

look at this

http://www.fmhs.uaeu.ac.ae/nml/Forums/NorthWind/Search.htm


I forgot to tell you. In the DRW use the criteria button. Then add all the fields that are in the search form, all of them with And and Begins With. Then put the default as I told you.



Regards
Hisham



hhammash -> RE: AND / OR paramaters (9/18/2002 17:32:58)

Hi,

Look at the SQL of my DRW

fp_sQry=" SELECT * FROM Customers WHERE (ContactTitle LIKE ' ::ContactTitle::%' AND City LIKE ' ::City::%' AND Country LIKE ' ::Country::%' )"
fp_sDefault=" ContactTitle=%&City=%&Country=%"
fp_sNoRecords=" <tr><td colspan=11 align=left width=" " 100%" " >No records returned.</td></tr>"
fp_sDataConn=" Northwind"


Hisham



lu lu -> RE: AND / OR paramaters (9/18/2002 19:01:44)

I tried it and what happened was the same result, all records were displayed from a query that should have displayed 1. Also there are some fields that could not use this
quote:

Then add all the fields that are in the search form, all of them with And and Begins With
so i left them as they were.

I switch the sql back and now this is what it looks like:

fp_sQry=" SELECT * FROM Results2 WHERE (ID = ::ID:: OR company_name LIKE ' %::company_name::%' OR city LIKE ' ::city::%' AND province LIKE ' ::province::%' AND phone_number = ' ::phone_number::' OR fax_number = ' ::fax_number::' OR line_of_business LIKE ' %::line_of_business::%' OR number_of_employees >= ' ::number_of_employees::' OR sales_volume >= ' ::sales_volume::' OR occupation LIKE ' ::occupation::%' AND esi_representative LIKE ' ::esi_representative::%' )"

fp_sDefault=" ID=NULL&company_name=NULL&city=NULL&province=NULL&phone_number=NULL&fax_number=NULL&line_of_business=NULL&number_of_employees=NULL&sales_volume=NULL&occupation=NULL&esi_representative=NULL"

?[:(]??



lu lu -> RE: AND / OR paramaters (9/19/2002 10:07:45)

quote:

Then put the default value in each field as " %" with the quotation marks.

when i use the quotes my sql look totaly different than the one you displayed and i get an error of invalid character pointing at " %" , i think you ment to say with OUT the quotes, but then why did you use the quotes in the first place.

quote:

put the default values of all the fields to be the same field name

so if i have 30 fields they should all have the same field name, that doesn' t make sense? I guess i need to take that sentence as " put the defaults of all the fields to be the same field name as that particular field."

quote:

Then add all the fields that are in the search form, all of them with And and Begins With

were you unaware that i have an ID field and other number fields.

can any one else help me?



rdouglass -> RE: AND / OR paramaters (9/19/2002 10:26:28)

I have used a DRW hack (quite a severe hack) and if you' d like, you can use it and I' ll help you thru it. It basically involves checking each search box for any data, then building the SQL string based on valid inputs, then passing the SQL string to a hacked DRW.

There is an example posted here. It is for a simple knowledgebase that I set up on our Intranet. It uses 2 text fields (Keywords and Body) and 3 dropdowns (Cat1, Cat2, and Cat3). It checks each field submitted for entries. If there is something in the field, it adds it to the SQL string; if not, it ignores it.

Your welcome to use this and adapt it to your scenario; I' ll give you pointers along the way if you' d like....



lu lu -> RE: AND / OR paramaters (9/19/2002 11:17:08)

Every field in the db has a value. My problem exists when i use the DRW to to query the database and display the records. I have a bunch of fields in the db but only a hand full are used to query the db, these are the hand full:
ID (unique autonumber)
company_name (text)
city (text)
province (text)
phone_number (text)
fax_number (text)
line_of_business (text)
number_of_employees (text)
sales_volume (text)
occupation (text)
esi_rep (text)

In the Critera part of the DRW i have the following:
Field---Comparision---Value---AND/OR

ID---equals---[ID]---OR
company_name---contains---[company_name]---OR
city---contains---[city]---OR
province---contains---[province]---OR
phone_number---equals---[phone_number]---OR
fax_number---equals---[fax_number]---OR
line_of_business---contains---[line_of_business]---OR
number_of_employees---Not less than---[number_of_employees]---OR
sales_volume---Not less than---[sales_volume]---OR
occupation---contains---[occupation]---OR
esi_rep---contains---[esi_rep]---OR

And under the " Defaults" button, for the input parameters, i have a default value of NULL for every field.

When saved and test it works great for single search queries, that is, if i only search for a record using only one of the search fields:
ID (unique autonumber)
company_name (text)
city (text)
province (text)
phone_number (text)
fax_number (text)
line_of_business (text)
number_of_employees (text)
sales_volume (text)
occupation (text)
esi_rep (text)

If i want to find a record that contains a specific esi_rep AND a specific occupation, meaning i use those two search field for the query, it does not display the record with fitting both critera. I understand this will not work because i am using the OR operative for occupation & esi_rep. So how am i able to search only by occuaption (to display all the containing the occupation) AND, if i would like, to also search for a record in a specific occupation that also contains a specific esi_rep ?





rdouglass -> RE: AND / OR paramaters (9/19/2002 11:28:32)

The example code I posted does what I think you' re asking for. You definitely would need to adapt it for your environment and SQL statements. Have you looked at the link I provided above? ...and if so, does it make any sense to you?

Maybe I should explain more. We' ll take the first two sections: 

Dim TechTipQueryString, KyWdStr, Cat1Str, Cat2Str, Cat3Str, Body
TechTipQueryString = " "


(DIM and initialize variables. I used 5 fields but you would need more.) 

If Request(" Keywords" ) = " "  then
TechTipQueryString = " "


(If KEYWORDS field is blank, leave the variable alone) 

else
TechTipQueryString = " (Keywords LIKE ' %::Keywords::%' )"


(If KEYWORDS has something in it, add it to the query) 

end if
 
If Request(" CategoryDesc1" ) <> " None"  then


(If CATEGORYDESC1 has something other than " None" , include it in the query) 

If TechTipQueryString = " "  then
TechTipQueryString = " (Cat1 LIKE ' %::CategoryDesc1::%'  OR Cat2 LIKE ' %::CategoryDesc1::%'  OR Cat3 LIKE ' %::CategoryDesc1::%' )"


(If query has nothing in it yet, add CATEGORYDESC1 to it) 

else
TechTipQueryString = TechTipQueryString & "  AND (Cat1 LIKE ' %::CategoryDesc1::%'  OR Cat2 LIKE ' %::CategoryDesc1::%'  OR Cat3 LIKE ' %::CategoryDesc1::%' )"


(If there was already something in the query, need to put " AND" in before adding to query) 

end if
end if


Continue on with all our other fields checking for contents of the field as well as contents of TechTipQueryString......

Then we pass the variable ' TechTipQueryString' to the DRW like this: 

fp_sQry=" SELECT * FROM Main WHERE (" &TechTipQueryString&" )"


This does work and will do what you want (or at least how I understand what you want). Does this help at all???



lu lu -> RE: AND / OR paramaters (9/19/2002 12:17:27)

Ok I think i somewhat understand what going on in the code you presented.

So am i on the right path? so with
If Request(" CategoryDesc1" ) <> " None" then
If TechTipQueryString = " " then
TechTipQueryString = " (Cat1 LIKE ' %::CategoryDesc1::%' OR Cat2 LIKE ' %::CategoryDesc1::%' OR Cat3 LIKE ' %::CategoryDesc1::%' )"
else
TechTipQueryString = TechTipQueryString & " AND (Cat1 LIKE ' %::CategoryDesc1::%' OR Cat2 LIKE ' %::CategoryDesc1::%' OR Cat3 LIKE ' %::CategoryDesc1::%' )"
end if
end if

I would create the above for every field name used in the query, so my first one would be:
If Request(" ID" ) <> " None" then
If TechTipQueryString = " " then
TechTipQueryString = " (ID LIKE ' %::ID::%' OR company_name LIKE ' %::ID::%' OR city LIKE ' %::ID::%' OR province LIKE ' %::ID::%' OR phone_number LIKE ' %::ID::% OR fax_number LIKE ' %::ID::%' OR line_of_business LIKE ' %::ID::%' OR number_of_employees LIKE ' %::ID::%' OR sales_volume LIKE ' %::ID::%' OR occupation LIKE ' %::ID::%' OR esi_representative LIKE ' %::ID::%' )"
else
TechTipQueryString = TechTipQueryString & " AND (ID LIKE ' %::ID::%' OR company_name LIKE ' %::ID::%' OR city LIKE ' %::ID::%' OR province LIKE ' %::ID::%' OR phone_number LIKE ' %::ID::% OR fax_number LIKE ' %::ID::%' OR line_of_business LIKE ' %::ID::%' OR number_of_employees LIKE ' %::ID::%' OR sales_volume LIKE ' %::ID::%' OR occupation LIKE ' %::ID::%' OR esi_representative LIKE ' %::ID::%' )"
end if
end if

so next i' d have Request(" company_name" ):

If Request(" company_name" ) <> " None" then
If TechTipQueryString = " " then
TechTipQueryString = " (ID LIKE ' %::company_name::%' OR company_name LIKE ' %::company_name::%' OR city LIKE ' %::company_name::%' OR province LIKE ' %::company_name::%' OR phone_number LIKE ' %::company_name::% OR fax_number LIKE ' %::company_name::%' OR line_of_business LIKE ' %::company_name::%' OR number_of_employees LIKE ' %::company_name::%' OR sales_volume LIKE ' %::company_name::%' OR occupation LIKE ' %::company_name::%' OR esi_representative LIKE ' %::company_name::%' )"
else
TechTipQueryString = TechTipQueryString & " AND (ID LIKE ' %::company_name::%' OR company_name LIKE ' %::company_name::%' OR city LIKE ' %::company_name::%' OR province LIKE ' %::company_name::%' OR phone_number LIKE ' %::company_name::% OR fax_number LIKE ' %::company_name::%' OR line_of_business LIKE ' %::company_name::%' OR number_of_employees LIKE ' %::company_name::%' OR sales_volume LIKE ' %::company_name::%' OR occupation LIKE ' %::company_name::%' OR esi_representative LIKE ' %::company_name::%' )"
end if
end if

and so on.
Is this correct?



rdouglass -> RE: AND / OR paramaters (9/19/2002 12:38:18)

Not quite...[:)]. First, how many fields will you be searching? and what are the field names? My example may be a little confusing since I allow only 1 CatDesc and want it to search all 3 CatDesc Fields. With your situation, it would look something like:

<%
' Function to build query for search
Dim myQueryString
myQueryString = " "
If Request(" ID" ) = " " then
myQueryString = " "
else
myQueryString = " (ID LIKE ' %::ID::%' )"
end if

If Request(" company_name" ) > " " then
If myQueryString = " " then
myQueryString = " (company_name LIKE ' %::company_name::%' )"
else
myQueryString = myQueryString & " AND (company_name LIKE ' %::company_name::%' )"
end if
end if

......

and so on....

You' d do similar thing for all fields included on your search / submit page. (Notice I changed some of the variable names to fit your scenario better.)

PS. I' m assuming you have separate textboxes on your submit page for each field you want to search.........



Long Island Lune -> RE: AND / OR paramaters (9/19/2002 12:58:56)

lu lu,

I thought you only wanted to search by occupation???

Also,

ID LIKE ' %::ID::% ???

Interesting....
So your saying that your looking for an ID like 47, but you' ll except 147, 478, 1478???

Confusing post... [:j]



lu lu -> RE: AND / OR paramaters (9/19/2002 13:07:47)

I see... should... ID LIKE ' %::ID::%' ...be ' #::ID::#' ?

aspects implemented (what other parts need to be changed to it to workl? AND THANK YOU sooo much for helping me get through this, it is so appreciated.):



rdouglass -> RE: AND / OR paramaters (9/19/2002 13:39:28)

The stuff I gave you looks close but not quite.

1. First, you' ll have to put the DRW code on the Spooky diet. You can see it here.

2. Next, you' ll need to change the lines:

If TechTipQueryString = " " then
TechTipQueryString = " (Keywords LIKE ' xxxx' )"
end if

to:

If myQueryString = " " then
QueryString = " (company_name = ' xxxx' )"
end if

because you want to use your variable (myQueryString) and you don' t want to find any records. If the statement is true (If myQueryString = " " ), then the user didn' t enter any criteria.

3. Next, you need to change the lines:

fp_sQry=" SELECT * FROM Results WHERE (" &TechTipQueryString&" )"
fp_sDefault=" Keywords=xxxx"

to:

fp_sQry=" SELECT * FROM Results WHERE (" & myQueryString & " )"
fp_sDefault=" company_name = xxxx"

4. ANd last, yes you' ll probably need to change the line you asked about if ID is a number field, you' d use:

ID = ::ID::

I don' t think you can use a LIKE on a number field, but I' m not sure. Make those changes and let' s cross our fingers.....[:o]



lu lu -> RE: AND / OR paramaters (9/19/2002 14:19:38)

ok i implemented those changes and now i' m trying to over come this database results error:
Too few parameters. Expected 1.



rdouglass -> RE: AND / OR paramaters (9/19/2002 15:07:23)

It looks like you have a typo where you set your default in the top script.

This:

' If query string is still blank, set a No Record Found value
If TmyQueryString = " " then
myQueryString = " (company_name = ' xxxx' )"
end if


should be this:

' If query string is still blank, set a No Record Found value
If myQueryString = " " then
myQueryString = " (company_name = ' xxxx' )"
end if

(notice the ' T" in ' TmyQyeryString' )

EDIT: WHat' s happening is that your first time to the page, there are no ' Request.Form' s to grab so it goes all the way to the end. When it gets there, TmyQueryString is NOT equal to " " because it is NULL (or nonexistant). The two are not equal....[;)] Subsequently the myQueryString variable only has " " in it (remeber we initialized it to " " right after our DIM statement) not our desired default....



lu lu -> RE: AND / OR paramaters (9/19/2002 15:24:36)

I caught that typo about 5 minutes after i posted, but i' m still getting the database results error:
Too few parameters. Expected 1.

i tried to run a query any way with just putting 2 in the ID field for query and i recieved this database result error:
Syntax error (missing operator) in query expression ' ((ID EQUALS 2))' .

I don' t understand that. I also looked up the first error:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q205972&
and i checked and all the db fields names are spelled correctly to the corresponding field names used in this asp page. I did some more searching and found that when in doubt just delete the drw and start over, but the way we have it there is no DRW component to delete in Normal view of front page.

kinda lost as to what to do



hhammash -> RE: AND / OR paramaters (9/19/2002 15:31:17)

Hi lulu,

In noticed that all your fields but one have a text value. The method I posted for you can work just fine for all text fields. Did you try the link I setup for you?

I have a suggestion. Since you are gowin into lot of troubles working this out for an autonumber filed, why don' t you put and ID field with text value instead of the autonumber. Like northwind customer table where you have customer ID as text.

If all your search fields are Text, my method above will work.

Are you going to search using the autonumber field?

Regards
Hisham



lu lu -> RE: AND / OR paramaters (9/19/2002 15:35:09)

yes, i' m going to sometimes wanna search using the autonumber field.



rdouglass -> RE: AND / OR paramaters (9/19/2002 15:35:33)

Try changing the code to :

myQueryString = " (ID = ::ID::)"

...since ID is a numeric field. Also, check all your field types and be sure your queries reflect the types. Use:

::FieldName:: for numbers
' ::FieldName::' for text
#::FieldName::# for dates

I did build a quick DB and test your page on my server. I used Number for ID and text for everything else. And I did use the ' =' instead of ' EQUALS' .

Hang in there; we' ll get it....[:D]



lu lu -> RE: AND / OR paramaters (9/19/2002 15:53:10)

rdouglass, thanks again for every thing, suggestion made the errors go away.

So with the errors gone, now i just have to make the query work. When i put 2 in the ID to get the result of the second record, i recieve the answer of " no records returned" , in fact no matter what i put in the query, no records are returned. Which is icky[:' (], but i believe in you rdouglass and that soon i may be [:D]


so back to the " no records being returned" I' m guessing there is a problem with
fp_sQry=" SELECT * FROM Results WHERE (" & myQueryString & " )"
with myQueryString to be more percise.



lu lu -> RE: AND / OR paramaters (9/19/2002 17:25:07)

rdouglass i looked over you example that set me on this path and i noticed how the submit button was set up, so i implemented the same. But still no luck retrieving a query, what could be wrong? I also tried doing a search using " ID" and " province" and the dreaded error occured again:
Too few parameters. Expected 1.

<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.
On Error Resume Next

strErrorUrl = " "

If Request.ServerVariables(" REQUEST_METHOD" ) = " POST" Then
If Request.Form(" VTI-GROUP" ) = " 0" Then
Err.Clear

Set fp_conn = Server.CreateObject(" ADODB.Connection" )
FP_DumpError strErrorUrl, " Cannot create connection"

Set fp_rs = Server.CreateObject(" ADODB.Recordset" )
FP_DumpError strErrorUrl, " Cannot create record set"

fp_conn.Open Application(" applicant_ConnectionString" )
FP_DumpError strErrorUrl, " Cannot open database"

fp_rs.Open " Results2" , fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
FP_DumpError strErrorUrl, " Cannot open record set"

fp_rs.AddNew
FP_DumpError strErrorUrl, " Cannot add new record set to the database"
Dim arFormFields0(18)
Dim arFormDBFields0(18)
Dim arFormValues0(18)

arFormFields0(0) = " occupation"
arFormDBFields0(0) = " occupation"
arFormValues0(0) = Request(" occupation" )
arFormFields0(1) = " contact_person"
arFormDBFields0(1) = " contact_person"
arFormValues0(1) = Request(" contact_person" )
arFormFields0(2) = " address"
arFormDBFields0(2) = " address1"
arFormValues0(2) = Request(" address" )
arFormFields0(3) = " occupation_value"
arFormDBFields0(3) = " occupation_value"
arFormValues0(3) = Request(" occupation_value" )
arFormFields0(4) = " postal_code"
arFormDBFields0(4) = " postal_code"
arFormValues0(4) = Request(" postal_code" )
arFormFields0(5) = " number_of_employees"
arFormDBFields0(5) = " number_of_employees"
arFormValues0(5) = Request(" number_of_employees" )
arFormFields0(6) = " esi_representative"
arFormDBFields0(6) = " esi_representative"
arFormValues0(6) = Request(" esi_representative" )
arFormFields0(7) = " service_purchased"
arFormDBFields0(7) = " service_purchased"
arFormValues0(7) = Request(" service_purchased" )
arFormFields0(8) = " comments"
arFormDBFields0(8) = " comments"
arFormValues0(8) = Request(" comments" )
arFormFields0(9) = " record_input"
arFormDBFields0(9) = " record_input"
arFormValues0(9) = Request(" record_input" )
arFormFields0(10) = " fax_number"
arFormDBFields0(10) = " fax_number"
arFormValues0(10) = Request(" fax_number" )
arFormFields0(11) = " province"
arFormDBFields0(11) = " province"
arFormValues0(11) = Request(" province" )
arFormFields0(12) = " company_name"
arFormDBFields0(12) = " company_name"
arFormValues0(12) = Request(" company_name" )
arFormFields0(13) = " phone_number"
arFormDBFields0(13) = " phone_number"
arFormValues0(13) = Request(" phone_number" )
arFormFields0(14) = " line_of_business"
arFormDBFields0(14) = " line_of_business"
arFormValues0(14) = Request(" line_of_business" )
arFormFields0(15) = " city"
arFormDBFields0(15) = " city"
arFormValues0(15) = Request(" city" )
arFormFields0(16) = " occupation_name"
arFormDBFields0(16) = " occupation_name"
arFormValues0(16) = Request(" occupation_name" )
arFormFields0(17) = " sales_volume"
arFormDBFields0(17) = " sales_volume"
arFormValues0(17) = Request(" sales_volume" )

FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0

If Request.ServerVariables(" HTTP_USER_AGENT" ) <> " " Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables(" HTTP_USER_AGENT" ), " Browser_type"
End If
If Request.ServerVariables(" REMOTE_HOST" ) <> " " Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables(" REMOTE_HOST" ), " Remote_computer_name"
End If
FP_SaveFieldToDB fp_rs, Now, " Timestamp"
If Request.ServerVariables(" REMOTE_USER" ) <> " " Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables(" REMOTE_USER" ), " User_name"
End If

fp_rs.Update
FP_DumpError strErrorUrl, " Cannot update the database"

fp_rs.Close
fp_conn.Close

FP_FormConfirmation " text/html; charset=windows-1252" ,_
" Form Confirmation" ,_
" Thank you for submitting the following information:" ,_
" admin_e.asp" ,_
" Return to the form."

End If
End If

%>
<%
Dim myQueryString
myQueryString = " "
If Request(" ID" ) = " " then
myQueryString = " "
else
myQueryString = " (ID = ::ID::)"
end if

If Request(" company_name" ) > " " then
If myQueryString = " " then
myQueryString = " (company_name LIKE ' %::company_name::%' )"
else
myQueryString = myQueryString & " AND (company_name LIKE ' %::company_name::%' )"
end if
end if

If Request(" city" ) > " " then
If myQueryString = " " then
myQueryString = " (city LIKE ' %::city::%' )"
else
myQueryString = myQueryString & " AND (city LIKE ' %::city::%' )"
end if
end if

If Request(" province" ) > " " then
If myQueryString = " " then
myQueryString = " (province LIKE ' %::province::%' )"
else
myQueryString = myQueryString & " AND (province LIKE ' %::province::%' )"
end if
end if

If Request(" phone_number" ) > " " then
If myQueryString = " " then
myQueryString = " (phone_number LIKE ' %::phone_number::%' )"
else
myQueryString = myQueryString & " AND (phone_number LIKE ' %::phone_number::%' )"
end if
end if

If Request(" fax_number" ) > " " then
If myQueryString = " " then
myQueryString = " (fax_number LIKE ' %::fax_number::%' )"
else
myQueryString = myQueryString & " AND (fax_number LIKE ' %::fax_number::%' )"
end if
end if

If Request(" line_of_business" ) > " " then
If myQueryString = " " then
myQueryString = " (line_of_business LIKE ' %::line_of_business::%' )"
else
myQueryString = myQueryString & " AND (line_of_business LIKE ' %::line_of_business::%' )"
end if
end if

If Request(" number_of_employees" ) > " " then
If myQueryString = " " then
myQueryString = " (number_of_employees LIKE ' %::number_of_employees::%' )"
else
myQueryString = myQueryString & " AND (number_of_employees LIKE ' %::number_of_employees::%' )"
end if
end if

If Request(" sales_volume" ) > " " then
If myQueryString = " " then
myQueryString = " (sales_volume LIKE ' %::sales_volume::%' )"
else
myQueryString = myQueryString & " AND (sales_volume LIKE ' %::sales_volume::%' )"
end if
end if

If Request(" occupation" ) > " " then
If myQueryString = " " then
myQueryString = " (occupation LIKE ' %::occupation::%' )"
else
myQueryString = myQueryString & " AND (occupation LIKE ' %::occupation::%' )"
end if
end if

If Request(" esi_representative" ) > " " then
If myQueryString = " " then
myQueryString = " (esi_representative LIKE ' %::esi_representative::%' )"
else
myQueryString = myQueryString & " AND (esi_representative LIKE ' %::esi_representative::%' )"
end if
end if




rdouglass -> RE: AND / OR paramaters (9/20/2002 9:33:53)

Can you put a Response.Write in to find out what myQueryString is? Something like:

....
' If query string is still blank, set a No Record Found value
If myQueryString = " " then
myQueryString = " (company_name = ' xxxx' )"
end if

Response.Write(myQueryString)
%>

Also, response.write in your DRW as in:

fp_sQry=" SELECT * FROM Results WHERE (" & myQueryString & " )"
Response.Write(fp_sQry)
fp_sDefault=" company_name = xxxx"


...and post the response.write results? You don' t need to post the whole page code here. That really surprises me (that it didn' t work) since I took your whole page code and put it on one of my servers. I also created a quick DB to emulate your fields but all fields except ID were text. And I really can' t see any significant difference....

You can see your page at work here with the sample DB i set up. I only have 3 records in the DB, but you can see how it works.....



lu lu -> RE: AND / OR paramaters (9/20/2002 10:28:35)

I tried the response write and all seems to work but when i publish it, it doesn' t ? I checked the publish setting for frontpage and tried other tests and all is fine, I emailed my ISP to see if there were server errors when i tried publishing. Could you email me that file so i could try to publish it to verify my theories with the ISP. I also ran a tracert 5 times to my ISP from dos and things were fine 3 out of 5 times. twice some hops timed out?
lulu_zinger@yahoo.com




lu lu -> RE: AND / OR paramaters (9/20/2002 15:30:37)

THANK YOU RODGER, your keen abilities, made my day [:D][:D]
Because i would be one of the smartest humans in the 1st century, i have understood your code in ways most would not want to venture. [&:]

Thank you for every thing [:D]




rdouglass -> RE: AND / OR paramaters (9/20/2002 15:44:01)

So it was that ' Results2' thing, eh??[>:]

I hate it when I do that!!![:D][:D]



lu lu -> RE: AND / OR paramaters (10/1/2002 17:36:20)

<bump>



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.15625