ADODB & MySQL [RESOLVED]

[GameBit]

cn.Execute("Insert Into Table1 Values('value')")

OK Its vorking.

How about:

For a=1 to 100
cn.Execute("Insert Into Table1 Values('value')")
next a

not all 100 values are inserted because of flood

Question: How to insert all 100 values?

[randem]

GameBit,

What does Table1 look like? How is it defined? Indexes? PrimaryKey?

I have never used an SQL Insert statement without a field name. I am suprised it works.

[GameBit]

Simle table.

Name |tinytext,Primary,Index,Unique

[Lightning]

cn.Execute("Update Table1 set tinytext='value'")

[Frans C]

Your code tries to insert 100 records with the same value, while the field only excepts unique values. I guess only the first insert statement succeeds.

[GameBit]

Originally posted by Lightning

cn.Execute("Update Table1 set tinytext='value'")

Problem not there.
1. Your code updates record
2. Even if i want to update 100 records with loop MySQL counts is as flood

[GameBit]

Originally posted by Frans C
Your code tries to insert 100 records with the same value, while the field only excepts unique values. I guess only the first insert statement succeeds.

No. It inserts about 20 of them. Problem not here. I'm talking about how to connect lot of querys to 1 line and only then send it to MySQL

[GameBit]

OK. I found it mysqlf. Thanx to everyone.
Answer:

cn.Execute("Insert Into Table1 Values('value'),('value'),('value')")