CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Insert Record Question

Print topic Send  topic

Author Message
Webber
Posted: 03/24/2001, 9:48 AM

I created a single ASP page very simple insert record to my MS Access db. I
am still learning this product but the help files, etc. really do not
explain how to use the page & form events, etc.

On top of this I am fairly new to scripting and I want to be able to stop
duplicate records from being entered but I don't really know how:
a) what script do I use to stop duplicate records?
b) where do I put this script in codecharge?
c) is there a reference somewhere that will instruct me on how & where to do
this?

the url I am working with is at
http://www.mortgageyellowpages.com/test/bregister.asp

Thank you in advance for any help on this.

Webber


begin 666 Robin Lyson.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DQY<V]N.U)O8FEN#0I&3CI2
M;V)I;B!,>7-O;@T*3U)'.DU-4VD[24-1(",@,C$Y-S<R#0I4251,13I/=VYE
M<@T*3D]413M%3D-/1$E.1SU154]4140M4%))3E1!0DQ%.DES('EO=7(@8G5S
M:6YE<W,@36]R=&=A9V4@;W(@4F5A;"!%<W1A=&4@4F5L871E9#\@4F5G:7-T
M97(@>6]U<B!B=7-I;F5S<R!&<F4]#0IE(&]N($UO<G1G86=E(%EE;&QO=R!0
M86=E<RYC;VTN/3!$/3!!/3!$/3!!=W=W+DUO<G1G86=E665L;&]W4&%G97,N
M8V]M/3!$/0T*/3!!/3!$/3!!0VAE8VL@;W5T(&]U<B!N97=L>2!L875N8VAE
M9"!S:71E(2!H='1P.B\O=W=W+EEO=7),:6YC;VQN4&%R:RYC;VTN(#T-"E9I
M<VET(&)E9F]R92!I="=S(&]F9FEC:6%L(&1E8G5T(&]N(#4O,S$O,C P,2X]
M,$0],$$],$0],$%.965D(&UO<F4@:6YF;W)M870]#0II;VXL(&-O;G1A8W0@
M35E01U,@=FEA(&4M;6%I;"!O<B!T:')O=6=H(&]U<B!)0U$C(#(Q.3<W,BX-
M"E1%3#M73U)+.U9/24-%.C,Q,RXS.#(N,#DQ,0T*5$5,.T-%3$P[5D])0T4Z
M,S$S+C0P-RXQ,#<X#0I414P[4$%'15([5D])0T4Z,S$S+C0P-RXQ,#<X#0I4
M14P[5T]22SM&05@Z,S$S+C,X,BXP.3,T#0I414P[2$]-13M&05@Z24-1(R R
M,3DW-S(-"D%$4CM73U)+.T5.0T]$24Y'/5%53U1%1"U04DE.5$%"3$4Z.S,Q
M,RXS.#(N,#DQ,3LR,#<U($9O<G0@4W1R965T+" ],$0],$%3=&4@,C T.TQI
M;F-O;&X@4&%R:SM-23LT.#$T-CM54T$-"DQ!0D5,.U=/4DL[14Y#3T1)3D<]
M455/5$5$+5!224Y404),13HS,3,N,S@R+C Y,3$],$0],$$R,#<U($9O<G0@
M4W1R965T+" ],$0],$%3=&4@,C T/3!$/3!!3&EN8V]L;B!087)K+"!-22 T
M.#$T/0T*-CTP1#TP055300T*55),.FAT=' Z+R]W=W<N=V5B<V-H96UA=&EC
M<RYC;VT-"E523#IH='1P.B\O=W=W+FUO<G1G86=E>65L;&]W<&%G97,N8V]M
M#0I%34%)3#M)3E1%4DY%5#IW96)B97) ;6]R=&=A9V5Y96QL;W=P86=E<RYC
M;VT-"D5-04E,.TE.5$523D54.G)O8FEN;'ES;VY =V5B<V-H96UA=&EC<RYC
M;VT-"D5-04E,.TE.5$523D54.G)O8FEN;'ES;VY =W)I=&5M92YC;VT-"D5-
M04E,.U!2148[24Y415).150Z;7EP9W- :&]M92YC;VT-"E)%5CHR,# Q,#,R
6-%0Q-S0V,S=:#0I%3D0Z5D-!4D0-"@``
`
end
Alexey Alexapolsky
Posted: 03/26/2001, 7:33 AM

You must check "Key" checkbox on the left of your field if
you don't want it to be duplicate.

--
Regards,
Alexey
CodeCharge Support



Webber <webber@mortgageyellowpages.com> wrote in message
news:99imkn$djl$1@mail.tankhill.com...
> I created a single ASP page very simple insert record to my MS Access db.
I
> am still learning this product but the help files, etc. really do not
> explain how to use the page & form events, etc.
>
> On top of this I am fairly new to scripting and I want to be able to stop
> duplicate records from being entered but I don't really know how:
> a) what script do I use to stop duplicate records?
> b) where do I put this script in codecharge?
> c) is there a reference somewhere that will instruct me on how & where to
do
> this?
>
> the url I am working with is at
> http://www.mortgageyellowpages.com/test/bregister.asp
>
> Thank you in advance for any help on this.
>
> Webber
>
>
>

Webber
Posted: 03/27/2001, 8:44 AM

Hi Alexey,

I couldn't get it to work with your example, but when I checked the "unique"
box in the field, it worked.

Is this correct, or did I do something wrong.

Please advise,

Robin

"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:99nne8$eje$1@mail.tankhill.com...
> You must check "Key" checkbox on the left of your field if
> you don't want it to be duplicate.
>
> --
> Regards,
> Alexey
> CodeCharge Support
>
>
>
> Webber <webber@mortgageyellowpages.com> wrote in message
>news:99imkn$djl$1@mail.tankhill.com...
> > I created a single ASP page very simple insert record to my MS Access
db.
> I
> > am still learning this product but the help files, etc. really do not
> > explain how to use the page & form events, etc.
> >
> > On top of this I am fairly new to scripting and I want to be able to
stop
> > duplicate records from being entered but I don't really know how:
> > a) what script do I use to stop duplicate records?
> > b) where do I put this script in codecharge?
> > c) is there a reference somewhere that will instruct me on how & where
to
> do
> > this?
> >
> > the url I am working with is at
> > http://www.mortgageyellowpages.com/test/bregister.asp
> >
> > Thank you in advance for any help on this.
> >
> > Webber
> >
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.