Delphi-PHP Forums - embarcadero.public.delphiphp.database

MySQL 5.1 returnes empty data?

John Schmidt — Sun, 05 Sep 2010 12:37:01 GMT

John Schmidt wrote:
> echo ' 1. "' . $DataModule1->TablePerson->Filter . '" ';
> echo ' 2. "' . $DataModule1->TablePerson->PersID . '" ';
> echo ' 3. "' . $DataModule1->TablePerson->PersCode . '" ';
> echo ' 4. "' . $DataModule1->TablePerson->RecordCount . '" ';
>
> I get following results:
> 1. PersID=2
> 2. ''
> 3. ''
> 4. 2
>
> What may cause this?

This will happen if you haven't scrolled to the first record. Put the
following code before your code that reads from the table:

$DataModule1->TablePerson->First();

--
Jonathan Benedicto (TeamB)

newbie - connecting to database

Philip Jackson — Sat, 04 Sep 2010 20:59:11 GMT

Philip Jackson wrote:
> I have on my machine an ODBC datasource called AMMailMerge (which I use
> extensively for Mail Merge to MS Word). This points to a Visual foxpro
> table cdoc.dbf.
>
> I have created a small application and placed onto the form 4
> components...
>
> Database with properties
> DatabaseName = AMMailMerge
> DriverName = odbc
> Host = localhost
>
> when I run the application I get the following SQL/ODBC error.....
>
> Warning: odbc_connect() [function.odbc-connect]: SQL error:
> [Microsoft][ODBC
> Driver Manager] Data source name not found and no default driver
> specified,
> SQL state IM002 in SQLConnect in C:\Program Files
> (x86)\Embarcadero\RadPHP\3.0\rpcl\adodb\drivers\adodb-odbc.inc.php on line
> 60

Try setting the Host property on the database component to the DSN of the
ODBC datasource and clear the DatabaseName property.

--
Jonathan Benedicto (TeamB)

More MSSQL errors [Edit]

STEVEN OWEN — Fri, 03 Sep 2010 21:56:41 GMT

Steve Owen wrote:
> Tried the recommend fix of uncommenting:
>
> extension=php_mssql.dll
>
> from the php.ini.template file and this worked on an Win XP box, however,
> with
> RadPHP installed to a Windows 7 box after commenting the php.ini.template
> a
> new error occurs
>
> stating RadPHP cannot find file ntwdblib.dll and followed by yet another
> error
> message saying it can't find php_mssql.dll......suggestions?

Try installing the SQL Native Client on the machine:
http://msdn.microsoft.com/en-us/data/aa937733.aspx

--
Jonathan Benedicto (TeamB)

bunch of newbie questions

Jonathan Culley — Thu, 02 Sep 2010 20:10:15 GMT

Jonathan Culley wrote:
> 1) I am deploying on a LAMP environment. what is the best way to connect
> to
> the database: datamodule, add required tables to each appliction page? If
> I
> create a common.php file that has common functions how do I include that
> datasource and related properties / methods?

A common datamodule for the Database component would be a good idea, yes.

I'm not sure what you mean by "include that datasource and related
properties/methods".

> 2) There are some really simple queries that I want to run such as
> checking
> if a record ID exists in a table before I post a new record. Is there a
> built-in
> method for this or do I write out the SQL for that? Is there any
> documentation
> that is organized by results rather than just method names?

If you're using the Database component, you can use the AdoDB helper methods
to simplify your query. For example:

{code}
$count = $this->Database1->_connection->GetOne( "SELECT COUNT(*) WHERE ID =
?", array( 123 ) );
{code}

> 3) I want to create a drop-down select field that is populated by a
> database
> (for instance a country field that is populated by available countries in
> the
> database). How do I do this?

Because the ComboBox control does not support retrieving items for a
database, there are 2 ways to do this: 1. Manually populate the ComboBox
control, or 2. get a copy of Components For PHP Full
(http://www.jomitech.com/compforphp.php) and use their JTLookupComboBox.

> 4) I created a FormValidator and made up a bunch of rules, but when I run
> the
> unit nothing happens. How do I get the form to check the FormValidator?

Create a JavaScript OnSubmit event on the page and call the validator's
generated JavaScript method, returning the result. For example:

function Page1JSSubmit($sender, $params)
{
?>
return FormValidator1_validate();
}

--
Jonathan Benedicto (TeamB)

RadPHP Firebird

Mike Hickman — Tue, 31 Aug 2010 10:53:02 GMT

Hi,

Can you please elaborate ?

"New in XE! Firebird support in the IDE"

Are Firebird Databases included in the Data Explorer ?

Is there any difference in the way Firebird databases are handled or
connected to in comparison to MySQL and Interbase ?

Eager for an answer as I will purchase if I can get full connection and
functionality to Firebird.

Thanks

Mike Hickman

SQL Server Error

Scott Woods — Tue, 31 Aug 2010 04:46:31 GMT

I got it to work. For reference in C:\Program Files\Embarcadero\RadPHP\3.0\php there is a php.ini.template - making sure the line
extension=php_mssql.dll
was not commented out fixed the issue. I did not realize this file replaces the php.ini file for your project.