Search results for query: *

Hi, dear I have 3 ASP.Net systems that reference a VB.Net dll. I need 4 setups to install systems(3) and dll(1). If I alter code only in VB.Net dll, Do I need to generate all 4 setups or only the VB.Net setup? What about the systems(3) references to dll? Thank's Ofsouto Brazil

I want to show all registers from a table(CODE, DESCRIPTION) and show an additional collum with the row number(INCREMENT). Select * from table_1 RESULT: CODE DESCTIPTION INCREMENT -------- ------------------------- ----------- 03354718 FIRST_DESCRIPTION 1 54654654...

Hi, dear How can I open an OpenOffice instance on ASP.NET code? Thank you very much Obede

Thank you, chekai. It works. Could you answer me another question? What's better? Subqueries or Derived Tables? I know I could use subquery to get the result but I don't know about the performance. Thank you again. Obede Brazil

I have two queries: SELECT DISTINCT tot.po_tble_cod FROM po_tabelatotal tot (NOLOCK), po_tabelaitem itm (NOLOCK), po_parametro par (NOLOCK) WHERE tot.po_tblt_cod = itm.po_tblt_cod AND itm.po_para_cod = par.po_para_cod AND par.po_bloc_cod = 99 returns: 42, 43, 65, 114...

The problem was solved: SELECT DISTINCT fun.function_desc, fun.function_code FROM table_1 fun INNER JOIN table_2 itm ON fun.function_code = itm.function_code INNER JOIN table_3 par ON itm.parameter_code = par.parameter_code WHERE par.class_code = 1 AND fun.function_code NOT IN ( SELECT...

I need to list all functions (codes and descriptions) with item functions that have only parameters with class code = 1. It is wrong if the function has item functions with one parameter with class code = 1 and another parameter with class code = 2. Thank you very much. Obede

I have 3 tables table_1 function_code function_desc table_2 function_code itemfunction_code itemfunction_desc parameter_code table_3 parameter_code parameter_desc class_code I need to list all functions (code and description - table_1) where the item functions (table_2) have only parameters...

Hi, dear How can I get the inner text of "user" and "quantity" nodes? <Monitore xmlns="Monitoramento por Lote"> <Lote> <user>SIABE001 SC01</user> <quantity>1</quantity> <register>MR2000000000001I1IMR </register> <register>MR2000000000002I1IMR </register>...

Hi, dear I just got full text but there are some chr(13) characteres inside text. I think I'm using wrong encoding. Obede Brazil

Hi, dear I need to get the full text of a text datatype collumn of a sql-server table. I tried the example of this link (http://www.kbalertz.com/Feedback_317034.aspx) and change getbytes to getchars and I didn't get the full text. What's wrong? How can I get the full text? Thank you very much...

Hi, dear I need to get the value of a text datatype collumn in a SQL-Server table. The text length is 2196 characters, but when I try to get it by datareader or dataset the text length is 696. What's wrong? How can I get the full text? Thank you very much. Obede Brazil

Thank you ca8msm. I have solved the problem.

I intend to write more than one query in only one XML file. WriteXML permits write/save only one query. After write/save XML file I need to read/convert to dataset. Thank you.

Hi, dear I need to save the result of some queries as XML files. I know that I can use datasets. I would like to know if it's possible to save these queries in only one XML file. Is it possible to read and convert this XML file in datasets? Thank you very much. Obede Brazil

I'm querying data from a table. I have the table bellow CREATE TABLE [dbo].[AC_CARTEIRA] ( [ac_suplier_code] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [ac_date] [smalldatetime] NOT NULL , [ac_client_code] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ...

Is there another way without creating any table?

Hi, dear A date (GetDate()) is a stored procedure inside parameter. I need to list the last 13 month/year. I need to generate a query where I can get the result bellow: 01/2005 12/2004 11/2004 ... 02/2004 01/2004 Is it possible? How can I get it? Thank you very much Obede Brazil

I had solved the problem. I created an object as an arraylist and I set it = session("config"). Dim arrConfig As ArrayList = Session("config") lblUsuario.Text = CType(arrConfig.Item(5), String).Trim Thank you very much.

Dear sir I'm getting this error while trying to access an ASP.NET system on a Server. An user log on windows and can access the main page on ASP.NET system. Another user lon on windows and can't access the main page on ASP.NET System. Both are using the same machine. I tried again on another...