RSS update problem.

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
    - 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: RSS update problem. Tag: 296998
  - 2
    - 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: RSS update problem. Tag: 296997
  - 3
    - 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: RSS update problem. Tag: 296995
  - 4
    - 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: RSS update problem. Tag: 296994
  - 5
    - 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: RSS update problem. Tag: 296989
  - 6
    - 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: RSS update problem. Tag: 296977
  - 7
    - 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: RSS update problem. Tag: 296973
  - 8
    - 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: RSS update problem. Tag: 296972
  - 9
    - [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: RSS update problem. Tag: 296968
  - 10
    - 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: RSS update problem. Tag: 296967
  - 11
    - 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: RSS update problem. Tag: 296959
  - 12
    - Distance betweeen 2 zip codes anyone knows what the formula is for finding a distance betweeen 2 zip codes? Aaron Tag: RSS update problem. Tag: 296958
  - 13
    - 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: RSS update problem. Tag: 296951
  - 14
    - 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: RSS update problem. Tag: 296947
  - 15
    - 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: RSS update problem. Tag: 296939
  - 16
    - 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: RSS update problem. Tag: 296938
  - 17
    - Types in ASP, is it possible? Hey everyone, I am writing a basic tournament submit site for a poker tournamen group I am in. The situation is we want to use code to calculate wha we owe other members at the end of the week. The way I figured to d this is read from the database and store tournament numbers in an arra then run a query for each tournament and cycle through the tournamen data assigning the information where needed. I can not find if you ca or how you can use a Typedef in ASP. Pretty much I want to create type then make an array of that type. ie: Type typTournamentInformation dim Number dim Member dim XYZ dim ETC End Type dim TInfo() as typTournamentInformation then I can assign what I read from the database to tinfo(x).XXX Is this possible in ASP - Kewl ----------------------------------------------------------------------- Posted via http://www.codecomments.co ----------------------------------------------------------------------- Tag: RSS update problem. Tag: 296936
  - 18
    - page expired problem Hello All I have a web pagewhich queries a db and displays information on the subsequent page. On the subsequent page if I click back to previous page (this is a button with javascript code on it), it takes me to the previous page but the page says - "warning page expired". When I am in my company work environment, I dont get this page, it properly displays the information on the previous page but when I go to the client site, it gives me the problem All of us are on the same IE version and service packs. Could this be a programming issue or a security issue. Please advise Thank you Tag: RSS update problem. Tag: 296933
  - 19
    - Enter key behavior Hi, When the cursor is in an INPUT TEXT control and the Enter key is hit, what it's happen. I mean what is the chain of actions starting from that point. I have an ASP application that save modifications (qty chang in an input text) when the user navigate from page to page. For doing so I check if the value of the TEXT control differ from the value in the table. If so, I insert or update the table. But, when I hit Enter it is exactly the same as if I moved to another page. I would like to know exactly what's happen, in order to take advantage of this behavior. thank's serge Tag: RSS update problem. Tag: 296928
  - 20
    - action cancelled error i am using iis 6.0 ,application pool and com+ .previous version iis 5.0 one of asp page work correctly it takes about 3 minutes.but now i get error as "action cancelled" and no error number displayed,i set commandtimeout parameter 500 in asp page and increase iis asp scripttimeout like 500 also change com+ enable idle shutdown parameters as 30.but this page give same error, how can i solve this problem Tag: RSS update problem. Tag: 296917
  - 21
    - Generating navigation Hi guys, I'm using the Webedit Pro CMS for a client. When the user creates a new page, rather than go through every other page in the site and add a new link to the left hand navigation I want to use an include file and search the folder for all .asp and .htm files and display them in the navi as a link. If that makes sense? I've been playing around with FileSystemObject, but am struggling to get the desired results. Rather than display the full name of the file in the navi, I want to remove the file extension and the path, and maybe convert the leading letter to a capital so it looks like a regular nav. If anyone has done this before, or can point me to something that would help then I would appreciate it! regards, Tom Tag: RSS update problem. Tag: 296916
  - 22
    - Will these objects be closed and destroyed? In the code below I have a Response.End in the middle of a Do loop that is run if the condition in a nested 'If...' statement is not met. Will the rs and conn objects be closed and destroyed if the Response.End is called or will they be left open? connStr = "PROVIDER=OraOLEDB.Oracle; DATA SOURCE=xyz; etc..." Set conn = Server.CreateObject("ADODB.Connection") conn.Open connStr rs = Set Conn.Execute("Select A,B,C from TblTableName Where Blah = 'Blah'") Do While Not rs.eof If rs("A") = "Tra la la" Then 'Do something Else Response.Write("Some message") Response.End End If Loop 'Do other stuff... rs.Close Set rs = nothing conn.Close Set conn = nothing Tag: RSS update problem. Tag: 296912
  - 23
    - Previous return values from a BE method are shown when refreshing an ASP calling that method My ASP always calls a DLL that was constructed using VFP Code. If needed, this DLL can call a VFP External Class Method that is outside the DLL for some process. The DLL is bound with COM always. I have this External Class setup because, If a quick fix is needed, I can manage this with just sending modified External Class Library instead of the DLL. But the problem arrives this way. - Call ASP to receive old value X from existing External Class Method - this works fine - Call ASP to receive new value Y from modified External Class Method - this does not work - Shutdown COM object that cotains DLL and then, - Call ASP to receive new value Y from modified External Class Method - this works fine My only idea to have External Class Library is not to disturb existing COM setup (shutdown etc) for any quick fix. Does anybody have a clue whether can I achieve this without disturbing COM? - Shekhar Tag: RSS update problem. Tag: 296911
  - 24
    - Get Bad Data from a Recordset Call Here's the code: ------------------------------------------------------------------- accessID = request("accessID") strSQL = "SELECT * From PendingAccRequests Where AccessID = "&accessID 'Create the Recordset object and run SQL statement Set accRS = Server.CreateObject ("ADODB.Recordset") accRS.Open strSQL, objConn If request("confirm") = "yes" then strSQL = "Select * From AccessMaster Where RequestID = "&accessID 'Create the Recordset object and run SQL statement Set masterRS = Server.CreateObject ("ADODB.Recordset") masterRS.CursorLocation = adUseClient masterRS.Open strSQL, objConn,, adLockOptimistic masterRS.AddNew masterRS("PropownID") = accRS("Bld_Owner_ID") masterRS("FileName") = accRS("PROPOWN_Name") masterRS("Multiagreement") = False masterRS("OpenDate") = Date() masterRS("requestID") = accessID masterRS.Update strSQL = "Select * From Access Where MasterID = "&masterRS("MasterID") 'Create the Recordset object and run SQL statement Set newRS = Server.CreateObject ("ADODB.Recordset") newRS.CursorLocation = adUseClient newRS.Open strSQL, objConn,, adLockOptimistic newRS.AddNew newRS("Prop_Owner_ID") = accRS("Bld_Owner_ID") newRS("Acct_Mgr") = accRS("Assigned") newRS("Status") = "OPEN" newRS("Source_Date") = accRS("AccessDate") If Not IsNull(accRS("ProjID")) then newRS("Source_Info") = "SALES REQUEST" Else newRS("Source_Info") = "CONSTRUCTION" End If newRS("File_Received") = Date() newRS("MasterID") = masterRS("MasterID") newRS.Update If Not IsNull(accRS("ProjID")) then strSQL = "Insert Into AccessBldg (AccessID, BidID) "&_ "Select "&newRS("AccessID")&", BID_ID from ConstructionBldg Where ProjectID = "&accRS("ProjID")) objConn.Execute(strSQL) strSQL = "Update Building Set Bld_Access_ID = "&masterRS("MasterID")&" Where Bld_Address_ID in "&_ "(Select Bid_ID From ConstructionBldg Where ProjectID = "&accRS("ProjID")) &")" objConn.Execute(strSQL) Else strSQL = "Select * From AccessBldg Where AccessID = "&accIDRS("AccessID") 'Create the Recordset object and run SQL statement Set accBldRS = Server.CreateObject ("ADODB.Recordset") accBldRS.CursorLocation = adUseClient accBldRS.Open strSQL, objConn,, adLockOptimistic accBldRS.AddNew accBldRS("AccessID") = accIDRS("AccessID") accBldRS("BidID") = accRS("BidID") accBldRS("suite") = accRS("Suite") accBldRS.Update strSQL = "Select * From Building Where Bld_Address_ID = "&accRS("BidID") 'Create the Recordset object and run SQL statement Set bldRS = Server.CreateObject ("ADODB.Recordset") bldRS.CursorLocation = adUseClient bldRS.Open strSQL, objConn,, adLockOptimistic bldRS("Bld_Access_ID") = masterRS("MasterID") bldRS.Update End If strSQL = "Update AccessRequest Set Completed = 1 Where AccessID = "&AccessID objConn.Execute(strSQL) Response.Redirect("handler.asp?id="&newRS("AccessID") ) End If --------------------------------------------------------------- Now you'll notice I'm updating and pulling from multiple recordsets. Here's the problem. PendingAccRequests is a View, and when I run the SQL query (Where AccessID = "&accessID), I get good data. So I plug it into accRS. Now in that row there is a column called projID... it has the number 477 in it. But Anytime I try and call that field (accRS("ProjID")) I get nothing. It Will Not return my 477. This is the problem Just FYI. When I call newRS("AccessID") which is the ident key of the record I'm adding, I also get nothing. When I call accRS("Assigned") which is filled with the number 47, I get nothing. When I call masterRS("MasterID") which is another ident field of a recordset I'm adding. I get the wrong number. I do not know where the number is coming from. Can anyone tell me what could be wrong??? Thanks Tag: RSS update problem. Tag: 296906
  - 25
    - website on a CD I want to create a dynamic website hosted on a CD. It would be based on ASP and have a database. Is this possible? How would I approach such a thing? I'm sure I could by a runtime version of Access and build an application, but could that be implemented within the website? Any thoughts? I don't want the user to install anything on their hardrive if possible. thanks! Tag: RSS update problem. Tag: 296904
- Next
  - 1
    - formatting string Hi Guys I have one string variable and value stores something like this st = "From: ""John Thomas"" <john@test.com.au>" when i test it display some thing like From: "John Thomas" <john@test.com.au> How can I pick up only display name and without double quotes. i.e. it should display only John Thomas Thanx for helping dave Tag: RSS update problem. Tag: 296903
  - 2
    - Multi-column combo box, change width on select Has anybody ever seen or written code for ASP that would mimic Access' multi-column combo box? Specifically, I have a drop down box that lists about 100 five-digit codes. Each of these codes has a long text description that explains what the code represents. I'd like to be able to show the code plus description when the drop down list is dropped down, but just the code when the list is not displayed, so that I don't have to have a hugely long combo box taking up space. So, for instance, if I had a drop down list of airports and I'd selected SeaTac, I'd just see SeaTac in the drop down box text area, but if I were to click on the arrow and drop down the list, I'd see: SeaTac Seattle-Tacoma International Airport MCI Kansas City, MO International Airport etc... I know you can change the width of the combo box through javascript, but that screws up the rest of the fields to the right. Plus, whenever I change the width on the onclick event, it hides the list and I have to click again. Is there anyway to just change the width of the list area? TIA, Diane Tag: RSS update problem. Tag: 296896
  - 3
    - Hidden value Hello I seem to be having a problem with saving hidden values. I am trying to use the hidden values to post infomation back to the same page and also to a different second page. I would like to persit the values to a couple of more pages in this process. I have ten different values that I am trying to save. The problem is I dont see these Request objects on the second page. I have another .asp page that is included and processed on this second page (). Do I need to pass the request items to this include file and to the real page? I must be doing something wrong however I am not quite sure what I must me doing wrong. This a snippet from the original page. <tr> <td width="33%" align="right">Region: </td> <td align=left width="66%"> <input type="text" name="txtRegion" id="txtRegion" value=<%= strRegion %> ></td> </tr> <Input Type="hidden" Name="VendorRegion" Value ='"<%=Request.form("txtRegion")%>">' ....... </form> </BODY> </HTML> This a snippet from the second page. I am trying to grab the value here so that I can use this value on the page. strRegion = trim(Request.form("VendorRegion").item) ...... <HTML> <HEAD> <TITLE> Thanks for any insight! Tag: RSS update problem. Tag: 296895
  - 4
    - Displaying recordsets I'm trying to display different recordsets (which are 1 field each) as columns right next to one another. For example, Recordset1 is displayed on the left hand side of the screen. Recordset2 is displayed immediately to the right of then first recordset with the first rows or each at the same level. Recordset3 is displayed to the right of Recordset2 and so on. There is no set limit to the number of possible recordsets (or columns to display). Imagine a spreadsheet where each column is a different recordset. How can I display that using ASP? Tag: RSS update problem. Tag: 296893
  - 5
    - submit() QueryString data Hi, Is there a way to append the QueryString data when using <Script>document.FrmName.submit()</Script> Thank's in advance serge Tag: RSS update problem. Tag: 296885
  - 6
    - URL Rewrite Routine Hello -- I have a page that I call with a few URL parameters... For example: Parm1=a, Param2=b, Param3=c, Param4=d The ASP script can accept any number of parameters or none. Since I'm adding paging to the page via ADO RecordSet and having page navigation at the bottom, I'm creating a "Previous" and "Next" link which includes a parameter called "PageNum=" with the correct page #. The problem is... I need to append the PageNum parameter to the existing URL. And if the PageNum parameter is already on the URL, then I need to remove it and replace its value for the correct page. I assume I can loop thru the QueryString collection and compare name with value? Any sample code or help in accomplishing what I'm requesting would be appreciated. Tag: RSS update problem. Tag: 296879
  - 7
    - Script to edit PSD files Hi Is there any way to edit a PSD file trough ASP ? For example if I make a templimate with photoshop with a textfield then i want to change the textfields value trough the script and then render the new file as an image. Ive seen alot of components that can render PSD files but none that can edit them. Is it possible ? /Gustaf Tag: RSS update problem. Tag: 296878
  - 8
    - download file with [1] at the end of the file name Hi, I've the code bellow who give me a file to download. The files are sored in a folder. The filename is the id of the data stored in a table. The name of the file at the download time will be the one stored in the table. The problem is that if the file name in the table is toto.doc the browser propose me to save it at toto.doc[1] How can I get rid of the [1] The file can be of any tipe.  <% dim fileId dim fileName dim path dim sql dim rs dim objFSO dim objFile dim objStream fileId = Request.QueryString("fileId") sql = "select * from file where id_file = " & fileId set rs = Server.CreateObject("ADODB.Recordset") Call rs.Open(sql, conn, adOpenStatic, adLockReadOnly) fileName = rs("fileName") path = Server.MapPath("file") & "\" set objFSO = Server.CreateObject("Scripting.FileSystemObject") If objFSO.FileExists(path & fileId) Then Set objFile = objFSO.GetFile(path & fileId) ' write header Response.Clear Response.AddHeader "Content-Disposition", "attachment; filename=" & Server.URLEncode(fileName) Response.AddHeader "Content-Length", objFile.Size Response.ContentType = "application/octet-stream" ' get the data Set objStream = Server.CreateObject("ADODB.Stream") objStream.Open objStream.Type = 1 'adTypeBinary Response.CharSet = "UTF-8" objStream.LoadFromFile(path & fileId) Response.BinaryWrite(objStream.Read) objStream.Close Set objStream = Nothing Set objFile = Nothing else %> <html> <body> <h1>File not found</h1> </body> </html> <% end if set objFSO = Nothing %> Tag: RSS update problem. Tag: 296875
  - 9
    - File System Object Can some tell me how can I search for a particular block of text within the file and delete it? Section of the file I want to change looks like the one below and I want all the lines starting with dteHolidays[ deleted? /* INSERT HOLIDAYS HERE! */ dteHolidays[0] = new Date("01/01/2004"); // CHRISTMAS DAY dteHolidays[1] = new Date("04/09/2004"); // Good Friday dteHolidays[2] = new Date("04/12/2004"); // Easter Monday Any help thanks Tag: RSS update problem. Tag: 296872
  - 10
    - pwd's in dbases Hi all, What is the best way to store a pwd into a dbase? I guess it is hashing it. Read a lot regarding this issue to use md5 for it, but can i use AES for it also? And what is that salt thing doing? And then, there is more, What is the best way to request a login and pwd from a user (client level) without using https or ntlm or something like that, just a clean html / asp thing. John Tag: RSS update problem. Tag: 296871
  - 11
    - PWS replacement I have just upgraded my win98SE pc to winxp home. I am aware that PWS won't work with xp home, and I need to upgrade to XP pro for IIS. Problem is that I don't really want to upgrade unless I have to. I've been investigating the various server options available. I need to run .asp scripts and connect to access 2000 databases. I'm not sure what servers will do this as the documentation is never that clear. Will Apache do what I want, and is there a duffers guide to getting it running? Any other recommendations please? I need something that is pretty simple to get up and running. Thanks Tag: RSS update problem. Tag: 296867
  - 12
    - How to compress String using Visual Basic I have an XML in ASP which has to be compressed and sent to the browser client. I want to use a VB dll to do the job, is it possible? Tag: RSS update problem. Tag: 296865
  - 13
    - Hiding ASP source code I have a customer with an extensive intranet which contains a lot of sensitive company data. The client is concerned that any employee could download source code back to removable storage and thereby steal the data. Printing is considered publicly risky and other capture methods of visble screens would be too clumsy and outside the capability of most. So we have been asked to make the source "invisible" or at least extremely difficult to reveal. Any suggestions please...? TIA .les. o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o Les Juby lesjuby@anti-spam.iafrica.com Webpro Internet - - - Prosoft Microsystems Durban, KwaZulu-Natal, South Africa P.O.Box 35243, Northway 4065, South Africa Tel: +27 31 563-8344 Fax: +27 31 564-4928 o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o (you *do* know to take "anti-spam" out the address....? Tag: RSS update problem. Tag: 296864
  - 14
    - ASP scripts not executing Hi, I've got a computer with XP Pro and IIS 5.1 and can't get the vbscripts to run in my ASP pages. I set up a new virtual directory and turned all permissions on, on the virtual directory and the web site. Example code : <% dim x x = 5 response.write "test" if x > 0 then response.write "x is greater than 0" else response.write "x is not greater than 0" end if %> The above code produces no output, though normal html in an asp page appears normally. Does anyone know what the problem is and how to fix it? Thanks, Phil Tag: RSS update problem. Tag: 296853
  - 15
    - Browser (and other) caching I have a dynamic website system that my clients use to change their webpage conten online. Sometimes the new change isn't visible right away to a browser. I have the following in every webpage's <HEAD> section: <META HTTP-EQUIV="EXPIRES" CONTENT="0"> which on previous investigation was supposed to be a solution for this. All I want is a definitive solution so that when a browser makes a call to my server for one of my pages, everything along the line that has a cached copy of the page is going to say "Aha! The browser wants the latest version of this page! I'm going to pass this request up the line to see if their is a more recent version instead of sending it my cached copy". (Yup, that is how browsers and ISPs speak to each other). What do I have to do to my webpages to ensure this happens? At the same time, I don't want it to be getting the page all the way from the server if the page content hasn't changed. In other words, I just want the cacheing to work properly! Sorry if this isn't an explicit ASP question but no one in the HTML groups I've tried has any idea what I'm talking about and I'm hoping that those who frequent this room will have a better handle on the whole client/server/caching problem and the solution! Thanks! Tag: RSS update problem. Tag: 296851
  - 16
    - asp mail without using a mail component I'm looking for an asp code who can send an email without using a mail component. I started to write somethings using winsock but I don't have enough time to finish it. Does somebody have a such code? Thank you Michel Tag: RSS update problem. Tag: 296848
  - 17
    - Enforce Strong Passwords Hello all, I have a requirement to enforce strong passwords from a customer, and I can only assume they won't be the last to ask for it. Does anyone have any pointers for handling complex passwords? In this particular case I need to enforce between 6 and 16 Case Sensitive AlphaNumerics with at least one non-AlphaNumeric character. min and max I've got, but I'm not sure where to go with the rest. Thanks! Tag: RSS update problem. Tag: 296845
  - 18
    - VBScript and JScript Hi, At the top of my ASP page I declare <%@ Language=VBScript %> what do I have to write to embed some JScript in that page? Do I have to indicate that the code is intended to execute at the client side (if it is the case)? thank you in advance serge Tag: RSS update problem. Tag: 296833
  - 19
    - ASP editor/debugger Hi, I am new to ASP and presently I use a simple text editor (ConText, freeware) to write my ASP code. Is there any good tools outhere to facilitate coding and debugging ASP files? thank you serge Tag: RSS update problem. Tag: 296827
  - 20
    - Session variable cleared by IIS The session variable in my ASP application is expiring without any reason. It works for most of the users but very small amount of users have reported that the application logouts them out as thier session variable has expired even though they have only logged in 5 secs earlier. Does anyone know why this happens? I am using IIS6 with Windows 2003 server. Thanks Tag: RSS update problem. Tag: 296821
  - 21
    - Arrays or Rs in Sessions : Help me plz Hi all, I've got an issue with session variables in asp pages. I need to make a decision that I think you can hopefully help me out here. When a session starts on the iss server I need to store some information in some session variables. But this information is coming from an old dbase system. In the beginning of this project it was just a simple static array of information. Afterwards it turns out that this must be a dynamic array that we could change in other asp pages. Now, at this moment, it is even worse! There are several dynamic arrays (max10) with a lot of records (max100) and intensive changing of data in those arrays, sorting it and so on. The big problem is that I cannot write the changes in those dbases in a direct way and request them back. I know, it would help me a lot. Don't ask why! Ask this question to the green project manager! When the user is logging out then all changes will be save as an xml-file on the server, and some queuing service is picking this up a minute later to control all the data and do finally some dbase changes. My question is: can I change the arrays into disconnected record sets and store them into session variables? I'm using NT2K server with II6. In the old days (nt4 IIS4) they always said that storing objects into session variables are a bad way of programming for IIS. But in this case and with II6??? Some comments would be nice! Thanks in adv. Best regards, John Tag: RSS update problem. Tag: 296817
  - 22
    - Upgrade from MS Access? Howdy all./ Just wondering if there is a drag&Drop solution for migrating MS Access forms to VB.NET? Anyone had any experiences? Tag: RSS update problem. Tag: 296813
  - 23
    - not loading asp We have a web server running IIS 5.0 that will not load any file with an .asp file extension. The server loads .html just fine, but all links to an .asp file end up timing out. Any ideas would be appreciated. Tag: RSS update problem. Tag: 296808
  - 24
    - How to handle, when SQL command returns a single value This is a multi-part message in MIME format. ------=_NextPart_000_001A_01C469CC.7A4566B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I have a problem in dealing with the return value of the SQL = command. I know how to do, when SQL command returns Recordsets. But in = my case it returns a single value. The following code fails when = "objRst.open strQ" is executed. Can somebody suggest me how to overcome = this problem. Any Help is appreciated. Thanks in advance, Vasanth ----------------------- Set objConnect =3D Server.CreateObject("ADODB.Connection") objConnect.Open "Provider=3DMicrosoft.Jet.OLEDB.4.0;Data Source=3D" & = mdbFilePath & ";" Set objRst =3D Server.CreateObject("ADODB.Recordset") strQ =3D "Select MAX(index) from library where index like '*B-*';" objRst.Open strQ cmd.execute while Not objRst.EOF index=3DobjRst("index") objrst.movenext Wend Set objRst =3D nothing objConnect.Close Set objConnect =3D nothing %> <html> <head> <title> </title> </head> <body> <form action=3D"newupdate.asp" method=3Dpost> index:<%=3Dindex%> </form> </body> </html> ---------------------------------------- I also tried the following alternative. Here it fails when I try to = print "objRst" on the page. Set objConnect =3D Server.CreateObject("ADODB.Connection") objConnect.Open "Provider=3DMicrosoft.Jet.OLEDB.4.0;Data Source=3D" & = mdbFilePath & ";" Set cmd =3D Server.CreateObject("ADODB.Command") Set cmd.ActiveConnection =3D objConnect strQ =3D "Select MAX(index) from library where index like '*B-*';" cmd.commandtext=3DstrQ set objRst =3D cmd.execute objConnect.Close Set objConnect =3D nothing %> <html> <head> <title> </title> </head> <body> <form action=3D"newupdate.asp" method=3Dpost> index:<%=3DobjRst%> </form> </body> </html> ------=_NextPart_000_001A_01C469CC.7A4566B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>    I have a = problem in dealing=20 with the return value of the SQL command. I know how to do, when SQL=20 command returns Recordsets. But in my case it returns a = single=20 value. The following code fails when "</FONT><FONT face=3DArial=20 size=3D2><STRONG>objRst.open strQ</STRONG>" is executed. Can somebody = suggest me=20 how to overcome this problem.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Any Help is appreciated.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Thanks in advance,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Vasanth</FONT></DIV> <DIV><FONT face=3DArial size=3D2>-----------------------</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Set objConnect =3D=20 Server.CreateObject("ADODB.Connection")<BR>objConnect.Open=20 "Provider=3DMicrosoft.Jet.OLEDB.4.0;Data Source=3D" & mdbFilePath = &=20 ";"<BR>Set objRst =3D Server.CreateObject("ADODB.Recordset")<BR>strQ =3D = "Select=20 MAX(index) from library where index like '*B-*';"<BR><STRONG>objRst.Open = strQ</STRONG><BR>cmd.execute<BR>while Not objRst.EOF<BR> =20 index=3DobjRst("index")<BR>  objrst.movenext<BR>Wend</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Set objRst =3D = nothing<BR>objConnect.Close<BR>Set=20 objConnect =3D=20 nothing<BR>%><BR><html><BR><head><BR><title><BR><= /title><BR></head><BR><body><BR><form=20 action=3D"newupdate.asp"=20 method=3Dpost><BR>index:<%=3Dindex%><BR></form><BR></bo= dy><BR></html></FONT></DIV> <DIV><FONT face=3DArial=20 size=3D2>----------------------------------------</FONT></DIV> <DIV><FONT face=3DArial size=3D2><STRONG>I also tried the following = alternative.=20 </STRONG>Here it fails when I try to print "<STRONG>objRst</STRONG>" on = the=20 page.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial size=3D2>Set = objConnect =3D=20 Server.CreateObject("ADODB.Connection")<BR>objConnect.Open=20 "Provider=3DMicrosoft.Jet.OLEDB.4.0;Data Source=3D" & mdbFilePath = &=20 ";"<BR>Set cmd =3D Server.CreateObject("ADODB.Command")<BR>Set=20 cmd.ActiveConnection =3D objConnect<BR>strQ =3D "Select MAX(index) from = library=20 where index like '*B-*';"<BR>cmd.commandtext=3DstrQ<BR>set objRst =3D=20 cmd.execute<BR></FONT><FONT face=3DArial = size=3D2>objConnect.Close<BR>Set objConnect=20 =3D=20 nothing<BR>%><BR><html><BR><head><BR><title><BR><= /title><BR></head><BR><body><BR><form=20 action=3D"newupdate.asp"=20 method=3Dpost><BR><STRONG>index:<%=3DobjRst%></STRONG><BR></f= orm><BR></body><BR></html></FONT></DIV></BODY></HTML> ------=_NextPart_000_001A_01C469CC.7A4566B0-- Tag: RSS update problem. Tag: 296804
  - 25
    - ASP Script timeout Hi, I am suffering from a strange problem! I was porting my ASP pages from one server to the other (both Win 2000 Ad. Server). While I ported the reports it is not running at all at the new server and throwing an error: ------ Active Server Pages, ASP 0113 (0x80004005) 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. ----- I tried the normal methods to fix this, changing IIS App settings and increase the script timeout, but no result!!! I have .NET Framework 1.1 installed with Win 2k SP4 in this new server. Rest seems to be the same. Can anyone please point what is happening wrong?? I fetch some data from database, it seems like when the Recordset tries to fecch data, it hangs. If the page has no database interaction, it runs fine! I checked the server process, when I send the ASP page request, the DLLHOST process run by IWAM_<servername> account seems to be taking 99% of the server CPU! Please put some light into it. -surajit Tag: RSS update problem. Tag: 296799

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

Top

Re: RSS update problem. by Curt_C

Curt_C
Mon Jul 19 08:59:35 CDT 2004

little to vague to really help but it sounds like caching. look on
www.aspfaq.com for info on stopping your page from caching

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com

"msnews.microsoft.com" <agbenny@lycos.com> wrote in message
news:eqVEClYbEHA.2972@TK2MSFTNGP12.phx.gbl...
> 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
>
>

Top

Re: RSS update problem. by Rob

Rob
Mon Jul 19 13:34:04 CDT 2004

"msnews.microsoft.com" <agbenny@lycos.com> wrote in
news:eqVEClYbEHA.2972@TK2MSFTNGP12.phx.gbl:

> 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
>
>
>

I expect this is a caching issue...

use response.expires = 0 for starters...

do a search on google for: asp prevent caching
this will give you some more pointers!

Hope this helps!

--
Robert Collyer
www.webforumz.com
Free Web Design and Development Help, Discussions, tips and Critique!
ASP, VB, .NET, SQL, CSS, HTML, Javascript, Flash, XML, SEO !

Top