Re: [PHP-DB] parse error in create statement.

lt;[EMAIL PROTECTED]> Reply-To: Chris Ramsay <[EMAIL PROTECTED]> To: babu <[EMAIL PROTECTED]> 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/

Re: [PHP-DB] parse error in create statement.

"$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."; for the .'s

Re: [PHP-DB] parse error in create statement.

Also, correct me if I'm wrong, but this needs to be split into two seperate query strings and executed seperately... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] parse error in create statement.

Check your placement of all the '.' for a start. raz On 6/14/05, babu <[EMAIL PROTECTED]> wrote: > HI, > > Whats the error in this code. > > "$sqlstmt= "CREATE USER ".$adduser." PROFILE DEFAULT > IDENTIFIED BY ".$addpass." DEFAULT TABLESPACE USERS > TEMPORARY TA

[PHP-DB] parse error in create statement.

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;