Net::HTML#post_form with ASP

ruby-talk
1

Hello,

I've been trying to use Net::HTML.post_form to POST to a .asp file.

  url = URI.parse("http://www.ascca.com/findashop/findashopdetail.asp")
  res = Poster.post_form(url, { "id" => '1' } )
  puts res.body

This does not work with ASP pages but works fine with other pages.

Here's the error i get:

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression '[ID]='.

I believe it has something to do with it being urlencoded, but i'm not
exactly sure.

Any ideas?

Thanks,

Ricardo Amorim

2

Just a note: The Poster class is a Net::HTTP subclass. I was using it
to test the code. You could just use Net::HTTP instead.

Regards,

Ricardo

···

On 3/14/06, |MKSM| <mksm.sama@gmail.com> wrote:

Hello,

I've been trying to use Net::HTML.post_form to POST to a .asp file.

        url = URI.parse("http://www.ascca.com/findashop/findashopdetail.asp&quot;\)
        res = Poster.post_form(url, { "id" => '1' } )
        puts res.body

This does not work with ASP pages but works fine with other pages.

Here's the error i get:

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression '[ID]='.

I believe it has something to do with it being urlencoded, but i'm not
exactly sure.

Any ideas?

Thanks,

Ricardo Amorim

3

I think you are running into this:

http://ruby-talk.org/cgi-bin/scat.rb/ruby/ruby-talk/182324

I suspect the fix in that thread will get you going again.

Hope that helps.

James Edward Gray II

···

On Mar 14, 2006, at 1:09 PM, |MKSM| wrote:

Hello,

I've been trying to use Net::HTML.post_form to POST to a .asp file.

  url = URI.parse("http://www.ascca.com/findashop/findashopdetail.asp&quot;\)
  res = Poster.post_form(url, { "id" => '1' } )
  puts res.body

This does not work with ASP pages but works fine with other pages.

Here's the error i get:

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression '[ID]='.

I believe it has something to do with it being urlencoded, but i'm not
exactly sure.

Any ideas?

4

The problem is that the receiving end seems to be expecting id in the
query string: request.querystring("id") for GET vs. request.form("id")
for POST in ASP.

HTH

C

···

On 3/14/06, |MKSM| <mksm.sama@gmail.com> wrote:

Hello,

I've been trying to use Net::HTML.post_form to POST to a .asp file.

        url = URI.parse("http://www.ascca.com/findashop/findashopdetail.asp&quot;\)
        res = Poster.post_form(url, { "id" => '1' } )
        puts res.body

This does not work with ASP pages but works fine with other pages.

Here's the error i get:

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression '[ID]='.

5

Hello,

The fix did not work.I still get the same error. There is some bug here.

I've tested an app i coded last month and it still works:

url = URI.parse("http://translate.google.com/translate_t&quot;\)
g_res = Net::HTTP::post_form(url, { 'text' => "#{string}", 'langpair'
=> "#{from_lang}|#{to_lang}" } )
p g_res.body

Perhaps it has something to do with the file type you POST to? (php/cfm/asp)

Regards,

Ricardo

···

On 3/14/06, James Edward Gray II <james@grayproductions.net> wrote:

On Mar 14, 2006, at 1:09 PM, |MKSM| wrote:

> Hello,
>
> I've been trying to use Net::HTML.post_form to POST to a .asp file.
>
> url = URI.parse("http://www.ascca.com/findashop/findashopdetail.asp&quot;\)
> res = Poster.post_form(url, { "id" => '1' } )
> puts res.body
>
> This does not work with ASP pages but works fine with other pages.
>
> Here's the error i get:
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
> operator) in query expression '[ID]='.
>
> I believe it has something to do with it being urlencoded, but i'm not
> exactly sure.
>
> Any ideas?

I think you are running into this:

http://ruby-talk.org/cgi-bin/scat.rb/ruby/ruby-talk/182324

I suspect the fix in that thread will get you going again.

Hope that helps.

James Edward Gray II