lurch99
Posts: 47
|
| Posted: 05/14/2004, 6:10 PM |
|
Hi Folks,
I've just taken the plunge and bought CCS and am working my way through the first tutorials.
I have successfully created the pages with the Application Builder and am testing the page and two things happen:
1) I am not presented a login opportunity
2) On the List of Tasks, I have ID, Project_ID, Status_ID, Type_ID, etc etc instead of Project Name, Priority Name, Status Name, etc etc.
Any help would be much appreciated. I'm using PHP and mySQL.
Sincerely,
Lurch
|
 |
 |
peterr
Posts: 5971
|
| Posted: 05/14/2004, 6:28 PM |
|
I can try to help.
Please let me know which tutorial you used. The Task Management tutorial?
Besides the above issues, is your application generally working? Are you able to see the data and navigate between pages?
If not, I'd be curious if you used our sample databases (Internet and Intranet) and already loaded the SQL script(s) into MySQL? Can you see those databases directly in MySQL?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
lurch99
Posts: 47
|
| Posted: 05/14/2004, 6:57 PM |
|
Hi Peterr
I'm using the Quick Start tutorial and trying to create Task Management System with the Application builder.
I do see the tables and live data after hitting Live Page, but that's exactly where I am not given the login dialogue and then the info does not have the correct labels, as described above.
And yes, I've already populated mySQL with the info from the Intranet sample database included with CCS.
Thanks in advance for your help. By the way, this tutorial worked with ASP but my final product will have to be with PHP/mySQL so I might as well get this working correctly from the getgo...
Lurch
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/14/2004, 8:06 PM |
|
OK. I figure that the wrong field names (and probably values in those) are due to lack of relationtial features of MySQL. Our MS Access examples include predesignd relations but MySQL doesn't have features to design or store the relations that we could then read. One solution might be for you to use MS Access during the design but MySQL for live site, of course only when working with our sample databases.
When working with your own database you can design relational queries using the Visual Query Builder in CCS after you use the Application Builder. This should be easy once you try. Search for "Visual Query Builder" at http://docs.codecharge.com/studio/html/UserGuide/Forms/FormDataSource.html
Regarding the login screen, I just checked and there should be no Login screen shown when you view the "tasks_list" page. The Tutorial shows that page without login screen at http://docs.codecharge.com/studio/html/QuickStart/Creat...e/TestPage.html
All other pages should force users to login if this is what you specified on step 6 of the Application Builder as shown at http://docs.codecharge.com/studio/html/QuickStart/Creat...gSitePages.html
Since you're already past that step, check that the "Restricted" property of all other pages is set to "Yes".
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
lurch99
Posts: 47
|
| Posted: 05/14/2004, 8:16 PM |
|
Peter,
Thanks for your reply, I have everything working now except the relational features, which I'll tackle next. I was simply surprised to see different results after having done this same tutorial with ASP. Your answer makes perfect sense, and I'm realizing little by little where mySQL is somewhat limited.
One totally dumb question if you get a chance: when I enter my local IIS server's IP of http://192.168.1.5/TaskManager/login.php it works great. But I cannot substitute http://localhost/TaskManager/login.php or use the IP of 127.0.0.1.
Sorry for the newbie questions, I'm a Mac guy who is totally impressed with your software enough to jump ship for development purposes and some of this doesn't come that easily....
Lurch
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/14/2004, 10:56 PM |
|
I'm not sure if the last one is a dumb question because I don't know the answer 
What happens when you try using your localhost or 127.0.0.1 IP? Any errors?
Also here are related discussions:
http://forums.devshed.com/archive/t-118723
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&thre...t%3D10%26sa%3DN
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
lurch99
Posts: 47
|
| Posted: 05/17/2004, 2:45 PM |
|
Peterr,
I appreciate your patience with me, I figure once I'm past these early hurdles it will be all downhill!!
I am still trying to use the Visual Query Builder so that I can have my Tasks List show the value rather than the ID (you said this is because of mySQL's lack of relational features, which jibes with the fine print in the tutorial). In other words, project_id 1 should list Code Charge, project_id 2 should list My Project, etc etc.
So, apparently I should click anywhere on the Tasks List page, go to Data Source in my Data Properties panel, choose the Projects table (for example), and then what? It seems to want me to setup a join but that is not necesary. All I want is to exchange the ID values for its text value.
I've searched the documentation and it still isn't clear. Any help at this point would be much appreciated!
Thanks in advance,
Lurch
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/17/2004, 3:18 PM |
|
Lurch,
Those joins are actually used specifically to do what you need - replace ID value with the name or other value that you want to display. This is OK and it is the correct usage of relational database (even if the database doesn't remember/store those relations).
Therefore in the VQB you would need to add the Project table, place your cursor on the "project_id" field in the Projects table and drag it onto the sampe "project_id" field within the Tasks table. You should then see that both tables are joined via their project_id fields.
Once this is done click OK, select "project_id" field in your grid and change its "Control Source" property to "project_name" which now should be available thanks to that join.
Once you do this I hope that you'll be successful with configuring the other fields in a similar way.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
lurch99
Posts: 47
|
| Posted: 05/17/2004, 3:35 PM |
|
Peterr,
I'm guessing that your reply was to populate the headers at the top of the grid, correct?
Then what about the procedure for populating the data below the heading, ie project_id 1=CodeCharge.....
Lurch
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/17/2004, 3:38 PM |
|
I was referring only to the data section of the grid.
The headers are made of static text that can be easily edited directly on the page.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
lurch99
Posts: 47
|
| Posted: 05/17/2004, 4:25 PM |
|
Peterr,
That was indeed a dumb question, sorry.
Please tell me once you are in the VQB and have the tables for both Project and Tasks, which checkboxes are checked--I'm still not getting the results you describe.
But I'm almost there, I can feel it!
Lurch
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/17/2004, 4:35 PM |
|
I would check the two "*" fields, one in each able.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
lurch99
Posts: 47
|
| Posted: 05/17/2004, 4:46 PM |
|
Peterr,
Success! Turns out one final item had to be changed: the data type had to be text not integer, which is what the default was...
Thanks! On to other items now!
a Happy Lurch
|
|
|
|
lurch99
Posts: 47
|
| Posted: 05/17/2004, 4:59 PM |
|
Urgh, I spoke too soon!
It does print out the values, but I get an error when clicking on the headers (which are hyperlinks).
The following error:
Database error: Invalid SQL: SELECT * FROM ((tasks INNER JOIN projects ON tasks.project_id = projects.project_id) INNER JOIN priorities ON tasks.priority_id = priorities.priority_id) INNER JOIN statuses ON tasks.status_id = statuses.status_id ORDER BY project_id
MySQL Error: 1052 (Column: 'project_id' in order clause is ambiguous)
Session halted.
Any suggestions would be much appreciated!
Lurch
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/17/2004, 6:11 PM |
|
Please try changing the "Sort Order" property of that sorter (hyperlink in the grid header) by selecting "project_name" instead of "project_id" in there.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
lurch99
Posts: 47
|
| Posted: 05/17/2004, 6:36 PM |
|
Peterr,
That works, thanks! Great to see everything as expected!
One final question, I promise--before moving on: the last column user_id_assigned_to, I don't see what that should be linked (joined) to....
Your help has been invaluable, thanks Peterr
Lurch
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/18/2004, 3:35 AM |
|
Glad to see you make progress.
The user_id_assigned_to should be joined with employees.emp_id ("emp_id" field in the "employees" table).
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
