T
TV12 Webmaster
I was working on a new website http://12.20.136.102 using asp pages and
databases for all the text. Works fine diplaying the data from the
databases. Problem: I use a menu to bring up the data in a form so the user
can change it and send the new data to the database.
http://12.20.136.102/nbctmenu.asp You click the hyperlink and that sends
the existing data to the form. The user changes the data and clicks the
button.. this sends the data to a database results wizard with a query to do
the following:
UPDATE frontpage <--the name of the database
SET headline='::headline::' <--text data
WHERE id=::id:: <-numerical data
Here is the error I get
Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.
I have other websites on my computer and on the internet that do the exact
same function and work great (www.enctrader.com) I have searched MS
knowledge base and came up with a "timestamp problem" that doesn't apply and
an "empty number fields not recognized as numbers" but that didn't fix it
either. I have deleted the global.asa file and recreated it, no change. I
have FP 2003, XP Professional, Access 2003. This is the first website I
have created from scratch with FP2003. The other webs I made with FP 2000.
I don't know what else to try.
Erik Hardtle
These are the websites that use the same function for updating.
www.wcti12.com
www.enctrader.com
www.always-online.com
databases for all the text. Works fine diplaying the data from the
databases. Problem: I use a menu to bring up the data in a form so the user
can change it and send the new data to the database.
http://12.20.136.102/nbctmenu.asp You click the hyperlink and that sends
the existing data to the form. The user changes the data and clicks the
button.. this sends the data to a database results wizard with a query to do
the following:
UPDATE frontpage <--the name of the database
SET headline='::headline::' <--text data
WHERE id=::id:: <-numerical data
Here is the error I get
Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.
I have other websites on my computer and on the internet that do the exact
same function and work great (www.enctrader.com) I have searched MS
knowledge base and came up with a "timestamp problem" that doesn't apply and
an "empty number fields not recognized as numbers" but that didn't fix it
either. I have deleted the global.asa file and recreated it, no change. I
have FP 2003, XP Professional, Access 2003. This is the first website I
have created from scratch with FP2003. The other webs I made with FP 2000.
I don't know what else to try.
Erik Hardtle
These are the websites that use the same function for updating.
www.wcti12.com
www.enctrader.com
www.always-online.com