Web Gadget - Page Errors with one Site

[jacfrosty]

Hello,

I have a problem with the web gadget, I haven't come across any problems with the web gadget except for this one site, it appears to do some kind of database lookup (using asp I think??) and the page fails and their webserver reports back this error page:

• 
  Page: GET /tc/tc_courselistsfind.asp (www.xyz-training.com)
  
  Error Type: (0x80040E14)
  Incorrect syntax near the keyword 'GROUP'.
  /common/scripts/rec_func.asp, line 29
  
  Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
  
  Error Occured: 08 June 2006, 12:30:37
  Payload:

And I can't carry on entering the details I am supposed to.

Has anyone else come across this error before, I can't seem to find this specific problem elsewhere because it doesn't happen when you use any other Browser - just the Web Gadget from within a PB app.

I hope someone can help as I am really stuck..

Kind regards

jacfrosty.

[Dare]

Hi jacfrosty,

As you say, their script is crashing. Not sure how that could be the webgadget. I didn't think PureBasic had much to do with that end, but just in case have you tried with unicode on/off?

Also, you are not using the #PB_Web_Mozilla flag are you?

BTW, Just to be sure we have it right:

You navigate to the page (using the webgadget), fill in some info, and click the submit button. And get back that page info. Using IE, Opera, Mozilla, etc (which ones?) to visit the site no problem with the same info?

Do you have a link or is it private. Also, can you set up a simple asp script on some server somewhere (localhost would be good) and see what gets sent?

[jacfrosty]

Thanks for the reply Dare,

Your right, I thought the WebGadget had all the functionallity of a 'real' IE, but it seems not.

I am not sure what you mean about turning unicode off, maybe you could explain this one to me.

It makes no difference with/without the #PB_Web_Mozilla flag set, although I haven't managed to get the Mozilla Plugin working at all - every time I get the IE window appear. Maybe the Mozilla plugin would do something different??

You navigate to the page (using the webgadget), fill in some info, and click the submit button. And get back that page info. Using IE, Opera, Mozilla, etc (which ones?) to visit the site no problem with the same info?

Yep, works fine with every other browser I have tried (Windows/Linux), although it is not actually a submit button as such, it is a hyperlink that brings up a window with a list of courses specific to your company. Then when you select the course you want is puts this back into the original form you are filling in (unfortunately you can't just enter the course, you have to go through this lookup window!!)

Do you have a link or is it private.

Sorry but it is a private site, you have a specific login for your company and it is for a customer of mine that I have written some software for. (I know this makes it awkward I applogise.)

Also, can you set up a simple asp script on some server somewhere (localhost would be good) and see what gets sent?

Really would not know where to start with this, I am not a web programmer... Also the application is on their server..

Hope this info helps, I really could do with getting to the bottom of this problem, because what I have written for this customer allows them to paste data from a database directly into the web page input boxes saving them a whole lot of keying / spelling mistakes.

ps. I have noticed that the window that opens (which should contain the course list, but contains the error message) if you keep that window open (which incidentally looks like a real IE window) and go to the homepage, log back in get to the state of selecting the course again, instead of popping up another window, the course list appears in that same window, as it should have done in the first instance, then if you select a course - the windows closes and pastes the course info back in the original form/page.

[Dare]

Hi jacfrosty,

Re the unicode - that was just clutching a straws. You can set "Create Unicode Executable" in compiler options, I was just wondering if that had been done and maybe sent characters that confused the script/database.

I have been scratching my head on this and can't think of what it can be (sorry).

Can you use a webgadget to, say, log onto these forums?

Can you viewsource their page and see what the form field names are (the input and textarea, etc, tags) and can you see the javascript they use (or is it a linked js file)?

I'm thinking if we can dummy up a page (without all the identifying info, just the form fields and the js that sends it) then we can catch the data submitted (via the webgadget) to an asp page of our own and see what we get (and therefore, hopefully, what they got).