I posted before about replacing special characters (esp. '). However, I am wondering how formatting can be kept when entering it into a textbox to store in a database?
When text with seperate paragraphs is entered, it comes out as one big paragraph later on.Is there anyway to address this? When I was doing my searching - somethign about chr(10) kept coming up, but I am not sure what this is.
I have seen people who keeps datas in sql like 1, 3, 7. For example in a relatedCats field, all the fields are kept like 1, 3, 7. Are there any disadvantage fo this? And how is it possible to use them? I mean how is it possible to treat them as individual ids when once selected.?
View Replies View Relatedhow do i encode the URL to just stay at teh web address and not say ?ID=122 at the end?
View Replies View RelatedJust figure out that by detecting the user's "user agent" and redirecting the unwanted to say, Yahoo or Google would take a load off my server, and keep spambots and unwanted bots off my site for good, and I would finally get more realistic stats.First off, there are no more e-mail addreses displayed on my site (or in the code), contact is done through a form.
Second, and that's where I'm curently at, is writting an ASP script that would only allow Mozilla browsers, GoogleBot, Yahoo's bot, MSN's Bot and Amazon's Bot. Anyway, I've already written a long and lenghty (using disallow) robots.txt file, and it didn't change things at all in the last 2 months.
I have a dropdown menu with parents' names, and on the same page when a name is selected (through an onChange event), another drop dpwn boix containing student names change according to the parent selected.
But I want the Parent drop down box to contain the parent's name who was selected, and although the event works, it just keeps displaying the first name of the list of parents even after a different parent is selected.
I have a textarea field in a form, and am then using ASP to write the form details to a mySQL database.
What I would like to do is retain the basic line break/paragraph format the user has used in the textarea field, so that is written to the database in such a way that it will be displayed with the same line breaks etc. when it is written back out to the displaying page.
I have tried inserting <pre>; but long paragraphs are blowing the page apart, as each line is being forced to stay as one line.
I have tried wrap="physical" and this keeps the line break format - and writes it in the html code on different lines but the browser displays it as one block of text again, losing formating. wrap="virtual" gives me the same result.
This thread posting form seems to do what I want mine to do ... it adds a <br /> to the end of my paragraphs, or maybe the displaying page does, how does this get done, with either html or ASP?
I got a web based application. I need to keep track of number of users coming to use this applcation on a daily basis. This application is read only one. I have to veiw the traffic for a month. What is the best way to capture this information. I appreciate any help or related article link.
View Replies View RelatedI want to keep multiple information from input in multiple pages when moving between them. The value remains in the string even the user jump to different page or click back to move back to previous page.
I heard it is possible if using javascript to assist in this but i don't know how.
Is there any sample code i can refer?
I would like to format URLS that are being retreived from a database. Here is an example:
bodytext="this is some text http://www.sitepoint.com/ this is some more text"
response.write(bodytext)
how could I change the URL (http://www.sitepoint.com/) to a link? So instead of http://www.sitepoint.com/, it would be <a href="http://www.sitepoint.com/">http://www.sitepoint.com/</a>. There are going to be an infinate amount of URL's (the user can type in any one) and it is just not the URL by itself.
How would you make it so that people cannot download your .mdb file straight out of your site and see peoples usernames and passwords and then just log in with their info? Is there a way to block people from downloading the access database?
View Replies View RelatedI'm not very well-versed on developing on NT machines and IIS, but here goes..
I have a script that opens up an odbc connection to a Microsoft Access file (.mdb). This is file, but after I run it, Windows (or something) keeps the mdb file open and I can't reupload it for like, 20 minutes until it finally decides to close it.
I know it's not an asp problem because I've seen this before with Cold Fusion. I also know that it's not isolated to .mdb files because it does the same with a .txt file.
Any ideas? I do have access to the server, so if it requires any configuration changes.
I want to be able to format a year as mm/dd/yy
formatdatetime does not work because the year is yyyy. How do I format a 2 digit year such as 04 for 2004?
When i send a text string to my database linebreaks are stored, but when i call it from asp to the page all linebreaks are lost.
this will reformat text to look different than i was initially typed, how can i make the text shown on webpage in orginal formating.
hope im clear on this or ask and i will elaborate.
does anyone know if there is a function to format date?When my date is extracted from database, it is in decimal format (ie.38233.72078), is there a way to convert this number to date formate using asp?
View Replies View RelatedI have a list of dates in a sql database that are input as varchar like this 042999
How do I insert / in between the date/month and year
so this 042999 will appear like this 04/29/99
Having a pretty annoying format 'error'
The below code works fine,
strMessage = "Logged in as: " & Session("UserName") & ""
but it displays as:
Logged in as:
'Username'
Were as i want it to be:
Logged in as: 'Username'
Any ideas how to make it go to one line?
I have an ASP page taking data from a table. I would like that the data is shown as a % (like 51.456897%) All it shows with my code below is 0.51456897.
Can someone tell me how to change the code so that my % is shown? ....
I have a page where the user can enter some field data, like and address.
They then click on a button which opens a pop-up window, this window is where they enter detailed data. Upon submitting that window, it closes and because of caching, I need to refresh the main window.
Thus, the data (address) that they had previously entered is now gone forcing them to enter it again.
What is the best method to get around this? In practice, the user will definitely enter that address data first.
I am importing a time into a sql datetime field from a text datafile using vbscript in an asp file. The time coming in will look like 8:00 or 3:30 or some other similar thing.
Because it is doesn't have am or pm associated with it, I have to force the issue or sql will assume am all of the time, and I am sure that no judge in our county is going to hear a case in the middle of the night!
So I have to add 12 hours to anthing that could be an afternoon time before I add it to the database to keep it from looking stupid in the display screens.
if we use formatnumber library function in asp it will format the no as per the number format defined in the locale of the server. For example:
some number format look like this 34,135,200 (comma seperated)
some looks like this 34 135 200(blank spaces seperated)
so does anybody have a vbscript function which do this job.
I have the following variable being displayed but i would like it displayed in the default font and text size 2 how is it done?
<% response.write(sUserId) %>
Is there a way to output a date in latin american format?
You know the day first, the month second and the year last.
I have a report that will format a number to the last 2 decimal places. However it will trim off the 0 at the end. Example.
98.90 is formated to 98.9
how can i tell the format number function to not trim the 0 but still have the last 2 digits.
I am storing dates in a mySql database in the format yyyy-mm-dd. Now, I have set up so that this field is insert by a form.
It isn't very user friendly to have to type yyyy-mm-dd, how can I set up so that the user can enter format dd/mm/yyyy and it will automatically insert into the database as yyyy-mm-dd? I am using Dreamweaver MX 2004 and ASP.
I have a querystring that passes through the value 001 for example, the form on the receiving page need to display that number but with 1 added to it. i have
dim strnum
strnum = request.querystring("value")
strnum = strnum + 1
when displayed <%=strnum%> shows 2 instead of 002, and the zero's are very important, is there any number formating trick i dont know or another way of doing this?i thought about coding the first two zero's in before i call the strnum but this would mess things up when i get to 010 etc.
I have a funtion that is supposed to add items in my shopping basket.
It's an array, and each time the user is adding an item, it adds the item to the array with its quantity and size.
I've never used arrays before, read about it, etc...
The only problem is that when it adds the new product, it's not keeping the ones which were there before :-(.
I have used REDIM PRESERVE. So can't find out what is wrong.
Below are the funtions that i use for testing and the coding where I implement them. Code: