Can you go to this newsgroup via a web interface ?

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
    - two server processing Is it possible to have server1 do a post to another page on server2? Server2 page does it's thing and submit the results back to server1. All of this is done without any reference in the url. I tried server.execute and transfer but it only works on the same server. Basically, I have a component on server2 inside my firewall. Server1 is for public use. Users enter server1 and request what report they want. The report should pass to server2 to instantiate an object and create a report on the fly and store the pdf on server1. Users just have to view or download it from server1. All this is done without the user knowing they left server1. This does work if I sent the server1 form action to server2. But then it's on url now. Thanks. Khanh Tag: Can you go to this newsgroup via a web interface ? Tag: 297174
  - 2
    - Script Timeout and Dialup connection I've been researching this issue with little luck. Here's the situation: We have a few users on slow dialup connections who are posting data from forms. Frequently, they get script timeout errors. We've gotten timeouts from users with faster connections as well, so I suspected that the overall load is overtaxing the server. But it does seem to be more frequent with dialup users posting relatively large (>10K) worth of data from forms. The Script Timeout value for the site is 20 seconds. IMO, it's seems quite odd that connection speed could influence a server-side script timeout, but... Question: When form data is posted, does the server begin processing upon receipt of the first packet with the post request, or does it wait until all packets have arrived? Question 2: Is 20 seconds too short, or are there potential problems with increasing it to, say, 30, 45, or even 60 seconds? Any help would be appreciated. Thanks. Scott Tag: Can you go to this newsgroup via a web interface ? Tag: 297167
  - 3
    - working out time passed between two dates I am trying to work out the length of time that a page was opened till it reached another page, I amusing the script below End_Of_Call = formatdatetime(now(), 0) 'work out the duration of the call duration = End_Of_Call - cdate(vTime) response.write isdate(End_Of_Call) response.write isdate(vTime) 'response.write duration response.End() but it errors and i get Microsoft VBScript runtime (0x800A000D) Type mismatch: '[string: "7/21/2004 2:34:49 PM"]' /testing/process_new.asp, line 30 I cant understand why it doesn't work, it is being run on the same server as before and is identical code, except i dont use formatdatetime on both variables to set them, if i remove formatdatetime i still get type mismatch, any ideas how i can make this work. thanks Tag: Can you go to this newsgroup via a web interface ? Tag: 297159
  - 4
    - need help can i change the MSIE (extra,options, securty) with asp or javascript? if answer is yes how? Tag: Can you go to this newsgroup via a web interface ? Tag: 297152
  - 5
    - need quick helpp i have an web page. it use frame set .. but main frame is one server the other frame is another server. when i want to set a cookie or session from child frame.. it doesnt work... i research the problem from msn i tried <%Response.Buffer = True response.AddHeader "CP","CAO PSA OUR"%> CAUSE Internet Explorer 6.0 introduced support for the Platform for Privacy Preferences (P3P) Project. The P3P standard notes that if a FRAMESET or a parent window references another site inside a FRAME or inside a child window, the child site is considered third party content. Internet Explorer, which uses the default privacy setting of Medium, silently rejects cookies sent from third party sites. RESOLUTION You can add a P3P compact policy header to your child content, and you can declare that no malicious actions are performed with the data of the user. If Internet Explorer detects a satisfactory policy, then Internet Explorer permits the cookie to be set. Visit the following MSDN Web site for a complete list of satisfactory and unsatisfactory policy codes: Privacy in Internet Explorer 6 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpriv/html /ie6privacyfeature.asp A simple compact policy that fulfills this criteria follows: P3P: CP="CAO PSA OUR" This code sample shows that your site provides you access to your own contact information (CAO), that any analyzed data is only "pseudo-analyzed", which means that the data is connected to your online persona and not to your physical identity (PSA), and that your data is not supplied to any outside agencies for those agencies to use (OUR). You can set this header if you use the Response.AddHeader method in an ASP page. In ASP.NET, you can use the Response.AppendHeader method. You can use the IIS Management Snap-In (inetmgr) to add to a static file. ********************************************************************* and i dont have a permission in main frame and its server... Follow these steps to add this header to a static file: 1.. Click Start, click Run, and then type inetmgr. 2.. In the left navigation page, click the appropriate file or directory in your Web site to which you want to add the header, right-click the file, and then click Properties. 3.. Click the HTTP Headers tab. 4.. In the Custom HTTP Headers group box, click Add. 5.. Type P3P for the header name, and then for the compact policy string, type CP=..., where "..." is the appropriate code for your compact policy. this will made in child server or main server? please help me quickly??? Tag: Can you go to this newsgroup via a web interface ? Tag: 297148
  - 6
    - Sorting column headings I'm using the code below to display the results in rows with the column header as hyperlinks that will sort the rows by colum heading. Is there a way to have the results sorted (as default) in reverse order so that the most recent are at the top of the page also when the user selects the Open Date or Status column headings, sort the data in reverse order . Code is below. Thanks <% ppl_ctr=0 dim mthd ' Set up SELECT Statement (Order by if user selected) If IsEmpty(Request.QueryString("Order")) Then SQLStatement = "Select * From calls Order by callID" strORDER = "Ordered by ID" Else SQLStatement = "SELECT * FROM calls ORDER BY " & Request.QueryString("Order") & ", callID" If (Request.QueryString("Order") = "callID") Then strORDER = "Ordered by ID" Else strORDER = "Ordered by " & Request.QueryString("Order") End If End If %> <div align="center"> <center> <table border="0" cellpadding="0" cellspacing="0" width="100%" style="border-collapse: collapse" bordercolor="#111111"> <tr> <td align="center" width="100%"> <font size="5">Support Calls</font> </td> </tr> <tr> <td align="center" width="100%"> <a href="default.asp">Return to Support Call Home Page</a></td> </tr> </tr> <tr> <td align="center" width="100%">  </td> </tr> </table> </center> </div> <% Set RScalls = dbConnection.Execute(SQLStatement) %> <table align="center" border="1" cellspacing="0" cellpadding="5"> <tr bgcolor="#B1C1D1"> <td rowspan="2"><font size="-1"><b><a href="call_list.asp?Order=callID">ID</a></b><br></font></td> <td width="50%" rowspan="2"><font size="-1"><b><a href="call_list.asp?Order=Title">Title</a></b></font></td> <td rowspan="2"><font size="-1"><b><a href="call_list.asp?Order=OpenDate">Open Date</a></b></font></td> <td rowspan="2"><font size="-1"><b><a href="call_list.asp?Order=RecvBy">Logged By</a></b></font></td> <td rowspan="2"><font size="-1"><b><a href="call_list.asp?Order=status">Status</a></b></font></td> <td rowspan="2"><font size="-1"><b><a href="call_list.asp?Order=state">State</a></b></font></td> <td colspan="3"> <p align="center"><font size="-1"><b>Severity</a></b></font></td> </tr> <tr bgcolor="#B1C1D1"> <td><font size="-1"><b><a href="call_list.asp?Order=Severity1 DESC">Sev 1</a></b></font></td> <td><font size="-1"><b><a href="call_list.asp?Order=Severity2 DESC">Sev 2</a></b></font></td> <td><font size="-1"><b><a href="call_list.asp?Order=Severity3 DESC">Sev 3</a></b></font></td> </tr> <% Do While Not RScalls.EOF callscounter=callscounter+1 %> <tr> <td> <small> <% If (Request.QueryString("Order") <> "") Then %> <form method="Get" action="call_call_list.asp" id=form24 name=form24> <input type="hidden" name="Order" value="<%=Request.QueryString("Order") %>"> <% End If %> <a href="update.asp?submit=Update&callID=<%=RScalls("callID")%>"> <%=RScalls("callID")%> </a> </td> <td width="45%"><small><%=RScalls("title") %></small> </td> <td><small><%=RScalls("OpenDate")%></small> </td> <td><small><%=RScalls("RecvBy")%></small> </td> <td><small><%=RScalls("status")%></small> </td> <td><small><%=RScalls("state")%></small> </td> <td><small><%=RScalls("severity1")%></small> </td> <td><small><%=RScalls("severity2")%></small> </td> <td><small><%=RScalls("severity3")%></small> </td> </tr> <% RScalls.movenext Loop %> <% If callscounter=0 Then %> <%= "No Calls were found at this time." %> <% End If %> </table> Tag: Can you go to this newsgroup via a web interface ? Tag: 297145
  - 7
    - Display multiple lines Hello, Can anybody give me some tips on the best and/or easiest way to display multiple lines in a field. The data is collected from a "textarea" field when the form is submitted, and I want to display all of the data (multiple lines) in a resulting HTML page. The data displays on a single line (obviously) and does not wrap without manipulation of the string variable. Is there an easier way to display the data? Thanks, Joe Tag: Can you go to this newsgroup via a web interface ? Tag: 297143
  - 8
    - ASP, Dates & Languages We have a few English websites running on a single server and are in the process of adding a Spanish website to the same server. I am trying to determine how one would set the language for a particular website. For example, instead of ASP generating a date like "Monday, July 19, 2004" .. I would like something similar, but in Spanish. Tag: Can you go to this newsgroup via a web interface ? Tag: 297129
  - 9
    - Script context highlighting Could someone please point me in the direction of a function that will parse a "code" output and colorise the context of the script? eg - vbulletin style [code] output Cheers Tag: Can you go to this newsgroup via a web interface ? Tag: 297127
  - 10
    - Problem with this code.... Hey, Thanks for your response and yes I know that my code could use a lot o cleaning up. I am mainly a network engineer (CCIE #12284) and onl program as a hobby. The structure of the database is: CREATE TABLE [dbo].[tblTournaments] ( [TID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL , [TNum] [numeric](18, 0) NOT NULL , [TDate] [datetime] NOT NULL , [Member] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NUL , [Buyin] [money] NOT NULL , [TType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NUL , [won] [money] NOT NULL , [Place] [int] NOT NULL , [TotalPlayers] [int] NULL ) ON [PRIMARY] The situation is that 3-4 of us will team a Multi-Table Poke tournament online and share or profits of that tournament to hel balance the swings that can occur when playing poker. When we finish tournament all users enter the information for that tournament an every tournament is stored in the same table. If the tournament number match that means that multiple members played in the same tournament Example data would be: 10 2071171 2004-07-14 00:00:00.000 Kewlb 11.0000 2T-SnG .0000 6 18 11 35224 2004-07-12 00:00:00.000 Ammbo 33.0000 3T-SnG .0000 14 30 12 2048673 2004-07-12 00:00:00.000 Ammbo 33.0000 1T-SnG .0000 6 9 13 2048934 2004-07-12 00:00:00.000 Ammbo 22.0000 2T-SnG .0000 9 18 The point of my function was to create a report of a certain player stats. My goal was to first pull all the tournaments that a certai user has participated in. After I know all of these tournaments I nee to grab all members that played in each of these tournaments the calculate the stats on these tournaments. I also have an even bigger issue that I just gave up on as I could no figure it out. My goal was to calculate "owsies" on a per week basis Pretty much the function would have to pull all tournaments for th last week and figure out who owes what member what as well as cance out owes (ie: member 1 owes member 2 $20 and member 2 owes member 1 $1 then it should only report that member 1 owes $10 to member 2 for tha week.) Thanks for your help let me know if you need any more information. can do everything I want in Visual Basic, yet I love a challenge an want to get this working in a pure ASP script so I do not have to ru another back-end application just to handle my calculations - Kewl ----------------------------------------------------------------------- Posted via http://www.codecomments.co ----------------------------------------------------------------------- Tag: Can you go to this newsgroup via a web interface ? Tag: 297118
  - 11
    - Very very newbie ? Hi all, I am very very new to asp and am trying to get started fast. How do you develope asp pages: do you open a text document and start typing codes? Or is there a tool you use to develope asp pages. I would appreciate any tips, advise you can give me. Thank you, Tag: Can you go to this newsgroup via a web interface ? Tag: 297116
  - 12
    - Script Execution Time Is there an easy way to determine how long it took a particular page to execute? Tag: Can you go to this newsgroup via a web interface ? Tag: 297112
  - 13
    - Date Problem Hi I have one field in SQL Database datatype as datetime. When I am inserting or updating using asp on my machine its working fine but when I installed DB and application on other server and try to insert or update date using asp it giving error of date convertion. I know that its date format problem on one server it accept only "24/07/2004" format but on second server it accept as "07/24/2004" . As I don't know what will be date format on client server so this will be a problem. I am sure some of you have faced this problem and solved this, Please advise me how I can solve it what is the best way. Kind Regards Tag: Can you go to this newsgroup via a web interface ? Tag: 297101
  - 14
    - session quiz i have a site which uses session("xx") value.. in my site i take a variable and session("xx")=request("xx") im my url www.xx.com?xx=aaaaa it works... and i click another page in this url www.xx.com/d.asp the session variable is ok... but another page www.yy.com in a frame it opens my page to sending xx value... i take in my first page... but in www.yy.com i click my page and go to another page in frame(my page) the session variable is empty.. why? any idea.... Tag: Can you go to this newsgroup via a web interface ? Tag: 297097
  - 15
    - sorting columns with Access Is the CASE statement allowed when querying an Access database? Assuming so, what is the correct syntax? thanks SELECT OrderNo, Description, Type, Label FROM Stock WHERE Manuf = 'M' ORDER BY CASE 'C' WHEN 'orderno_asc' THEN OrderNo END ASC, CASE 'C' WHEN 'description_asc' THEN Description END ASC, CASE 'C' WHEN 'type_asc' THEN Type END ASC, CASE 'C' WHEN 'label_asc' THEN Label END ASC, CASE 'C' WHEN 'orderno_asc' THEN OrderNo END DESC, CASE 'C' WHEN 'description_asc' THEN Description END DESC, CASE 'C' WHEN 'type_asc' THEN Type END DESC, CASE 'C' WHEN 'label_asc' THEN Label END DESC Tag: Can you go to this newsgroup via a web interface ? Tag: 297096
  - 16
    - TOAD: Create a code statement mod This may be slightly off topic, but this is probably a better place to ask than an Oracle group as folk here are more likely to use the feature I'm asking about. In Toad (Quest Software) there is a button called 'Create a code statement' that turns SQL into something you can use in ASP for building SQL strings: For example if in Toad you highlight the following, and click the button: SELECT name, address_line1, address_line2, county, city, postcode FROM address_table WHERE city = 'Birmingham' It copies this into clipboard: SQL = " SELECT " SQL = SQL & " name," SQL = SQL & " address_line1," SQL = SQL & " address_line2," SQL = SQL & " county," SQL = SQL & " city," SQL = SQL & " postcode" SQL = SQL & " FROM " SQL = SQL & " address_table" SQL = SQL & " WHERE " SQL = SQL & " city = 'Birmingham'" This is a nice feature (and there is another button that does the reverse), but I like to build my SQL like this: Dim aSQL() Redim aSQL(8) aSQL(0) = "SELECT " aSQL(1) = " name, " aSQL(2) = " address_line1," aSQL(3) = " address_line2," aSQL(4) = " county," aSQL(5) = " city," aSQL(6) = " postcode" aSQL(7) = "FROM " aSQL(8) = " address_table" aSQL(9) = "WHERE " aSQL(10) = " city = 'Birmingham'" sql = Join(aSQL,"") Erase aSQL Anyone know if Toad can be modified to create the array above instead? I cant find any information about this anywhere. TIA, Colin Tag: Can you go to this newsgroup via a web interface ? Tag: 297095
  - 17
    - Field calcs with OnBlur I am trying to have an auto calculation happen on a form when 1 of 2 boxes get data keyed into them. I tried using ONBLUR with both textboxes, but I kept getting an invalid object. I use VBscript for my coding. <% response.write(<td class=""detaill""><input type=""text"" name=""txtRate_1"" size=""5"" onBlur=""CalcTotal"" ></td>") sub CalcTotal . . . end sub %> Any help would be appreciated. Thanks, George Tag: Can you go to this newsgroup via a web interface ? Tag: 297077
  - 18
    - Form Validation Hi, I have a form that is created dynamically from a recordset, this creates a line for each record together with 2 checkboxes, Yes & No so the source output would be something like this: <p>Please indicate whether you still use each piece of software detailed below:</p> <form name="apps" method="POST" action="MyAction.asp"> <table width="600" border="1" cellspacing="0" cellpadding="5"> <tr bgcolor="#9999FF"> <td><font color="#FFFFFF"><strong> Software</strong></font></td> <td><font color="#FFFFFF"><strong>Required?</strong></font></td> </tr> <tr> <td>Adobe Photoshop 7.0 7.0</td> <td><input type="checkbox" name="Yes" value="Adobe Photoshop 7.0 7.0"> Yes <input type="checkbox" name="No" value="Adobe Photoshop 7.0 7.0"> No </td> </tr> <tr> <td>Citrix ICA Client</td> <td><input type="checkbox" name="Yes" value="Citrix ICA Client"> Yes <input type="checkbox" name="No" value="Citrix ICA Client"> No </td> </tr> <tr> <td>Macromedia Dreamweaver MX 6.0</td> <td><input type="checkbox" name="Yes" value="Macromedia Dreamweaver MX 6.0"> Yes <input type="checkbox" name="No" value="Macromedia Dreamweaver MX 6.0"> No </td> </tr> </table> <p> <input type="submit" name="Submit" value="Submit"> </form> And so on...... I want to ensure that either Yes or No has been checked for each line before the form can be submitted, can this be done in asp? The amount of lines in the form will vary. Thanks. Tag: Can you go to this newsgroup via a web interface ? Tag: 297070
  - 19
    - Re: Cannot access server variables on client Hi All, I left a mistake in the last line of th script. Here's the revised version. Any ideas why it doesn't work (i.e. no fifth element and first swapped with second)? <html> <head> <script language="javascript" runat="server"> var thirdString = "Thirdly<br>"; var fifthString = "Fifthly<br>"; </script> </head> <body> Firstly <br> <script language="javascript" runat="server"> response.write("Secondly<br>"); </script> <%=thirdString%> <script language="javascript"> var clientFourthString = "Fourthly<br>"; document.write(clientFourthString); </script> <script language="javascript"> var clientFifthString = <%=fifthString%>; document.write(clientFifthString); </script> </body> </html> Tag: Can you go to this newsgroup via a web interface ? Tag: 297067
  - 20
    - Cannot access server variables on client Hi Folks, This page of asp should (I think) generate a page that reads: Firstly Secondly Thirdly Fourthly Fifthly But it doesn't: the first two lines are swapped and the fifth line is missing. How should I change it so that it worked? Thanks, Tim. PS Actually a fix for either problem would do. PPS Here's the ASP: <html> <head> <script language="javascript" runat="server"> var thirdString = "Thirdly<br>"; var fifthString = "Fifthly<br>"; </script> </head> <body> Firstly <br> <script language="javascript" runat="server"> response.write("Secondly<br>"); </script> <%=thirdString%> <script language="javascript"> var clientFourthString = "Fourthly<br>"; document.write(clientFourthString); </script> <script language="javascript"> var clientFifthString = <%=fifthString%>; document.write(clientString); </script> </body> </html> Tag: Can you go to this newsgroup via a web interface ? Tag: 297066
  - 21
    - Writing out array values Please help me with this I have an array which has days of the month stored in it. For example at one time it might have the values 1,2,3,6,7,8,9 at another time it might have the value 4,5,12,14,19,25 These are days of the month that have been selected and read into an array. What i would like to do is to write them out and put a "X" where the days were selected Somthing like this For i = 1 to 31 if i is found in the array response.write "X" else response.write "-" end if Next I cannot figure out how to search an array for the values for example the output of the first example should be 1 2 3 4 5 6 7 8 9 10 11 12 ...... X X X - - X X X X - - - Tag: Can you go to this newsgroup via a web interface ? Tag: 297057
  - 22
    - ASP Error Handling Dear all, this error handling has been a pain since so manya days using ASP 3.0 with IIS 5.0 on W2K server Created a custom error page using the Server.GetLastError() and works fine in most of the cases. Following are the issues : 1. Have a hughe file (5-6 mb approx) to upload, now if there are any errors during upload i want to immediately throw an error and roll back the transaction. 2. When the following error occurs, am not redirected to the custom error page bu the same is displayed on the same page. Error - Microsoft OLE DB Provider for SQL Server error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. is there a way to trap the above error using the Server.GetLastError on the custom error page Pls help... Thanks & Regards, Niraj *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Can you go to this newsgroup via a web interface ? Tag: 297056
  - 23
    - request instead of request.QueryString hi, I saw some program using "request("fieldname") " instead of "request.QueryString" to get the value from URL, what's the different ?? thanks Tag: Can you go to this newsgroup via a web interface ? Tag: 297055
  - 24
    - Issue with a variable form a database. Hello All. I am having issues with the visualbasic gramatic for the following scenario: I am retrieving information from an Access 2000 Database. The current fields are: ebay, which is a yes / no, showing as -1 or 0 ebay_path, which is a memo field with the ebay link to the product auctioned. within the HTML code, I have the following code: ---------------------------------------------------------------------------- --- <% if elbadet.Fields.Item("ebay").Value = -1 then <a href="<%=(elbadet.Fields.Item("ruta_ebay").Value)%>" target="_blank"><img src="images/content/ebay_auctions.gif" width="296" height="43" border="0"> else <img src="images/content/ebay_auctions_inactive.gif" width="296" height="43" border="0"> end if %> ---------------------------------------------------------------------------- --- where elbadet is the name of the recordset ebay is the field having the value ruta_ebay is the other field with the path Once previewed :is giving me the following error HTTP 500.100 - Internal Server Error - ASP error Internet Information Services ---------------------------------------------------------------------------- ---- Technical Information (for support personnel) a.. Error Type: Microsoft VBScript compilation (0x800A0400) Expected statement /lacany/TMP6hxrg14ri3.asp, line 62 <a href="<%=(elbadet.Fields.Item("ruta_ebay").Value) b.. Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) c.. Page: GET /lacany/TMP6hxrg14ri3.asp d.. Time: Monday, July 19, 2004, 11:10:52 PM e.. More information: Microsoft Support -------------------------------------------------------------------------- In plain english I need the statement to behave something like this (pseudocode) If the specified filed = -1 then show the active gif image and the link else show the inactive gif image end if statent Thanks in advance; any help is highly appreciated. Juan Pablo Rojas merca-web.com Tag: Can you go to this newsgroup via a web interface ? Tag: 297051
  - 25
    - Calculation not working Hello, I am having a problem getting some code to calculate/work in an ASP page. In the snippet below I am collecting some data (inthours1 and intrate1) and then want to calculate a value (intsub1) to display on the page. If I set intsub1 to a fixed value, the page displays correctly. If I try the calculation listed below, I get a 500 internal server error on the page. What am I doing wrong??? Thanks, Joe <% Dim strSDate1, strEng1, intHours1, intRate1, intSub1 intHours1 = Trim(Request.Form("shours1")) intRate1 = Trim(Request.Form("srate1")) ' Sub total buckets intSub1 = inthours1 * intrate1 %> <td><INPUT TYPE=TEXT NAME="SHours1" VALUE="" SIZE=10 MAXLENGTH=10></td> <td><INPUT TYPE=TEXT NAME="SRate1" VALUE="" SIZE=12 MAXLENGTH=12></td> <td><%= intSub1 %> </td> Tag: Can you go to this newsgroup via a web interface ? Tag: 297048
- Next
  - 1
    - Recommend an ASP-based RSS Reader? Can anyone recommend a good, reliable server-side RSS reader that is VBScript based? Tag: Can you go to this newsgroup via a web interface ? Tag: 297046
  - 2
    - checking record older than 2 years not working? Good day to you all I'm trying to see all the records in the database older than 2 years from today, and I can't seem to be getting it to go. SELECT * FROM comments WHERE (currentdate < 2002 - 07 - 20) ORDER BY currentdate I get null records returned, even though I can see some records as old as 1995. When I run the command like this however, it returns all the rows. SELECT * FROM comments WHERE (currentdate > 2002 - 07 - 20) ORDER BY currentdate any suggestions? -- Kind Regards Rudi Ahlers +27 (82) 926 1689 Greater love has no one than this, that he lay down his life for his friends (John 15:13). Tag: Can you go to this newsgroup via a web interface ? Tag: 297042
  - 3
    - code behind file not being refresh we're running IIS 5 and trying to do a simple update to a code behind file (Login.aspx.vb) we copy the file over to the server, but we're not seeing the updates. the server is still reporting errors on line numbers in the file that no longer exist. we've even stopped / restarted the service, with no luck. Tag: Can you go to this newsgroup via a web interface ? Tag: 297041
  - 4
    - Problem with this code.... Hey Guys, My server decided to all of a sudden stop giving me compile/scrip errors and instead now just gives me a blank page with no informatio as to what the problem might be. I have looked over the below cod quite a few times and just for the life of me can not figure out wha could be wrong maybe a fresh set of eyes could help me. Thanks i advance! (sorry for the sloppy code as well) Set adoCon = Server.CreateObject("ADODB.Connection") 'Set the connection string to the database adoCon.connectionstring = strCon 'Set an active connection to the Connection object adoCon.Open SQLString = "Select * from TblTournaments where Member = '" request("member") & "'" Set adoRec = Server.CreateObject("ADODB.Recordset") adoRec.open SQLString, adoCon, 3, 3 if adoRec.EOF = true then RHTML = "This report did not generate any data." end if if adoRec.EOF = false then adoRec.movefirst xyz = 0 do until adoRec.EOF = true tmpTournament(xyz) = adoRec("TNUM") xyz = xyz + 1 adoRec.movenext loop adoRec.close for x = lbound(tmpTournament) to ubound(tmpTournament) SQLString = "Select * from tblTournaments where TNUM = " tmpTournament(x) adoRec.open SQLString, adoCon, 3, 3 for y = 1 to adoRec.recordcount if adoRec("Member") = request.form("member") then Total_Buyin = Total_Buyin + adoRec("buyin") Tournaments_Played = Tournaments_Played + 1 if adoRec("won") > 0 then Gross_Money_Won = Gross_Money_Won + adoRec("won") Net_Money_Won = Net_Money_Won + (adoRec("won") adoRec.recordcount) Money_Paid = Money_Paid + (adoRec("won") Net_Money_Won) end if else if adoRec("won") > 0 then Gross_Money_Collected = Gross_Money_Collected (adoRec("won") / adoRec.recordcount) end if end if next adoRec.close Total_Tournaments = Total_Tournaments + 1 next Total_Net_Collected = (Net_Money_Won + Gross_Money_Collected - Total_Buyin Solo_Collected = Gross_Money_Won - Total_Buyin RHTML = RHTML & "You have played in a total of " Tournaments_Played & " tournaments.<br>" RHTML = RHTML & "You have spent a total of $" & Total_Buyin " in entry fees.<br>" RHTML = RHTML & "You have generated a Gross amount of $" Gross_Money_Won & " from your wins.<br>" RHTML = RHTML & "You have paid out a total of $" & Money_Pai & " to other members.<br>" RHTML = RHTML & "You have generated a net amount of $" Net_Money_Won & " after paying all members.<br>" RHTML = RHTML & "You have collected $" & Gross_Money_Collecte & " from other members.<br>" RHTML = RHTML & "You have made a net amount $" Total_Net_Collected & ".<br>" RHTML = RHTML & "Flying solo you would have made $" Solo_Collected & " compared to $" & Total_Net_Collected & " being o the team." & ".<br>" response.write RHTML end i - Kewl ----------------------------------------------------------------------- Posted via http://www.codecomments.co ----------------------------------------------------------------------- Tag: Can you go to this newsgroup via a web interface ? Tag: 297034
  - 5
    - Update Application value on multiple servers? Can I update Application("SomeVariableName") on server A in response to user's action on server B? There is no problem in updating the same variable on server B, of course, but we would like both variables to be in sync since users can view the value stored on arbitrary server. So far I have tried server.execute and server.transer to execute script updating Application("SomeVariableName") value on server A in response to user's action on server B but these methods didn't work - documentation conformed it. Is there another, perhaps some creative way of doing it? Tag: Can you go to this newsgroup via a web interface ? Tag: 297024
  - 6
    - msgbox im trying to use the MsgBox function in the following to display an ASP MsgBox containing text retrieved from the db into a recordset <% set rsMessages= myRecordset msg_text = rsMessages.Fields("msg_text") msgbox(msg_text) %> this generates a permission denied error b/c msgbox needs to run client side so i tried the same code but used <SCRIPT LANGUAGE="VBSCRIPT"> </SCRIPT> in place of the <% %> tags but now i just get an empty message box i must be misunderstanding something with the way the msgbox function works in terms of client side vs server side. any help would be much appreciated jt Tag: Can you go to this newsgroup via a web interface ? Tag: 297019
  - 7
    - writing text to an image with asp is there any component to make it.. i want to make user registiration page.. in this page i want to place a image which has a text and a user must be type this text to a text box and after that i will check the textbox value and image text value.. how can i make it.. do i need a component. if there is a component what is its name .. and i need a free one... Tag: Can you go to this newsgroup via a web interface ? Tag: 297016
  - 8
    - need remote_user servervariable Hi, I have an intranet application running on windows 2000 server with IIS 5.0, but there is no domain. The users use workstation windows 2000 and log on locally. I need the logon of the users of our LAN in the application, so i did: lo=request.servervariables("remote_user"), but it's empty. I tried all of them with this: <% for each a in request.servervariables %> <p> <% = a %> <% response.write(" ") %> <% response.write(request.servervariables(a)) %> <p> <%next%> and i saw that 'logon_user' also was empty. Must there be a domain defined and must the users logs on that domain in order to use 'remote_user' or 'logon_user'? Thanks again Cas Tag: Can you go to this newsgroup via a web interface ? Tag: 297015
  - 9
    - RSS update problem. Hi All, I was able to generate an RSS for the news I provide with ASP and MS SQL backend. When I opens it its working fine with any RSS reader, But its not getting updated, when I update the feed. Its showing the one which I made the day one, How to rectify and what could be the problem. Any help is appriciated. Regards, Benny Tag: Can you go to this newsgroup via a web interface ? Tag: 296999
  - 10
    - problem with sending emails with CDO Hi, I run IIS 5.0 on windows 2000 server sp4. This server is connected to the ISP with adsl modem. I put ASP code (found on internet) in order to send emails with CDO: (see below) When running that page, i get the error: "HTTP 500 - Internal server error Internet Explorer" No idea why. I wonder whether the first 4 lines must be between comments. Another point: do i need to install SMTP service of my IIS server, or (what i think) can i use the SMTP service of my ISP? Thanks Cas  <% Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(cdoSendUsingMethod) = cdoSendUsingPort .Item(cdoSMTPServer) = "smtp_ of_ my_ ISP" .Update End With Set cdoMessage = CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = "fromme@eretr.be" .To = "toyou@dfghdfg.be" .Subject = "test with CDO" .TextBody = "it works" .Send End With Set cdoMessage = Nothing Set cdoConfig = Nothing %> Tag: Can you go to this newsgroup via a web interface ? Tag: 296998
  - 11
    - asp chat how can i do a chat page with asp .. does anyone have example codes or url.. or with java.. please help me... Tag: Can you go to this newsgroup via a web interface ? Tag: 296997
  - 12
    - upload file component Hi All, Do you know where have free/buy a upload file component? I need allow user to select the folder instead of select file one by one thanks~~ Tag: Can you go to this newsgroup via a web interface ? Tag: 296995
  - 13
    - writing to file Hi I'm reading one html file and writing in another problem. while cnt <= ubound(lines) myFile.WriteLine "body = body & """&lines(cnt)&"""" cnt = cnt + 1 wend Using this code when I see new file it puts one character (look like small rectangle) before " how would i get rid of this character??? If i run this code...it works fine while cnt <= ubound(lines) myFile.WriteLine "body = body & """&lines(cnt) cnt = cnt + 1 wend how would i append " at end of each line without having special character..i tried to copy and paste to hear but i am unable to paste...may be its carriage return or line feed... thanx dave Tag: Can you go to this newsgroup via a web interface ? Tag: 296994
  - 14
    - IIS process only .ASPX files Hi I have installed IIS on WINDOWS 2003 server. IIS is working only if I type filename.aspx for .asp or any other file its giving "HTTP Error 404 - File or directory not found. " Please advise what I am doing wrong. Regards Tag: Can you go to this newsgroup via a web interface ? Tag: 296989
  - 15
    - Redefined variable Hi everybody, In an ASP page, I need to load twice an include file that contains variables. So I get an error message "variable redefine" I tried to test with VarType before to define the variable (dim) with no success. Is it faisable with VBScript to define a variable (dim) under condition. ' this code gives an error if VarType("MyVar") = vbNull then dim MyVar end if many thank's serge Tag: Can you go to this newsgroup via a web interface ? Tag: 296977
  - 16
    - Adding rows to database table thro ASP Hi, I want to add a row to library table. Table has total 7 fields. But I want to create the new row with 5 field data. When I run the following query in MS Access strQ = "INSERT into library (index,title,author,itemtype,createdate) VALUES ('B-096','Hihihihihi','hello','Book','07/18/04')" It successfully adds the row. But same thing I am trying with the following ASP code. It gives error, saying syntax error in INSERT into statement. Can anybody suggest me, what is wrong in my code below. Any help is appreciated. Thanks in advance, Vasanth ----------------------------- <% option explicit Response.ExpiresAbsolute = "January 1, 2003" Dim path, mdbFilePath, sPos, objConnect, objRst, strQ, x for each x in Request.Form execute x & "="""&Request(x)&"""" next path = Request.ServerVariables("PATH_TRANSLATED") sPos = InStr(path, "library\newupdate.asp") if sPos = 0 then sPos = InStr(path, "library/newupdate.asp") end if mdbFilePath = Left(path, sPos-1) & "library.mdb" Set objConnect = Server.CreateObject("ADODB.Connection") objConnect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mdbFilePath & ";" Set objRst = Server.CreateObject("ADODB.Recordset") Set objRst.ActiveConnection = objConnect 'strQ = "INSERT into library (index,title,author,itemtype,createdate) VALUES ('"&session("index")&"','"&title&"','"&author&"','"&session("itemtype")&"',' "&date&"')" strQ = "INSERT into library (index,title,author,itemtype,createdate) VALUES ('B-096','Hihihihihi','hello','Book','07/18/04')" objRst.Open strQ Set objRst = nothing objConnect.Close Set objConnect = nothing %> <html> <head> <title> </title> </head> <body> Library Item, <%=session("index")%> has been created on <%=date%>. </body> </html> Tag: Can you go to this newsgroup via a web interface ? Tag: 296973
  - 17
    - Setting message priority with CDOSYS Hello. Can someone please tell me how to set the priority of an email message sent from an ASP script using CDOSYS as below - set oCdoMsg = server.createobject("CDO.Message") oCdoMsg.from=... oCdoMsg.to=... oCdoMsg.subject=... oCdoMsg.importance=1 ' fails oCdoMsg.HTMLBody=.... oCdoMsg.send With CDONTS I successfully used .importance but that fails with CDOSYS. I have searched the MSDN documentation but can't find it. BTW I find the various alternatives confusing - CDO, CDONTS, CDOEX etc. Thanks in advance for any help. Peter Croft Tag: Can you go to this newsgroup via a web interface ? Tag: 296972
  - 18
    - [NEWBIE] Viewing ASP files (.ASP extension) Dear group, I have never done any ASP coding before (Just HTML and Javascript as far as web pages go - and got on fine) I would like to start writing some ASP scripts, but I am having difficulties viewing '*.asp' files on my PC, when I open them only the HTML aspects of the code displays or I just get a blank browser window.. I am running XP, is there something special that I need to install? Please forgive me for asking what probably sounds like a stupid question, but as you have probably gathered I haven't got a clue!!! :o) Thanks, Cassandra I am trying to create a simple "Tell A Friend" page. The code I have is as follows: **************************************************************************** ********************************************** (File: Functions.asp) <% function mail(mMessage, mFrom, mTo, mSubject) Dim objMail Set objMail = Server.CreateObject("CDONTS.NewMail") objMail.From = mFrom objMail.Subject = mSubject objMail.To = mTo objMail.Body = mMessage objMail.Send set objMail = nothing end function function tellFriend(pageName) if Request.QueryString("mailsent") = "true" Then Response.Write "<P><strong>Your recommendation has been sent.</strong></P>" end if Response.Write "<P>To tell a friend about this page, complete your friend's name and email address and write your name and email address below.<P>" &vbCrLf Response.Write "form method = ""post"" action = ""tellafriend_script.asp""> &vbCrLf Response.Write "<p>Your name:<br />" &vbCrLf Response.Write "<input type=""text"" name=""senderName"" id=""senderName"" /></P>" &vbCrLf Response.Write "<P>Your Email Address:<br />" &vbCrLf Response.Write "<input type=""text"" name=""senderEmail"" id=""senderEmail"" /></P>" &vbCrLf Response.Write "<p>Your friend's name:<br />" &vbCrLf Response.Write "<input type=""text"" name=""friendName"" id=""friendName"" /></P>" &vbCrLf Response.Write "<P>Your Friend's Email Address:<br />" &vbCrLf Response.Write "<input type=""text"" name=""friendEmail"" id=""friendEmail"" /></P>" &vbCrLf Response.Write "<input type =""hidden"" name=""pageName"" value=""" & pageName & """ />" &vbCrLf Response.Write "<input type =""submit"" value=""send!"" class=""submit""> </P>" &vbCrLf Response.Write "</form>" &vbCrLf end function %> **************************************************************************** ********************************************* (File: tellafriend_script.asp) <%@LANGUAGE = "vbscript"%> <%Option Explicit%> <!-#includefile=function.asp"-> <% Dim senderName, senderEmail, friendName, friendEmail, pageName Dim mailSubject, mailMessage, sendmail senderName = Trim(Request.Form("senderName")) senderEmail = Trim(Request.Form("senderEmail")) friendName = Trim(Request.Form("friendName")) friendEmail = Trim(Request.Form("friendEmail")) pageName = Trim(Request.Form("pageName")) mailSubject = senderName & " has recommended this web page to you" mailMessage = "Dear " & friendName & "," &vbCrLf &vbCrLf mailMessage = mailMessage & "your friend " & senderName & " has recommended that you visit the following page." &vbCrLf &vbCrLf mailMessage = mailMessage & "http://www.yourdomain.com/" & pageName &vbCrLf &vbCrLf mailMessage = mailMessage & "We have not stored your details." sendmail = mail(mailMessage, senderEmail, friendEmail, mailSubject) Response.Redirect(pageName & "?mailsent=true") %> **************************************************************************** ********************************************** (File: Tellafriend.html) <%@LANGUAGE = "vbscript"%> <%Option Explicit%> <!-#includefile=function.asp"-> <%Dim display%> <html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Tell a friend</title> </head> <body> <% display = tellFriend("tellafriend.asp")%> </body> </html> Tag: Can you go to this newsgroup via a web interface ? Tag: 296968
  - 19
    - Displaying Img from Access using BinaryWrite Hi, Becoming quite frustrated with this. I have a commercial database written in access and I'm trying to display some images, jpegs, stored in the DB on web page. My code is as follows: Response.ContentType = "image/jpeg" sql = "SELECT PartImage FROM Parts WHERE ShortID='AAPTM01'" Set rs = AMConn.execute(sql) If not rs.eof Then PicSize = rs("PartImage").ActualSize if PicSize > 0 then Response.BinaryWrite rs("PartImage").GetChunk(rs("PartImage").ActualSize) end if End If set rs = nothing All i get on the page is the image not found icon with the red cross in IE. What could possibly be going on? Any suggestions would be appreciated. Tag: Can you go to this newsgroup via a web interface ? Tag: 296967
  - 20
    - ASP and WebBots Can anyone enlighten me as to the spambot email harvesting process? I use to use javascript to protect my email address, but with security levels rising, I can't rely on everyone to have javascript enabled. I am currently using an encoding tool (UltimateMailto) that turns the email address into a combination of hex and dec code. I wondered if drawing the email from a database with asp is safe. Does an email harvesting bot read the .asp code or the page created by the .asp code? Any help and enlightenment would be appreciated. I HATE SPAM!!! Tag: Can you go to this newsgroup via a web interface ? Tag: 296959
  - 21
    - Distance betweeen 2 zip codes anyone knows what the formula is for finding a distance betweeen 2 zip codes? Aaron Tag: Can you go to this newsgroup via a web interface ? Tag: 296958
  - 22
    - Client printing format Hello, I have an ASP form to collect some data and then have the client print it out through their browser. I was wondering if there was any way to control and/or eliminate (from the server side) the additional text that gets printed on the page, such as: "page 1 of x" at the top of the page; The date at the bottom of the page; and the form name and path at the bottom of the page. Thanks, Joe Tag: Can you go to this newsgroup via a web interface ? Tag: 296951
  - 23
    - Form Submit quiz <form action="a.asp" method="get" > <input type="image" border="0" src="IMAGES/oklar.jpg"> </form> im usnig this codes to submit form when a user click on oklar.jpg(an image) .. but it submits form ***a.asp?x=6&y=8*** like this.. x and y takes randomize values... how can i remove x and y variables from my string... if it cant be possible how can submit a form when a user click my image file... Tag: Can you go to this newsgroup via a web interface ? Tag: 296947
  - 24
    - DSNLess troubles I'm trying to setup an Access DSNLess connection on my local computer. The following string works fine within the Dreamweaver interface. But when I upload to my server (locally) I get this error. Can anyone lend some insight? thanks Object required: 'oConn' /Connections/conn.asp, line 2 <% oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ "Dbq=c:\inetpub\wwwroot\authors.mdb;" & _ "Uid=admin;" & _ "Pwd=" %> Tag: Can you go to this newsgroup via a web interface ? Tag: 296939
  - 25
    - simple question on vbScript SET statement Simply: On one .asp page I have: Set Session("mydictionary") = [dictionary object] Now the session variable has the dictionary object in it, then on another page ... Set x = Session("mydictionary") ... and I use the "x" variable with the properties of that object, etc. Question: Is "Set x = nothing" needed before the .asp page ends processing or redirects? From what I know the "x" variable is just a reference and does not need to be set to "nothing"... correct? Tag: Can you go to this newsgroup via a web interface ? Tag: 296938

Can you go to this newsgroup via a web interface ? If yes, what is the URL
address for that ? Thanks.
For example, you can access Outlook newsgroup on the web at
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba

Top

Re: Can you go to this newsgroup via a web interface ? by Torgeir

Torgeir
Wed Jul 21 13:54:10 CDT 2004

Fie Fie Niles wrote:

> Can you go to this newsgroup via a web interface ? If yes, what is the URL
> address for that ? Thanks.
> For example, you can access Outlook newsgroup on the web at
> http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba
Hi

http://communities.microsoft.com/Newsgroups/default.asp?ICP=MSCOM&sLCID=US&newsgroup=microsoft.public.inetserver.asp.general

--
torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway
Administration scripting examples and an ONLINE version of
the 1328 page Scripting Guide:
http://www.microsoft.com/technet/scriptcenter/default.mspx

Top

Re: Can you go to this newsgroup via a web interface ? by Fie

Fie
Wed Jul 21 14:31:58 CDT 2004

Thank you.

"Torgeir Bakken (MVP)" <Torgeir.Bakken-spam@hydro.com> wrote in message
news:%23ljUmR1bEHA.2816@TK2MSFTNGP11.phx.gbl...
> Fie Fie Niles wrote:
>
> > Can you go to this newsgroup via a web interface ? If yes, what is the
URL
> > address for that ? Thanks.
> > For example, you can access Outlook newsgroup on the web at
> >
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba
> Hi
>
>
http://communities.microsoft.com/Newsgroups/default.asp?ICP=MSCOM&sLCID=US&newsgroup=microsoft.public.inetserver.asp.general
>
>
> --
> torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway
> Administration scripting examples and an ONLINE version of
> the 1328 page Scripting Guide:
> http://www.microsoft.com/technet/scriptcenter/default.mspx

Top