You searched for the word(s): userid:652214

More Search Options

RSS Available

• Re: calling TextBox.Text value into mailto: subject

  Geeezzz - <%# Eval("C_Email", "mailto: {0}&subject=" + TextBox1.Text ) %>' I am Object Oriented Idiot.

  Posted to Web Forms (Forum) by zoltac007 on 11/25/2009

• Re: calling TextBox.Text value into mailto: subject

  You can call the TextBox.Text directly as a parameter of the Eval , it works. <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%# Eval("CDE_Email", "mailto: {0}&subject=" + TextBox1.Text) %>' Text='<%# Eval("CDE_Email") %>'></asp:HyperLink>

  Posted to Web Forms (Forum) by zoltac007 on 11/25/2009

• calling TextBox.Text value into mailto: subject

  How do I call the value of a TextBox.Text into the subject parameter of mailto: <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%# Eval("C_Email", "mailto: {0}&subject=ABC " ) %>' Text='<%# Eval("C_Email") %>'></asp:HyperLink> I need the - subject=ABC..... - to be - subject=[TextBox5.Text] In C# code behind PageLoad I have MailSubject - TextBox1.Text; Do not know syntax to evaluate it in to the

  Posted to Web Forms (Forum) by zoltac007 on 11/24/2009

• DateAdd syntax problem

  This where clause works in an Access 2007 query - but does not work when used in a GridView DataSource SELECT statement. Points to "d" - what is the day parameter syntax? WHERE (GetDate() > DateAdd("d", 1, Companies.C_Fax_Sent ) ) AND ( Companies.C_FaxPhone IS NOT NULL ) AND ( Companies.C_KeepFlag <> 9 ) ; Thank you

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by zoltac007 on 11/14/2009

• Re: DateAdd syntax problem

  Found it: "d" needed to be day WHERE ( (GetDate()) > (dateadd(day,1,Companies.C_Fax_Sent )) )

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by zoltac007 on 11/14/2009

• Can a table be dynamically named in a SELECT query?

  Is is possible to dynamically name a table in a simple stored procedure? I am trying to create tables that will show me all sales over 1000 dollars in the districtNo entered. SELECT name, state, zip, sales, districtNo INTO "tblClients + @districtNo" WHERE sales > 1000 and districtNo = @districtNo SORRY I MISSTATED the problem - I want the SP to create a new table with its name being the concantenation of the main table tblClients + the @districtNo entered. For example when I enter the

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by zoltac007 on 11/7/2009

• Re: Can a table be dynamically named in a SELECT query?

  I misstated the question and revised the post. I meant to ask how to dynamically name an INTO table using an input parameter. Thank you

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by zoltac007 on 11/7/2009

• SQL - INTO statement, concantenate table name?

  Does the SQL language INTO allow for concantenation in constructing a table name using a parameter? @tablesuffix ...... INTO tblClients + @tablesuffix such that if @tablesuffix = 123 the INTO table name would be tblClients123 Thank you

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by zoltac007 on 11/7/2009

• Getting AVERAGE field value in query

  How would I write a query that would select a group of records and give me the average value of one of the fields? SELECT ID, Name, Amount FROM tblCustomers WHERE Amount > 10 Assuming the query found 100 qualifying records what would the statements look like that would give me the average value of the 'Amount' field? Thank you

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by zoltac007 on 11/6/2009

• Re: Getting AVERAGE field value in query

  Found the AVG function - SELECT AVG(Amount) FROM tblNAME

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by zoltac007 on 11/6/2009