Trim Function

I need to select records from table where right part of Field1 = strTest

the table looks like:

Field 1 Field2 Field3
5159-10 2 3
5159-20 6 9
LS5598-20 8 9

strTest=5159 or LS5598 doesn't matter

should be something like "select Field1 from tabTest where " & Right(Field1, 3) & " like " & strTest & "

Obviously I'm wrong somewhere, could anyone tell me where?

View Replies


ADVERTISEMENT

ASP Trim Function?

I'm creating a website that will have a page that lists current news
items. The news items will be stored in a SQL Server database and will
have basically two fields, the date and the news blurb . . . On the
main page of the site, I want to have a box that shows "Current News"
and only pulls the first 7 or so words from the news blurb followed by
a ... [more] where [more] is a link to the current news page.

For example, the database entry may be something like this: Code:

View Replies View Related

ASP Trim Function

i need to use the trim function trim("str","?"). How do i remove the "return sign" from a string?

View Replies View Related

ASP Trim()

i'm having some trouble with the trim function. I have a date 04/18/1982. I want enter the value 1982-04 into the database. The code i'm using is:

strEXPDT = replace(right(left(request.form("Expiration_Date")2)4),"'","''")

View Replies View Related

Trim

I am constantly in need of help, I am back again. I am slowly, slowly getting my page to work. Here is the latest of my queries. I want to automatically make a username by trimming the first character of the first name and taking the entire last name, and putting it in strUserName, I am a little iffy about TRIM (what else is new) rofl. Anyway the user name I want to take the first 3 characters from postal/zip code and the first three numbers from phone number and make the password. Here is what I am thinking of course it doesn't work. BIG SURPRISE!!!

strUserId = Trim(RS("FName"),1) & RS("LName")
strPassword = Trim(RS("PCode"),3) & Trim(RS("Phone"),3)

View Replies View Related

Trim Numbers

I am converting bites to Megabytes in an operation. How would I trim the result to only go to 2 decimal places?ex:

Response.Write(file.FileName & " (" & (file.Size/1048576) & "Mb)<BR>")

View Replies View Related

Using Replace And Trim Together

This should not be this tough but I may be thinking too hard about it.
Here's what I have:

thenames="charles,sam,chris,"

How do I do remove the last comma? I tried using trim and replace
together but couldn't get it.

View Replies View Related

Trim String

How do i cut the last 4 characters in a string?
I know how to cut the 4 first, but i need to cut the last!
I have a image name like testimage.gif and I want to cut away .

View Replies View Related

Trim Leading

I have a textarea, that when you insert your cursor into it anywhere except for in the very first line, the cursor falls into the second line. When the form is submitted there is a carriage return at the beginning of the text that I'm having trouble getting rid of.

I tried to Trim() the string both before inserting it into the database and when writing it to the page, but apparently that doesn't strip off carriage returns (even though I've read it does.)

View Replies View Related

Trim Text

how to use ltrim, rtrim to trim the beginning and end of text entries for extra spaces. I was wondering if there is a way to trim extra spaces from WITHIN a text entry.

Example:

change
John and Linda
to
John and Linda

View Replies View Related

Trim Whitespace

does anyone know if it's possible to crop whitespace regions from around the edges of an image using Imagemagick?

