Robert Rodgers
|
| Posted: 05/17/2002, 11:04 AM |
|
Hi All,
First all I have to say I really like CC Studio. I think you have a great
product.
CC Studio Beta4
MSSQL7
ASP+Templates
1)
On a record update form. I am updating the foreign keys with a listbox from
another table. If the user does not choose a value(or the user chooses
"Select Value"). On submit I get a DB error stating the "Select Value" was
passed to the update table. In Beta3 this didn't happen. Here is the error
description. Notice CallID is being set to 'Select Value' When the user
has not chosen a value (This is not a required field so it should be ok if
the user leaves it unchanged, at least it was in Beta3).
Error description: Syntax error converting the varchar value 'Select Value'
to a column of data type int. (Microsoft OLE DB Provider for SQL Server)
UPDATE [WorkQueue] SET [CallID]='Select Value', [AssignedUserSysID]='7',
[PrioritySysID]=4, [ActionSysID]='3', [StatusSysid]='35',
[ActionDate]='11/7/2001 5:05:00 PM', [Description]='This user is still
having problems', [AdditionalNotes]='These are the notes' WHERE
[WorkQueue].[SysID] = 1
2)
Same situation as above but this time the field PrioritySysID is Required.
In the DB it is set to Not Null and in CC Studio This Field is set to
Required = Yes. You can see on the POST Data: that the field is being set
to Select Value
If a value is not chosen (or the user chooses "Select Value") then I get a
"The page cannot be displayed" error. This also worked in Beta3, If a user
did not choose a value then the page is redisplayed with a message stating
the field is required and they should choose a value (or something like
that).
These are the details.
Technical Information (for support personnel)
a.. Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: 'DataSource.Connection'
/sccrm/Classes.asp, line 1082
b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; T312461)
c.. Page:
POST 168 bytes to /sccrm/WorkQueue_maint.asp
d.. POST Data:
CallID=1&AssignedUserSysID=7&PrioritySysID=Select+Value&ActionSysID=3&Status
Sysid=35&ActionDate=11%2F7%2F2001+5%3A05%3A00+PM&Description=&AdditionalNote
s=&Update=Submit
Thanks for you time.
Rob
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 05/20/2002, 9:55 AM |
|
Please submit your requests to http://support.codecharge.com/support_new.asp
and attach zipped ccs project folder with database.
--
Alex
CodeCharge Developer
"Robert Rodgers" <Robert@SylvanComputing.com> wrote in message
news:ac3gnp$r2e$1@news.codecharge.com...
> Hi All,
>
> First all I have to say I really like CC Studio. I think you have a great
> product.
>
>
> CC Studio Beta4
> MSSQL7
> ASP+Templates
>
>
> 1)
> On a record update form. I am updating the foreign keys with a listbox
from
> another table. If the user does not choose a value(or the user chooses
> "Select Value"). On submit I get a DB error stating the "Select Value"
was
> passed to the update table. In Beta3 this didn't happen. Here is the
error
> description. Notice CallID is being set to 'Select Value' When the user
> has not chosen a value (This is not a required field so it should be ok if
> the user leaves it unchanged, at least it was in Beta3).
>
> Error description: Syntax error converting the varchar value 'Select
Value'
> to a column of data type int. (Microsoft OLE DB Provider for SQL Server)
> UPDATE [WorkQueue] SET [CallID]='Select Value', [AssignedUserSysID]='7',
> [PrioritySysID]=4, [ActionSysID]='3', [StatusSysid]='35',
> [ActionDate]='11/7/2001 5:05:00 PM', [Description]='This user is still
> having problems', [AdditionalNotes]='These are the notes' WHERE
> [WorkQueue].[SysID] = 1
>
> 2)
> Same situation as above but this time the field PrioritySysID is Required.
> In the DB it is set to Not Null and in CC Studio This Field is set to
> Required = Yes. You can see on the POST Data: that the field is being set
> to Select Value
>
> If a value is not chosen (or the user chooses "Select Value") then I get a
> "The page cannot be displayed" error. This also worked in Beta3, If a
user
> did not choose a value then the page is redisplayed with a message stating
> the field is required and they should choose a value (or something like
> that).
>
> These are the details.
> Technical Information (for support personnel)
>
> a.. Error Type:
> Microsoft VBScript runtime (0x800A01A8)
> Object required: 'DataSource.Connection'
> /sccrm/Classes.asp, line 1082
>
>
> b.. Browser Type:
> Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; T312461)
>
> c.. Page:
> POST 168 bytes to /sccrm/WorkQueue_maint.asp
>
> d.. POST Data:
>
>
CallID=1&AssignedUserSysID=7&PrioritySysID=Select+Value&ActionSysID=3&Status
>
Sysid=35&ActionDate=11%2F7%2F2001+5%3A05%3A00+PM&Description=&AdditionalNote
> s=&Update=Submit
>
>
>
> Thanks for you time.
> Rob
>
>
|
|
|
|
|
