I must not be putting this SQL query into OG correctly

Discussion in 'Optigold ISP' started by t0ksik, Jan 16, 2006.

0
  1. #1
    This is my SQL query when a new customer is setup. It works when I throw it into the MS Query Analyzer. But not when I put it into OG, do I need to throw a pipe in somewhere?

    If EXISTS (select * from SUBSCRIBERS where username = '<Login>')
    print 'ERR:'
    ELSE
    INSERT INTO SUBSCRIBERS ("username", "password", "replyattr") VALUES ('<Login>', '<Pass>', '<MService1>')
     
    t0ksik, Jan 16, 2006 IP
  2. t0ksik

    t0ksik Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    forgot to say that the email response I get is:

    The results were:

    OK: Connected
    ERR: No ResultSet was produced
     
    t0ksik, Jan 16, 2006 IP