I dont want to include the Ids if they are null.

Is there a way to do this:

@FirstId uniqueidentifier = NULL;
@SecondId uniqueidentifier = NULL;

SELECT ..
FROM ..
WHERE
IF(@FirstId IS NOT NULL)
BEGIN
FirstId = @FirstId
END
IF(@SecondId IS NOT NULL)
BEGIN
AND FirstId = @FirstId
END

Or a smarter way? :D Thanks in advance!

public partial class Administration_Controls_FileControl : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
Control control = this.Page.FindControl("MessageControl");

Gives back null

Control control = this.Page.FindControl("ctl00");

That gives my masterpage :) Not really nice id

Hi! Is there a way to access a control in my MasterPage from my custom user control. I have MasterPage with custom control --> Default.aspx --> User Control And my last User Control needs to access the custom control in my master. Or do i have to work with delegate in my default.aspx Thanks! Wouter

Thanks man! Works great!

Ok thanks , i posted my usercontrolid in the trigger, now it works :) Thanks!

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="FileControl.ascx.cs" Inherits="Administration_Controls_FileControl" %>
<div style="width: 100%; height: 50px;">
<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:Button ID="test" runat="server" OnClick="test_click" />
</div>

protected void test_click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{

}

}

I have this code, but i keep getting HasFile = false .. Anyone sees what im doing wrong.. I really dont see it. Thanks. Wouter

Yes i will consider that :) Havent thought about it that way.

ID Name Access1 Access2 Access3 Access4 Access5
918a6fb8-573f-4744-b4de-019bc8322ce4 Gast False False False False True
013b4a2b-3027-41b6-a7e1-e0e536dd0bbc Administrator True True True True False

I have multiple results for 1 user. In the example I want the results to get to one row, with the final result (True, True, True, True, True). So the query has to go through all the results and check if the Access Right is True or False. Is one of them is True the result of the column is true. I tried to use Temp Tables but im stuck :( Anyone has an idea? I use MSSQL