ADODB & MySQL [RESOLVED]

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?

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.

:)

Simle table.

Name |tinytext,Primary,Index,Unique

VB Code:

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

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.

Quote:

---

Originally posted by Lightning

VB Code:

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

Quote:

---

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

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

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