473,511 Members | 15,630 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Missing Something ( Insert )

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?

<CODE>
...........

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
...........

</CODE>

any help is appreciated.....

Jan 11 '07 #1
2 1310

"Mangler" <dw******@directwireless.comwrote in message
news:11**********************@77g2000hsv.googlegro ups.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?

<CODE>
..........

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

..........

</CODE>

any help is appreciated.....

Jan 12 '07 #2

Mark J. McGinty wrote:
"Mangler" <dw******@directwireless.comwrote in message
news:11**********************@77g2000hsv.googlegro ups.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?

<CODE>
..........

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......

Jan 12 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
18031
by: dcarson | last post by:
I've read about this error in several other discussions, but still can't seem to pinpoint the problem with my code. Everything seemed to be working fine for some time, but it now tends to bomb out...
2
6376
by: btober | last post by:
I run the following script to export some data from my development database and then update or insert the records into to the quality assurance testing database, but I get a warning notice that I...
1
4575
by: JMCN | last post by:
I have an ftp program that i inherited and i tried to modify it to ftp over my file however, i receive an error message : run-time error '3075 syntax error (missing operator) in query expression...
2
9255
by: jannordgreen | last post by:
I am using Winxp and Ms Access 2003. I get this error message: error 3137, Missing semicolon (;) at end of SQL statement when I run this code: Dim I As Integer For I = 0 To...
2
1316
by: Ike | last post by:
Im wondering if someone can take a look at this simple INSERT statement which is puking on me. I KNOW I must have something stupid in it that I am NOT seeing, which will likely be obvious to...
4
25488
by: Mahesh BS | last post by:
Hello, I need to write a query to find out a set of missing number in a given sequence. Eg : a Column in some table has the following data
3
3915
by: danceli | last post by:
After loading the BCP files that are created during the trigger/ reporting events I've noticed that the data in the table is missing records. I've also noticed that the missing records (records in...
3
16890
by: anupamadatta | last post by:
Hi there, I am trying to execute one Insert query using Pro C . the Insert query is as below: Prepared statement is : stmnt.len = sprintf((char*)stmnt.arr, "INSERT INTO %s ("...
5
1980
by: fennychieck | last post by:
dear all, i've a problem here. everytime a user click on "approve" button, they'll always get database error. and when i check the error log, there are several fields that have missing...
0
7242
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7138
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7508
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5662
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5063
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4737
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3222
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3212
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1572
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.