John Ramsden
|
| Posted: 12/03/2002, 6:07 AM |
|
I'm using CodeCharge Studio v1.0.7.0 to set up PHP web pages each with a
grid comprising information read from several MySQL databases (a summary
database, and another for each customer), and I have a couple of questions:
1. For test purposes I set up a couple of database connections by using
ODBC. But as the database names will be taken from a .ini file these
names cannot be hard-coded in the PHP code; so I'd rather access the
databases directly by using connection strings.
But how does one find the format for a connection string to a MySQL
database? The CodeCharge manual doesn't give any examples.
Another reason for wanting to use direct connections is that I want
the site to be able to run on Unix as well as Windows.
2. The table records I'm reading contain a couple of datetime columns,
and despite considerable efforts I've been unable to eliminate an
irritating warning that pops up each time I run any of the relevant
pages in live mode:
Warning: Set the Project Date Format property to work correctly
with the Date fields.
I don't want to turn off warnings (I wouldn't know how to do that
anyway.) But I'd appreciate any instructions/suggestions for how
to fix whatever is causing this warning.
Cheers
John Ramsden (john_ramsden@sagitta-ps.com)
|
|
|
|
John Ramsden
|
| Posted: 12/03/2002, 8:51 AM |
|
A reply I made to my own message didn't show up, maybe because
I didn't notice that the topic line needs filling for the reply
(whatever for, I wonder, if it's in the same thread?!)
Anyway, I stopped the Date Format warning, by clicking on
the project name in "Project Explorer" then in "Properties"
setting "Default Date Format" to yyyy-mm-dd.
(and if this reply doesn't go through, I'm not trying again !-)
|
|
|
|
|
|
