In FrontPage 2002 you were about to insert a row of new data into a table
using the following syntax via a custom query:

Insert into table_name(Column1, Column2) values ('::field1::','::field2::')

Now in FrontPage 2003 this does not work. What coding do I need to use to
instert data from a form into my table. I cannot find anything on this.

Why wouldn't that work? It's just a simple SQL Statement. Are you using a
different database? What error message do you get? Is the problem just
that the records aren't getting inserted? If so it could just be a
permissions issue. The folder that the database is in needs read-write
permissions.

--
David Berry
Microsoft MVP - FrontPage
FrontPage Support: http://www.frontpagemvps.com/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
-----------------------------------


"superdl1" <(E-Mail Removed)> wrote in message
news:99264368-00C6-4A89-8D00-(E-Mail Removed)...
> In FrontPage 2002 you were about to insert a row of new data into a table
> using the following syntax via a custom query:
>
> Insert into table_name(Column1, Column2) values
> ('::field1::','::field2::')
>
> Now in FrontPage 2003 this does not work. What coding do I need to use to
> instert data from a form into my table. I cannot find anything on this.

According to Microsoft it no longer works when I try I get a link to the
following Knowledge base article

http://support.microsoft.com/kb/907307


"David Berry" wrote:

> Why wouldn't that work? It's just a simple SQL Statement. Are you using a
> different database? What error message do you get? Is the problem just
> that the records aren't getting inserted? If so it could just be a
> permissions issue. The folder that the database is in needs read-write
> permissions.
>
> --
> David Berry
> Microsoft MVP - FrontPage
> FrontPage Support: http://www.frontpagemvps.com/
> -----------------------------------
> To assist you in getting the best answers for FrontPage support see:
> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> -----------------------------------
>
>
> "superdl1" <(E-Mail Removed)> wrote in message
> news:99264368-00C6-4A89-8D00-(E-Mail Removed)...
> > In FrontPage 2002 you were about to insert a row of new data into a table
> > using the following syntax via a custom query:
> >
> > Insert into table_name(Column1, Column2) values
> > ('::field1::','::field2::')
> >
> > Now in FrontPage 2003 this does not work. What coding do I need to use to
> > instert data from a form into my table. I cannot find anything on this.
>
>

Did you follow what it said in the KB article? It says:

"To resolve this problem, obtain the latest service pack for Microsoft
Office 2003. After you install Microsoft Office 2003 SP2, you have to reopen
and save each ASP page that was created by using the Database Results
Wizard. When you save the ASP page, the .inc files will be rewritten."

You can get the latest SP from the Office Update Site
http://office.microsoft.com/en-us/do...incatalog.aspx (make sure you
have your CD handy)

--
David Berry
Microsoft MVP - FrontPage
FrontPage Support: http://www.frontpagemvps.com/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
-----------------------------------


"superdl1" <(E-Mail Removed)> wrote in message
news:C64E5ED9-5D94-4C59-896E-(E-Mail Removed)...
> According to Microsoft it no longer works when I try I get a link to the
> following Knowledge base article
>
> http://support.microsoft.com/kb/907307
>
>
> "David Berry" wrote:
>
>> Why wouldn't that work? It's just a simple SQL Statement. Are you using
>> a
>> different database? What error message do you get? Is the problem just
>> that the records aren't getting inserted? If so it could just be a
>> permissions issue. The folder that the database is in needs read-write
>> permissions.
>>
>> --
>> David Berry
>> Microsoft MVP - FrontPage
>> FrontPage Support: http://www.frontpagemvps.com/
>> -----------------------------------
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
>> -----------------------------------
>>
>>
>> "superdl1" <(E-Mail Removed)> wrote in message
>> news:99264368-00C6-4A89-8D00-(E-Mail Removed)...
>> > In FrontPage 2002 you were about to insert a row of new data into a
>> > table
>> > using the following syntax via a custom query:
>> >
>> > Insert into table_name(Column1, Column2) values
>> > ('::field1::','::field2::')
>> >
>> > Now in FrontPage 2003 this does not work. What coding do I need to use
>> > to
>> > instert data from a form into my table. I cannot find anything on
>> > this.
>>
>>

I completely remade it from nothing and the SQL statement still does not work.

"David Berry" wrote:

> Did you follow what it said in the KB article? It says:
>
> "To resolve this problem, obtain the latest service pack for Microsoft
> Office 2003. After you install Microsoft Office 2003 SP2, you have to reopen
> and save each ASP page that was created by using the Database Results
> Wizard. When you save the ASP page, the .inc files will be rewritten."
>
> You can get the latest SP from the Office Update Site
> http://office.microsoft.com/en-us/do...incatalog.aspx (make sure you
> have your CD handy)
>
> --
> David Berry
> Microsoft MVP - FrontPage
> FrontPage Support: http://www.frontpagemvps.com/
> -----------------------------------
> To assist you in getting the best answers for FrontPage support see:
> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> -----------------------------------
>
>
> "superdl1" <(E-Mail Removed)> wrote in message
> news:C64E5ED9-5D94-4C59-896E-(E-Mail Removed)...
> > According to Microsoft it no longer works when I try I get a link to the
> > following Knowledge base article
> >
> > http://support.microsoft.com/kb/907307
> >
> >
> > "David Berry" wrote:
> >
> >> Why wouldn't that work? It's just a simple SQL Statement. Are you using
> >> a
> >> different database? What error message do you get? Is the problem just
> >> that the records aren't getting inserted? If so it could just be a
> >> permissions issue. The folder that the database is in needs read-write
> >> permissions.
> >>
> >> --
> >> David Berry
> >> Microsoft MVP - FrontPage
> >> FrontPage Support: http://www.frontpagemvps.com/
> >> -----------------------------------
> >> To assist you in getting the best answers for FrontPage support see:
> >> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> >> -----------------------------------
> >>
> >>
> >> "superdl1" <(E-Mail Removed)> wrote in message
> >> news:99264368-00C6-4A89-8D00-(E-Mail Removed)...
> >> > In FrontPage 2002 you were about to insert a row of new data into a
> >> > table
> >> > using the following syntax via a custom query:
> >> >
> >> > Insert into table_name(Column1, Column2) values
> >> > ('::field1::','::field2::')
> >> >
> >> > Now in FrontPage 2003 this does not work. What coding do I need to use
> >> > to
> >> > instert data from a form into my table. I cannot find anything on
> >> > this.
> >>
> >>
>
>
>

When you say it doesn't work, are you getting an error message? If so, what
is it?

--
David Berry
Microsoft MVP - FrontPage
FrontPage Support: http://www.frontpagemvps.com/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
-----------------------------------


"superdl1" <(E-Mail Removed)> wrote in message
news:2DE9FDD4-F2BD-43EF-BFF1-(E-Mail Removed)...
>I completely remade it from nothing and the SQL statement still does not
>work.
>
> "David Berry" wrote:
>
>> Did you follow what it said in the KB article? It says:
>>
>> "To resolve this problem, obtain the latest service pack for Microsoft
>> Office 2003. After you install Microsoft Office 2003 SP2, you have to
>> reopen
>> and save each ASP page that was created by using the Database Results
>> Wizard. When you save the ASP page, the .inc files will be rewritten."
>>
>> You can get the latest SP from the Office Update Site
>> http://office.microsoft.com/en-us/do...incatalog.aspx (make sure
>> you
>> have your CD handy)
>>
>> --
>> David Berry
>> Microsoft MVP - FrontPage
>> FrontPage Support: http://www.frontpagemvps.com/
>> -----------------------------------
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
>> -----------------------------------
>>
>>
>> "superdl1" <(E-Mail Removed)> wrote in message
>> news:C64E5ED9-5D94-4C59-896E-(E-Mail Removed)...
>> > According to Microsoft it no longer works when I try I get a link to
>> > the
>> > following Knowledge base article
>> >
>> > http://support.microsoft.com/kb/907307
>> >
>> >
>> > "David Berry" wrote:
>> >
>> >> Why wouldn't that work? It's just a simple SQL Statement. Are you
>> >> using
>> >> a
>> >> different database? What error message do you get? Is the problem
>> >> just
>> >> that the records aren't getting inserted? If so it could just be a
>> >> permissions issue. The folder that the database is in needs
>> >> read-write
>> >> permissions.
>> >>
>> >> --
>> >> David Berry
>> >> Microsoft MVP - FrontPage
>> >> FrontPage Support: http://www.frontpagemvps.com/
>> >> -----------------------------------
>> >> To assist you in getting the best answers for FrontPage support see:
>> >> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
>> >> -----------------------------------
>> >>
>> >>
>> >> "superdl1" <(E-Mail Removed)> wrote in message
>> >> news:99264368-00C6-4A89-8D00-(E-Mail Removed)...
>> >> > In FrontPage 2002 you were about to insert a row of new data into a
>> >> > table
>> >> > using the following syntax via a custom query:
>> >> >
>> >> > Insert into table_name(Column1, Column2) values
>> >> > ('::field1::','::field2::')
>> >> >
>> >> > Now in FrontPage 2003 this does not work. What coding do I need to
>> >> > use
>> >> > to
>> >> > instert data from a form into my table. I cannot find anything on
>> >> > this.
>> >>
>> >>
>>
>>
>>

"Database Results Wizard Error The operation failed. If this continues,
please contact your server administrator."

When I try to write an Update Query to the database it updates records
without any problems, so I know it is not a permission issue. But the Insert
Query statement does not work just like the KB article says. I would think
there is a way around this but so far I cannot find anything.

"David Berry" wrote:

> When you say it doesn't work, are you getting an error message? If so, what
> is it?
>
> --
> David Berry
> Microsoft MVP - FrontPage
> FrontPage Support: http://www.frontpagemvps.com/
> -----------------------------------
> To assist you in getting the best answers for FrontPage support see:
> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> -----------------------------------
>
>
> "superdl1" <(E-Mail Removed)> wrote in message
> news:2DE9FDD4-F2BD-43EF-BFF1-(E-Mail Removed)...
> >I completely remade it from nothing and the SQL statement still does not
> >work.
> >
> > "David Berry" wrote:
> >
> >> Did you follow what it said in the KB article? It says:
> >>
> >> "To resolve this problem, obtain the latest service pack for Microsoft
> >> Office 2003. After you install Microsoft Office 2003 SP2, you have to
> >> reopen
> >> and save each ASP page that was created by using the Database Results
> >> Wizard. When you save the ASP page, the .inc files will be rewritten."
> >>
> >> You can get the latest SP from the Office Update Site
> >> http://office.microsoft.com/en-us/do...incatalog.aspx (make sure
> >> you
> >> have your CD handy)
> >>
> >> --
> >> David Berry
> >> Microsoft MVP - FrontPage
> >> FrontPage Support: http://www.frontpagemvps.com/
> >> -----------------------------------
> >> To assist you in getting the best answers for FrontPage support see:
> >> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> >> -----------------------------------
> >>
> >>
> >> "superdl1" <(E-Mail Removed)> wrote in message
> >> news:C64E5ED9-5D94-4C59-896E-(E-Mail Removed)...
> >> > According to Microsoft it no longer works when I try I get a link to
> >> > the
> >> > following Knowledge base article
> >> >
> >> > http://support.microsoft.com/kb/907307
> >> >
> >> >
> >> > "David Berry" wrote:
> >> >
> >> >> Why wouldn't that work? It's just a simple SQL Statement. Are you
> >> >> using
> >> >> a
> >> >> different database? What error message do you get? Is the problem
> >> >> just
> >> >> that the records aren't getting inserted? If so it could just be a
> >> >> permissions issue. The folder that the database is in needs
> >> >> read-write
> >> >> permissions.
> >> >>
> >> >> --
> >> >> David Berry
> >> >> Microsoft MVP - FrontPage
> >> >> FrontPage Support: http://www.frontpagemvps.com/
> >> >> -----------------------------------
> >> >> To assist you in getting the best answers for FrontPage support see:
> >> >> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> >> >> -----------------------------------
> >> >>
> >> >>
> >> >> "superdl1" <(E-Mail Removed)> wrote in message
> >> >> news:99264368-00C6-4A89-8D00-(E-Mail Removed)...
> >> >> > In FrontPage 2002 you were about to insert a row of new data into a
> >> >> > table
> >> >> > using the following syntax via a custom query:
> >> >> >
> >> >> > Insert into table_name(Column1, Column2) values
> >> >> > ('::field1::','::field2::')
> >> >> >
> >> >> > Now in FrontPage 2003 this does not work. What coding do I need to
> >> >> > use
> >> >> > to
> >> >> > instert data from a form into my table. I cannot find anything on
> >> >> > this.
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>