West Wind Message Board Messages

Attachments:

None

Will you also be planning some time for developer show and tell?

What are the arrangements for your WC sessions/training at SWFox 2010?

A vendor session, or a pre- or post- conference session?

There will be a Web Connection training workshop prior to the main conference (assuming I can get space at the hotel)...

I'll post details here as soon as I get them.

+++ Rick ---

I did not know you were going to be there. But, I'm glad to hear it.

Details please...

As you are using your, btw great tool, West Wind HTML Help Builder, could you please create a word or PDF format of the wc documentation so we can carry it in a Kindle?

The documentation is available in Word format - take a look in the help file for the link (although the Word docs tend to be slightly out of date). You can create a PDF from that with the Office PDF tools.

PD. Are you doing a new work shop abot WC at SouthWest Fox this year?

Yes I'm planning to do training this year at Southwest Fox.

+++ Rick ---

Getting wwSMTP, upgrading, purchasing, etc

Julian Dominguez — Sat, 20 Mar 2010 21:19:08 GMT

Getting wwSMTP, upgrading, purchasing, etc

West Wind Internet Protocols

Getting wwSMTP, upgrading, purchasing, etc

03/20/2010
02:19:08 PM
2W40XE2A8

From:

Julian Dominguez

To:

All

Attachments:

None

UPDATE to my question.....

Is available individually?

As part of another package?

