DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
Advanced Form Controls  
DwZone Forum Index -> Advanced Form Controls

Moderators: AdministratorsModerators 
Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.
New Topic Search for
 View     Per page     Messages Since 
Messages 71 to 80 of 381 (Total: 176) First |  Prev |  Next |  Last  
 Subject Author Date  
   Re: Event Calendar - How to change the language?  
View this persons public profile  Gianluigi   11:29 30 Sep 2011  
    Comma-separated CheckBoxes - Can't submit form if no boxes checked  
View this persons public profile  JeffKeller   1:43 12 Jun 2011  
 
Great extension! Thank you.

I am having 1 small issue though. On a Classic ASP/VBScript page, I am updating a recordset value and everything works fine--unless I have no checkboxes selected. Then I get the following error:

Microsoft OLE DB Provider for SQL Server error '80040e07'
Operand type clash: float is incompatible with text

I'm using MSSQL 2008 and the field that stores the comma-sep values is a varc_h_a_r(500)null [allowed].

Again--it works fine if I have 1 or all checkboxes checked, but I get the error.

Here is the row in the Dreamweaver Update Behavior that's associated with the checkboxes:

MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param34", 201, 1, 500, Request.Form("CustomerGroups")) ' adLongVarChar

Suggestions?
 
Reply to this current thread  View this persons public profile  Send Private Message
   Re: Comma-separated CheckBoxes - Can't submit form if no boxes checked  
View this persons public profile  Gianluigi   12:38 13 Jun 2011  
   Re: Comma-separated CheckBoxes - Can't submit form if no boxes checked  
View this persons public profile  JeffKeller   20:24 13 Jun 2011  
   Re: Comma-separated CheckBoxes - Can't submit form if no boxes checked  
View this persons public profile  Gianluigi   10:28 14 Jun 2011  
   Re: Comma-separated CheckBoxes - Can't submit form if no boxes checked  
View this persons public profile  JeffKeller   10:48 14 Jun 2011  
   Re: Comma-separated CheckBoxes - Can't submit form if no boxes checked  
View this persons public profile  Gianluigi   11:17 14 Jun 2011  
   Re: Comma-separated CheckBoxes - Can't submit form if no boxes checked  
View this persons public profile  JeffKeller   12:14 14 Jun 2011  
   Re: Comma-separated CheckBoxes - Can't submit form if no boxes checked  
View this persons public profile  Gianluigi   12:37 14 Jun 2011  
   Re: Comma-separated CheckBoxes - Can't submit form if no boxes checked  
View this persons public profile  JeffKeller   14:39 14 Jun 2011  
Last Visit: Saturday 10 May, 2025 1:58 pm First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT-2

Jump to: