|
| |
|
|
4ank
Posts: 11
Joined: 2/11/2004
Status: offline
 |
Database Editor Problems - 4/30/2004 17:00:00
Hi all.
I seem to be having some trouble with my database editor since I changed my database around. I have the editor showing the records, but I cannot highlight a record and make changes. Is there any way to redo this page to get it operable? Thanks
Frank
|
|
|
|
4ank
Posts: 11
Joined: 2/11/2004
Status: offline
|
RE: Database Editor Problems - 5/5/2004 16:17:02
Unfortanatley, I do not have a url that can be accessed.
As for back-ups... I originally made this as a test, but I liked the way it turned out so I kept it. I did have backups until I though everything worked on the page...UNTIL i checked the database editor.
My problem is the I cannot highlight the records to modify them....the records are shown, but not able to be modified.
Is there anyway to recreate the database editor using an exhisiting database?
| |
|
|
|
Richard Dudley
Posts: 668
Joined: 8/22/2002
From: Butler, PA
Status: offline
|
RE: Database Editor Problems - 5/5/2004 19:30:34
What editor are you using, and with what database?
_____________________________
I need to change my avatar--the puppy is full grown now!
| |
|
|
|
4ank
Posts: 11
Joined: 2/11/2004
Status: offline
|
RE: Database Editor Problems - 5/5/2004 20:15:29
I am using the database editor automatically made by FP, if that is what you mean.
I went back and made changes manually so the editor works, but when I try to update or add a record, I am getting a javascipt error....When I try to debug it, it points to this line:
<form METHOD="POST" action="--WEBBOT-SELF--" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1">
Anyone have any clue...this is bothering me. Oh, and my apologies if this is a newb thing.
| |
|
|
|
4ank
Posts: 11
Joined: 2/11/2004
Status: offline
|
RE: Database Editor Problems - 5/5/2004 21:42:43
That is what I did. After I modified some by hand, i realized re-creating would be quicker.
On to my next case.
After recreating everything, I still cannot update an already exhisting record. It is giving me the error:
quote:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers
I compared the syntax on the update to one on a sample database I created in the page titled "update.asp" automatically created by frontpage.
Here is the UPDATE statement
quote:
fp_sQry="UPDATE Results SET VIN = '::VIN::' , Yr = '::Yr::' , Make = '::Make::' , Model = '::Model::' , Mileage = '::Mileage::' , Color = '::Color::' , Price = '::Price::' , Desc = '::Desc::' , Image = '::Image::' WHERE (Key = ::Key::)"
All help as always is appreciated.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 