RecordCount/Rows Affected ADODB and Javascript

Shaun.McGuile · #1 (**permalink**) 08-13-07, 10:53

Hey here's a good one -

I'm trying without success to get the recordcount property of an adodb recordset object populated by using the adodb.connection execute method in javascript.

The <insert rude words here> always reports either -1 or 0 depending on how I try to get at it. However I know I have six records returned into the recordset object as I can traverse the set using the moveNext() method.

Here is my code

Code:

//DataConn is a legit data source that works (SQLServer) as I can see the data.
SQL = "Exec sp_GetAccountRate @IdString = \"918|808|1214|89|995|300|\""
	
AccountsData.Data = DataConn.Execute(SQL,rows,1);
Response.Write("No Of Records = " + AccountsData.Data.recordCount);// = 'No Of Records = -1'
Response.Write("No Of Records = " + rows ); //No Of Records = 0

Why does this not work?

When I run the stored proc in SQL analyzer I get the expected data and a rows affected count of 6, @@ROWCOUNT also reports 6.

regards

Shaun McGuile

gvee · #2 (**permalink**) 08-13-07, 11:03

This might be well worth a read

gvee · #3 (**permalink**) 08-13-07, 11:05

Also, what cursor type are you using here? If I remember rightly, you can only use RecordCount using certain cursors.

Shaun.McGuile · #4 (**permalink**) 08-13-07, 11:12

Yeah, issue is how do I open a recordset in javascript?

I can use command or connection execute() ok, but that just gives me a forward only cursor.

I take it then, record count won't work using this method?

Also the <more rude words> won't allow me to do a while loop checking for not EOF.

So I can't even count up as I do moveNext().

Damn why can't it just work like VBScript?

Cheers GeorgeV.

Is your girlfriend nay fiancee better these days, last I read she was ill in where was it south america?

Shaun.McGuile · #5 (**permalink**) 08-13-07, 11:17

By GeorgeV you've cracked it for me I had not realised I could do next record set method on the object. My stored proc has the Select @@ROWCOUNT as [Rows] in it.

Just gotta test it works.

Cheers.

Shaun.McGuile · #6 (**permalink**) 08-13-07, 11:22

Well <hugely relieved rude words> it works.

I can now use a for loop.

Dynamic web pages without VBScript here we go.

;-)

Regards

Shaun McGuile

'Every answer possible is there on the web, you just have to ask the precise question to get the precise answer".

gvee · #7 (**permalink**) 08-13-07, 11:24

Quote:

Originally Posted by Shaun.McGuile

Is your girlfriend nay fiancee better these days, last I read she was ill in where was it south america?

Very observant of you! She's doing much better now thank you

All the tests for nasties have finally come back and they're all negative *jumps for joy*.

She was back for a couple of weeks before she swanned off to Italy to climb mountains... She's back tomorrow though

Thanks for asking - and I hope you can get this to work!