imranwsu@hotmail.com
|
| Posted: 04/29/2004, 1:09 AM |
|
 Hi.
I am new to CCS and also kind of beginner to Web programming but I am a very good learner. I believe so. I need to know is there any good tutorial for these issue or any person can explain me all points with some example.
I want to know what the function of these “table parameter” and how we utilize it
And if I select Expression in Table parameter window. how can I utilize it (any example pls) and what is this “and” , “or” option how these effect differently. And what is parameters different options are. Like “Field” “Condition” “Parameter Source” and for Parameter Source what is this “Type Option” and how different option under this category gives different power for different situation. When we suppose to what in what condition. If I m using expression then from where I will get that expression. And If I m using URL and then what does it mean. Does it mean post method. I am confused to much. Is there any tutorial who will explain very well about this Data Source option and specially this parameter stuff and all its option. Even I search in online help for CCS but there is nothing like Parameter.
Thanks in Advance
Imran 
|
|
|
 |
ryan
Posts: 41
|
| Posted: 04/29/2004, 1:17 AM |
|
Sorry :
The only way to learn it is go through it man!
Data Source - Table, SQL Statement...
Parameter - You define it from CCS when expression you define it the way you use on Quer Analyzer WHERE(thisfield=12)
Something that's too complicated to explain here....you will get your head on this...please start experimenting and don't give up CCS makes it easy.
_________________
(\__/)
(='.'=)
(")_(") |
 |
|
peterr
Posts: 5971
|
| Posted: 04/29/2004, 9:42 PM |
|
Imran,
The explanation may depend on your understanding or experience with the SQL. The parameters are converted to SQL WHERE clause and are not used for anything else.
For example creating a parameter "article_id = s_article (URL)" is equivalent to typing an SQL statement ending with:
"WHERE article_id=(some variable)". Table parameters basically allow to visually create the WHERE clause. You can familiarize yourself with the WHERE clause at http://www.google.com/search?q=sql+%2Bwhere+clause
The "AND" and "OR" operators are also generated as part of the SQL, therefore the only way to understand it is to be able to construct simple SQL. Also see http://www.w3schools.com/sql/sql_and_or.asp
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Imran
|
| Posted: 04/29/2004, 11:07 PM |
|
 Hi ryan and peterr thanks for replaying on this issue. First I would like to give you my back ground so you will able to help me more clear way. Basically I am a masters student in computer sci. ( But my Bachelors not in computer Sci  ) Last semester I took one database course where I did enough sql but I forget most of it but still I have basic concept of it except for join and inner join and outer join instead I know how to use select command to do these functionality as well as division quires. I also did little bit web programming in perl cgi and asp in last fall semester but the problem is I never used this kind of visual editor and most of my programming I did in VI or notepad. That’s why I would like to clear some basic fundas for this visual environment so lets start again this discussion .
Peter I understand your meaning that parameter is some kind of variables which we pass from previous page or current page to run queries against data base . Also URL means query string like in asp and post and get method mean same which we use in form. To submit data from form to destination. But here I have one problem in form we also mention destination page where I need to send these parameter variable but in CCS where I m mention my desired destination page to send these variables. And if CCS is dealing in some different way then what is that way. Another problem which I facing is to understand the control flow of the program since most things are automated. Lets say usually I make asp or html page where I have form and then I submit this page to one asp page which just do the processing and some other thing and then forward control to another asp or html page. But how ccs is doing stuff here in with case of asp still I m not able to understand. Another thing if I choose session variable then where I can declared my session variables and am I allowed to choose any name for it and it will choose the default name ( it is sory to say that I search for information of session variables in complete documentation but there is nothing like session variables just session timeout property. Ryan or Peter could u pls tell me is there any information regarding session variables and cokies for CCS like to make it how to use it what are the restriction in CSS for these. Another thing for Table property ok I m choosing the URL to assign parameter from URL which is coming from my previous page to this page to do some executing the database or something other stuff but how any body can declare these URL parameter to send other page and also what about application and expression how we create parameter by application to use in table parameter on which situation we create parameter by application and expression pls peter if you work in CSS ask them to make some good documentation otherwise it seem to me like Macintosh computer system on which even after spending 25 min I was not able to find from where I should get the ip of this sytem. I am sorry for lengthy mail but I m feeling exciting and frustrating by using this product but I really like to learn this product since I know how much pain is to do coding in VI.
Thanks
|
|
|
|
ryan
Posts: 41
|
| Posted: 04/30/2004, 12:47 AM |
|
Imran :
What can I say the trick to understanding one technology is perseverance. First I can see myself in your shoes I despised CC and CCS I said what is this I am in so much stress with my previous employer that I was forced to learn new tool out of nothing, I have less time to browse forums, test codes and review articles. I've been literally dissing the Codecharge support for two months I'va asked redundant questions posted everything...and guess what I BECOME OBSESSED with Codecharge studio.
I've been creating custom applications that look like not CODECHARGE STUDIO made.
http://www13.brinkster.com/charmangel/_forum/ccswww/For...seATheme=TSPACE
http://www13.brinkster.com/charmangel/_forum/sitewww/PollSoftware.asp
And now when I see other posts they've created other CCS sites as well all unique, all that stand out not just grid-record forms not just the layer inside but the look and feel. Many people asked me "hey is that really Codecharge Studio made" I use custom functions and that comment alone entices me to do more so every criticism became positive reinforcement I still resume to do CCS components that are unique. Basically I am distracted with the usual grid record form. I like to do something that is different from those outsource companies that say "Hey we charge $250.00 for this" and what you get is a lousy common, mediocre design...I am so obsessed with changing the interface fiddling stuff that CCS can do.
I have an e-commerce site (no payment gateway) and an online reservation that is CCS made I like to do more and help others but I cannot disseminate everything I know I'd rather give tips because it's you that has that creativity to enthrall users not others.
_________________
(\__/)
(='.'=)
(")_(") |
|
|
|
Imran
|
| Posted: 04/30/2004, 10:12 AM |
|
hi i got information about those which i m looking for from downloading the complete documentation on local computer and then search session variable in search column . since online documentation don't have any search option i was not able to search. so first i will read those and then i will ask you people further question regarding this Topic
Thanks a lot
Imran
|
|
|
|
