how to remove double space in text erea b4 add DB


message = request.form("message")

anyone know how to remove the double spaces and replace with single space b4 enter my database
Posted On: Thursday 11th of October 2012 05:34:01 AM Total Views:  210
View Complete with Replies

RELATED TOPICS OF ASP PROGRAMMING LANGUAGE




double statements

Originally posted by : Artemis (sanchez@ccso.org)I am not getting the correct Response.Write when I run it. If I only type the LastName field, it is okay, but when I try to enter the first name and the date, I get something that says that there are no records when I have seen it. I have noticed that I get double statements such as the following:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:documents and settingssanchezMy DocumentsRMSCAD mscad.mdbSELECT * FROM tblCFS WHERE BusLastName like 'knights%' AND BusFirstName like 'barbara%' AND DateReported = #1/6/1994#BusLastName like 'knights%' AND BusFirstName like 'barbara%' AND DateReported = #1/6/1994#.Can someone suggest anything\tThis is my code:
VIEWS ON THIS POST

110

Posted on:

Thursday 11th October 2012
View Replies!

How can I remove an item from an array?!


VIEWS ON THIS POST

221

Posted on:

Friday 12th October 2012
View Replies!

How to remove characters from a string

HiI have a string called "stringQuery" made up of characters and spaces.\tI have calculated the total length using len(stringQuery)There is a word in the string "or".\tI would like to remove everything to the left of stringQuery up to and including this word.I have used the function InStr to work out where in the total string the word "or" appears.\tI have done this as follows:dim characterscharacters = InStr(1,strQuery, "or")Please can anyone tell me what function or how to remove all the characters and spaces to the left of this string\tBasically what I need to do is subtract 'characters' from the total string length but I'm not sure how to do thisThank you for any help.
VIEWS ON THIS POST

213

Posted on:

Monday 15th October 2012
View Replies!

how to permanently remove apostrophe

help me again , I am only new in ASP world and my knowledge is not so broad.I have a back end MS Access. I need to remove the apostrophe. i mean like this: ASP's .Net when I add this i got a syntax error. i don't know how to remove, replace or escape this before they passed to and from the database using web pages. all the value with apostrophe I got syntax error.please help me.
VIEWS ON THIS POST

205

Posted on:

Monday 15th October 2012
View Replies!

remove http:// charcters from string

hii want my users to enter a web address as www.bbc.co.uk for example not http://www.bbc.co.ukif they do enter http:// at the start how can i best remove it before sending the result to the database thanksI thought of doing something like CODEleft(str, 7)if str = "http://" thena = len(str)replace str(str, mid(str,8,a-7))
VIEWS ON THIS POST

242

Posted on:

Monday 15th October 2012
View Replies!

remove duplicates but distinct wont work...

! im currently making a report page that shows all items bought in our site. im fetching values from 2 tables : products & orders. my query is working fine but it also shows duplicate entries.here is my sql query: SELECT distinct orders.pid_ordered,orders.orderdate,products.prod_id,products.costused,products.cost1,products.cost2,products.cost3,products.cost4,products.price,products.timesbought,products.prodname FROM products,orders where DateValue(orders.orderdate) BETWEEN #1/2/2004# AND #1/7/2004# AND products.prod_id = CInt(orders.pid_ordered) order by products.timesbought desc The prob lies in the "distinct", i was able to determine that the reason it wont work is that every product id in the orders database has different order dates so it was regarded as a distinct row. how can i still fetch the needed data without duplicates im not quite familiar with inner joins, is it the solution _______________CRYOcoustic_____________
VIEWS ON THIS POST

246

Posted on:

Tuesday 16th October 2012
View Replies!

remove the page.asp after the link

I have a curiousity.\tHow can I remove the page.asp link from the address bar\tFor example I have a link called www.mysite.com/page.aspf=1, after the user clicks on the menu navigation.\tHow can I get rid of page.aspf=1 so that only www.mysite.com appears\tAnother thing, will request.querystring still work then
VIEWS ON THIS POST

231

Posted on:

Tuesday 16th October 2012
View Replies!

how to remove comma from text area

