Using variables in SQL statement

[japplebee]

I'm having troubles getting this to work. I'm updating a recordsource with information stored in variables. So far this works:

Set Conn = Server.CreateObject("ADODB.Connection&quot
Conn.open "DSN=webif"
Set RS = Conn.execute("INSERT INTO inbounds (customer) VALUES ('1236547')&quot

But when I replace the last line with this, it gives me a syntax error:

Set RS = Conn.execute("INSERT INTO inbounds (customer) VALUES (" & g_custnum & &quot&quot

It must be how I'm inserting the variables, but I'm at a loss on how to fix it.

Any help is appreciated!

 

[derren]

Hi

In the first statement you are surrounding the value 1236547 with single quotes, but when you are doing it with the variable you haven't put them in!

Set RS = Conn.execute("INSERT INTO inbounds (customer) VALUES ('" & g_custnum & "')&quot

Derren
[The only person in the world to like Word]