NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: britech on July 23, 2010, 05:30:14 AM

Title: The Browse Next & Previous don't work with MS SQL : Need to hit Refresh Browser
Post by: britech on July 23, 2010, 05:30:14 AM

Hi Folks,

I Have a Browse on a SQL table that is sorted on a unique key. For some reason, the Next, Last Previous, First buttons don't refresh the Browse. If I press Next , and then   hit F5 (refresh), I'm asked if I want to resend the request. When I do, then I get the Next page.

Is this problem familiar to anyone else and do you know of a cause/solution?
The browse works fine if I switch it to TPS.

This is happening on all my MS SQL browses.

Netalk 5 PR 25

6.3 9055

Brian

Title: Re: The Browse Next & Previous don't work with MS SQL : Need to hit Refresh Browser
Post by: kevin plummer on July 23, 2010, 05:45:06 AM

Do your have MARS set on your connection?

If using FM3 drop this into the driver sting field on the global template.

/BUSYHANDLING=2 /MULTIPLEACTIVERESULTSETS=TRUE

I'm using MSSQL2005 and can't think what else would cause the prob except if a & is anywhere in a browse the buttons stop working although I think it would be the same for TPS. PR26 fixes this prob.

Let us know how you get on

Kev

Title: Re: The Browse Next & Previous don't work with MS SQL : Need to hit Refresh Browser
Post by: britech on July 23, 2010, 06:14:50 AM

Thanks Kevin,

I'll download PR26 and try it.
This dict works fine with the other WIN32 apps on it and we have all the driver strings setup to deal with MS SQL.
Perhaps there was a problem in PR25.
I'll check that first .
Brian

Title: Re: The Browse Next & Previous don't work with MS SQL : Need to hit Refresh Browser
Post by: Alberto on July 23, 2010, 06:40:55 AM

May be the problem is in a XHTML code in some column.
Hope this helps
Alberto

Title: Re: The Browse Next & Previous don't work with MS SQL : Need to hit Refresh Browser
Post by: britech on July 23, 2010, 09:50:44 AM

OK I found the problem. One of my columns has values that may contain a  &   in the string.

If I replace the '&' character in all my data in the Company Name fields with a '+ ', the browses work fine.

This cannot possibly be the correct solution to this. I can't tell my clients not to use the '&' character.

Is there another work around to this ?


Brian

Title: Re: The Browse Next & Previous don't work with MS SQL : Need to hit Refresh Browser
Post by: zdpl0a on July 23, 2010, 05:13:03 PM

Hi,

Bruce says this will be fixed in PR 26.  Your '&' should be accessed and displayed fine after that.  (It used to work)

Dave

Title: Re: The Browse Next & Previous don't work with MS SQL : Need to hit Refresh Browser
Post by: Bruce on July 24, 2010, 05:24:21 AM

PR 26 is up.

Title: Re: The Browse Next & Previous don't work with MS SQL : Need to hit Refresh Browser
Post by: zdpl0a on July 24, 2010, 01:40:15 PM

Both dowload sites?
The one I just downloaded was the same size as the one I downloaded on 7/7/2010

Dave

Title: Re: The Browse Next & Previous don't work with MS SQL : Need to hit Refresh Browser
Post by: Bruce on July 24, 2010, 09:34:56 PM

sorry - didn't update the mirror site - is up there now as well.

cheers
Bruce