NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: johanco123 on May 09, 2013, 09:43:25 PM

Title: Calendar lookup field blank
Post by: johanco123 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

Title: Re: Calendar lookup field blank
Post by: Bruce 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?

Title: Re: Calendar lookup field blank
Post by: johanco123 on May 09, 2013, 11:06:31 PM

SQL - int
Dictionary  - Long (@d6)

Tanks
Johan

Title: Re: Calendar lookup field blank
Post by: johanco123 on May 12, 2013, 11:12:34 PM

Hi Bruce

Any suggestions regarding the calendar lookup.

SQL - int
Dictionary  - Long (@d6)

Tanks
Johan

Title: Re: Calendar lookup field blank
Post by: Bruce 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

Title: Re: Calendar lookup field blank
Post by: johanco123 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