How to insert variables into my table

[inteleserve]

strSQL = "insert into usertable values ('fullname', 'address', 'city', 'state', 'zip', 'zip4', 'phone')"


**above is the sql string i am using. This string writes 'fullname' 'address' etc inside my table. I need it to write "BOB SMITH", "208 Jake Street" etc inside my table from a form.

I have tried the string below.....

strSQL = "insert into usertable values ('"& fullname &'", '"& address &"', '"& city &"', '"& state &"', '"& zip &"', '"& zip4 &"', '"& phone &'&quot"


...... however this method does not write anything and just inserts a blank line into my table.

Any ideas on what needs to be done here? Or does someone have a sample script from an online form that i can take a look at?

Thanks,

Ross Lund

 

[Bastien]

How are you populating the variables? From a form?

Have you assigned the data to the variables?

ie: FullName = request("FullName&quot

Could try thisall on one line)
strSQL = "insert into usertable values ('"& request("fullname&quot &'", '"& request("address&quot &"', '"& request("city&quot &"', '"& request("state&quot &"', '"& request("zip&quot
&"', '"& request("zip4&quot &"', '"& request("phone&quot &'&quot"

Note: I highly suggest that you validate all the data passed by the form to ensure that no one is gonna mess with your DB...

Bastien

 

[inteleserve]

It works awesome. Thanks you so much.