I have a small form which searches a SQL DB on several fields - ie.
WHERE Field1 = xxx AND Field2 = xxx AND Field3 = xxx
How can I do this so that if one search criteria is left blank, it ignores it instead of trying to match it in the DB?
i have a form where the user keys in words to be searched from the itemDescription column in the database. My search works fine, but how to i bold that particular searched word?
View Replies View RelatedI'd like to add to my search function of my asp site the possibility to highlight in the result pages all the words searched.
View Replies View RelatedHow to perform multiple search using asp in website, the search from local adn remote database.
the local search is working properly, but the remote search stil kinda stuck with it...
my local search script(work well):
dim Connection
set Connection = server.createobject("ADODB.Connection")
Connection.open "Provider=SQLOLEDB;DATA SOURCE=PROTOS;UID=smc;PWD=project;DATABASE=Virtual-Observatory"
how to attach the remote database search for the same website??
i need to make some choices in my search code by adding 1 drop-down box or more like that
<SELECT size=1 name="items">
<OPTION selected value="all" >all</OPTION>
<OPTION value="1" >item 1</OPTION>
<OPTION value="2" >item 2</OPTION>
<OPTION value="3" >item3</OPTION>
<OPTION value="4" >item 4</OPTION>
</SELECT>
so my search string will be
select * from table where rs("itemID") = '"&items&"'
and my quiz is if i want 2 make the drop-down box (items) = all i mean i want the sql statment sellects all of the names what should b the value of the all option ?
note im using 3 or 4 drop-down box and i may nedd the value of some of them to b all and the othere takes any value.
i have a form (22 different criteria although I'm only showing 3) and want to be able to enter criteria into and have it search the database. Code:
View Replies View RelatedI want to do is search through a database based on what was selected on a form.It will be based on state, county, and category.Out of the search I just want one field out of the database, the email field. Now, at first I had one table to mess with so I was using this:
strSQL = "SELECT DISTINCT EMail FROM Info WHERE Category='" & category &"' AND State='" & state &"' AND County='" & county &"'"
the way the database is going to be set up now what I need to do is search through one table that will have all the states, counties, category, and UserID fields.Then it has the other table that will have a UserID field and an email field.So I guess it needs to go through the first table and depending on what state, cat, county were selected it will take that UserID and match it to the UserID in the email table and then pull the emails that match UserID.UserID? Would this use JOIN? UNION? How would this be done, to take the form info and search the one table and then depending on what userid matches the state, county, and category in that table it matches that userid to the userid in the email table and pulls the emails from the email field.
i have a simple search page which i want to search mutiple tables with different layouts so i can return the search results in one recordset. how owuld i do this?
View Replies View RelatedI am searching for a specific record based on different criteria:
First Name, Middle Name, Last Name, City, State, Zip Code, File Number
I am using sql server to store all the information.
how to search multiple fields in an access database?Basically I want the code to search an entire table, field irrelevant.While I'm at it, does anyone know how to make the same search not care about word order or placement?
Such as:
Search string: "John went to the store"
returns the same results as
Search string: "The store went to John"
Just thought I would throw these out there and see what direction anyone can lead me.
I am trying to make a search page. Once a serach word or words is put in I need it to serach multiple product tables and output the description of any prioduct if the search word is present in the description.
However, If i put in 2 keywords like "paper sticker" I get no results. How do you search multiple keywords? Code:
I have a form on one page where someone selects a bunch of options and details about a specific category. Then on the next page they fill out a form with contact information, name, address, email, etc.
Well what I want to know is when they click Submit on that contact form is there a way to have it so it goes through and searches the database for any that match the state and county(which they will select from a )??
So what I basically want right now is for the first form to be filled out, then the second form to be filled out, then when they are submitted it will go through the database and select everyone in there with that state and county, then on the next page display the results of both forms AND the matches in the db(obviously whatever fields I want it to display).
I already have both forms(basic html), I already have the dynamic dropdown for state and county(classic asp), what Im wondering is how do I put that dynamic dropdown in the contact form and then when submitted it will go through and search the db based on what was selected there. Would this be some sort of onClick for the submit button tellin it to search the db based on the dropdown or how would I get started on something like this?
There will be other information on the dropdown like name address email so one problem I was wondering about was my dropdown menu. When you select the state it refreshes the page and then loads the counties, so wouldnt that erase anything that was filled out on the form?
I could make it so they actually type the name of their state and county but that causes problems too because if they mispell either then it wont return any results.
I am trying to search for clients contained within a database using multiple search criteria that the user is able to select using a front end form.
The user is able to select there criteria by selecting one or more check boxes and the results are thus retrieved based on what the user has selected. The search works fine until you try and select multiple client types Code:
let's say that I want to highlight some words or even a square of a table in yellow...how would i go about doing that? What code would work to do what I need?
View Replies View RelatedI'm having a problem in displaying a selected option from the drop down list in words. But after I selected an option, nothing is being displayed, I think the value can't be passed at all. Please let me know how to fix it.
<td align=center width=20%>Fruit:
<select name=""FruitName">
<%
" If not myRS.eof Then
while not myRS.eof
%>
<option value="<%=myRS.fields("ID")%>"<%If FId = myRS.fields("ID") Then response.write "selected"%>><%=myRS.fields("FName")%></option>
<%
myRS.MoveNext
wend
%>
</select>
<p>The fruit you have selected is <%=FruitName%></p>
I have a database field that is a memo type. I would like to be able to only display the first 50 words from the database. I would like for it to show ..... after about 50 words.
I am using <%=Content %>. How do I trim this field to show only 50 words and then ....?
I tried the following code:
Function LengthTrim(input, length)
If Len(input) > length Then
Return Left(input, length) + "..."
Else
Return input
End If
End Function
then <%= LengthTrim(Content, 50) %>
But it would not work. I got the following error message:
Microsoft VBScript runtime error '800a01f4'Variable is undefined: 'Return' .
I have data where first and last name are in one field. I need help
how to i separate first and last name in ASP.
the spaces between the words (in a textbox for example) are removed when i try to pass the value to another page for saving.
View Replies View RelatedI want to take a string like this:Code:
string = "THE RED GIGANTIC AND HUMONGOUS"
and retrieve only the words over a certain length or longer (let's say 5 characters), maintaining spaces between them- result:Code:
string = "GIGANTIC HUMONGOUS"
i am having trouble getting my REPLACE fn. to replace whole words only. basically, i'm running a 'spelling checker' fn. that uses the REPLACE fn. to find incorrect spellings and replace them. problem is, the fn. seems to replace all instances of a string, and not a whole word only as I intend it to be:
Code as follows:
StrInput = Request.Form("BKM_Search")
StrInput = LCase(StrInput) 'convert all to lowercase
StrInput = Trim(StrInput)'trim all empty space b4 & after string
StrCorrect = Replace(a_StrWrong, a_StrRight,1,1,1)
Let's say I want to replace the word "sea" with "ZZZ" only:
Example input: "Sean has some neat sea shells"
Example output: "ZZZn has some neat ZZZ shells"
I have to develop a spell checker from scratch using asp language. as i'm a newbie with asp, there are still a lot of things that i don't understand. How can I add new words to my list of dictionary sorted alpabetically?
Do i need to use the database for this function? Can anyone show me? or if anyone knows of any websites that i can refer to.
Let's say I have the following var:
Code:
strTemp="Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed"
and I am searching the string for another string 'amet', for example. How would I go about getting my page to output the word I search for and say 10 chars to the left and 10 to the right? So, in this case, I'd like to be be able to search the string with any
other string ['amet' for example] and have it output this:
Code:
...dolor sit amet, consecte...
wondering if its possible to have some kind of searched word highlight! IE. every thing it throws up in return of search it will highlight why it has brought it up! so if search "a" all "a" in return results would be highlighted.
View Replies View Relatedis it possible (i heard u can replace) to filter out bad words using regexp? I'm using Replace() but it sucks without ALOT of extra code... but using regexp it seems better, with ignorecase, etc.
How would I do it? O, here's the way it is now:
<%= Decode(ChkBadWrds("Comment")))%>
How would I do something similar using regexp?
how can i count how many words have i written in a text
area?Like taking an example ... i am writing in this textarea
of microsoft usergroup. and say in total i have written 50
words .. how can find out this information?
I retrieved some data from the database and put it in a textbox but the words after the blank sapace cannot be shown, why is that?
Name = rs("requestor") 'where the name is "Sam Siew"
<TD><INPUT TYPE=TEXT Name=requestor size=12 Value=<%=Name%>></TD>
In the text box, it only show "Sam".
how to capitalise all words in a string that are seperated by spaces. The string is variable and not the same every time hence I cant use the Ucase function as I wont know the exact position of the start of each word.
View Replies View RelatedI would like to have a text box where people can type a word they want and then click on a button to get the description of that word.The way I see it working is if the word they entered in the box is in my database a page will display the meaning corresponding to the word in the database. However if it is not then it will display a message telling them that.
View Replies View RelatedThis code highlights words entirely. I look for the word nation it highlights words like abomination. So I only want the function to highlight whatever I'm looking for. Code:
View Replies View Relatedhow can i transform say 12,000 to "twelve thousand" with asp?
View Replies View RelatedI'm really at wits end on this as I'm not having much success with locating a function or other options I have. I'm working on a message board for a website and I'm needing to check the length of the words that users put in.
For example, when someone puts in "yesssssssssssss!", I put together a small function that omits all of the s's as this is wreaking havoc on the layout of tables within the site. But I don't have a solution if someone types in "ssss sasdfjskldjfaskld;jfaskdf" as random ambiguous letters.
I know I can check the length of the entire string but don't know to check the words
within it.
How do i use asp to retrieve the first two hundred words from a field in a database.
View Replies View Relatedhow can i count how many words have i written in a text area? Liek taking an example ... i am writing in this textarea of devshed forumns. and say in total i have written 50 words .. how can find out this information?
View Replies View Related