Insert a value into a sql statement

[phoenixaz]

I want to ALSO insert into TABLE1 in the field name "signupdate" the signupdate which is "AZDATE".

sql= "insert into TABLE1 (CustomerID,productid)select customerid,productid from TABLE2,TABLE3 where TABLE2.customername = '"& customer &"' and TABLE2.customerid = '"& id &"' and TABLE3.productname = '"& productname&"' "

I know I have to add it here....


TABLE1 (CustomerID,productid,signupdate)

...but not sure how to add the value "azdate". AZDATE is properly formatted, just can't figure how to insert it.

Code works ok but can't seem to add the date!

Thanks for your help.

[sqlconfused]

sql= "insert into TABLE1 (CustomerID,productid,signupdate) select customerid,productid from TABLE2,TABLE3 where TABLE2.customername = '"& customer &"' and TABLE2.customerid = '"& id &"' and TABLE3.productname = '"& productname&"' "

would you not just add
& productname&"', '" & AZDATE & "'"

[phoenixaz]

would you not just add
& productname&"', '" & AZDATE & "'"

I can't seem to get that to work by adding that. I am adding that to the end of the statement; would that be correct?

[gk53]

if your code
sql= "insert into TABLE1 (CustomerID,productid)select customerid,productid from TABLE2,TABLE3 where TABLE2.customername = '"& customer &"' and TABLE2.customerid = '"& id &"' and TABLE3.productname = '"& productname&"' "
works just

sql= "insert into TABLE1 (CustomerID,productid, signupdate )select customerid,productid,"& AZDATE &" from TABLE2,TABLE3 where TABLE2.customername = '"& customer &"' and TABLE2.customerid = '"& id &"' and TABLE3.productname = '"& productname&"' "

[phoenixaz]

Of course, I see that now. Thanks for that!

When I do this... "& AZDATE &" I get 1/1/1900, so I did this...

'"& AZDATE &"'

and it works fine. Why is that?

Thanks

[gk53]

oh yes time must be included in ' (single quotes) it is SQL rule

[sqlconfused]

For the record, the code box in my last reply had the proper SQL string if you combined it with the suggestion as well, which is why I didn't respond. I thought you'd notice it.

sql= "insert into TABLE1 (CustomerID,productid,signupdate) select customerid,productid from TABLE2,TABLE3 where TABLE2.customername = '"& customer &"' and TABLE2.customerid = '"& id &"' and TABLE3.productname = '"& productname&"', '" & AZDATE & "'"

But alas you have it working now.

[phoenixaz]

I did add that just as you last posted and it didn't work. I get this error message...

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ','.

When I added it per gk53, it doesn't error out and it inserts the date correctly.

Thanks for your time, I do appreciate it very much and yes, alas it's now working.