Database

Re: Database fields for forum project

11-Jun-08 4:40

Make one up - its not a difficult question is it? Please don't post homework questions, its pointless.

Bob
Ashfield Consultants Ltd

Colin Angus Mackay11-Jun-08 5:03

Colin Angus Mackay

11-Jun-08 5:03

What about tables? Surely a forum requires multiple tables.

Recent blog posts:
* Introduction to LINQ to XML (Part 1) - (Part 2) - (part 3)

My website | Blog

Re: Database fields for forum project

Pete O'Hanlon11-Jun-08 8:50

Pete O'Hanlon

11-Jun-08 8:50

Colin Angus Mackay wrote:
What about tables? Surely a forum requires multiple tables.

Nah - it can be done in one access table with 450 fields. Just call them Field1, Field2, Field3, ..., FieldN.

Deja View - the feeling that you've seen this post before.

My blog | My articles

a child row has multiple parents [modified]

Kjetil Svendsen11-Jun-08 2:17

Kjetil Svendsen

11-Jun-08 2:17

Hi All

I have 4 tables in a dataset:
ACTIVITY
ACTIVITY_PARTICIPANT related to ACTIVITY (nested)
PERSON related to ACTIVITY_PARTICIPANT (nested)
ROLE related to ACTIVITY_PARTICIPANT (nested)

if one person i related several times to one activity, with different roles, I get the "a child row has multiple parents" error.

I understand why I get the error Smile | :)

My question is:
How could I produce this xml
<DATASET>
<ACTIVITY>
<ACTIVITY_PARTICIPANT>
<ROLE ID="1" />
<PERSON NAME="PERSON A" />
</ACTIVITY_PARTICIPANT>
<ACTIVITY_PARTICIPANT>
<ROLE ID="2">
<PERSON NAME="PERSON A" />
</ROLE></ACTIVITY_PARTICIPANT>
</ACTIVITY>
</DATASET>

from my dataset. Is there a method, or do I have to write it myself ?

I guess I have to start with
ACTIVITY
ACTIVITY_PARTICIPANT related to ACTIVITY (nested)
PERSON related to ACTIVITY_PARTICIPANT (NOT nested)
ROLE related to ACTIVITY_PARTICIPANT (NOT nested)

Thans in advance

Kjetil

modified on Wednesday, June 11, 2008 8:55 AM

Stored Procedures Out Put Parameter Returns Null What is missed.

greekius11-Jun-08 2:17

greekius

11-Jun-08 2:17

I created a table for keeping Configuration parameters. When i wanna get the value via stored proc, i got null. Could u check me my stored procedure pls.

CREATE PROCEDURE [dbo].[sp_GetConfigurationParameter]
@Key char(4),
@Type char(4),
@Value nchar   OUTPUT
AS
SET NOCOUNT ON;
SELECT @Value=[Value] FROM VpConfParameters WHERE [Type]=@Type AND [Key]=@Key

To Try

declare @Value nchar
EXEC [sp_GetConfigurationParameter] 'DBNL','DEVE',@Value
select @Value

Result
NULL :'(

Re: Stored Procedures Out Put Parameter Returns Null What is missed.

SomeGuyThatIsMe11-Jun-08 2:43

SomeGuyThatIsMe

11-Jun-08 2:43

assuming that there is data that matches your query in the table, you could forego the output parameter and just select [Value] then your exec statement would be

declare @Value nchar
EXEC @value = [sp_GetConfigurationParameter] 'DBNL','DEVE',@Value
select @Value

I know that works in sql server 2k, and i'm fairly certain it wont work in oracle.

Alcohol the cause of and solution to all of life's problems.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Stored Procedures Out Put Parameter Returns Null What is missed.

greekius11-Jun-08 3:02

greekius

11-Jun-08 3:02

i use sql 2005 server

Re: Stored Procedures Out Put Parameter Returns Null What is missed.

SomeGuyThatIsMe11-Jun-08 4:18

SomeGuyThatIsMe

11-Jun-08 4:18

as far as i know you can still select values out of a usp in sql server 2k5.

Alcohol the cause of and solution to all of life's problems.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Stored Procedures Out Put Parameter Returns Null What is missed.

Ashfield11-Jun-08 4:45

Mixing Select Into and Appending Data

11-Jun-08 4:45

You have missed OUTPUT in your test

greekius wrote:
declare @Value nchar
EXEC [sp_GetConfigurationParameter] 'DBNL','DEVE',@Value
select @Value

Should be

declare @Value nchar
EXEC [sp_GetConfigurationParameter] 'DBNL','DEVE',@Value <big>OUTPUT</big>
select @Value

Bob
Ashfield Consultants Ltd

prithaa11-Jun-08 1:00

11-Jun-08 1:00

Hello,

I have the following query where I want to append to the existing table SalePrice and the the third coilumn SalePrice = 199 which is wrong .
Can you correct it ?
Can you sugest me sites to improve my query writing.

SELECT timeperiod.timeperiod,product.product,
convert(int,199) as SalePrice
INTO SalePrice FROM timeperiod,product where Product='Shirt199Light'

Can you

Ashfield11-Jun-08 2:56

11-Jun-08 2:56

Ok, so you didn't really like my answer last time. What you want then is a variation on it.

SELECT timeperiod.timeperiod,product.product, 
cast(null as int) as SalePrice 
INTO SalePrice FROM timeperiod,product where Product='Shirt199Light'

Bob
Ashfield Consultants Ltd

prithaa11-Jun-08 5:49

11-Jun-08 5:49

Hello,

Your last answer was very helpful and I think asking the variation was really silly on my part but from where did you get these 'cast' and 'convert' 'as' keywords.

I have visited SQL sites but they don't offer anyting more than the basic SELEC,INSERT,WHERE keywords.

I will search for more sites and hope not to bother you much.
Thanks for your answer.

Pritha

prithaa11-Jun-08 6:37

11-Jun-08 6:37

Hello,

The above query does not add record to the existing table.It says
'There is already an object named 'SalePrice' in the database.'

I want to add records to an existing table where all the 3 columns exist.

Thanks.
Pritha

prithaa11-Jun-08 7:19

Re: Connect to DB2 database

11-Jun-08 7:19

Hello,

I have got how to insert record
But are there any sites that offer help with such mix and match in SQL.

Prithaa

Connect to DB2 database

Sankalp Verma11-Jun-08 0:47

Sankalp Verma

11-Jun-08 0:47

Hi all,

I want to connect to DB2 database in my application. IS there any command line utility for the same or is there any way I may program it. My application is based on C#.net.

Thanks,
Sankalp

Vasudevan Deepak Kumar11-Jun-08 1:22

Vasudevan Deepak Kumar

11-Jun-08 1:22

Check this out:

http://www.codeproject.com/KB/database/DotnetDb2.aspx[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

All the world's a stage,
And all the men and women merely players.
They have their exits and their entrances;
And one man in his time plays many parts... --William Shakespeare

Convert crystal report to text file

Krazy Programmer10-Jun-08 21:29

Krazy Programmer

10-Jun-08 21:29

hello friends
I want to convert crystal report to txt format * not rtf

Inner properties do support rtf,pdf and other formats but not txt

Thanks

Krazy Programmer

If You win You need not Explain............
But If You Loose You Should not be there to Explain......

update same table in 3 different databases

Dushan12310-Jun-08 20:05

Dushan123

10-Jun-08 20:05

I need to update same table in 3 different databases. All database Name contains word user. I want to write sql query update those tables. I am using sql server 2000. please help me this is very agent

ssss

Ashfield10-Jun-08 21:02

10-Jun-08 21:02

If its a one off:

begin tran

update database1.dbo.table set .....
update database2.dbo.table set .....
update database3.dbo.table set .....

commit tran

You need to put some error checks and rollback, but you get the idea. If its an ongoing requirement you ought to consider replication

Hope this helps

Bob
Ashfield Consultants Ltd

Dushan12310-Jun-08 23:47

Dushan123

10-Jun-08 23:47

Actually I don't no the exactly name of the database. I only know the database name contains the word "User". Plese can u help me

ssss

Ashfield11-Jun-08 3:02

11-Jun-08 3:02

You need to generate some dynamic sql then. You can the update statements from master..sysdatabases

select 'update ' + name + '.dbo.table set ...' from master..sysdatabases
where name like '%user'

All you need to do then is put it in loop and execute it, or something similar - there are loads of ways from this point.

Bob
Ashfield Consultants Ltd

Mixing Select into and Create

Dushan12311-Jun-08 3:30

Dushan123

11-Jun-08 3:30

thanks

ssss

prithaa10-Jun-08 20:03