Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MattRK

    Separating house number from street address

    Well i need to order the records first by thier street address and then by thier house number. so instead of 1 a street 2 c street 3 c street 4 b street it would be: 1 a street 4 b street 2 c street 3 c street -Mr.K
  2. MattRK

    Separating house number from street address

    Yes, but what about apartments? lol 106B S. Something st.. It would break 106 away from B S. Something st. :P Oh well. -Mr.K
  3. MattRK

    Separating house number from street address

    Well, i ended up just cuting and pasteing. lol. But if i wanted to redo it all, how would i break at the first space in the string? I only have like 2 1/2's. I can just do those by hand. Thanks!! -Matt Keller
  4. MattRK

    Separating house number from street address

    I have big database with customer information. There is one address field that contains the house number and the street address. (1212 main st.) Is there a way to seperate the house number (1212) and the street address (main st.) and put them into seperate fields (house_number and...
  5. MattRK

    Postifx delet's my mail???

    Thanks for your help. Your probably right. Postfix it self probably didnt do it. I have decided just to make a dedicated mail server. I might go with freebsd or debian. (both of which i have heard good things about) I'm also going to try to impliment mysql in. Everyone says that is the way to go...
  6. MattRK

    Postifx delet's my mail???

    Ok, i have a server running mandrake 8 with postfix installed. I use imap instead of pop. Well the other day i decided to check my email, and low and behold, my inbox was empty. My /var/spool/mail/$user file was 0 bytes. Empty. Apparently something deleted it. Or erased it. Does anyone know if...
  7. MattRK

    Order by street address

    Yes. What i need to know is if there is a function or a way to extract just the street name, IE: Elm St. Or whatever. Basically anything that isn't a number. If there isnt a way to do this, mabey i could write a macro to extract the numbers and put them into a field of thier own. I havent ever...
  8. MattRK

    Order by street address

    Ok, i havent tried this yet, but just from looking at it, i dont know if it would work. My problem is that i have the address in one field. So the data in that field is 1000 Whatever St. Is: Order by Street_Address,Door_No Specifying those fields? (like do i have to have a Stree_Address and...
  9. MattRK

    Order by street address

    Ok, i have a small problem. I want to order fileds by a street address. The address looks like: 1234 Main St. How do i order by street address so that it looks like this: 1111 Main St. 1112 Main St. 1111 Norway St. 1112 Norway St. 1111 Other 1112 Other ETC. -Matt Keller.
  10. MattRK

    Windows and Linux text files problem

    Thanks for all your help. I found that KWrite (kde's advanced text editor) has an option to do dos, linux, or mac line endings. So i just chose dos. I also found that textpad can do the same on windows. So i'm good from both ends. Thanks again for your help. -Mr.K
  11. MattRK

    Windows and Linux text files problem

    Ok, I have a laptop with a 30 gig drive in it. I partitioned it into 3 different drives. A 5 gig for windows, a 20 gig for sharing, and a 5 gig for linux. The first drive is an ntfs file system, the second (the 20 gig) is a fat32 file system, and the last is whatever linux uses (ext2 I think)...
  12. MattRK

    WU-FTP showing all files?

    hahaha, i love answering my own questions. It is in the client it self. Like in leapftp, i just had to change the list command to ls -la. I didnt know you could do that. Lol, i guess ill search the web more often. -Mr.K
  13. MattRK

    WU-FTP showing all files?

    No, i dont think you understand. When i am ftp'd into my system via an ftp client (wu-ftp, cuteftp, leapftp, etc.) It only displays regular files. I want it to display all files, including hidden files such as .whatever files. Thanks! -Mr.K
  14. MattRK

    WU-FTP showing all files?

    I use wu-ftp. Everything works great. The only thing that bugs me is that it doesnt show hidden files!!! Like .htaccess files and the sort. Is there any way to configure it to show these hidden files? Thanks!!! -Mr.K
  15. MattRK

    Conrol Source Binding!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Thanks for all the advice. Heather, that is what i finaly did. I wasnt sure how subreports worked, but after playing with them for awhile i finaly ended up using them. I created my 7 differnt reports and then on "Master" unbound report and added each of the 7 reports as subreports...
  16. MattRK

    multiple queries on a report

    This is a little late, but i would like to know how. Mabey you can explain a sub-report to us. Thanks for any help you can provide. -Mr.K
  17. MattRK

    Conrol Source Binding!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Ok, mabey im asking the wrong question. Sorry. :) What i have are about 7 differnt querys that i want to include in a report. I just want it to look like this. Query 1: -------- data data data Query 2: -------- data data data etc... Nothing fancy, i just want that report to display all 7 (or...
  18. MattRK

    Conrol Source Binding!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    I dont have a linking field. How would i create one of these?
  19. MattRK

    Sql problem

    Thanks!!

Part and Inventory Search

Back
Top