You don't need the "values" or the brackets. strSQL = "INSERT INTO testpurchase(ProductName) Select ProductName from Products where Yes-No_Fld='No'"
Dan Visit www.diado.com for free ASP.Classic classes, articles, links & downloads. Looking for a new domain for your ASP website? I have ASPfunctions.net and .com for sale for a reasonable offer - email me for more info! -----Original Message----- From: Melvin Ocampo [mailto:[EMAIL PROTECTED] Sent: 28 April 2004 10:30 To: [EMAIL PROTECTED] Subject: [ASP] SQL help 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 ------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511 http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/17folB/TM ---------------------------------------------------------------------~-> --------------------------------------------------------------------- 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/
