Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...

Or... now make it easy with Facebook Integration
Connect via Facebook

Top Sellers

Dynamic Registration 4.0

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery 4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

XMod Pro 2.7 - Forms and Views for Databases

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

Smith Shopping Cart v3.88

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

Event Calendar and Registration 4.0

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

DNN Modules

Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
Insert problems
Last Post 08-18-2008 11:31 AM by Chad Nash. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Lane CampbellUser is Offline
skipping stones
skipping stones
Posts:7
Avatar

--
08-13-2008 08:26 AM

    I must be missing something very obvious. I have a form completion event the execute the flowing sql:

    INSERT INTO [mytable]
               ([EmailGUID]
               ,[Email]
               ,[FirstName]
               ,[YearOfBirth]
    )
         VALUES
               ('$(EmailGUID)',
               '$(Email)',
               '$(FirstName)',
               $(YearOfBirth_Text)
    )

    it is actually inserting "$(EmailGUID)" instead of replacing the value. I tried removing the apostrofe, but then the insert doesn't happen.

     

    What am I missing and how does one debug this? Why isn't the error sent to the event viewer?

    thanks
    Candace 616User is Offline
    river guide
    river guide
    Posts:105
    Avatar

    --
    08-15-2008 09:46 AM

    Hi Lane,

    Can you set up a demo of the problem on www.betasprings.com ?  (pls. use host / dnnhost to login.)  Please let us know your page name when it's ready.   Thanks!

    Candace

     
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    08-18-2008 11:31 AM
    Hi. Well a few things to look at as well.

    * If you add ?Debug=True to the querystring when loading the form, it should spit out exactly what is being sent within the SQL Completion Event when you click Submit.

    * I would also try and insert the text just as you have it in the SQL Event, only in an email event. You should receive an EMAIL that includes the parsed SQL. If you copy/paste that under Host, SQL does it work then?

    * I notice that you don't have ' around the YearOfBirth_Text. This is probably suggested just in case an integer is not entered.

    * Also... I am assuming that EmailGUID is the short field name of a field on your form?

    As Candace suggested though I would setup a page on Beta Springs with your same implementation and we can assist further there.


    -Chad
    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
     
     

    Join our mailing list...

    Get current news and events the easy way
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • 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