Recent content by MadProfessor

Hi everyone, We have various sites running on a server. Occasionnally, when we restart IIS one of the sites (and only one - the rest are fine) just displays this message: HTTP 1.1 New Application Failed The only way to get rid of it is to restart the server. Can anyone advise me why it has...

point taken, but it doesn't answer my original question: which way are they read - left to right or right to left? On the Where clause, I want to put the join conditions then most restrictive conditions first, to optimise performance, so want to know which way it is read so that I can place...

Hi, Simple question: when you have multiple conditions in the Where clause, does Access 2000 read them from left to right or from right to left? I am trying to optimize the SQL statements hence wanting to know this.

Hi Terry, I need the random number as I have a list of Unique ID numbers that are in sequence. These are to be attached to a querystring in a link in an email that is to be mailed out. The link in the email then links back to a site, where the UID pulls out the customer details. The random...

Hi, I have an empty column in a database, and I want to update it with a DIFFERENT random number for each record. When I use: update table set column = round(rand()*1000 + 1, 0); it sets the same random number for all the records, which is no good to me. How do I get it to set a different...

cheers Vic, that's sorted it for me.

Hi, I'm trying to submit a form that's in a layer by calling a function from a button in another layer (I've used div tags to define the layers). The function is very simple: function subForm() { document.regform.submit(); } (by the way, regform is the name of the form). Internet Explorer...

I had a quick look but am actually on holiday at present so haven't investigated fully (I posted the message just before going away). I'm back at work on the 9th July and it's a priority to get done then so I will let you know.

Is it possible to link to a particular frame in a flash movie from a hyperlink on an html page? For example, I have a movie that has 500 frames long, and normally plays from frame 1 to 500, then stops. But, say I want to have another link that starts playing at frame 100 in the movie - how do...

Does anyone know how search engines index flash sites, if at all? I have a flash driven site which uses text files as a convenient way to update the flash content. Will the text files be indexed or am I stuck with using meta-tags etc in the html that holds the flash?

In the end I have reinstalled IIS for a third time and then updated windows 2000 & IE5 with the latest service packs. This fixed it. Still not really sure what the actual problem was but fingers crossed it doesn't happen again. Thanks to everyone for their help.

I've sorted this all out. I was just being stupid (probably due to hangover). Thanks for everyone for their help.

The above worked fine (seleting the first name/last name from the single). But my severe lack of SQL knowledge is causing me headaches again. My problem now is updating the 2 new columns with the multiple values. I want to put all divided names into 2 new columns (first and last name). How...

Thanks very much for this - I'll try it out tomorrow (It's late here where I am) and will let you know.

Ok first off, sorry if this sounds simple but I am not a SQL genius by any stretch of the imagination. Here's my problem: I have a SQL database mailing list which all the peoples' full names are in one column. I need to split this into 2 fields: first_name and last_name. I think I need a SQL...