Comments by shajis001 (Top 12 by date)

Select id from product where id in (1 ,2 ,3 , .................. ,n)

any suggestions or ideas welcome.

Rob Philop Is creating a view solve this problem or not because i am planning to go with that approach.

I have created a view

<pre lang="SQL">CREATE VIEW CommonTable AS

SELECT 'Admin' AS userTable, * FROM Admin

UNION ALL

SELECT 'Student' AS userTable, * FROM Student

UNION ALL

SELECT 'Parent' AS userTable, * FROM Parent

UNION ALL

SELECT 'Teacher' AS userTable, * FROM Teacher
</pre>

I tried creating one array
var stockVal = ["symbol","Name","Change"];

I want to get this much vallue.
When i am trying to check the length of data

console.log(data.query.results.quote.length);


is displaying 1 actually i want to get the length of attributes inside quote how can i do this..

But tadit one more help quote containing symbol "YHOO"
AverageDailyVolume "17498000"
Change "-0.29"
DaysLow "38.1131"
DaysHigh "38.45"
YearLow "20.58"
YearHigh "41.72"
MarketCapitalization "39.712B"
LastTradePriceOnly "38.23"
DaysRange "38.1131 - 38.45"
Name "Yahoo Inc."
Symbol "YHOO"
Volume "9987016"
StockExchange "NasdaqNM"
this much value how can i display all

Can you explain it briefly

If i give alert(data); i am getting a prompt [object Object]