I currently have a simple html page that consists of a text box and submit button. A user supplies a quote in the text box and presses the submit button. When the submit button is pressed the quote is added to a ‘Quote’ table in an MS Access database.
This works perfectly well, however if a quote contains an apostrophe, such as … this won’t work… It will not add to the database. If I had typed in …this wont work… It would be added to the database with no problems. Code:
I have a asp webapp that must use a .net dll (with com wrapper) that in turn uses the patterns and practices libraries (june 2005 version) to access to the database.My asp webapp can properly instantiate the c# dll, but I do not know how to set the data needed to access the db. In asp.net I can add the configuration info to web.config, pointing to a dataconfiguration.config and all works fine. How can I put the needed info in the ASP configuration? If it is not possible to do so, how can I set a single configuration file for the enterprise library, provided that their dll are in GAC and that the can be called from c# exe, asp.net webapps and asp webapps and all of them should share a single configuration?
I’ve a form with a textbox called Message. When visitor enters text, I use Replace function to handle an apostrophe code that will receive the text and store in the database. It works fine. When I try to retrieve the text message, it doesn’t show what I’ve in the DB, but it displays, for example: I?m. It supposes to display as “I’m”
I did try: <%message= Replace(trim(RS("message")),"'","''")%> <td><p><%=message%></p></td>
However, that just makes it a regular double-quote. I guess I could try and find out what the character number for apostrophes are, but not sure where that is. Besides, will that mess up my SQL Server or the email if I do that?
I know a few ways to handle an apostrophe, but am at a loss for which i should use for this. The ways I know how to deal with it are.
alias = Replace(Request.form("alias"), "'", "''") alias = Replace(Request.form("alias"), "'", " & #39; ")
The name of the field is self explanitory. When the admin searches for a person using the "'" , " ' ' " method they find the user. But when ever we display that info anyware it has the O''conner setup. Code:
I have a text search which reads a textfile and displays each line that has a value the user is searching for. It's practically finished except when it searchs it doesn't look for exact matches (e.g a searh for Ali would return Alison or Alice).
How would i go about using RegEx's to prevent this by making the search look for the exact word entered? Code:
I am trying to do some custom forum code, like using [ b ] as a tag and replacing it later using RegEx. The problem is, its not replacing quite right. Its leaving in the s and its not closing some of the tags.
Here is my pattern: "[ b ]((.| )*?)[/ b ]" Here is my replace text: "<b>$1</b>"
Here is some sample text: "yada yada yada [ b ]hey![/ b ] yada yada"
Now, another thing, I would like it to close tags if they aren't closed properly. Is this possible?
I am running into a very common problem that i cannot seem to find a solution for. I have an access database with a text field. Some of the records will contain an apostrophe. i have used the replace method to escape the apostrophe and turn it into ~~~. I can sucessfully change that back to an apostrophe everywhere but a text box. Here is my code:
When I want to execute a SQL statement (as we all know) certain characters will cause an error. You can't execute a statement with a " in one of the parameters or else the command will stop short and result in an error.
Let's say for example that I'm trying to update a field named "code" and the value of the field "code" is: Code:
I made a regular expression to match Guitar Chords.
This pattern should find any of the following:
1) G 2) Gmaj 3) G7 4) G# 5) Gb 6) G#min
I'm using regular expressions to identify in a string an url ad format it in hyperlink.
The problem is that in the same string should be bbcodes and the [url] one tooo... so when the regexp will format the code will format the one in bbcode too.
The solution would be the lookaround function of RegEx to see if behind the match there is the [url] code... but it's not implemented in VisualBasicScript. Is there any way to use this function in my script ?
Is it possible to have more then one pattern for the .pattern variable. If I'm to execute and search and replace on a specific string can I make it so my .pattern will ignore specific keywords and not just A keyword?
i have text, in it i want to highlight the words user used to find this result. i used the normal replace, it worked fine except the case thing..
SearchForSp = Split(SearchFor, " ") For i = 0 to Ubound(SearchForSp) EmpJobsText = Replace(EmpJobsText, SearchForSp(i), "<strong><u><font color=red>"&SearchForSp(i)&"</font></u></strong>", vbTextCompare) EmpJobsText next
i tried to use the regEx.Repalce from the examples in groups but just couldn't find a way. problem is in the normal replace function i have option to supply a source. in this case "EmpJobsText" is the source. but regEx.Repalce don't seem to have place to type where to replace, only what to replace with what.
I am having a problem with the apostrophe not showing up correctly when doing a mysql query and returning the data.
I am using a function to keep apostrophes from causing the queries to fail and the data that does get displayed to the user (html) turns out right 90% of the time but on a certain page it displayes the apostrophy twice instead of once. Here are the relevant pieces of code:
Where [0-9]+ means you need atleast 1 number there, the rest is just a string plus my recordset's variable. I know this syntax would work with the regex I learned at school but I'm not sure how to make it work in ASP.
I have a string that I want to check to be sure there are no single or double quotes in it. Using RegEx should be possible but I cannot figure out how the syntax should go. I am programming in ASP.NET with C# as the code behind. here is one I know works to be sure there are only numbers in the string, but i can not for the life of me figure out the right syntax for quotes
The problem is that i can not get the vb replace to work on the "$1" in the url. $1 is such that it can be multiple words separated by a space. for the href, I need to convert the space to "-". It does not do that with the way I hvae the code above.
I am using a Replace function to replace single quotes with double when submitting a text field in the database i.e. Replace (q, "'", "' ' ") which works fine. When I retrieve the field from the database which has apostrophe I am getting 'Object expected' error message. Is there a way to fix this?
Isn't there some line of code that I can write to tell ASP to treat everything between BLAH and /BLAH as text (including the apostrophe). So that users can type a name of "O'Malley" in a form and I can retrieve it and store it in my database.
What is the correct data type to use if the phrase I'm saving to my table contains an apostrophe such as in the phrase "yesterda's news". I've tried "text" data type, I've tried "varchar" and "char". They all give me bugs when I save to the database and if I remove the apostrophe from the phrase, then it saves correctly with any data type.