Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
SQL Error on email
Last Post 07-19-2010 03:24 PM by David To. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
teknetUser is Offline
new to the springs
new to the springs
Posts:5
Avatar

--
07-14-2010 02:31 AM

    Hi

    I keep getting email alerts with this error i have about 30 every half hour , any ideas its saying that the Column name 'PleaseC' appears more than once , when it does not , because ive changed the fields now after i recived the error.



    An error occurred when attempting to run this SQL query:


    Update dbo.[DynamicForms_CustomTable_397] Set [TestTyp] = 'Car', [TestCat] = 'B-Car', [DoYouH] = 'Yes', [DoYouN] = 'No', [PleaseC] = 'Manual', [PleaseG] = 'BOROM709237GR9AE 62', [PleaseC] = 'Manual', [TheoryT] = '303073138' Where UniqueCompletionID = ''


    Column name 'PleaseC' appears more than once in the result column list.
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    07-19-2010 03:24 PM
    HI, if you go to Host / SQL and type in:

    select top 1 * from Dynamicforms_customtable_397

    what do you see? Is the [PleaseC] column exist twice? also, go to the URL/TABID of the dynamicforms page and look at your SQL completion event. This is where the SQL update statement should be found. Remove the second [PleaseC] = 'Manual'
    in the statement and it should clear you up. -- David

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi