Insert problem

CW · September 8th, 2003, 04:53 AM

Thanks Jacob.

************************************************** **
POST Data:
StudentNameFirst=fyf&studentNameLast=lhlhlhlk
*******************************************
First of all iam not retreiving , but i am insertig into the database.

**********************************************
Well, as far as I can see you still got two input controls 'StudentNameFirst' and 'studentNameLast' (last name not capitalized), and you are requesting something like 'txtFirstName' and 'txtLastName', which does not correspond.
************************************************** ******

Ok, I can change, but the problem is now:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

This link http://www.aspfaq.com/show.asp?id=2062 did not help me alot. I just want to know how to do it.

"The most common reason is that the Internet Guest account (IUSR_MACHINE), which is by default part of the "Everyone" group, does not have Write permissions on the database file (.mdb). To fix this problem, use the Security tab in Explorer to adjust the properties for this file so that the Internet Guest account has the correct permissions". this is the microsoft support.

I am using winxp, iis5.0 (ADO 2.5, i think).
How can i solve this permission first.

Thanks in advance

rgds
CW

Imar · September 8th, 2003, 05:38 AM

Did you follow the link that was suggested in the FAQ item?

I think http://support.microsoft.com/?kbid=175168 describes what to do:

1. Open a Windows Explorer
2. Browse to your database folder
3. Right-click it, choose Properties and then switch to the Security tab.
4. Add the user IUSR_MachineName and give it rights to read and modify the folder. Don't forget to replace MachineName with the name of your machine.

Now the IUSR account will be able to write and read from your database.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

jacob · September 8th, 2003, 12:19 PM

hehe! :D

I know you were inserting, but you are retrieving from the form; that was why I said that you are retrieving this...

POST Data:
StudentNameFirst=fyf&studentNameLast=lhlhlhlk

... which you can do with...

Request.Form("StudentNameFirst") and Request.Form("studentNameLast")

Jacob.

CW · September 9th, 2003, 04:44 AM

:D

OK.

I have tried your suggestions, and NOW every thing is working perfectly

Thanks a lot guys.

One little questions about retrieving names.
How can they be displayed as hyperlinks, so that user can only click on what he/she wants to view. After that User can read the selected item in detail.

Thanks in advance

rgds CW

Imar · September 9th, 2003, 04:52 AM

You mean like some sort of Master - Detail pages where the Master page shows a list of records (a short version) and the Detail page shows all the details?

Try something like this:

[Master.asp]

Code:

<%
  Do While Not MyRecordset.EOF
    Response.Write("<a href=""Detail.asp?ID=" & MyRecordset("ID") & _
        """>" & MyRecordset("Description") & "</a><br />")
    MyRecordset.MoveNext()
  Loop
%>

This will write out a list of <a> tags linking to the Detail page. The Description from the recordset will be linked.

On the detail page, you can request the ID, and do with it whatever you want....

[Detail.asp]

Code:

<%
  Dim ID
  ID = Request.QueryStrong("ID")
  If Len(ID) > 0 Then
    ' Use ID to retrieve the details for the requested record
    ' and display it on the page
  End If 
%>

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.