Stefan
Sat Sep 03 05:50:06 CDT 2005
Copy the fpdbrgn1.inc file generated from FP 2000 into the site using FP 2003
(replacing the file fpdbrgn1.inc generated by FP 2003)
--
_____________________________________________
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
_____________________________________________
"Arthur" <Arthur@discussions.microsoft.com> wrote in message news:191C36BB-9FBF-405B-8DEC-17D5602BF849@microsoft.com...
| Hi Kevin,
| Since i'm determined to figure this out, i have installed Frontpage2000
| on another machine and used the same statement and parameters etc.etc.
| simply like this: INSERT INTO customer (name) Values ('::name::')
| Now, this works perfectly in FP2000 but will NOT work in FP2003.
| I have also compared the fpdbrgn1.inc files from both FP2000 and FP2003
| and there are or is a difference somewhere around line 304
| Is this a bug or not, I would like to post you the FP generated code but you
| have to be more specific from which files since i don't know which code you
| mean.
| Thanks again for replying,
| Arthur
|
|
| "Kevin Spencer" wrote:
|
| > Can you post the FrontPage-generated code?
| >
| > --
| > HTH,
| >
| > Kevin Spencer
| > Microsoft MVP
| > ..Net Developer
| > Neither a follower nor a lender be.
| >
| > "News" <tuurtje2000@hotmail.com> wrote in message
| > news:df9bh1$14c$1@news1.zwoll1.ov.home.nl...
| > > Hi Kevin,
| > > No i created two seperate pages, one is called "insert.htm" which contains
| > > the form
| > > and form properties are set to "send-to-other" and the action is "add.asp"
| > > which
| > > i use the INSERT INTO statement on.I have also doublechecked the
| > > spelling,upper/lowercase things like that. I also recreated the
| > > 'insert' and 'add' page many times from scratch.None will work.
| > > Could it be that there is a 'bug' in FP2003 that causes this error, I've
| > > seen
| > > on the Microsoft website that there is/was a similar problem with the
| > > ORDER BY
| > > parameter if used in a custom-query string. They made a 'hot-fix' for that
| > > but that
| > > would only work for that specific parameter.
| > >
| > > Thanks for replying and i very much hope, you or anyone else
| > > can help me out further with this.
| > >
| > > Gr. Arthur
| > >
| > > "Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com> wrote in message
| > > news:uOhd0g6rFHA.460@TK2MSFTNGP15.phx.gbl...
| > >> Have you checked the spelling? The name of the form field must exactly
| > >> match the value you type in in the Custom Query.
| > >>
| > >> Also, you are submitting a form with this form field to execute the
| > >> query, right? It won't work if the form field is simply on the same page.
| > >>
| > >> --
| > >> HTH,
| > >>
| > >> Kevin Spencer
| > >> Microsoft MVP
| > >> .Net Developer
| > >> Neither a follower nor a lender be.
| > >>
| > >> "News" <tuurtje2000@hotmail.com> wrote in message
| > >> news:df81uv$gs5$1@news4.zwoll1.ov.home.nl...
| > >>> Hi,
| > >>> When i use the "INSERT" into statement in DBRW in
| > >>> a custom query-string and type in the proper
| > >>> values ('::naam::') the result would that i get an
| > >>> error specified as "Unable to find operator in query string.
| > >>> Query string currently is Insert into invoer (naam) Values('::naam::')"
| > >>> So it doesn't insert anything into my table, (=problem no1, the major
| > >>> problem)
| > >>> Now when i change the Values to ('naam') without the :: then it
| > >>> does insert "naam" into my table but not the value that came from
| > >>> the insert -form field. It inserts the word "naam". So the Insert
| > >>> statement seems to work it only inserts the wrong value.
| > >>> It actually inserts the values name. So it appears to start working
| > >>> a bit ( i get no error messages like above) but now the right values.
| > >>> Is there a way i can solve these (2) problems, i've been
| > >>> looking at Microsoft MSDN, KB, FPsupport, but without
| > >>> any positive result, Pls do help if you can.
| > >>>
| > >>> Thanks in advance,
| > >>> Arthur
| > >>>
| > >>>
| > >>>
| > >>>
| > >>>
| > >>>
| > >>
| > >>
| > >
| > >
| >
| >
| >