Recent content by JulianUK

Thanks for your comments, but that simply is not what I want to do. My scenario - I hold Javascript snippits in a database field. I create them in Notepad, and cut n paste them straight into my table. I do it 1 at a time, and maybe a few times a month. Other times, I mod those entries already...

[repost from "svr admin" forum last week - no joy there...] I have just "upgraded" from SQL Server Enterprise Mgr 2000 to 2005. (I like to be an early adopter...). This was done for no real reason and I wish i'd not bothered. Anyway, I have some text fields in which I hold some lines of code...

As jbenson001 said, something in your WHERE clause must be excluding one row from your result set. That said, the above query would not work if we consider the table to be as you said. 2 columns, none of which match anything in your where clause! Another possibility is that you have in fact...

The first case will give you a count of the number of unique mbr_ssn_nbr values within your result set, which is I presume what you are after. In the second case, your use of distinct is irrelevant, as the COUNT statement will return only 1 row, so you are effectively asking for a distinct set...

I have just "upgraded" from SQL Server Enterprise Mgr 2000 to 2005. (I like to be an early adopter...). This was done for no real reason and I wish i'd not bothered. Anyway, I have some text fields in which I hold some lines of code. In EM2000, opening the table directly allowed me to insert...

Hmm, thanks, but it took me a while to realise that the example in the link does not work in Firefox!

Yes, thanks I just found the same answer in another thread ( http://www.tek-tips.com/viewthread.cfm?qid=772563 ). Did that and it works a treat - many thanks. I promise i DID do a forum search before posting my q, why didn't I see that post before?! Law of Sod. Cheers Julian

Hi I have a simple html login page with a Flash built "tour" of the site on one page. on some of the Flash frames, there are URL links that fire a Javascript function on the originating HTML page, to show (using visibility) a <div> section (which shows an enlarged version of the graphic the...

Hi vongrunt That's fair enough I suppose. We just want to grab those new features and to hell with the consequences! But perhaps they are right. What is likely to be the timescale for the first SP?

Hi I am trying to persuade the powers that be to upgrade our SS 2000 to 2005 for a major project. One view that is holding things up is that it is generally "unstable", or at least unproven. Is this baseless nonsense or not? Julian

Thanks Chris (belatedly!) It suddenly dawned on me that I could simply submit a form to another www, something I'd been presuming I couldn't do (for some unbeknown reason). A real "dur!" moment. Julian

ok, sorry, just reread your post. yes it can be done in IIS too... In the web site properties dialog, on the "Home directory" tag, choose "configuration". On the 2nd tab, "App Options" you'll find the session timeout property.

Hi I'm not sure this is the correct place for this question but here goes anyway... I have 2 non-secure web sites that require a single "portal" at which point the user enters username and password. depending on a locally (to the portal) stored parameter for each user, the user is redirected...

You need the timeout property. e.g. <% Session.Timeout = 40 %> This would set the time out of the session to 40 minutes. By default it is 20.

oh boy is nothing ever simple?! Thanks.