As shown in KB278613 DISTINCT drop down not working

[Mettá]

Hi
I have had some help from Thomas to get round this problem, but before
rewriting loads of pages...

Has anyone got a modified DRW drop down using DISTINCT which is based on a
form search.

i.e. User inputs a search term as say xxx, DRW returns all counties in a
DISTINCT drop down where the searched field contains xxx

This new problem is on an machine with XP Pro, FP 2002 inc all MS updates up
to SP3

The drop down comes back empty??

 

[Jim Buyens]

-----Original Message-----

Hi
Howdy.

I have had some help from Thomas to get round this
problem, but before rewriting loads of pages...

Has anyone got a modified DRW drop down using DISTINCT
which is based on a form search.

i.e. User inputs a search term as say xxx, DRW returns
all counties in a DISTINCT drop down where the searched
field contains xxx

This new problem is on an machine with XP Pro, FP 2002
inc all MS updates up to SP3

The drop down comes back empty??

1. Get the DRW drop-down working without DISTINCT.
2. Once the drop-down is displaying multiple occurences,
run the DRW once more, then on page 2 click Custom
Query and Edit. Them, add the word DISTINCT after
SELECT.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Mettá]

Hi
I have done this, there seems to be a problem, maybe with SP3 and I wanted
to know if anyone else was having trouble with this. I have had it working
well for some time, now it will not populate once changed to Distinct - it
works fine without Distinct except for multiple copies in the drop down????

 

[Jim Buyens]

Curious. Have you tried a GROUP BY clause:

SELECT country FROM countrytable
GROUP BY country
ORDER BY country

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Mettá]

Hi
Thanks for the suggestion but it has made no difference...

The custom sql reads:
SELECT County FROM dbNAME WHERE (Description LIKE '%:escription::%') GROUP
BY County ORDER BY County ASC

It comes back empty, to check the variable "Description" I placed a
request("description") within the drop down and it shows up, as I said
before it works without the DISTINCT. GROUP BY seems to "cause" the same
problem????

M

 

[Jim Buyens]

I spent quite a bit of time working with this, and I feel there *are*
serious problem with the Database Results Wizard and Office XP SP3.
However, I haven't been able to localize the specific problem or fix.

I guess the next thing to try would be backing off Office XP SP3.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Jim Buyens]

Whoops, I guess there isn't an uninstall for Office XP SP3. Perhaps an
uninstall/reinstall would do it.

All in all, Office XP SP3 looks like a bad thing to install if you use
the Databse Results Wizard.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Mettá]

Hi

Thank you for taking the time to check this out.

Any idea if MS are likely to rectify this in the very near future, I have 3
sites using DISTINCT in DRW's within numerous pages. A rewrite is a lot of
work. Not to mention the other problems with record updates etc on other
pages which also seem to have gone wrong.

Once again thanks for checking on this one.

Regards
Mark

 

[Jim Buyens]

Hi

Thank you for taking the time to check this out.

Any idea if MS are likely to rectify this in the very near future, I have 3
sites using DISTINCT in DRW's within numerous pages. A rewrite is a lot of
work. Not to mention the other problems with record updates etc on other
pages which also seem to have gone wrong.

Once again thanks for checking on this one.

Regards
Mark

Sorry, no idea. It could be tomorrow, or it could be never. Because
anything they say in public instantly becomes a commitment, the
FrontPage team, the Office team, and Microsoft in general are
very tight-lipped about this sort of thing. I certainly have no
access to a prioritized list of issues, or anything like that.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------