Search results for query: *

Ok, I have solved the problem. You can copy your application folder contents into the ROOT folder. Then edit the web.xml file in the "conf" folder. At the bottom of the file there should be a list of default pages like : index.html, index.htm, index.jsp. Be careful, I think the naming is...

Hi, I have been playing with Tomcat and I found out one thing. What appears to be happening is that all the requests are directed to Tomcat. The default page in IIS is never ever referenced. Tomcat is having a webApps folder. There is a sub-folder there called ROOT. All requests are going to...

Hello, I have setup Tomcat to work with IIS on Win 2K. I successfully configured the ISAPI filter in IIS to point to Tomcat. I checked the IIS_redirect logs and they show that IIS is able to initialize the ISAPI filter and talk to Tomcat over AJP 1.3. The tomcat web server returns an HTTP...

...columns N I need to Sum( N ) and set the value in a column Rank Below I am showing an example, with Rank showing the calculation I must achieve. ******************************************************** Table ----------------------------------- Col_1 Col_2 .. Col_N Rank...

E-squared is the man .. yes I did what he said and it works. Nice.

Hello, I am trying to create a dynamic T-SQL update query. The query syntax is wrong and the main problem is that I can't retrieve a value from a global table to be used in the Update query. I have tried looking at several forums and places for a solution. I was reading somewhere (I can't...

Once you create the Table name dynamically all the manipulations on that table have to be made through Exec calls. The stored proc does not have a definition of the table, so the only place it can look is in the globals. Anyway..I have a recent post related to this issue. .. if you know the...

Hello E-Squared, I am using the dynamic SQL for very specific reasons. The reason is that the table columns are determined based on the input coming into the stored procedure. As a result I have to create the table using an Exec call and substituing the column names when the input arrives...

Is there a way to save the information temporarily into a variable? @my_var = Exec ( Select var_val from ## .. ) Exec (Update Table_name Set E = @my_var where E > @my_var' )

...156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'Select'. I have tested: Select var_val from ##STVR_FLOAT_Test_word28July2007205415483137 returns a value Select * from ##Out_Test_word28July2007205415483137 returns multiple rows and columns and column 'e' is one of...

...= @var_val where Column_Name > @var_val However, @var_val is contained in a table. I am trying to select the table. The actual statement is: *********************************************************** Update ##Out_Test_word28July2007205415483137 Set e = Select var_val from...

...EXEC(@value_string) ------------------------------------------------------------ Output T-SQL Query Which is Called by EXEC ********************************************************* Select @temp_val = isNull( t , 0) from ##Test_word28July20075231713524 PROBLEM...

...Name #Input_Word_Chars " error, where #Input_Word_Chars is the table that is created in the Dynamic T-SQL statment Code snippet is as follows: ************************************************************ set @Len =0 While(@Len < @Unique_W_Len) BEGIN set @curr_char =...

Hello, I am trying to make a calculation on two tables: Table # 1 --------- #words (Word varchar, A float, B float, C float,.. Z float) Table # 2 --------- #input_word #input_word table has a subset of the columns (A .. Z) Example: #words Word---A---B---C--...E.....S....T....... X Y...

I am trying to achieve the equivalent of a function call with an array result returned as a multi-column temporary table to a main procedure. main_function ( input_word (string) ) Table_1 [ ]= another_function ( input_word ) Table_2 [ ]= empty return result set...

Hello, I have a stored procedure: SP_SPLIT Input: Input_Word varchar(1000) Output: Select * from #temp_table which returns a temporary table with 2 columns: #temp_table-------------- ------------------------- Word-----------Varchar(80) Value----------Float I need to retrieve this...

I have solved the problem. The table #t was declared as an INT column. My code required a float as a result the decimal input was being cast to 0. Thanks.

I don't get any exceptions from the debugger. Just the value is coming back as 0 .. that is the error.

the Structure of the #t table is: Column Name: num_sample Column Type: Float Number of rows = 1 Table Definition Code: create table #t (num_sample int)

One additional piece of information The original dynamic query is comprised of two parts. 'Insert into #t Select ' + @curr_char + @temp_query_string_part_1 Select ' + @curr_char + @temp_query_string_part_1 [b]Output[b]: Select T from #Temp_word_list where KeywordID = 2 This query returns...