incorrect syntax error..., - ASP.NET Discussion Boards

www.Developerof.NET29-Jun-07 2:42

www.Developerof.NET

29-Jun-07 2:42

Hi all,

Are all objects created in asp .net transient or persistant???
ie if i write SqlConnection sqlConnection=new SqlConnection(.....) 100 times, does this imply that 100 different objects are created or a single object is overwritten???

Re: Lifetime of an object in ASP.NET

Sylvester george29-Jun-07 2:52

Sylvester george

29-Jun-07 2:52

if you repeat this statement

sam werch wrote:
SqlConnection sqlConnection=new SqlConnection(.....)

for 100 times the code will not compile

if you write

SqlConnection sqlConnection = new SqlConnection(.....);

sqlConnection = new SqlConnection(.....);
sqlConnection = new SqlConnection(.....);
sqlConnection = new SqlConnection(.....);

for 100 times

it will create only one object
but the memory will be refred 100 times
and 100 times insatcne will be generated

and its really a coding HORRoR

Regards,
Sylvester G

Re: Lifetime of an object in ASP.NET

www.Developerof.NET29-Jun-07 3:05

www.Developerof.NET

29-Jun-07 3:05

Suppose i close the connections every time i instantite it, will it dispose off the connection?

Re: Lifetime of an object in ASP.NET

Not Active29-Jun-07 3:12

Not Active

29-Jun-07 3:12

The object will be disposed but because of connection pooling the connection itself may remain open.

http://www.15seconds.com/issue/040830.htm[^]

only two letters away from being an asset

Re: Lifetime of an object in ASP.NET

www.Developerof.NET29-Jun-07 3:35

www.Developerof.NET

29-Jun-07 3:35

Thanks 4 giving ur precious time Rose | [Rose]

Biztalk, pls, answer. pls. I have created a flatfile schema

indian14329-Jun-07 2:27

indian143

29-Jun-07 2:27

Sir,
I am very new to Biztalk server development env. I have created a flatfile schema. When I say Validate Schema its giving all the records in the flatfile and they are correct. But when I say genenrate instance it is showing only dummy record, that too only one.
What I want to do is I have a flat file and that flat file data I want to process in some functoids in Biztalk maps. But its not giving what result I want pls. help me. Thank you.

Regards,
Aleem.

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

Re: Biztalk, pls, answer. pls. I have created a flatfile schema

Not Active29-Jun-07 2:36

Not Active

29-Jun-07 2:36

Stop cross posting and someone may answer you. This has nothing to do with ASP.NET

only two letters away from being an asset

incorrect syntax error...,

Member 387988129-Jun-07 2:20

Member 3879881

29-Jun-07 2:20

in my button click event i am filling the datas from my stored procedure to datagrid...,
But i am getting error like...,
Incorrect syntax near ','
And its showing error place at

mysqldataadapter.fill(mydataset,"st") place...,
This is my code...,

mySqlDataAdapter = New SqlDataAdapter("Magview" & Val(ddEmpid.SelectedItem.Value) & "," & Val(ddlMonth.SelectedItem.Value) & "," & Val(ddlYears.SelectedItem.Value) & "", sqlconn)

myDataSet = New DataSet

mySqlDataAdapter.Fill(myDataSet, "st")
DataGrid1.DataSource = myDataSet
DataGrid1.DataBind()
mySqlDataAdapter.Dispose()
myDataSet.Dispose()
sqlconn.Close()

And this is my stored procedure:

CREATE PROCEDURE MagView
(
@EId as int,
@months as tinyint,
@years as smallint
)
As
begin

select hra as hra1,'hra' AS magc
from tblmonthsalary
where hra <> 0 and Eid=@Eid and Smonth=@months and SYear=@Years
UNION
select ca as hra1, 'Ca' AS magc
from tblmonthsalary
where ca <> 0 and Eid=@Eid and Smonth=@months and SYear=@Years
UNION
select ota as hra1, 'ota' AS magc
from tblmonthsalary
where ota <> 0 and Eid=@Eid and Smonth=@months and SYear=@Years
UNION
select sha as hra1, 'sha' AS magc
from tblmonthsalary
where sha <> 0 and Eid=@Eid and Smonth=@months and SYear=@Years
union
select al as hra1,'al' AS magc
from tblmonthsalary
where al <> 0 and Eid=@Eid and Smonth=@months and SYear=@Years
UNION
select alp as hra1, 'alp' AS magc
from tblmonthsalary
where alp <> 0 and Eid=@Eid and Smonth=@months and SYear=@Years

end
GO

Plz solve my probs...,

Regards,
Magi

Re: incorrect syntax error...,

kubben29-Jun-07 2:25

kubben

