Recent content by kevink

Can I anyone point me in the right direction for creating namespaces? I'm using msxml3.dll - and want to embed a script into the XSLT stylesheet. The SDK says to use <msxsl:script> for this - but you need to create your own namespace for this ... which begs the question, how do I create a...

Has anyone seen this error before when trying to use CreateRecordset? CreateRecordset error '80004002' No such interface supported It runs fine on WinNT 4.0 SP6a, but gives the above error on Win2K, SP2. It the last part of an index server search. Thanks Kevin

I'm trying to write a COM object that will return the results from an index server search. The search works fine from ASP, but when I put it into the COM object, I get a &quot;Type Mismatch&quot; error. -------------- Public Function myData (ByRef varData As Variant) As Variant Redim...

Thanks John, That was one of my errors - I've got a few simple COM objects working with arrays now. I still have a problem with my main one - that of using Index Server within a COM object. Using Index Server from the ASP page works fine - put the function into a COM component and I'm back...

I have a component which opens a db connection and returns the recordset as an array.  When the function is in the ASP page directly, everything works fine,  however when the function is compiled as COM object, I get a &quot;Type mistmatch&quot; error when I try and assign the results to an...

Hi Sarah, If I follow the question correctly, you can just join the strings together: E.g. myDate = request.form(&quot;day&quot;) & &quot;/&quot; & request.form(&quot;month&quot;) & &quot;/&quot; request.form(&quot;year&quot;) Just don't forget that VBSCript and Access generally stores the...

Try enclosing the option value in single quotes i.e. response.write &quot;<option value='&quot; & rs(0) & &quot;'>&quot; & rs(0) & &quot;</option>&quot; If that doesn't work, then try using server.URLEncode to encode the option value: response.write &quot;<option value='&quot; &...

Can anyone recommend a good book for ADO and VB6 please? Anything in the intermediate/advanced category would be great. I've read &quot;Beginning Visual Basic 6 Database Programming ~ John Connell&quot;, but that only contains a few chapters on ADO and I would like some more information. TIA...

Definitely need to see some code, but your code should look like this: 'open recordset - objRS Do until objRS.EOF ''Loop until the end of recordset 'Do your stuff objRS.movenext 'move to the next record Loop HTH, Kevin

When I press CTRL + F12 under Win Me. it opens up Netscape Navigator. Is there any way I can change or disable this? TIA Kevin

Does anyone know what is the maximum number of records that Access 2000 can handle in a single table? Or where I can find the information? I've searched the Microsoft MSDN site to no avail. TIA, Kevin

I would like to write a COM object that would dial up (via a modem) to my server at a set time every day and download a database (using VB6 on Win 98/NT/2000). Can anyone give me pointers on how to do this? Or even any books which would help? I've written COM object before - its just the...

Is there any way to capture a shutdown event in Win 98? I want to log when the computer is started/shutdown. TIA Kevin

In my opinion there is no real difference between PHP and ASP - depends which platform you want to develop for. PHP is cheaper and easier to learn if you come from a C background, ASP can be written in JScript or VBScript (easy if you come from a VB background). Incidentally, Jscript seems to...

Have you tried Response.Write Request.Form(&quot;qty&quot; &amp; j) HTH