How to transfer all data from one database to another

[neokafe]

I have been trying to transfer a bulk of data into another database using the
form method but when i tried copyin from the first database, they all inserted
into one row in the second database. i also ried some other method like
defining an array but it still didnt work. for example, i tried to send 10
information into another database but they all end up insering into one row
istead of 10. Please if anyone can help me with this, i will really appreciate
it.

[gumshoe]

re:
I have been trying to transfer a bulk of data into another database using
the
form method

Not sure about anone else, but that statement makes little sense to me? The
rest of it didn't get much better.

Please try and explain this a little better.


"neokafe" <webforumsuser@macromedia.com> wrote in message
news:d0492v$364$1@forums.macromedia.com...

>I have been trying to transfer a bulk of data into another database using
>the
> form method but when i tried copyin from the first database, they all
> inserted
> into one row in the second database. i also ried some other method like
> defining an array but it still didnt work. for example, i tried to send
> 10
> information into another database but they all end up insering into one
> row
> istead of 10. Please if anyone can help me with this, i will really
> appreciate
> it.
>

[Brian Hogue]

This sounds like a database question, not a CF question. Here are some
possibilities
- export from the old database and import into the new database
- try SELECT INTO
- if you are using SQL Server 2000, try BCP or DTS

-brian

"neokafe" <webforumsuser@macromedia.com> wrote in message
news:d0492v$364$1@forums.macromedia.com...

> I have been trying to transfer a bulk of data into another database using

the

> form method but when i tried copyin from the first database, they all

inserted

> into one row in the second database. i also ried some other method like
> defining an array but it still didnt work. for example, i tried to send

10

> information into another database but they all end up insering into one

row

> istead of 10. Please if anyone can help me with this, i will really

appreciate

> it.
>

[cmschofield]

I'm not sure what the form is for. Please explain what you are trying to do with the form.

[kyle969]

One possibility:
Set up a link from db1 to db2 then-
<cfquery datasource="db1">
INSERT INTO Customer2@db2
SELECT * Customer2
</cfquery>
Thats kinda hokey, but it should work
(in Oracle anyway)

[kyle969]

If you have to go through the form, do a <cfdump var="#form#"> on the
processing page, I bet the elements are in lists. In which case you will have
to:

<cfloop from="1" to="#listlen(form.firstName)#" index="i">
<cfquery datasourse="db2">
INSERT INTO Customer2(firstName,Lastname,address)
VALUES('#ListGetAt(Form.firstName,i)#',
'#ListGetAt(Form.lastName,i)#',
'#ListGetAt(Form.address,i)#')
</cfquery>
</cfloop>