Database Wizard Results Error Again (Full Version)

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



Message

kkwwex -> 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??



Spooky -> RE: Database Wizard Results Error Again (3/5/2008 1:03:30)

Do the statements contain any reserved words? its a list that is under constant review, there may be words you have previously used that are now not available.
Place brackets [ ] around all of the column names in the SQL statements to confirm.
Failing that though, it would be best to see an error message



kkwwex -> 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 -> 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.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875