Database

jebberwocky27-Jul-06 23:41

jebberwocky

27-Jul-06 23:41

Try to use the Response.write to write out the Statement
Then u can use SQL analysis to test it
or try this
=db.OpenRecordset("select * from emp where empno='" & Val(Text1(0).Text) & "' and ename='" & Val(Text1(1).Text) & "' and hidate='" & Text1(5).Text) &"'"

Hy Chanhan28-Jul-06 1:20

Hy Chanhan

28-Jul-06 1:20

Hi,

In SQL Statement:
EX:
============

SELECT * FROM table_name WHERE field1 BETWEEN 1 AND 10

============
PLEASE CHECK YOUR STATEMENT AGAIN.
Hy Chanhan

Ravi kumar G29-Jul-06 2:52

Ravi kumar G

29-Jul-06 2:52

hi,
pleas give space between "empno" and "and" statement

Ravikumar
[Coimbatore]

S Douglas29-Jul-06 20:36

S Douglas

29-Jul-06 20:36

capamaro wrote:
("'select * from emp where empno='" & Val(Text1(0).Text) & "'[insert space] and ename='" & Val(Text1(1).Text) & "'[insert space]and hidate=[#]" & Text1(5).Text & "[#];")

You have an extra single quote in that query and are missing some spacing. When in doubt do a Debug.Print SQLQuery to see how it looks to the database engine.

You should really take a look at the article below, it’s not in the same language, but the content is still worth reading. Protecting the database is your number one goal no matter who the end users are. The way your queries are run they are prime for SQL injection attacks.

SQL Injection Attacks and Some Tips on How to Prevent Them[^]

I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:

How can I join 2 xml documents to get one table.

Ennis Ray Lynch, Jr.31-Jul-06 8:40

Ennis Ray Lynch, Jr.

31-Jul-06 8:40

It is vulnerable to SQL injection.

(Also try wrapping the date in ##

A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."

-- Stephen Crane

kalyan_vb27-Jul-06 17:00

kalyan_vb

27-Jul-06 17:00

Hi,

I want to join 2 xml documents to get the result into one table. Can any one gives the syntax.

Regards,
Kalyan

VB.NET , DATAGRID

gordie warwick27-Jul-06 8:22

gordie warwick

27-Jul-06 8:22

I want to update a cell in a datagrid, and then update my database with the cellvalue - Hopefully, using a contextmenu.
I am using a data/adapter.fill for the grid

Cool | :cool:

Gord Warwick

VK-Cadec28-Jul-06 7:40

VK-Cadec

28-Jul-06 7:40

Isn't updating the cell in grid update the database automatically?

gordie warwick28-Jul-06 7:49

gordie warwick

28-Jul-06 7:49

No...I would like some code examples, please

VK-Cadec28-Jul-06 7:56

VK-Cadec

28-Jul-06 7:56

try this web site:
<a href="http://samples.gotdotnet.com/quickstart/aspplus/" rel="nofollow">http://samples.gotdotnet.com/quickstart/aspplus/</a>

SpreadSheet and Pivot Components

gordie warwick28-Jul-06 8:32

gordie warwick

28-Jul-06 8:32

Thanks...I am a Virgin (Novice) .NET developer

This is not an ASP.NET project...it is a WINDOWS app

hamidreza_buddy27-Jul-06 7:45

hamidreza_buddy

27-Jul-06 7:45

Hi What is the activex control name for PivotTable and SpreadSheet and Chart?
I want to use them in a "Windows Form Application".

Inserting a row to a table

clint198227-Jul-06 5:52

clint1982

27-Jul-06 5:52

I use C# to Insert values into tables.
Now, I have a table that has a automatic counter as the ID.
Is there away that after I make insert I will get the ID of the row ? or do I have to make another pass using select ?

Re: Inserting a row to a table

Colin Angus Mackay27-Jul-06 5:56

Colin Angus Mackay

27-Jul-06 5:56

clint1982 wrote:
Is there away that after I make insert I will get the ID of the row ?

INSERT ....
SELECT SCOPE_IDENTITY() AS Id

Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

SQL Server Insert

clint198227-Jul-06 5:31

clint1982

27-Jul-06 5:31

Hi I want to insert into a table information and if the value exists it shouldn't insert but also not throw an error message.
Is there any option to the insert statement ?
It is in SQL Server.

Thanks,
Clint

Colin Angus Mackay27-Jul-06 5:36

Colin Angus Mackay

27-Jul-06 5:36

BEGIN TRANSACTION
IF NOT EXISTS (SELECT * FROM SomeTable WHERE SomeColumn = @SomeValue)
BEGIN
    INSERT ....
END
END TRANSACTION

clint198227-Jul-06 5:49

clint1982

27-Jul-06 5:49

Is there anyway to avoid two passes over the table ?

Colin Angus Mackay27-Jul-06 5:54

Colin Angus Mackay

27-Jul-06 5:54

Yes, but you'll have to catch the exception. The overhead for the exception is probably greater than the overhead for passing over the table twice in a single operation.