CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> Wishes

 Add A Combo Box Control !!

Print topic Send  topic

Author Message
rhenry

Posts: 2
Posted: 05/31/2006, 4:43 PM

Please Add A Combo Box Control. Pls......
View profile  Send private message
Benjamin Krajmalnik
Posted: 06/02/2006, 11:13 PM

Go to www.dhtmlgoodies.com
They have a free one.
I am going to test it next week within the CodeCharge framework.
I'm sure I will find a way to integrate it seamlessly.

rhenry

Posts: 2
Posted: 06/05/2006, 8:47 AM

Thanks! that's great.
View profile  Send private message
WKempees
Posted: 06/05/2006, 3:53 PM

@B
interested in implementation CCS style.
Walter
(The other Cla*r**n guy) ;-)

Benjamin Krajmalnik
Posted: 06/07/2006, 10:07 AM

I have not played with it yet.
However, I assume we can place a label inside the input tag, and in the
BeforeShow create the list of avilable items.

CCS may complain about not finding the tag, but I think the template
processor will still see it and replace it.

There are a few otjher implementatinos out there which may also work. I
just like Alf's stuff because it is elegant and works, period.

Benjamin Krajmalnik
Posted: 06/07/2006, 3:45 PM

Just found one which integrates better with Codecharge, as it performs its
magic on the OnFocus() event of the CCS generated select box.

http://planet.keks.com/scripts/download.php?id=1


"rhenry" <rhenry@forum.codecharge> wrote in message
news:224484521ac96cc@news.codecharge.com...
> Thanks! that's great.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

Benjamin Krajmalnik
Posted: 06/07/2006, 4:22 PM

There is still a minor issue which I am working out for the cases where the
item is not added to the table source (for example, the field can have an
item from the related table OR the value in the database fied for the
record).
This is just a matter of modifying the datasource on the fly.
It should not be difficult.

I will see if it can be accomplished by having a more complex datasource
uery (such as a union), or else dynamically adding to the datasource.
Also, of you ned the value to be updated into the data source table for the
combobox, this will need to be done manually.

If there is a foreign key constraint, it will need to be added before you
insert/updte the record.
I will repost as soon as I have the solution.


"Benjamin Krajmalnik" <kraj@illumen.com> wrote in message
news:e67ktj$cnc$1@news.codecharge.com...
> Just found one which integrates better with Codecharge, as it performs its
> magic on the OnFocus() event of the CCS generated select box.
>
> http://planet.keks.com/scripts/download.php?id=1
>
>
> "rhenry" <rhenry@forum.codecharge> wrote in message
>news:224484521ac96cc@news.codecharge.com...
>> Thanks! that's great.
>> ---------------------------------------
>> Sent from YesSoftware forum
>> http://forums.codecharge.com/
>>
>
>

Benjamin Krajmalnik
Posted: 06/07/2006, 4:44 PM

OK.

Got it to work perfectly.
The name of my list control is "Job".
The HTML for the control is as follows:
<select name="{Job_Name}" class="Select" style="width:250px"
onFocus="javascript:toCombo('{Job_Name}')">
<option value="" selected></option>
{Job_Options}
</select>

Now, since in this case the value in the form field may not exist in the
associated table, I made a small change to the datasource.
The datasource, as defined in the project, is Select Jons from tblQuoteJobs.
However, I neede the current value to be added to the data source, so I am
dynamically modifying the value when the quote number is > 0 (when editing
the quote) so that the value will be displayed.

The code below is ASp, but you can get the idea.

Function tblQuotes_Job_DataSource_BeforeBuildSelect()
'tblQuotes_Job_DataSource_BeforeBuildSelect @1203-CCE39E52

'Custom Code @1492-73254650
' -------------------------
' Write your own code here.
' -------------------------
if tblQuotes.QuoteNumber.Value > 0 then
EventCaller.SQL = EventCaller.SQL & " UNION Select Job from tblQuotes where
Job is not null and Job <> '' and QuoteNumber = " &
tblQuotes.QuoteNumber.Value
end if
'End Custom Code

This is the cleanest implementation of a ComboBox so far, and I have seen
many. the beauty of it is that it works seamlessly within the CCS
framework, since it builds directly on the Select control.

Michael Mikkelsen
Posted: 06/13/2006, 12:57 PM

See this solution:
http://forums.yessoftware.com/posts.php?post_id=62496
jamesgerald

Posts: 1
Posted: 06/24/2006, 7:57 AM

Guys please check out this one which i made myself at: http://www.geocities.com/cjackphil. It only runs on IE.;-) I hope this can be of some help.
_________________
jamesgerald
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.