Missing Something ( Insert )
am 11.01.2007 22:25:23 von dwaldman
I am running a stored proc that aborts an insert if the result is "YES"
Well all inserts are being aborted and i cant figure out why. Maybe I
am missing a line or have something wrong?
...........
If (spDupresult) = "YES" Then
MM_abortEdit = true
If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
If (MM_editRedirectUrl <> "") Then
Response.Redirect(MM_editRedirectUrl)
End If
End If
End If
...........
any help is appreciated.....
Re: Missing Something ( Insert )
am 12.01.2007 05:13:11 von mmcginty
"Mangler" wrote in message
news:1168550722.616135.231520@77g2000hsv.googlegroups.com...
>I am running a stored proc that aborts an insert if the result is "YES"
>
> Well all inserts are being aborted and i cant figure out why. Maybe I
> am missing a line or have something wrong?
>
>
> ..........
>
> If (spDupresult) = "YES" Then
> MM_abortEdit = true
End If
> If (Not MM_abortEdit) Then
> ' execute the insert
> Set MM_editCmd = Server.CreateObject("ADODB.Command")
> MM_editCmd.ActiveConnection = MM_editConnection
> MM_editCmd.CommandText = MM_editQuery
> MM_editCmd.Execute
> MM_editCmd.ActiveConnection.Close
>
> If (MM_editRedirectUrl <> "") Then
> Response.Redirect(MM_editRedirectUrl)
> End If
> End If
> ' ****** commented End If
-Mark
> ..........
>
>
>
> any help is appreciated.....
>
Re: Missing Something ( Insert )
am 12.01.2007 15:03:51 von dwaldman
Mark J. McGinty wrote:
> "Mangler" wrote in message
> news:1168550722.616135.231520@77g2000hsv.googlegroups.com...
> >I am running a stored proc that aborts an insert if the result is "YES"
> >
> > Well all inserts are being aborted and i cant figure out why. Maybe I
> > am missing a line or have something wrong?
> >
> >
> > ..........
> >
> > If (spDupresult) = "YES" Then
> > MM_abortEdit = true
>
> End If
>
>
> > If (Not MM_abortEdit) Then
> > ' execute the insert
> > Set MM_editCmd = Server.CreateObject("ADODB.Command")
> > MM_editCmd.ActiveConnection = MM_editConnection
> > MM_editCmd.CommandText = MM_editQuery
> > MM_editCmd.Execute
> > MM_editCmd.ActiveConnection.Close
> >
> > If (MM_editRedirectUrl <> "") Then
> > Response.Redirect(MM_editRedirectUrl)
> > End If
> > End If
>
>
> > ' ****** commented End If
>
>
> -Mark
I am getting the same results.... not working right......