|
| |
|
|
kkwwex
Posts: 6
Joined: 3/4/2008
Status: offline
 |
Database Wizard Results Error Again - 3/4/2008 18:25:47
I came across this post back in 2005 when the issue first arose. I replaced the 2000 fpclass files and everything worked perfectly and then a few months, it started happening again. The weird pary is my pages work just fine and information are continuing to update on the database, however I am not able to able to update queries in Frontpage. I get a Database Wizard Results Error. I followed the link provided by Microsoft, updated both my webserver and my local machine to SP2 and then resave all asp files that contains the database results wizard and it still doesn;t work. I tried to replacing the fpclass files again and that didnt work either. The pages that are affected contains the UPDATE and INSERT INTO function. I'm at a loss, can someone please help??
|
|
|
|
kkwwex
Posts: 6
Joined: 3/4/2008
Status: offline
|
RE: Database Wizard Results Error Again - 3/5/2008 9:59:21
It won't even let me do that and unfortunately the only error that comes up is "Custom query contains error" and it doesn't provide any more details.
the script runs just fine when i pull up the webpage but I can't edit the codes. here's the code I'm trying to edit. I just need to add another column.
INSERT INTO Results (FranchiseNbr,Contact,Phone,AirbillNbr,CheckNbr,CheckDate,CheckAmount,ReimburseAmt,Reason,Submitted) Values('::FranchiseNbr::','::Contact::','::Phone::','::AirbillNbr::','::CheckNbr::',cdate(#::CheckDate::#),'::CheckAmount::','::ReimburseAmt::','::Reason::',#::Submitted::#)
here's the 2nd code:
SELECT * FROM Results
WHERE FranchiseNbr= '::FranchiseNbr::' AND Submitted=cdate('::Submitted::')
ORDER BY ID DESC
| |
|
|
|
kkwwex
Posts: 6
Joined: 3/4/2008
Status: offline
|
RE: Database Wizard Results Error Again - 3/5/2008 18:38:05
Ok, after wasting 2 days on this, I figured it out. I stopped screwing with the Frontpage Data Results Wizard and just hard code the changes in the code view in the webbot script.
urgg.
| |
|
 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¥ 