Jeri
|
| Posted: 04/06/2001, 6:41 PM |
|
HI,
I'm using PHP, MySQL and Apache. I also use phpMyAdmin to help with the
MySQL database.
I have a few field names and table names that I'd like to change. I can
change them in phpMyAdmin, but the change doesn't reflect in CodeCharge.
I've closed Codecharge, and refreshed the table fields but it still pulls up
the old names.
Is there a solution to this?
Thanks,
Jer
|
|
|
 |
Mads-Mols
|
| Posted: 04/06/2001, 8:42 PM |
|
Hi,
I have found that you can edit your projectfile 'project.ccs' with a
text-editor. This is a pure ASCII-file that contains all information about
your project. Do a 'search-and-replace'.
But be carefull - this is undocumented and I would think unsupported. I
have nevertheless changed all the filenames and various prompts in a project
this way.
Poul
----------------------------------------------------------------------
Jeri <jerirej@hotmail.com> skrev i en
nyhedsmeddelelse:9alr89$lci$1@mail.tankhill.com...
> HI,
>
> I'm using PHP, MySQL and Apache. I also use phpMyAdmin to help with the
> MySQL database.
>
> I have a few field names and table names that I'd like to change. I can
> change them in phpMyAdmin, but the change doesn't reflect in CodeCharge.
> I've closed Codecharge, and refreshed the table fields but it still pulls
up
> the old names.
>
> Is there a solution to this?
>
> Thanks,
>
> Jer
>
>
|
|
|
|
Jeri
|
| Posted: 04/06/2001, 11:29 PM |
|
HI Poul,
This is how I've been doing it also. I think the feature would be handy for
the person who wouldn't be confident modifying the main ccs file.
I was hoping the other files were text based so I could create custom
styles, but alas no luck.
Thanks for posting.
Jer
"Mads-Mols" <mads-bro@mols-linien.dk> wrote in message
news:9am2ad$19v$1@mail.tankhill.com...
> Hi,
>
> I have found that you can edit your projectfile 'project.ccs' with a
> text-editor. This is a pure ASCII-file that contains all information
about
> your project. Do a 'search-and-replace'.
>
> But be carefull - this is undocumented and I would think unsupported. I
> have nevertheless changed all the filenames and various prompts in a
project
> this way.
>
> Poul
>
> ----------------------------------------------------------------------
> Jeri <jerirej@hotmail.com> skrev i en
> nyhedsmeddelelse:9alr89$lci$1@mail.tankhill.com...
> > HI,
> >
> > I'm using PHP, MySQL and Apache. I also use phpMyAdmin to help with the
> > MySQL database.
> >
> > I have a few field names and table names that I'd like to change. I can
> > change them in phpMyAdmin, but the change doesn't reflect in CodeCharge.
> > I've closed Codecharge, and refreshed the table fields but it still
pulls
> up
> > the old names.
> >
> > Is there a solution to this?
> >
> > Thanks,
> >
> > Jer
> >
> >
>
>
|
|
|
|
John King
|
| Posted: 04/06/2001, 11:52 PM |
|
There's something wrong there Jeri. I also used MySql, Apache, PHP and
phpmyadmin during my trial period and I can guarantee you that changing
field names is a piece of cake! I strongly suggest you get CC working
properly before changing files with a text editor.
If CC is set up correctly, all field name changes made with PHPMyadmin
will show up in RED on each of the CC forms affected. Go ahead and
change your filed names using PHPMyadmin, then open CC and go to the
forms concerned. As I said, the altered fields will appear in red.
Click on the field list button next to each red field and select the
replacement which will be in black. Bingo, all is fixed without spilling
your coffee. I changed some 60 field names in ten databases in a matter
of minutes. Maybe less.
I found this a really nice feature of CC because all the field info
remained intact. Some programs just loose everything when a field is
changed, but not CC.
Don't forget to press the browser reload button from time to time
because you may be seeing a cached version of the old form.
Best wishes
John
|
|
|
|
Jeri
|
| Posted: 04/07/2001, 12:10 AM |
|
Hi John,
There were two problems:
1. The security field didn't have a refresh.
2. the original database name wasn't changed in the ccs file. It was showing
in Database under Database name, but was listed
incorrectly here:
Database="db_mysql.inc" Host="localhost"
DesignSideConnection="Provider=MSDASQL.1;Persist Security Info=False;User
ID=Admin;Extended Properties="DSN=NuSphere
MySQL;DB=affpro;SERVER=localhost;UID=root;PORT=3306;OPTION=0;STMT=;""
ServerSideConnection="affpro"
Where you see affpro now, there was a different name.
Once I changed that, the problem disappeared. Thanks for the info. Now that
I know it will work like you described, that will save a lot of
inconvenience.
Jer
"John King" <jking@cairns.net.au> wrote in message
news:3ACEB96A.5FF7FC1E@cairns.net.au...
> There's something wrong there Jeri. I also used MySql, Apache, PHP and
> phpmyadmin during my trial period and I can guarantee you that changing
> field names is a piece of cake! I strongly suggest you get CC working
> properly before changing files with a text editor.
>
> If CC is set up correctly, all field name changes made with PHPMyadmin
> will show up in RED on each of the CC forms affected. Go ahead and
> change your filed names using PHPMyadmin, then open CC and go to the
> forms concerned. As I said, the altered fields will appear in red.
> Click on the field list button next to each red field and select the
> replacement which will be in black. Bingo, all is fixed without spilling
> your coffee. I changed some 60 field names in ten databases in a matter
> of minutes. Maybe less.
>
> I found this a really nice feature of CC because all the field info
> remained intact. Some programs just loose everything when a field is
> changed, but not CC.
>
> Don't forget to press the browser reload button from time to time
> because you may be seeing a cached version of the old form.
>
> Best wishes
>
> John
>
|
|
|
|
Jeri
|
| Posted: 04/07/2001, 12:14 AM |
|
To clarify if others experienced the same thing I did.
When I changed the DATABASE Name I needed to change it's name in TWO
locations.
In the Database Section
* Connection String
* Database name
If you don't change it in connection string, all the fields will appear in
red and won't change when you refresh.
HTH,
Jer
"John King" <jking@cairns.net.au> wrote in message
news:3ACEB96A.5FF7FC1E@cairns.net.au...
> There's something wrong there Jeri. I also used MySql, Apache, PHP and
> phpmyadmin during my trial period and I can guarantee you that changing
> field names is a piece of cake! I strongly suggest you get CC working
> properly before changing files with a text editor.
>
> If CC is set up correctly, all field name changes made with PHPMyadmin
> will show up in RED on each of the CC forms affected. Go ahead and
> change your filed names using PHPMyadmin, then open CC and go to the
> forms concerned. As I said, the altered fields will appear in red.
> Click on the field list button next to each red field and select the
> replacement which will be in black. Bingo, all is fixed without spilling
> your coffee. I changed some 60 field names in ten databases in a matter
> of minutes. Maybe less.
>
> I found this a really nice feature of CC because all the field info
> remained intact. Some programs just loose everything when a field is
> changed, but not CC.
>
> Don't forget to press the browser reload button from time to time
> because you may be seeing a cached version of the old form.
>
> Best wishes
>
> John
>
|
|
|
|
John King
|
| Posted: 04/07/2001, 12:33 AM |
|
Hi Jeri,
I stand corrected, but I didn't think you could change a database name
with PHPMyadmin. Hopefully you copied the database, thus renaming the
new one in the process. I'm not sure if CC will allow you to change the
name once a CCS is created because I've never been down that track. You
had better wait for some advice from CC rather than listen to me on that
one.
regards,
John
|
|
|
|
Jeri
|
| Posted: 04/07/2001, 2:02 AM |
|
HI John,
Actually I wasn't correcting you. What you said is correct. It led me to
track down the problem.
Here's what I did in more detail. The original datbase data was dumped to a
sql file. Then I created a new database using that data. When I wrote that I
changed the name in phpMyAdmin I was incorrect.
So, I was using my original database in the Design area, but the new
database was used for localhost.
When I mad changes to the new database using phpMyAdmin, they would never
show up because I was using the original database for the design. Uggh.
I know I won't make that mistake again and hope others will avoid the same.
Thanks again for the help.
Jer
"John King" <jking@cairns.net.au> wrote in message
news:3ACEC2F0.7D3581AC@cairns.net.au...
> Hi Jeri,
>
> I stand corrected, but I didn't think you could change a database name
> with PHPMyadmin. Hopefully you copied the database, thus renaming the
> new one in the process. I'm not sure if CC will allow you to change the
> name once a CCS is created because I've never been down that track. You
> had better wait for some advice from CC rather than listen to me on that
> one.
>
> regards,
>
> John
>
|
|
|
|
John King
|
| Posted: 04/08/2001, 12:31 AM |
|
Hi Jeri,
It never crossed my mind that you may have been correcting me so don't
worry. The purpose of any exercise is to succeed, and often the answers
come in the strangest ways.
Best wishes,
John
|
|
|
|
|
