nested repeat region extension from dwteam.com

I'm trying to group some records together. The tutorial for this extension
only groups on one field. I'd like to group multiple fields. ie. I have a
list of companies(with all address info) and then a list of contacts with these
companies as well. Normally it would list each company with only one contact
below it. And would repeat each company for each contact that exists. I've
tried selecting all the company fields and applied the nesting but when I test
it makes the company and address info disappear altogether and only shows the
grouped contacts.
Setup: dreamweavermx 2004, phakt adodb, php4, iis

Hello,
Actually, if you want to list both the company and the contact, you
don't need a nested repeat region.
You need a left join in your SQL query, and then a regular repeat
region will do.

select * from table1 left join table2 on idcompany=idfkcompany

Alexandru

newbeenewbee wrote:

I'm trying to group some records together. The tutorial for this extension
only groups on one field. I'd like to group multiple fields. ie. I have a
list of companies(with all address info) and then a list of contacts with these
companies as well. Normally it would list each company with only one contact
below it. And would repeat each company for each contact that exists. I've
tried selecting all the company fields and applied the nesting but when I test
it makes the company and address info disappear altogether and only shows the
grouped contacts.
Setup: dreamweavermx 2004, phakt adodb, php4, iis

--
Alexandru COSTIN
President Products Division
Dreamweaver Extensions: http://www.interakt.ro/
+4021 312 5312

I think you misunderstood a bit. I just need to list the company once and all
the related contacts below it.

ie.
I have this currently:
Test Co. 123 Main St. New York, NY 44444
Joe Smith (333)-333-3333
Test Co. 123 Main St. New York, NY 44444
Tanya Baaa (444)-444-4444

I want this
Test Co. 123 Main St. New York, NY 44444
Joe Smith (333)-333-3333
Tanya Baaa (444)-444-4444

But it's outputting this(company info disappears):
Joe Smith (333)-333-3333
Tanya Baaa (444)-444-4444

Hello,
I can't help you much with Tom's product, but I can help you by
recommending you our product <can't help it>
http://www.interakt.ro/products/MXLooper/

Alexandru

newbeenewbee wrote:

I think you misunderstood a bit. I just need to list the company once and all
the related contacts below it.

ie.
I have this currently:
Test Co. 123 Main St. New York, NY 44444
Joe Smith (333)-333-3333
Test Co. 123 Main St. New York, NY 44444
Tanya Baaa (444)-444-4444

I want this
Test Co. 123 Main St. New York, NY 44444
Joe Smith (333)-333-3333
Tanya Baaa (444)-444-4444

But it's outputting this(company info disappears):
Joe Smith (333)-333-3333
Tanya Baaa (444)-444-4444

--
Alexandru COSTIN
President Products Division
Dreamweaver Extensions: http://www.interakt.ro/
+4021 312 5312

Can it handle what I need it to do? Or can it only group on one field only.

Hi,
Please send me your access database and I will let you know if we
can handle it or not.

Right now, it is not very clear what you want to do and how your
information is organized

Alexandru

newbeenewbee wrote:

Can it handle what I need it to do? Or can it only group on one field only.

--
Alexandru COSTIN
President Products Division
Dreamweaver Extensions: http://www.interakt.ro/
+4021 312 5312

I can't send you my access database, it's in postgresql. Here's how the query
is layed out. An example of a single record:

company, dba, street, city, state, zip, name, lastname, phone, fax

I'd like to group on "company, dba, street, city, state, zip"

because there are many records which have the same company but different
"name, lastname, phone, fax"

So once it's grouped I want it to look something like this on my web page:

company, dba, street, city, state, zip
name, lastname, phone, fax
name, lastname, phone, fax
name, lastname, phone, fax

instead of :
name, lastname, phone, fax

We also take pgdumps
But I can confirm - our extension allows you to do this

Alexandru

newbeenewbee wrote:

I can't send you my access database, it's in postgresql. Here's how the query
is layed out. An example of a single record:

company, dba, street, city, state, zip, name, lastname, phone, fax

I'd like to group on "company, dba, street, city, state, zip"

because there are many records which have the same company but different
"name, lastname, phone, fax"

So once it's grouped I want it to look something like this on my web page:

company, dba, street, city, state, zip
name, lastname, phone, fax
name, lastname, phone, fax
name, lastname, phone, fax

instead of :
name, lastname, phone, fax

--
Alexandru COSTIN
President Products Division
Dreamweaver Extensions: http://www.interakt.ro/
+4021 312 5312

I don't understand why you are needing to group on more that one field.
From the example you gave, you need a standard repeat region for which the
DWTeam extension is the proper tool.

I think you do not need to group on the multiple fields - you need to group
on only one field (CompanyID). You can still write those other fields to the
page without including them in the grouping statement.

BTW, Tom has a support newsgroup (doesn't appear very active, though). The
newsgroup server is "tom-muck.com" and the name of the forum is
"dw_extension_support".

"newbeenewbee" <webforumsuser (AT) macromedia (DOT) com> wrote

Can it handle what I need it to do? Or can it only group on one field
only.

do you have a demo I can test on my site first?