I am using a text area for multiple selection of entries through which i want database columns to be searched. but when i get a reponse on the next page, i get it with comma inserted in between multiple selected entries. how shuold i deal with it, so that it is searchable within a column of a database..
VIEWS ON THIS POST

212

Posted on:

Thursday 18th October 2012
View Replies!

Delete button to remove corresponding row in sql server 2005 in asp apge not working

hi , I would be really grateful if you could help me. actually i have got a table in asp page which each row having a delete button.when i click the button the corresponding row in the sql server mudt be deleted. pleas find some of my codes below Server.ScriptTimeout = 7200 if request.form("btnDel") = "Del" then call DelRow() end if sub Delrow() dim sql dim record sql = "DELETE FROM Q_table WHERE QCode='" &Request.Form("txtQCode") set record = Server.CreateObject("adodb.recordset") set record = con.Execute(sql) end sub sub LtQu() str = "SELECT QCode,QTitle,A.ABody,Date,ExpiryDate " & _ " FROM Q_table as QM INNER JOIN ABody as A ON A.ABodyC = QM.Abody " set record = Server.CreateObject("adodb.recordset") set record = con.Execute(str) RecCount = 1 do while not record.eof 'str = str & " & "" & "^" str = str & & "" & "^" 'str = str & "^" & "" & "^" end sub
VIEWS ON THIS POST

252

Posted on:

Wednesday 24th October 2012
View Replies!

Function to remove text between html tags

can someone help me create a function to remove text between html tags (so that all I have left is the html tag itself
VIEWS ON THIS POST

232

Posted on:

Friday 26th October 2012
View Replies!

2 dimensional array -> remove order (redim?)

hello experts, question to you.. I created a shoppingcart by using a 2 dimensional array. It al works fine, so adding items works correctly and removing items from the cart almost correctly. This is why i need your help. The first dimension of the array contains productcode, price, quantity etc... (4 elements in total) The second dimension contains the actual orders. Lets say i put 4 orders into the shoppingcart: 1 2 3 4 Example: When i remove order number 2, then the array has to be resorted. This all works fine but now i have order number 4 twice, because it wasn't actually removed. Here is the code: Code:
VIEWS ON THIS POST

168

Posted on:

Friday 26th October 2012
View Replies!

Auto-remove bounced email addresses from mailing list

I'm about to build a website which houses a mailing list. The site is hosted on a shared server - I don't have access to the server in terms of installing components or configuration or anything like that. I'm going to operate the list via asp - using a CDONTS loop or JMail to send the mail. I need to do one of two things however, to make sure the list is maintained and accurate. Either: 1. Somehow record bounced emails, so that they are flagged as 'expired' in the database, or even removed. Is this possible using ASP or any common mail component Or: 2. Periodically (e.g. every 90 days) send out an email to the entire list, asking them to confirm their registration. In this instance, how do I automate the script to run every 90 days without an administrator having to remember My hosting company offers a mailing list service, but it won't integrate into my database (which is something I really need, since the mails will be bespoke for each recipient - depending on what information they have signed up for). If anyone could shed any light on the best way to do this, and how it can be achieved, I'd be really grateful,
VIEWS ON THIS POST

428

Posted on:

Friday 26th October 2012
View Replies!

How to remove blanks from a list menu??

One of my tables is used for two purposes so there are blanks in the column I'm filtering. I tried using an IF statement but it still put the blanks in the list menu. Any idea how to remove the blank items\t My code: Code:
VIEWS ON THIS POST

254

Posted on:

Friday 26th October 2012
View Replies!

remove multiple lines?

i'm creating an app where the user will copy/paste BIG word documents into a textbox to save into db. problem is -> some of the documents have a lot of whitespace which needs removed. anyone know of a script / method to remove multiple lines of whitespace i.e. if i come aross a large portion of whitespace (extra lines) i want to remove them and leave only one line in it's place. tia.
VIEWS ON THIS POST

210

Posted on:

Friday 26th October 2012
View Replies!

how to remove the gap between 2 images

i have problem in removing the gap between two images, pls see the attached image. coz my item name is quite long, i dun wnat it display in horizontal, i want it display as vertical. so i create the images for the character and use ascii to recognized it. my code is as below: can anyone help\t
VIEWS ON THIS POST

459

Posted on:

Friday 26th October 2012
View Replies!