Hi

Trying to delete multiple records from MX & Access Database. Having error:

Error Type:
Microsoft JScript compilation (0x800A03EC)
Expected ';'
/Contact/landlord_delete.asp, line 4, column 3
If Request.Form("Process"="True" Then
--^


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

Page:
GET /Contact/landlord_delete.asp

Here is the code using from a Tutorial from Webthang:

<%
If Request.Form("Process"="True" Then
//First check for a selection
If Request.Form("cSelect"="" Then
Response.Redirect "delete.asp"
End If
//Proceed with delete
Dim sDelete
sDelete = Replace(Request.Form, "&cSelect=", ","
sDelete = Replace(sDelete, "cSelect=", ""
sDelete = Left(sDelete, Len(sDelete)-13)

set cDelete = Server.CreateObject("ADODB.Command"
cDelete.ActiveConnection = MM_ contact _STRING
cDelete.CommandText = "DELETE FROM Landlord WHERE Landlord.ID IN (" & sDelete & ""
cDelete.CommandType = 1
cDelete.CommandTimeout = 0
cDelete.Prepared = true
cDelete.Execute()
Response.Redirect("landlord_delete_success.asp"

End If
%>

Form Name: <form action="landlord_delete_success.asp" method="post" name="frmselect" id="frmselect">
Checkbox: <input type="checkbox" name="cSelect" value="<%=(rslord.Fields.Item("ID".Value)%>">

Hidden: <input type="hidden" name="Process" value="True">


Please help me, I checked the tutorial, adjactly same I tried to configure, don't why its not showing the page........

Is there any alternative way I can do it???
Many thanks





Babu

are your connections set properly in the global.asa file?

Hi

Should I have to use global.asa file, I checked on the tutorial there wasn't mention to use global.asa

This is the first time I am trying to do...admin section (delete)

Look forward from you.

Babu

Hi

Does any one knows where I can get an Extension for Update/Delete/Add in DWMX

Can anyone point me out.....need a cheap cost extension.

Look forward from you

Babu

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Does any one knows where I can get an Extension for Update/Delete/Add in DWMX<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Cheap, sorta... great, yes. I would take a good look at Interakts' ImpAKT & NeXTensio - which are bundled into MX Kollection 2 (version 3 is out in a couple months, so there's a 50% off v2)!

www.interaktonline.com

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>

Hi

Thanks, just downloaded from Interact trial version, not - BUT IT IS TOOOOOOOOOOO EXPENSIVE

Regards

Babu

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Thanks, just downloaded from Interact trial version, not - BUT IT IS TOOOOOOOOOOO EXPENSIVE<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
It's really GOOOOOOOOOOOOOOOOOOOOOOOD.

<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>

Thanks

Trying to configure.....but it does not work...properly...............<img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle><img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Regards

Babu