Suggestion Assistance

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ ASP Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - ASP/CDO Mail and Exchange 2000 on AD Domain I have no idea how to get started, really, but I am looking for a way to have an email sent via an ASP page via our Exchange 2000 server. I have a fairly simple asp page that displays data from a SQL 2000 database in the form of web links. A part of this page allows people to post links to the database for display. When someone posts a link, I would like an email sent to me with the data (link) that they posted through the ASP page. This page is on our internal web server only and only our domain users can access this web server. We have a single exchange 2000 mail server. I did look at ASPFAQ 2026 on using CDO for sending e-mail but this doesn't help me much because it doesn't say anything about connecting to the exchange server or anything about proper authentication with the exchange server. Any help would be appreciated. Thanks, Jim Tag: Suggestion Assistance Tag: 309313
  - 2
    - Response.BinaryWrite for one JPEG is Very Slow I am using Response.BinaryWrite to display JPEG's to the browser. The problem is that in IE, one particular JPEG is loading very slow. Normal JPEG's take a few seconds, but this one sometimes takes up to 30 seconds. THe weird thing is that if I refresh really quick, the JPEG appears for quick second, and then the new Response.BinaryWrite kicks in. So, it looks like the browser has the image, but for some reason it is not finishing loading it into the browser. I found another article with a similar issue at http://groups-beta.google.com/group/microsoft.public.data.ado/browse_thread/thread/9d61f1f9e4800ebd/0c071cbb27813992?q=jpg+slow+response.binarywrite&rnum=1#0c071cbb27813992 This seems to be something related to the exact size of that JPEG. Any help would be greatly appreciated. Tag: Suggestion Assistance Tag: 309312
  - 3
    - ASP -> Excel Hello all.. I'm working on some reports, and have added the ability to "download" the reports to excel. Not a big deal, fairly straight forward. However, PHB wants to be able to create some pivot tables from said reports (again.. no biggie) and when he goes to save the file, Excel wants to save the file as a web page instead of and Excel spreadsheet. Now.. I know the simple thing here is to just pick Excel from the drop down box in the save as dialog.. but.. PHB would "prefer" to not have to do that. Has anyone been able to jump this hurdle before? My good friend google hasn't turned anything up. My preference is to give PHB the middle finger.. but alas.. the paycheck is keeping me from doing that. Thanks! Tag: Suggestion Assistance Tag: 309309
  - 4
    - Fronpage access from MacOS software Hi, I have a client who want to edit ASP page but from her Machintosh (MacOS 9.1) and I wonder if anyone here know about any web editing software for Macintosh that supports the Frontpage Server extension? I can't find a copy of the old Frontpage 98 for Mac anymore. Thanks in advance Christian Tag: Suggestion Assistance Tag: 309308
  - 5
    - 2 WebServices with the same name on 1 Server? Hi, I have developed a WebService (with .net) and have to install it on a Windows2003-Server for TEST and PRODUCTION (my Customer has only 1 Windows-Server). It it possible, to use the same name (of the asmx-file) for TEST and PRODUCTION (same files in 2 different folders; I have installed the PRODUCTION-WebService and want to copy it to another folder) or do i have to deploy the WebService for TEST with a different name (and a second installation)? (I have tried the first way, and now I have some Security-Problems (Access is denied), when accessing dll's in the BIN-Subfolder) thank you for your help Ulrich Haverkamp Tag: Suggestion Assistance Tag: 309306
  - 6
    - IIS6/worker processes/performance counters Hi... We're looking at moving an ASP app from IIS 5 to IIS 6. In general things seem to be working okay, but there are some oddities around the edges. One of those unanticipated changes has to do with the new process model and the option to have more than one worker process per web instance. We found that each worker process has its own Application() state and anything your app puts there/uses gets a new copy for every worker process. So depending on how much initialization your app does in Appication() that expense could get paid over and over as IIS 6 cycles worker processes based on idleness, load, memory use, etc. The facet I still have a question about is performance counters. When you have multiple worker processes for a web instance, are the usual performance counters like Active Server Pages/Requests Total, Requests Queued, etc aggregated across worker processes? How are they impacted by worker process cycling? How about custom performance counters? I assume we'd probably have to take extra effort to aggregate custom pcounters across worker processes - is that right? Are there any faqs on the new IIS 6 process model and/or implementing custom pcounters for them? Thanks _mark Tag: Suggestion Assistance Tag: 309305
  - 7
    - Site navigation question Completely new to technologies like CSS, but trying to learn fast.... I've seen a few sites with "very sophisticated" navigation tools that provide menus that both drop down and expand horizontally...very similar to the menu tools we're used to in Windows applications. Anyhow, in an attempt to mimic this, I've looked at a web few sites and studied the source files. It appears that there are two schools of thought here. The first uses unordered lists and the second uses tables to hold the information. Both then use a combination of CSS and JavaScript to control the behaviour. Which really is the method of choice? Thanks Griff PS - not using ASP.NET (yet) Tag: Suggestion Assistance Tag: 309302
  - 8
    - Developing a "google-like" search engine for intranet Hello guys, I've been building a search facility for an intranet site I'm part of developing and we've been building a search engine using Index Server. It mostly works, however there have been a few niggling problems and fixing it seems to be a case of patching errors as we find them so I'm thinking that it might be worth starting the logic from scratch and rebuilding this again. Basically we have a simple search, which is simply a text box with a submit button. I would like some boolean search functionality, ie. search term - would search for all items, search OR term - would search for documents containing either words, search AND NOT term - and so on. We also have an advanced search, with a number of fields - 'all words', 'any words', 'exact phrase' and 'not containing'. Does anyone have any information on building this kind of search, either sample code or simply just a text on how someone might have done this kind of thing. I've had a good look around and am yet to find what I'm looking for. Must have been done a million times before though! Cheers and thanks in advance. Alastair Tag: Suggestion Assistance Tag: 309301
  - 9
    - Trapping ScriptTimeout Error Hi, i want to trap the ASP ScriptTimeout Error. Its okay if i can do it in the same page or redirect to any other page via coding or via any changes in IIS. This is very important to us. Waiting for ur reply. Thanks in advance -- Deepson Thomas Tag: Suggestion Assistance Tag: 309292
  - 10
    - Send mail and auto submit a form? Hi All, I am working on a script and I have a form to a page to be submitted (POST-ed) to an external site. I need that when the user submits the form, first step is to send an email using an asp script and only after that to post the information to the web site. I can send the email but I don't know how to post the form automatically after I send the email. I think I can use javascript, but maybe there is a better way of doing it? Regards, Nicolae Tag: Suggestion Assistance Tag: 309290
  - 11
    - Sample needed for DB management Hi, Could anyone provide some example/template/links for a web-based access database management (CRUD) system? Thanks a bundle. newbie Tag: Suggestion Assistance Tag: 309288
  - 12
    - fso fails when connecting to mapped drives from asp on IIS 6.0 I've seen posts similar to this, but have not found the magic bullet to solve my problem.. I have an asp page (see source code below) running on IIS 6.0 on Win2003 Server that tries to get file and folder information on a Novell Server. I am able to successfully connect to the share on the Novell box if I use the UNC path. But, unfortunately, I need to have the mapped path for my application. I created a simple vbs script and saved it to the server desktop and run it to verify connectivity to the Novell box. I am logged in to the server with the same user as set up in my website as the anonymous user. The vbs file runs perfectly. But as soon as I move the code into an asp file, I get the following error "Microsoft VBScript runtime error '800a004c' Path not found". If I go into my asp file and change the path to the novell box to a UNC format, then it works. Below is the asp file: <% dim fso, fil, fldr, sbfldr set fso = server.CREATEOBJECT("Scripting.FileSystemObject") set fldr = fso.getfolder("g:\doc_test") for each sbfldr in fldr.subfolders response.write sbfldr.name & "<br>" next %> At this point, I don't feel like it's an authentication issue because I can get it to work with UNC. Any help is greatly appreciated. -- lhansen ------------------------------------------------------------------------ Posted via http://www.webservertalk.com ------------------------------------------------------------------------ View this thread: http://www.webservertalk.com/message988327.html Tag: Suggestion Assistance Tag: 309284
  - 13
    - How do you know if IIS 5.1 is running? I had a windows xp professional and I install the windows component so that I can use the IIS 5.1 to test an ASP file. I went to start and click the run button and then type mmc. As soon as the mmc window opens I click the console but there is an error saying that there is nothing into it. I need help! Thank you-- :) Tag: Suggestion Assistance Tag: 309282
  - 14
    - Problems with building sql statement Hi, I have a sql statement in asp page as below sql = " INSERT INTO tblExpense (ENO, EntryDate, ContractedServiceExpense, " sql = sql & "TravelExpense, PersonnelExpense)" sql = sql & " VALUES('" & l_ENO & "', '" & l_Date & "', '" & l_contractedserviceexpense & "', '" & l_travelexpense & "', '" & personnelexpense & "')" The response.write on sql gives the following: INSERT INTO tblExpense (ENO, EntryDate, ContractedServiceExpense, TravelExpense, PersonnelExpense) VALUES('1', '03/01/2005', '5', '5', '10') However when I am trying to open the recordset, it gives me the following error: Error Type: Microsoft JET Database Engine (0x80040E07) Data type mismatch in criteria expression. I suspect the variables are not properly used to build the above statement. The ENo is of text type, EntryDate is of date type while the rest of the last three fields are of number type. I appreciate any help. Thanks in advance. Regards. Tag: Suggestion Assistance Tag: 309281
  - 15
    - Formatting output I am using a response.write to test the formatting of the output. I am supposed to get this: BEGIN:VCALENDAR VERSION:1.0 BEGIN:VEVENT DTSTART:20051022T090000Z DTEND:20051022T090000Z LOCATION;ENCODING=QUOTED-PRINTABLE:Library UID:20051022T090000ZI-request DESCRIPTION;ENCODING=QUOTED-PRINTABLE:test SUMMARY;ENCODING=QUOTED-PRINTABLE:I-request PRIORITY:3 END:VEVENT END:VCALENDAR But instead I get this: BEGIN:VCALENDAR VERSION:1.0 BEGIN:VEVENT DTSTART:20051022T090000Z DTEND:20051022T090000Z LOCATION;ENCODING=QUOTED-PRINTABLE:Library UID:20051022T090000ZI-request DESCRIPTION;ENCODING=QUOTED-PRINTABLE:test SUMMARY;ENCODING=QUOTED-PRINTABLE:I-request PRIORITY:3 END:VEVENT END:VCALENDAR I am sure I am missing something very simple, but I can't figure out what I am doing wrong. Here is the code: strvCalendar = "BEGIN:VCALENDAR" & vbCrLf & _ "VERSION:1.0" & vbCrLf & _ "BEGIN:VEVENT" & vbCrLf & _ "DTSTART:" & strStart & vbCrLf & _ "DTEND:" & strStart & vbCrLf & _ "LOCATION;ENCODING=QUOTED-PRINTABLE:" & strLocation & vbCrLf & _ "UID:" & strStart & strSubject & vbCrLf & _ "DESCRIPTION;ENCODING=QUOTED-PRINTABLE:" & strDescription & vbCrLf & _ "SUMMARY;ENCODING=QUOTED-PRINTABLE:" & strSubject & vbCrLf & _ "PRIORITY:3" & vbCrLf & _ "END:VEVENT" & vbCrLf & _ "END:VCALENDAR" & vbCrLf Any ideas? TIA!!! Tag: Suggestion Assistance Tag: 309277
  - 16
    - Email link in message through msgbox I am trying to include an email link in the message displayed through a msgbox function. How can I do that? or can I? Thanks. Tag: Suggestion Assistance Tag: 309273
  - 17
    - IIS Stops working after 2-3 days I am working on a project using classic ASP. Every time I install Windows and IIS, it works for 2-3 days and then starts having problems. Specifically, things that have to do with the FileSystemObject stop working. I have tried Win2k, WinXP, the IISs that go with them, different partitions (fresh install), turning Windows Update Off as well as doing full updates, and cannot find a solution that works for more than 2 or 3 days. Is it a worm? A virus? A windows update glitch? It is driving me crazy. Are others having problems like this recently? Thank you, A.L. Tag: Suggestion Assistance Tag: 309271
  - 18
    - ASP Database Problem I have a windows200 server running iis5. I have a number of websites on the server, most of them using asp and either MSAccess or Sql Server databases. Every now and then all the pages that access a database slow way down or time out. I have spent a lot of time trying to track this down and have not found anything that would work. Here is my story. I know it's not a "pure" asp problem because test asp pages that don't access a database will load just fine. Around the time of the problem I often time see the following error, but not always. Access denied attempting to launch a DCOM Server. The server is: {00020906-0000-0000-C000-000000000046} The user is Unavailable/Unavailable, SID=Unavailable. (I have done this. http://support.microsoft.com/default.aspx?scid=kb;en-us;290398) Other websites on other servers that access the same SQL Server work just fine. VB programs running on other computers that are running against a database on the server with the websites that are having problems sometimes error out. at about the same time. The processor on the server always drops to almost zero during the time the pages are not working right. Sometimes the problems clears all on it's own. Sometimes I have to run iisreset to stop and start the server. Sometimes it won't restart and I have to reboot. My gut tells me that it's not related to iis or asp but I don't know that. I have always had some network problems with this server where from time to time a workstation may take a few seconds to browse the files. Confused? I am!!! Please help!!!!! Thanks, Tom Tag: Suggestion Assistance Tag: 309267
  - 19
    - Post file from server to another server - Urgent help required I accept a few user inputs and a file from the user, post it to my ASP page. I'm able to receive the data as well as the file properly in Receiver.asp. In my receiver.asp, I need to process the user inputs and subsequently POST this data and the file again to a different server. I would like to use ServerXMLHttp. Now, how do I simulate Form creation in receiver.asp. I use the following code to post to the second server MyXmlHttp.open "post", myTargetURL,false MyXmlHttp.setRequestHeader "Content-Type", "multipart/form-data" Now here's where I get stuck. 1) How do I construct the form data? How can I put together the data i received (which is text) as well as the received file (which is Binary) in the same Send statement for the Post? -- I assume that if HTML forms do it in some format, I should be able to simulate the same through ASP, but how??? 2) The received file will not be stored anywhere in my server. It has to be forwarded in memory. Should it look somewhat like the following? MyXmlHttp.send ("userId=" & someUserId & "&privateLabelID=" & someLabel & "&File=" & receivedBinaryFileInMemory) Thanks in advance for any help Tag: Suggestion Assistance Tag: 309260
  - 20
    - create an access database using asp+javascript How can I create a database access using asp+javascript withen the code?Is there (createdatabase)?If yes how can we use it? thanks for all -- fad ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Suggestion Assistance Tag: 309256
  - 21
    - Web Hosting - what do you suggest? Hi all, I'm italian and I'm planning to manage a web site using a web hosting in the US. Do you have some suggestions? I'm looking for asp, asp.net and ms sql support or in alternative php and mysql, with 24/24 support Thanks in advance PGei Tag: Suggestion Assistance Tag: 309249
  - 22
    - classes in vbscript Hi, i'm trying to create a class which one of its properties is another class. this is what i'm basicly trying to do : public bbb public aaa end class class bugi public ccc as new subbugi public ddd end class set a=new bugi a.ccc.aaa="ds" the problem is that for somereason this doesn't work. any solutions? Roy. Tag: Suggestion Assistance Tag: 309248
  - 23
    - Problem setting InnerText value I hope this illustrates my question a little better. Consider the following script; why does the client side script change the div object's innerHtml property but the server side script does not? Debug reports that the server script does not see the document's div object but I thought I read that varibles created with page scope are available throughout the page. <%@ language="VBSCRIPT" %> <html> <head> <script language="vbscript"> Sub chgDivText oDiv1.InnerHtml="Div changed by button" End sub </script> </head> <body> <div id="oDiv1">Div Label</div> <button onclick="chgdivtext">"Change Div Text"</button> </body> <% oDiv1.InnerHtml="Div changed by server" %> </html> Thanks for your help. Tag: Suggestion Assistance Tag: 309241
  - 24
    - non ascII char probleme hello, when i do .... set xmlhttp = CreateObject("WinHTTP.WinHTTPRequest.5.1") ..... StrXmlhttpResponseText = xmlhttp.responseText StrXmlhttpResponseText = replace(StrXmlhttpResponseText, "../", "/") response.write StrXmlhttpResponseText i have an probleme is the responseText contain non ascii char such as ? or é ! how can i correct that ? thank you by advance stéphane Tag: Suggestion Assistance Tag: 309236
  - 25
    - Want recursive SQL query function to generate breadcrumb navigation I'd want to make a custom class that will generate breadcrumb navigation for my site via a recursive query, e.g. Home > Page1 > Subpage 1. I've structured my database with hierarchical parent/child relationships. Can someone help me set up the code structure? I'm using ASP VBScript, and I have a table structure similar to the following: NavItems ---------- NavitemID (PK) Nav_ParentID Nav_Name The top level record in the entire table is "1", but it would be nice if I could parameterize the function so that I could specify the ID of the current page and the ID of the topmost ID I want to trace to, e.g. GetTrailOfBreadcrumbs(CurrentNavitemID, TopmostNavitemID) The least expensive approach from the standpoint of the database would be something that used something besides ADO recordsets to grab the data. If someone has some code lying around or can offer some guidance, I'd sure appreciate it. Thanks. -KF Tag: Suggestion Assistance Tag: 309232
