Re: need solution for storing '(single quotation) in sql database - Database Discussion Boards

Re: Help on a query

andyharman13-Feb-07 22:50

andyharman

13-Feb-07 22:50

Have you tried using sub-select statements? For example:

select Vendor.VCode,
   (select sum(SalesLine.Quantity) from SalesLine
   inner join SalesLine
     on SalesLine.SaleCode = Sale.SaleCode
   where Sale.VCode = Vendor.Vcode) as SumProductQty
   --other sub-selects go here
from Vendor
order by Vendor.VCode

The sub-selects are allowed to reference fields within the Vendor table.
Regards
Andy

Re: Help on a query

logicon13-Feb-07 23:03

logicon

13-Feb-07 23:03

I am using MS Access 2003, I think it doesnot supports this.

Thanks

Re: Help on a query

Pete O'Hanlon13-Feb-07 23:25

Pete O'Hanlon

13-Feb-07 23:25

The only way to find out is to try it. Saying that, I do believe that Access supports this because this is a standard SQL technique and not a vendor/tool specific one.

the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer

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

How can I use multiple queries

N a v a n e e t h13-Feb-07 20:15

N a v a n e e t h

13-Feb-07 20:15

Hello

How can i use ado.net to send multiple queries to database and perform them. Example, I need to create a stored procedure programatically from my application. any way to do that. or is it possible to execute some transact sql statements like

declare @value as money
select @value = 10

How can i display the messages send by SQL server after executing queries in my application ?

Please help

Cheers
Navaneeth!!

Re: How can I use multiple queries

Colin Angus Mackay13-Feb-07 23:55

Colin Angus Mackay

13-Feb-07 23:55

You can put just about any SQL you like in a SqlCommand. So, yes, you can create stored procedures from your application.

Navaneethkn wrote:
How can i display the messages send by SQL server after executing queries in my application ?

I've never needed to do this, so I don't know. However, if the SQL causes an exception to be thrown the messages will be in the exception message.

What's in the messages that you want back?

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

need solution for storing '(single quotation) in sql database

Tech_spidy13-Feb-07 20:14

Tech_spidy

13-Feb-07 20:14

I developed an project in vb for storing some quotations in sql db and displaying it on ASP web page on daily basis. when i am adding quotes in the database, whenever i am using single quotation mark i am getting some run time error .. i need a solution to solve this problem.

Give me an instant solution to rectify this problem

regards, D'Oh! | :doh:

Tech_spidy

Re: need solution for storing '(single quotation) in sql database

N a v a n e e t h13-Feb-07 20:16

N a v a n e e t h

13-Feb-07 20:16

Hi
Replace single quotation with double quotation before sending to database.

it will be like this

comment's will be comment''s

Cheers
Navaneeth!!

Re: need solution for storing '(single quotation) in sql database

Tech_spidy13-Feb-07 20:34

Tech_spidy

13-Feb-07 20:34

hi Navaneeth,

thanks for ur immediate response.. see while displaying some motivational quotes like, it wouldn't look good.. In official sites we can't go display like this.

thanks for ur temprory solution. if you/anyone know the exact solution please reply..

regards, Frown | :(

Tech_spidy

Re: need solution for storing '(single quotation) in sql database

WoutL13-Feb-07 21:13

WoutL

13-Feb-07 21:13

Hi,

I think Navaneeth mend to say: Replace the single quotation by two single quotations.

Wout Louwers

Re: need solution for storing '(single quotation) in sql database

N a v a n e e t h13-Feb-07 21:39

N a v a n e e t h

13-Feb-07 21:39

Hi Tech_Spidy

Don't worry. In database only single quote will be stored. It won't store '' in table.

Cheers
Navaneeth!!

Re: need solution for storing '(single quotation) in sql database

Tech_spidy14-Feb-07 2:51

Tech_spidy

14-Feb-07 2:51

Thank you so much navaneeth..
wht u suggested is exactly working..

regards Smile | :)

Tech_spidy

Re: need solution for storing '(single quotation) in sql database

Colin Angus Mackay13-Feb-07 21:58

Colin Angus Mackay

13-Feb-07 21:58

Use parameters to insert strings in to the database. That way you don't have to escape quotation marks. And you improve the security of your application.

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Re: need solution for storing '(single quotation) in sql database

Tech_spidy13-Feb-07 22:58

Tech_spidy

13-Feb-07 22:58

ok.. i will try tht.

thanks for ur response.

regards Smile | :)

Tech_spidy

Re: need solution for storing '(single quotation) in sql database

Krish - KP13-Feb-07 23:43

Krish - KP

