Ken
|
| Posted: 07/06/2002, 8:33 PM |
|
I am using CCS 1.0.5, PHP 4 with Templates, MySQL.
1) I have a table in MySQL that CCS will not no matter what I use to create the form update. I have tried to create the form with the wizard, the builder and on a blank form. I can't get the thing to work. I am just trying to use a record form with no grid to add users to the data base. I can send you my code? Everything else is working except for this issue and the next issues.
2) I have a form with two drop down lists. One list work perfectly, the other will not work at all. I was able to get the values into the list by creating a list of values, but this is not how I would like this to work. The values however when selected will not save in the database. Any ideas?
3) I have a link to allow the user to edit his record only. If the user is viewing a record that is not theirs and clicks on this link, it bring up a blank screen and if you click on the add button it puts a blank record in the database. How can I stop the edit screen from displaying at all if the user is not viewing their record?
Thanks in advance!
|
|
|
 |
Nicole
|
| Posted: 07/08/2002, 2:14 AM |
|
Ken,
1. what exactly doesn't work? please provide more details;
2. please check you have filled the following settings for the ListBox field:
Source Type: Database Column
Control Source: one of table fields
Connection: connection_name
List Source Type: Table/View
List Data Source: db table
Bound Column: the field from source table. Its value will be inserted into table when action (insert/update) is performed
Text Column: table field that will be displayed in the list.
Data Type: the field types of 'Bound Column' and 'Control Source' fields should match.
3. to forbid users to edit cases which not belong to them you can add check code into page Initialize event. Catch the passed "id" value, then look up corresponding user_id value using CCDLookUp() function. Compare the value to the value of session variable "UserID" (to get it use CCgetUserID() function). In case the values do not match you can just redirect user to any other page.
|
|
|
|
Ken
|
| Posted: 07/08/2002, 8:05 AM |
|
I am trying to create a page using your wizard to add new records to a table and this is the error I get everytime:
Warning: Access denied for user: 'kabwebs@localhost' (Using password: YES) in /home/kabwebs/kabwebs-www/phpAlumni/db_mysql.php on line 93
Database error: pconnect(localhost, kabwebs, $Password) failed.
MySQL Error: ()
Session halted.
The page is NOT restricted.
|
|
|
|
Ken
|
| Posted: 07/08/2002, 8:35 AM |
|
This is really irritating!!!! I created a table listing States, PA NJ, NY, etc and created a page to add edit and delete records. The table has one field and that field is the primary key. I published this page right out of the wizard and the page works perfectly, I can add edit and delete. Next I created a larger table that has about 25 fields with one field being the primary key, I followed the same procedures I did for the states table and created the pages, but published right out of the wizard these pages produce the following error when trying to access them. I will send my code if you tell me where.
Error:
Warning: Access denied for user: 'kabwebs@localhost' (Using password: YES) in /home/kabwebs/kabwebs-www/phpAlumni/db_mysql.php on line 93
Database error: pconnect(localhost, kabwebs, $Password) failed.
MySQL Error: ()
Session halted.
|
|
|
|
Ken
|
| Posted: 07/08/2002, 6:39 PM |
|
I think this is somthing everyone could use, so I am posting this here. Tech Support figured out that within the error I was getting that the $Password variable should have been spelled with a lower case "p". To resolve this issue I had to find and replace all of the references to the $Password variable in the db_MySQL.php file. Once this was completed the errors went away.
|
|
|
|
Ken
|
| Posted: 07/08/2002, 6:43 PM |
|
One more thing, this file was generated by Codecharge Studio 1.0.5. using PHP 4.0 and Templates.
|
|
|
|
CodeCharge Support
|
| Posted: 07/09/2002, 11:53 PM |
|
Ken,
we're aware of the problem with $Password variable. For now there're couple workaround for it:
1). open common.php and db_mysql.php files and modify
$this->Password;
to
$this->password;
in connect() function in db_mysql.php file and in Initialize() function in common.php file. Let us know if it helps.
OR
2). open db_mysql.php and add password value to connect() function.
We're working on its solution, but we need to collect as much information as possible about this issue. It helps much in the investigation. So please submit the request to the support system at http://support.codecharge.com/support_new.asp
and provide following information:
- does it happen with ALL php projects you build with CCS;
- email your project folder (for the project you get the problem with) and db dump tosupport@codecharge.com
|
|
|
|
meshmesh
|
| Posted: 01/05/2003, 11:01 AM |
|
you should write the correct user for the database .. and password ..
|
|
|
|
|
