Showing posts with label field. Show all posts
Showing posts with label field. Show all posts

Saturday, March 31, 2012

SendKeys In A Webform

I have a button to insert text into a field, after inserting the text i would like to set the cursor at the end of that text to then complete the entry
I can set the text and the focus
txtNewPrice.Text ="$"
txtNewPrice.Focus()

But how can i use the send keys to move to the end of that text
In a Windows world i would do this but i dont seem to have that function in the web world
SendKeys.Send("{END}")

you can try using javascript for that


Could you give me an example


Hi

I needed something similar this weekend. Found this and it works fine.

http://www.velocityreviews.com/forums/t70952-set-focus-and-cursor-at-end-of-text.html

Thursday, March 29, 2012

Separate two words

Hi: I have data where first and last name are in one field. I need help
how to i separate first and last name in ASP

Thanks,ASP or ASP.NET?

VB.NET or C# ?

ASP:

dim str = "Bruno Alexandre"
dim aArray

aArray = split(str, " ")

response.Write("First Name: " & aArray(0) & "<br/>Last Name: " & aArray(1) )

ASP.NET:

dim str as string = "Bruno Alexandre"
dim aArray as array

aArray = split(str, " ")

Label1.Text = "First Name: " & aArray(0)
Label2.Text = "Last Name: " & aArray(1)

--

Bruno Alexandre
"a Portuguese in Kbenhav, Danmark"

"Eric" <ehtisham@.gmail.comescreveu na mensagem
news:1155161104.634833.310800@.75g2000cwc.googlegro ups.com...

Quote:

Originally Posted by

Hi: I have data where first and last name are in one field. I need help
how to i separate first and last name in ASP
>
Thanks,
>

seperating an address field....?

Does anyone know an easy way to seperate an address in one database field into a couple of different fields.

if i have the following in one table

address:
1234 Main St.

number road_name Type
1234 Main St.

is this possible?It is very much possible. Just make fields for different sections of the address.

id
addr_streetNumber
addr_roadName
addr_type

I usually store the whole street as one then store the city/state/zipinformation in different fields. What db are you trying to dothis for?
it is sql server.

the issue i'm trying to figure out is that the addresses are not in thedatabase in a consistent manner. Here is a random sample of whatmy be in there. I thought about using the split() method, butknow I don't think this is the way to go.

Thanks for the help

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
6011 CENTURY OAKS DR

3224 S HI LO CIR

P O BOX 11400

4105 9TH AVE.

1109 JORDAN LANE
I've spent a lot of years in the mailing industry and I knowall-too-well how inconsistent user-entered data can be. The firststep is to make the data consistent. My suggestion to you is topurchase an address standardizationprogram. This will go up against a USPS database and correct yourdata, and as an added bonus plus it can field your data automaticallythe way you need.
"My suggestion to you is topurchase an address standardizationprogram"
Any suggestions on a good product? Does it allow batchprocessing? We have about 20,000+ records that need to bevalidated and seperated.

Thanks.
Is this an ongoing need or one time only?

Personally I've used BCC Software'sMail Manager product for bulk address processing. And I've usedMelissa Data's APIs for individual address standardization from within an application.

If this is a once-and-done process, Melissa Data is one of many companies offeringCASS certification as a service, and they price their service per thousand records.
one time thing. thanks for the help... i'll look into those options.

Monday, March 26, 2012

Sequence problem in database

Hi,
I create a database in access. For example, There is a table named 'table1'.
There are 3 field in this table,'projectId','taskId','description';
The data type of taskId is sequence.
When i add any data in this table, i want the value of taskId to be increased according to projectID(also project ID is sequence) Is it possible?If so, how?

Thanks!For example:

projectID TaskID
1 1
1 2
2 1
2 2
2 3
1 3
1 4
3 1
2 4

blah..blah..

Thanks!