NetTalk Central

Author Topic: Calendar lookup field blank  (Read 3489 times)

johanco123

  • Full Member
  • ***
  • Posts: 245
    • View Profile
    • Email
Calendar lookup field blank
« on: May 09, 2013, 09:43:25 PM »
Hi Bruce

I create a netwebform in Nt7.10 using an existing MSSQL database. In the field type I use 'Date' but the field is display a blank, even when I select a field from the lookup calender the field stays empty. When I change the field to a string the date display correct as a @d6 field.

Any suggestions

Regards
Johan

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: Calendar lookup field blank
« Reply #1 on: May 09, 2013, 10:27:25 PM »
What is the field in the SQL database declared as?
what is the field in your dictionary declared as?


johanco123

  • Full Member
  • ***
  • Posts: 245
    • View Profile
    • Email
Re: Calendar lookup field blank
« Reply #2 on: May 09, 2013, 11:06:31 PM »
SQL - int
Dictionary  - Long (@d6)

Tanks
Johan

johanco123

  • Full Member
  • ***
  • Posts: 245
    • View Profile
    • Email
Re: Calendar lookup field blank
« Reply #3 on: May 12, 2013, 11:12:34 PM »
Hi Bruce

Any suggestions regarding the calendar lookup.

SQL - int
Dictionary  - Long (@d6)

Tanks
Johan

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: Calendar lookup field blank
« Reply #4 on: May 12, 2013, 11:48:14 PM »
perhaps make a small example Johan, with TPS if possible.
I'm guessing you have a setting wrong somewhere.

Or even just a screen-shot of the form-field settings might help.

cheers
Bruce

johanco123

  • Full Member
  • ***
  • Posts: 245
    • View Profile
    • Email
Re: Calendar lookup field blank
« Reply #5 on: May 13, 2013, 03:11:49 AM »
Hi Bruce

I update the netwebform in the settings tab, 'Picture' as '@d6' and the 'Date Lookup picture' to '@d6,@s10'

The date is showing now  the correct date and the calendar lookup is working.

Tanks
Johan