Stored queries

Hi

How do i parse variables into my stored insert query.

Thanks for your help

Just like you'd pass variables to other stored queries.

Help

I tried the examples in the tutorial and got the following message

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/asp/StoredProc.asp, line 32

Why am I getting this message?

Thanks

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Database Error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

This is a very common error message when updating Access databases. Since Access is file based any attempt to update the database by an ASP script can only modify the Access databases if permissions are established correctly. Operation must use an updateable query. This error occurs on a page when an event is updating or inserting into a recordset. The permissions on the database itself does not have full read/write privileges in effect.

This error can also occur when the database is located outside of the inetpub/wwwroot directory. Though the information is still able to be viewed and searched, it cannot be updated unless it is in the wwwroot directory.

Go to the parent directory where the database is stored. Click on the folder permissions. The permissions MUST be set on the directory the database is in. IUSER_xxxxx privileges must be set to "read/write".

http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP shows some other causes besides permissions.

Additional information

For additional information on this error, please refer to following article in Microsoft's Knowledge Base:
Q174640 - PRB: ASP: "The query is Not Updateable..." Error when Updating

Hello my name is billl gay (get it bill gates) ha ha ha ha!!!!!!!!! Neway is there anyone else out there that wants to get with me for some gay sex and computer porn hacking.


Please reply,

Gay

xxxxxxxxxxxxxxxxxxxxxxxx