INSERT INTO results.... I am having problems... (Full Version)

All Forums >> [Web Development] >> General Web Development



Message

Mojo -> INSERT INTO results.... I am having problems... (3/16/2001 20:27:00)

I can't get my SQL string with INSERT to work. I am trying to pass a variable to the string. The variable is the field.

My SQL looks like this so far:

"INSERT INTO results " & varField & "VALUES ('1')"

Thanks in advance,

Joe




Mojo -> RE: INSERT INTO results.... I am having problems... (3/16/2001 13:03:00)

I finally figured it out.

In case anyone ever needs it here it is...

fp_sQry="INSERT INTO yourtable ("&yourvariable&") VALUES ('yourvalue')"

Joe

[This message has been edited by jbennett (edited 03-16-2001).]




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625