post it in thread dude.. i will try to sort it.. also u cant do it directly as u mentioned here.. u have to declare some variables.. i think ur a starter.. dont worry.. will help u to sort it out.. post in thread..
yogesh420 Thanks for your reply from my message titled, "HELP! ...with SQL...!" You've said: -------------------- 1. Yes mostly it will work.. 2. i think this code does not needed to optimize.. correct me if i am wrong.. btw y ru using ("INSERT INTO Stock_Status " & "VALUES (?, ?)", Con_StockDB) ?? ("INSERT INTO Stock_Status VALUES (?, ?)", Con_StockDB) this will work.. -------------------- Thank question is easy to answer! I've copied most of it from a book. I've modified variable names. Thanks! The entire portfolio needs to be written in one table, it must be recalled with an ASP app'. Can a SELECT statement retrieve from a table be directly assigned to a variable? Like in this code: For I = 1 to 500 Price(I) = SELECT StockPrice FROM Stock_Status Next I If this wont work, what should I change? May you have a blessed day as the Lord wills. JEP_Dude
