Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Anymouse form submission - with out letting user see data

  Asked By: Christopher    Date: Aug 01    Category: Sharepoint    Views: 1625

I am a newbie when it comes to sharepoint and asp.net. So can you
help me.

I am making a website using a sharepoint backend for some users to
administer and I there is a form that is anonymous. I would like to the
form to insert into a list.

So i can use the frontpage listforms because the anon. user does not
have view/write/edit permissions on the list. And i can not use form
web part because (a. I do not what to push the data to, b. I do not
have anything to have the form push the data to).

So i found the stored procedure that share point uses to put the info
into the list / table, proc_AddListItem. BUT i can not call a sql
command in a aspx page using fp. So am i missing something very simple
here or and I SOL.

Please help this is something I thought could be done easlly



5 Answers Found

Answer #1    Answered By: Jabari Burks     Answered On: Aug 01

Don't ever do anything directly against the database tables or stored  procedures
- you're just asking for trouble :)

Sounds like your best approach would be to create an new .aspx form  which uses
the Object Model (see the WSS SDK) to put  in the form values. You'll then need
to deploy the .aspx into the _layouts directory on the server.

Answer #2    Answered By: Heena Desai     Answered On: Aug 01

All I have to say about that is that sucks.

I can't believe I need to be an admin to do such a thing. I mean for
goodness sake this is a enterprise solution. I am thinking about
deploying sharepoint  to students at our college as collaborative tool.
So how would they be able to do such a thing, because they do not would
not have access to these directories, for obvious reasons.

Hmmm some times Microsoft just does not think things through as much as
they should. They really take themselves out the admin role once in a

Don't get me wrong SharePoint kicks ass and so does the new FrontPage,
kick ass.

Thanks and sorry for the rant I was just hoping for that simple thing I
had missed in my endless readings.

Answer #3    Answered By: Manuel Crawford     Answered On: Aug 01

You're trying to do several things that aren't part  of a OOTB scenario. If all
you are trying to do is post items to a list, there is a built-in form  for each
list and you can grant anonymous  access to the list  to allow user  to use it, and
to only see their own submissions. The permissions  structure you outline
(write-only and anonymous) isn't one that was common enough to be in there OOTB,
hence the need to develop something as an admin if you really want to do that.

Answer #4    Answered By: Otis Blackwell     Answered On: Aug 01

How could anonymous user  access list  and see there only submissions?
They can't. That is logically impossible. But I digress. I have went
against the grain because of a time schedule issue and used the stored
procedure proc_AddListItem to add an item to a list based on some info.
It works. Period. Now I am working on the upload part  of the list.

Answer #5    Answered By: Virendar Chaudhari     Answered On: Aug 01

If it works, great. Just be aware that my doing this you won't get support from
Microsoft (unless you can repro the issue without your additions) and accessing
the database directly may cause deadlocks - even when using the OOTB stored
procedures do to some out-of-order exceution and caching in WSS?SPS. This is
why direct DB access is highly discouraged and unsupported...

Didn't find what you were looking for? Find more on Anymouse form submission - with out letting user see data Or get search suggestion and latest updates.