phiber102
Last Activity: Apr 6 '09, 07:30 PM
Joined: Feb 25 '09
Location:
-
ok great idea thx, will try to play around with that -
hi sorry for the late answer
Its a one time copy every time a user register as a "builder" on the site, then all the "build plans/schematics" will automatically copy in to the mybpo, with bpo + anv on the same id (table anv holds the user data), which ofc will increase the number on the "id" tag like :
usr1+bpo1 id=1
usr1+bpo2 id=2
usr1+bpo3 id=3
usr1+bpo4 id=4
usr1+bpo5...Leave a comment:
-
hi sorry for the late answer its a one time copy every time a user register as a "builder" on the site then all the plans will automatically copy in to the database, with plans + user name on the same id which ofc will increase the number on the "id" tag like :
usr1+plan1 id=1
usr1+plan2 id=2
usr1+plan3 id=3
usr1+plan4 id=4
usr1+plan5 id=5
usr1+plan6 id=6
usr value and plan...Leave a comment:
-
thx again :D appreciate the helpLeave a comment:
-
hmm i still cant get it to work, doing this now:
but then i get error message Microsoft JET Database Engine (0x80040E14)Code:sql = "INSERT INTO mybpo SELECT bpo FROM bpo JOIN anv ON (usr = '" & session("usr") & "')"Leave a comment:
-
Thank you very much! might have saved my day :DLeave a comment:
-
Hmm not not really sure, since im not that good at sql/database part :D
But what i want is to take data from table "anv" column "usr" and then take out data from table "bpo" column "bpo", and place them into a table called "mybpo" column "usr" and column "bpo". and its important that usr and bpo enter "next to each other"Leave a comment:
-
Copy table to table, how?
Hello!
I been working on a problem for a while. I need to copy data from 2 tables and merge them in to 1 table that already exists. i need to extract a column called "bpo" and a column called "usr" from 2 different tables called anv and bpo and then copy them into a table called mybpo.
I guess it shood look something like this:
sql = "INSERT INTO mybpo SELECT usr FROM anv where... -
need help with copy table to table in mysql
Hello!
I been working on a problem for a while. I need to copy data from 2 tables and merge them in to 1 table that already exists. i need to extract a column called "bpo" and a column called "usr" from 2 different tables called anv and bpo and then copy them into a table called mybpo.
I guess it shood look something like this:
sql = "INSERT INTO mybpo SELECT usr FROM anv where... -
I need help with copy table to table with asp
Hello!
I been working on a problem for a while. I need to copy data from 2 tables and merge them in to 1 table that already exists. i need to extract a column called "bpo" and a column called "usr" from 2 different tables called anv and bpo and then copy them into a table called mybpo.
I guess it shood look something like this:
sql = "INSERT INTO mybpo SELECT usr FROM anv where...
No activity results to display
Leave a comment: