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?
Printable View
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.
Problem not there.Quote:
Originally posted by Lightning
VB Code:
cn.Execute("Update Table1 set tinytext='value'")
1. Your code updates record
2. Even if i want to update 100 records with loop MySQL counts is as flood
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 MySQLQuote:
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.
OK. I found it mysqlf. Thanx to everyone.
Answer:
cn.Execute("Insert Into Table1 Values('value'),('value'),('value')")