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.
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 ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.