janiali
Posts: 44
|
| Posted: 12/09/2007, 11:21 AM |
|
Hi every one Experts here
I am new to webdevelopment as I started with CCS .
I got one dependent list box working on one page but now the problem starts when I involve sql in the dependent list box . its not getting filter the list according to the 1st list box as it was doing before useing SQL .
the secnario is I have two list box one is Program and the second is Activities as I have 5 programs and every program has more than 50 activities .
I used SQL query for the Activies list box just to get ID and NAme togather in list box with the sql query .
since that time my activies list box is not getting the filter data according to the program list box . may be I have to use sql query to get the programID=1,2,3,4 from the URL adress bar but I don't know that query as well
before I was useing the parameter in Activites listbox that ProgramID=ProgramID (URL )
but now how to do it please help
please help me in that
thanks
_________________
Jani Ali |
 |
 |
Oper
Posts: 1195
|
| Posted: 12/10/2007, 10:52 AM |
|
you shoudl have on the listbox of the actividites
ProgramID=ProgramID (URL )
and shoudl work.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
janiali
Posts: 44
|
| Posted: 12/10/2007, 11:03 AM |
|
Quote Oper:
you shoudl have on the listbox of the actividites
ProgramID=ProgramID (URL )
and shoudl work.
yes that is already there but as I am useing SQL for activities to get activitesID and name togather in that list box since that time its not working I am useing sql as below
SELECT actTypeID, Cast( actID as varchar(7))+ ' - '+ ActName as actIDAndName
FROM tblactivity
please see the page live
thanks
Jani
_________________
Jani Ali |
|
|
|
Oper
Posts: 1195
|
| Posted: 12/10/2007, 1:27 PM |
|
like 98% of the time you dont need SQL unless thing go realy complicate to use custom SQL
to get activity toghther you dont need the to use cusotm SQL
step by step
go to the query Builder (dont use Custom SQL)
on the right click select no add 1 line with your custom AS like in the image
assign a name and that name will appear on your field selection
Check on the uimage the:Cast( actID as varchar(7))+ ' - '+ ActName as actIDAndName you used.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
janiali
Posts: 44
|
| Posted: 12/10/2007, 11:42 PM |
|
Hi Oper
Thanks for the Help its working fine on my local project but when I am puting every thing same in the live project it gives me the error below :-
Source: ListBox ActID
Error description: Line 1: Incorrect syntax near '('. (Microsoft OLE DB Provider for SQL Server)
the Main Problem I can guess is I can not see the new field ActIDandNAme any where in the like text cloumn or niether in bound coulmn as I can see that in my local proojcet .
can you please tell me what could be the problem .
there is nothing change in local and live
thanks
Jani
_________________
Jani Ali |
|
|
|
janiali
Posts: 44
|
| Posted: 12/11/2007, 4:32 AM |
|
Hi Oper
thanks its working live as well now there was some Issue with the privious SQL entry I have cleaned the SQL tansaction Log and then now its working fine .
But I have one an other problem to Admin Data search is not working now what ever I use to search its not working it showing me all the time all data
Pelase help
Thanks
Jani
_________________
Jani Ali |
|
|
|
Oper
Posts: 1195
|
| Posted: 12/11/2007, 8:23 AM |
|
its al about query builder and how CCS work.
could you please take a Snapshot of the Visual query design builder of your Grid.
Also Janiali the important is that you try to undertand what i just doing, so you could used later.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
janiali
Posts: 44
|
| Posted: 12/11/2007, 8:46 AM |
|
Quote Oper:
its al about query builder and how CCS work.
could you please take a Snapshot of the Visual query design builder of your Grid.
Also Janiali the important is that you try to undertand what i just doing, so you could used later.
Hi Oper I test that in my Local Pc every thing is working fine thanks for the Clue I am now comparing the local and live grid Query there is lot of changes I made so its will be ok hopefully
thanks a lot
Please see the new post which I posted today link is
http://forums.codecharge.com/posts.php?post_id=92534
as this is the only problem left now
I am realy great full to you for your time and help .
Thanks
Jani
_________________
Jani Ali |
|
|
|
