adding multiple records

[Matt]

Thanks Perry,

I am not sure what :

(" & (nBsae £« 1£ > © & " )")


is as the characters are not normal?

could you please repost, thank you very much

>-----Original Message-----
>You can use code as follows to add multiple records into

your database:

>
>szSQL="SELECT * FROM tblTickets ORDER BY nID DESC"
>set rsTemp2= objConn.Execute (szSQL)
>dim nBase
>nBsae = rsTemp2("nticket")
>
>objConn.Execute ("insert into tblTickets (nticket)

values (" & (nBsae £« 1£

>©& " )")
>objConn.Execute ("insert into tblTickets (nticket)

values (" & (nBsae £« 2£

>©& ")")
>objConn.Execute ("insert into tblTickets (nticket)

values (" & (nBsae £« 3£

>©& ")")
>objConn.close
>set objConn = nothing
>
>Best regards,
>Perry Deng
>Microsoft
>
>This posting is provided "AS IS" with no warranties, and

confers no rights.

>
>.
>

[Perry Deng]

Hi Matt,

Sorry, some characters become messy, so I paste it again:

szSQL="SELECT * FROM tblTickets ORDER BY nID DESC"
set rsTemp2= objConn.Execute (szSQL)
dim nBase
nBsae = rsTemp2("nticket")

objConn.Execute ("insert into tblTickets (nticket) values (" & (nBsae £« 1)
& " )")
objConn.Execute ("insert into tblTickets (nticket) values (" & (nBsae £« 2)
& ")")
objConn.Execute ("insert into tblTickets (nticket) values (" & (nBsae £« 3)
& ")")
objConn.close
set objConn = nothing

Best regards,
Perry Deng
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.