Search results for query: *

Thanks for the response k5tm The only problem is I need to know the node. Im looking for the node(s) that contains the value. What I'm trying to do is like find in notepad except its ignoring the tags and attributes it only looks at the values once its found the value then I want to know the...

Hi, I'm trying to do the equilivant to a Like or Wildcard search ( '*FRED*' to find any node containing FRED ) on the values in the nodes of an XML document. I've looked at XPath and XQuery and don't seem to be able to do this. Is this the case or is there a way of doing it. Thanks in advance...

Its not a web app the application that is doing the generation (of the Web Site) is a Windows App. So it seems to be a mixture of a problem with NTFS Security, Default Web Site, Metabase and Registry permissions. All works fine if you are a Local Admin of the Web Server. Have thought of adding...

Hi Everyone, Ihave a problem with an application that creates a web site on IIS. The problem is that if the user of the app has local admin permissions on the server everything works fine site created etc. But if I just move them out of the Admin group into a new group that has the same NTFS...

Hi Everyone, Ihave a problem with an application that creates a web site on IIS. The problem is that if the user of the app has local admin permissions on the server everything works fine site created etc. But if I just move them out of the Admin group into a new group that has the same NTFS...

Thanks DBomrrsm, I'll try the Global temporary table. Its just strange that it works fine in a SQL Task and through preview on the Source its self. Its only when I run the Transformation or Parse the Query that it gives me the error. If I remove the reference to the temporary table and as you...

Thanks DBomrrsm, I'll try the Global temporary table. Its just strange that it works fine in a SQL Task and through preview on the Source its self. Its only when I run the Transformation or Parse the Query that it gives me the error. If I remove the reference to the temporary table and as you...

Hi, I've currently got a problem with a DTS Package. I have a Data Source which is a stored proedure (that returns a resultset) which goes through a transfermation (just copying the field) to a Text file as the Destination. The stored procedure works fine in SQL analyser and as a SQL Task in...

LMCRYER, I'm assuming you are converting to SQL Server. *= is a lot like (+) in that the star needs to be on the side where the nulls will occur. ie it can either be *= or =*. You get the outer join request not permitted where you have more than one outer join and but they are not linier (can't...

Thanks cappmgr and everyone else, code worked with a few changes, need to add : at the start of the parameter and it all worked fine. Thanks again Andy

You'll need to Converts on the date strings as well if the columns are of datetime types in SQL Server. Andy

Hi, Try this SELECT "PACT"."EMPLOYEE_ID", "PACT"."ORDER_NBR", "PACT"."DEPT_ID", "PACT"."ACTIVITY_DATE", "PACT"."ACT_RSRC_USED", "PACT"."CONTROL_ID", "BIDCAT_CC"."CC" FROM "MRPOWNER"."BIDCAT_CC" "BIDCAT_CC", "CSIOWNER"."SOPN_ELK" "SOPN", "CSIOWNER"."PACT_ELK" "PACT" WHERE...

Hi Everyone, I'm getting the above error message for the following code: DataSet lds_Data = new DataSet(); OracleConnection lo_Conn = new OracleConnection("Data Source=xxxx; User ID=xxxx; Password=xxxx"); string ls_SQL = ""; // Build the SQL Statement ls_SQL = "SELECT *...

Hi there, Do you have to use dynamic SQL, you could have a table of the following structure. CREATE TABLE SeqNo( TabName varchar(255), CurrentSeq int ) Then when you need a Sequence number for you table have a stored procedure with the following code in it DECLARE...

Hi There, I have a WinForms app that links to a set of Doc Management Web Services. My problem is this I get back from the Web Service the MIME Type so that I can activate the relevant application. But I can't seem to find a way of find and starting the correct application. Thanks in advance...

Hi, Go a problem at the present with an import application which resides on the Application Server. This app needs to be run everyday, if certain errors occur I want it to reschedule for a specific time. Instead of writing the scheduling into the application I want to use the scheduler in SQL...

Hi, New to Visio Prof (2002 sp 1). In previous data modelling tools I've used there is the ablity to generate the ddl for the physical database model. My question is how do I do this in Visio. I've tried the Help an this seems only to look at entering code into the model sp, function, etc. And...

Yes I throught that 0 would indicate that no picture was present, but I was wrong. There seems to be a value there, even when empty. I've tried that value to and it still does not work. I've also looked at the Picture property but got the same result. Andy (LokiDBA)

You could also try SET ROWCOUNT 10 -- Return only the first 10 rows SELECT DISTINCT exposureid FROM instrumentid SET ROWCOOUNT 0 -- Reset row count to all Hope of some use Andy (LokiDBA)

Hi, I'm trying to validate some data input into a grid. One of the fields contains an image. Does anyone know how I can tell if the cell has a picture in it or not. Many Thanks in Advance Andy (LokiDBA)