Thanks!
Code:
<% @language="vbscript" %> <% Response.buffer = true %> <html> <head> <title> NC NE&P Panel Data</title> </head> <body background="\..\background.jpg"> <% '************************************************************
Jimgunkel
Last Activity: Oct 15 '10, 05:40 PM
Joined: Jul 20 '10
Location: Fort Wayne, IN
-
I changed the code in line 37 and the web page is deleting records.
Thanks!
... -
New error message:
Technical Information (for support personnel)
Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'close'
/paneldatatest/indiana/fdp/deletepaneldefa ult.asp, line 45
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; .NET CLR 3.0.4506.2152;...Last edited by jhardman; Oct 11 '10, 09:27 PM. Reason: fixed code tags. Thanks for trying! and please continue to use them in the futureLeave a comment:
-
Will this command work with MS Access. I tried it - I no longer get an error message but the data was not deleted.
...Code:locvar = Request.QueryString("loc") locCount = 1 Set MyConn = Server.CreateObject("ADODB.Connection") ' Establish the connection object MyConn.Open ("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Inetpub\wwwroot\paneldatatest\databases\FDPIN.mdb;Uid=;Pwd=niemtel;")Leave a comment:
-
I'm getting a new error message:
Technical Information (for support personnel)
Error Type:
Microsoft VBScript compilation (0x800A0400)
Expected statement
/paneldatatest/indiana/fdp/deletepaneldefa ult.asp, line 49
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729;...Leave a comment:
-
Jared
I am tring to delete 12 or more rows from my Access Database.
Thanks JimLeave a comment:
-
How can I delete records from Access
Error message
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E23)
Row handle referred to a deleted row or a row marked for deletion.
/paneldatatest/indiana/fdp/deletepaneldefa ult.asp, line 56
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E)... -
Thanks this worksLeave a comment:
-
JKing - The MS value is not a constant I used it as an example other info may need to change like 1099009FDP009MS 01 to 1099009FDP008MS 03 as an example. So a simple way may not work. I'm all for simple if possable but I need the flexability to change more than one peramiter. Sorry if I was to vague.Leave a comment:
-
Getting new error:
Microsoft VBScript compilation (0x800A03EA)
Syntax error
/paneldatatest/indiana/fdp/movepaneldefaul t.asp, line 61, column 7
Code:Public Function MakeNewLoc(ByVal loc As Variant) AS String
Leave a comment:
-
Sorry - I was tring a few things and forgot to add it back in to the code.
I'm game to try a different way.Code:'UPDATE panel sqlUPDATE = "UPDATE panel SET PlantLoc = '" & newlocvar & "' WHERE PlantLoc = '" & locvar & "'" MyConn.Execute sqlUPDATE
Leave a comment:
-
I'm not getting an error but the database is not being updated with the new key data "PlantLoc".
...Code:<% @language="vbscript" %> <% Response.buffer = true %> <% '************************************************************ 'ADO is the keyword for google searches on help with DB stuff '************************************************************
Leave a comment:
-
Same error
...Code:locvar = Request.Form("loc") newlocvar = Request.Form("loc") locCount = 1 locSize = Request.Form("ps") locSize = Cint(locSize) Set MyConn = Server.CreateObject("ADODB.Connection") ' Establish the connection object MyConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Paneldata\Databases\FDPIN.mdb;JetLeave a comment:
-
Getting a new error:
Microsoft JET Database Engine (0x80040E14)
Syntax error in UPDATE statement.
/paneldatatest/indiana/fdp/movepaneldefaul t.asp, line 65
Line 65 is "MyConn.Exe cute sqlUPDATE"Code:sqlUPDATE = "UPDATE panel SET key = " & newlocvar & " WHERE key = " & locvar MyConn.Execute sqlUPDATE
Leave a comment:
-
Getting a new error:
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/paneldatatest/indiana/fdp/movepaneldefaul t.asp, line 65, column 18
Code:'UPDATE panel SET key = newlocvar WHERE key = locvar;
Leave a comment:
-
Is there a way to change my primary key in Access using ASP?
Is there a way to change my primary key in Access using ASP?
My primary key looks like this:
1101001CXR001MS 01-01 thru 1101001CXR001MS 01-24
I want to change MS01 to MS04.
...Code:<% locvar = Request.Form("loc") newlocvar = Request.Form("loc") locCount = 1 locSize = Request.Form("ps") -
I was missing the "0" on 01-09. Thanks for your help!Leave a comment:
-
Jared thanks that fixed my type mismatch but now I'm getting a different error message:
Technical Information (for support personnel)
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/paneldatatest/indiana/fdp/updatefibercomm ents.asp, line 38
Browser Type:
...Leave a comment:
-
Microsoft VBScript runtime (0x800A000D) Type mismatch
Error message:
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch
/paneldatatest/indiana/fdp/updatefibercomm ents.asp, line 59
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
...Leave a comment:
-
Microsoft VBScript runtime (0x800A000D) Type mismatch
I'm getting an error message:
Technical Information (for support personnel)
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch
/paneldatatest/indiana/fdp/updatefibercomm ents.asp, line 61
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
...Last edited by Niheel; Jul 27 '10, 08:13 PM. Reason: added code tags around code [code] . . . [/code]
No activity results to display
Leave a comment: