Hi All,

I've quite a strange requirement to insert multiple records into a table.
I have some numbers say 14,32,3,5,7,811,43,45 which i want be inserted into a table T1 with one column N1

but i want all these values to be inserted as different records records in one go without using any looping .

I know this can be done using the INSERT ... SELECT ... Statements.
or slightly different way.

But not sure on how exactly it can be done.

On a slightly different requirement I want a way to get these values in the form of records without using any table.


I mean i need a select statement on the values 1,3,65,22,65,77,33

something like Select * from (1,3,65,22,65,77,33)

and the result be displayed in the form

(No Column Name)
----------------
1
3
65
22
65
77
33

Is it possible.

I know some experts out there can help me do these things.

I will appreciate any help on this

Thanks,
Deepak Chauhan
XpertGuys.com

You need a individual Insert statement for each value you want to insert.

Not sure what you mean by this.

You can use inte IN clause
Select <some col>
from <some table>
where <some col> IN (1,3,65,22,65,77,33)

Hei!

Is this of any help?

Set MyConn = CreateObject("ADODB.Connection")

MyConn.Open "your name for the cnnection-string"
    Set RS = MyConn.Execute("SELECT * FROM tabname WHERE anyField = '" & aVar & "'")


If Not RS.EOF then
MyConn.Execute "UPDATE Produkt SET fieldName = '" & aVar & "' WHERE anyField = '" & anyVar & "'"

    Else
    End if

    MyConn.Close
    Set MyConn = Nothing

    response.redirect "anyPage.asp"


Regards from

grstad

... sorry, that one must have been directed to the wrong page!