Is it possible to search a string for a upper case character? Here is what I am trying to do:
I have the following string:
Quote: str = "ProjectSectionPlanning"
I'm trying to break this string into:
Quote: str = "Project Section Planning"
I need to filter the records of a table where the records contain a searchin string with no case sensitive compare, and all with one only sql statement.
"SELECT * FROM Stuff WHERE LOWER(StuffName) LIKE '%" & lcase(StrSearch) & "%'"
but the error is in the function LOWER exist a similar function ?
How to make first letter of word in upper case?
i.e. hello should return Hello
Is there any inbuilt function?
Since my website uses a font for headlines that doesn't exist on default in windows I want to dynamicly create my headlines with images(of characters)
For this to work nicely I have to detect if a character is upper or lower case.
Like the string
"Welcome"
Here I want to replace the "W" with a upperw.png and then replace "elcome" with lowere.png, lowerl.png, lowerc.png...and so on, you get the picture.
Is this possible in asp (vbscript) ? or java if It's possible to integrate into my vbscript page.
I just realized that when I do a replace:
replace(rs("IMAGE"),".jpg","")
it replaces all instances of a lower case .jpg but not the upper case
..JPG
How can I fix this?
Below is my sql search code in my asp page. But my search seems to be case sensitive. How can i modify it to make it not case sensitive?
<%
sqlString = "SELECT product_image, product_name, product_description, product_price " &_
"FROM Products " &_
"WHERE product_status = 1 " &_
"AND ( product_name LIKE '%" & searchFor & "%' " &_
"OR product_description LIKE '%" & searchFor & "%') " &_
"ORDER BY product_name "
SET RS = Conn.Execute( sqlString )
IF NOT RS.EOF AND searchFor <> "" THEN
%>
Below is my sql search code in my asp page. But my search seems to be case sensitive. How can i modify it to make it not case sensitive?
<%
sqlString = "SELECT product_image, product_name, product_description, product_price " &_
"FROM Products " &_
"WHERE product_status = 1 " &_
"AND ( product_name LIKE '%" & searchFor & "%' " &_
"OR product_description LIKE '%" & searchFor & "%') " &_
"ORDER BY product_name "
SET RS = Conn.Execute( sqlString )
IF NOT RS.EOF AND searchFor <> "" THEN
%>
I have some stored values in a DB. When I search for a username I don't want to retrieve anything unless all characters match exactly. Assume a user has chosen "HeLLo" for username. Then I don't want the SQL string to store that name in the recordset when names like "hello" or "Hello" is searched.
The way my code works now, it doesn't pay any attention to whether it is lower or upper case. How can I search a DB and only store the values in the recordset if all cases match?
if its possible to loop through my entire DB Table and do String Case Conversion. I only want to chnage the case of certain fields. I can get each of the field value and update them easily but I need a way to convert them to the case I want.
The standard LCase and UCase function are ok but I want the formating to be mixed like Title case (in MS Word) or Capitalise (text-transform in HTML/CSS). Basically I've some of the values are in upper case some in lower case I want them all to be Title Case Similar To: Html Css Text-transform Like This Line .
How to i search the colon in the data and then pick characters after colon. for eg:
ACTUAL DATA
Date: Fri Aug 04 15:14:38 EDT 2006
REQURED DATA
Fri Aug 04 15:14:38 EDT 2006
Retrieve a list of all records starting with special characters.Does anybody know of solution?
View Replies View Relatedcan someone please tell me how to add the " character to a string
i've already tried:
<%
dim string
string = "something"
string = string & """
%>
string should equal something" but doesn't work ?
What is the best way to check each character within a string?
For doing something like encryption, where you check character 1 and replace
it with a different character.. then check character 2 and replace it with a
different character.... etc.... until completing the string?
I tried the strlen() func but to no avail. I am looping through a record set, if the length of a fields string is above a certain character count, say 50, I want to do one think, less than 50 do another?
View Replies View RelatedI have an input text area on a form the max field size in the database is 255 i need to split the string at the 250 caracter?
View Replies View Relatedi have a browse button on a web form that the user can upload images via ftp. the user clicks on the browse button to browse a file on his computer and the text field displays the path - "mycomputerdesktopmyimage.jpg".
i need to get the name of the image and insert the name into my database. so i need to be able to search the string ("mycomputerdesktopmyimage.jpg") and insert all the characters after the last "" which will give me the image name. ive tried just writing out the string in asp (jscript), but it gives me "mycomputerdesktopmyimage.jpg" without all the backslashes.
how do i get those backslashes back into the string? my second question is how do i search for the characters after the last backslash? i know i can use a substring on this, but how can i use it for the last backslash?
I have a page that will display a list of locations from an SQL DB. Users need to be able to sort and/or search these locations by industry
Each location has a 4 character desgnation, the 3rd character of which indicates industry. How do I query the DB in an ASP page to recognize ONLY the third character in the string?
say i have a string that is "hello this is my string and i like it very
much" and i want to insert a newline at every 20th character, how could i go
about doing this?
I'm passing a unique identifier from page1 to page2 to page3 querried from MS SQL Server. When I pass the value, it puts the value in the curly brackets. (Page1 is for display and Page2 is for edit and Page3 is update edit)
When I go to Page3, it gives me an error saying "Syntax error converting from a character string to uniqueidentifier" {7171B9BD-4599-43D9-9521-3DA583A1BB1A} This is the value and the error page says "id=%7B7171B9BD-4599-43D9-9521-3DA583A1BB1A%7D" It seems tp put "%7B" and "%7D" for "{" and "}". Has anyone seen this?
I'm also passing numbers and text and they don't seem to have this problem, just the unique key.
I'm using Msxml2.ServerXMLHTTP.3.0 to fetch a HTML page on a remote
server. The fetched page is then parsed and the information of interest
is extracted and send to the client browser.
However, the remote server does not specify any character coding in its
headers. If using ResponseText property in ServerXMLHTTP, some
international characters are not decoded correctly. This is due to
ResponseText assuming UTF-8 coding if no character set is specified.
My solution is to use the ResponseBody property which returns the web
page as an array of unsigned bytes. I then convert the data to a string
using the ADODB.Stream method as described here:
http://www.motobit.com/tips/detpg_binarytostring/
The string is then parsed and the required information is pulled out.
This solution works just fine but I wonder if there is some more
efficient (without the need for a byte to string converion) way to
solve the problem.
Code like this
=======================
Select case q
Case "a"
Dim arr(5)
Case "b"
Dim arr(2)
end select
=====================
returns an error saying variable arr redefined.
Should it be like that or an I using Select incorrectly? Perhaps something
similar to break needs to be used?
i have a variable cup and works like this for each item in request.querystring
if cup <>"" then
cup = cup + 1
next
how do i get the maximum number in cup ? do i use ubound ?
I am passing the following variables....
City - name of city
RentLow - low range of rent
RentHigh - high range of rent
myquery - keywords
The following is the start of my query string but I am having issues with the City portion already and I have not gotten to the rent yet
I know the SQLquery portion right below is fine - it tested perfectly, along with the rest of the query, it was when I added in the request city string that gives me No value given for one or more required parameters. even though one is passed in the string.
SQLquery = "(" &parsethis(strText ,words ,wCount, 3) & ")"
SQLquery = Replace(SQLquery, "<FIELD1>", "title")
SQLquery = Replace(SQLquery, "<FIELD2>", "description")
SQLquery = Replace(SQLquery, "<FIELD3>", "comments")
SQLstr = "SELECT * FROM links WHERE " & SQLquery & " AND city = " & Request.QueryString("city") & " AND linktype = 2 AND active = " & myTrue & " " & SortSQL & ";"
end if
i ve a string like this : my_name_is_ahmed_adly
now i need to see if this string contains the word "is"
so how can i do this ?
if i have a string with comma seperated words. is there a way to search another string for words that are in it?
View Replies View RelatedI have a page that is not asp that is linking to an asp page with a question mark and a variable on the end of the URL. How can I pull the variable off using server
side processing only?I have tried using ServerVariable("HTTP_REFERER") no good, I tried ServerVariable("URL") no good. I am also using Instr(var,"?") to search the url string like this.
Red1 = Requestor.ServerVariable("URL")
Test1 = Instr(Red1,"?")
Test1 is always a 0 because Red1 is always just the refering URL and I need the whole string in address field. I think that I am using the wrong property but I am not sure what is the right property.
Is there any fast way to search for a specific string within all the files in a folder at a same time?
I am having some trouble with getting reliable results with a search string I am using in an ASP page that uses embedded SQL.
In the ASP page, I am using checkboxes for the user to select states to search for records that apply to the selected states. Let's say that I checked the states of [GA][VA][TN]. And, let's say that there is a record with a column "states" which has the states of "AL,GA,FL,VA,TN".
The search criteria I use above will not return that record. However, If I use a search criteria that satifies the leading value of "states" or the trailing value of "states" the result will be returned. But since my search criteria 'breaks apart' the actual value of "states", it is not returned in the search. Why, and how can I make this work better?
I've made my first ASP website that interacts with a detabase. All fairly standard: it can display the entire contents of the db, you can input new items, update and delete items, and I've just started making a search page...[!]
It all works fine if the user just searches with one word, but if they enter more than one word and then press search, I don't know how to split their searchstring up into [an array of?] different strings to search the db with.
Is this even the easiest way to do it, or am I just wasting my time?
I am creating a search page and need help writing the code to build the sql
string.
I have 3 fields on the main page which a user can choose to enter search
terms in any of the 3 fields. My question is how do I write the logic so it
only includes the fields in the search criteria where the user has entered
anything.
Fields are
Production No
Production Title
Synopsis
The user may enter any, all or some of the search teams in the fields.
On the search page I am using lots of if conditions to build my sql string
like
strSQL = "Select * from Productions where "
now after where there are lots of permutations and combination like
production no could be empty or it could be filled in and the other fields
might be empty or filled in as well.
Does someone has a simple logic to build the correct sql String?
I'm trying to split my search string, So I can compare search results if the string was of two words such as: "world news"... But i'm a bit confused of how to do it using this code (FOR EXAMPLE): ....
View Replies View RelatedI'm trying to use the Microsoft Search to search for a text string in a folder full of a bunch of ASP files. Seems like the normal "Search for text in files" program in XP Pro won't search between the ASP delimiters <% %> .
How can I search for text strings in ASP a folder full of ASP files with out opening each one individually and searching?
In a HTML form field, the user enters a long text. I need to search for an image tag. Then get the name of the image (*.gif or *.jpeg) to check the image library if the image already exists. If exists, cannot upload the image. Else, upload the image.
View Replies View Related