Zye
Posts: 56
|
| Posted: 08/19/2004, 5:07 PM |
|
Hello Community &
Hello Ashiff
I searched for the code you mentioned in your post on gotocode but it dosn't look like it exists anymore.
http://forums.codecharge.com/posts.php?post_id=24124&s_keyword=
I am desperate to get this working after playing around with SQL queries all week, following the CCS Example pack.
I have two search forms on a page, one with a keyword search and two dependant listboxes as taken from the example by Walter Kempees: Works great as is .... until I try to make it work with SQL as my datasource type on my results grid.
http://forums.codecharge.com/posts.php?post_id=49888&s_keyword=
The other form has a mult-select listbox with my categories, which I am trying to get working with the SQL datsource of my grid as stated in the CCS Example Pack.
I got the muti-select listbox working on my records form following the examplepack. I just need to search them now.
I noticed that on the multiselect search example the beforebuildselect event is active with no custom code included.
I just need to get my categories working and the beforebuildselect event seems like the only way. I just haven't seen any example code for it anywhere.
Can you help me, or indeed can anyone help a poor soul.
I am inexperienced so any help would be appreciated.
Thanks
Zye
|
 |
 |
Damian
|
| Posted: 08/20/2004, 5:24 AM |
|
Zye,
Im not exactly sure what you are trying to do.
The first example here selects ALL values in the drop down list.
The second value here has 4 listboxes, listbox 2 is dependant on listbox 1,
List box 3 on 2 and listbox 4 on 3. In this example the search is actually
only searching on the value selected in Listbox 4.
If you want to do anything more than a simple search you need to write some
custom code.
Damian
"Zye" <Zye@forum.codecharge> wrote in message
news:5412540d81b08b@news.codecharge.com...
> Hello Community &
> Hello Ashiff
>
> I searched for the code you mentioned in your post on gotocode but it
dosn't
> look like it exists anymore.
>
> http://forums.codecharge.com/posts.php?post_id=24124&s_keyword=
>
> I am desperate to get this working after playing around with SQL queries
all
> week, following the CCS Example pack.
>
> I have two search forms on a page, one with a keyword search and two
dependant
> listboxes as taken from the example by Walter Kempees: Works great as is
.....
> until I try to make it work with SQL as my datasource type on my results
grid.
>
> http://forums.codecharge.com/posts.php?post_id=49888&s_keyword=
>
> The other form has a mult-select listbox with my categories, which I am
trying
> to get working with the SQL datsource of my grid as stated in the CCS
Example
> Pack.
>
> I got the muti-select listbox working on my records form following the
> examplepack. I just need to search them now.
>
> I noticed that on the multiselect search example the beforebuildselect
event is
> active with no custom code included.
>
> I just need to get my categories working and the beforebuildselect event
seems
> like the only way. I just haven't seen any example code for it anywhere.
>
> Can you help me, or indeed can anyone help a poor soul.
> I am inexperienced so any help would be appreciated.
>
> Thanks
>
> Zye
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Walter Kempees
|
| Posted: 09/18/2004, 1:39 PM |
|
send me the project and I'll have a look.
It can be done and remeber:
ïf it's difficult, youre on the wrong approach" (grin)
kempe819 at planet dot nl
Walter Kempees
"Zye" <Zye@forum.codecharge> schreef in bericht
news:5412540d81b08b@news.codecharge.com...
> Hello Community &
> Hello Ashiff
>
> I searched for the code you mentioned in your post on gotocode but it
dosn't
> look like it exists anymore.
>
> http://forums.codecharge.com/posts.php?post_id=24124&s_keyword=
>
> I am desperate to get this working after playing around with SQL queries
all
> week, following the CCS Example pack.
>
> I have two search forms on a page, one with a keyword search and two
dependant
> listboxes as taken from the example by Walter Kempees: Works great as is
.....
> until I try to make it work with SQL as my datasource type on my results
grid.
>
> http://forums.codecharge.com/posts.php?post_id=49888&s_keyword=
>
> The other form has a mult-select listbox with my categories, which I am
trying
> to get working with the SQL datsource of my grid as stated in the CCS
Example
> Pack.
>
> I got the muti-select listbox working on my records form following the
> examplepack. I just need to search them now.
>
> I noticed that on the multiselect search example the beforebuildselect
event is
> active with no custom code included.
>
> I just need to get my categories working and the beforebuildselect event
seems
> like the only way. I just haven't seen any example code for it anywhere.
>
> Can you help me, or indeed can anyone help a poor soul.
> I am inexperienced so any help would be appreciated.
>
> Thanks
>
> Zye
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Walter Kempees
|
| Posted: 09/18/2004, 1:43 PM |
|
meanwhile:
in the build select do something like
select [fields] from [table]
where field 1 = selectfield1
and/or field2 = selectfield2
in the parameter section of the build select add the selectfield1 and the
selectfield2
(make sure they are of the same type as the selectboxes)
and in the properties of each parameter field set them to use the selctbox
from the FORM (type = FORM)
should be doable, but first offer still stands.
Walter
"Zye" <Zye@forum.codecharge> schreef in bericht
news:5412540d81b08b@news.codecharge.com...
> Hello Community &
> Hello Ashiff
>
> I searched for the code you mentioned in your post on gotocode but it
dosn't
> look like it exists anymore.
>
> http://forums.codecharge.com/posts.php?post_id=24124&s_keyword=
>
> I am desperate to get this working after playing around with SQL queries
all
> week, following the CCS Example pack.
>
> I have two search forms on a page, one with a keyword search and two
dependant
> listboxes as taken from the example by Walter Kempees: Works great as is
.....
> until I try to make it work with SQL as my datasource type on my results
grid.
>
> http://forums.codecharge.com/posts.php?post_id=49888&s_keyword=
>
> The other form has a mult-select listbox with my categories, which I am
trying
> to get working with the SQL datsource of my grid as stated in the CCS
Example
> Pack.
>
> I got the muti-select listbox working on my records form following the
> examplepack. I just need to search them now.
>
> I noticed that on the multiselect search example the beforebuildselect
event is
> active with no custom code included.
>
> I just need to get my categories working and the beforebuildselect event
seems
> like the only way. I just haven't seen any example code for it anywhere.
>
> Can you help me, or indeed can anyone help a poor soul.
> I am inexperienced so any help would be appreciated.
>
> Thanks
>
> Zye
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
