Custom Query (Insert)

[superdl1]

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.

 

[David Berry]

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.

 

[superdl1]

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]

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/downloads/maincatalog.aspx (make sure you
have your CD handy)

 

[superdl1]

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

 

[David Berry]

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

 

[superdl1]

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