TbsSQL v3.0.0 final

[TomH]

Skrol29,

Thanks for the formal release of tbssql 3.0 ! All looks good - I see
no differences compared to the most recent beta.

Reminders...
* the version number is not up to date yet
* the $Db->TempCacheTimeout, as seen via get_object_vars($Db), does
not yet show the value

Possible convenience improvement... as seen in get_object_vars($Db)
the "$Db->Mode : 28" displays the binary value
It would be nice to see
$Db->Mode : TBSSQL_TRACE + TBSSQL_GRID + TBSSQL_CONSOLE

That's all I see for now.

And last, a thank you for adding the debug console as native to the
class. As you know I wrote a debug feature for ezSQL and JustinV
added my code to his class, but it was very cumbersome to use because
the javascript needed to be added to each template page.

You console solution is Soooooo much more elegant and user-friendly
and now the caching makes TbsSQL a standout winner!

Thanks for TBS every day,
TomH

[TomH]

Okay, I found the source of my confusion about the $Db-
>TempCacheTimeout property, the class resets the property to false
after setting the temporary timeout - so unless I do the
get_object_vars($Db) after setting TempCacheTimeout but before the
program code executes the db query, I'll never see the setting.
Duh!

Sorry to have been bothering you about that

Thanks for TBS every day,
TomH

On Aug 23, 10:11 am, TomH <t...@tomhenry.us> wrote:
> Skrol29,

[Skrol29]

Hi TomH,

The bug about the version is fixed now.

I agree about the improvement for displaying the current Mode. I thought to
add this in a further version.

And thanks for your appreciation about the console feature :-)

I've observed that ezSQL has not been updated since June 2009, but the Code
Igniter support has been added on December 2009.

Bien cordialement,
Regards,
Skrol29

-----Message d'origine-----
De : tbs-...@googlegroups.com [mailto:tbs-...@googlegroups.com] De la part
de TomH
Envoyé : lundi 23 août 2010 16:12
À : TinyButStrong Next Version
Objet : [tbs-next] TbsSQL v3.0.0 final

Skrol29,

--
You received this message because you are subscribed to "TinyButStrong next
version".
Post to this group: send email to tbs-...@googlegroups.com
Subscribe: send email to tbs-next+...@googlegroups.com
Unsubscribe: send email to tbs-next+u...@googlegroups.com
More options: http://groups.google.com/group/tbs-next

[TomH]

Hello Skrol29,

A small issue seems to show when
$Db->Mode = TBSSQL_TRACE + TBSSQL_GRID + TBSSQL_CONSOLE ;

For...
$sql = "SELECT *, CONCAT_WS(' ',fname,lname) AS name FROM mycontacts
ORDER BY lname";

If I use the standard syntax all of the query GRID information is
displayed as expected
> $result = $Db->GetRows($sql);
> $TBS->MergeBlock('blk', $result);

If I use the alternate syntax then the GRID information for that query
is NOT displayed
> $TBS->MergeBlock('blk', $Db->TbsKey, $sql); // alternative syntax
> $TBS->MergeBlock,('blk', 'tbssql', $sql); // alternative syntax

Maybe is not a bug, if so I would appreciate understanding what is
happening differently.

[Skrol29]

Hi TomH,

You're right, the Grid and the Console are not displayed for a
MergeBlock() linked to TbsSQL.
It was not implemented because I first thought it could be confusing to
have a popup when you are working with templates, and also because you
can use the template itself you make your debug grid.

It could be easily added for a further version. Dou you think it could
be useful?

---------------------
Skrol29
www.tinybutstrong.com
---------------------

Le 05/09/2010 01:17, TomH a �crit :

[TomH]

Skrol29, thanks for the reply.

It just seemed to me inconsistent.. if the coder explicitly sets the Mode then
they are expecting to see the CONSOLE (with GRID if specified), and it seems
they currently are then limited to only one syntax for calling tbssql in order
to get the debug/trace/console.

The main point of having the GRID as part of the CONSOLE is to eliminate all of
the particularized coding needed in every template during debugging TBS
applications, just by switching the TbsSQL Mode "on/off"!

The way I use PHP/TBS is by having my own uniform, generalized framework for
applications. As I learn more TBS I upgrade the whole framework. This also
includes setting up auto_prepend files for initial conditions, classes, and
special functions -- and also having a set of default TBS/PHP and TBS/Template
files with my favorite structures already coded in my editer program. This save
lots of coding and more important, for inexperienced coder like me, it greatly
reduces errors and omissions.

Thanks for TBS, and now TbsSQL, every day,
TomH

Skrol29 wrote:
> Hi TomH,
>
> You're right, the Grid and the Console are not displayed for a
> MergeBlock() linked to TbsSQL.
> It was not implemented because I first thought it could be confusing to
> have a popup when you are working with templates, and also because you
> can use the template itself you make your debug grid.
>
> It could be easily added for a further version. Dou you think it could
> be useful?
>
> ---------------------

he