Recent content by YaBabyYa

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...

Hello, I have a table, the table has as subset of 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...

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' )

I have checked all the tables. They are being created properly. The Update query is complaining at the Select line Server: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'Select'. Server: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'Select'. I...

Hello, I have an update query which is being created dynamically. The update query needs to select a value from a temporary table and use that value to make the update. If the value was in a variable @var_val the query is Update <Table_Name> Set Column_Name = @var_val where Column_Name >...

Hello, I am constructing a dynamic T-SQL query. code snippet ---------------------------------------------------------- set @value_string = ' Select @temp_val = isNull( ' + @curr_char + ' , 0) from ##' +@input_table_name EXEC(@value_string)...

Hello, I am using some code to dynamically create a table. The columns of the table are determined at run time. The code is creating the proper TSQL statement and when I execute the statement independently it creates the table. However, in the code body after Executing the TSQL when I try to...

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...