Search results for query: *

Thanks for all of your great advice Jason.

Actually, you can have asp (vbscript) snippets in an .htm file. But that's OK, I figured it out. In the member name column in the Dimension Editor: CONVERT(CHAR(10),"dbo"."date_dim"."the_date",103) Thanks everyone for your GREAT help!

I figured it out. In the member name column in the Dimension Editor: CONVERT(CHAR(10),"dbo"."date_dim"."the_date",103) Thanks everyone for your help!

Hello, I am currently returning the date from an Cube Dimension into an OWC Pivot Table as such: 2008-01-30 00:00:00 I have been researching how to apply a short date format (mm/dd/yyyy) on the web page as such: RowAxis.InsertFieldSet(FieldSets("Request Open Date")).NumberFormat = "Short...

Thanks, but this doesn't help me. I'm trying to do this on an .htm page used by the OWC component.

Hello, I am currently returning the date from an Cube Dimension into an OWC Pivot Table as such: 2008-01-30 00:00:00 I have been researching how to apply a short date format (mm/dd/yyyy) on the web page as such: RowAxis.InsertFieldSet(FieldSets("Request Open Date")).NumberFormat = "Short...

Hello, I've looked in Outlook at the rules and for other ways to do this, so I was hoping someone here might be able to help. Is there a way I can send an e-mail notification is an hourly e-mail is late or doesn't arrive as expected? For instance, if the email from a certain sender is over 60...

Hi Skip, Any chance I could get a brief example, or a good resource? I did some searching but was unable to find very much information. Sorry, newbie Word automatino programmer here. Thanks, Dennis

Hello, I've been looking at different approaches for creating a dependent drop-down list (or text box), but have been unable to come up with a solution that works. In some cases there will be only one value for a value chosen in a drop-down, in other cases there may be more than one. In the...

Hello, I have been looking for an application that would enable me to set-up an hourly job to run. This job would populate and submit (or submit a pre-populated form) that would run (submit) once an hour. The client is worried the form might not be running so they want some kind of confirmation...

Thanks George! I'll check it out. Dennis

George: "you will need to write 2 update statements. , and wrap the 2 update statements in to a transaction" Could you please show me an example of how I would do this? Thanks, Dennis

Hello, But I cannot write two statements in this case because the key field(email) only resides in the customers table, and the query I sent involves a join between orders and customers tables. Here are the queries again and the required resultset: I have this query which is pulling from a...

Hello all, Uh, I see where from your example I can update one table, but in this case I need to update two tables which are involved with the join for this query. Could someone please show me how I could update BOTH table in one update statement? Would this involve some use of a cascading...

Thank you all VERY much for your valuable input. I will take your advice all the way around and hope I can contribute to this great message board in return. I will try the query and let you know. Dennis

Hello, I have this query which is pulling from a production table: select o.OrderNumber as [Order Number], o.CustomerID as [Customer ID], o.LastName + ' ' + o.FirstName as [Customer Name], c.Email, c.AdditionalEmail as [Additional Email], c.Phone, o.ShippingCity as [Shipping...

Here is the code: mailer.cs: using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Net.Mail; using...

Hello, When trying to send mail through my application I am getting this error: A first chance exception of type 'System.Net.Mail.SmtpException' occurred in System.dll System.Net.Mail.SmtpException: Failure sending mail. I am using ASP.NET 2.0 and the project is in Visual Studio 2005...

Hello, I've been researching this for some time. Does anyone know if you can conditionally jump to a report? Something like this: =iif(Fields!TEST.Value = "?????" And Fields!TEST2.Value > 0, TestDetailReport, "") I've tried this based on the text color also but keep getting errors like this...

Hello, I've been researching this for some time. Does anyone know if you can conditionally jump to a report? Something like this: =iif(Fields!TEST.Value = "?????" And Fields!TEST2.Value > 0, TestDetailReport, "") I've tried this based on the text color also but keep getting errors like this...