I have some ASP pages that use ASPmail to generate emails containing infomation taken from an Access database (the info is selected from a random record, in a particular database field, and then inserted in the email text as a variable). When the emails arrive at their destination, they contain a random space. The position of the space is completely random. It can appear in the ordinary body text, or in the lines of text generated by displaying the contents of the aforementioned variables.
eg the line in the email may say:-
I am a line in an em ail.
or
I am another li ne in an email.
or
I am yet ano ther line in an email.
Sometimes the space appears in a hyperlink and causes it to fail.....
However, what I want to do is include a request.querystring("ID"), so that IF an ID is defined, eg ID=3, , it will display the relevant (not random) information. I've tried this every way I can think and get type mismatches, etc etc. It's probably really simple but I can't see it.
We have the need to have a random token (a 16 char alphanumeric field) to be used as the key for one of our SQL tables. I have created a random token generator, however after only 3 months in production, it appears that we had an instance where a token that already existed in the tables was created. There are 3810 records currently in the database so it isn't like there are billions of records there.
I contacted an old college buddy of mine who is a mathematician, and he claims, assuming that random really does mean random, that the chances of getting a duplicate token are 1 in 79.5 septillion (79,500,000,000,000,000,000,000,000).
So my conclusion is that this was either a complete freak of nature occurance, or my random generator isn't really all that random. Here is the code behind how I am generating this: Code:
how can I add a space between words in my formtomail script. i know that by putting & VbCrLf & it adds a line break but I need to be able to add a space.
i m using a simple form to cleect user info and i need to chech if the user left any spaces befor or between words and delete it for ex if the user pressed enter many times before typing the data in the text area.
it makes errors in my db so how can i check if there is spaces in the textarea ot text box and delete it?
that works fine but when I just do a simple Response.write(Var_Myname) I end up with something like:
'James'
I don't want these quotes, so the question is can I either correct the Response.write (don't really want to do that each time.or is there a way to ge the text boxes to do their bloody job propper.
I use breadcrumbs for navigation I have a folder called College Students in WWWRoot in college students i have a page called mainpage.shtml when i open the page like this www.abc.com/college students/mainpage.shtml i see the breadcrumbs like this Home >> College%20Students >> Students List but i want to see it like this Home >>College Students >> Students List Students List is the title of the page Can someone tell me how to get rid of those %20 that i see when i have spaces in my folder name
In my createpst.asp page I am trying to load in an array using the split function:
<% Dim arrVals arrVals = split(Request.Form ("pstfldr"), ",") Dim i For i=0 to UBound(arrVals) Response.Write arrVals(i) & "<br>" Next %>
However, the problem is that some of my values that are read in from myArray(i) in the first asp page can be more than one word. So, when I get to my second asp page and traverse through the loop, some of the values stored that contain more than one word only output the first word.
Even when I try using LTrim function, I have one variable that has two mysterious spaces in front of it when i pass it to the next page in a query string
I have written some code to query a database and create a hyperlink based on a value, however, if the value comprises of more than one word, the hyperlink only references the first part of the value. e.g. For instance, if the value retrieved is "the strokes", the hyperlink will only contain the word "the".
Below this code causes and error because there are spaces within the "". I can't change the name of the field, so I need to find out if there is away round this?
we never guarded againsts spaces in a new site we built. And while checking, a couple of users registered with spaces between their usernames. e.g. afrika 1 instead of afrika_1. Could there be downside to this?
Just a quick one, how can I add a space between words in my formtomail script. i know that by putting & VbCrLf& it adds a line break but I need to be able to add a space.
I have a db auto uploaded to me everyday. I am displaying information from the db, but some of the columns contain spaces. When I use a space in a select statement it obviously does not work. Is there some special syntax I need to allow for a column name that contains a space?
I am using ASP to read code from a text file that I am displaying on my page. Because I do not want the code from the text file to be executed, I used the Server.HTMLEncode() method to display it as it is in the file. However, the spaces used to indent lines is still removed by the browser.
I cannot use VBScript's replace function to replace all spaces with because that would replace all spaces, including ones that I do not want replaced as well as majorly increasing the size of my file. Is there any way to display the spaces used to indent the lines without manually writing a function to do it?
I have a View button that shows a database record of entries. At the end it has a delete link for each entry. When u click it, it passes the Address(like a house address) to a script that searchs the DB for the matching address.
The only problem is most address have spaces. I read somewhere about double quotes, or using single quotes or some combination, I don't remember.
How to keep the spaces before the description line in the following code? Right now, it displays like "Net Income", but I like to have spaces before the words like " Net Income". The database value is " Net Income".
I am running a select statement against a table that has several columns with the name:
like OS Name and OS Type
How do I do my SQL select statement and deal with the space in the column name? Thus far I have tried putting "OS Name".. which has genterated an error Then I tried 'OS Name' which did NOT spin out an error but did not return any data either.
I am trying to generate a random number. I am using randomize and then rnd to return a decimal number between 100 and 120. This will give me a longitude. I am doing something similar to generate a latitude.
I created this on a page which refreshs every minute. I put these points into a map and they are showing up in groups of straight lines. Since rnd is time based will refreshing every 60 seconds return similar numbers?
I have an ASP (3.0, not .NET) app that writes cookies with hyphens and spaces in the names and values. If I had the control over the apps that will be looking for these cookies, I would eliminate the special characters, but as it is, I do not have that luxury.
When I write the cookies, they seem okay in IE, but in Firefox, they are strange. For example, the cookie name is US-NONUS, but in Firefox it looks like US%2DNONUS. For a value of NEW HAMPSHIRE it comes out in Firefox as NEW+HAMPSHIRE.
Please note that these strings are not created in any special way: They are hard-coded into the ASP, with no encoding or anything like that.
i am currently working on code that searches an excel spreadsheet and displays results. Below is the code for the drop down. I was wondering is there a way to modify this to ignore blanks as when i use the drop down, it contains the blank cell spaces Code:
I’m trying to build an application that will flow like this “when the data from my form1 is submitted an auto increment is generated id will generated...I want to be able to used the generated id in other form or page in my application.. this is because the id would be use as foreign key in other table in the database” …is there anybody can guide me on these issue.. I manage to develop it only until the submission of the first form after that I didn’t know how to call the generated id.. For your information I’m using mysql as database.
I am trying to update my table with a value passed though the request.querystring method but as you can see from the sql statement below it is causing errors.
In this case the name of the department as displayed is "Arts and Entertainment" but it is giving me something strange when I try to use the variable
update empprofile set department ='Arts%20%26%20Entertainment' where employeenumber =219104 Microsoft JET Database Engine error '80004005'
You cannot add or change a record because a related record is required in table 'Departments'. Code:
I'm trying to validate several fields using regular expressions and not sure how to allow spaces and special characters within the expression.
One field is for an address:
^[a-zA-Z0-9]+$
how can I allow spaces and special characters like a comma, number sign and periods. So, if some entered an address with a suite number or p.o. box where commas, periods and number signs can be used it would validate correctly. Right now, the expression is only checking for alfanumeric characters.
