Ouch! Don't do that. If you manage to get it to work, you will be keeping the uploaded file in memory between requests. If the second request never comes, it will stay in memory until the session times out, normally after 20 minutes. The application would be totally open for a DoS attack. You just have to upload a lot of files, and it will use up all the memory of the server. Why don't you save the file when you recieve it? --- b { font-weight: normal; }

Yeah, thats it

The .exe is in your projects 'bin\Debug' folder. Wacky waving inflateable arm flailing tube man! - Family Guy

That's okay. The naming convention extends to servers. Just add in the server name like this: ServerName.DatabaseName.SchemaName.TableName SchemaName is dbo, unless you've set it up otherwise. You will also have to link the two servers together. You might find this useful: MSDN: Configuring Linked Servers[^] ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

Implement your own style of password If you look into the source of the page its setting it as a password that html takes over. You might be able to disable it. But other users might not. so override the thext box public class MyTextBox : TextBox and implement the Render function Nick 1 line of code equals many bugs. So don't write any!!

Click this link [^] to see what I mean by a Regular Expression. It links to the MSDN page introducing the topic.

Hi there. Make sure your HtmlInputFile control has an ID and is set with runat="server": <input runat="server" id="File1" type="file" /> Then you can use C# code like this to set the class: File1.Attributes["Class"] = "MyClass"; or VB code like this: File1.Attributes("Class") = "MyClass"

ftp://ftp.microsoft.com/[^] Click Help-Index then type FTP ftp://ftp.microsoft.com:userName@password I believe. I usually user WS_FTP http://www.ipswitch.com/[^] 1 line of code equals many bugs. So don't write any!! -- modified at 9:14 Wednesday 25th January, 2006

Thats the one, thank you

Try this (with a MIN and GROUP BY added): select a.codeid, MIN(b.codeidalias) as MinCodeIdalias from tblcodes a left outer join tblcodeslookup b on a.codeid = b.codeid where a.codeid not in (select codeidalias from tblcodeslookup) group by a.codeid