29-Jun-07 2:25

The Fill method doesn't have any over loads that match what you are trying to do. Why are you putting , "st" after the myDataSet? It should probably be just myDataSet) nothing else.

Ben

Re: incorrect syntax error...,

Member 387988129-Jun-07 2:28

Member 3879881

29-Jun-07 2:28

If i remove "st" aslo its giving same error...,
See i have attached my stored procedure too in my pre msg...,
Hlp me...,

Regards,
Magi

Re: incorrect syntax error...,

kubben29-Jun-07 2:31

kubben

29-Jun-07 2:31

Well, looking at your code:
("Magview" & Val(ddEmpid.SelectedItem.Value) & "," & Val(ddlMonth.SelectedItem.Value) & "," & Val(ddlYears.SelectedItem.Value) & "",

Would probably translate to:
MagviewValuefromDropdown,MonthSelected,YearSelected

So I am guessing you need a space after Magview

So your code probably should be:
("Magview " & Val(ddEmpid.SelectedItem.Value) & "," & Val(ddlMonth.SelectedItem.Value) & "," & Val(ddlYears.SelectedItem.Value) & "",

Ben

Re: incorrect syntax error...,

Member 387988129-Jun-07 2:37

Member 3879881

29-Jun-07 2:37

Hey yar how i forget to give the space on there...,
Ya want to give space on ther...,
Anyway thanks to spend ur time with me...,
keep in touch,

Regards,
Magi

Re: incorrect syntax error...,

doWhileSomething29-Jun-07 14:53

doWhileSomething

29-Jun-07 14:53

The additional parameters when filling the dataset are optional, the second paramater is for the table name. It could be the identical name of the table your pulling from, or just an alias so you can reference it later (assuming you have more than one in your dataset).

This is likely where the error is comming from:

mySqlDataAdapter = New SqlDataAdapter("Magview" & Val(ddEmpid.SelectedItem.Value) & "," & Val(ddlMonth.SelectedItem.Value) & "," & Val(ddlYears.SelectedItem.Value) & "", sqlconn)

The data adapter has two optional parameters you can use when you create the NEW instance of it.
Commandtext(string) and an sql connection object.

Your parameters broken down look like this:
("Magview" & Val(ddEmpid.SelectedItem.Value)
& ","
& Val(ddlMonth.SelectedItem.Value) &
"," &
Val(ddlYears.SelectedItem.Value) & "",

sqlconn

The first one is what throws me off a bit, you have a fixed string and concatenating that with what should be a numeric value. (kind of sloppy code Frown | :(

)) If it is a string, then you need to wrap it with single quotes. The last piece of your string appends a double quote, not sure why, but it doesnt match anything else.

If these are parameters that you are trying to feed a SPROC, then this too is still wrong.

Can you explain what it is your trying to do?

My Personal Site

Identifier Expected Error

vijay_8329-Jun-07 2:01

vijay_83

29-Jun-07 2:01

this is my code in which i get an error as "Identifier Expected in line:

private const SecretSalt = "H3#@*ALMLLlk31q4l1ncL#@...";

_____________________________________________________________________________

private void Page_Load(object sender, System.EventArgs e)
{
lnkToB.NavigateUrl = CreateTamperProofURL("TamperProofURLs.B.aspx", "NonTamperProof=1", "TP1=Scott&TP2=27");
}

//The secret salt...
private const SecretSalt = "H3#@*ALMLLlk31q4l1ncL#@...";

public string CreateTamperProofURL(string url, string nonTamperProofParams, string tamperProofParams)
{
string tpURL = url;
if (nonTamperProofParams.Length > 0 || tamperProofParams.Length > 0)
{
url // ERROR: Unknown assignment operator ConcatString
;
}

//Add on the tamper & non-tamper proof parameters, if any
if (nonTamperProofParams.Length > 0)
{
url // ERROR: Unknown assignment operator ConcatString
;

if (tamperProofParams.Length > 0) url // ERROR: Unknown assignment operator ConcatString
;
}

if (tamperProofParams.Length > 0) url // ERROR: Unknown assignment operator ConcatString
;

//Add on the tamper-proof digest, if needed
if (tamperProofParams.Length > 0)
{
url // ERROR: Unknown assignment operator ConcatString
;
}

return url;
}

public string GetDigest(string tamperProofParams)
{
string Digest = string.Empty;
string input = string.Concat(SecretSalt, tamperProofParams, SecretSalt);

//The array of bytes that will contain the encrypted value of input
byte[] hashedDataBytes;

//The encoder class used to convert strPlainText to an array of bytes
System.Text.UTF8Encoding encoder = new System.Text.UTF8Encoding();

//Create an instance of the MD5CryptoServiceProvider class
System.Security.Cryptography.MD5CryptoServiceProvider md5Hasher = new System.Security.Cryptography.MD5CryptoServiceProvider();

//Call ComputeHash, passing in the plain-text string as an array of bytes
//The return value is the encrypted value, as an array of bytes
hashedDataBytes = md5Hasher.ComputeHash(encoder.GetBytes(input));

//Base-64 Encode the results and strip off ending '==', if it exists
Digest = Convert.ToBase64String(hashedDataBytes).TrimEnd("=".ToCharArray());

return Digest;
}
In which case do i get that error. pls do help me in solving it.

Regards
Vijay.

Re: Identifier Expected Error

Vasudevan Deepak Kumar29-Jun-07 2:10

Vasudevan Deepak Kumar

29-Jun-07 2:10

vijay_83 wrote:
private const SecretSalt = "H3#@*ALMLLlk31q4l1ncL#@...";

Can you try @"H3#@*ALMLLlk31q4l1ncL#@...";?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

NAKRA final

NAKRAINC29-Jun-07 1:46

NAKRAINC

29-Jun-07 1:46

AS:1
QNO : 1
CREATE TABLE MEMBER_VIJAY(MEMBER_ID NUMBER(5),
MEMBER_NAME CHAR(25),
ACC_OPEN_DATE DATE,
MAX_BOOKS_ALLOWED NUMBER(2),
PENALTY_AMOUNT NUMBER(7,2)
);

CREATE TABLE BOOK_VIJAY(BOOK_NO NUMBER(6),
BOOK_NAME VARCHAR2(30),
AUTHOR CHAR(30),
COST NUMBER(7,2),
CATEGORY CHAR(10)
);

CREATE TABLE ISSUE_VIJAY(LIB_ISSUE_ID NUMBER(10),
BOOK_NO NUMBER(6),
MEMBER_ID NUMBER(5),
ISSUE_DATE DATE,
RETURN_DATE DATE
);

QNO : 2
DESC MEMBER_VIJAY;
DESC BOOK_VIJAY;
DESC ISSUE_VIJAY;

QNO : 3
ALTER TABLE ISSUE_VIJAY ADD( COMMENTS CHAR(100));

QNO : 4
ALTER TABLE MEMBER_VIJAY MODIFY(MEMBER_NAME CHAR(30));

QNO : 5
ALTER TABLE ISSUE_VIJAY ADD(REFERENCE CHAR(30));

QNO : 6
ALTER TABLE ISSUE_VIJAY DROP COLUMN REFERENCE;

QNO : 7
RENAME ISSUE_VIJAY TO LIB_ISSUE_VIJAY;

QNO : 8
INSERT INTO MEMBER_VIJAY VALUES(1,'RICHA SHARMA','10-DEC-05',5,50);
INSERT INTO MEMBER_VIJAY VALUES(2,'GARIMA SHARMA',SYSDATE,3,NULL);

QNO : 9
ALTER TABLE MEMBER_VIJAY MODIFY(MEMBER_NAME CHAR(20));
ORA-01441: cannot decrease column length because some value is too big

QNO : 10
INSERT INTO MEMBER_VIJAY VALUES(1,'VIJAY','27-JUNE-2007',110,100);
ORA-01438: value larger than specified precision allows for this column

QNO : 11
CREATE TABLE MEMBER101_VIJAY AS (SELECT *FROM MEMBER_VIJAY);

QNO : 12
INSERT INTO BOOK_VIJAY VALUES(101,'LET US C','DENIS RITCHIE',450,'SYSTEM');
INSERT INTO BOOK_VIJAY VALUES(102,'ORACLE-COMPLETE REFERENCE','LONI',550,'DATABASE');
INSERT INTO BOOK_VIJAY VALUES(103,'MASTERING SQL','LONI',250,'DATABASE');
INSERT INTO BOOK_VIJAY VALUES(104,'PL SQL-REF','SCOTT URMAN',750,'DATABASE');

QNO : 13
INSERT INTO BOOK_VIJAY VALUES(&BOOK_NO,'&BOOK_NAME','&AUTHOR',&COST,'&CATEGORY');
Enter value for book_no: 105
Enter value for book_name: C++
Enter value for author: LIPMAN
Enter value for cost: 450
Enter value for category: SYSTEM

QNO : 14
CREATE TABLE BOOK101_VIJAY AS (SELECT BOOK_NO,BOOK_NAME,AUTHOR,COST,CATEGORY FROM BOOK_VIJAY WHERE BOOK_NO NOT LIKE '1%');

QNO : 15
INSERT INTO BOOK101_VIJAY(SELECT *FROM BOOK_VIJAY);

QNO : 16
COMMIT;

QNO : 17
SELECT *FROM MEMBER_VIJAY;
SELECT *FROM BOOK_VIJAY;
SELECT *FROM ISSUE_VIJAY;
SELECT *FROM MEMBER101_VIJAY;
SELECT *FROM BOOK101_VIJAY;

QNO : 18
INSERT INTO BOOK_VIJAY VALUES(105,'NATIONAL GEOGRAPHIC','ADIS SCOTT',1000,'SCIENCE');

QNO : 19
ROLLBACK;

QNO : 20
UPDATE BOOK_VIJAY SET COST=300,CATEGORY='RDBMS' WHERE BOOK_NO=103;

QNO : 21
RENAME TABLE LIB_ISSUE_VIJAY TO ISSUE_VIJAY;

QNO : 22
INSERT INTO ISSUE_VIJAY(LIB_ISSUE_ID,BOOK_NO,MEMBER_ID,ISSUE_DATE)
VALUES(&LIB_ISSUE_ID,&BOOK_NO,&MEMBER_ID,&ISSUE_DATE);
Enter value for lib_issue_id: 7001
Enter value for book_no: 101
Enter value for member_id: 1
Enter value for issue_date: '10-DEC-06'

QNO : 23
COMMIT;

QNO : 24
INSERT INTO ISSUE_VIJAY(LIB_ISSUE_ID,BOOK_NO,MEMBER_ID,ISSUE_DATE)
VALUES(&LIB_ISSUE_ID,&BOOK_NO,&MEMBER_ID,&ISSUE_DATE);
Enter value for lib_issue_id: 7007
Enter value for book_no: 101
Enter value for member_id: 3
Enter value for issue_date: '10-JUNE-06'

INSERT INTO ISSUE_VIJAY(LIB_ISSUE_ID,BOOK_NO,MEMBER_ID,ISSUE_DATE)
VALUES(&LIB_ISSUE_ID,&BOOK_NO,&MEMBER_ID,&ISSUE_DATE);
Enter value for lib_issue_id: 7007
Enter value for book_no: 102
Enter value for member_id: 2
Enter value for issue_date: '15-JULY-06'

QNO : 25
UPDATE ISSUE_VIJAY SET RETURN_DATE=(ISSUE_DATE+15) WHERE LIB_ISSUE_ID=7004
OR LIB_ISSUE_ID=7005;

QNO : 26
UPDATE MEMBER_VIJAY SET PENALTY_AMOUNT=100 WHERE MEMBER_NAME='GARIMA SHARMA';

QNO : 27
SAVEPOINT X;

QNO : 28
DELETE FROM ISSUE_VIJAY WHERE MEMBER_ID=1 AND ISSUE_DATE<'10-DEC-06';

QNO : 29
DELETE FROM BOOK_VIJAY WHERE CATEGORY!='RDBMS' AND CATEGORY!='DATABASE';

QNO : 30
ROLLBACK TO X;

QNO : 31
COMMIT;

QNO : 32
DROP TABLE MEMBER101_VIJAY;

QNO : 33
DROP TABLE BOOK101_VIJAY;

QNO : 34
SELECT * FROM MEMBER_VIJAY;
SELECT * FROM BOOK_VIJAY;
SELECT *FROM ISSUE_VIJAY;
DESC MEMBER_VIJAY;
DESC BOOK_VIJAY;
DESC ISSUE_VIJAY;

QNO : 35
SELECT TNAME FROM TAB WHERE TNAME LIKE '%VIJAY';

########################################################################
AS: 2
QNO : 1
SELECT MEMBER_NAME
FROM MEMBER
WHERE ACC_OPEN_DATE>'31-DEC-2005' AND ACC_OPEN_DATE <'1-JAN-2007';

OR

SELECT MEMBER_NAME
FROM MEMBER
WHERE ACC_OPEN_DATE BETWEEN '31-DEC-2005' AND '1-JAN-2007';

QNO : 2
SELECT BOOK_NAME,AUTHOR
FROM BOOK
WHERE AUTHOR='LONI' AND COST>600;

QNO : 3
SELECT LIB_ISSUE_ID,BOOK_NO,MEMBER_ID,ISSUE_DATE,RETURN_DATE
FROM ISSUE
WHERE COMMENTS='PENDING';

QNO : 4
UPDATE ISSUE SET RETURN_DATE='31-DEC-06'
WHERE RETURN_DATE=NULL AND (LIB_ISSUE_ID!=7005 OR LIB_ISSUE_ID!=7006);

QNO : 5
SELECT LIB_ISSUE_ID,BOOK_NO,MEMBER_ID,ISSUE_DATE,RETURN_DATE
FROM ISSUE
WHERE (SYSDATE-ISSUE_DATE)>30 AND (ISSUE_DATE-RETURN_DATE)>30;

OR

SELECT LIB_ISSUE_ID,BOOK_NO,MEMBER_ID,ISSUE_DATE,RETURN_DATE
FROM ISSUE
WHERE ((SYSDATE-ISSUE_DATE)>30 AND RETURN_DATE=NULL) OR (ISSUE_DATE-RETURN_DATE)>30;

QNO : 6
SELECT BOOK_NAME
FROM BOOK
WHERE (COST BETWEEN 500 AND 750) AND CATEGORY='DATABASE';

QNO : 7
SELECT BOOK_NAME
FROM BOOK
WHERE CATEGORY IN('SCIENCE','DATABASE','FICTION','MANAGEMENT');

QNO : 8
SELECT MEMBER_ID,MEMBER_NAME,PENALTY_AMOUNT
FROM MEMBER
ORDER BY PENALTY_AMOUNT DESC;

OR

SELECT MEMBER_ID,MEMBER_NAME,PENALTY_AMOUNT
FROM MEMBER
ORDER BY 3 DESC;

QNO : 9
SELECT BOOK_NAME,COST
FROM BOOK
ORDER BY BOOK_NAME,COST DESC;

OR

SELECT BOOK_NAME,COST
FROM BOOK
ORDER BY 1,2 DESC;

QN0 : 10
SELECT BOOK_NAME
FROM BOOK
WHERE BOOK_NAME LIKE '%SQL%';

QNO : 11
SELECT MEMBER_NAME
FROM MEMBER
WHERE MEMBER_NAME LIKE ('G%I%' ||'R%I%');

QNO : 12
SELECT INITCAP(BOOK_NAME),UPPER(AUTHOR)
FROM BOOK
ORDER BY 1 DESC;

QNO : 13
SELECT BOOK_NO, CONCAT('IS WRRITTEN ', 'BY') " ---------------- ", AUTHOR AS NAME
FROM BOOK;

OR

SELECT CONCAT( BOOK_NO,' IS WRITTEN BY') "BOOKNO ------------------",AUTHOR AS NAME
FROM BOOK;

QNO : 14
SELECT LIB_ISSUE_ID,BOOK_NO,TO_CHAR(TO_DATE(ISSUE_DATE,'DD-MM-YY'),'Day,Month,DD,YYYY') ,
TO_CHAR(TO_DATE(RETURN_DATE,'DD-MM-YY'),'Day,Month,DD,YYYY')
FROM ISSUE
WHERE MEMBER_ID=101;

QNO : 15 & 16
SELECT CATEGORY,
DECODE(CATEGORY,'DATABASE','D','SCIENCE','S','RDBMS','R','OTHERS','O')
FROM BOOK;

QNO : 17
SELECT CONCAT( RPAD(BOOK_NAME,20,'*'),LPAD(AUTHOR,20,'*') )
FROM BOOK;

QNO : 18
SELECT LIB_ISSUE_ID,ISSUE_DATE,RETURN_DATE,COUNT(ISSUE_DATE-RETURN_DATE) "NO OF DAYS"
FROM ISSUE;

QNO : 19
SELECT MEMBER_ID,MEMBER_NAME,ACC_OPEN_DATE,MAX_BOOKS_ALLOWED,PENALTY_AMOUNT
FROM MEMBER
ORDER BY 3 DESC;

QNO : 20
SELECT COUNT(BOOK_NO)
FROM ISSUE
WHERE MEMBER_ID=101;

QNO : 21
SELECT SUM(PENALTY_AMOUNT)
FROM MEMBER;

QNO : 22
SELECT SUM(COST)
FROM BOOK
WHERE CATEGORY='DATABASE';

QNO : 23
SELECT BOOK_NAME,COST
FROM BOOK ;

QNO : 24
SELECT BOOK_NO,MIN(ISSUE_DATE)
FROM ISSUE;

QNO : 25
SELECT BOOK_NO,MAX(ISSUE_DATE)
FROM ISSUE;

QNO : 26
SELECT AVG(COST)
FROM BOOK
WHERE CATEGORY='DATABASE';

########################################################################
AS: 3
QNO : 1
SELECT CATEGORY,COUNT(BOOK_NO) FROM BOOK_C_VIJAY GROUP BY CATEGORY;

QNO : 2
SELECT B.BOOK_NO,COUNT(I.BOOK_NO) FROM BOOK_C_VIJAY B,ISSUE_C_VIJAY I
WHERE (B.BOOK_NO=I.BOOK_NO) GROUP BY B.BOOK_NO;

QNO : 3
SELECT MAX(PENALTY_AMOUNT),MIN(PENALTY_AMOUNT),SUM(PENALTY_AMOUNT),
AVG(PENALTY_AMOUNT) FROM MEMBER_C_VIJAY;

QNO : 4
SELECT M.MEMBER_ID,COUNT(I.MEMBER_ID) FROM
MEMBER_C_VIJAY M,ISSUE_C_VIJAY I WHERE
(M.MEMBER_ID=I.MEMBER_ID) GROUP BY M.MEMBER_ID;

QNO : 5
SELECT I.MEMBER_ID,B.BOOK_NO,COUNT(I.BOOK_NO)
FROM ISSUE_C_VIJAY I,BOOK_C_VIJAY B
WHERE I.BOOK_NO IN(B.BOOK_NO)
GROUP BY I.MEMBER_ID,B.BOOK_NO;

QNO : 6
SELECT TO_CHAR(ISSUE_DATE,'MONTH'),COUNT(BOOK_NO)
FROM ISSUE_C_VIJAY
GROUP BY TO_CHAR(ISSUE_DATE,'MONTH')
ORDER BY 2 DESC;

QNO : 7
SELECT BOOK_NO FROM BOOK_C_VIJAY
WHERE BOOK_NO NOT IN(SELECT BOOK_NO FROM ISSUE_C_VIJAY);

QNO : 8
SELECT MEMBER_ID FROM MEMBER_C_VIJAY
WHERE MEMBER_ID IN(SELECT MEMBER_ID FROM ISSUE_C_VIJAY);

QNO : 9
SELECT MEMBER_ID,COUNT(*)
FROM ISSUE_VIJAY
GROUP BY MEMBER_ID
HAVING COUNT(*) IN
( (SELECT MAX( COUNT(*) ) FROM ISSUE_VIJAY
GROUP BY MEMBER_ID),
(SELECT MIN( COUNT(*) ) FROM ISSUE_VIJAY
GROUP BY MEMBER_ID) );

QNO : 10
SELECT * FROM ISSUE_C_VIJAY
WHERE TO_CHAR(ISSUE_DATE,'MM') IN('12','07');

QNO : 11
SELECT B.BOOK_NO,B.BOOK_NAME,I.ISSUE_DATE FROM
BOOK_C_VIJAY B,ISSUE_C_VIJAY I
WHERE TO_CHAR(ISSUE_DATE,'MM') IN('12') AND B.BOOK_NO=I.BOOK_NO AND CATEGORY='DATABASE';

QNO : 12
SELECT I.MEMBER_ID,M.MEMBER_NAME,COUNT(I.BOOK_NO)
FROM MEMBER_C_VIJAY M,ISSUE_C_VIJAY I
WHERE I.MEMBER_ID=M.MEMBER_ID
GROUP BY I.MEMBER_ID,M.MEMBER_NAME
ORDER BY 3 DESC;

QNO : 13
SELECT B.BOOK_NO,B.BOOK_NAME,I.ISSUE_DATE,I.RETURN_DATE
FROM BOOK_C_VIJAY B,MEMBER_C_VIJAY M,ISSUE_C_VIJAY I
WHERE (M.MEMBER_NAME='VIJAY' AND I.BOOK_NO=B.BOOK_NO
AND I.MEMBER_ID=M.MEMBER_ID);

QNO : 14
SELECT M.MEMBER_ID,M.MEMBER_NAME,B.CATEGORY
FROM MEMBER_C_VIJAY M,BOOK_C_VIJAY B,ISSUE_C_VIJAY I
WHERE B.CATEGORY='DATABASE' AND M.MEMBER_ID=I.MEMBER_ID
AND B.BOOK_NO=I.BOOK_NO;

QNO : 15
SELECT CATEGORY, MAX(COST)
FROM BOOK_C_VIJAY
GROUP BY CATEGORY;

QNO : 16
SELECT M.ACC_OPEN_DATE,I.BOOK_NO,I.MEMBER_ID,I.ISSUE_DATE,I.RETURN_DATE
FROM MEMBER_C_VIJAY M,ISSUE_C_VIJAY
I WHERE (I.ISSUE_DATE NOT BETWEEN M.ACC_OPEN_DATE AND I.RETURN_DATE)
AND I.MEMBER_ID=M.MEMBER_ID ;

QNO : 17
SELECT DISTINCT M.MEMBER_ID,M.MEMBER_NAME
FROM MEMBER_C_VIJAY M,ISSUE_C_VIJAY
WHERE M.MEMBER_ID NOT IN(SELECT MEMBER_ID FROM ISSUE_C_VIJAY);

QNO : 18
SELECT MEMBER_ID,MEMBER_NAME
FROM MEMBER_C_VIJAY
WHERE
(SELECT COUNT(I.BOOK_NO) FROM ISSUE_C_VIJAY I,BOOK_C_VIJAY B,MEMBER_C_VIJAY M
WHERE I.BOOK_NO=B.BOOK_NO AND I.MEMBER_ID=M.MEMBER_ID)>MAX_ALLOWED_BOOKS
GROUP BY MEMBER_ID,MEMBER_NAME;

QNO : 19

QNO : 20
SELECT DISTINCT B.BOOK_NAME,B.COST
FROM BOOK_C_VIJAY B,ISSUE_C_VIJAY I
WHERE (I.RETURN_DATE-I.ISSUE_DATE)>30;

QNO : 21
SELECT B.AUTHOR,B.BOOK_NAME FROM BOOK_C_VIJAY B
WHERE (SELECT COUNT(C.AUTHOR) FROM BOOK_C_VIJAY C WHERE B.AUTHOR=C.AUTHOR)>=2;

QNO : 22
SELECT M.MEMBER_NAME,M.MEMBER_ID,COUNT(*)
FROM ISSUE_C_VIJAY I,MEMBER_C_VIJAY M
WHERE M.MEMBER_ID = I.MEMBER_ID
GROUP BY M.MEMBER_NAME,M.MEMBER_ID
HAVING COUNT(*) IN
( (SELECT MAX( COUNT(*) ) FROM ISSUE_C_VIJAY GROUP BY MEMBER_ID),
(SELECT MIN( COUNT(*) ) FROM ISSUE_C_VIJAY GROUP BY MEMBER_ID) ) ;

QNO : 23
SELECT MAX(COST) FROM BOOK_C_VIJAY
UNION
SELECT MAX(COST) FROM BOOK_C_VIJAY
WHERE COST < (SELECT MAX(COST) FROM BOOK_VIJAY)
UNION
SELECT MAX(COST) FROM BOOK_C_VIJAY
WHERE COST < ( SELECT MAX(COST) FROM BOOK_C_VIJAY WHERE COST < (SELECT MAX(COST) FROM BOOK_C_VIJAY) );

OR

SELECT BOOK_NAME,AUTHOR,COST FROM BOOK_C_VIJAY
ORDER BY COST DESC;

QNO : 24
SELECT SUM(B.COST) FROM BOOK_C_VIJAY B,
ISSUE_C_VIJAY I
WHERE (I.RETURN_DATE>SYSDATE AND B.BOOK_NO=I.BOOK_NO);

QNO : 25
SELECT B.BOOK_NO,B.BOOK_NAME,COUNT(*)
FROM ISSUE_C_VIJAY I,BOOK_C_VIJAY B
WHERE B.BOOK_NO=I.BOOK_NO
GROUP BY B.BOOK_NO,B.BOOK_NAME
HAVING COUNT(*) IN(SELECT MAX( COUNT(*) ) FROM ISSUE_C_VIJAY GROUP BY MEMBER_ID);

#####################################################################
AS : 4
QNO : 1
CREATE TABLE MEMBER_C_VIJAY(MEMBER_ID NUMBER(5) PRIMARY KEY,
ACC_OPEN_DATE DATE DEFAULT SYSDATE,
MAX_ALLOWED_BOOKS NUMBER(2) CHECK(MAX_ALLOWED_BOOKS<100),
PENALTY_AMOUNT NUMBER(7,2) CHECK(PENALTY_AMOUNT<=1000)
MEMBER_NAME CHAR(25));

QNO : 2
CREATE TABLE BOOK_C_VIJAY(BOOK_NO NUMBER(6) PRIMARY KEY,
BOOK_NAME VARCHAR2(30) NOT NULL, CATEGORY CHAR(10)
CHECK(CATEGORY='SCIENCE' OR CATEGORY='FICTION' OR CATEGORY='FICTION' OR CATEGORY='DATABASE' OR CATEGORY='RDBMS' OR CATEGORY='OTHERS'))

QNO : 3
CREATE TABLE ISSUE_C_VIJAY(LIB_ISSUE_ID NUMBER(10) PRIMARY KEY,
MEMBER_ID NUMBER(5) REFERENCES MEMBER_C_VIJAY(MEMBER_ID),
BOOK_NO NUMBER(6) REFERENCES BOOK_C_VIJAY(BOOK_NO),
ISSUE_DATE DATE,
RETURN_DATE DATE );

ALTER TABLE ISSUE_C_VIJAY ADD CONSTRAINT I CHECK(RETURN_DATE>ISSUE_DATE);

OR

CREATE TABLE ISSUE_C_VIJAY(LIB_ISSUE_ID NUMBER(10) PRIMARY KEY,
MEMBER_ID NUMBER(5) REFERENCES MEMBER_C_VIJAY(MEMBER_ID),
BOOK_NO NUMBER(6) REFERENCES BOOK_C_VIJAY(BOOK_NO),
ISSUE_DATE DATE,
RETURN_DATE DATE ,CHECK(RETURN_DATE>ISSUE_DATE);

QNO : 4
ALTER TABLE BOOK_C_VIJAY ADD CONSTRAINT V CHECK(COST<2500);

QNO : 5
SELECT *FROM USER_CONSTRAINTS WHERE TABLE_NAME='ISSUE_C_VIJAY';

QNO : 6
ALTER TABLE ISSUE_C_VIJAY DISABLE CONSTRAINT I;

QNO : 7
CREATE VIEW Vijay AS( SELECT LIB_ISSUE_ID,BOOK_NAME,MEMBER_NAME,AUTHOR,ISSUE_DATE
FROM
BOOK_C_VIJAY B,MEMBER_C_VIJAY M,ISSUE_C_VIJAY I
WHERE ((B.COST>500 AND B.COST<750) AND (B.CATEGORY='RDBMS' OR B.CATEGORY='DATABASE') AND
I.BOOK_NO=B.BOOK_NO AND I.MEMBER_ID=M.MEMBER_ID));

QNO : 8
CREATE VIEW VIJAY1 AS(SELECT BOOK_NAME FROM BOOK_C_VIJAY WHERE COST>500);

QNO : 9

QNO : 10

Re: NAKRA final

kubben29-Jun-07 1:50

kubben

29-Jun-07 1:50

Thanks for posting your sql code, I have no idea if you have a question on this. You also posted it to the asp.net forum I think this may belong to the sql forum.

Ben

Re: NAKRA final

Vasudevan Deepak Kumar29-Jun-07 2:12

Vasudevan Deepak Kumar

29-Jun-07 2:12

It might be addressed to a particular person (his friend) or somebody. Some peole use such cheap tricks to exchange code snippets through discussion forums since thier corporate networks might be preventing Webmails on thier desktops.

At least, they could have used 'Email' option instead of openly posting the SQL code.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: NAKRA final

kubben29-Jun-07 2:23

kubben

29-Jun-07 2:23

When I checked the sql forum and saw it posted four or five times there, I got the picture. Kind of silly if you ask me.

Ben

web user control

kvijayajyothy29-Jun-07 1:32

kvijayajyothy

29-Jun-07 1:32

i want create ascx page . i want to create lookup design

vijaya

vijaya

Re: web user control

kubben29-Jun-07 1:45

kubben

29-Jun-07 1:45

Not sure what your question is here. In your web project add a new item it is called web user control. Inside that control do your lookup design. Then when you want to include it into a web page you need two lines of code:
First you register the user control, so at the top of the page right below the <@ Page directive you need something similar to this:
<%@ Register TagPrefix="uc1" TagName="LookupControl" Src="~/Controls/LookupDesign.ascx" %>

Then in your code you need to add this:
<uc1:LookupControl ID="_lookupControl" runat="server" />

Don't know if that answered your question or not.

Ben

Re: web user control

kvijayajyothy29-Jun-07 2:17

kvijayajyothy

29-Jun-07 2:17

i have form which displays data in grid based on query passed and condition selected.

now i want to call that page
in any page when i click on button

so what is the best method?

so i thought ascx is best method
i used
<cc1:hovermenuextender id="HoverMenuExtender1" runat="server" popupcontrolid="pnl1" popupposition="Bottom" targetcontrolid="Button1">
<asp:panel id="pnl1" runat="server">
<myc:cal id="abc" runat="server">

lookup page goes off when i place currsor out side the pan and even when i click on any option in the lookup panel like dropdown list

vijaya

Re: web user control

kubben29-Jun-07 2:22

kubben

29-Jun-07 2:22

If you have multiple places where you want to have the same control, yes it is a good idea to use a user control. That would be a good solution.

Ben

Re: web user control

Vasudevan Deepak Kumar29-Jun-07 2:15

Vasudevan Deepak Kumar

29-Jun-07 2:15

kvijayajyothy wrote:
i want create ascx page

From the solution explorer, navigate to the folder and right click 'Add New Web User Control'.

kvijayajyothy wrote:
i want to create lookup design

Your web designer should be able to advise this on. Or if you are a web designer yourself, try using Dreamweaver or Frontpage.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

What are Macros?

vijay_8329-Jun-07 1:28

vijay_83

29-Jun-07 1:28

What is meant by Macros and why do we use macros in .net? Is Macros essential in .net? anybody pls explain me abt Macros in detail....

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.