- Next
  - 1
    - Unable to use variables in asp page I am trying to change text in the div tags of my page with values from an object obtained from a server side script but the object is not accessable to the client script. I get an object required error but I know the object exists and is correct becuase I can write the query string value and properties of the object with a server script. I also tried to access the div tags from the server script but this also resulted in an object required error. <body> <% sLdapStr = request.QueryString("ldapurl") set usrobj = GetObject(sLdapStr) %> <div id=oFirstName>label1</div><br> <div id="oLastName">label2</div><br> <div id="oEmpNum">label3</div><br> <% sLdapStr = request.QueryString("ldapurl") response.Write sldapstr & "<br>" response.Write usrobj.Get("givenName") %> <script language=vbscript> oFirstName.InnerText = usrobj.Get("givenName") oLastName.InnerText = usrobj.Get("sn") oEmpNum.InnerText = usrobj.Get("employeeID") </script> </body> Tag: Suggestion Assistance Tag: 309231
  - 2
    - Cannot grab some of the values from a form Hi, I got a simple form where one needs to input data. The data is being processed in an asp page. However, I cannot figure out why couple of values I am typing in the form is not being retrived in the asp processing page. Instead it shows as a null value. Any help is appreciated. I have attached the major code for the form, the processing page and output on the screen including sql output. Any help is appreciated. Regards. FORM CODE: <TABLE border = 0 width= "80%" > <TR> <TD> <INPUT id=chk_0 name = chk_0 type = hidden> <B><Font size = 2 color=darkblue>Add</font></B> </TD> <TD> <INPUT type = "text" size = 12 value = "" name = "ID_0" style = "FONT-SIZE: 10"> </TD> <TD> <INPUT type = "text" size = 12 value = "" name = "date_0" style = "FONT-SIZE: 10"> </TD> <TD> <INPUT type = "text" size = 12 value = "" name = "contractedserviceexpense_0" style = "FONT-SIZE: 10"> </TD> <TD> <INPUT type = "text" size = 12 value = "" name ="travelexpense_0" style = "FONT-SIZE: 10"> </TD> <TD> <INPUT type = "text" size = 12 value = "" name = "personnelexpense_0" style = "FONT-SIZE: 10"> </TD> </TR> </table> PROCESSING CODE: l_ENO = Request.Form("ID_0") Response.Write l_ENO & "<br>" l_Date = Request.Form("date_0") Response.Write l_Date & "<br>" l_ContracedServiceExpense = Request.Form("contractedserviceexpense_0") Response.Write l_contractedserviceexpense l_TravelExpense = Request.Form("travelexpense_0") Response.Write l_travelexpense & "<br>" l_PersonnelExpense = Request.Form("personnelexpense_0") Response.Write l_personnel & "<br>" 'Create the UPDATE SQL STATEMENT sql = " INSERT INTO tblExpense (ENO, Date, ContractedServiceExpense, " sql = sql & "TravelExpense, PersonnelExpense)" sql = sql & " VALUES('" & l_ENO & "' , '" & l_Date & "', '" & l_contractedserviceexpense & "', '" & l_travelexpense & "', '" & personnelexpense & "')" Response.Write sql & "<BR>" OUTPUT FROM THE PROCESSED ASP PAGE 1 03/29/2005 5 INSERT INTO tblExpense (ENO, Date, ContractedServiceExpense, TravelExpense, PersonnelExpense) VALUES('1' , '03/29/2005', '', '5', '') Tag: Suggestion Assistance Tag: 309228
  - 3
    - IIS 6 I am trying to run vb6 webclasses from a NT IIS6 webserver. For a few years we have been running these successfully on IIS4. I'm having a little trouble getting the initial asp page to load. Is there anytning special that needs to be installed for webclasses or asp on IIS 6? Thanks, Ellie Tag: Suggestion Assistance Tag: 309222
  - 4
    - how to retrieve windows login/pwd in ASP ? hi, I want to redirect my user to another page. With ASP (not .Net) and IIS 5.0, under windows 2000 server. We have installed the component WinHTTP that is used to manipulate http requests. We want to automatically identify the user through his Windows login/pwd (NTML) He does not need to type it. How do i get the login/pwd from windows, and perfom an authentification control ? A subsidiary question: then how do i set up a cookie in the client computer ? thanks Tag: Suggestion Assistance Tag: 309218
  - 5
    - ASP -> Database (Insert) Hi, i'm having problems with the insert command in .NET The Select statement works perfectly, but insert.. He gives an error when he executes the command: ExecuteNonQuery() Check the code below.. Thanx in advance! Public Sub voegToe(ByVal aproduct As Product) Dim oConn As New OleDbConnection(mStrConn) Dim sqlCmd As String = "INSERT INTO Product (ProductName, Color, Sizes, M_F, Price, ProductTypeID, ProductClassID, UnitsInStock) VALUES (@ProductName, @Color, @Sizes, @M_F, @Price, @ProductTypeID, @ProductClassID, @UnitsInStock)" Dim oCmd As New OleDbCommand(sqlCmd, oConn) oCmd.Parameters.Add(New OleDbParameter("@ProductName", aproduct.Naam)) oCmd.Parameters.Add(New OleDbParameter("@Color", aproduct.Kleur)) oCmd.Parameters.Add(New OleDbParameter("@Sizes", aproduct.Maat)) oCmd.Parameters.Add(New OleDbParameter("@M_F", aproduct.M_F)) oCmd.Parameters.Add(New OleDbParameter("@Price", aproduct.Prijs)) oCmd.Parameters.Add(New OleDbParameter("@ProductTypeID", aproduct.TypeID)) oCmd.Parameters.Add(New OleDbParameter("@ProductClass", aproduct.ClassID)) oCmd.Parameters.Add(New OleDbParameter("@UnitsInStock", aproduct.Voorraad)) Try oConn.Open() oCmd.ExecuteNonQuery() oConn.Close() Catch ex As Exception Throw New Exception("Database niet gevonden") oConn.Close() End Try End Sub My DB is added in the config file so i don't know what the problem COULD be.. I have the same problem with UPDATE & DELETE... Only SELECT works.. Tag: Suggestion Assistance Tag: 309199
  - 6
    - Generate Excel File Using ASP Hi experts, With response.contenttype = "application/vnd.ms-excel", I can easily export my data to Excel which is embeded and shown within a browser. If I'm going to save the Excel file through ASP programming, which method can I use? I need to save the data to Excel file with dynamic name (the file name should contain key values and appended with system datetime). Thanks a lot Tag: Suggestion Assistance Tag: 309198
  - 7
    - ASP/database problem I hope I can make this clear: I have an Access 2000 database that drives an ASP web site to track sales leads. There is a combo box , "units", that lists the inventory of models we sell. Here's a code snippet Fills the combo box: <select name="units" id="units"> <% While (NOT leads1.EOF) %> <option><%=(leads1.Fields.Item("units").Value)%></option> <% leads1.MoveNext() Wend If (leads1.CursorType > 0) Then leads1.MoveFirst Else leads1.Requery End If %> This code works perfectly to fill the combobox with the model names from the units table of the units db. Leads1 is the recordset that is connected to the db The 'units' table has three fields: ID (autonumber - PK) units - Text field AnnValue - currency field The form also has a readonly textbox, "AnnVal" to display the Annual cost of the service contract for that unit. Displays textbox: <td valign="top"><input name="AnnVal" type="text" id="AnnVal" size="15" readonly> </td> I want to populate that textbox with the data in the AnnValue field of the units db. Based on the choice the user makes in the combobox, I want the corresponding price to populate the read-only textbox. I have seen several solutions that employ some Javascript with ASP to get this to work but I have no idea how to implement these suggestions. Being a real newbie, can someone offer some nicely commented code to help me make this work the way I have described? Thank you so much. You folks have always been so helpful! Tag: Suggestion Assistance Tag: 309197
  - 8
    - cdosys with windows 2003 error Hi, I'm using windows 2003 with asp. However I'm having problems sending email using the cdosys object. My code is below and I don't believe its the code but on the send command. <% dim sch dim cdoConfig dim cdoMessage sch = "http://schemas.microsoft.com/cdo/configuration/" Set cdoConfig = Server.CreateObject("CDO.Configuration") cdoConfig.Fields.Item(sch & "sendusing") = 2 cdoConfig.Fields.Item(sch & "smtpserver") = "127.0.0.1" cdoConfig.fields.update Set cdoMessage = Server.CreateObject("CDO.Message") Set cdoMessage.Configuration = cdoConfig cdoMessage.From = "test@gmail.com" cdoMessage.To = "test@gmail.com" cdoMessage.Subject = "Sample CDONTS NewMail" cdoMessage.TextBody = "This is a test for CDONTS message" cdoMessage.Send Set cdoMessage = Nothing Set cdoConfig = Nothing %> error '8004020f' /tad/testing.asp, line 30 I'm not sure what's wrong. When I go to my SMTP Virtual Server settings in IIS --> Properties --> Delivery --> Advanced . The FQDN is localhost and the smarthost is blank. Any expertise/help would be greatly appreciated. Thanks :D Tag: Suggestion Assistance Tag: 309195
  - 9
    - developing asp with Access database open Hi All, I have some asp pages which use a local Access database. I want to add different records to the database and also to be able to browse the page. When the database is open in MS Access, I can't open the asp pages, because I get an error (Microsoft JET Database Engine (0x80004005) Could not use ''; file already in use.) I wonder if there is a way of being able to read records from the database in an asp script while the database is open in Access. Regards, Nicolae Tag: Suggestion Assistance Tag: 309192
  - 10
    - Read binary record from Database with ADODB.Stream Hello! I wanna read binary data from database with ADODB.Stream object. So I wrote code.. --------- <% query = "SELECT * FROM Categories" adoDB.DefaultDatabase = "Northwind" adoRs.Open query, adoDB, 1 Set rec = Server.CreateObject("ADODB.Record") 'read [Picture] column. rec = adoRs(3) ------------ And the 'rec' TypeName() is 'Byte()' But I can't get it to ADODB.Stream. How Can I do? Or Can I read binary column to another way? Pardon my poor English. Thanks. - GuyV - Tag: Suggestion Assistance Tag: 309190
  - 11
    - Excel properties Curt and McKirahan have been very helpful the past week as I have been introduced to something new to me: generating a spreadsheet from ASP. Now that I have the spreadsheet, I am in need of knowledge about how to control the properties. By properties, I mean font, hyperlink, and color information. I'd like the spreadsheet to have the same data as the HTML page it's getting the data from, but in a different format. I have been searching in several places, including the Excel Help files, but cannot find any info on how to do this. I'm not asking anyone to tell me how to do this; just looking for where to find out how to do this. Anyone here have any idea where I can look? Tag: Suggestion Assistance Tag: 309188
  - 12
    - Re: fso layout?/menu? Well, I don't know. I also struggle with putting myself in the end user's perspective and designing friendly interfaces. But, if you went with a Windows Explorer type of view, you could try to duplicate the behaviors. The ability to select a file and press F2 to rename it. You could use context menus for file operations. Confirmations for deleting. It'd be a LOT of work, and involve much, much more client-side code than ASP I'm sure. I've seen things before you'd have a list like so: ../ file1 delete rename file2 delete rename file3 delete rename The delete links would just do a if(confirm('delete?')) {... and then delete the file. The rename links would take you to a different page with just a textbox in which you type the new file name. Ray at work From: "Mike D" <MikeD@discussions.microsoft.com> Subject: Re: fso layout?/menu? Date: Monday, March 28, 2005 3:59 PM Writing the files and folder names out should be easy enough. Would you use a radio button for users to select files or folder they want to do something to. Then go to another page and allow the user to rename/delete the file or folder? I have been pondering the best way to do this and don't have a great visual of how it will look and how a user will "tell" the page what they want to do. Thanks for the reply. Mike "Ray Costanzo [MVP]" wrote: > Well, you could try to mimic Windows Explorer. That seems to be an > acceptable interface for most people. > Tag: Suggestion Assistance Tag: 309187
  - 13
    - Check file date of text file Hi. I am tring to setup an asp script that will do the following... If file date/time is within last 10 minutes then response.redirect to file else do something else end if The text file is not located on the webserver. I created a virtual directory on the webserver which allows me to response.redirect to the file. However when I use the FileSystemObject to check the date/time, I cannot find the file. It seems like it only works against files on the webserver. UNC paths do not seem to work. I was hoping the virtual directory would allow me to specify something like c:\inetpub\wwwroot\<VIRTUAL DIR NAME>\<FILE NAME>, however that's not working either. Basically, is there any way to use FileSystemObject against a file not on the webserver, or can I get the file date/time using something else? Thanks. Tag: Suggestion Assistance Tag: 309182
  - 14
    - fso layout?/menu? I need a page or set of pages to allow a user to mange the file system under a certain folder. This certain folder will be determined by authentication and db checks. So the user will need to be able to Rename files or folders, Delete files or folders and move files or folders. I can handle writing the code to do this but I am stuck on a user interface. Does anyone have a good example they would be willing to show me? Thanks Mike Tag: Suggestion Assistance Tag: 309180
  - 15
    - codepages and cookies Hi... I'm a little perplexed. <%@Codepage="65001" %> changes how IIS/ASP will handle interpreting query string variables - i.e. it will read the querystring as being utf-8 encoded. However, I'm finding that it *doesn't* change how Response.Cookies or Request.Cookies get read/written. I've been testing with a little jscript asp page with the lines if (String (Request.QueryString ("abc")) != "undefined") Response.Cookies("abc") = Request.QueryString ("abc"); Response.Write (Request.QueryString ("abc")); to take a value from the query string and pass it back out as a cookie. The test value I was using was r%c3%a9sume (resume with an accented e). When the code page is set to utf-8, it will properly interpret the urlencoded query as a utf-8 string. It will output the right bytes with Response.Write. But watching the headers produced by the request, it comes out encoded in latin-1. Set-Cookie: abc=r%E9sume; path=/ I checked the cookie rfc on w3c.org, and oddly it doesn't say much about how to encode/interpret cookie NAME=VALUEs. The only comment on character set in the spec is that a cookie *comment* has to be utf-8 encoded. I couldn't find anything on the MSDN documentation that addressed cookie character sets either. Anyone else run into this? Thanks _mark Tag: Suggestion Assistance Tag: 309179
  - 16
    - ASP WORD/RTF Download Hi Folks, I am generating a word document from an asp page using the following header: Response.ContentType = "application/rtf" Response.AddHeader "Content-Disposition", "attachment; filename=" & objRS("FieldName") & " " & Replace(Date, "/" , "-") & ".rtf;" This works fine for me and most users, however, sometimes, I hear from a user that gets an error like "File cannot be found/Check Spelling/try different name" or something like that. Anyway, the solution for these users is to rename the word document before they save it. Does anyone know what would cause this for the occasional user? A browser security setting maybe? It happens with maybe 1 in 20 users - all using Win XP. Thanks, Jack Coletti St. Petersburg, FL Tag: Suggestion Assistance Tag: 309174
  - 17
    - ASP Error Event information is missing the file name I am using Windows 2003/IIS 6. The following event occurs during the day. i want to debug the culprit ASP page which is causing this, but having hard time without knowing on what page and website where the error occurs. May anyone have any idea 1)how to change the server configuration so it will log the page, or 2) is the error log stored elsewhere (i checked onWINDOWS\system32\LogFiles\HTTPERR, but it logs different sort of errors), or 3)is there another way to log only errors (we have an internal error monitoring system, but this error seems to escape it. maybe it's on global.asa)? Thanks in advance, Amitay Event Type: Warning Event Source: Active Server Pages Event Category: None Event ID: 9 Date: 28/03/2005 Time: 18:00:37 User: N/A Computer: WEB1 Description: Warning: IIS log failed to write entry, Script timed out. The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Tag: Suggestion Assistance Tag: 309172
  - 18
    - MAKE MONEY FAST AND EASY!!!!!! AND LEGAL Make Money Fast and Easy!!!!!! Just by following these simple steps: *MAKE EASY AND QUICK CASH MONEY by doing almost nothing (NO JOKE, NO SCAM, AND VERY LEGAL)* $ Please read on! $ You will be very thankful you did! PLEASE READ LIFE CHANGING INFORMATION!! $5.00 to $42,000!! in few days THIS IS AN EASY, HONEST, AND LEGAL WAY TO MAKE SOME QUICK CASH. ! WoW ! THIS REALLY WORKED! I CAN'T BELIEVE IT! YOU WON'T EITHER! But it is So Let's Start :-- A while back, I was browsing these newsgroups, just like you are now, and came across an article similar to this that said you could make thousands of dollars within weeks with only an initial investment of $5.00 plus stamps! So I thought, "Yeah, right, this must be a scam!" But like most of us I was curious and kept reading. It said that if you send $1.00 to each of the 5 names and addresses listed in the article, you could make thousands in a very short period of time! You then place your own name and address at the bottom of the list at #5, and post the article to at least 200 newsgroups. (There are about 32,000 of them out there and that's quite a large market pool). Even though the investment was a measly $5, I had 3 questions that needed to be answered before I could get involved in this sort of thing. 1. IS THIS REALLY LEGAL?? I called a lawyer first. The lawyer was a little skeptical that I would actually make any money but he said it WAS LEGAL if I wanted to try it. I told him it sounded a lot like a chain letter but the details of the system (SEE BELOW) actually made it a legitimate legal OR IS IT MAIL FRAUD?.... I called them: 1-800- 725-2161 and they confirmed THIS IS ABSOLUTELY LEGAL! (See Title18, h sections1302 NS 1341 of Postal Lottery Laws). This clarifies the program of business. 2. IS IT OK WITH THE POST OFFICE collecting names and addresses for a mailing list. Well of course, It is. 3. IS IT MORAL? Well, everyone who sends me a buck has a good chance of getting A LOT of money ... a much better chance than buying a lottery ticket!!! So, having these questions answered, I invested EXACTLY $8.04 ... five $1.00 bills and six 34 cent postage stamps ... boy am I glad I did!!! Within 7 days, I started getting money in the mail! !!! I was shocked !!! I figured it would end soon and didn't give it another thought. But the money continued coming in. In my first week I made between $20 to $30. By the end of the second week I had a made a total of $1,000.00. In the third week I had over $10,000.00 and it was still growing. This is now my fourth week and I have made a total of just over $42,000 and it's still coming in ..... It's certainly worth $5.00 and 5 stamps!!! Also, make sure you print a copy of this article NOW so you can get the information off of it as you need it. I promise you that if you follow the directions exactly, that you will start making more money than you thought possible by doing something so easy! Suggestion:- Read this entire message carefully! (Print it out or download it.) Follow the simple directions and watch the money come in!$$$$$$$$$$ It's easy! It's legal ! And, your investment is only $5.00 (Plus postage) ! This is not a rip-off; it is not indecent; it is not illegal; and it is virtually no risk - it really works!!!! If all of the following instructions are adhered to, you will receive extraordinary dividends. PLEASE NOTE: Please follow these directions EXACTLY, and $50,000 or more can be yours in 20 to 60 days. This program remains successful because of the honesty and integrity of the participants. Please continue its success by carefully adhering to the instructions. You will now become part of the Mail Order business. In this business your product is not solid and tangible, it's a service. You are in the business of developing Mailing Lists. it really works!!!! Many large corporations are happy to pay big bucks for quality lists. However, the money made from the mailing lists is secondary to the income which is made from people like you and me asking to be included in that list. HERE ARE 4 EASIEST STEPS TO SUCCESS: STEP-1: Get 5 separate pieces of paper and write the following on each piece of paper "PLEASE PUT ME ON YOUR MAILING LIST."Now get 5 US $1.00 bills and place ONE inside EACH of the 5 pieces of paper so the bill will not be seen through the envelope (to prevent thievery). Next, place one paper in each of the 5 envelopes and seal them. You should now have 5 sealed envelopes, each with a piece of paper stating the above phrase, your name and address, and a $1.00 bill. What you are doing is creating a service. THIS IS ABSOLUTELY LEGAL! You are requesting a legitimate service and you are paying for it! Like most of us I was a little skeptical and a little worried about the legal aspects of it all. So I checked it out with the U.S. Post Office (1-800-725-2161) and they confirmed that it is indeed legal! Mail the 5 envelopes to the following addresses: 1. COLIN ROATY, 23351 FERN CRESCENT, MAPLE RIDGE, B.C., V4R 2S6, CANADA 2. T. DOWNEY, 194 CITY RD 34, NORWICH, NY 13815 3. RAFAEL JIMÉNEZ REINA. CALLE LOPE DE VEGA Nº 28. CP: 41700 DOS HERMANAS (SEVILLA). ESPAÑA. 4. A.J. SANDLES, 1418 S, 34TH. ST., MILWAUKEE, WI 53215 5. JOSÉ MIGUEL BAZTÁN J. C/ ING. DAVID MASALLES, #46 URB. FERNANDEZ, SANTO DOMINGO, REPUBLICA DOMINICANA STEP-2: Now take the #1 off the list that you see above, move the other names up (5 becomes 4, 4 becomes 3, etc...) and add YOUR Name as number 5 on the list. STEP-3: Change anything you need to, but try to keep this article as close to original as possible. STEP-4: Now, post your amended article to at least 200 newsgroups. (I think there are close to 32,000 groups) All you need is 200, but remember, the more you post, the more money you make! This is perfectly legal! Keep a copy of these steps for yourself and, whenever you need money, you can use it again, and again. PLEASE REMEMBER that this program remains successful because of the honesty and integrity of the participants and by their carefully adhering to every step in the directions. Look at it this way. If you are a person of integrity, the program will continue and the money that so many others have received will come your way. Note: You may want to retain every name and address sent to you, either on a computer or hard copy and keep the notes people send you. This VERIFIES that you are truly providing a service. (Also, it might be a good idea to wrap the $1 bill in dark paper to reduce the risk of mail theft.) So, as each post is downloaded and the directions carefully followed, five members will be reimbursed for their participation as a List Developer with one dollar each. Your name will move up the list geometrically so that when your name reaches the #1 position you will be receiving thousands of dollars in CASH!!! What an opportunity for only $5.00 ($1.00 for each of the first six people listed above) Send it now, add your own name to the list and you're in business! HOW TO POST TO NEWSGROUPS --- DIRECTIONS --- STEP-1: You do not need to re-type this entire letter to do your own posting. Simply put your cursor at the beginning of this letter and drag your cursor to the bottom of this document, and select 'copy' from the edit menu. This will copy the entire letter into the computer's memory. STEP-2: Open a blank 'notepad' file and place your cursor at the top of the blank page. From the 'edit' menu select 'paste'. This will paste a copy of the letter into notepad so that you can add your name to the list. STEP-3: ) Save your new notepad file as a .txt file. If you want to do your postings in different settings, you'll always have this file to go back to. STEP-4: Use Netscape or Internet explorer and try searching for various newsgroups (on-line forums, message boards, chat sites, discussions.) STEP-5: Visit these message boards and post this article as a new message by highlighting the text of this letter and selecting paste from the edit menu. Fill in the Subject, this will be the header that everyone sees as they scroll through the list of postings in a particular group, click the post message button. You're done with your first one! Congratulations... THAT'S IT! All you have to do is jump to different newsgroups and post away, after you get the hang of it, it will take about 30 seconds for each newsgroup! **REMEMBER, THE MORE NEWSGROUPS YOU POST IN, THE MORE MONEY YOU WILL MAKE!! BUT YOU HAVE TO POST A MINIMUM OF 200** That's it! You will begin receiving money from around the world within days! You may eventually want to rent a P.O. Box due to the large amount of mail you will receive. If you wish to stay anonymous, you can invent a name to use, as long as the postman will deliver it. **JUST MAKE SURE ALL THE ADDRESSES ARE CORRECT** Now the WHY part: Out of 200 postings, say I receive only 5 replies (a very low example). So then I made $5.00 with my name at #5 on the letter. Now, each of the 5 persons who just sent me $1.00 make the MINIMUM 200 postings, each with my name at #5 and only 5 persons respond to each of the original 5, that is another $25.00 for me, now those 25 each make 200 MINIMUM posts with my name at #4 and only 5 replies each, I will bring in an additional $125.00! Now, those 125 persons turn around and post the MINIMUM 200 with my name at #3 and only receive 5 replies each, I will make an additional $626.00! OK, now here is the fun part, each of those 625 persons post a MINIMUM 200 letters with my name at #2 and they each only receive 5 replies, that just made me $3,125.00!!! Those 3,125 persons will all deliver this message to 200 newsgroups with my name at #1 and if still 5 persons per 200 newsgroups react I will receive $15,625,00! With an original investment of only $5.00! AMAZING! When your name is no longer on the list, you just take the latest posting in the newsgroups, and send out another $5.00 to names on the list, putting your name at number 5 again. And start posting again. The thing to remember is: do you realize that thousands of people all over the world are joining the internet and reading these articles everyday? JUST LIKE YOU are now!! So, can you afford $5.00 and see if it really works?? I think so... People have said, "what if the plan is played out and no one sends you the money? So what! What are the chances of that happening when there are tons of new honest users and new honest people who are joining the internet and newsgroups everyday and are willing to give it a try? Estimates are at 20,000 to 50,000 new users, every day, with thousands of those joining the actual internet. Remember, play FAIRLY and HONESTLY and this will really work. ** By the way, if you try to deceive people by posting the messages with your name in the list and not sending the money to the rest of the people already on the list, you will NOT get as much. Someone I talked to knew someone who did that and he only made about $150.00, and that's after seven or eight weeks! Then he sent the 6 $1.00 bills, people added him to their lists, and in 4-5 weeks he had over $10k. This is the fairest and most honest way I have ever seen to share the wealth of the world without costing anything but our time!!! You also may want to buy mailing and e-mail lists for future dollars. Make sure you print this article out RIGHT NOW! Also, try to keep a list of everyone that sends you money and always keep an eye on the newsgroups to make sure everyone is playing fairly. Remember, HONESTY IS THE BEST POLICY. You don't need to cheat the basic idea to make the money!! GOOD LUCK to all and please play fairly and reap the huge rewards from this, which is tons of extra CASH. Please remember to declare your extra income. Thanks once again... LEGAL? ? ? (Comments from Bob Novak who started this new version.) "People have asked me if this is really legal. Well, it is! You are using the Internet to advertise your business. What is that business? You are assembling a mailing list of people who are interested in home- based computer and online business and methods of generating income at home. Remember, people send you a small fee to be added to your mailing list. It is legal. What will you do with your list of thousands of names? That's up to you." So, build your mailing list, keep good accounts, declare the income and pay your taxes. By doing this you prove your business intentions. Keep an eye on the newsgroups and when the cash has stopped coming (that means your name is no longer on the list), you just take the latest posting at the newsgroups, send another $5.00 to the names stated on the list, make your corrections (put your name at #5) and start posting again. NOTES: * 1. In some countries, the export of the country's exchange is illegal. But you can get the license to do this from the post office, explaining the above statements (that you have an online business, etc. You may have to pay an extra tax, but that's OK, the amount of the incoming money is HUGE! And as I said, a few countries have that restriction. *2. You may want to buy mailing and e-mail lists for future dollars. (Or Database or Spreadsheet software.) *3. If you're really not sure or still think this can't be for real, please print a copy of this article and pass it along to someone who really needs the money, and see what happens. *4. You will start getting responses within 1-2 weeks, it depends. ***ALSO REMEMBER*** SEND YOUR $1 OUT TO EVERYONE ON THE LIST, EVEN IF THEY ARE NOT FROM THE U.S. WHAT ARE YOU WAITING FOR??? !!!! Good Luck !!!! My business :- Remember: Once in a while I will send out information to you on home business and computer and internet business. Also on how to make money. Other wise this would be illegal. I have my own business that informs people about home business and puts them on my list for $1. Use this information wisely and you can easily start earning thousands of dollars. You have the right to just copy this information and paste it for your own adds MAKE MONEY FAST AND EASY!!!!!! AND LEGAL Tag: Suggestion Assistance Tag: 309162
  - 19
    - localhost... hi all I just bought a new computer with win XP PRO. I'm trying to set it up so that I can use it as a local host and with IIS etc. I don't really know where to start. How do I start running IIS? At this point, pointing to localhost doesn't work but I'm not sure what I'm supposed to be doing. I'd really appreciate any help. TIA -- Sara Tag: Suggestion Assistance Tag: 309159
  - 20
    - ,localhost... Hi all -- Sara Tag: Suggestion Assistance Tag: 309158
  - 21
    - how to install IIS? my computer is win xp professiional.. i try to IIS yester day by going to control panel->Add or remove programs-> Add remove/Windows Components after this there is a dialog box prompt out, and i tick at IIS,and there is another dialog box prompt out and ask me to insert win xp sp1 cd to install the IIS. so i to get a xp sp1 cd from my friend, but i dono how to install it by cd. is it there got any links can download -- machi ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Suggestion Assistance Tag: 309149
  - 22
    - ASP stops responding Everything runs fine for a while (weeks even), and then IIS stops responding to (or even logging) requests for ASP pages. HTML pages are served up just fine. I'm running Windows 2000 SP4, and IIS 5.0. Windows Update tells me I'm up to date on patches. The problem has happened three times on a production server and twice on a test server. I reproduced the problem on the test server after using the web stress-test tool--once right after the stress-test finished, and once after the sessions established by another stress-test run timed out. At least two of the three times on the production server, though, there hadn't been any real activity (new or timed-out) in several hours. There's nothing in the Event Log or W3SVC log. No error messages anywhere that I can find. Once the problem starts, the IIS Console may hang. This doesn't happen right away--once, it doesn't happen for many minutes after the problem started. Once the problem starts, I can't use "NET STOP" to stop the WWW Publishing Service. IISreset does clear the problem. My primary ASP application uses some custom VB 6.0 DLLs, and stores a few references to them in session variables. Although I know that's not advised (see the recent thread "Storing objects in Session Variables - exactly why not?"), I don't think it's the cause of the problem--memory and performance don't seem to be issues. Before I embark on revising several DLLs and many ASP pages to not store objects in session variables, I'd like to consider alternatives, especially since I haven't found any indication that this is causing the problem. I'd appreciate any thoughts or suggestions you might have. Thanks! MJ. Tag: Suggestion Assistance Tag: 309148
  - 23
    - adCurrency problem in ASP I'm using ADO from an ASP 3.0 page written in JScript to query a database table in SQL Server 2000. One of the columns in a currency field. Instead of retrieving a value of 1095.60 like I expect, I'm getting 1095.6000000000001 instead. If I use other tools like Query Analyzer to run my select the value comes out as I expect. The type of the ADO field in my recordset is adCurrency as I expect. Here's a short example of code that demonstrates the problem: var strSQL = "select ItemPrice from dbo.item where ItemID = 5"; var oConn = Server.CreateObject("ADODB.Connection"); oConn.Open(getDBConnectionString()); var rs = oConn.Execute(strSQL); while (!rs.EOF) { Response.Write(rs("ItemPrice").Value + "<br>"); rs.MoveNext(); } rs.close(); oConn.close(); Am I doing something wrong here? My DSN shows Microsoft SQL Server ODBC Driver Version 03.85.1025 Is there a driver problem? Tag: Suggestion Assistance Tag: 309143
  - 24
    - screen scraping Am I correct in assuming screen scraping is just the response text sent to the browser? If so, would that mean that this could not be screen scraped? function moi() { var tag = '<a href='; var tagType1 = '"mail'+'to:', tagType2 = '">', tagType3 = '<\/a>'; var user1 = 'web', user2 = 'master', user3 = '@'; var dom1 = 'danger', dom2 = 'ous', dom3 = 'ly'; var tld = '.us'; document.write(tag+tagType1+user1+user2+user3+dom1+dom2+dom3+tld+tagType2+user1+user2+user3+dom1+dom2+dom3+tld+tagType3); } -- Roland Hall /* This information is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose. */ Technet Script Center - http://www.microsoft.com/technet/scriptcenter/ WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp MSDN Library - http://msdn.microsoft.com/library/default.asp Tag: Suggestion Assistance Tag: 309138
  - 25
    - Newbie to ASP.Net Hi, I am writing a small application and I am facing the 2 following problems. 1) I have implemented an authentication screen (simple username and password), and when user signs in, I use the following and redirect user to a main page Session["connected"] = username; When user tries to visit the main page, without first having signed in, in the Page_Load, I check the value of the Session["connected"] and if its empty, I redirect user back to authentication screen. Now when user signs out, Session["connected"] is set "" and user is redirected to authentication screen. When user have at leasted visted main page once in authenticated state, and then in non-authenticated state, he tries again to visit the main page, he is not being directed to authentication screen, but entering main page normally. I tried to do some debugging in the method Page_Load, but at the time descrived in this paragraph, it is not entering in this method. Is there any other method that I should handle/overload? 2) I have followed this link to do a drop-down menu: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_fp2003_ta/html/OfficeFrontPageCreateDropDownMenu.asp Now one of the menu Items is Sign Out. In this Sign out I have done a link to the Authentication screen described earlier. Now before I redirect the user I require to do some operations like Session["connected"] = ""; Can this be done with some scripting. I have done something similar to this in another language, previously. I hope someone understands my problems and helps me out. Thanks in Advance Tag: Suggestion Assistance Tag: 309134

