|
You might try looking at Telligent's community server package. there are various licences available including free to non profits
http://communityserver.org/
It's used by the guys at #develop and it seems to work very well.
End of Line.
|
|
|
|
|
When I try to run an update query via ASP to an Access DB, I get the error below. The insert query works fine when I run it from Access, but not ASP. I can read from the DB fine, but can't write to it.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/Tutorial/guestbook.asp, line 43
Code:
<% @Language=VBScript %>
<title>Guest Book
<%
IF request.form ("Message")="True" THEN
strTB1=request.form("To")
strTB2=request.form("EMailAdd")
strTB3=request.form("CC")
strTB4=request.form("Subject")
strMB1=request.form("Memo")
IF strMB1 = "" THEN
iLenMB1=255
ELSE
iLenMB1 = Len(strMB1)
END IF
'Connects to the Access driver and Access database in the Inetpub
'directory where the database is saved
strProvider = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Inetpub\Wwwroot\Tutorial\guestbook.mdb;"
'Creates an instance of an Active Server component
set objConn = server.createobject("ADODB.Connection")
'Opens the connection to the data store
objConn.Open strProvider
'Instantiate Command object and use ActiveConnection property to
'attach connection to Command object
set cm = Server.CreateObject("ADODB.Command")
cm.ActiveConnection = objConn
'Define SQL query
cm.CommandText ="INSERT INTO Guestbook (TB1,TB2,TB3,TB4,MB1) VALUES (?,?,?,?,?)"
'Define query parameter configuration information for guestbook fields
set objparam=cm.createparameter(, 200, , 255, strTB1)
cm.parameters.append objparam
set objparam=cm.createparameter(, 200, , 255, strTB2)
cm.parameters.append objparam
set objparam=cm.createparameter(, 200, , 255, strTB3)
cm.parameters.append objparam
set objparam=cm.createparameter(, 200, , 255, strTB4)
cm.parameters.append objparam
set objparam=cm.createparameter(, 201, , iLenMB1, strMB1)
cm.parameters.append objparam
cm.execute
response.write("Thank you!")
ELSE%>
Guestbook
To
Email Address
CC
Subject
Message
<%End if%>
Thanks!
|
|
|
|
|
Check that the account used by IIS has write access on the directory where the MDB file is.
|
|
|
|
|
Your "write access" tip led me in the right direction. Turns out "users" did not have write permission to one of the folders in the path to the database. Thanks a bunch!
|
|
|
|
|
hi all,
i ve a asp listbox control in my webpage.
i need to find the number of items in that list box using javascript?
is it possible?
it doesnt contain any option1, option2 ....
with regards
Crazy
CrazySanker
All I ever wanted is what others have
|
|
|
|
|
theListBox.options.length
---
b { font-weight: normal; }
|
|
|
|
|
I am looking for a simple template(kind of black & white) for my weblog on blogger.com. Something like a newspaper, but very simple and professional. Do you know any?
Thanks in advance
-Maysam
-- modified at 1:40 Thursday 12th January, 2006
|
|
|
|
|
Hi
Go to Yahoo!
search for Yahoo! site builder and download it
this program helps you to build and construct your website in prof. way
and you can use the template provided
Best Wishes
Regards
Mohammad Rabay'a
|
|
|
|
|
Hi ...
Im using the code from
http://www.dddekerf.dds.nl/DHTML_Treeview/DHTML_Treeview.htm
and I need to modify it to have hyperlinks to nodes with the + sign, I cant seem to get that done - any idea anyone?
Thanks!
|
|
|
|
|
hi,
I have a dataSet and I am binding the dataset to the table.The data set may have more number of rows(20) and columns(10).I want to have a scrollable grid that shows only 5 rows and 4 coulms and if the user needs to see more he has to scroll left or right.
How can make the grid scrollable to left and right.Till now what I did is that I got the data set and I bind it to the DataGrid I am seeing all the rows and columns.How to proceed further.
can any one help me in this.
Thanks,
Satish.
|
|
|
|
|
hello everyone,
i have a simple question and there probably is a very simple answer but somehow i am having trouble solving the problem. Please help.
my code is as follows:
<code><%
set myconn = server.createobject("adodb.connection")
dbpath = server.mappath("fpdb/guest2.mdb")
myconn.open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & dbpath )
%>
<%
DIM strEmail
DIM MySQL, objRS
mySQL = "SELECT * from results"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.CacheSize = 500
objRS.Open mySQL, MyConn
strEmail = objRS("mail_adres")
for i = 1 to objRS.RecordCount
Dim MyCDONTSMail2
Dim HTML
Set MyCDONTSMail2 = CreateObject("CDONTS.NewMail")
HTML = "<!DOCTYPE HTML PUBLIC""-//IETF//DTD HTML//EN"">"
HTML = HTML & "<html>"
HTML = HTML & "<head>"
HTML = HTML & "<title>Bla Bla</title>"
HTML = HTML & "</head>"
HTML = HTML & "<body bgcolor=""FFFFFF"">"
HTML = HTML & "<p><font size =""3"" face=""Arial""><strong>"
HTML = HTML & "Bla Bla</strong><br>"
HTML = HTML & "Weekly Bulletin</strong></p>"
HTML = HTML & "<p align = ""center"">Click...</p>"
HTML = HTML & "</body>"
HTML = HTML & "</html>"
MyCDONTSMail2.From= "bulletins@somewhere.com"
MyCDONTSMail2.To= strEmail
MyCDONTSMail2.Subject="Weekly Bulletin"
MyCDONTSMail2.BodyFormat=0
MyCDONTSMail2.MailFormat=0
MyCDONTSMail2.Body=HTML
MyCDONTSMail2.Send
set MyCDONTSMail2=nothing
objRS.MoveNext
next
%>
</code>
and the result is a for loop not working as desired and returning only the top most record but not a set of records. so could anyone tell me what i am doing wrong in here? i would like to make the code work so that it can send the newsletter to every e-mail address in the db.
thanks
|
|
|
|
|
When you open a recordset as forward-only, the RecordCount property can't be used to get the number of records, as there is no way of knowing the number of records until the entire recordset is read.
Just loop until objRS.EOF becomes true.
---
b { font-weight: normal; }
|
|
|
|
|
i tried that one also but still get the same result. but thanks anyway.
i'll try something else with the idea you gave me.
|
|
|
|
|
I'm trying to return string like "\u0001" from web method, but client gets
exception
System.InvalidOperationException: There is an error in XML document (1,
978). --
-> System.Xml.XmlException: '', hexadecimal value 0x01, is an invalid
character
. Line 1, position 1001.
What's wrong??
Thank you.
Den
|
|
|
|
|
The character 0001 doesn't exist in the character set you are using.
---
b { font-weight: normal; }
|
|
|
|
|
Does anyone know of a script or tool to remove comments from two types of files:
1. ASP file with embedded Javascript & HTML
2. XSL file with embedded Javascript & HTML
So basically it's removal of
// Javascript style comments
/* Javascript style comments */
' VBScript (ASP) style comments
A good script/tool would be one that strips all source code of comments. Then another script/tool that reapplies the comments. So that means storing the comments and line numbers in another file possibly.
|
|
|
|
|
Try RegEX - Regular Expressions for finding and removing.
PraVeeN
NinethSense.com/blog/
|
|
|
|
|
I'm writing a web page for a select number of users. I've used Windows authentication, and added the user ids into the allow users section of the web config.
However, I don't want to keep adding people to this everytime a new person joins the department or needs access.
I do keep a list of the users in a SQL 2000 table for other purposes, and I'd really like to be able to use this to allow any users from this table, but despite days of surfing, I'm no closer to an answer on how to do this .
|
|
|
|
|
do you want to restrict the users(unauthenticated) from accessing the Internet????
|
|
|
|
|
I want to restrict unauthenticated users accessing my site (as I need to control who has access to it). My web.config file looks like this:
<authentication mode="Windows">
<authorization>
<allow users="RETAIL\Steph">
<allow users="RETAIL\Dan">
<deny users="*">
This works OK, and if the user isn't an allowed user, then the standard login screen is displayed - the standard windows 'Connect to server' screen. (I haven't got a login screen of my own.)
Other info I should have told you before (sorry, got brain drain ), is that I'm using C# and I have anonymous access switched off in IIS, and no impersonation in the web.config.
|
|
|
|
|
does someone know about any existing open source e-learning platform coded in ASP .NET?
free of charge or paid
"Absolution requires sacrifice" -- Dan Brown 'The Da Vinci code'
|
|
|
|
|
You could utilize DotNetNuke to do something like that. I've seen people talking about various modules to support what you're looking for. In my opinion, an option like that would be best because it'd be the most flexible.
Michael Flanakin
Web Log
|
|
|
|
|
when i click a button a menu is opened.
This is opening downwards.
But i want this in upward direction.
plz help me
|
|
|
|
|
Where is the button ? Is it on a toolbar, and the framework is doing it all for you ? Or is it on a form ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
hi all,
this is my query.
I have 3tables(a,b,c).
i am connecting table a with table b using columns
pinnumber(in a table) with Usernumber(in table b).
if this query is correct then only i have to compare
third table column (menuid)with second table column(accessid)
pls help me out of this problem.
Regards
rs_net
|
|
|
|