I've got a small problem that I can't seem to figure out.

Anytime I want to display the {Total_Records} for any one of my Recordsets, it displays -1. I've used both the Dreamweaver shortcut and ASP coding.

Anyone have any ideas? <img src=../images/dmxzone/forum/icon_smile_question.gif border=0 align=middle>

that is very strange, though you could hand code it
SELECT stuff, more stuff, COUNT(*) AS total_records
FROM tables
WHERE x=y

Sharing knowledge saves valuable time!

Simon

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>

Sharing knowledge saves valuable time!

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Boy and does it! <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Thanks for the info. I'm still a newbie when it comes to SQL. I outta buy a book or something...oh well.

Glad that helped <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Don't know why DMX was reporting -1 for total_records - it would be good to find out.
Is it all recordsets, or all recordsets in a given project?
Could you set up a test to see if its dmx throwing an error?

Sharing knowledge saves valuable time!

Simon

Honestly, I'm quite clueless about the problems I've been facing with the Recordsets.
I've been teaching myself dynamic content for the last 3 months or so and I've run into many random issues; almost all of which I've been able to figure out. This one is beyond me...

I think it might tie into another issue I've been facing. I have not been able to use most Dreamweaver apps. because the program refuses to recognize my Recordsets. It will ask me to create a Recordset for the application I want to use but when I do so it asks me to create another one. I've tried new documents and differing document locations but to no avail.

You don't happen to know if these problems are tied to MS Access, do you? I have yet to hear a positive word about that program, yet, it's the only one I have thus far.

I've not heard of any issues like that caused by Access. Maybe dmx needs a re-install - its amazing what that can do for productivity!

There isnt anything 'wrong' with access, its cheap and easy and it does the trick. Yeah ok it doesnt have the power of SQL server or Oracle - but you dont need a ferrari to drive to the shops

Sharing knowledge saves valuable time!

Simon