Database

Re: How to select 1 entry without using "top 1" in SQL query?

8-Oct-02 14:54

If it ain't broke... why do you want to fix it?

Paul

Anonymous8-Oct-02 16:19

Anonymous

8-Oct-02 16:19

Because, this is just part of my query, if I use top 1, then, I can't get other entries required by some other conditions. So, basically, on that part I mentioned in my previous mail, I just want the last failed entry with any task name. Any suggestions?

Re: How to select 1 entry without using "top 1" in SQL query?

Jon Hulatt9-Oct-02 0:34

Jon Hulatt

9-Oct-02 0:34

Can't really answer without seeing the rest of your query, but you may be able to achieve what you're trying with a subquery:-

select a.a,b.b,c.c
from table_a a (nolock)
inner join table_b b (nolock)
inner join ( select top 1 * from table_c (nolock)) c

Signature space for rent. Apply by email to....

Re: How to select 1 entry without using "top 1" in SQL query?

Nick Parker9-Oct-02 1:43

Nick Parker

9-Oct-02 1:43

Anonymous wrote:
Because, this is just part of my query, if I use top 1, then, I can't get other entries required by some other conditions.

Use the Top 1, you can use the UNION statement to make multiple selects like this to match all of your criteria:

SELECT a, b, c, d FROM table_one WHERE a = 5

UNION 

SELECT a, b, c, e FROM table_one WHERE a = 6

UNION

SELECT a, b, c, f FROM table_one WHERE a = 7

UNION 

SELECT a, b, c, g FROM table_one WHERE a = 8

HTH

Nick Parker

The goal of Computer Science is to build something that will last at least until we've finished building it. - Unknown

Updating Access Queries using SQL?

Paul Riley8-Oct-02 14:24

8-Oct-02 14:24

I may need to be able to create and update Access 2000 Queries using SQL commands. Is that even possible? I'm using ADO.NET if that, for some reason I've missed, makes life easier.

Paul

Mazdak9-Oct-02 9:21

Mazdak

9-Oct-02 9:21

Paul Riley wrote:
Is that even possible?

Yes.Why not!

Mazy

"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down

Paul Riley9-Oct-02 11:45

9-Oct-02 11:45

Mazdak wrote:
Yes.Why not!

Well... because I don't know how to do it and thus I have to accept the unlikely possibility that it just can't be done.

So, Mazy, do you happen to know how to do it? Poke tongue | ;-P

Paul

Mazdak9-Oct-02 23:12

Mazdak

9-Oct-02 23:12

When you use ADO.NET,you use sqlCommand class for SQLServer database,now here for Access database you have to use OleDbCommand class.

Mazy

"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down

Paul Riley9-Oct-02 23:36

Output Nested Set Model to XML using MS SQL2K

9-Oct-02 23:36

Mazdak wrote:
When you use ADO.NET,you use sqlCommand class for SQLServer database,now here for Access database you have to use OleDbCommand class.

Blush | :O

Ooops! That's not what I meant. I get OleDbCommand, although I'm using OdbcCommand.

I mean that I want to create an actual Access Query inside the Access database. Some quite complicated things that I'm going to have to do repeatedly so I don't want the SQL to be in my code, where one bug means fixing it in ten places. I want to get the Query into the database and read that. But it'll be a live database, so downloading it, updating it and then uploading it again will mean shutting the web site down.

I will have a direct SQL page that only I can get at, so it would be really convenient if I can just say "Add Query..." in the same way I can add a table.

The alternative is getting the guy who owns the server to update it (which is not beyond the realms of possibility, but it is a pain).

Paul

Ingram Leedy8-Oct-02 9:34

Ingram Leedy

8-Oct-02 9:34

Anyone any experience of outputting a nested set model (to an XML
structure using Microsoft SQL Server? Would like to read in as a stream using ExecuteXmlReader.

For details on Nested Set Model, see the chapter in JOE CELKO'S SQL FOR SMARTIES (Morgan-Kaufmann, 1999, second edition)
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci801943,00.html

> For example using the following table and TSQL I can extract an
> employee and their subordinates.
>
> Personnel
> emp lft rgt
> ======================
> 'Albert' 1 12
> 'Bert' 2 3
> 'Chuck' 4 11
> 'Donna' 5 6
> 'Eddie' 7 8
> 'Fred' 9 10

Example XML output:

<root>
<node emp="Albert">
<node emp="Bert"/>
<node emp="Chuck">
<node emp="Donna"/>
<node emp="Eddie"/>
<node emp="Fred"/>
</node>
</node>
</root>

This works, but isnt an XML stream:

SELECT xml1.xmltext
FROM
(SELECT lft, xmltext = '<node emp="' + emp + '">' FROM Personnel
UNION ALL SELECT rgt, xmltext = '</node>' FROM Personnel) AS xml1
ORDER BY xml1.lft

-- Ingram Leedy

reading Excel from ASP.NET

ViteshAggarwal8-Oct-02 2:39

ViteshAggarwal

8-Oct-02 2:39

Hi,
I am using the following code to read a exel file from a AS.NET page , but its not working.
Pls help...

string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=D:\\Documents\\EServer\\ProjectCodes.xls;"
+"Extended Properties=Excel 8.0;";

//You must use the $ after the object you reference in the spreadsheet
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);

DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "ProjectCodes");// This line is giving the error !

DataGrid1.DataSource = myDataSet.Tables"ProjectCodes"].DefaultView;

DataGrid1.DataBind();

Re: reading Excel from ASP.NET

Ed Gadziemski8-Oct-02 4:46

Ed Gadziemski

8-Oct-02 4:46

What is the error message? Also, you have an extra bracket in the second to last line (DataGrid1.DataSource). Is that a problem?

Re: reading Excel from ASP.NET

Carlos Antollini10-Oct-02 6:27

Carlos Antollini

10-Oct-02 6:27

I Use the following from VC++, I hope that will be the same:

strConnection = _T("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;"
		"Dbq=C:\\DatabasePath\\DBSpreadSheet.xls;DefaultDir=c:\\databasepath;");

If you prefer to use Ole DB you connection srting is correct...
Where you recibe an error?

Regards

Carlos Antollini.
Sonork ID 100.10529 cantollini

reading Excel file from ASp.NEt

ViteshAggarwal8-Oct-02 2:36

ViteshAggarwal

8-Oct-02 2:36

XMLA Function Parser

Anonymous7-Oct-02 7:53

Anonymous

7-Oct-02 7:53

Well I am in need of a MDX function parser and do not want to reinvent the wheel.

anyone know where I can find one?

MS acess for ASP

Sarvesvara (BVKS) Dasa6-Oct-02 23:30

6-Oct-02 23:30

HI all....

Can u help me in this,

I have MS Office 2000 installed with all options. I want to setup a database using the MS-Access, to access the database for my ASP applications. What should I do?

Mine is Windows 2000 professional.

Thanks in advance,
SPS

Jon Hulatt7-Oct-02 0:29

Jon Hulatt

7-Oct-02 0:29

1. Look at some articles right here on codeproject
2. read a book
3. search the web.

Signature space for rent. Apply by email to....

Sarvesvara (BVKS) Dasa7-Oct-02 6:42

7-Oct-02 6:42

Great help and good idea. Wont forget this forever.

Happy day.....

Nick Parker7-Oct-02 8:45

Nick Parker

7-Oct-02 8:45

SPS wrote:
What should I do?

I agree with what Jon wrote as you will only understand more as you read, so I thought this article[^] will show you an example to go off of. Smile | :)

HTH

Nick Parker

The goal of Computer Science is to build something that will last at least until we've finished building it. - Unknown

Sarvesvara (BVKS) Dasa7-Oct-02 9:38

7-Oct-02 9:38

Thanks a lot. But I am need need to configure my ODBC driver. I guess, I know what to do after getting the ODBC connected.

Anyway, thanks for the help indeed.

James T. Johnson7-Oct-02 11:32

James T. Johnson

7-Oct-02 11:32

Nick Parker wrote:
so I thought this article[^] will show you an example to go off of.

OMG | :OMG:

Thats the exact same article that got me started with using databases from ASP Smile | :)

James
Sig code stolen from David Wulff

Sarvesvara (BVKS) Dasa7-Oct-02 17:30

7-Oct-02 17:30

Will give a try at that.... Thanks.........

Nick Parker8-Oct-02 2:52

Nick Parker

8-Oct-02 2:52

James T. Johnson wrote:
"So, if you are interested in watching the rate of hair loss, are you going to hook up a callback to each follicle?
Personally, I'd rather just hook up the comb, and let it tell me when a hair gets stuck in there. Any interesting information I need about why the little deserter abandoned post I can get from the hair itself as a member of the HairLossEventArg type.
Interestingly, my hair loss is a result of inheritance, which I can also use to extend my hair... What's up with that?"
Ed Stegman on event granularity

Ed sounds like he read a little too much into Chris Sells .NET Delegates: A C# Bedtime Story[^] article. Smile | :)

Nick Parker

The goal of Computer Science is to build something that will last at least until we've finished building it. - Unknown

Sarvesvara (BVKS) Dasa8-Oct-02 8:06