Recent content by SadeJade

hello martynj, I'm using a ODBC connection, I believe my problem is the correct use of recordset's, I type in the VBScript myRecord.RecordCount and doesn't work, so I try out myRecord.Count still doesn't work!! Can you give me a tip? J.

That's a good ideia... no I have to see how to do that!! Thanks a lot, if you can help a bit more please do to sade_jade@hotmail.com ok? J. :-)

Hi I have an ASP file that I use to call viewer that put's together the XMl files and the XSL files and I need to put the result of a search SQL query made in XML like 10 for page, I need to do the results paging, do you know how to do that? J. :-)

Hi shouldn't be something like: AdminPriv = 10 Set p = CreateObject("Scripting.Dictionary") p.Add "Variable_used_in_xsl", cstr(AdminPriv) I'm not sure, maybe I'm talking about XML not XSL but, you can always try it!! Good luck J.

Hello, I made a XML file that brings the results of a key search from SQL 2000 to XSL for display but I need to break those results in pages of ten !! How can I do that? I should do that in the XSl or in the XML or at the SQL query? And how to do it in the appropriated language?? Thanks...

You can use vbScript to solve that problem, you make a variable that contains a string with the sql query and then execute it to a recordset... something like Vsql="select field_name from table_name where condition" Set db_rs = db_conn.execute(Vsql) you must create the connection to...

I sugest that you use the combination od both, I believe the results and the manipulation will be easier. SQL for database and XML to manipulate data, as datastructure, have allready think about the display? XSL ?