Re: parse error in create statement.

From:	Bastien Koert	Date:	Tue, 14 Jun 2005 11:21:35 +0000
Subject:	Re: parse error in create statement.
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-39666@lists.php.net to get a copy of this message

Missing a . in the line before the last quote GRANT CREATE TRIGGER TO ".$adduser" "$sqlstmt= "CREATE USER ".$adduser." PROFILE DEFAULT

                IDENTIFIED BY ".$addpass." DEFAULT TABLESPACE USERS
                TEMPORARY TABLESPACE TEMP
                QUOTA UNLIMITED
                ON USERS
                ACCOUNT UNLOCK;
                GRANT CREATE TABLE TO ".$adduser."
                GRANT CREATE TRIGGER TO ".$adduser."
                GRANT CONNECT TO ".$adduser;".

bastien

From: Chris Ramsay <raz.net@gmail.com> Reply-To: Chris Ramsay <raz.net@gmail.com> To: babu <garavindbabu@yahoo.co.uk> CC: php-db@lists.php.net Subject: Re: [PHP-DB] parse error in create statement. Date: Tue, 14 Jun 2005 10:56:24 +0100 Check your placement of all the '.' for a start. raz On 6/14/05, babu <garavindbabu@yahoo.co.uk> wrote: HI, Whats the error in this code. "$sqlstmt= "CREATE USER ".$adduser." PROFILE DEFAULT
                IDENTIFIED BY ".$addpass." DEFAULT TABLESPACE USERS
                TEMPORARY TABLESPACE TEMP
                QUOTA UNLIMITED
                ON USERS
                ACCOUNT UNLOCK;
                GRANT CREATE TABLE TO ".$adduser."
                GRANT CREATE TRIGGER TO ".$adduser"
                GRANT CONNECT TO ".$adduser;".
any suggestions. --------------------------------- Yahoo! Messenger NEW - crystal clear PC to PCcalling worldwide with voicemail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php