1 Topic by andrewgrz

(1 replies, posted in Code)

I have a database table called contacts with a table in it called addresses. The fields in the addresses table are firstname, lastname, address, city, state, zip, areacode and phonenumber. (The state field is a 2 character text field.) I want to ask the user for a state and then I want to display all the records for that state only. Can anyone help me?

Thanks,

Andrew

Go to forum: Code

2 Topic by andrewgrz

(1 replies, posted in Code)

I have a comma delimited text file with several records. A typical record looks like this:

Jim,Smith,1234 Main Street,Anytown,NY,12345,206,123-3456

I need to read the file andd then output the data (name and phone number) in a two columm table like this:

Smith, Jim        (206) 123-3456

The data also needs to be sorted by last name.

I assume I will be using an array, but I'm not sure how to do it.

If you can help me, email me at grz@wi-net.com.

Thanks,

Andrew

Go to forum: Code