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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SM777

  1. SM777

    Intermittent display directory index or correct index.html

    I don't know why the /* is in there. The conf file has been like that on the server for a while. I've removed it now and will have to wait and see what happens. As I said - it's intermittent so it's not clear cut if there is a mistake in httpd.conf which causes the problem.
  2. SM777

    Intermittent display directory index or correct index.html

    This is what is in the main part of httpd.conf: ------------------------------- DocumentRoot "/home/mysite/public_html" DirectoryIndex index.html index.htm index.php IndexOptions FancyIndexing SuppressColumnSorting SuppressDescription SuppressLastModified SuppressSize SuppressIcon SuppressRules...
  3. SM777

    Intermittent display directory index or correct index.html

    I have a problem where Apache will intermittently display either the directory index, or serve the correct index.html I open up a new IE browser and go to http://www.mysite.co.uk/ Sometimes I will either get the correct index.html page displayed, sometimes a directory listing is returned. If...
  4. SM777

    Will Windows XP 64-bit run older FoxPro versions?

    I don't know if it will work with 64-bit windows but foxpro works fine on amd 64.
  5. SM777

    FileSeek() sorting by filename

    I have a routine which scans a directory looking for TXT files ready for parsing. How can I ensure that the files are read in a certain sequence? If the filenames are generated sequentially: file1.txt 10:14 21-May file2.txt 10:17 21-May file3.txt 10:20 21-May Then they are read in the...
  6. SM777

    Tbrowse Question

    That's the ticket. Worked a treat. Cheers.
  7. SM777

    Tbrowse Question

    Yes it's two tables Oldnames and Newnames. There is a relation linking the two. I have tried the straight replace oldnames->name with newnames->names It does update the database, but does not update the 2nd column on the screen. In other words the screen is not refreshing with the new data.
  8. SM777

    Tbrowse Question

    Two databases Oldnames and Newnames. I have a table with two columns. What I want to do is to scroll down the list and if I press F1 I want the data in column 1 to be copied to column 2. i.e. the name in Oldnames to be Newnames .... oColumn := TBColumnNew("Old Name", FieldWBlock("NAME", 2)...
  9. SM777

    Sub Grouping Select Statement

    OK, how about this next conundrum? Think of this more like a stock inventory. How do I list those manufacturers who have 2 or more models in stock? e.g. Ford, Taurus Ford, Taurus Ford, Escort Ford, Taurus Ford, P350 Ford, Escort Mitsubishi, Evo-7 Mitsubishi, Evo-7 Nissan, 350Z Nissan, 350Z...
  10. SM777

    Sub Grouping Select Statement

    Let me try this one next. Same as above, but only listing those manufacturers with 2 or more models. Should return only: Ford 3 models Nissan 2 models I tried SELECT manufacturer,COUNT(DISTINCT model) FROM cars GROUP BY manufacturer HAVING COUNT(DISTINCT model) > 1 but that's not right.
  11. SM777

    Sub Grouping Select Statement

    Think I have it. SELECT manufacturer,COUNT(DISTINCT model) FROM cars GROUP BY manufacturer
  12. SM777

    Sub Grouping Select Statement

    Hmm, all that does is give me the totals for each manufacturer - not their number of unique models. I forget to add that the cars database contains many records: Ford, Taurus Ford, Taurus Ford, Escort Ford, Taurus Ford, P350 Ford, Escort Mitsubishi, Evo-7 Mitsubishi, Evo-7 Nissan, 350Z Nissan...
  13. SM777

    Sub Grouping Select Statement

    I have a database which lists car manufacturers and their models. How can I retrieve data such that each manufacturer is listed as well as the number of models? Data ----- Ford, Taurus Ford, Escort Ford, P350 Mitsubishi, Evo-7 Nissan, 350Z Nissan, Skyline GT-R Required Report ---------------...
  14. SM777

    Clipper on Pentium 4's

    I don't know why I stuck with plain clipper 5.2 and vanilla rtlink over the past few years. I wish I had discovered xHarbour early. It certainly does fly. A few tests on some of my code sees a 3x speed increase. I have a few questions though. 1) Where is the support? I can only find an xH...
  15. SM777

    Clipper on Pentium 4's

    Clipper runs much slower on Pentium systems than on equivalent AMD systems. I believe this is to do with changes to P4's which deprecated the use of 16-bit apps. Is there a way around this? Is it just a matter of using a better compiler / linker? In another thread Xharbour is mentioned. Does...

Part and Inventory Search

Back
Top