Jim Lucas wrote:
Peter wrote:
I am trying to convert ms access sql to postgresql using php.
I have a sql statement in the form ;-
$sql = SELECT DISTINCT [Table Name].[Column.Name], [Table Name
1].[Column Name 2] etc.
what I want to end up with is $sql = SELECT DISTINCT
table_name.column_name, table_name_1.column_name_2, ........
I have managed to get the caps to lower but I cant work out how to put
the _ in place of spaces if the spaces are between [ ]. I either
end up with S_E_L_E_C ..... or SELECT_DISTINCT_ etc... .
Something along the lines of this?
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
$sql = "SELECT DISTINCT [Table Name].[Column Name], ".
"[Table Name 1].[Column Name 2]";
echo "{$sql}<br />\n";
preg_match_all('%\[([^\]]+)\]%', $sql, $matches, PREG_SET_ORDER);
$change = array();
foreach ( $matches AS $match ) {
$change[$match[0]] = str_replace(' ', '_', $match[1]);
}
echo '<pre>'.print_r($change,1).'</pre>';
echo str_replace(array_keys($change), $change, $sql);
Thanks Keith and Jim once I wake up I'll give both methods a try and let
you know how I go. (Just having my morning coffee atm) I know I wont
find the perfect converter as ms access lets you use to many 'bad'
characters in column names. aah well only need to change about 600 queries.
Peter
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
