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:
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.
Ok, I have a Javascript ASP and in it I have a dynamic repeating table with certain attributes to people. If one of these attributes is old or invalid, i want to change the color of the text (and maybe make it flash, blink, change size, something) so that it's easy to read.
i have been asked to create text boxes dynamically on a web site, the user can click a button and a new set of text boxes will appear. The user can add as many boxes as many times as he wants, I have created the text boxes already using the following code.
function inserttextboxs() { var tab = document.getElementById("Difference")
var tr = tab.insertRow() var tc = tr.insertCell("") tc.innerHTML = '< input type=text id=text1 name=text1>';
}
The problem is I don't if this how I should be doing it when I submit the form all the elements have the same id, I need to create something with unique id's so I can retrieve the different values
how do get dynamic content to a drop down text box from a db. For example:
There are two drop down boxes. First one continents Second one countries.
The user selects content from the first drop down box and using the onChange javascript function the data on the second drop down should show the countries related with that content.
I need a text box to only take 6 digits. It should work like this:
If the user inserts say '89' form would actually send over '000089'. Likewise if they inserted 1234, again the form would send 001234, if they inserted 1 it would send 000001 and so on..
Yes, the easy way round this would be to give the users a message to input the data as 001234 for example, but is there any way this can be done dynamically?
I have a dropdown that is dynamically populated. The value = a numeric code which I save in the DB. The text = the description. I know how to get the value of the selected item but I need the text of the selected item. I know how to do this in javascript but where I need to gather the text is during an ASP routine.
How do you get the text portion of a dropdown? I saw one post where you can add the numeric code and description together and then use split() to seperate them. I'd rather not do it this way. Is there another way?
I'm having a complete brain cramp today. I've written a form that displays information based on content in a database. Can someone tell me what's wrong with my code to display the data in a textarea?
I am looking for a way to have people enter some text, click a button and have the text show up on top of the existing graphics. I have no idea what this would be called, so if this is an existing topic, please forgive me and just point me to the topic. Is anyone aware of any sample code that demonstrates this?
I have a form that has both static and dynamic fields. I have no problem validating the static data, but whenever I try and apply form validation to a dynamic text box that has repeated rows, the validation does not seem to take. Do I have to run that validation through a loop? Code:
Does anyone know how I can insert daynamic text box data into a SQL Server database? I have text boxes that are being generated dynamically and I want each of those values inserted into the database that hold the results. I'm not sure how to write my loop statement.
I am having trouble with the ordering page. I would like a dynamic form list to look at a database and when the user selects a product code, the text boxes containing description and price change too to reflect the product code.
The user will be entering in their contact details, so I dont want the page to reload too because I will lose that info. Code:
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:
Below is the code I use to send data from form to database. Problem is if an apostrophe is entered in cQuestion field or any field for that matter the form errors out. 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 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:
how to add the symbol ' (Apostrophe) to the code so that the validation accepts this within a surname such as o'neill? this is wot i hav at the minute:
With regExName .Pattern = "^[a-z]+$" .IgnoreCase = true .Global = true End With
how to accept ' or apostrophe when adding on the database? because I created a simple guestbook and when i tested it it works fine but once i add apostrophe like TOY'S etc it generates error.
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:
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?
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.
I code that creates a calendar for each month and then it displays events from that month that are stored in a db. I need to loop through my recordset and display all the events, but I can't quite figure out how to do it. I am thinking I need to do an array. But I am not really sure.... any ideas. Here is where you can view the calendar. Code:
I have this problem in controlling a the text in a Text Area. How can I do that for example the field size is 200, when it reaches 50 it automatically goes to the next line. Bcoz im having problem when viewing it in my report, it continuesly views in a strieght line and im having problem in printing.
When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
I have a form on asp page that pulls info from a DB when the page loads. It them puts the info into text boxes on the page that are editable by the user.
The only problem I have is say in the description text box it should read "HP Laserjet 5Si" , it always cuts the text off where it just says "HP" .. It does this on all the text boxes? I can't seem to figure out why it is doing it. Here is the sample code:
