?
using the DIW is not hand coding anything
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________
| I've started from scratch and made all pages up without using the DIW, i've
| got my list to choose form, and my editable page, but it doesn't seem to
| workis there a way that i can check that the paramaters are being passed from
| the form to the trackerupdate.asp page
|
| I've set the form method to post and Action to trackerupdate.asp.
|
| any ideas
|
|
| Al....
|
| "Thomas A. Rowe" wrote:
|
| > Have you consider learning to hand code?
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > ==============================================
| > If you feel your current issue is a results of installing
| > a Service Pack or security update, please contact
| > Microsoft Product Support Services:
| >
http://support.microsoft.com
| > If the problem can be shown to have been caused by a
| > security update, then there is usually no charge for the call.
| > ==============================================
| >
| > | > > it doesn't show as a subsite, also if i dont use the option then it creates a
| > > whole new site and asks for another location to write it to, which we know
| > > works until you reboot your unit
| > >
| > > Al.... <---- losing hair by the minute
| > >
| > > "Thomas A. Rowe" wrote:
| > >
| > >> The problem with #5 is that FP is create subsite under Tracker, when you use that option.
| > >>
| > >> --
| > >> ==============================================
| > >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> ==============================================
| > >> If you feel your current issue is a results of installing
| > >> a Service Pack or security update, please contact
| > >> Microsoft Product Support Services:
| > >>
http://support.microsoft.com
| > >> If the problem can be shown to have been caused by a
| > >> security update, then there is usually no charge for the call.
| > >> ==============================================
| > >>
| > >> | > >> > Sorry but it doesn't work.
| > >> > 1) I opened up the remote website within FP i.e. the http:// site
| > >> > 2) I created a folder called tracker, converted it to a web.
| > >> > 3) Opened it up
| > >> > 4) imported tracker.mdb assigned name. FP moved it and said it should be
| > >> > within an fpdb folder and moved it into there.
| > >> > 5)Used DIW to create basic site i never filled any options except Add to
| > >> > existing web, use existing database & edite delete files.
| > >> >
| > >> > Above is just the same as New|DIW (don't click add to current web) a new
| > >> > site is created and then you stick in your information, publish it and it
| > >> > works ok, until you reboot.
| > >> >
| > >> > There is something missing or something that changes after a reboot.
| > >> >
| > >> > I am just using a standard desktop with the IIS installed, would this make a
| > >> > difference.
| > >> >
| > >> >
| > >> > Al....
| > >> >
| > >> >
| > >> > "Thomas A. Rowe" wrote:
| > >> >
| > >> >> 1. Open the root web in FP via http://
| > >> >> 2. Create the folder tracker, then convert to a subweb/subsite
| > >> >> 3. Double click the tracker subweb/subsite to open
| > >> >> 4. Import your tracker.mdb, assign connection name and then let FP move it to the fpdb folder
| > >> >> 5. Use the DIW to create your asp pages within the tracker subweb/subsite. The only path you
| > >> >> should
| > >> >> see is: \tracker\fpdb\tracker.mdb
| > >> >> --
| > >> >> ==============================================
| > >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> >> ==============================================
| > >> >> If you feel your current issue is a results of installing
| > >> >> a Service Pack or security update, please contact
| > >> >> Microsoft Product Support Services:
| > >> >>
http://support.microsoft.com
| > >> >> If the problem can be shown to have been caused by a
| > >> >> security update, then there is usually no charge for the call.
| > >> >> ==============================================
| > >> >>
| > >> >> | > >> >> > because of he trouble i've been having i have totally removed the DIW from
| > >> >> > the current website, I clicked New|DIW told it where i want the site FP made
| > >> >> > up a new site for the tracker database and I let FP set up the basic
| > >> >> > somponents, after publishing everything works fine, however when i reboot my
| > >> >> > unit everything is screwed up again.
| > >> >> >
| > >> >> > Database Results Wizard Error
| > >> >> > 'c:\inetpub\wwwroot\tracker\tracker_interface\Results\fpdb\tracker.mdb' is
| > >> >> > not a valid path. Make sure that the path name is spelled correctly and that
| > >> >> > you are connected to the server on which the file resides.
| > >> >> >
| > >> >> > I can tell you that FP put the database file in the tracker/fpdb folder,
| > >> >> > i've touched nothing and it doesn't work.
| > >> >> >
| > >> >> > So what's happening in that reboot.
| > >> >> >
| > >> >> >
| > >> >> > Al....
| > >> >> >
| > >> >> > "Thomas A. Rowe" wrote:
| > >> >> >
| > >> >> >> However if you want this to work, you would need to export the database to your desktop,
| > >> >> >> then
| > >> >> >> open
| > >> >> >> the tracker subweb and then import the database, then run the DIW, etc from within the
| > >> >> >> tracker
| > >> >> >> subweb.
| > >> >> >>
| > >> >> >> You will also need to open the root web, then Tools | Site Settings | Database and delete
| > >> >> >> the
| > >> >> >> tracker connection.
| > >> >> >>
| > >> >> >> When you work with FP database components, the database must be within the fpdb folder
| > >> >> >> within
| > >> >> >> the
| > >> >> >> subweb/subsite where it is being accessed from or it will not work.
| > >> >> >>
| > >> >> >> --
| > >> >> >> ==============================================
| > >> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> >> >> ==============================================
| > >> >> >> If you feel your current issue is a results of installing
| > >> >> >> a Service Pack or security update, please contact
| > >> >> >> Microsoft Product Support Services:
| > >> >> >>
http://support.microsoft.com
| > >> >> >> If the problem can be shown to have been caused by a
| > >> >> >> security update, then there is usually no charge for the call.
| > >> >> >> ==============================================
| > >> >> >>
| > >> >> >> | > >> >> >> > OK stefan i'll explain from the beginning
| > >> >> >> >
| > >> >> >> > I have a website with about 9 databases on it, i was asked to create another
| > >> >> >> > database which would be editable, i opened FP opened up the website i had
| > >> >> >> > created then clicked NEW/Database Interface wizard and check the box that
| > >> >> >> > says "Add to current Website"
| > >> >> >> >
| > >> >> >> > Then follow the options on screen
| > >> >> >> > After everything is setup the tracker.mdb file is in the route directory
| > >> >> >> > fpdb folder and not tracker/fpdb. this was setup by FP if i try to view it
| > >> >> >> > after publishing i get an error stating that it cannot find the tracker.mdb
| > >> >> >> > file in the tracker/fpdb folder.
| > >> >> >> >
| > >> >> >> > If i go into Tools/Site Settings and click the database tab then verify the
| > >> >> >> > tracker.mdb file it screws up all of the other databases as it thinks they
| > >> >> >> > are in the tracker/fpdb folder which doesn't exist.
| > >> >> >> >
| > >> >> >> > At that point i copied the fpdb folder form the main directory into the
| > >> >> >> > tracker/fpdb folder. after publishing i could read from the database files
| > >> >> >> > but could not write to them.
| > >> >> >> >
| > >> >> >> > i also checked the global.asa file and it showed all of the databases being
| > >> >> >> > in fpdb/filename.mdb bwhich if i'm not mistaken is the the fpdb folder in the
| > >> >> >> > route web.
| > >> >> >> >
| > >> >> >> > So if FP didn't screw up the first time i wouldn't have had any problems.
| > >> >> >> >
| > >> >> >> >
| > >> >> >> >
| > >> >> >> > Al....
| > >> >> >> > "Stefan B Rusynko" wrote:
| > >> >> >> >
| > >> >> >> >> When you import a FP DB, FP creates the fpdb folder and it's unique permissions
| > >> >> >> >> (read/write)
| > >> >> >> >> in
| > >> >> >> >> the root web
| > >> >> >> >> - you can't just copy that folder anywhere and expect it to work
| > >> >> >> >>
| > >> >> >> >> If you need the DBRW in a subweb (tracker) you need to import the DB into the subweb and
| > >> >> >> >> let
| > >> >> >> >> FP
| > >> >> >> >> create the folder and it's
| > >> >> >> >> permissions
| > >> >> >> >>
| > >> >> >> >> --
| > >> >> >> >>
| > >> >> >> >> _____________________________________________
| > >> >> >> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > >> >> >> >> "Warning - Using the F1 Key will not break anything!" (-;
| > >> >> >> >> To find the best Newsgroup for FrontPage support see:
| > >> >> >> >>
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > >> >> >> >> _____________________________________________
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >> >> | > >> >> >> >> | Ok i've had to reboot my unit, now i can't get the original site with
| > >> >> >> >> | databases to work with the Editable database created by the FPBDW, it either
| > >> >> >> >> | one or the other.
| > >> >> >> >> | When i created the Editable database i specified for it to be used in the
| > >> >> >> >> | existing website, it also locates the .mdb file within the fpdb folder on the
| > >> >> >> >> | main site, but it doesn't work as it seems to think that the .mdb file is
| > >> >> >> >> | within a fpdb folder in the editable database folder in this case "tracker"
| > >> >> >> >> | unfortunately when this happens all databses point to "tracker/fpdb". if i
| > >> >> >> >> | copy the fpdb folder from the main site into the "tracker/fpdb" folder then i
| > >> >> >> >> | can read all databases but i can't write to them.
| > >> >> >> >> |
| > >> >> >> >> | Why does frontpage allow you top setup an editable database within the
| > >> >> >> >> | current website then not allow it to work.
| > >> >> >> >> |
| > >> >> >> >> | Why does fp think that all my databases are within a folder that doesn't
| > >> >> >> >> | exist, even after i have reverified their location.
| > >> >> >> >> |
| > >> >> >> >> | Does this mean that i'm gonna have to create a different site for this
| > >> >> >> >> | editable database. since FP doesn't have a clue (like me) what happening with
| > >> >> >> >> | the files it's setting up.
| > >> >> >> >> |
| > >> >> >> >> |
| > >> >> >> >> |
| > >> >> >> >> | Al.... <------Confused
| > >> >> >> >> |
| > >> >> >> >> |
| > >> >> >> >> | "Sproul" wrote:
| > >> >> >> >> |
| > >> >> >> >> | > I've managed to get it to work, however when i went into SITE Setings and
| > >> >> >> >> | > verified the database, i got an error when published.
| > >> >> >> >> | >
| > >> >> >> >> | > For some reason when i use the database interface wizard with in an existing
| > >> >> >> >> | > site then verify the .mdb file it screws up all databases on the site as it
| > >> >> >> >> | > thinks that they are within an fpdb folder within the subfolder that the .asp
| > >> >> >> >> | > file i'm using is in, instead of the fpdb folder within the main site
| > >> >> >> >> | > directory.
| > >> >> >> >> | > I also made sure that all the verified databases were pointing to the
| > >> >> >> >> | > correct place. It seems that if i re point the .mdb files in site
| > >> >> >> >> | > setting/databases and don't verify them, then everything works fine.
| > >> >> >> >> | >
| > >> >> >> >> | > I've got everything going and even managed to edit some things into it, but
| > >> >> >> >> | > would like to know why verifying the Databases kills the connection.
| > >> >> >> >> | >
| > >> >> >> >> | >
| > >> >> >> >> | > Al....
| > >> >> >> >> | >
| > >> >> >> >> | > "Andrew Murray" wrote:
| > >> >> >> >> | >
| > >> >> >> >> | > > I've had that problem with the update routine - but I think it's a "bug" in
| > >> >> >> >> | > > Frontpage and how it generates that code.
| > >> >> >> >> | > >
| > >> >> >> >> | > > | > >> >> >> >> | > > > I've been trying to setup a database update page through FP2003, i'm
| > >> >> >> >> | > > > allowing
| > >> >> >> >> | > > > it to create everything, then i publish it.
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > I can add, view and delete records but for some reason i can't update.
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > the error i get is
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > Database Results Wizard Error
| > >> >> >> >> | > > > Description: Syntax error in UPDATE statement.
| > >> >> >> >> | > > > Number: -2147217900 (0x80040E14)
| > >> >> >> >> | > > > Source: Microsoft JET Database Engine
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > the update statement is
| > >> >> >> >> | > > >
| > >> >> >> >> | > > > UPDATE Results SET Action = '::Action::' , Raised_By = '::Raised_By::' ,
| > >> >> >> >> | > > > Choice = '::Choice::' , Owner = '::Owner::' , Status = '::Status::' ,
| > >> >> >> >> | > > > Comments = '::Comments::' WHERE (Key = ::Key:
| > >> >> >> >> | > >
| > >> >> >> >> | > >
| > >> >> >> >> | > >
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >> >>