I have wwipstuff that i have had since I bought Web Connection, but cannot remember if I got it as part of it or separate :(

What I want is to find out if and upgrade is available ....... which is the simplest upgrade??

Hi all!

How do I get the wwSMTP class??

Thanks

Julian

Jquery problem

Tore Bleken — Sat, 20 Mar 2010 19:08:16 GMT

Jquery problem

Web Connection 5.0

Jquery problem

03/20/2010
12:08:16 PM
2W50PY46Q

From:

Tore Bleken

To:

All

Attachments:

None

I have a strange problem with some jquery code. The code includes some debugging code, to illustrate the problem. I have some tables with three rows, row one is text, row two is an image, and the third row is more text. The purpose of this code is to read the "alt" value from the second row in a table, when the user clicks the text in the first row. The code works when I hard code the colx variable, but when I calculate the value in the code, it does not with. To debug the code, I added code to change the backcolor for row 3 when the text in row 1 is clicked.

With the code below, when I click row one, the whole third row gets red backcolor. But when I hard code colx to for instance 4, the code works as expected, meaning that only column four in the third row gets red backcolor. Clearly the calculated colx and the hard coded colx behave differently, but why? And how do I fix this? Any tip is appreciated, I have already spent a whole day with something I expected to be a trivial thing.

A second problem is that with IE the backcolor does not change, but that's not important since I only change the backcolor in order to test my code. But it's strange anyway.

<script type="text/javascript">
  $(function(){
  $('table th')
  .click(function(event){
  var colx = $(this).parent().children().index($(this));
  var table1 = $(this).parent().parent().parent();
    $('tr:nth-child(3) td:nth-child(colx)',table1).css("background-color","Red");
  var verdi = $('tr:nth-child(2) td:nth-child(2)',table1).css("background-color","yellow").attr('img') + ' ' +colx;
  say(verdi);
  })
  function say(text) {
  $('#console').html('<div>'+text+'</div>');
  }
</script>

The problem is with the variable colx, which calculates which column's header I click.

Web Connection, IIS, Kernel Caching, and Low Latency

Brett Baggott — Sat, 20 Mar 2010 15:56:07 GMT

Web Connection, IIS, Kernel Caching, and Low Latency

Web Connection

Web Connection, IIS, Kernel Caching, and Low Latency

03/20/2010
08:56:07 AM
2W501WQPO

From:

Brett Baggott

To:

All

Attachments:

None

I'm going to lay out a hypothetical here and _please_ understand it's hypothetical only because your first instinct is probably going to be to say, "but why would you do that", I wouldn't.

Here goes.

Let's say you wanted to build MarchMadnessRealtimePlayerStats dot Com and so you build a pretty UI (I'm talking web page here) to send to the client and then you fired an Ajax call _per second_ back to the server where all the stats were stored that would update the user's UI with all the second by second stats.

Now, if the backend to this was Web Connection, and you anticipated having thousand of viewers, you'd want to be as efficient as possible. For example, you'd service your Ajax call via a "static cookieless domain" to help improve latency. After all, if your responses are taking 1 sec+, polling per second is kinda pointless.

Now let's say that 99% of your users were viewing their favorite player 99% of the time. Now you start to think, maybe cache can help me out here. After all, at any given millisecond, with thousands of viewers, and with so may uber popular players, you're _very_ likely to have _identical_ request/response streams.

So, all that to say, in the given hypothetical, where you might hope to one day have hundreds of thousands of users but yet still keep the back-end we all love, what can be done to:

a. improve latency (IIS, don't need any networking pointers)
b. improve possibility of kernel caching kicking in
c. improve things I haven't thought of

In the 'nix world, there are several flavors devoted specifically to this issue. We have IIS (well, at least I'm not interested in running WWWC on Apache unless I have to).

I've seen threads here before on performance, and I got a lot of great info out of them. But I've never seen a thread on _absolute best_ latency performance (course I might have missed it). Again, I'm not talking general all-purpose "defrag your hard drive" type things. I'm talking what is the absolute lowest latency environment to get a data-based response from WC over the wire and is it possible to structure that response such that kernel caching will kick in.

Thoughts?

EDIT: I should add that I've been playing around with this in a test environment over local LAN, over the net to our own datacenter, and over the net to EC2 and without even any extreme tweaking I can get to 100-150ms ranges for non-cached hits, which makes the app a doable situation.

However, same HTML test page with URL set to hit my LAMP Nginx server with same data hit just server via PHP/mySQL hums along at 30-50ms.

Also, I've been looking into kernel caching and it doesn't support querystrings. Trying to keep things simple, rather than using a POST for my tests, I was using a GET like so:

example.com/update.ww?player=1001&time=12345678 (i.e. LTRIM(STR(SECONDS()*1000)))

however, given the querystring issue, couldn't you do this:

example.com/player1001/time12345678/update.ww

and get away with having kernel caching fire?

Re: File Access Denied when creating exe on Win7

Simon White — Sat, 20 Mar 2010 02:06:01 GMT

Re: File Access Denied when creating exe on Win7

Web Connection

Re: File Access Denied when creating exe on Win7

03/19/2010
07:06:01 PM
2W414XSNF

From:

To:

Attachments:

None

I think the problem is now fixed. I removed the "Everyone" group from the security permissions on the folder containing the project and compiling worked every time I tried even with the compatibility settings removed. I am not sure why everyone would cause the problem unless it is just a case of security permissions getting messed up.

So I will monitor it for a while and see if it is truly resolved.

Simon

I have a continual problem with compiling applications on Windows 7. All most every time I compile I get an error message saying the "File access is denied" for ".vbr" file. This did not happen under XP or Vista but it happens almost all the time in Windows 7. I run as Administrator but this does not help.

If I compile the second time without quitting VFP then I get a second message saying that the file is in use.

Has anyone else seen this problem or have an idea how to fix it?

Regards,
Simon

Re: File Access Denied when creating exe on Win7

Simon White — Sat, 20 Mar 2010 01:31:35 GMT

Re: File Access Denied when creating exe on Win7

Web Connection

Re: File Access Denied when creating exe on Win7

03/19/2010
06:31:35 PM
2W413PN69

From:

To:

Stein Goering

Attachments:

None

I am using VFP9 SP2 and have been for as long as it had been available. This is the only problem I have ever had with it on Windows 7.

Simon

What version of VFP are you using?

FWIW, I've been running VFP 9SP2 under 64-bit Windows 7 for a couple of months. I have never done anything with the compatibility mode setting.

I've had no problems building and compiling apps in this environment, so there's not an issue with Win 7 per se...

--stein

UAC is turned off and I have "Run As Administrator" set as well for all users.

I find that the first time I build the "exe" I get the error. I then quit VFP and then re-start VFP and build the "exe" again and most times it works. Ocassionally I have to restart VFP 3 or 4 times before it will build the "exe". I also have the compatiblity mode set to "Windows XP SP3" which helps a little since I was unable to produce the "exe" without the compatibility mode.

Simon

Simon,

Make sure you are in fact an administrator on Windows 7. If you're running with User Access Control *on* you are not an Administrator even if your user account is flagged as an account in the Administrators group. You have to use Run As Administrator or turn UAC off to run an app really as an Administrator.

+++ Rick ---

If I compile the second time without quitting VFP then I get a second message saying that the file is in use.

Has anyone else seen this problem or have an idea how to fix it?

Regards,
Simon

Re: File Access Denied when creating exe on Win7

Stein Goering — Fri, 19 Mar 2010 22:28:27 GMT

Re: File Access Denied when creating exe on Win7

Web Connection

Re: File Access Denied when creating exe on Win7

03/19/2010
03:28:27 PM
2W40X64CM

From:

Stein Goering

To:

Attachments:

None

What version of VFP are you using?

FWIW, I've been running VFP 9SP2 under 64-bit Windows 7 for a couple of months. I have never done anything with the compatibility mode setting.

I've had no problems building and compiling apps in this environment, so there's not an issue with Win 7 per se...

--stein

UAC is turned off and I have "Run As Administrator" set as well for all users.

Simon

Simon,

+++ Rick ---

If I compile the second time without quitting VFP then I get a second message saying that the file is in use.

Has anyone else seen this problem or have an idea how to fix it?

Regards,
Simon

Re: File Access Denied when creating exe on Win7

Simon White — Fri, 19 Mar 2010 21:22:52 GMT

Re: File Access Denied when creating exe on Win7

Web Connection

Re: File Access Denied when creating exe on Win7

03/19/2010
02:22:52 PM
2W40UTRM6

From:

To:

Attachments:

None

UAC is turned off and I have "Run As Administrator" set as well for all users.

Simon

Simon,

+++ Rick ---

If I compile the second time without quitting VFP then I get a second message saying that the file is in use.

Has anyone else seen this problem or have an idea how to fix it?

Regards,
Simon

Re: Blank prg

Rick Strahl — Fri, 19 Mar 2010 20:11:31 GMT

Re: Blank prg

Web Connection

Re: Blank prg

03/19/2010
01:11:31 PM
2W40SA0DM

From:

To:

Paul

Attachments:

None

There are lots of choices out there. Google Charts for example can be used to render graphs into pages externally.

Web Connection comes with a wrapper for Office Web Components which provides some basic graphing functionality. Look at wwWebGraphs.prg and the docs in the help file...

Other ActiveX controls for graphing also exist that you can use with Visual FoxPro - all of these will generate images that you can embed into a page as an external link.

+++ Rick ---

Thank for the reply. Can you suggest any way of implementing a dynamic chart without the use of images? What i was trying to do was use Microsoft chart controls. Do you know of anything similar?

I have used RMchart in some foxpro programs but i need to display a chart on a webpage and looks (unfortunately) are key so i think my client will want something more than an image of a graph.

Any help would be great.

Regards,
Paul.

P.S.
Your product is excellent and i am really enjoying learning how to use it.

Rick Strahl
West Wind Technologies

Where do you want to surf today?

from Maui, Hawaii

Re: WC Documentation

Rick Strahl — Fri, 19 Mar 2010 20:11:31 GMT

Re: WC Documentation

Web Connection 5.0

Re: WC Documentation

03/19/2010
01:11:31 PM
2W40SA0DT

From:

To:

Matt Slay

Attachments:

None

What are the arrangements for your WC sessions/training at SWFox 2010?

A vendor session, or a pre- or post- conference session?

There will be a Web Connection training workshop prior to the main conference (assuming I can get space at the hotel)...

I'll post details here as soon as I get them.

+++ Rick ---

I did not know you were going to be there. But, I'm glad to hear it.

Details please...

As you are using your, btw great tool, West Wind HTML Help Builder, could you please create a word or PDF format of the wc documentation so we can carry it in a Kindle?

PD. Are you doing a new work shop abot WC at SouthWest Fox this year?

Yes I'm planning to do training this year at Southwest Fox.

+++ Rick ---

Rick Strahl
West Wind Technologies

Where do you want to surf today?

from Maui, Hawaii

Re: File Access Denied when creating exe on Win7

Rick Strahl — Fri, 19 Mar 2010 20:11:31 GMT

Re: File Access Denied when creating exe on Win7

Web Connection

Re: File Access Denied when creating exe on Win7

03/19/2010
01:11:31 PM
2W40SA0E0

From:

To:

Attachments:

None

Simon,

+++ Rick ---

If I compile the second time without quitting VFP then I get a second message saying that the file is in use.

Has anyone else seen this problem or have an idea how to fix it?

Regards,
Simon

Rick Strahl
West Wind Technologies

Where do you want to surf today?

from Maui, Hawaii

Re: Trap SQL conn problems

Rick Strahl — Fri, 19 Mar 2010 20:11:31 GMT

Re: Trap SQL conn problems

Web Connection 5.0

Re: Trap SQL conn problems

03/19/2010
01:11:31 PM
2W40SA0E7

From:

To:

Jerry Tovar

Attachments:

None

Try using just the Connect method with the ConnectionString set to the DSN name... that should do the trick. ConnectByDsn has been deprecated and doesn't handle all the connection setup options that Connect supports when the connection is established.

Basically there is:

SQLSetProp(0, 'DispWarnings', .F.)

that causes warnings to fail as errors rather than pop up dialogs. These settings (there are several of them) are global SQL settings on the envrionment.

+++ Rick ---

I am using the below in my app to query a SQL Server table. Sometimes while running the example below, a dialog will appear with my SQL Server UID and PW in the dialog waiting to someone to press 'Ok'. The app is hung until someone response to the dialog.

What causes the dialog to appear? Is there a way to trap for it? Whats the recommended way of handling this?

o = CREATEOBJECT([wwsql])
ll_isconnected = o.ConnectByDsn('Mydsn', 'myuid', 'mypw')
ln_sqlresult = o.Execute(tc_sql)

Thanks,

Jerry

Rick Strahl
West Wind Technologies

Where do you want to surf today?

from Maui, Hawaii

Trap SQL conn problems

Jerry Tovar — Fri, 19 Mar 2010 20:00:40 GMT

Trap SQL conn problems

Web Connection 5.0

Trap SQL conn problems

03/19/2010
01:00:40 PM
2W40RW1RE

From:

Jerry Tovar

To:

All

Attachments:

None

What causes the dialog to appear? Is there a way to trap for it? Whats the recommended way of handling this?

o = CREATEOBJECT([wwsql])
ll_isconnected = o.ConnectByDsn('Mydsn', 'myuid', 'mypw')
ln_sqlresult = o.Execute(tc_sql)

Thanks,

Jerry

Re: File Access Denied when creating exe on Win7

Simon White — Fri, 19 Mar 2010 18:05:26 GMT

Re: File Access Denied when creating exe on Win7

Web Connection

Re: File Access Denied when creating exe on Win7

03/19/2010
11:05:26 AM
2W40NRUMS

From:

To:

Attachments:

None

I made a mistake in the previous post when reporting the messages.

The first message is "File is not open" then if I created the "exe" without quitting VFP I get the "File access denied" error.

I also tried switching the compatibility to "Windows XP SP3" and I was able to create the "exe" file once but then it reverted to giving me the same error message.

Simon

If I compile the second time without quitting VFP then I get a second message saying that the file is in use.

Has anyone else seen this problem or have an idea how to fix it?

Regards,
Simon

The name xxxx Does Not Exist in the Current Context

Chuck Bradley — Fri, 19 Mar 2010 16:28:34 GMT

The name xxxx Does Not Exist in the Current Context

ASP.NET

The name xxxx Does Not Exist in the Current Context

03/19/2010
09:28:34 AM
2W40JTC7C

From:

Chuck Bradley

To:

All

Attachments:

None

I recently encountered the problem of an undeserved error in code-behind which does not allow a successful build. When you pull a list item type, say a DropDownList, from the toolbar into the markup, give it an ID and then try to reference it in code-behind, you get an error message: "The name nnnnnn does not exist in the current context".

This problem has presented itself thru several versions of Visual Studio. When it happened again I got on the message boards to see what others are doing about it. There atre several threads about this and very litle mention about it on any MS boards or forums. MS hasnt owned up to this one yet (as far as I can find...).

If you remove the code-behind references so you can run debug and look at the Locals window the DropDownList will show up under the tree item "this". However, the solution has lost all visibilty to it in code-behind.

Oh, and no matter how many successful builds I did, the error always came back. I tried building with the control in the markup and without references in the code behind, deleting it all and rebuilding, cleaning out the solution of backups, double-referenced classes, etc. All kinds of scenario's ad nauseum.

So it leads you to a workaround which is to use FindControl to get a reference to it and cast it to a local protected variable of that same type. However, you must use the id name found in the control tree and not the ID you used in the markup. Keep in mind that DropDownList1 becomes ctl00$Main$DropDownList1 at runtime. (or something like it depending upon master pages, etc....)

To get the runtime ID, set the markup directive Trace="true" to get the control tree output at the bottom of the page in question. Copy and paste the id into the FindControl argument and you have it. The trace output will look something like this:

ctl00$Main$ctl02 System.Web.UI.ResourceBasedLiteralControl 323 0 0
ctl00$Main$DropDownList1 System.Web.UI.WebControls.DropDownList 436 216 0
ctl00$Main$ctl03 System.Web.UI.LiteralControl 152 0 0
ctl00$Main$lblcourtHouseName System.Web.UI.WebControls.Label 188 0

Depending upon your comfort level with which control it is going to find, you may want to do a little checking on it first before using the casted control, so check the type and do your due-diligence.

Here's the code:

public partial class Default_aspx  : System.Web.UI.Page
{ 
    protected DropDownList myDropDownListFix;
  
    protected void Page_Load( object sender, EventArgs e )
    {
        //  get a reference to the desired control
        Control myControl = FindControl("ctl00$Main$DropDownList1");
 
        //  make sure you have the right type       
        if (myControl.GetType() == typeof(System.Web.UI.WebControls.DropDownList))
        {
            // now safe to cast it to the one you want and work with it
            myDropDownListFix = (DropDownList)FindControl("ctl00$Main$DropDownList1");
            myDropDownListFix.Items.Add("Me");
            myDropDownListFix.Items.Add("You");
            myDropDownListFix.Items.Add("Calib");
            myDropDownListFix.Items.Add("The Horses");
        }
    }
}
.
.
.
.

I'm sure there are more elegant ways to do this, but it is a *workaround*.
BTW, after I did the manual fix, it all started working again. So, I'm not sure whether to take the workaround out or not. Not real dependable there MS.....VS200x gotta love it. Definitely a love-hate relationship.

I know this doesnt address any event handler problems you may have when you do not have visibility to the control. If I wind up in visibilty purgatory again, I will post the fix here, friends.
But for now it started working. Not LOL.

Cheers,
Chuck.

Re: Wish I could stop using 'File' mode!!

Brandon Harker — Fri, 19 Mar 2010 16:20:51 GMT

Re: Wish I could stop using 'File' mode!!

Web Connection

Re: Wish I could stop using 'File' mode!!

03/19/2010
09:20:51 AM
2W30LQ2HT

From:

Brandon Harker

To:

Marty Glynn

Attachments:

None

I need to create PDF files. When I invoke "Report Form to &xerox.printer",I get a "co create" error unless I'm in file mode. I'm thinking of writing a separate app using wwAsyncWebRequest to handle printing. Anybody got a better idea?

I use this technique:
I don't like maintaining separate .exe's on the server for these type issues, so instead, in my applications startup program, I have:

LPARAMETERS lnAppMode
lnAppMode=VAL(TRANSFORM(lnAppMode))

and then I conditionally do different things based on the value of lnAppMode. In this way, I'm not maintaining different .exe's but I can extend functionality for async processes.

Now just call your own exe like this:
lcFile='c:\mypath\mypath.exe'
lcParms='1'

! /N &lcFile &lcParms

File Access Denied when creating exe on Win7

Simon White — Fri, 19 Mar 2010 15:30:25 GMT

File Access Denied when creating exe on Win7

Web Connection

File Access Denied when creating exe on Win7

03/19/2010
08:30:25 AM
2W40I8I0V

From:

To:

All

Attachments:

None

If I compile the second time without quitting VFP then I get a second message saying that the file is in use.

Has anyone else seen this problem or have an idea how to fix it?

Regards,
Simon

Re: Installing VFP Ole Db Driver on Windows 2008

Dmitry Litvak — Fri, 19 Mar 2010 12:40:26 GMT

Re: Installing VFP Ole Db Driver on Windows 2008

ASP.NET

Re: Installing VFP Ole Db Driver on Windows 2008

03/19/2010
05:40:26 AM
2W40C5VHK

From:

Dmitry Litvak

To:

Guy Pardoe

Attachments:

None

Hi Guy,

Thank you very much for your message. Yes, this is 64 bit Windows. I will test this app on a Windows 7 I have, also 64 bit Windows, to see if the Ole Db driver works there. And I will Google for other possible solutions.

Hi Dmitry,

Is it 64 bit Windows? If so, you could be in for some complications. As I understand it, 64 bit applications won't talk to the 32 bit driver. However, 32 bit applications running on 64 bit Windows can work. You can google it and find some additional discussion.

Guy

In the past I have installed VFP 9 Ole Db driver on Windows 2003 many times and never had a problem.

Now when I installed it on Windows 2008 I have a problem. When I run a test ASP.NET page that attempts to open a VFP database (test one that I always use), I get error message:

InvalidOperationException: The 'VFPOLEDB.1' provider is not registered on the local machine.

This type of message in the past meant that the drive was not installed. But when I go to the Programs and Features window in Windows 2008 I see that VFP Ole DB driver is listed there.

Is there an extra step that I need to do on Windows 2008 when installing Ole Db Driver?

Thank you in advance for any suggestions.

Re: Installing VFP Ole Db Driver on Windows 2008

Guy Pardoe — Fri, 19 Mar 2010 11:46:37 GMT

Re: Installing VFP Ole Db Driver on Windows 2008

ASP.NET

Re: Installing VFP Ole Db Driver on Windows 2008

03/19/2010
04:46:37 AM
2W40A8NTA

From:

Guy Pardoe

To:

Dmitry Litvak

Attachments:

None

Hi Dmitry,

Guy

In the past I have installed VFP 9 Ole Db driver on Windows 2003 many times and never had a problem.

Now when I installed it on Windows 2008 I have a problem. When I run a test ASP.NET page that attempts to open a VFP database (test one that I always use), I get error message:

InvalidOperationException: The 'VFPOLEDB.1' provider is not registered on the local machine.

This type of message in the past meant that the drive was not installed. But when I go to the Programs and Features window in Windows 2008 I see that VFP Ole DB driver is listed there.

Is there an extra step that I need to do on Windows 2008 when installing Ole Db Driver?

Thank you in advance for any suggestions.

Re: WC Documentation

Matt Slay — Fri, 19 Mar 2010 11:23:10 GMT

Re: WC Documentation

Web Connection 5.0

Re: WC Documentation

03/19/2010
04:23:10 AM
2W409EIKN

From:

Matt Slay

To: