can't get more stupid then this..

[News]

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

 

[p c]

Dump FP for managing dataases and write your own code in ASP. What is
needed
* Learn some basic ASP
* Learn how to connect to datbases
* Learn some basci SQL syntax

There ar plenty of tutorils on the net. Also, invest in a good how to
book. And you can find plenty of datnases mament scipts on the web you
can use with monor modifications. Google is your friend.
...PC

 

[Kevin Spencer]

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]

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]

Can you post the FrontPage-generated code?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

 

[Arthur]

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

 

[Stefan B Rusynko]

Copy the fpdbrgn1.inc file generated from FP 2000 into the site using FP 2003
(replacing the file fpdbrgn1.inc generated by FP 2003)




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

 

[News]

Thank, But i tried that and will not work.
I've replaced fpdbrgn1.inc file first to see what happend.
After negative result, i replaced the whole _fpclass folder.
(sadly with the same result)

I'm getting more and more convinced that this is a bug in FP2003
which, in my opinion should be fixed by MS.
Does anybody know a way to report this to them.

Thanks again for helping.
Arthur

 

[alex]

I'M sure it's a bug!. Below is my post to another thread here in the same
group:

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