How To Determine Case Sensitive Text
I want to know how case sensitive works...simple code for an idea..thanks
View Replies
ADVERTISEMENT
Case Sensitive
i have this on my signup page
Set rs = Conn.Execute("SELECT * from rounds")
DO WHILE NOT rs.EOF
IF request.form("username") = rs.fields.item("username").value THEN
response.redirect("register2.asp")
END IF
rs.MoveNext
LOOP
the problem is.. some who signed up as say Jeff can still sign up as jeff
or jeFF how can i fix this??
Case-sensitive
My problem is like this:
http://www.4guysfromrolla.com/webte...q022400-1.shtml
But I use ASP + Access (Jet SQL 4)
Not A Case Sensitive Search?
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
%>
Case Sensitive Password
I have tried searching various sites including this one and I cant find a straight forward answer.
Code:
strSQL = "SELECT user.username FROM user WHERE username = '" & myUsername & "' AND password = '" & myPassword & "';"
How do I check for case sensitivity?
Case Sensitive Password
how can I make the password entered into a database case sensitive when a user tries to sign in?
View Replies View RelatedInSTR Is Case Sensitive
Just used this code and noticed it doesn't always work, turns out InStr is case sensitive.What's thet best way to do a non-case sensitive search?pHP Code:
IF INSTR(VideoName,"HiRes") THEN
Case Sensitive Queries
any way of searching a database without case sensitivity? Make any sense?! I have an Access 2000 db with 11 fields in it: Name, Keywords..., Description... But whenever I try to search through it using the ASp site I made, it'll only find matches if they are written identically, I.E a search for "bob" won't find the entry "Bob".
I thought about making the entire contents of the db Uppercase, but I don't want to, as that would look crap when the contents are displayed in the website.
Not A Case Sensitive Search
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
%>
Case Sensitive Files
i have developed an application with some of the files name myfile.asp, others TheFile.asp and others THATFILE.asp, that is i change the case in the names of the files. everything works on my pc, however i don't have much of cross-browser experience and before lauching it, i want to know if would matter or not? would it make any difference on Netscape, IE earlier versions, firefox, opera and so on.
in some of my files i use username, others UserNAME, others User Name and so it hereby used Request.form("username") or Request.form("User Name") Does this also makes any difference? I am basically talking about cross-browser viewing of the application.
Case Sensitive Data
When a read a field (string) in my script and checks whether it matches user input or not, the comparison is case sensitive. Eg Code:
x=objRS1.Fields("Login_Name")
If (x=User_Input_Variable) Then
Code
End If
How do I drop the case sensitivity?
Case Sensitive Search
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?
Case Sensitive In Replace Function In ASP
I use a replace char function to remove any bad words from user's input to prevent SQL injection. Here is what I use:
Function killChars(strWords)
Dim badChars, newChars
badChars = Array("bad words here")
newChars = strwords
For i=0 to uBound(badChars)
newChars = replace(newChars, badChars(i), "")
next
killChars=newChars
End function
Now the problem is if a user enter "DeLETe" in the input box, and this word is not get removed before entering the DB. because I entered "delete" in the badchars array.
so how can I enable a case sensitive in my function? So the bad words would get deleted regardless its in upper or lower case?
Make Asp "case-sensitive"
how do we make asp check the case of the strings entered.i currently have a running db login... the thing is that i cant make asp check the case of the passwords entered..... and my search pages cant distinguish between "product" and "product" in a search page
View Replies View RelatedChange Case For Text
I have a access database that has data where the people entered their name all in upper case or in various forms of upper and lower case. Can a change all the data so it is in a proper format. Example: This is Joe Smoe. Or change it to be all lower case for email addresses?
View Replies View RelatedDim Inside Select Case Executes In Any Case?
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?
Upper Case And Lower Case
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 ?
Determine Id
here is some background on the page I made. It's a calendar page with events listed. No database, just used id="" to display certain months depending on the option chosen from the jump down menu.
The question I have is this: I would like to display the current month's events when they land on the page. I used
<%
id=request.querystring("id")
%>
and created an <%elseif id="1" then%> and so on for each month. Is there a way can request the month and display that id? Thanks for you help. I have the code for the page if need be
Determine Images
Is there a way to determine the actual width and height of a image file ?
I'm using aspsmartupload to upload the image, how can determine and save the
width and height value ?
seems that aspsmartupload doesn't have this property.
If so, is there any method to determine it in asp in the simpliest way? I
will prefer to maintain the aspsmartupload method.
How To Determine Other Servers OS?
I have many servers which will be reghosted everyday with different OS
(Win2000, Win2003, WinXP...). How could I write the ASP code to get the
information of other servers' OS?
Let say the asp page is hosted on Server A, how can I check the OS version
of Server B and Server C?
How To Determine What Day A Date Is In ASP?
How do you determine if a given date is a weekday (Mon-Thurs) or weekend (Fri - Sun)? Is there a built in function?
View Replies View RelatedDetermine A Website
Somewhere in my program I ask users to provide their website URL. I would like to determine if the given website exists or not.How can I determine a website with given URL exists?
View Replies View RelatedDetermine Recordset
I am creating an ASP page for members of my team to add and delete records from specified tables. This table is choose by the user and I am dynamically creating text boxes. I also wish to include the type of the attribute to assist the user.
<%
for s_intCounter=0 to objRs.Fields.Count -1
%><tr>
<td width="34%"><% objRs.Fields.Item(s_intCounter) %>: <input type="text" id = <% objRs.Fields.Item(s_intCounter) %> > </td>
<td width="66%">Type: <% INSERT ASP FOR RETRIVING TYPE</td>
</tr>
<%next%>
Determine CSS Style
I want to use asp to assign a css class to <td> tag. I was thinking an If statement, but i've not come across trying to assign a class to a table cell before! I want the cell background to be highlighted red determined by a database table with - yes or null. (null remains white, yes - red) At the moment it simple like this: Code:
<td><%=strAddress%> </td>
Determine ASP Version
My web hosting account lets me use ASP and so I thought I'd try to learn and use some.
There is only one thing that I would like to know, and that is how to find out what version of ASP is running. Preferably, what I am looking for is something similar to the PHP php_info() function. Is there anything like this for ASP?
Determine If More Than One Row Returned
I have an ASP/ADO application querying an SQL Server DB. I want know the most efficient way to determine if more than one row is returned from a query. If more than one row is returned, the user will be presented with a choice of which row to process. If only one row is returned, I want to skip this stage, and process that single row immediately.
I can think of a number of ways of acheiving this (eg. .recordcount) but I'm looking for the slickest and most efficient method.
Determine Type Of Value
This may be a trivial question, but I was wondering how can you determine if a value contains an Integer or Float. I know there is a function called IsNumeric, however you can't determine what type it is.
View Replies View RelatedHow To Determine If Time Slot Is Available
I built a simple scheduling application using an access db.
The relevent fields are eventRoom, startDate, startTime and endTime.
When I go to add a new event, what method can I use to make sure the
eventRoom is available for the selected date and time slot? Id like to just
display an alert with the conflicting times and suggest the next available
startTime.
Determine File Date
I need to figure out if this file is over a day (or however many hours) and if it is, i need to delete it. If its not i redirect the user to it
Code:
If (fs.FileExists(workFile))=true Then
set f=fs.GetFile(workFile)
If (f.DateLastModified > Date-1)
Response.Redirect "/" & tFileName & "/" & reqString & ".html"
Else
f.Delete
End If
set f=nothing
End If
obviosuly the date-1 is wrong, i can't fid the appropriate syntax to save my life.
Determine An Image Dimension - ASP
Anyone knows how to determine an image's dimension using Classic ASP?
Like How do I know the width, Height of this image using ASP?
Determine Connection Speed
Just wondering if anyone knows how to determine someones connection speed in asp the reason for this being so i can redirect the user to a different media file depending on their connection speed.
View Replies View RelatedDetermine If Field Is Autonumber
I have a recordset with two three fields. One is an autonumber field called ID , one is a text field called Name and the last is a date/time field called DateEntered. How can I programatically determine the autonumber field ? Code:
View Replies View RelatedDetermine Pagerank With Asp Code
is there anyone here who can help me to determine google's pagerank with asp code. Just like pagerank tools are doing, where do they request data from, how do they get it, etc..
View Replies View Related