Hello everybody, I got lost on my SQL
strSQL = "INSERT INTO testpurchase(ProductName) VALUES ( Select ProductName from Products where Yes-No_Fld='No' )" it generates syntax error in query expression for the query after the "VALUES".... any idea where is my mistake... thanks a lot melvin [Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
