Thread Title: Textfield - Multi Field insert (Code supplied by: EE Member = aibusinesssolutions)
Thread Description (By: Carrzkiss):
Got something that i have been wondering how to do for several years
now.
(When it comes to me, I think about how it could be
done)
Textfield.
have it to where each line does a break.
(String)
And then you look at each break in the textfield, to determin how
many strings you have.
You then have an INSERT Statement that will insert
each line (String) into indivisual fields.
(Multi Field insert
statement)
So.
To break it down.
Take a continues string from a
Textfield
Break it down to indivisual strings (Per row)
And insert
indivisual records into a Table.
Hope that it is clear.
Just something
that I have been wondering about for a while.
What made me thing about it was
that I have an Old Perl script
That uses a Textfield and for each row, it
inserts into the MySQL database.
So.
If it can be done in Perl/MySQL
It
should be able to be done in ASP/Access (or) (SQL Server)
(I am using
Access)
have a good one all.
Carrzkiss
Q_24163759
To view the output, click here: [ => Output <= ]
Download Code (Some codes do not have .zip files with them, sorry!)
This Thread has been viewed: [ 400 ] times
|
