Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > General .NET
|
General .NET For general discussion of MICROSOFT .NET topics that don't fall within any of the other .NET forum subcategories or .NET language forums.  If your question is specific to a language (C# or Visual Basic) or type of application (Windows Forms or ASP.Net) try an applicable forum category. ** PLEASE BE SPECIFIC WITH YOUR QUESTION ** When posting here, provide details regarding the Microsoft .NET language you are using and/or what type of application (Windows/Web Forms, etc) you are working in, if applicable to the question. This will help others answer the question without having to ask.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the General .NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 3rd, 2005, 11:09 PM
Authorized User
 
Join Date: Aug 2003
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default PROBLEM WITH INSERT STATMENT

Dim SQL_INSERT = ("Insert INTO PHONE (Customer,Phone_Type,Phone) " & _
            "Values ('" & IFTMemberId & "','EMAIL','" & EmailUpdate & "'")

            OConn.Open()

            Dim cmd As OracleCommand = New OracleCommand(SQL_INSERT)
            cmd.Connection = OConn
            cmd.CommandType = CommandType.Text

            If cmd.ExecuteNonQuery() Then
                'Completed Ok
            Else
                Dim Ex As Exception

---------------------ERROR MESSAGE SAYS I AM MISSING A COMMA----------------------
I tesed this in TOAD and it works fine. DOn't knoww what the problem is.

Sanjeet
__________________
Sanjeet
 
Old February 4th, 2005, 09:39 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,110
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Values ('" & IFTMemberId & "','EMAIL','" & EmailUpdate & "'")

Try removing the red double quote and placing it behind the ')'.






Similar Threads
Thread Thread Starter Forum Replies Last Post
insert & update statment problem (sql express) abdrabaa C# 2 July 15th, 2007 05:54 AM
Help with IIF Statment Corey Access 2 December 14th, 2006 11:10 AM
problem with this insert statment in vba method Access VBA 1 June 22nd, 2005 12:26 PM
if statment knightm28 Classic ASP Databases 2 April 1st, 2005 11:08 AM
SQL Statment btpoole VB Databases Basics 1 February 18th, 2004 01:03 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.