strings to a database

[alex]

How would you insert two differents Strings to two differents field column
but in the same row. For example If I have the following declarations: String
a = "hello";
String b ="World";

Database: Table
Field 1 Field 2
-------- -------
row1 hello World

I know that you can use: insert into "Table" (Field1) values('" + a +"'));
This statement works for single entry.But What I want is multiple access.
My problem is that when I put :
insert into "Table" (Field1,Field2) values('" + a + b+"')); It won't update
my database

Can somebody help me
thanks;

[Thomas Skariah]

The syntax should be

insert into tablename (field1, field2) values("'" + a "', '" + b + "'");

Each string should be surrounded with a (') and each field should be seperated
with (,).


"alex" <delgadoalex2001@aol.com> wrote:
>
>How would you insert two differents Strings to two differents field column
> but in the same row. For example If I have the following declarations:
String
>a = "hello";
> String b ="World";
>
>Database: Table
> Field 1 Field 2
> -------- -------
>row1 hello World
>
>I know that you can use: insert into "Table" (Field1) values('" + a +"'));
>This statement works for single entry.But What I want is multiple access.
>My problem is that when I put :
> insert into "Table" (Field1,Field2) values('" + a + b+"')); It won't update
>my database
>
>Can somebody help me
>thanks;