thsman
Posts: 27
|
| Posted: 02/15/2012, 2:55 PM |
|
Using builders is all good but sometimes I want to adjust something quickly like modify a WHERE clause. But I cannot find it.
So after using the gallery builder, for instance, where can I find the SQL code to modify?
|
 |
 |
thsman
Posts: 27
|
| Posted: 02/15/2012, 5:28 PM |
|
After further investigation I have found some of what I need in the code but.... the SQL WHERE clause is just not making it into the code.
There is a variable (SQL_Where) that does not appear to be set anywhere in the code
Is this a bug in CCS 5?
|
|
|
|
Oper
Posts: 1195
|
| Posted: 02/15/2012, 6:01 PM |
|
1) CCS5 is Beta
2) If you did modify any code inside that was grey. (CCS wont generate any code anymore)
you never modify inside of code (unless event properties)
3) No is not a bug, you modify bt datasource Property Window.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
thsman
Posts: 27
|
| Posted: 02/15/2012, 6:06 PM |
|
Well I found a WHERE clause in the code that was
WHERE = ""
I modified this and it now works but what happened to the WHERE clause created in the query builder opened from the gallery builder?
|
|
|
|
Oper
Posts: 1195
|
| Posted: 02/15/2012, 6:24 PM |
|
You never modify the code
you new to CCS?
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
thsman
Posts: 27
|
| Posted: 02/15/2012, 6:30 PM |
|
Yes very new.
|
|
|
|
Oper
Posts: 1195
|
| Posted: 02/15/2012, 6:34 PM |
|
Quote thsman:
Yes very new.
during the learning Curve, do not modify any CODE
Trust me if not needit
everthing is almost CLick CLICK CLICK
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
andy
Posts: 183
|
| Posted: 02/16/2012, 1:32 AM |
|
Like oper says avoid hacking the code.
Use the events or better still the intended properties.
As Oper mentioned, click on the grid or record.
In Properties, on the Data tab, click on the ... elipsis next to "Data Source", which opens the Visual Query Builder dialogue box.
In the left pane click on WHERE, then in the bottom pane, click on the + Plus icon.
This allows you to add a where condition to the SQL query.
In the toolbar at the top, you can switch between Table / Procedure / SQL mode. If you temporarily switch to SQL using the drop down at the very left of the toolbar, it will show you the Query in SQL. Select Table again and it goes back into Visual Query Builder mode.
This is how you change the data source!
Click click click
Have fun
PS
If you ever need to do any custom coding you use the events at page / form/ field level.
Read the help file to get a handle on this
_________________
Andy
RAD tools for rich UI controls:
http://www.koolphptools.com |
|
|
|
thsman
Posts: 27
|
| Posted: 02/16/2012, 6:19 AM |
|
Thanks for clarifying how to get back to the SQL stuff without running the builder again. However I still have the same problem I was "solving" by modifying the code.
Before following your instructions I changed the code back to what it was before modifying it. Then I went to the query builder as you described and sure enough there was the SQL including the WHERE clause I had created yesterday that didn't make the slightest difference to the way records were pulled.
So I closed the query builder by the "save" button and went to "live page" only to find the WHERE clause has no effect whatsoever.
So is this a bug in CCS5? If not what am I doing wrong?
|
|
|
|
thsman
Posts: 27
|
| Posted: 02/16/2012, 6:32 AM |
|
Following up to the above I just created a new project and using the gallery builder created a grid with the intention of filling it with records using a WHERE clause again. I completed it as previously and the WHERE clause has no effect. Why not?
|
|
|
|
mor
Posts: 119
|
| Posted: 02/16/2012, 7:11 AM |
|
Maybe WHERE clause is wrong?
make simple test and create WHERE for one specific row (select one row by primary key) and check result in Live Page. Bug persists?
_________________
Mor ve Ötesi |
|
|
|
Oper
Posts: 1195
|
| Posted: 02/16/2012, 7:41 AM |
|
Quote :
Following up to the above I just created a new project and using the gallery builder created a grid with the intention of filling it with records using a WHERE clause again. I completed it as previously and the WHERE clause has no effect. Why not?
Maybe WHERE clause is wrong?
make simple test and create WHERE for one specific row (select one row by primary key) and check result in Live Page. Bug persists?
you Already changed anothre code and codecharge wont generate Script anymore aroudn that part.
--> Check if where the WHERE you are talking about you changed is GREY or WHITE...
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
thsman
Posts: 27
|
| Posted: 02/16/2012, 7:53 AM |
|
Good question.
In the builder the settings are;
Field
Name = item_type Condition: Equals (=) Parameter: 2
Type = integer Type: URL
Format = blank Format: blank
The clause then looks like this:
item_type = {2}
This should select only those records where item_type = 2 but it has no effect. All records are returned.
When I modified the code myself the clause was not the same as above. My clause was
item_type = 2 without the brackets and this works.
Where is the error?
|
|
|
|
Oper
Posts: 1195
|
| Posted: 02/16/2012, 7:57 AM |
|
i think you already destroyed de code. if that part is WHITE(question you did not answer)
then the code is Destroyed.
i will Suggest:
1) Try to put everthing like it was before (hard whne you are new to CCS)
2) Start all Over.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
thsman
Posts: 27
|
| Posted: 02/16/2012, 8:13 AM |
|
Oper I created an entirely new project and did nothing but create the query with a gallery grid. I did this based on what you had said about destroying code.
I think it has to be something to do with how I am setting up the where clause in the query builder. I just downloaded and tried the same thing in CCS 4.3 and got the same result so it isn't likely to be a bug in CCS 5.
What am I doing wrong?
|
|
|
|
thsman
Posts: 27
|
| Posted: 02/16/2012, 8:14 AM |
|
Take a look at my where clause (above) and see if you can find something wrong with it.
|
|
|
|
Oper
Posts: 1195
|
| Posted: 02/16/2012, 8:51 AM |
|
Are you typing you WHERE manualy?
or CLIKCING option using listbox Selection?
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
thsman
Posts: 27
|
| Posted: 02/16/2012, 9:06 AM |
|
No I'm not typing it manually. When I put it in the code (sub Class_Initialise()) I did type it and it only worked without the brackets. Using the query builder I cannot see a way to type manually.
|
|
|
|
Oper
Posts: 1195
|
| Posted: 02/16/2012, 9:08 AM |
|
what did you type on Class_Initialize?
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
thsman
Posts: 27
|
| Posted: 02/16/2012, 9:19 AM |
|
It already had
Where = ""
I changed it to
Where = "item_type = 1"
and it worked.
|
|
|
|
Oper
Posts: 1195
|
| Posted: 02/17/2012, 6:36 AM |
|
again.
you dont need to do this.
you will have to read the help.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
thsman
Posts: 27
|
| Posted: 02/17/2012, 7:04 AM |
|
Wow. Not a very impressive response.
I'm a new user using a trial version. I have a few days left of the trial then I decide whether or not to buy a license. I like the product a lot but am having problems with it.
I ask a question here and give all the details that appear necessary to give a helpful response. I have answered all your questions regarding what I am doing.
It is perfectly fine for you to say it shouldn't be done that way. Nothing wrong with that. But it would be helpful if you would go on to describe what I should do. I did use the query builder and IT DID NOT WORK. I would like to know what I did wrong, if anything.
I have described exactly what I did in the query builder to create the where clause. I asked if there was anything wrong with it. No one has answered that question.
|
|
|
|
Oper
Posts: 1195
|
| Posted: 02/17/2012, 7:28 AM |
|
CCS is one of the best product out there.
The Only Issue is the Learning CUrve and SUpport/Help from the company
This Forum is a USER Help, you dont get reply from Develover here
that is a big issue from YesSoftware, They will sale more if at least
they get one person just to help starter.
Normaly i try to help but is really hard
we never know the exactly enviroment
MySQL/MSSQL ASP/PHP NET/Etc.
i have been using CCS for about 8Year Average i think.
and i'm sure about saying this, Must people giveup for the none Help
from YesSoftware (i almost did)
Forget the Gallery Builder
work on a Simple GridBUILDER and Record Form
Pratice around that
PS:Sometime my Answer/reply sound really Crude, English is no my Main language
Check this QuickVideo:
and how to change the where after Builder is Done.
http://www.HostSeven.com/HostSeven/Video_2012-02-17_112423.wmv
Sometime WMV dont play completly in Browser
better if you hit ALT and click the LINK to download
to your COmputer and watch there.
Quote thsman:
Wow. Not a very impressive response.
I'm a new user using a trial version. I have a few days left of the trial then I decide whether or not to buy a license. I like the product a lot but am having problems with it.
I ask a question here and give all the details that appear necessary to give a helpful response. I have answered all your questions regarding what I am doing.
It is perfectly fine for you to say it shouldn't be done that way. Nothing wrong with that. But it would be helpful if you would go on to describe what I should do. I did use the query builder and IT DID NOT WORK. I would like to know what I did wrong, if anything.
I have described exactly what I did in the query builder to create the where clause. I asked if there was anything wrong with it. No one has answered that question.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
Jan K. van Dalen
|
| Posted: 02/17/2012, 9:14 AM |
|
Honestly ... your message is misguided and up-to-a-point ... insulting.
It is obvious that you have not read the Manual in detail and to push
back to another user (not a Yes Software employee) even after he/she has
help is just not right.
Send your question tosupport@yessoftware.com and they will answer.
On 2/17/2012 10:04 AM, thsman wrote:
> Wow. Not a very impressive response.
>
> I'm a new user using a trial version. I have a few days left of the trial then
> I decide whether or not to buy a license. I like the product a lot but am
> having problems with it.
>
> I ask a question here and give all the details that appear necessary to give a
> helpful response. I have answered all your questions regarding what I am doing.
>
>
> It is perfectly fine for you to say it shouldn't be done that way. Nothing
> wrong with that. But it would be helpful if you would go on to describe what I
> should do. I did use the query builder and IT DID NOT WORK. I would like to
> know what I did wrong, if anything.
>
> I have described exactly what I did in the query builder to create the where
> clause. I asked if there was anything wrong with it. No one has answered that
> question.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
joejac
Posts: 242
|
| Posted: 02/17/2012, 10:00 AM |
|
Hello,
Reading the manuals is a must, they have also examples, and they explain how to modify the Where clause and other parts of the SQL statements.
http://support.yessoftware.com/tutorials.asp?product_id=2
Like van Dalen said please write to support, they are very good and usually they have also good response times.
I am using the product since the begining in 2001 and for me it is the best, and it is affordable.
Best regards
joejac
|
|
|
|
thsman
Posts: 27
|
| Posted: 02/17/2012, 10:12 AM |
|
Oper I had replied to you several hours ago but somehow the reply never made it to the board.
I agree with what you say about support.
I grew up with Visual Basic and was very spoilt for help and support. There were hundreds, if not thousands, of sites and forums for that.
|
|
|
|
thsman
Posts: 27
|
| Posted: 02/17/2012, 10:13 AM |
|
Jan I never meant to be insulting. If you read through the whole thread i think you will understand.
|
|
|
|
thsman
Posts: 27
|
| Posted: 02/17/2012, 10:17 AM |
|
Joejac thanks. Have you been using v.5? If so what do you think of it?
|
|
|
|
joejac
Posts: 242
|
| Posted: 02/17/2012, 11:28 AM |
|
Hello thsman,
Yes, I am using now CCS 5, it has read all my CCS4 CMS project files fine. The nice thing about CCS 5 is that now you can run the builders all the times you need over your existing generated components, that gives you big power to make modifications very easy on the fly to your components.
One amazing thing of CCS in general is the ability it has to build complex queries directly on the Visual Query Builder. The query has to be very, very complex for you to need to modify it via the "events" but it can be customized to any complex need.
I still need to test more, for next week I will have my first website of my CMS generated now with CCS 5 and I will see how it runs on a live web server. But in my localhost it looks to me stable.
CCS had provided me with big time savings thanks to the ability to reuse code, this for me is wonderful.
I remember one time I had to make a very complex database project, I did the EER diagram, generated the database with all the tables, and then with CCS 4 Application Builder it taken minutes to generate a big amount of web pages each one based on their corresponding database table. Of course, then I had to adjust the functionality of some pages, but I had the core of my application right there, in a matter of minutes, simply amazing.
Best regards
joejac
|
|
|
|
Oper
Posts: 1195
|
| Posted: 02/17/2012, 11:35 AM |
|
Quote joejac:
Hello,
Reading the manuals is a must, they have also examples, and they explain how to modify the Where clause and other parts of the SQL statements. http://support.yessoftware.com/tutorials.asp?product_id=2
Like van Dalen said please write to support, they are very good and usually they have also good response times.
I am using the product since the begining in 2001 and for me it is the best, and it is affordable.
Best regards
joejac
in 2001 wasnt CCS the name was CC only 
i remember when i started using at the end 2001 and the first i did
was go into the code and change everthing Manualy (I did not read the manual, Big mistake)
almost trought away the Product, cuase after chaneg code you can do anything.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
