Forum: Ruby Net::HTML#post_form with ASP

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
7d77e3e44327ffd20c0d19fa0fe15cab?d=identicon&s=25 |MKSM| (Guest)
on 2006-03-14 20:11
(Received via mailing list)
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
7d77e3e44327ffd20c0d19fa0fe15cab?d=identicon&s=25 |MKSM| (Guest)
on 2006-03-14 20:14
(Received via mailing list)
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
4299e35bacef054df40583da2d51edea?d=identicon&s=25 James Gray (bbazzarrakk)
on 2006-03-14 21:47
(Received via mailing list)
On Mar 14, 2006, at 1:09 PM, |MKSM| wrote:

> 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
7d77e3e44327ffd20c0d19fa0fe15cab?d=identicon&s=25 |MKSM| (Guest)
on 2006-03-14 22:16
(Received via mailing list)
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")
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
3b803506ca7d7b5796bc16ee5b9f11d3?d=identicon&s=25 carlos tirado (Guest)
on 2006-03-15 02:15
(Received via mailing list)
On 3/14/06, |MKSM| <mksm.sama@gmail.com> wrote:
> Here's the error i get:
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
> operator) in query expression '[ID]='.


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
This topic is locked and can not be replied to.