Hi all,

I'm new to AJAX.


If I do a ajax posting to an asp page that will returns some values from db. And I build a variable "myVar" and do as follows.

to pass the results back to ajax, then

But I'm getting nothing in my ajax responseText.

I'm confusing why I'm getting this?

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!

That makes two of us! But then I'm also new to AJAX and still just playing with it . If you figure it out, post here!

I think your DB code is in error, or your query returns nothing.

Try this ,

__________________
cheers
Aman

Thanks for the reply.

Actually, I've independently verified that each piece is working. I've narrowed it down to the query string I create that calls the stored Proc on the server. Strangely, both return the same record, but ajax accepts only one:

rsGetDatabasesQ2 = "exec spGetMostCurrentDatabaseStats '" & xServerName & "', '" & xDBName & "'"
^^^ this one I build the string dynam - doesn't work with ajax, but does return the correct recordset.

rsGetDatabasesQ2 = "exec spGetMostCurrentDatabaseStats 'wavedev\wavedev', 'css'"
^^^ this one I explicitly pass the params in - does work with ajax, and returns the correct recordset.

Hmm...I'm stumped.

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!

I've further narrowed it down to the xServerName var in the query string. If I replace it with the value directly, it works. I know the var itself is correct because the process does return valid records form the database when its used.
Ajax sure seems picky about things?

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!

There are no "variables" in the query string. There are name/value pairs.

Does the query string have an ampersand in it?


?something=th&is

The "is" will be treated as the second name in the second name/value pair, as if the query sting were like this:

?something=th&anything=is

Try it this way,

?something=th&is

__________________
cheers
Aman

Hi aman!

Any way thnx for your kind reply. I will go thru this way.

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!