Hi.

I have prof_*date columns created as hidden fields.
In the signup form, i am trying to pass the dates as hidden fileds and submit to db. The source of the signup page shows the dates generated fine as follows:

<input type="hidden" name="prof_sdate" value="2004-08-02">
<input type="hidden" name="prof_adate" value="2004-08-02">
<input type="hidden" name="prof_rdate" value="2005-08-03">

However, the database always shows the date for the above columsnas
0000-00-00

Where am i goofing. Similar thing works fine in GMail....

TIA
Anup

Is this really not possible. it looks so easy in GM and also in LSQL. Here it's not getting submitted to db no matter what i do.... it's always 0000-00-00. Can the actual dates (as hidden fields in signup form) be submitted to the DB while a user signs up?

Any suggestions?

Anup

What DB do you use? MySQL?
What is the type of the dat fields? DATE? DATETIME?

Best regards,
Webmaster33

---

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...

Tried it with latest community.
Database : MySQL 4.x
Column : Date

The dates passed as hidden field in user signup form really never makes it's way to the database ... which always shows 0000-00-00.

Looks like a shortcoming unless i have missed something.

Regards
HyTC

Hm. Ok. Strange anyway.

I can not test it nowadays. I'm busy with other tasks. Maybe later.
If I find a solution I will post it here.

Best regards,
Webmaster33

---

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...

Hi,

It looks to be working fine here. I'd recommend turning on debug and looking at your error log to see what queries are getting sent to the database (i.e. does the query have the custom fields in it?).

Cheers,

Alex
--
Gossamer Threads Inc.