Thank you, I find an better example:

http://www.kryogenix.org/code/browser/sorttable

gangeles

Hello Dear,
I am having problem on generating report from my Web Application,
I am using ASP/SQL 2000/Crystal Report 9.1
When I start generate report from my asp page it throw an error like
Error Occurred creating Report Object: Object required, Err.No: 424
What is the problem how to solve this situation...?

N.Rajakumar B.E.,
Application Developer,

-- modified at 5:25 Friday 13th January, 2006

The background:
We have an internal order management system which is running as a web application. In the next generation of our system, I want to incorporate a WorkFlowManager subsystem. As I see it functioning -- I want this to function as an observer for state changes in specific data items. It then moves an item into the next workflow state and notify the person/group responsible for that stage of the flow.

What I need to accomplish is this:

I thought of running a component in the background on peoples workstations that would sit as a listener waiting for a message from the workflow manager. It would then show a box that a work item exists in the workflow queue for them to review and they have to respond to the request.

The issue:

I need to have a way to know that a user in a particular roll is touching the web .. it may be specifically the workflow web. I then need to check and see if my communicator is on their machine, and if not push it to them. And this is where my ASP.NET skills fall short. Any suggestions on doing this check-and-push approach ???

Thanks,
Michael

Please don't cross post.

---
b { font-weight: normal; }

I'm looking to setup a forum. I'd like to hear any recommendations people have for software! I'm a good C++ developer, but my web development is very limited (I can edit HTML and modify existing code, but I've never written new code for the web), so I'm looking for something REALLY easy to setup.

So far the best I've seen are:

1)Web Wiz
http://www.webwizguide.info/asp/default.asp[^]

2)Instant ASP
http://kb.instantasp.co.uk/article.aspx[^]

I'd like a "hosted" version if possible, or for "non-hosted" I'd like to use godaddy.com if possible, as I already have a website there.

As long as it's < $1000 cost isn't a big issue.

Any comments would be greatly appreciated! Smile | :)

Thanks

Warren

So you want Forum software???

Why not use phpBB or vBulletin? (Free and commercial)

It's frustrating being a genius and living the life of a moron!!!

You might try looking at Telligent's community server package. there are various licences available including free to non profits Big Grin | :-D

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 & ""
HTML = HTML & "Bla Bla "
HTML = HTML & "Weekly Bulletin"
HTML = HTML & "Click..."
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 Sniff | :^)

.

do you want to restrict the users(unauthenticated) from accessing the Internet????

Web Development

Guestbook