Do You Have Your Own RegEXp To Validate Your String
I just realized that it's so important to validate each string, I mean
'each' before you insert data from asp page into database.
I guess some customers just copy data from some electronic document and
paste intoform field which it will probably mess up the program.
for example, we have a customer who wants to enter AH12345 into one of our
fields, it appears Ð?Ð?12345 in hidden field of our asp page, but it displayed
AH12345 to the customer, but our program failed because of the data does fit
into char field in sql database.
I don't know in reality, how other companies deal with those kind of thing.
Do I have write our own regExp to validate each string, since we do need to
allow apostrophe or "-" in first name or last name.
why the following code incorrectly returns 2 as matches count whereas when I change str = "179,80,179,80,179" I get the correct count which is 3? str = "179,179,179" num = 179
Set regEx = New RegExp regEx.Global = true regEx.IgnoreCase = True regEx.Pattern = "(^|,)" & num & "($|,)"
Set colMatches = regEx.Execute(str) response.write colMatches.Count & "<BR>"
I have a string which is an html document - I want to eliminate all the <script>blah blah</script> tags. I can't seem to get the regexp pattern right. Here's where I've got to:Code:
Set oReg = New RegExp oReg.IgnoreCase = True oReg.Pattern = "(<script[. ]*</script>)"
Set oMatches = oReg.Execute(sHTML)
For Each oMatch In oMatches sHTML = Replace(sHTML, oMatch.Value, "") Next
I am trying to write an asp(vbscript) parser for wiki-style pseudo code, and can't get my head round regexp.
I am hoping if somebody could give me an example to work on for one, I could sort the others.
e.g. how do you turn (from within a large string, with varying occurences) .......[image:/mydir/pics/my portrait.jpg | A picture of me]...... into ......<img src="/mydir/pics/my%20portrait.jpg " alt="A picture of me">.....
I'm struggling trying to get the concepts of the regExp function down....
What i'm trying to achieve is to remove all white space from html formatted source code.
I have the following regExp search string to remove all html source code but that is not what i require.. RegExp.Pattern = "<.*?>"
I want to store all html source code and its text/image contents into a DB.
For that reason i want to remove all line breaks and spacing/tabs within the source code so as to only have one exteremely long single line leaving the formatting of the contents of the html code alone all so that i can stuff into a varchar(MAX) field.
what is the syntax for parenthesis? but i don't want to allow <> or / like S would (if i understand that correctly). would i use ascii then, as in: x40 and x41?
Premise: Inserting data into a database form a <textarea> and displaying this data through an HTML page.
When inserting data into a database via a text area and then displaying this data any carriage return that was entered into the database was lost. I Created a function to replace a carriage return with a <BR>. I call this function when I display this data.
If I enter text inside <> into a database and then display this data, any text that was within the <> is lost because it is considered an HTML tag. How can I search the string for the brackets and actually diplay them? I do not want to use Server.HTMLEncode before I insert the data into the database. This is because we often query the database from outside a web browser.
Here is my function I have for the carriage return. I need to figure out how to accomplish this for both < and >. I am sure this is simple but I do not know what the .pattern should be (for a carriage return it is " ".
SET regQuote = New RegExp regQuote.pattern = " " regQuote.global = True catchCR = regQuote.Replace(strText, "<br>")
I have a bit of code that replaces all links in my forums with hyperlinks. I'd like to add [url=www.sitehere.com]Link[/url] BB Code links to my forums. This is difficult to word, but how do you specify for RegExp to skip links if they are in [url] tags.
I have some code working with Regular Expressions and it works right on my server (W2K Server), but doesn't work on all IIS 5 servers. I originally thought that the servers just didn't have the RegExp object, but a testing script shows that the problem is in the replace statement. Code:
I'm not so familiar with ASP, so don't shoot me if this one's easy. I have to redesign the front of a Belgian hosting company. On that front they have a domain check like this:
Input field (domain without extension) Hidden fields with populair basic extensions
(<input type=hidden name=ext value=be> <input type=hidden name=ext value=com> ...) Submit button What I want now when the the user submits this form is that IF he adds an extension in the first field (which is not required), the script also checks if that extension is available. Code:
is 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.
I need to truncate a news article to only show a certain number of characters on the front page. the news articles often contain html and the characters in the html are being counted. So, even though I want the text to be truncated at, say, 350 characters, the final result on the page looks like it's been truncated way further up, because the text of the html added to the character count.
here's the code i'm using to truncate
URLFunction ChopLastWord( Line, Length ) If Len(Line) < Length Then ChopLastWord = Line Exit Function End If Dim spaceat spaceat = InStrRev( Line, " ", Length ) If spaceat < Length-20 Then spaceat = Length ' value of 20 is arbitrary ChopLastWord = Left( Line, spaceat ) & "..." End Function
2) when highlighting words (in a search results page for example), I want to match the word ignoring case. however, when wrapping the word in highlighting code and replacing the substring, I want to keep the original capitalization.
for example, if the word to match is marvelous, but the word is stored uppercase in the db, the above code will replace the word with a lowercase version. how do I get around this?
3) I want to remove any and|or that are not inside double quotes in a string. for example,
test = """The dog and the cat""" & " and fox or mouse " & """the cat and the dog"""
resulting in "The dog and the cat" and fox or mouse "the cat and the dog"
I would like to remove only the AND OR linking fox and mouse in the middle of the string. how would I do that?
set typ = server.createobject("Scriptlet.TypeLib")
to create a random string of 36 characters. However, is there a way to create a random string of digits in the length I request? Perhaps a string of 20 digits with a few asterisks thrown in for ease of typing?
I have a date entry on a form that must be at least 30 days from the current date. It is a delivery request date and the soonest it can be processed is 30 days from the request. I need code to validate and message should they enter a date less than 30 days from the current date.
I've been given a task to write an function to validate URL's used on a website. The URL's are going to be kept in a table with other fields to indicate if the URL is valid and when it was last validated.
Any URL's that aren't valid won't be displayed on the site. Is there a way in ASP to check if any given URL returns a 404 error?
I have created one of those change your password forms whereby the the old password and new password are provided.
What I am having trouble with is ensuring that the old password entered actually exists already. Below is what I have tried, but I am getting a syntax error:
Code:
'Check Password
if request.form("CusPassword")<>rsCheckUser.fields("CustomerPassword") then
response.write "Invalid password"
end if
Else
if request.form("CusPassword")= rsCheckUser.fields("CustomerPassword") then
'write new password to databasestrSQL ="UPDATE Customer Set CustomerPassword ='"& NewPassword& "',CustomerPasswordverified ='"& NewPassword& "' where CustomerEmail = '"&CusEmail&"' "
I have a form which consists of a few fields. The problem that i encountered was it seemed like just checking the first field only rather than all the fields. Code:
I am looking for a way to do a validation in the form that who ever is filling the form is a true person & not a automatic system. there is a way to do it with letters in an image & the user must enter the same letters in a text field.
I am wondering if there is a way to validate a user's login from 2 different tables. Currently I have a sql string that pull info from a table based on the users login and password.Code:
sqlStr = "Select * From authorised_user_table where username = '" & Request.Form("username") & "' and password = '" & Request.Form("password") & "'"
My problem is I the passwords in this table are old, and I have a new table with all new passwords (same structure, just different passwords). I'm thinking most of the users don't remember their new passwords just the old. So is there a way I can query both tables? Something like Select * from table1..... else Select * from table2
I once saw somewhere, and I cannot recall the site / article... But I believe there is a way that you can "Check" an E-Mail Address to make sure that it is a Valid Email Address. NOT Syntax checking... But to actually determine if the email address typed in is a "Real" and "Active" E-Mail Address.
I realize this is not solely an ASP question, but I thought you guys might know the answer and I couldn't find anywhere else to post this. If you have suggestions for this I am more than happy to post somewhere else.
How can I, using ASP code, validate whether or not an email address is a real one? For example, if I have the email address called Join Bytes! how can I determine if it is real?
