Messages

Hi,

          Thank you, now my Konakart application working well. I install my db successfully.......

Thanks & Regards,
    Geetha..............

hi,

      I find the query in database/MYSQL/konakart-demo.sql.
     "{ Create a KK_IF function which for MySQL is a wrapper around the IF function (but we can't use IF on all databases)
DROP FUNCTION IF EXISTS KK_IF;
#CREATE FUNCTION KK_IF (test int, a decimal(15,4), b decimal(15,4)) RETURNS decimal(15,4) deterministic return IF(test, a, b)"  }"

now, what have to do? by deleting this or i have to change something in this query...

thanks and regards,
geetha

hi,

      I find the query in database/MYSQL/konakart-demo.sql.
     "{ Create a KK_IF function which for MySQL is a wrapper around the IF function (but we can't use IF on all databases)
DROP FUNCTION IF EXISTS KK_IF;
#CREATE FUNCTION KK_IF (test int, a decimal(15,4), b decimal(15,4)) RETURNS decimal(15,4) deterministic return IF(test, a, b)"  }"

now, what have to do? by deleting this or i have to change something in this query...

thanks and regards,
geetha

Hi,
        I am using MySQL Server 4.1 for database.........

HI,

I have a problem in installation, i am using mysql database connection is successful. after that i have an error "SQL execution failed."

          " Message:   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS KK_IF' at line 1
SQLState:  42000
ErrorCode: 1064"

pls help me to resolve this error............