Response.Write your variable that holds the SQL string and post it to the group. I think that we may need more information in order to help. Mark
kuku b <[EMAIL PROTECTED]> wrote: i have provided space but still not working fine. Dan Powderhill wrote:Did you try putting a space after the VALUES keyword in the SQL statement, before the opening parenthesis? Dan -----Original Message----- From: kuku b [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 16:39 To: [EMAIL PROTECTED] Subject: Re: [AspClassicAnyQuestionIsOk] error in the code mark i have solved that problem. thanks for the reply. i have another problem which i have sent today. hi i have problem linking to db i m getting an error as Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. /inventory/inventory8.asp, line 76 SQL="INSERT INTO inventory (serialnumber,modelnumber,description) values("& serialnumber & ", " & modelnumber & ", '" & description & "')" conn.Execute SQL my db has 2 tables one of which is inventory. which has 3 feilds as serialnumber,modelnumber and description. Mark E wrote: This usually means that you started an "If" statement and do not have a closing "End If". But we would need to see your code in order to tell definitively. Mark kuku b wrote: hi my code is giving problem as "expected end " on line 57. can u help me with that thanks --------------------------------- Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com [Non-text portions of this message have been removed] Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? Discover all that's new in My Yahoo! [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? The all-new My Yahoo! � Get yours free! [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> 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/
