Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dldev
  • Order by date
  1. dldev

    Date Format for OWC/Pivot Table

    Thanks for all of your great advice Jason.
  2. dldev

    Date Format for OWC/Pivot Table

    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!
  3. dldev

    Date Formatting for OWC/Pivot Table RowAxis field

    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!
  4. dldev

    Date Formatting for OWC/Pivot Table RowAxis field

    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...
  5. dldev

    Date Format for OWC/Pivot Table

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

    Date Format for OWC/Pivot Table

    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...
  7. dldev

    Outlook 2003: Send E-Mail Notification If Scheduled E-Mail Is Late

    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...
  8. dldev

    Dependent Drop-Down lists in Word 2003

    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
  9. dldev

    Dependent Drop-Down lists in Word 2003

    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...
  10. dldev

    Automate Fill and ASP Form Submit for Testing

    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...
  11. dldev

    Update Two Tables based on join

    Thanks George! I'll check it out. Dennis
  12. dldev

    Update Two Tables based on join

    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
  13. dldev

    Update Two Tables based on join

    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...
  14. dldev

    Update Two Tables based on join

    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...
  15. dldev

    Update Two Tables based on join

    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
  16. dldev

    Update Two Tables based on join

    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...
  17. dldev

    ASP 2.0, first chance exception, Failure sending mail

    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...
  18. dldev

    ASP 2.0, first chance exception, Failure sending mail

    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...
  19. dldev

    Conditional Jump to Report in SRS 2000 possible?

    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...
  20. dldev

    Conditional Jump to Report in SRS 2000

    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...

Part and Inventory Search

Back
Top