CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 Multi-Select Values Into DB

Print topic Send  topic

Author Message
Imran
Posted: 08/21/2003, 6:41 AM

(ASP, SQL Server 2000)

Is there a simple way to get a multi-select box in CCS to send ALL the
values into the database field, separated by, say, commas? There seems to be
plenty of documentation in using the multi-selects for searching, but I want
to use it in a record form, and I don't want just the first value, which is
what CCS does by default.

I can always try to create some custom code here, but I'd rather not
reinvent the wheel if someone's already crossed this hurdle.

Thanks!
Imran.

Juan Domingo Herrera
Posted: 08/21/2003, 8:37 AM

Hi Imran,

You will have to receive the string passed and add those values to the
database yourself, is not complicated
but CC doesn't has anything like it to do it in an automated way :(.
--
Regards,
Juan Domingo Herrera
SoftMasters - http://www.softmasters.com.ar
Buenos Aires - Argentina



"Imran" <imranz@knight-images.com> escribió en el mensaje
news:bi2i5k$s00$1@news.codecharge.com...
> (ASP, SQL Server 2000)
>
> Is there a simple way to get a multi-select box in CCS to send ALL the
> values into the database field, separated by, say, commas? There seems to
be
> plenty of documentation in using the multi-selects for searching, but I
want
> to use it in a record form, and I don't want just the first value, which
is
> what CCS does by default.
>
> I can always try to create some custom code here, but I'd rather not
> reinvent the wheel if someone's already crossed this hurdle.
>
> Thanks!
> Imran.
>
>

Imran
Posted: 08/21/2003, 8:58 AM

I ended up using the method I figured uses the very least bit of custom
code. I just put the multi-select box in the form without connecting it to a
field, and then created a hidden field for the database field, and on Before
Insert for that hidden field, I told it to request value from the
multi-select field. Which, of course, by default pulls in the values as
value1,value2,value3.

Only one line of custom code, but it would be great if it was automated
though...



"Juan Domingo Herrera" <juandherrera@hotmail.com> wrote in message
news:bi2ovb$5f1$1@news.codecharge.com...
> Hi Imran,
>
> You will have to receive the string passed and add those values to the
> database yourself, is not complicated
> but CC doesn't has anything like it to do it in an automated way :(.
> --
> Regards,
> Juan Domingo Herrera
> SoftMasters - http://www.softmasters.com.ar
> Buenos Aires - Argentina
>
>
>
> "Imran" <imranz@knight-images.com> escribió en el mensaje
>news:bi2i5k$s00$1@news.codecharge.com...
> > (ASP, SQL Server 2000)
> >
> > Is there a simple way to get a multi-select box in CCS to send ALL the
> > values into the database field, separated by, say, commas? There seems
to
> be
> > plenty of documentation in using the multi-selects for searching, but I
> want
> > to use it in a record form, and I don't want just the first value, which
> is
> > what CCS does by default.
> >
> > I can always try to create some custom code here, but I'd rather not
> > reinvent the wheel if someone's already crossed this hurdle.
> >
> > Thanks!
> > Imran.
> >
> >
>
>

rookie
Posted: 10/16/2003, 11:16 AM

Hi,
I´m trying to do the same, can you send me your code or ccs file. I´m really
a newbe in this.

"Imran" <imranz@knight-images.com> escribió en el mensaje
news:bi2q6d$744$1@news.codecharge.com...
> I ended up using the method I figured uses the very least bit of custom
> code. I just put the multi-select box in the form without connecting it to
a
> field, and then created a hidden field for the database field, and on
Before
> Insert for that hidden field, I told it to request value from the
> multi-select field. Which, of course, by default pulls in the values as
> value1,value2,value3.
>
> Only one line of custom code, but it would be great if it was automated
> though...
>
>
>
> "Juan Domingo Herrera" <juandherrera@hotmail.com> wrote in message
>news:bi2ovb$5f1$1@news.codecharge.com...
> > Hi Imran,
> >
> > You will have to receive the string passed and add those values to the
> > database yourself, is not complicated
> > but CC doesn't has anything like it to do it in an automated way :(.
> > --
> > Regards,
> > Juan Domingo Herrera
> > SoftMasters - http://www.softmasters.com.ar
> > Buenos Aires - Argentina
> >
> >
> >
> > "Imran" <imranz@knight-images.com> escribió en el mensaje
> >news:bi2i5k$s00$1@news.codecharge.com...
> > > (ASP, SQL Server 2000)
> > >
> > > Is there a simple way to get a multi-select box in CCS to send ALL the
> > > values into the database field, separated by, say, commas? There seems
> to
> > be
> > > plenty of documentation in using the multi-selects for searching, but
I
> > want
> > > to use it in a record form, and I don't want just the first value,
which
> > is
> > > what CCS does by default.
> > >
> > > I can always try to create some custom code here, but I'd rather not
> > > reinvent the wheel if someone's already crossed this hurdle.
> > >
> > > Thanks!
> > > Imran.
> > >
> > >
> >
> >
>
>

Kevin
Posted: 10/26/2003, 2:32 PM

But this is the exact reason to BUY CCS;
Having "TOOLS" that can be dragged and dropped onto the form.
At one time they opened the API for creating tools and some of us made some
then CCS 2.x came out and everything died.

A good example is a LISTBOX control; CCS has screwed up the Select object by
naming it with an ARRAY name (listboxname[]) which means you can't reference
it from Javascript.

I created a new LISTBOX type called MLISTBOX that allows extended
multi-select returning a comma delimited list of values.
Now when I need to select n~ number of users to add them to a group it's
simple.

I have been waiting for CCS to publish the API for creating controls for
over a year, it would be a great product if they allowed us to add controls
since they seem to be focused on making CCS work with every script language
made, not functionality.

"Imran" <imranz@knight-images.com> wrote in message
news:bi2i5k$s00$1@news.codecharge.com...
> (ASP, SQL Server 2000)
>
> Is there a simple way to get a multi-select box in CCS to send ALL the
> values into the database field, separated by, say, commas? There seems to
be
> plenty of documentation in using the multi-selects for searching, but I
want
> to use it in a record form, and I don't want just the first value, which
is
> what CCS does by default.
>
> I can always try to create some custom code here, but I'd rather not
> reinvent the wheel if someone's already crossed this hurdle.
>
> Thanks!
> Imran.
>
>


   


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

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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