Recent content by Elton1984

Hi all, My exchange 5.5 on a win2k server has been uninstalled by accident and i want to reinstall it back. But when i tried to reinstall exchange back, i received this following error: "The command lodctr dsactrs.ini failed, returning an error code of <6>." I have checked the Microsoft KB and...

Hiz all, anyone have any ideas on hw to build up a calendar using jsp without the use of a pop-up window. I searched all around the internet and most of the usable calendars are using a pop-up window. Anyway websites or examples of the codes would be greatly appericated.. Thanx in advance, Elton

Hiz all, I have a little problem here.. Example: (I'm supposed to add 4 days to today's date (22/6/04) and display the date that is 4 days later.) Oh ya, is there also a way to display all the dates that between today's date and the date 4 days later?? Anyone have any ideas on hw to get it to...

Hmmz it is quite helpful sedj thanx.. But i would like to noe if the stored procedure tat i haf copied out on top is it a stored procedure that is trying to retrieve data from DB or passing data into the DB.. Then hw can i use "registerOutParameter" in this case.. And "CreateParameter" from...

Hi all, i have a problem here.. I'm supposed to code a set of codes that would allow me to call a stored procedure from SQL. The problem is tat i have to convert this whole chunk of ASP codes to JSP codes.. And i am not familiar wif ASP as well as a stored procedure that requires variables...

Hi all, i have a scenario here whereby when i print a batch of reports, i would have to update a tblPrint to tell it that that particular batch of reports have been printed at least once. Here comes the problem, if i cancel the printjob halfway without printing anything.. The tables would still...

Hi all, I have a problem here where i am supposed to insert records into 2 tables. Table A has a primary key (loanindex) which is an autonumber. And i need to get the loanindex of the just inserted record and insert it into Table B. I have seen some forums, and notice that's a method regarding...

Hi all, I have a problem here where i am supposed to insert records into 2 tables. Table A has a primary key (loanindex) which is an autonumber. And i need to get the loanindex of the just inserted record and insert it into Table B. I have seen some forums, and notice that's a method regarding...

Hiz all, Reallie in need of some help here.. My stored procedure onli update the last record of the DB. DECLARE @prdtID varchar(10) SELECT @prdtID = a.PrdtCode FROM tblPrdt a LEFT OUTER JOIN tblLoan b ON a.PrdtCode = b.PrdtCode WHERE (b.LoanIndex IS NULL) UPDATE tblPrdt SET PrdtStatus = 'On...

Hiz all, Reallie in need of some help here.. My stored procedure onli update the last record of the DB. DECLARE @prdtID varchar(10) SELECT @prdtID = a.PrdtCode FROM tblPrdt a LEFT OUTER JOIN tblLoan b ON a.PrdtCode = b.PrdtCode WHERE (b.LoanIndex IS NULL) UPDATE tblPrdt SET PrdtStatus = 'On...

Thanx for that post of urs venu.. But i am still not able to loop thru the all the records in the DB. My stored procedure onli update the last record of the DB. DECLARE @prdtID varchar(10) SELECT @prdtID = a.PrdtCode FROM tblPrdt a LEFT OUTER JOIN tblLoan b ON a.PrdtCode = b.PrdtCode WHERE...

I am using currently using SQL Server.. The syntax would be something like VB Script? Is it possible to haf an example of the syntax? Thanx

Hiz everyone, i would like to know if loops(For Loop, While Loop) are allowed in a Stored Procedure. If it is possible, an example of the codes would be of great help.. Thanx in advance Elton Wong

Greetings everyone.. I did a simple stored procedure which would enable mi to delete some records from the DB.. STORED PROCEDURE ---------------- CREATE Procedure purgeRecords As DELETE FROM tblLoan WHERE CollectionStatus = 'Uncollected' GO ---------------- Can anyone help with calling...

Hey all, i would like to noe if that's anyway for mi to validate 2 days to make sure that the end date is not earlier than the start date, and if the dates are not in the right format an error msg would be displayed in the same page instead of submitting to another page.. Thanx all in advance Elton