13-Feb-07 23:43

In SQL 2000 there is some thing called
SET QUOTEDIDENTIFIER ON/OFF

Pls check this. would help you.

Re: need solution for storing '(single quotation) in sql database

Tech_spidy14-Feb-07 2:54

Tech_spidy

14-Feb-07 2:54

thanks for ur response krish. but i m using sql server for this wat navaneeth suggested is working exactly .
regards Smile | :)

Tech_spidy

How to get radio button values in sql 2000

rrrriiizz13-Feb-07 19:57

rrrriiizz

13-Feb-07 19:57

Hello all

am creating simple application in vb.net 2005 sql server 2000 as my back end,
My problem is for gender identification am creating Radio buttons in the Frontend. How do I Specify data type (varchar/ navarchar/float) for that Radio buttons? How i store its value in the back End? Please help me Frown | :(

Re: How to get radio button values in sql 2000

N a v a n e e t h13-Feb-07 20:18

N a v a n e e t h

13-Feb-07 20:18

Hi
In my point of view, you can store the values as varchar. If it is male then store in table like M. When fetching the data, check if that is M.

Cheers
Navaneeth!!

Re: How to get radio button values in sql 2000

M A A Mehedi Hasan13-Feb-07 20:36

M A A Mehedi Hasan

13-Feb-07 20:36

Hello,
You can use bit data type if your gender is limited to male/female. If your gender is more than 2 types i.e. male/female/unknown then you can use tinyint or int.

Thanks

Mehedi Hasan

Want a sql query or any solutation

vnsraj13-Feb-07 19:51

vnsraj

13-Feb-07 19:51

how i will do this in C#?

list all doctors whose birthday falls between the coming weeks Wednesday and next week Tuesday. The client will run this report every week. So say the client runs it on 12th February which is a Monday it will list all doctors whose birthday is between 14th-20th Feb.

Re: Want a sql query or any solutation

Krish - KP13-Feb-07 23:55

Krish - KP

13-Feb-07 23:55

try using these functions
getdate()
datepart()
dateadd()

SQL server in to XML

indian14313-Feb-07 19:37

indian143

13-Feb-07 19:37

Hi all,
How can I convert all the data that is present in SQL server in to XML format. If its big, then atleast provide me some link. Thank you.

Regards,

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

Re: SQL server in to XML

N a v a n e e t h13-Feb-07 21:42

N a v a n e e t h

13-Feb-07 21:42

Hi
Fill a dataset with your data from SQL database. User dataset's write XML function to create XML file.

OR

Read the database row by row and write each row using xml text reader

Cheers
Navaneeth!!

Re: SQL server in to XML

indian14322-Feb-07 21:01

indian143

22-Feb-07 21:01

Sorry for the late reply, but I need it without using the .Net coding. And from SQL server tools or from any other database tools. Please help me if you could. Thank you.

Regards,
Mohd. Abdul Aleem,

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

relatioships & datasets? [sqlservr 2005 , C# 05]

giddy_guitarist13-Feb-07 19:32

giddy_guitarist

13-Feb-07 19:32

Hi ,

i've just started using slq server 2005 express. I know how to put a table into a dataset and then if i have two datasets i can make a relation between them via code[DataRelation].But why then , do we make relations in the database itself?

My scenario:

In my DB I have Three tables:
Persons : PID , Name
Items: ItID , Name
Purchases PID , ItID.
[there are 2 relations FK_Purchases_PID , FK_Purchases_ItID]

I have listboxes on my plain app , one of them is filled with the persons names. Now if i click a particular name i should get the corresponding purchases?
If i load each table into a dataset and then remake the relatioships via code it seems silly.

Would someone show me the best way to do the aforementioned? Confused | :confused:

I'm using C# 2.0 , .NET 2.0 and sql server 2005.

Thanks
Gideon

Re: relatioships & datasets? [sqlservr 2005 , C# 05]

Colin Angus Mackay13-Feb-07 19:38

Colin Angus Mackay

13-Feb-07 19:38

giddy_guitarist wrote:
But why then , do we make relations in the database itself?

Because that's where the relationships are supposed to go. Datasets are ephemeral when compared to a database. Putting a relationship in a database is longer lasting and its existance will ensure data integrity across any and all applications that use the database.

giddy_guitarist wrote:
If i load each table into a dataset and then remake the relatioships via code it seems silly.

Personally, I rarely ever use datasets. If anything is required from System.Data in the presentation layer I start questioning my design because there is probably something wrong with it. Other than for quick throw-away apps I ensure the data layer and presentation layer are quite well separated.

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

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