After I read in a value from a table i need to read in the last letter of the value and check if it has an "s" as its last letter, so that i can display either ' or 's.
Does anyone know how code to view the last letter of the value or move the variable into javascript so that I can manipulate it from their?
1. The file is on a map drive, which is mapped to a folder
on the same server. Example. The user's folder 'John'.
2. I am able to get the file information
("E:PhotosImage1.jpg") and can copy the file to the
folder. ONCE I KNOW THE UNC ("headoffice-
dellsystPhotosImage1.jpg" file to copy)
I would like to be able to get the UNC from the user's
system, by submitting the drive letter to a function.
This script is for an Intranet and should be in ASP or
JavaScript.
..
i want to query a fields first letter.how can i do this?Code:
strsql = "SELECT * FROM COORD WHERE First='" & Request.Form("UserName") & "' AND last LIKE '%" & right(last,1) & "%' and active ='" & Request.Form("Password") & "'"
I want the search last by only the first letter of there name.
i need to convert the first letter of a veriable to uppercase (the veriable is loaded and the applied LCase() ).
View Replies View Relatedim building an ecommerce site. I asked the client to populate the database i built with all 3000 of their products. They have done this, but put all the data in in CAPITALS. Ive tried 'capitalising' (first letter of each word is a capital) the words in css, but that doesnt work because the letters are all in caps (it would work if they were in lower case).
Has anyone a function written in asp (jscript) to achieve this? Or should I try doing this in sql if this is possible?
I want to take a value that users type into a field (actually 2 fields--first and last name) and convert the first letter to Upper Case. I thought I could use UCase, but it seems to only work for an entire string.
View Replies View RelatedWe have an ASP VBScript email autoreply. I'd like to make it extra squeaky-clean and have it auto-capitalize the user's first name if they did not. I.e.
"Dear bob, your order has been placed."
to
"Dear Bob, your order has been placed."
I realize that probably the pro way would be to normalize it in the DB when they first sign up.. but this is not necessary, I just need some kinda left-trim-uppercase-codeamabob.
I am using asp and access database on my page Up untill now I have just been listing all catagories from the database on one page, now the list has become huge.
I would like to have a page with an alphabetical list of links A, B, C etc and then just display the catagory records beginning with A etc depending on user input.
What query would I have to use to select entries from a database where there first letter is a letter of the alphabet? ie. Select all entries starting with an A etc.
View Replies View RelatedI have records where I need to replace one letter with another. Can I modify this highlighting code to do that?
What I need to do is to update my table of database where a column has to replace one letter with another. WHat I have is the "insert into" statement where I duplicated the table (not shown below) Code:
How to make first letter of word in upper case?
i.e. hello should return Hello
Is there any inbuilt function?
Basically i have a string with a value that either starts with U or N.
If the string starts with a U, I would like to chop that U off but leave the rest of the string. If it starts with an N, then i would need to keep the N on the string. For example,
strUID = U369373
If strUID = 'starts with a U' Then
'Chop off the U to create 369373 instead of U369373'
End If
Should be a fairly easy logical statement, but i just forgot the variables to do that.
when I ourput data from Access, numbers bigger than 999 are shown with letter "B" inserted into the 4th position left to the coma. (in my w2k regional settings I have the decimal dot separator set to "." and digit group separater set to nothing. In Access the number are shown with "." as decimal separator, but for some reason ASP used "," instead)
Say, 3000,00 is shown as 3B 000,00 Why and how do I sort this out?
I'm querying a table and the column has 6 positions. I need to check if the 5th position is a 2,3,6 or 7. If so I want to set a variable = "Y". Can someone help me out with this?
View Replies View RelatedI am using position feature for images...although its placing the image on the HTML file using the top left corner of the image. Anybody know how to make it use the center of the image?
<img src="image.gif" style="position: absolute; left: 54; top: 34">
I have a access db and I want to pull some info out of it with VBScript. How can I specify a starting record?For example, I want to start at the 15th record and pull everything beyond that out.
View Replies View RelatedWhen a page is opened is there a way to set focus of the cursor to a named input. I want the cursor to be in the input box when the page is opened.
View Replies View RelatedI've just gone to Google and there's a link saying "add world cup live
scores..."
I clicked on that link and there are a whole lot of boxes containing content
that I can pick up and drag around, changing their relative position on the
screen.
Fantastic - but how do they do this (were can I read up on this?)
I have been working on this site for the last couple of weeks and i am now in the process of testing and have found a problem.
Basically it is on my jscript function. I have written that if the value is >= 2000 do something else do something else, which is fine with the exception that the value isn't always going to go up in 1000's (sometimes it will be 1-10 others 500-5000 others 1000 - 10000[these values are generated within select tags]).
Basically i am wanting to know is there any way that i can use the select tag to work out the position from within the tag. For example if the position >= 2nd in list do this else do something else.
I have put serveral panel controls within a page, each of them matching to a action defined by buttons, so I want to fix all panels in one place( they already have same size, but different left, top values), how can I do it (in code, if I do it in desgn, is there a way to put the panels in different "layers" so the contained controls will not interupt with each other)?
View Replies View RelatedI use an array of elements and I want to know the position of a given element in my array
I know the filter function that allows to determine if the element i look for is in the array but this function doesn't allow me to know its position.
how do i find the occurence and position of a variable in a csv string. e.g. how do i find "hello" in hi,who,where,how,hello,greetings,xmas,etc. The starting position and if it occurs ? I tried using instr but cant seem to get it right.
View Replies View RelatedI need to figure out how many instances of a certain letter appears in a string or array. The result should appear in a message box, looking something like this:
- The letter a appeard 2 times
- The letter b appeard 5 times
and so forth.
Any ideas on how to acomplish this?
I have a dynamic table asp/vb that is returning records as expected. There are 7 fields that are returning boolean values based on whether there is or is not a meeting on those given days.
My table is returning TRUE and FALSE and all I want to do is create an if or select statement that will detect the values in these fields and change them as follows:
If true, then field = "R" (Wingdings2 R is a checked box)
If false, then field = "T"(Wingdings2 returns a x'd out box)
how to create automated MailMerge which creates a form letter using SQL connection using ASP?
View Replies View Relatedi want to make a data field with an auto numbering , but i exactly want is like this CT-1 , CT-2,CT-3 , the Ct letters must be before the autonumber , so its seems to me in that case i cant choose the dat field in my db as int and choose identity Yes cause the identity seed will be an integer only and no way to put with it a number.
so i want to make throw asp and put this datfield as a char so it can accept the(letter-number)value , so how can the asp make an autonumbering, and know what the lastnumber so it can add 1 to it.
I'm trying to grab my form field and convert the first letter of each sentence to a capital letter, and the rest of the sentence lowercase (except for I, A etc..)
I've searched all over the place, and only came across functions that convert the first letter of every word to upper case. Now they call these proper case functions. I was taught in grade school that proper case is the first letter of a sentence is capital, and the rest are lower case. So WHY does everyone call these functions proper case functions??!!?? Ok enough venting.
Anyways if you know where I can find a similar function please help me out. I'm sure I could code this, but I just don't have the time right now, and I'm tired, and the Colts lost.
I am having a prob with getting for example, ASP Free Forums > Programming > etc, to display properly. I can get it to work sort of but need to be able to read in a value and be able to change it before its displayed.
It works on the first page but when going to other pages it doesn't. Also when going back to the original page, topic.asp where it works, from view topic the formatting disapears which is a mystery to me. Here is the code that gets it to work on the topic.asp page:section = Trim(Request("Section")) Code:
The code below takes the script name of a page (which is always an asp file) and substitutes the asp extension with html and then inserts the file in the <frame> tag.
This code works file for a url such as www.somesite.com/file.asp But if the url includes an index eg www.somesite.com/file.asp#position1 how do I get the #position1 added to the file name that is used in the <frame> tag? Is there a server variable for # info? Code:
How can I delete an specific position within a vector?I have a list of e-mails to be sent but there's duplicated values which I'd like to remove.I added a function that locates the duplicates and tells the vector position I can find them, but don't have a clue how to remove them.
View Replies View RelatedWe have a page that loads a long list of things. Each row has an onclick where you can open a window for more information. When you do that the parent page refreshes to the top of the page....so if you were near the bottom, you would have to scroll back down to get back to where you were. I would like the parent page to hold its position when the child opens.
View Replies View RelatedIm attempting to grab results from a stored procedure and toss them in a recordset. Unfortunately, I cannot open a recordset that can move forward and backward. I have tried to simply chance the rs.CursorType but this results in a connection timeout..
Code: ....
how to change the ordinal number of a field and the field datatype in Access using ASP?
View Replies View Related