Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Needs Help With Adding an If Statement
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Needs Help With Adding an If Statement

 Post Reply Post Reply
Author
Misty View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 February 2002
Location: United States
Status: Offline
Points: 711
Post Options Post Options   Thanks (0) Thanks(0)   Quote Misty Quote  Post ReplyReply Direct Link To This Post Topic: Needs Help With Adding an If Statement
    Posted: 07 October 2005 at 1:52am

Please look at the code below. Please look at the bolded line of code. I'd like to add some code to let an event show up if the EventStartDate has a value and the EventEndDate doesn't have a value. For example, there may be some one day events. I am not sure how to do this. Could someone please help me with this? I got the following error message when there was just an one day event with the EventEndDate field null.


strSQL = " SELECT * FROM EVENTS WHERE (EventStartDate >= '" & datCalendarStart.ToString()  & "' " & _ 
" AND EventStartDate <= '" & datCalendarEnd.ToString()  & "') OR (EventEndDate >= '" & datCalendarStart.ToString()  & "' " & _
" AND EventEndDate <= '" & datCalendarEnd.ToString()  & "') OR (EventStartDate <= '" & datCalendarStart.ToString()  & "' " & _
" AND EventEndDate >= '" & datCalendarEnd.ToString()  & "') ORDER BY EventStartDate "

        myCommand = New SqlCommand( strSql, Conn)
       
        Conn.Open()
 
        myReader = myCommand.ExecuteReader()

        lblDates.Text = " <P> Events for the month of " & calCalendar.SelectedDate.ToString("MMMM yyyy") & "<br> <br>"

        ' Always call Read before accessing data.
        While myReader.Read()
            
           lblDates.Text &= myReader.GetDateTime(2).ToString("MM/dd/yy") & " - " & myReader.GetDateTime(3).ToString("MM/dd/yy") & "<br>"           

lblDates.Text &= "<a href=""DisplayEvent.aspx?EventID=" & myReader.GetInt32(0).ToString() & """ >" & myReader.GetString(1).ToString() & "</a> <br>"
lblDates.Text &= myReader.GetString(5).ToString() & " <p> "
        End While


Edited by Misty - 07 October 2005 at 1:53am
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 07 October 2005 at 10:18am

Without looking into your problem specifically, I have a Timesheet app I developed and all events that are startdate=enddate I set both fields with the same date, that would eliminate and NULL problems, you can set a rule on SQL Server that if the enddate IS NULL THEN endate=startdate

Back to Top
Misty View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 February 2002
Location: United States
Status: Offline
Points: 711
Post Options Post Options   Thanks (0) Thanks(0)   Quote Misty Quote  Post ReplyReply Direct Link To This Post Posted: 07 October 2005 at 10:28pm
I actually want it to show a date like 10/07/2005 if it's just an one day event. I've figured out how to do it.
 
Here's the code:
 
        ' Always call Read before accessing data.
        While myReader.Read()
        If myReader("EventStartDate").ToString.Length <> 0 AndAlso myReader("EventEndDate").ToString.Length = 0 Then
        lblDates.Text &= myReader.GetDateTime(2).ToString("MM/dd/yy") & "<br>"
        Else         
            lblDates.Text &= myReader.GetDateTime(2).ToString("MM/dd/yy") & " - " & myReader.GetDateTime(3).ToString("MM/dd/yy") & "<br>"
        End If 
            lblDates.Text &= "<a href=""DisplayEvent.aspx?EventID=" & myReader.GetInt32(0).ToString() & """ >" & myReader.GetString(1).ToString() & "</a> <br>"
            lblDates.Text &= myReader.GetString(5).ToString() & " <p> "
        End While
 
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.