Coders - Help before I throw another laptop out of the widow....

[EddyTheDog]

I am trying to send a REST url like this - It looks odd as its for YQL..

http://query.yahooapis.com/v1/public/yql?q=insert into wordpress.post (title, description, blogurl, username, password) values ("Test damian", "<a href="http//:www.xxx.net">Damian</a>", "http://xxxxxxx.co.uk", "kjhjkhjkh", "kjhkjhjkhj")&format=json&diagnostics=true&env=store://datatables.org/alltableswithkeys&callback=cbfunc

Its obviously sent encoded - The above is for clarity

http://query.yahooapis.com/v1/public/yql?q=insert%20into%20wordpress.post%20(title%2C%20description%2C%20blogurl%2C%20username%2C%20password)%20values%20(%22Test%20damian%22%2C%20%22%3Ca%20href%3D%22http%2F%2F%3Awww.xxx.net%22%3EDamian%3C%2Fa%3E%22%2C%20%22http%3A%2F%2Fxxxxxxx.co.uk%22%2C%20%22kjhjkhjkh%22%2C%20%22kjhkjhjkhj%22)&format=json&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=cbfunc

I can see what the problem is - I have highlighted the little fuckers in red in the code - I have tried escaping them and that works but then the backslash appears in the HTML for the post and that is obviously no good.....

This all new to me and I just can not see a way around it - the documentation is sparse at best...

Any ideas?

[EddyTheDog]

Worked it out.......

2 Hours of my life I will never get back.

[lucas131]

ok then ...

[V_RocKs]

Tee hee!

[Fletch XXX]

Originally Posted by EddyTheDog

Worked it out.......

2 Hours of my life I will never get back.

ive found though, when something like this gets in your way you end up learning something and it will never happen again.

[Fap]

What'd you learrrn?

[Why]

dont put double quotes inside your double quotes. ;)

[EddyTheDog]

Originally Posted by Why

dont put double quotes inside your double quotes. ;)

I knew that - I couldn't work out how to use html without double quotes or escaping them....

It turns out that you can use single quotes on the outside in the YQL and then you can escape the single quotes in the html itself.

It is true I did learn a lot fucking around with that stuff all afternoon....

[mikke]

query.yahooapis.com/v1/public/yql?q=insert into wordpress.post (title, description, blogurl, username, password) values ('Test damian', '<a href="http//:www.xxx.net">Damian</a>', 'http://xxxxxxx.co.uk', 'kjhjkhjkh', 'kjhkjhjkhj')&format=json&diagnostics=true&env=sto re://datatables.org/alltableswithkeys&callback=cbfunc

returned

cbfunc({"query":{"count":0,"created":"2012-02-22T18:15:59Z","lang":"en-US","diagnostics":{"publiclyCallable":"true","url" :[{"execution-start-time":"19","execution-stop-time":"420","execution-time":"401","proxy":"DEFAULT","content":"http://www.datatables.org/wordpress/wordpress.post.xml"},{"execution-start-time":"431","execution-stop-time":"492","execution-time":"61","proxy":"DEFAULT","content":"http://xxxxxxx.co.uk/xmlrpc.php"}],"javascript":["Exception: TypeError: Cannot read property \"param\" from undefined (<javascript>#163)",{"execution-time":"67","instructions-used":"42067","table-name":"wordpress.post"}],"user-time":"493","service-time":"462","build-version":"25358"},"results":null}});

looks like it's working?

[EddyTheDog]

Originally Posted by mikke

returned


looks like it's working?

Yeah - No problems now I am using the single quotes...

Just have to make sure any single quotes in the html are escaped...

[martinsc]

it's funny how a little thing can keep you busy and cursing for hours....

[redwhiteandblue]

Originally Posted by Fletch XXX

ive found though, when something like this gets in your way you end up learning something and it will never happen again.

Until you run it on another server and it fucks up all over again in a different way.

[EddyTheDog]

Originally Posted by redwhiteandblue

Until you run it on another server and it fucks up all over again in a different way.

lol - I am running this on a local machine and will have to migrate it - I am not looking forward to that!!

[FlexxAeon]

Originally Posted by martinsc

it's funny how a little thing can keep you busy and cursing for hours....

my little mantra is "99% of the time it's something small and stupid!'