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 Rhinorhino 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. BadRabbit

    SQL Server 2000 Enterprise Man - Reg new server?

    Thanks! I didn't know that. I will change my username and password to be the same on both databases. It's a pity my hosters couldn't be bothered to suggest this!
  2. BadRabbit

    SQL Server 2000 Enterprise Man - Reg new server?

    Hi, I have a SQL Server 2000 database with my hosters, and I've set up a SQL server registration in Enterprise manager under a group. When I access this registration, I can log into my database remotely cos the profile on Enterprise Manager holds my username and password. So far so good. But...
  3. BadRabbit

    Equivalent of Oracle Decode in Order by clause

    Thanks, that looks like it'll do the trick.
  4. BadRabbit

    Equivalent of Oracle Decode in Order by clause

    Hi, I'm bring back some username records and I want to order them alphabetically but I always want the record containing the word "General" to come last. In Oracle it's easy: SELECT...FROM...WHERE... ORDER BY DECODE(my_field,"General","ZZZZZ",my_field) Does...
  5. BadRabbit

    Unwanted blank tables creating evil gaps

    Useful function thanks, I've saved it away, but it's more the HTML columns that are causing problems, in the way DW inserts blank tables as padding whenever a change is made. I've got around this by removing them manually so far, but it's a real pain when they keep re-appearing.
  6. BadRabbit

    Unwanted blank tables creating evil gaps

    Yes, the columns are fixed width as they contain non-stretchable border graphics and must be a particular size.
  7. BadRabbit

    Unwanted blank tables creating evil gaps

    I'm using DW to create a page comprised of * A header table, right across the page * 3 columns of content below this * A footer, right across the page The columns are not the same length - i.e. don't contain the same amount of text, so under one or two of them there will be white space. Which...
  8. BadRabbit

    Downloading from SQL Server to Excel on Client Machine

    Thanks jerasi, that doesn't sound too difficult, even for a novice like myself. I'll keep your offer in mind because the customer's time-scale will also have a bearing on what is outsourced. Cheers.
  9. BadRabbit

    Downloading from SQL Server to Excel on Client Machine

    A customer has requested that he wants the facility on his website to download report outputs into Excel format on his local machine (as well as viewing reports on screen of course). I have no real idea how to do this, or even if it can be done. I'm using SQL Server 2000 via an ASP.NET...
  10. BadRabbit

    Using paramters does not work with single quotes

    Problem solved. No idea how. I've had to make all my form fields into text areas. Baffling.
  11. BadRabbit

    Using paramters does not work with single quotes

    It's doing the same when it retrieves data, just displaying the stuff before the single quote. The code is very simple, below, so maybe it's a SQL Server problem not an ASP.NET one. Yes, I should have stayed with Access and ASP - much more productive. dim dr as SqlDataReader sc...
  12. BadRabbit

    Using paramters does not work with single quotes

    I'm trying to update a field from a form using parameters but it will not accept single quotes. It just cuts off the text, so "Bill's Record" would just be updated as "Bill". The solution on all the web pages I've seen, i.e. replacing the single quotes with two single quotes...
  13. BadRabbit

    HTML forms unavailable in .NET?

    Hi Mark, Thanks for the reply. The immediate problem I got when I tried this was that when I included the name attribute in the main form tag (e.g. name="myForm") the served HTML had changed the name="_ct10" or something, so none of my check scripts worked. Of course, I...
  14. BadRabbit

    HTML forms unavailable in .NET?

    Well, I've got around it just by including "onsubmit="return false" in the main form, thus disabling RETURN. It seems strange that a new language invalidates the very environment and useful features it's trying to integrate with.
  15. BadRabbit

    HTML forms unavailable in .NET?

    I'm new to ASP.NET and I am so hating it. :| Is it true that you can't use HTML forms any more in an ASP.NET page? All I want is a simple search box that resubmits to the page by way of a button (which calls some javascript). First off, I tried to include an HTML form but nested forms aren't...
  16. BadRabbit

    SQL Server with ASP.NET / Cassini WS

    Yes, it would be Developer Edition as I would only require it for development, and implementation would be via a 3rd party hoster. Thanks for the replies, and if anyone else has any input I'd be glad to hear it.
  17. BadRabbit

    SQL Server with ASP.NET / Cassini WS

    Hi, A bit of advice, if possible... Not having IIS (I have XP Home which I don't want to upgrade to PRO) I was considering creating a dev environment consisting of SQL*Server and ASP.NET through Cassini web server (ASP.NET only). I wondered if anyone had any views on this, along the lines of...
  18. BadRabbit

    Report Footer at the bottom of the page????

    Thanks for the reply - I'll give it a go. Cheers, Simon
  19. BadRabbit

    Report Footer at the bottom of the page????

    Hi, I've search high and low for the answer to this, but... All I want is the final report footer to print at the bottom of the final page. The unchangeable (?) default seems to be just to print wherever the report ends? Is there a way of doing this? I hope so, I give a demo of the...
  20. BadRabbit

    Invisible Text! What can you do?

    Hi Darrylle, Well, out of sheer frustration I deleted the entire form and re-created it. I used the same VB (cut & pasted) and now it works. I can't explain it at all! I wasn't imagining it - the text was there, and when you selected it you could see the black selection box, but no text...

Part and Inventory Search

Back
Top