I have my webserver and a database. Things started to slowdown a ton with
access, permissions denied (it is on a Windows XP machine, 10 session limit,
etc).

I moved my database off the webserver to a faster and more secure location.
I can't access the database through the webserver anymore.

I am using Windows Authentication. I understand that the webserver will be
using the IUSR_xxxx account to access the database. I am at a loss on how
to access the database

Please help.

Thanks

Top

Re: Suggestion Assistance by Bob

Bob
Thu Mar 31 15:20:51 CST 2005

nca-wom wrote:
> I have my webserver and a database. Things started to slowdown a ton
> with access, permissions denied (it is on a Windows XP machine, 10
> session limit, etc).
>
> I moved my database off the webserver to a faster and more secure
> location. I can't access the database through the webserver anymore.
>
> I am using Windows Authentication. I understand that the webserver
> will be using the IUSR_xxxx account to access the database. I am at
> a loss on how to access the database
>
> Please help.
>
> Thanks

What kind of database?
Never mind. See this:
http://www.aspfaq.com/show.asp?id=2168

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Top

Re: Suggestion Assistance by Ray

Ray
Thu Mar 31 15:31:53 CST 2005

In addition to what Bob said, you realize that this won't change the 10
connection limit in XP, right? I don't see how this will solve your
problem.

Ray at work

"nca-wom" <nca-wom@yahoo.com> wrote in message
news:u37lkZjNFHA.1176@TK2MSFTNGP15.phx.gbl...
> I have my webserver and a database. Things started to slowdown a ton with
> access, permissions denied (it is on a Windows XP machine, 10 session
limit,
> etc).
>
> I moved my database off the webserver to a faster and more secure
location.
> I can't access the database through the webserver anymore.
>
> I am using Windows Authentication. I understand that the webserver will
be
> using the IUSR_xxxx account to access the database. I am at a loss on how
> to access the database
>
> Please help.
>
> Thanks
>
>
>

Top