msgbox permission error

JohnYingling · Sep 24, 2001

You are trying to POP a MSGBOX on the server. That isn't allowed. Who is going to answer? Perhaps you want to write HTML to the client with an <Input TYPE=text Name=Delet Value=""> and check for a ("Y" or "y&quot

on the next response.

Microbe · Sep 24, 2001

Aha...I see the problem now...of course.

So, what is MsgBox for then????? Steve Davis
hey.you@hahaha.com.au

JohnYingling · Sep 24, 2001

Most pages I've seen use a button with an OnClick Event in the client side script and doing a "Window.Submit"???? if the answer is "Y" i.e the script writtem to the page where the user specifies delete. I have not had to use client side script (I mostly access other sites like a credit bureau withe the VB WebBrwoser Control).

Microbe · Sep 24, 2001

Yeah, I solved it by just tossing to a new page with a confirm and then deletes on a "yes"

A msgbox would have been tidier theough ;o)

Thanks for that, solved something that has niggled for ages. Steve Davis
hey.you@hahaha.com.au

JohnYingling · Sep 24, 2001

Yeah, when they come after me to convert my "open new customers/accounts/atm cards/autotransfers/etc while asynchronously checking checking credit bureaus, OFAC frozen assets, zip codes on the internet and his/her mama VB desktop app" to the intranet, I'll be looking at Client Side Script, but golly gee...guess what? That darm VB desktop app just "snaps" the screens so fast that the users can't be moved to an intrnet app with dynamite.

Ovatvvon · Sep 24, 2001

you CAN use the msgbox to confirm the delte of a file by sending the confirmation script to the client side. If you just write it client side and substitute in the variables, it should work. I have used this option many times!! works nice!
-Ovatvvon :-Q

JohnYingling · Sep 25, 2001

How about posting a code example?

Ovatvvon · Sep 25, 2001

Yeah, no problem John,

Let's assume that you have a bunch of email addresses in a database. You have them displayed on a page in order of the database. You make them a link so when someone clicks on it, they are selecting they want to delete that email address. (for simplicities sake).

Then, on click, you'll have it run the vbscript, which will confirm you want to delete that one. It will pass that database object to the script for processing.

You have a database, it's called mydb.mdb. fields in it are userPK, userName, and userEmail.

==============================================================

<html>
<head>
<title>My Sample Page</title>

<script language='VBScript'>
<!--
function deleteIt(pk, name)
Dim yesNo
yesNo = MsgBox("Are you sure you want to delete " & name & "'s email address?", vbYesNo+vbQuestion, "Delete?&quot

If yesNo = vbYes then
document.location.href = "deleteEmailPage.asp?userID=" & pk
end If
end function
-->
</script>

</head>
<body>

<%
Dim conn, connString, rs, sql

sql = "SELECT * FROM mydbTable;"
Set conn = Server.CreateObject("ADODB.connection&quot

connString = "DRIVER = {Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/db/mydb.mdb&quot

& ";"
conn.Open connString
Set rs = Server.CreateObject("ADODB.Recordset&quot

rs.Open sql, conn, 0, 1

Do while not rs.EOF
Response.write("Name = <DIV ID='" & rs("userName&quot

& "' style='cursor:hand;' onClick=""deleteIt(" & rs("userPK&quot

& ", '" & rs("userName&quot

& "')"">" & rs("userName&quot

& "</DIV><BR>&quot

Response.write("Email = <DIV ID='" & rs("userName&quot

& "1' style='cursor:hand;' onClick=""deleteIt(" & rs("userPK&quot

& ", '" & rs("userName&quot

& "')"">" & rs("userEmail&quot

& "</DIV><BR><BR>&quot

rs.MoveNext
Loop

rs.Close
conn.Close
Set rs = nothing
Set conn = nothing
%>

</body>
</html>

Hope this helps...

-Ovatvvon :-Q

Ovatvvon · Sep 26, 2001

Does this help?
-Ovatvvon :-Q

Microbe · Sep 26, 2001

Yes.

So was the problem I was having (look at the original message) because I was trying to use the querystring value in the msgbox????

That is the only difference I can see in what you posted and what I was trying. Steve Davis
hey.you@hahaha.com.au