Web Connection
Request.form erroring out / cannot load wwIPStuff.dll
Gravatar is a globally recognized avatar based on your email address. Request.form erroring out / cannot load wwIPStuff.dll
  Scott R
  All
  Mar 29, 2019 @ 08:50am

Rick,

Have a weird one for you. I have the following form variable passed in (not sure if it matters but this particular web service is called from our desktop code and the variable is passed in using wwHttp.addPostKey()) and I can see it fine in request.cFormVars:

&sqlQuery=SET%20DATEFORMAT%20mdy%20%09%09%09SELECT%20uds.%2A%0D%0A%09%09%09%09from%20uds%0D%0A%09%09%09%09where%20%20(%20%20uds.id%20%3D%20%27SCHEDSV2%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDSVW2%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27NOERNDJOBMSG%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDUWOO%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDUWOW%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHDSPLIT%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLORCALLB4GO%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLORCONFIRM%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLORSTARTED%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLORARRIVED%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLORDEPARTED%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLORCOMPLETED%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLORFTRETURNED%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLORNEEDREV%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLORPARTASSIGN%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLORAVAILABLE%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLOROFF%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLORMEETING%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLORSICK%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDCOLORVACATION%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDSVT%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDSVO%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHED%27%20and%20%20uds.userid%20%3D%20%27REFRESHRAT%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDTCHSR%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDWRKGP%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDWRKAV%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDUNHRS%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27showaddtl%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDUNSGN%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHDBRANCH%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27RECURSCHED%27%20and%20%20uds.userid%20%3D%20%27SHOWEARLY%27%20)%0D%0A%20OR%20%20(%20%20uds.id%20%3D%20%27SCHEDPAGE%27%20and%20%20uds.userid%20%3D%20%270000000007%27%20)

When I call

TRY 
   m.retval = request.form('sqlQuery')
CATCH TO oError
   *SET STEP ON
   m.retval = ''
ENDTRY 

It errors out saying

Cannot load 32-bit DLL c:\source\cenpoint\webconnect\deploy\wwipstuff.dll.

I've verified the file is really there and is not blocked. What I really don't understand is the fact that this is NOT the largest form variable I've used / extracted before but for some reason this one consistently errors out.

Any thoughts?

Thanks,

Scott

Gravatar is a globally recognized avatar based on your email address. re: Request.form erroring out / cannot load wwIPStuff.dll
  Scott R
  Scott R
  Mar 29, 2019 @ 10:14am

Rick,

False alarm. I restarted VFP and it started working again. Not sure what was going on but all is good.

Thanks,

Scott

Gravatar is a globally recognized avatar based on your email address. re: Request.form erroring out / cannot load wwIPStuff.dll
  Rick Strahl
  Scott R
  Mar 29, 2019 @ 04:30pm

That sounds like you're maybe losing your path.

Make sure that your startup folder is explicitly in your FoxPro path of the application, or better yet make sure your appication doesn't accidentally change path. Most common reason for this to happen is an Open File/Folder dialog as those things tend to move the path to whatever you pick.

+++ Rick ---

© 1996-2019