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: *

  1. TonyGroves

    import gimp web layout to an actual website

    Sounds like you need to learn HTML. There are loads of books and online tutorials out there. Regarding uploading files, your ISP probably provides a file-upload facility, otherwise you could use FTP.
  2. TonyGroves

    ksh: script_name not found

    This sounds a bit obvious, but does the user have executable permission for the script?
  3. TonyGroves

    Difference of days in terms of Year, Month Week and Day

    Trouble is, how long is a month? 28? 29? 30? 31 days? Even a year: 365 or 366 days? Weeks and days is the best you can reliably do, as far as I can see.
  4. TonyGroves

    Advice for multilingual site

    Sleidia, it wasn't a stupid question and you weren't bothering anybody. You asked for our advice and we gave it, which you're free to accept or reject. Any design that works acceptably well for you is perfectly valid, whether it conforms to supposed "best practice" or not. Best of luck with your...
  5. TonyGroves

    Advice for multilingual site

    I wouldn't hard-wire the languages into the database structure; it makes it difficult to add new languages, makes queries complicated, and violates relational principles. In a situation like specifying translations for strings I'd use a translations table, with columns for (1) language code...
  6. TonyGroves

    Loading Data into MySQL from a Text File

    What I mean is, install a MySQL client program such as one of the GUI clients already mentioned, on your own computer. Using that client program you can execute queries on the remote database from the comfort of your computer, without having to use SSH. Assuming that your hosting company allows...
  7. TonyGroves

    Loading Data into MySQL from a Text File

    Another approach you might like to consider: Install a MySQL client program on your computer. Edit the CSV file to produce an SQL command file. For example: 123 happy 456 christmas becomes: insert mytable (id,message) values (123,'happy'), (456,'christmas') Connect the client to...
  8. TonyGroves

    which linux distribution is good for a dedicated server

    Just thinking, we haven't had a distro flame war for some time now; this would be great opportunity for one! Seriously though, Pentode's help-me-decide link is a good one, go with it!
  9. TonyGroves

    Borland C++ IDE

    My instinct would be to assume that the IDE adopts whatever locale the OS is running; if you change the Windows locale to English, C++ Builder would turn to English. Have you tried that?
  10. TonyGroves

    Using multiple drives for data

    If you were running Linux, you could (as hvass said) simply use softlinks to link to files and directories on other volumes. I've never done that myself, but I see no reason why it wouldn't work. But of course you're running Windows, so that's no help to you.
  11. TonyGroves

    MySQL and Access 2007 - currency format

    Can you show us a sample line of the file?
  12. TonyGroves

    Speed Up In Statement

    I was missing something.
  13. TonyGroves

    Speed Up In Statement

    That seems unnecessarily complicated. How about: select * from Tbl_Members group by MemberNr HAVING count(MemberNr)>1 order by MemberNr desc; Or am I missing something?
  14. TonyGroves

    Loading Data into MySQL from a Text File

    I've no idea why you're getting that error but at least if you eliminate the extra layer that SSH imposes you're eliminating a source of possible error. If you have the MySQL command-line client installed locally (which you probably haven't) you can use the connection command already given...
  15. TonyGroves

    Loading Data into MySQL from a Text File

    You shouldn't need to use ssh, it just adds another layer of complication. You could just connect directly to the database via a local command shell or GUI.
  16. TonyGroves

    Loading Data into MySQL from a Text File

    Sorry, I've been asleep. That looks like a bash (system command shell) error. I can't understand why you'd get that if you're safely inside the MySQL command shell, which you seem to be. Are you able to run simpler queries with no problem?
  17. TonyGroves

    Problem with select statment

    Trouble is it's not PHP. Looks more like a mix of Basic and SQL. The SQL part needs to be wrapped into a PHP string before being executed.
  18. TonyGroves

    Loading Data into MySQL from a Text File

    MySQL Query Browser (free from MYSQL) is good.
  19. TonyGroves

    Loading Data into MySQL from a Text File

    First you have to connect to the database in some way. On the command line it would be something like: mysql -h myhostname -u myusername -p mypassword mydbname That will bring you into the MySQL client shell where you can enter SQL commands and queries. The "mydbname" in the command specifies...
  20. TonyGroves

    Increment DB Column Value using HTML Form

    That's almost exactly right; have you tried it? UPDATE tablename SET col1=col1+1, col2=col2+1 WHERE id=1234

Part and Inventory Search

Back
Top