Jack
|
| Posted: 02/28/2002, 1:21 AM |
|
Dear Sir,
I do not know if it's possible that I
could create a listbox contains more then one column data.( not in one
field )
I created a car maintenance form(master/detail), that includes some records
about repair items.
I would like to create a list selected from my parts table while inserting
to car maintenance form.
Using Oracle Developer/2000, I could create a record list contains more then
one column data
from another table. While inputing data, I just select one record from the
list and it fill into the
corresponding fields in car maintenance form.
What should I do if I want to have similar function?
Thanks
Jackson
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 02/28/2002, 2:14 AM |
|
Such thing may be possible via combination of javascript
and server side script. If you mean that when selecting a record from a
list
the data should be already present on the page and should appear
immidiately (without page reload) in car maintenance form , then
you need to store you data in javascript arrays. Upon listbox onchage event
,
a proper data will be pulled out. And of course in the very beginning
you should fill these javascript arrays on server side with data.
Here is an example that is pretty close to what you want to achieve.
"How to create dependent listboxes in CodeCharge "
http://www.gotocode.com/art.asp?art_id=45&
--
Alex
CodeCharge Developer
"Jack" <jack38@ms10.url.com.tw> wrote in message
news:a5ksrf$8jo$1@news.codecharge.com...
> Dear Sir,
> I do not know if it's possible that I
> could create a listbox contains more then one column data.( not in one
> field )
>
> I created a car maintenance form(master/detail), that includes some
records
> about repair items.
>
> I would like to create a list selected from my parts table while inserting
> to car maintenance form.
>
> Using Oracle Developer/2000, I could create a record list contains more
then
> one column data
> from another table. While inputing data, I just select one record from the
> list and it fill into the
> corresponding fields in car maintenance form.
>
> What should I do if I want to have similar function?
>
> Thanks
>
> Jackson
>
>
>
|
|
|
|
Jack
|
| Posted: 02/28/2002, 7:02 AM |
|
Dear Alexey,
Many thanks for your quick reply.
I was interested in your solution and I read the page you wrote.
There is a little problem that while I trying the ASP solution.
It's in CC 1.1.6 version and I could not open it.
Is there any new version ? Because I was not good in PHP.
Besides, I read the PHP version file, there is also a SQL file in the ZIP
file.
The example is read different columns from different tables. If I just
want to retrive more the one column from one table, may I use the PK in the
table
to get some columns in one record and put them in the correspoding fields on
the form ?
Many thanks for your kindly assitance !!
Jackson
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:a5kvtg$dm9$2@news.codecharge.com...
> Such thing may be possible via combination of javascript
> and server side script. If you mean that when selecting a record from a
> list
> the data should be already present on the page and should appear
> immidiately (without page reload) in car maintenance form , then
> you need to store you data in javascript arrays. Upon listbox onchage
event
> ,
> a proper data will be pulled out. And of course in the very beginning
> you should fill these javascript arrays on server side with data.
> Here is an example that is pretty close to what you want to achieve.
> "How to create dependent listboxes in CodeCharge "
> http://www.gotocode.com/art.asp?art_id=45&
>
>
>
>
> --
> Alex
> CodeCharge Developer
>
>
> "Jack" <jack38@ms10.url.com.tw> wrote in message
>news:a5ksrf$8jo$1@news.codecharge.com...
> > Dear Sir,
> > I do not know if it's possible that I
> > could create a listbox contains more then one column data.( not in one
> > field )
> >
> > I created a car maintenance form(master/detail), that includes some
> records
> > about repair items.
> >
> > I would like to create a list selected from my parts table while
inserting
> > to car maintenance form.
> >
> > Using Oracle Developer/2000, I could create a record list contains more
> then
> > one column data
> > from another table. While inputing data, I just select one record from
the
> > list and it fill into the
> > corresponding fields in car maintenance form.
> >
> > What should I do if I want to have similar function?
> >
> > Thanks
> >
> > Jackson
> >
> >
> >
>
>
|
|
|
|
|
