|
|
Posted by tatata9999 on 10/12/07 20:57
Hi Jack,
Very simple sql dml code (all the columns are of varchar of various
length):
insert into myTBL (col1,col2,col3)
values ('#ranVar#','#FORM.element1#','#FORM.element2#')
The err msg is:
Violation of PRIMARY KEY constraint 'PK__myTBL__772828B3EFCA'. Cannot
insert duplicate key in object 'myUsers'.<P><P> SQL = "insert into
myTBL (col1,col2,col3) values
('342*783','signmeeup728392@student.org','s')" "
Actually sql server has successfully captured one record. Don't know
why it tries to capture it again. It would be nice to have many
simultanous users to use/test it... If you don't mind, http://www.mytata.net/,
Many thanks.
Don
On Oct 12, 11:01 am, "Jack Vamvas" <DEL_TO_RE...@del.com> wrote:
> Could you post your stored procedure or code?
> Are you able to get an output of the sql string that will be used, the one
> that throws the error.
>
> --
>
> Jack Vamvas
> ___________________________________
> Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL
>
> <tatata9...@gmail.com> wrote in message
>
> news:1192198893.793558.61740@v29g2000prd.googlegroups.com...
>
>
>
> > Hi,
>
> > SQL env: sql server 2000
> > Target column of insertion: varchar(15)
>
> > Case, a var is made up of a character of the following characters
> > (random selection):
> > A,B,C,D,E,$,!,%,^,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,&,*,(,)
> > and a few numbers (random selection), and then
>
> > var = ran1&ran2
>
> > I'm experiencing intermit sql error
> > Is it because I did not include the string with quotes like
> > var = "ran1 & ran2"
>
> > or the first random seletion may include special character and that
> > may cause insertion error randomly?
>
> > Probably the former is more likely. And I've added quotes for the
> > var (programming language shouldn't really matter, int type usually
> > without quotes while strings need quotes).
>
> > What's your thought?
>
> > Thanks.- Hide quoted text -
>
> - Show quoted text -
Navigation:
[Reply to this message]
|