Cannot Add to database

[News]

Hi (again) to all,

Can anyone help me out with the following ?

I'm trying to "insert" records to my table called 'invoer' (yes, thats
dutch)
I followed a sample from "frontpagehowto.com" and used a custom
query-string like this :
Insert into invoer (naam) values ('::naam::')
The value comes from a page called insert.htm and the form
properties are set to 'send-to-other' and as action it would post to
addrecord.asp. (in my opinion this should work)
However when i publish the whole thing and enter some name
in the formfield 'naam' en click submit i keep getting the follwing error:
Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.
I'm using FP2003 and the database connection works fine, also created pages
to display other
data and that works. The above sample is just a test-table i've created in
my database because
i actually need to store much more information into other tables.
Give the above information, can somebody tell me what i did wrong and why
it's not working?

Thanks in advance for any idea's or suggestions,
(p.s.: i can't use the "send-to-database" option in the form-field
properties, i'm not using the
FP-servext.)

Gr. Arthur

 

[Stefan B Rusynko]

To see a more detailed error message temporarily, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file
At about line 19, change :
fp_DEBUG = False
to :
fp_DEBUG = True





| Hi (again) to all,
|
| Can anyone help me out with the following ?
|
| I'm trying to "insert" records to my table called 'invoer' (yes, thats
| dutch)
| I followed a sample from "frontpagehowto.com" and used a custom
| query-string like this :
| Insert into invoer (naam) values ('::naam::')
| The value comes from a page called insert.htm and the form
| properties are set to 'send-to-other' and as action it would post to
| addrecord.asp. (in my opinion this should work)
| However when i publish the whole thing and enter some name
| in the formfield 'naam' en click submit i keep getting the follwing error:
| Database Results Wizard Error
| The operation failed. If this continues, please contact your server
| administrator.
| I'm using FP2003 and the database connection works fine, also created pages
| to display other
| data and that works. The above sample is just a test-table i've created in
| my database because
| i actually need to store much more information into other tables.
| Give the above information, can somebody tell me what i did wrong and why
| it's not working?
|
| Thanks in advance for any idea's or suggestions,
| (p.s.: i can't use the "send-to-database" option in the form-field
| properties, i'm not using the
| FP-servext.)
|
| Gr. Arthur
|
|

 

[News]

I've changed that, it's Not working, it only changes the error message into
this:

Database Results Wizard Error
Unable to find operator in query string. Query string currently is Insert
into invoer (naam) values :naam:
I've tried the 'values' syntax in many ways like with ("::naam::") and
:naam: and ('naam') and (naam), but none of them seem
to work. i've also 'published' it to my local-website which has FP-ext. on
it but still get the same error.
Pls, anymore idea's will be greatly appreciated.

Arthur

 

[alex]

I ran into similar problem today. The custom query does not work when I use
INSERT statement with prameters. If parameters are replaced with the static
values, everything's OK. When even one parameter is added the wizard gives
you message "Custom query contains errors" and does not let you continue. It
also displays a link to http://support.microsoft.com/kb/907307 , which
suggests you to upgrade to SP2... But I believe this is when my problems
started - after upgrading to SP2. Any suggestions?

Alex