SQL now ok i think

Results 1 to 4 of 4

Thread: SQL now ok i think

  1. #1
    Tony (Acuum) PLEASE HELP Guest

    Default SQL now ok i think

    Sorry had a play and found that the SQL seems to be working.<BR>it is running ok but when i try to refere to the results it is causing the error not the SQL its self<BR><BR><BR><BR><BR><BR><BR>e.g.<BR>SQL_FIND_M ONTH = "SELECT TIMES FROM RESULTS WHERE SKINUM = " & FILL_FORM(0) & " AND MONTH = " & MONTH_TO_DO_NUM & ""<BR> SET FIND_MONTH = CONN.EXECUTE(SQL_FIND_MONTH)<BR> IF FIND_MONTH(0)= null THEN RESPONSE.WRITE(FILL_FORM(0))<BR><BR><BR><BR><BR>wh at i want to happen is that it shows me that this month has had now time put in for this SKINUM then i can allow the user to input a value for them<BR><BR>i hope that makes sence.<BR><BR>but i get this error with the IF statment<BR>error &#039;80020009&#039; <BR>Exception occurred. <BR><BR>/upload_02.asp, line 60 <BR><BR><BR><BR><BR>Please can somone help me!!!<BR><BR>:)<BR>Tony (Acuum)

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL now ok i think

    do you have an "endif"? i don&#039;t see it.

  3. #3
    kannys ( the guru) Guest

    Default put END IF at the end

    put END IF at the end

  4. #4
    Join Date
    Dec 1969

    Default no!! you don't need endif !!!!


Posting Permissions

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