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. Stretchwickster

    CSS Object Wrapper for Delphi?

    I don't know of any existing classes for this purpose, so I think you'll need to build it yourself. Perhaps this will give you a starting point. Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err is human, but to really foul things up you need a computer." (Paul Ehrlich)...
  2. Stretchwickster

    Return rows without querying a table/view

    Perfect - thank you very much. I've never used UNION until now. Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err is human, but to really foul things up you need a computer." (Paul Ehrlich) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ To get the best answers from this...
  3. Stretchwickster

    Return rows without querying a table/view

    What I'm trying to do is create a SQL query that internally generates the following result set without querying an actual table/view... DESC ABBR CALENDAR_YEAR Next Year N 2013 This Year C 2012 Last Year L 2011 Older Year O 2010 The respective values...
  4. Stretchwickster

    Excel 2007: Columns overlay when using two y-axes

    Thanks for the info Skip. Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err is human, but to really foul things up you need a computer." (Paul Ehrlich) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ To get the best answers from this forum see: faq102-5096
  5. Stretchwickster

    Excel 2007: Columns overlay when using two y-axes

    Many thanks for your suggestions - they appear to be the only way of achieving what I want. Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err is human, but to really foul things up you need a computer." (Paul Ehrlich) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ To get...
  6. Stretchwickster

    Excel 2007: Columns overlay when using two y-axes

    I've had a good search for the answer to this, but I'm struggling to find anything. In Excel 2007, I've created a chart consisting of two clustered column series. Series 1 is plotted on the primary (left) y-axis, whilst Series 2 is plotted on the secondary (right) y-axis. Both series share the...
  7. Stretchwickster

    Application.Caller Issue

    I guess I'm going to have to go with shorter sheet names due to Microsoft imposing this arbitrary 30 character constraint in Excel 2007 - very annoying. I wish they would ensure backwards compatibility, as I noticed they removed some additional chart properties which threw up errors in Excel...
  8. Stretchwickster

    Application.Caller Issue

    Thanks for the suggestion - but unfortunately it made no difference. It appears that, in Excel 2007, when a string is returned in Application.Caller it is limited to 30 characters. Does anyone know why this limit has been imposed? Or if it's documented anywhere? Any other ideas for...
  9. Stretchwickster

    Application.Caller Issue

    Hi there, On running a macro (originally written in Excel 2003) in Excel 2007 I get a "Run-time error '9': Subscript out of range" error which arises from the following code: Public Sub GoToChart() ' check which text box button called the macro and activate appropriate sheet If...
  10. Stretchwickster

    Determining the amount of RAM

    Many thanks for posting this code Griffyn, I haven't had much time to visit Tek-Tips lately, let alone update any of my out-dated 2005 FAQs! I've updated my FAQ to point to this thread. However, I'm happy to remove my FAQ on this topic, if you're willing to replace it with the finalised...
  11. Stretchwickster

    Mapping hostname to ip address

    Thanks for the tip. My understanding of how it works is a bit clearer now, thanks to your input. Mine did have a single localhost entry until I added my entries. Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err is human, but to really foul things up you need a computer."...
  12. Stretchwickster

    Mapping hostname to ip address

    Now you mention it, this time I did reboot after making the change to the hosts file, last time I don't believe I did. So I think you're spot on there. I think I confused myself into thinking that the hosts file only impacted IIS, and therefore the problems I was running into were related to...
  13. Stretchwickster

    Mapping hostname to ip address

    Many thanks to you both for your input. I'm sure I tried donb01's suggestion before, but after uncommenting the "127.0.0.3 apache" line in my hosts file, typing http://apache/ in my browser now finds the XAMPP welcome page - hooray! Better still, if I start XAMPP first, then start IIS, I can...
  14. Stretchwickster

    Mapping hostname to ip address

    Hi there, Throughout today I've been trying to setup Apache 2.2.12 (installed as part of XAMPP 1.7.2) in a local development environment such that http://apache/ maps to http://127.0.0.3. I have forced Apache to listen on 127.0.0.3:80 so that I can run IIS concurrently on 127.0.0.2:80 (I have...
  15. Stretchwickster

    Backup Copy of Website on Different Server? FailOver?

    Any decent host should have some kind of uptime guarantee and will provide financial compensation according to the duration of downtime. For example: http://www.site5.com/hosting/guarantees/ Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err is human, but to really foul things...
  16. Stretchwickster

    Backup Copy of Website on Different Server? FailOver?

    It's sometimes called "Hosting Redundancy" or "Redundancy Hosting" and probably a host (no pun intended!) of other names too. The web host I use has just surveyed its customers to see whether redundancy would be desirable, given the additional costs required. I did a search for "redundancy...
  17. Stretchwickster

    Finding redundant website files

    Sorry for the delay in replying - many thanks for the suggestions Feherke. Is this a setting in wget or something I need to enable on the server? Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err is human, but to really foul things up you need a computer." (Paul Ehrlich)...
  18. Stretchwickster

    Finding redundant website files

    Hi there, Unfortunately, I've inherited a large site which I believe to have many unused files. Could anyone recommend the most effective way to obtain an accurate listing of such files? Your advice would be much appreciated. Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err...
  19. Stretchwickster

    Backing up stored routines

    Thanks for your reply Daddy. I did read that, but I must confess I wasn't sure how to go about doing that until I spent a bit of time looking it up. On trying the following SQL: GRANT SELECT ON MySQL.Proc to user@host; ...I discovered I don't have permissions to do this on my shared web hosting...
  20. Stretchwickster

    Backing up stored routines

    MySQL version: 5.0.67-community-log I've recently added a significant number of stored routines (i.e. stored procedure and stored functions) to my database. I checked the output of my automatic backup PHP script (which executes a call to mysqldump) today and discovered that the stored routines...

Part and Inventory Search

Back
Top