Search results for query: *

Hi, I have used XMLSPY's facility to reverse engineer a DB2 database into an XML schema. However, I hit problems with DB2's timestamp columns. The data is extracted as: 2000-08-01 12:00:00.000000 However the schema expects: 2000-08-01T12:00:00.000000 The pattern is...

Hi, I have an XSLT script that converts to CSV (comma separated) so that I can load the data into a database. The problem I have is that the source XML contains embedded HTML tags encoded as escape sequences and I would like to retain these. An example would be: <para-text>Example...

Hi, Is there any way of storing an ISO/XML DateTime of format: CCYY-MM-DDThh:mm:ss In a DB2 TimeStamp column? Thanks, Stoggers.

Hi, I need to write some VBScript to validate and XML document against a schema. How do you do this using the XMLDOM object in MSXML? I am hoping to be able to exec the VBScript in a command window and take a couple of parameters - the XML and the schema. XMLDOM does have 'validate' methods...

Hi, If I have a trigger on TABLE_A that stores information in TABLE_B whenever an INSERT/DELETE or UPDATE takes place, what access, if any, is required to TABLE_B. What I would like is for the user to be able to directly update TABLE_A but only read from TABLE_B. Thanks, Mike.

Hi, How do you count the number of rows returned by the following statement: WITH TEMP1 (D) AS (VALUES DATE('01/01/2004') UNION ALL SELECT (D + 1 DAY) FROM TEMP1 WHERE (D + 1 DAY) < DATE('01/02/2004')) (SELECT D,DAYOFWEEK(D) FROM TEMP1) Thanks, Mike.

Hi, Anyone has experience of a JPEG 2000 plug-in for Internet Explorer. Recommendations appreciated. Thanks, Mike.

Hi, 'scuse my ignorance but we have an application that sits on an intranet behind a firewall. My question is: how do we configure it so that we can autodownload the player? Thanks, Mike.

Hi, Is it possible to pre-bind a package - ie bind a DBRM to a sub-system but not deploy the associated executable until a later date? If so, is the package locked during the bind process? Thanks, Mike.

Hi, Does anyone know of a good example of how to introduce zoom, pan, rotate, etc into a scene. Thanks, Mike.

Hi, I have a problem where I have an ASP site that uses 3rd-party DLL's to extract data from a database and format it as HTML. What I would like to do is replace the existing ASP script with my own and output the data as XML. How feasible is this? Rather than reverse engineering the DLL I...

Hi, Is there any way of avoiding rebinds of programs? In the following scenario: Program ABC has consistency token 123 and DBRM with consistency token 123 and runs fine against a particular schema where it has been bound as a package. Program ABC is amended but the SQL statements remain the...

Hi, I have a table similar to: REF NAME 1 Mike 2 John 3 John 4 Dave ...and I would like to count the number of duplicates using SQL similar to: SELECT * FROM (SELECT NAME,COUNT(*)AS C FROM TABLEA GROUP BY NAME) AS TEMP WHERE C > 1; The problem I now have is that I...

Hi, I have just bought a new PC with XP Pro and I would like to install Linux on the old PC and network the two. Does anyone of a simple description of the steps required to achieve this. Thanks, Stoggers.

Hi, I need a free applet that will display the number of days, hours, minutes etc to a specified event. Thanks, Mike.

Hi, Running IIS on XP Pro I have created a local site called //MIKE/site1. When I have an active internet connection I can access all the pages but as soon as I drop the line most attempts to access pages are refused. Any suggestions? - security, proxy, DNS???? Thanks, Stoggers.

Hi, I have an UNLOAD of a table taken under z/OS and I would like to reload this into the table but the table now has an additional column at the start of the PK. My question is: How do I change the SYSPUNCH cards to supply a default value that does not exist in the input UNLOAD. I cannot...

Hi, How do I use FIND in VBA? What I have is two columns, say A & B, and I would like to highlight (ie change the color of) cells in A if they exist in B. Would FIND be an appropriate way of doing this? Does anyone have any code-snippets that could do this? Any suggestions appreciated...

Hi, I use Response.Write with embedded <BR> tags to write out a formatted page that I want users to cut & paste into a document. However, I find that, although the text appears correctly on the screen (due to the <BR>'s) the cut text appears as a single stream of characters. How do I ensure...

Hi, Is there a download for a more recent version of OUTLOOK.TXT. Thanks, Stoggers.