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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: SM777
  • Order by date
  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

    ...IndexOptions FancyIndexing SuppressColumnSorting SuppressDescription SuppressLastModified SuppressSize SuppressIcon SuppressRules IndexIgnore .?* *~ *# HEADER* RCS CVS *,v *,t --------------------------------- Then in the Virtual Server Section: -------------------------------------------...
  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 ---------------...
    • SM777
    • Thread
    • Replies: 6
    • Forum: MySQL
  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...
  16. SM777

    select data from within the last 28 days

    I'm trying to select data from within the last 28 days using PHP. I don't think I'm getting the right results. This is either due to incorrect select or because of the leap year? $date28 = date("Y-m-d", strtotime("-28 day")); Is that correct or is there another way to do it?
    • SM777
    • Thread
    • Replies: 2
    • Forum: MySQL
  17. SM777

    MySQL server tuning?

    If you mean that the server is showing 97% memory usage then thats normal - don't worry about it. Unused ram is wasted ram. All Linux is doing is using your free ram as buffer or caching. Even if you add another gig you'll find that you'll still have 9x% used. What you need to look at is if...
  18. SM777

    Printing with Lexmark under Win XP

    I couldn't get the Net Use method to work. On investigation I found the following. If you are using a networked printer, and the pc you are printing from hasn't got the printer attached e.g. PC-A = usb printer PC-B networked as peer to peer with PC-A Then you still need to have the LPT1 port...
  19. SM777

    make = undefined reference to `mysql_connect'

    I solved this by removing MySQL 4 and installing version 3.23. This created the correct libraries which are required for dbfmysql. Once compiled, I could then remove 3.23 and install 4 again. But also need to install mysql-shared-compat-4.x as this includes libmysqlclient10 files which are...
  20. SM777

    make = undefined reference to `mysql_connect'

    ...In function `my_uncompress': : undefined reference to `uncompress' collect2: ld returned 1 exit status make: *** [dbf2mysql] Error 1 --- I have had dbf2mysql working on a debian system using apt and that works fine. But now I'm using SuSE and it just won't compile. There is an RPM for...
    • SM777
    • Thread
    • Replies: 1
    • Forum: MySQL

Part and Inventory Search

Back
Top