Incorrtect SELECT statement

Results 1 to 2 of 2

Thread: Incorrtect SELECT statement

  1. #1
    Join Date
    Dec 1969

    Default Incorrtect SELECT statement

    I am trying to select a story with will be set by times in the row is a start time with a ore-defined time. <BR><BR>Instead i get a EOF or BOF message <BR><BR>STORYSQL = "Select Heading, Article, Picture From HeadStories Where Starttime &#062;=&#039;" & time & "&#039;"

  2. #2
    Join Date
    Dec 1969

    Default After executing the sql query

    do this:<BR>If not Rsobj.eof then &#039;this means record exists for this query<BR>&#039;do something<BR>else &#039; no record exists<BR>&#039; do something else<BR>end if

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts