Database

Re: Select spaces and then the value???

Support12322-Nov-07 23:22

Support123

22-Nov-07 23:22

i though i had it figured out too...

But now with the space() function... i can get the result i am looking for without using variables.

Thank you for your time

"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

Re: Select spaces and then the value???

Support12322-Nov-07 23:53

Support123

22-Nov-07 23:53

Sorry....

But what does the right( do (i used select right(space(20) + 'TEST', 25)? i tested the also with select left(space(20) + 'TEST', 25)... i did not notice a difference.

What does the left or right do in this section?

"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

Re: Select spaces and then the value???

Cristian Amarie26-Nov-07 8:00

Cristian Amarie

26-Nov-07 8:00

select replicate('.', 9 - len(ltrim(rtrim(TestColumnValue)))) + ltrim(rtrim(TestColumnValue))
from YourTable

and this will left prefix with '.' character your field.

Nuclear launch detected

DBGRID

mahenputta22-Nov-07 20:11

mahenputta

22-Nov-07 20:11

HI friends..
i want to display row wise values in the oracle table..TO THE columnwise of the DB GRID IN DELPHI..(ROWWISE VALUES TO COLUMNWISE... FROM ORACLE TABLE TO DBGRID IN DELPHI)
THANKS
MAHEN

Re: DBGRID

pmarfleet22-Nov-07 20:54

pmarfleet

22-Nov-07 20:54

This site deals with Microsoft technologies. You would be better off asking your question on a Delphi site.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

How to Know Db's Column is null or not ?

tr_thorn22-Nov-07 19:40

tr_thorn

22-Nov-07 19:40

Hi ,

i have got a datagridview object in my form..When i click a cell i wanna know if dg.currentrow[5].cell.value == null or not . . . . . .

thanx ...

Re: How to Know Db's Column is null or not ?

pmarfleet22-Nov-07 21:17

pmarfleet

22-Nov-07 21:17

tr_thorn wrote:
When i click a cell i wanna know if dg.currentrow[5].cell.value == null or not

Try Convert.IsDBNull(dg.currentrow[5].cell.value).

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

[Message Deleted]

DotNet22-Nov-07 5:06

DotNet

22-Nov-07 5:06

[Message Deleted]

Re: Please explain: JOIN ON thinggy? It's confusing.

pmarfleet22-Nov-07 5:16

pmarfleet

22-Nov-07 5:16

Did you try to find the answer yourself before posting?

It took me 3 seconds to find this[^].

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: Please explain: JOIN ON thinggy? It's confusing.

DotNet22-Nov-07 5:21

DotNet

22-Nov-07 5:21

Yes, I even try to figure out the reason, I'm puzzled still.

Why can't be -> sp.StateProvinceID = p.StateProvinceID, instead of p.StateProvinceID = p.StateProvinceID ?

NEWBIES - Aaron

Re: Please explain: JOIN ON thinggy? It's confusing.

pmarfleet22-Nov-07 6:16

pmarfleet

22-Nov-07 6:16

DotNet wrote:
Why can't be -> sp.StateProvinceID = p.StateProvinceID, instead of p.StateProvinceID = p.StateProvinceID ?

It's a typo. It should be

sp.StateProvinceID = p.StateProvinceID

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: Please explain: JOIN ON thinggy? It's confusing.

DotNet22-Nov-07 14:01

DotNet

22-Nov-07 14:01

Thanks a lot, Paul...

NEWBIES

How Enable/Disable Remote Connection by Script

DotNetWWW22-Nov-07 1:51

DotNetWWW

22-Nov-07 1:51

hi , how can I Enable/Disable Remote Connection by Script?
thanks in advance

Re: How Enable/Disable Remote Connection by Script

Cristian Amarie26-Nov-07 8:03

Cristian Amarie

26-Nov-07 8:03

select answer from forums where forum_name like '%remote%'

This is the forum for SQL/ADO/ADO.NET. Your remote connection question have little chances to get an answer here...

Nuclear launch detected

Rock Star.22-Nov-07 1:37

Rock Star.

22-Nov-07 1:37

Hi,
Anyone knows how to use login control and how to connect it with the SQl server 2005 and connect to the table within my application database. So it can match the values from the table I have already created in my database.

Rock Star

Cross post. Please ignore this thread.

Pete O'Hanlon22-Nov-07 2:17

Pete O'Hanlon

22-Nov-07 2:17

See the title.

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

My blog | My articles

Re: Cross post. Please ignore this thread.

Paul Conrad23-Nov-07 8:30

Paul Conrad

23-Nov-07 8:30

I shall ignore Roll eyes | :rolleyes:

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

dividing

legend_of_zanado22-Nov-07 1:37

legend_of_zanado

22-Nov-07 1:37

select (5/7) always result 0 .... how can i correct this result ?
plz help Frown | :(

Re: dividing

andyharman22-Nov-07 1:53

andyharman

22-Nov-07 1:53

SQL-Server assumed that you wanted an integer result because both of the operands were integers.

Try: select convert(float, 5) / 7

Regards
Andy

how to make many foreign key from one table [modified]

Xmen Real 22-Nov-07 0:50

Xmen Real

22-Nov-07 0:50

hi there,
i have 2 table, first have 2 columns(ID, Name) here ID is primary key
second have 9 columns (ID, 1, 2, 3, ... 8) here ID is primary key too

in second table column names from 1 to 8 have ID Numbers from Table First(which is primary)
and i want to make them foreign keys (from 1 to 8) so that if i delete ID from first table then the action that is set to "Set Null" will set that cell to null
for example
first table have data like this
[ID] [Name]
15 ABC
16 ERT
17 GHJ
18 LKI

in second table :
[ID]_[1]__[2]__[3]__[4]__[5]__[6]__[7]__[8]
14___16___18___17___15___17___17___15___15
15___18___18___17___16___18___18___17___15
16___15___18___16___15___17___17___16___15

now what i want, if i delete ID 16 from first table then the value 16 in table second shoul be set to "null" (from 1 to 8) so it will look like this:

[ID]_[1]__[2]__[3]__[4]__[5]__[6]__[7]__[8]
14________18___17___15___17___17___15___15
15___18___18___17________18___18___17___15
16___15___18________15___17___17________15

to do that i make 8 relationships, and set all actions as
update = cascade
delete = set null
but when i save it, it give error

'firsttable' table saved successfully
'secondtable' table
- Unable to create relationship 'FK_secondtable_II_firsttable'.
Introducing FOREIGN KEY constraint 'FK_secondtable_II_firsttable' on
table 'secondtable' may cause cycles or multiple cascade paths.
Specify ON DELETE NO ACTION or ON UPDATE NO ACTION,
or modify other FOREIGN KEY constraints.
Could not create constraint. See previous errors.

i want both actions, but sql is not allowing me to do that

it can be done by this, but i dont want to use this method

update secondtable set [1] = NULL where [1] = 
update secondtable set [2] = NULL where [2] = 
update secondtable set [3] = NULL where [3] = 
update secondtable set [4] = NULL where [4] = 
update secondtable set [5] = NULL where [5] = 
update secondtable set [6] = NULL where [6] = 
update secondtable set [7] = NULL where [7] = 
update secondtable set [8] = NULL where [8] =

some have any solution?
thanks

-- modified at 7:26 Thursday 22nd November, 2007

Becoming Programmer...

Regarding select Date

Aavesh Agarwal21-Nov-07 22:33

Aavesh Agarwal

21-Nov-07 22:33

Hi,

I am having a problem.Actually what i want is to find the Dates between particluar Dates like how many dates between two dates.For this i dont have any table.Then after i want to store this resultset in the Temporary Table.
i have done lots of RNd but didn't get the ans.
Thanks in Advance
Avesh

Re: Regarding select Date

joemonvarghese21-Nov-07 23:58

joemonvarghese

21-Nov-07 23:58

hi
you have to give the values for from date and todate

while @fromdate<=@todate
begin
insert into #Temp(fdate) values(@fromdate)
set @fromdate=dateadd(day,1,@fromdate)
end

Regards
Joe

How to run Dynamic SQL Query Securely?

DotNetWWW21-Nov-07 22:31

DotNetWWW

21-Nov-07 22:31

Hi all ,
What's the most secure way for executing dynamic sql from a .Net App in your opinion?

Thanks in advance ,

Re: How to run Dynamic SQL Query Securely?

Colin Angus Mackay21-Nov-07 22:46

Colin Angus Mackay

21-Nov-07 22:46

A few quick tips:
* Use parameters as much as possible.
* Validate EVERYTHING.
* If you are needing to dynamically set the name of tables or columns then have your SQL check the existance of the table first (A lookup on INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS will help here - remember to use parameters to pass the table name)
* Validate EVERYTHING.
* Run the code in the most restrictive account possible.
* Validate EVERYTHING.* Call stored procedures and have the SP validate the parameters and generate the dynamic SQL.
* Validate EVERYTHING.

Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland

My website

Bulk Export Task

RAGHAVENDRAN200721-Nov-07 20:22

RAGHAVENDRAN2007

21-Nov-07 20:22

Hi,
I am in the process of transferring the data from MSSQl database to MYSQL D'Oh! | :doh:

database.
I went through a code snippet which as in vb, in transferring the data (I mean content of tables).
I got this info from SQL DTS.com (Bulk Export Task) can any one here who did this sort of job earlier using C#?
I downloaded the required dll but wanna to have a code snippet in C#.
If any one knows please help me.

Thank you in advance
Raghavendran. Rose | [Rose]

Raghavendran

General News Suggestion Question Bug Answer Joke Praise Rant Admin

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