Types Of Users On My Forums
Assume I have three types of users.
Type I can only Read Posts.
Type II can Read and Edit. And
Type III can Read, Edit and Delete Posts.
Now to manage this, do I need to make three different users in my DB or should I just use ASP to determine that what permissions should every user have. For example, Type I users will not have the edit and delete button on thier screens and Type II users won't have delete button on their screens and Type three would have all three buttons.
Even if I make different users in my DB (assuming it's necessary for security), so how would I determine that what connection string should I connect a specific user with since we have to give the user name and password on the ADODB connection string?
View Replies
ADVERTISEMENT
I am building a stored procedure to populate a textarea. Where I can find good forums to get assistance in building stored procedures?
View Replies
View Related
I've made some forums, and I thought it might be useful if I put it on the forums for anyone to use. It's attatched, and I've even included a sample database for it. You can customise it as much as you want. I've even added a CSS file which you can modify.
This is the forum design I use on http://robmusic.somee.com/, and it works rather well. The only thing I haven't done is, when you delete a post, it doesn't reduce the amount of replies or threads in that forum.
View Replies
View Related
I want to compare the availability and functionality between the free PHP/ASP offerings. Code:
View Replies
View Related
like we can put php based forums in our web , so is there any asp forums available for ur web.
View Replies
View Related
I want to be able to log in a database any transactions my users perform. For example logging in, requesting a page, downloading a resource, logging out etc.
What is the most practical way to code this? I was thinking of trying to use an include file which would have a function to add a log in the database for each page on the site or when a particular action is performed.
View Replies
View Related
I have been looking for mailing list scripts, but discover that they all seem to be for "newsletter" type lists rather than debating lists. Are there any that can be used to allow all subscribers to post?
View Replies
View Related
Can I get the list or names of forums which is as good as PHPBB or Invision in ASP....
And also Can I have the names of good CRM and Intranet in ASP as well. Basically I need CRM for my client who want to manage theirs Link Building Management Process.
View Replies
View Related
I'm working on the ASP forum and have a little problem. I don't know how to check if topics and forums are read or unread. I have an idea. In table topics i add column with name IDS that stores ID numbers of users that read the topic. So when somebody writes a post in the topic, the IDS empties.
When you open the topic your ID is stored in IDS. There is no problem with topics but i don't know how to do that with forums, because there could be more unread topics in one forum. how you guys do this. So how do you check if there are some unread topics in forum and if the topic is unread. With cookies? sessions?
View Replies
View Related
I found webwiz forums as best ASP 3.0 open source forums out there. It Might be better if I would have posted this msg in webwiz support forums but I GET ANSWERS FROM SITEPOINT.
What I want is to host multiple forum sites on one single SQL database and one code folder. I know it may require hard code and database changes but I'm not sure where and how. It is highlighted here that each website will be having its separate
- Users
- Categories
- Forums
- Admin Setting
- And Different Adminitrators
I searched on other sites but no one is sure of his/her own opinion (May be/try this/can be).
View Replies
View Related
I need to upgrade my forums, but don’t have any time. I’m looking to purchase some third party plug-ins to handle some of the new functionality.
I need code to handle the:
Private messaging system
Transferring of threads from one forum to another
Banning users temporarily and permanently
Editing users posts and titles
View Replies
View Related
I came across the following question at a website but unfortunately the answer wasn't accompanying it:
What are the special sub-types in VBScript?
What's the answer to the above question?
View Replies
View Related
I am writing a basic tournament submit site for a poker tournamen
group I am in. The situation is we want to use code to calculate wha
we owe other members at the end of the week. The way I figured to d
this is read from the database and store tournament numbers in an arra
then run a query for each tournament and cycle through the tournamen
data assigning the information where needed. I can not find if you ca
or how you can use a Typedef in ASP. Pretty much I want to create
type then make an array of that type. ie: Code:
View Replies
View Related
the cursor types and lock types while opening the recordset.
View Replies
View Related
I'm running PWS on a Windows ME machine to do some WAP development. I need to set up some mime types so that PWS can deal with .wml .wbmp and .wmls WAP files.
I'm told this can be done by either via the Folder Options -> File Types from a Windows Explorer or by editing the registry. I've tried both of these but to no avail.
View Replies
View Related
does the data type varchar allow numbers and characters, or just one, also if this does not allow both numbers and characters what data type can i use to do this.
View Replies
View Related
I pass a table name into my program dynamically. I could display the data by looping through the object.Fields for both the field name and the field data using object.GetRows.
What I have not figured out is if there is a way to figure out from the Fields what type of field (ie. Numeric, Text) it is.
Certainly I could check the actual data once it is read, but is there a way to figure out the field type without doing that? Perhaps an object property of a recordset that I am not familiar with?
View Replies
View Related
Why am I only able to create 60 currency type fields in Access 2002 (Build 10.4302.6735) SP3?
If I try to create more than 60 Currency type fields, I will get an error that says, "Too Many Fields Defined. Errors were encountered during the save operation. Data types were not changed."
What if I need more currency type fields - like about 32 more? Do I need to create two separate related tables?
View Replies
View Related
i have a problem with the data types im using right now... because i set my data type to text ang number of characters allowd is 50, what happens is everytime i entered a data that is less than 50 characters and if i displayed it the remianing blank spaces that hasnt been cosumed is displayed.
anyone here got an idea how i can control this? is this a data type problem? i cant set my data type lesser.
View Replies
View Related
I'm currently using a document upload script and saving the filename to a database field as such: Code:
RS("Title") = Form("SourceFile").FileName
What I'm trying to do is evaluate that files type (ie. doc, xls, txt...) and fill in another database field with just the document type or a variable representing it. Is there a way to just strip off the last three letters of the form input and save that seperately?
View Replies
View Related
I have a selection of MP3's on my website, (non-copyrighted of course), I have an asp page that list the directory of MP3's which then provides a link to another ASP page to force download the file.
<%
Response.AddHeader "content-disposition","attachment; filename=" & Request.QueryString("fname") & ""
%>
Up until the weekend just gone, this worked fine, but now it only downloads a 0 byte file.
Obviously my code hasn't changed, so has anyone any other ideas whats gone wrong or another way the force download of a known mime type can be acheived.
View Replies
View Related
I have a form with 3 submit buttons that uses Javascript to determine which of the three buttons were pressed, appends the appropriate querystring to the end of the action value of the form before submitting it. eg
if add was clicked then the action would be; process.asp?query=add
Inside process.asp I have a switch statement that should check the value of the querystring and execute the appropriate SQL query. Here is the code:
View Replies
View Related
I am trying to use a query to filter SQL Server 2000 records by a date
value.
Here is relevant columns in my database table (tblContent):
title [nvarchar]
starting [smalldatetime]
.... and here is my query:
Query = "SELECT title FROM tblContent WHERE starting = '" & date & "'"
I've done exactly this query on numberous occassions in the past with no
problems at all but this time I get the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of char data
type to smalldatetime data type resulted in an out-of-range smalldatetime
value.
What on earth is going on? I'm not using a char data type anywhere! I am
doing all the initial development locally and I have just installed XP
Service Pack 2. I realise it's unlikely, but that's the only thing I can
possibly attribute it to. Or am I just missing something obvious?
View Replies
View Related
1) I have the following html code on the server:
<HTML>
....
.....
<BODY>
<A HREF = http://MyServer/MyDoc.doc> Click here to see the document</A>
When I click on the link How Internet Explorer understand that it's a Word
Document and It's necessary open it with Microsoft Word ? Is The extension
to give the necessary information to Internet Explorer ?
Where does IE look for the application to use to open the file on the server
? On the local registry ?
I have tried to rename Mydoc.doc in MyDoc.pdf and I have called
http://MyServer/MyDoc.pdf and the browser has opened Acrobat Reader but the
binary format is for Microsoft Word.
Does the Browser User an Http_Header sended automatically ? (for example
HTTP_FILE_NAME....IF IT EXISTS)
2)Now I have the following link:
http://MyServer/ReturnMyDoc.asp
It returns the binary data of MyDoc.doc file. Now I want to say to the
browser that the file is called MyDoc.doc (I don't want to use Content Type
= ms-application/msword) : is there a header to say this to Internet
Explorer ?
View Replies
View Related
I'm getting an error on my ASP page:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'StoreFileIntoField'
I assume - 99.5% - the error is generated because of worng value types,
I attemp to pass from my ASP/VBScript page to the VB/DLL function.
My relevant ASP/VBScript Code:
View Replies
View Related
I'm getting an error on my ASP page:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'StoreFileIntoField'
I assume - 99.5% - the error is generated because of worng value types,
I attemp to pass from my ASP/VBScript page to the VB/DLL function.
My relevant ASP/VBScript Code is:
View Replies
View Related
I have the following stored procedure:
CREATE PROCEDURE [dbo].[GET_CategoryCurrentNewsList]
@Category VARCHAR
AS
BEGIN
SELECT dbo.News_Joined.NewsTitle, dbo.News_Joined.NewsID
FROM dbo.News_Joined
WHERE (dbo.News_Joined.StartDate <= GETDATE()) AND (dbo.News_Joined.EndDate >= GETDATE()) AND (dbo.News_Joined.CategoryID IN (@Category))
END
GO
dbo.news_Joined.CategoryID is an INT, and @Category is a string such as (1000, 1010, 1020). However, no results are returned. I figured I had to do something to do some string conversions from INT to VARCHAR or something, but I can't use CSTR. I do not know how many numbers will be passed to @Category, so making seperate variables isn't an option.
Any ideas???
View Replies
View Related
My asp/sql server application gets an error, but only when you use the
Excel export option:
<% Response.ContentType="application/vnd.ms-excel" %> (very popular w/
users)
I think somebody entered a string of characters that Excel does not
like:
So I believe (but not sure) some character(s) in a Ntext sql server
field "desc_text" is confusing the Excel file and causing it to error
(and crashes Excel)
So far, I have attempted three fixes with no success
1) Tried to convert the data type in the SQL query:
CAST(sr.desc_text AS VARCHAR(255))
2) Tried to convert the data type in the vbscript:
<% desc_text1 = Cstr(rs.fields.item("desc_text").value)%>
3) Tried append an apostrophe to the beginning of the field so that
Excel would not read it as a formula. (this might have worked, but
Excel does not treat an apostrophe the same from an export as it does
if you typed it in directly)
<%response.write "'"%> <% response.write desc_text1%>
Soliciting all ideas!
Also, if you have any ideas on how to isolate and identify the
specific record and character(s) that is causing the error, that would
be great. I have it narrowed down to a record set of 600 records, and
the error occurs if I include beyond the 130th character position. The
problem does not occur if I use CAST(sr.desc_text AS VARCHAR(129))
View Replies
View Related
How to display this str in a proper format accordingly to the MIME type specified in side the str? Code:
View Replies
View Related
I would like to use this code on my website to allow simple file uploads from clients. I would like to restrict the file types they can upload. Code:
View Replies
View Related
I have 3 tables
members, pubs, favepubs
favepubs contains
favepubID, UserID (from members), PubID (from Pubs)
I'd like to join all 3 and maybe count the users?!
basically i want to show in my list of pubs how many users like that pub
Example:
The Red Lion (4 members - click for more details)
The Royal Oak (2 members - Click for more details)
or
The Red Lion (Jarv, Test, Admin, Shelly)
View Replies
View Related
I'm hosting a couple of ASP applications on my server. How can I tell the number of users currently logged on, and can I get any details about them ?
View Replies
View Related
How do we have a track of users who have logged in? I want to have a table of record with usernames and the status(logged in or logged out).
Whenever the user logs in, the status shud indicate he is logged in and when he logs out the status shud change accordingly. Does anybody know how to do this???
View Replies
View Related