Search results for query: *

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!

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

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

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

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.

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

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

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.

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

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

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

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

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

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.

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

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.

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

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

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

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