alex
Mon Nov 21 15:49:02 CST 2005
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
"News" wrote:
> 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
>
>
> "Stefan B Rusynko" <sbr_enjoy@hotmail.com> wrote in message
> news:ehDbo2trFHA.904@tk2msftngp13.phx.gbl...
> > 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
> >
> >
> > --
> >
> > _____________________________________________
> > 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.net-sites.com/sitebuilder/newsgroups.asp
> > _____________________________________________
> >
> >
> > "News" <WantNews@hoymail.com> wrote in message
> > news:df6j2d$8f0$1@news5.zwoll1.ov.home.nl...
> > | 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
> > |
> > |
> >
> >
>
>
>