I have a whole bunch of signature images (as in, people's handwritten signatures) and I'd like to crop them so that there's no whitespace margin around them. I can do the cropping fine, it's just detecting the color regions.

View Replies View Related

Trim All Characters After The First "

I need to do is remove ALL characters after and inc the characters "." found in a variable. i have a variable which holds device with DNS name such as E096064-FWSM2.netdevice.companyname.com

i want the variable to just hold the name E096064-FWSM2 the extension after the first "." can very greatly so i can not specify all possible options as i just do not know what they are going to be.

View Replies View Related

Trim Return Caracter

I make a csv file with values from data base fields . If my value contains a carriage return caracter at the end, a new line is created in my csv file. I tried to replace chr(13) caracter by an empty caracter but it doesn't work, my code is:

Replace(Trim(element.value), chr(13),"")

Do you have any idea to resolve my problem?

View Replies View Related

Trim() Doesn't Work

I cannot figure out why this won't work, but I cannot get the trim() function to work for me. I tried this test code just to see if I could get anything:Code:

<%
String = "This is a string"
response.write String & "<br>"
Trimmed = Trim(String)
response.write Trimmed

And the results are both the same.This is a string.
Can anyone think of any good reason the Trim statement wouldn't be working I cannot think of any other common ASP function that isn't working for me.

View Replies View Related

Trim Request.Form

its ok to use just

Trim(Request.Form("txtFromName"))

or to use both
rTrim(ltrim(Request.Form("txtFromName")))

View Replies View Related

Trim String And Indexing Server

Ok, I have this code:

For i = startCt To endCt
' Get the document title. If it's blank, set it to "Untitled".
Dim docTitle,path,desc
Dim tObj
Set tObj = results1(i)
docTitle = tObj("title")
path = tObj("vpath")
desc = tObj("desc")
.......

Now, results1 comes from the ms indexing server.

Problem with some of the results is the title is an empty string, so no link.

If I query the catalog in comp mgnmt, no problems.

So, indexing problem or something else.

I can use the path and get the doc name there if empty.

Also, does asp have a string.trim like .net? ....

View Replies View Related

Difference Between Private Function And Public Function?

What's the difference between private and public functions in ASP? When should I use either?

View Replies View Related

How Can I Add Mail Function To That Post Function

I am using a simple guestbook /portal and i want script to send mail to the thread owner when someone reply his message.

this is the send message code ....

View Replies View Related

Function Inside A Function

Can I define a function inside a function. e.g;

function abc()
function xyz()
....some code.....
End Function
End Function

I googled this but can't find any related topic.

View Replies View Related

Function In The InStr Function

I want to use the instr function, but return results from it depending on surtain functions, I can't realy explain so I'll show my example:

I have a string in wich some word I want to find might be in diffrent Capital Letters order, I want the Instr function to return all the values of the place of that word (avcourse I'll run a for and increase the starting point of the Instr func until it returns 0). The instinct thought is to use the Lcase or the Ucase functions, but in this case I don't know how to use them. In the same Idea I wanted to use the Instr Func with the trim Func, But Its realy the same principle if I just understood how to do so.

View Replies View Related

Asp Function

I am trying to call a function in asp to check to see if a varibale has a value stored in it if there is nothing wite the value NA into it. My code is

<%
Function NullValues(userField)
if userField = "" then userField = "NA"
end function

AccountNo = ""
Name = "sam clowes"
email = ""

AccountNo = (NullValues(AccountNo))
Name = (NullValues(Name))
email = (NullValues(email))

response.Write AccountNo & "<br>"
response.Write Name & "<br>"
response.Write email & "<br>"
%>

When I run this code ALL the variables are blank and nothing is output

View Replies View Related

XML/XSL & ASP Function

the function
<%
Dim objXML, objXSL

Function ShowXML(strXML,strStyleSheet)
Set objXML = CreateObject("MSXML.DOMDocument")
Set objXSL = CreateObject("MSXML.DOMDocument")
objXML.load(Server.MapPath(strXML))
objXSL.load(Server.MapPath(strStyleSheet))
Response.Write objXML.transformNode(objXSL)
Set objXML = Nothing
Set objXSL = Nothing
End Function
%>


calling the function in an asp file
<%Call ShowXML("http://msn.foxsports.com/feedout/syndicatedContent?categoryId=142","nhl/xsl/news/teamNews.xsl")%>


the errors
1. the http:// part
2. and the ? mark

the error message says that the path has been typed wrong.

View Replies View Related

Function

the user can key in variable A and B
then C is auto generated by C = A / B

so how and where should i write the C function??

View Replies View Related

XML Value Into ASP Function

Possibly a very simple question but how do I get a value out of an XML document so I can play with it in ASP

E.G: <Name>Tom</Name

How do I pull the work tom into asp

View Replies View Related

Now() Function

I am using the now() function to be displayed on an email after a form submission has been sent. The problem is that the server is not in the same timezone as I am for the result. How do I adjust the hours on the now() to allow for this please ?

View Replies View Related

Sub Or Function

I know the basic difference between a subroutine and a function is a
subroutine performs a task and a function performs a task and returns a
value. The Call keyword is required when using parens with subs with more
than 1 parameters. Parens around values passed are ByVal vs ByRef and is a
waste of processing if passed ByRef for no reason.
I am told there is no reason to ever use a subroutine as a function can be
used even if it doesn't return a value. While this appears to be true, is
there any reason why it's ever a bad idea to use a function, instead of a
subroutine, that doesn't return a value? Are there memory, performance,
etc. issues?

View Replies View Related

ASP Function

I am trying to locate information on how to call a sub within VBScript on an
ASP page but I can't locate generic information. What I want to do is
generate a page that will stay up but the information on it will change
based on a series of drop down boxes. I need the first drop down box to call
a second dropped down box based on the state that is chosen then city and so
on.

View Replies View Related

Asp Function

I have a column in the table which contains 2 full names seperated by "&" (e.g: Joe Smith & Jeff Scott) I want to display only the first names of the whole record in an asp page. Is there an asp function using which i can do this?

View Replies View Related

Mod Function

im using the mod function to create a calendar for me, which everything works perfectly, all is totally well with that!
but...when i use the mod function it churns out this loooooooooong string which is the whole table...
if there is some way that i can insert hard breaks IN THE CODE ITSELF.

View Replies View Related

NaN Function

I used to be quite an experienced ASP programmer but I haven't used it for a while

I’m trying to do something that I remember as very simple I'm trying to check that the value of a form text box is numerical using the isNaN function. The code I am using is:

<%
quantity = Request.Form("number1")

if isNaN(quantity) = true then
Response.Write "Your input was not a number"
else
Response.Write "Your input was a number"
end if
%>

All I get is a NaN type mismatch error.

View Replies View Related

Contains Function

Is there a function to check to see if a string contains a space
Thanks

View Replies View Related

Mid Function

I was just wondering when using the mid function how does the assigment work when the length is longer then string itself? For example

test = mid(12345, 1, 10)

What would be the end result of test?Would it be 0000012345 or 1234500000 or 12345?

View Replies View Related

Mid() Function

When I create a single character string

var str = "A"
'convert to ascii
num = asc(str)
Response.Write num ' 65 shows up
'when I have a whole string
str = "hello"
str = mid(str, 1, 1) ' return 'h'
num = asc(str)

'I get an error:

Invalid procedure call or argument:'asc'What can be done to fix this?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved