Database Editor Problems (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

4ank -> 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



Spooky -> RE: Database Editor Problems (5/2/2004 14:16:01)

What sort of code are you using and is there a demo URL?
(And do you keep backups? :)



4ank -> 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 -> RE: Database Editor Problems (5/5/2004 19:30:34)

What editor are you using, and with what database?



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



Spooky -> RE: Database Editor Problems (5/5/2004 21:18:14)

Yes, Id just look at recreating it.
Assuming you havent customised the editor pages at all, just delete the folder that contains the database editor files (NOT the database!) and rebuild it using the wizard



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



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875