How to write text into textfile using SQL 2000
can I use exec sp_OAMethod ‘c:osqloutput.txt’, ‘WriteLine’, Null, ‘hello’ to write something on file using sql2000

Answer Question   |  November 16, 2010  11:54 AM
SQL, SQL 2000, SQL Server 2000, textfile

How to invalidate the session in Java?
i have written code to logout the user session in my project. but its not if i click back option, the session is still alive. please suggest me. my code is Java code: public void logout() { session = request.getSession(); session.invalidate(); RequestDispatcher rd = new RequestDispatcher(“Homepage”); rd.forward(request,response); } After logout, if I click back , the session [...]

Answer Question   |  November 16, 2010  6:03 AM
Java, Java code, Session length, session terminating

What is a good book for SQL?
which is the Good book for SQL?

Answer Question   |  December 5, 2010  4:52 AM
IT Books, Oracle, Oracle Books, SQL, SQL Server

How to simultaneously build a program on multiple platforms using Hudson
I would like to know what I need and how I should configure Hudson to do builds for multiple platforms and archetectures without having to build each version seperately, thus taking up valuable time. Is there a way to do this, and if so, how?

Answer Question   |  November 16, 2010  2:29 AM
Hudson, Platform integration, Platform Solutions, Programming, Programming tools, Visual Studio

Putting object description in Access 2007 navigation panel
how do i get the object desc. to show in the navigation panel?

Answer Question   |  November 15, 2010  4:12 PM
Access 2007, Access 2007 functions, Access Functions, Access Navigation Pane

Counting the number of correct answers in Visual Basic
I am trying to count the number of times a selected choice is “Correct!” and then after the 5 choices have been made display a message in a text box based on how many answer were correct. For instance, if the person answered 4 out of the 5 questions correctly I would display a text [...]

Answer Question   |  November 15, 2010  2:47 PM
COUNT statement, VB, VB Code, Visual Basic, Visual Basic developers

How to add an article in transactional replication in sql server 2005?
How to add an article in transactional replication in sql server 2005? and what are the prerequisites for trnsactional replication?

Answer Question   |  November 15, 2010  6:55 AM
DBA, SQL, SQL Server, SQL Server 2005, Transactional replication software

VBA Excel dates
Why can I not make VBA Excel write me the date I put in the code, rather it shows always 00/01/1900 pls? See I wrote a short code that fills in the woorkbook (sheet), the date (any date) as a responce to a week number. The problem is that the code is only returning one [...]

Answer Question   |  November 15, 2010  2:59 PM
Excel workbooks, VBA, Visual Basic, Visual Basic Error Messages

Error Message ORA-00903 in SQL table
Here is my query:   select guestid, guestfname, guestlname from guest where tourid = 6; It says tourid is an invalid identifier. TourID is a defined attribute in a table called Tour. I’d be grateful for any help.

Answer Question   |  November 15, 2010  11:53 PM
ORA-00903, SQL, SQL Plus, SQL tables

Filename from SQL 2005 Query
I have a batch file that runs a SQL query command overnight once a week and outputs the results of that query to a file as a .csv file. The query produces, amongst other things, a week ending date. Is it possible to to name the output file with result of the week ending column [...]

Answer Question   |  November 12, 2010  12:56 PM
Batch files, SQL 2005, SQL Query, SQL Server, SQL Server 2005

SQL Agent in SQL environment?
what is SQL Agent in SQL Environment?

Answer Question   |  November 12, 2010  11:52 AM
Agents, SQL, SQL Server, SQL Server Agent

How to update data for one column in MS SQL?
Hi, I have a table column named “Question” that stores the question without space.For example “Who are you” is stored as “whoareyou”.Now I have modified the code to store the data with spaces in Question column.Problem is newly added data will be stored with space,but I want to change the already existing thousands of records [...]

Answer Question   |  November 16, 2010  3:50 AM
SQL, SQL Database, SQL Server, SQL tables

Search for column header in Excel 2007
I use a macro for a weekly report. In the macro i use “Column (“C:C”).Select to select that column to filter out the zeros. Sometimes the information is in a different column when the data is downloaded, but the header of the column is still the same: “90_day_Late”. How do i search for “90_day_Late” (say it [...]

Answer Question   |  November 25, 2010  3:42 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excel functions, Excel macros

Skills for Software Tester for 1 year Experience
What all skills are required for a Software Tester having 1 year experience in Testing in terms of: 1). Domain. 2). Database. 3). Automation. 4). Programming Language. 5). Testing Methodologies. For the Above mentioned points please tell me in detailed manner how much % knowledge & also in what terms the knowledge is required for [...]

Answer Question   |  December 21, 2010  2:26 AM
Software testers, Software testing, Software testing fundamentals, Software testing jobs

Is OSGi useful for enterprise applications?
Is OSGi useful to developers for building enterprise applications?

Answer Question   |  November 12, 2010  10:47 PM
Application development, Enterprise application development, Enterprise applications, OSGi

Using SQL to insert records into a table
I have a table with a period in the table name, i.e. AB.CDE that I need to insert some records into. When I query the table (Select * from “AB.CDE”) it works fine. When I try to insert records (insert into “AB.CDE”), however, I get a file not found message. Does anybody know why this [...]

Answer Question   |  November 19, 2010  6:05 PM
AS/400, AS/400 Interactive Jobs, SQL, SQL Query

Embedded SQL number of days between dates
C/EXEC SQL                                C+ INSERT INTO SERIOVR60                  C+ SELECT HTSERN, HTPART, HTQTY, HTSTKL,  C+ HTSTS,  HTADAT,                        C+ substr(HTPART, 1, 11) AS HTMODEL,      C+ HTADAT – :CURDATE AS HTDAYS            C+ FROM SERI                              C+ WHERE HTADAT < :TESTDATE and           C+       HTADAT <> ’0001-01-01′ and       C+       HTSTS  = ‘A’                     C+ ORDER BY HTPART                        C/END-EXEC                                This returns;  Date     =    2010-05-12        Days [...]

Answer Question   |  November 13, 2010  5:07 PM
AS/400, Embedded SQL, SQL, SQLRPGLE

VBA Excel 2003 Copy and Paste
I would like to know how am i going to copy a certain range (A1:E500) in File A and paste it in a different file (File B). Then copy a new range in other sheet of File A then paste it in File B without overlapping the data I copied from the first range. Thank you [...]

Answer Question   |  November 16, 2010  4:08 PM
Excel 2003, Excel VBA, VBA, VBA EXCEL 2003

DMZ Setup with Cisco ASA 5510 and 2 VPN peers
I have an Cisco ASA with one external IP address, and 2 VPN Peers. Now i need to add a web server to the mix. Please tell me how can i accomplish this bearing in mind my existing setup? Thanks,

Answer Question   |  November 12, 2010  3:39 PM
Cisco ASA, Cisco ASA 5510, DMZ, DMZ Switch, Web servers

How can I tell if a file is ASCII or EBCDIC in iSeries?
Hi, I have to create a file to send to another location outside of our company. they ask if the file type is ASCII or EBCDIC. How do I tell what the file is on the iseries? Also when I transfer the file thru FTP do I need to define it in FTP. Thanks!

Answer Question   |  November 16, 2010  3:22 PM
ASCII, ASCII File, EBCDIC, File Types, iSeries, iSeries File Members