Literal Value error when updating the UserProfile
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Literal Value error when updating the UserProfile

 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server
Author Message
mark
Guest





Posted: Mon Oct 11, 2004 11:59 pm    Post subject: Literal Value error when updating the UserProfile Reply with quote

I am receiving the following error message when executing the
following line found in the UpdateUserProfile() SUB

"Literal value in the command exceeded the range of the type of
the assoicated column"

Any suggestions would be greatly appreciated.

Thanks (in Advance)

Mark
Back to top
David Hargis [MSFT]
Guest





Posted: Fri Oct 15, 2004 10:14 pm    Post subject: RE: Literal Value error when updating the UserProfile Reply with quote

Hi Mark. You'll get this error when you are trying to assign a value to
one of the profile properties that is longer than the maximum allowed by
its data type. I'm not sure of all of the maximums off hand, but I believe
strings can be at most 8000, and binary can be at most 4096.

Hope this helps,
David

--------------------
From: mstowers@kodak.com (mark)
Newsgroups: microsoft.public.commerceserver.general
Subject: Literal Value error when updating the UserProfile
Date: 11 Oct 2004 11:59:08 -0700
Organization: http://groups.google.com
Lines: 11
Message-ID: <ed5270ad.0410111059.1e67ed64@posting.google.com>
NNTP-Posting-Host: 165.170.128.66
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1097521148 5088 127.0.0.1 (11 Oct 2004 18:59:08
GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 11 Oct 2004 18:59:08 +0000 (UTC)
Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!news.glorb.com!postnews1.google.com!not-for-mail
Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.general:14973
X-Tomcat-NG: microsoft.public.commerceserver.general

I am receiving the following error message when executing the
following line found in the UpdateUserProfile() SUB

"Literal value in the command exceeded the range of the type of
the assoicated column"

Any suggestions would be greatly appreciated.

Thanks (in Advance)

Mark


This posting is provided "AS IS" with no warranties, and confers no
rights.

EBusiness Server Team
Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server All times are GMT
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB