Javscript-How to join two tables?

Question

0.00/5 (No votes)

See more:

Prefer table(dateformat,papersize,enablepass,currency)
params table(newpassword,oldpassword,dateformat,papersize,enablepass,currency,secretq,secretans)

These are the two tables I am working with.Prefer table details insertion is done in prefer.js and params table in params.js.On insertion the datas are inserted like.
for example:
prefer
dateformat ,papersize ,enablepass ,currency
dd/mm/yy , 4 , yes , $

params table appears like this:-
newpassword ,oldpassword, dateformat , papersize, enablepass , currency, secretq , secretans
qwer , asdf , - , - , - , - , dfg , dgdfg
- , - , dd/mm/yy , 4 , yes , $ , - , -

the dateformat,papersize ,enablepass and currency is inserted in another line:-my code says to do the same, I need to know how to insert the fields together in one line?
something like this:-

params table:-
newpassword, oldpassword, dateformat , papersize , enablepass , currency, secretq , secretans
qwer , asdf , dd/mm/yy , 4 , yes , $ , dfg , dgdfg

prefer.js

SQL

db=openDatabase(masterDbName,version,displayName,maxSize);
    db.transaction(function (tx)
    {
   tx.executeSql('INSERT INTO preferences(date_format,paper_size,currency_symbol,password)VALUES(?,?,?,?)',[$('.date option:selected').val(),$('#paper_size').val(),$('.currency option:selected').val(),$('.password option:selected').val()],populate_success,transaction_error );
     tx.executeSql('INSERT INTO params(date_format,paper_size,currency_symbol,enable_pword)VALUES(?,?,?,?)',[$('.date option:selected').val(),$('#paper_size').val(),$('.currency option:selected').val(),$('.password option:selected').val()],populate_success,transaction_error );
    });

params.js

db=openDatabase(masterDbName, version, displayName,maxSize);
db.transaction(function(transaction)
{
transaction.executeSql('insert into params(new_password,old_password,secret_question,secret_answer)values(?,?,?,?)',[ $('#pass1').val() ,$('#pass2').val(),$('#question').val(),$('#answer').val()],populate_success,transaction_error );
});

I hope the question is clear by my words..please help

Posted 25-May-14 18:39pm

p@y@l

Updated 25-May-14 18:42pm

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 26-May-14 1:34am

Are you sure you want to do it in Javascript? It could be utterly unsafe, because the script it totally opened to the client and can be easily spoofed. How about using one of the server-side technologies.
—SA

p@y@l 26-May-14 2:01am

I am using html also for design in this, but database work is completely done in javascript,and my work to be done in this!!Which other you are talking about?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

p@y@l · Answer 1 · 2014-05-25T20:55:00

Done with it..it is just u have to update the filed instead of inserting again!

SQL

db=openDatabase(masterDbName,version,displayName,maxSize);
   db.transaction(function (tx)
   {
  tx.executeSql('INSERT INTO preferences(date_format,paper_size,currency_symbol,enable_pword)VALUES(?,?,?,?)',[$('.date option:selected').val(),$('#paper_size').val(),$('.currency option:selected').val(),$('.password option:selected').val()],populate_success,transaction_error );
    tx.executeSql('UPDATE params SET date_format=?,paper_size=?,currency_symbol=?,enable_pword=?',[$('.date option:selected').val(),$('#paper_size').val(),$('.currency option:selected').val(),$('.password option:selected').val()],populate_success,transaction_error );
   });