FUDforum: comp.lang.php » Adding MSSQL support to a MySQL/Postgres script

Home » Imported messages » comp.lang.php » Adding MSSQL support to a MySQL/Postgres script

Show: Today's Messages :: Polls :: Message Navigator

Re: Adding MSSQL support to a MySQL/Postgres script [message #170123 is a reply to message #170081]

Mon, 11 October 2010 11:06

DiamondEagle
Messages: 11
Registered: October 2010

Karma:

Junior Member

On Oct 8, 11:34 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:

> I would suggest you start with
>
> echo "<pre>\n";
> print_r($tables);
> echo "</pre>\n";
>
> And take a look at the keys in your array.

Thanks. My problem seems to be that $tables is empty. When I debug
using print_r($tables) it shows that $tables is empty.

I'm "certain" that the problem is the line in the code below where
$tablename gets defined i.e
$tablename = trim($table['table_name']);

When I run the code with some added debug lines I see a few "failed
empty check" messages so the if(!empty($tablename)) check is saying
that $tablename is empty.

case 'mssql_n':
$query = mssql_query("select * from information_schema.tables");
if (mssql_num_rows($query) > 0) {
while ($table = mssql_fetch_assoc($query)) {
$tablename = trim($table['table_name']);
if (!empty($tablename)) {
echo "passed empty check<br />";
$tables[] = $tablename;
}
else {
echo "failed empty check<br />";
}
}
}
break;

And I don't know why!

Report message to a moderator

[Message index]

		Adding MSSQL support to a MySQL/Postgres script By: DiamondEagle on Fri, 08 October 2010 10:34
		Re: Adding MSSQL support to a MySQL/Postgres script By: Jerry Stuckle on Fri, 08 October 2010 21:34
		Re: Adding MSSQL support to a MySQL/Postgres script By: DiamondEagle on Mon, 11 October 2010 11:06
		Re: Adding MSSQL support to a MySQL/Postgres script By: Jerry Stuckle on Mon, 11 October 2010 12:25
		Re: Adding MSSQL support to a MySQL/Postgres script By: DiamondEagle on Mon, 11 October 2010 21:39
		Re: Adding MSSQL support to a MySQL/Postgres script By: Jerry Stuckle on Mon, 11 October 2010 22:31
		Re: Adding MSSQL support to a MySQL/Postgres script By: DiamondEagle on Tue, 12 October 2010 12:27

Previous Topic:	Cursor to 1st fllable field?
Next Topic:	php://memory and php://temp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 12:00:59 GMT 2024

Total time taken to generate the page: 0.04547 seconds