Wrox Home  
Search P2P Archive for: Go

  Return to Index  

javascript_objects thread: ADODB.Parameters error 800a0d27


Message #1 by "Donna Leeb" <dleeb@j...> on Sat, 26 Oct 2002 01:14:31
I'm glad that it helped.  But please, next time, post it on appropriate 
list
:)

> -----Message d'origine-----
> De : Donna Leeb [mailto:dleeb@j...]
> Envoy=C3=A9 : mercredi 30 octobre 2002 19:33
> =C3=80 : JavaScript Objects
> Objet : [javascript_objects] RE: ADODB.Parameters error 800a0d27
>
>
> > This is actually an ADO+ASP (maybe + JScript) issue, not really
> JavaScript
> issue.  But well, it doesn't matter for this time.  Keep on
> reading ......
>
> > [snipped]
> > <%@ LANGUAGE =3D JScript %>
> > <HTML>
> > <BODY>
> > <%
> > function Back()
> > {
> >    history.go(-1);
> > }
>
> 	This Back() is within <% ... %>, so it's server-side code.  Make
> sure there's really a history object (but I don't think so). 
> Normally,
> History is a client-side object.  So after you've solved this
> problem, the
> Back() function would give you another problem.
>
> > adoParam =3D adoCommand.CreateParameter("CMPTRN", adVarChar,
> > adParamInput,
> > 8, Request.Form("CMPTRN"));
> > [snipped]
> > adoParm =3D  adoCommand.CreateParameter("NOTE", adVarChar,
> > adParamInput, 30,
> > Request.Form("NOTE"));
>
> 	The problem comes from your typo mistake :)  You wrote adoParm
> instead of adoParam.
>
> 	You're repeating the same action again and again.  Why don't you
> write a wrapper function to do this?  Like this:
>
> function adoAppend (qString, n) {
> 	var adoParam =3D adoCommand.CreateParameter(qString, adVarChar,
> 		adParamInput, n, Request.Form(qString));
> 	adoCommand.Parameters.Append(adoParam);
> }
>
> Thank you for finding my error & the wrapper suggestion.
> Donna
>

  Return to Index