WMF in RFT-File

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
    - How to align elements and define resize behaviour? Hello, I'm experienced Windows programmer, however, I'm quite novice in HTML technologies. Recently I was assigned a task to write small utility for internal use in our development team. I chose to write its GUI in HTML and make front end as HTA. While developing application's logic is no problem the HTML layout and properties require some additional efforts. So, I decided to ask my questions here, where almost everybody is well proficient in HTML and far beyond hypertext markup. Please, bear with me if my questions seem too dull. My application is wizard-like and has following layout: +---+---------+ I - image | I | iframe | iframe - IFRAME object | | | [] - buttons |---+---------| |[] | [][] []| +---+---------+ It's regular table with elements inside each cell. Now the questions: 1. How can I specify that width of I-cell will be automatically adjusted to the width of image? Currently I hardcoded WIDTH="N", where N is number of pixels. 2. How can I specify that height of second row (with buttons) will be equal to the default height of button? 3. During document resize I want that: a) width of first column (with image) won't change b) height if second row (with buttons) won't change c) height and width of iframe-cell can change freely how can I achieve that? Currently, during resize whole table changes proportionally. Thanks in advance Alex Tag: WMF in RFT-File Tag: 316198
  - 2
    - How to store and retrieve processed salary information Hi All, I want to store the processed salary information in the data base. My requirement is as follows: 1.For each location for an employee , I have to pay/deduct different components (at least 38 )which differ from person to person. 2.Each component is mapped to component table which contains the component Id. I may have 2 options Option 1: Store data in traditional RDBMS system with different rows for different components like Emp No, Location ID, Component Id, Amount. 44, LONDON, 1, 5000 44, LONDON 2, 6000 Drawback: will result in no of obselete, non usable columns. Will result in multiple selects. Option 2:Storing data in one column for each employee in a location Emp No,Location Id,Component ID1,Amount 1,componentID2,Amount 2 44, LONDON, 1 5000 2 6000 Advantage: this SAP like table structure can store dynamic data. Will result in 1 select per employee and location Problem: In 2 option there is difficulty in inserting and selecting data. Please suggest me unique and performance based best way of inserting and selecting data in Option 2 Thanks and Regards, Saurabh Tag: WMF in RFT-File Tag: 316191
  - 3
    - Sending a parameter to webservice with MSXML2.ServerXMLHTTP? Hi How do I send an input-param to my web service with MSXML2.ServerXMLHTTP? Can this be done without the soap-toolkit? Can't find anything about it - looking forward getting some help :-) ------------- Function GetLatest() Dim url, xmlhttp, XMLDOM, XMLNode url = "http://www.mssoapinterop.org/asmx/simple.asmx/echoString" Set xmlhttp = Server.CreateObject("MSXML2.ServerXMLHTTP") Call xmlhttp.Open("POST", url,False) Call xmlhttp.send 'Parse result Set XMLDOM = Server.CreateObject("Microsoft.XMLDOM") XMLDOM.Load(xmlhttp.responseBody) Set XMLNode = XMLDOM.SelectSingleNode("//string") If Not XMLNode Is Nothing Then GetLatest = XMLNode.text End If End Function ------------- Best regards Michael Christensen Tag: WMF in RFT-File Tag: 316189
  - 4
    - problem on Date/Time Data Type Hello there Im having trouble in storing blank or space value on a variable wich data type is Date/Time, if i make a statement like this Field Data Type CPARCAVEDate Date/Time strCPARCAVEDate = rstFEVV.fields("CPARCAVEDate").value if strCPARCAVEDate = "" then counter = counter + 1 end if The value doesnt increment. Do you guys have an idea how to recognize a no value Thanks Leo Tag: WMF in RFT-File Tag: 316182
  - 5
    - connection problem I'm really at a loss on this one. This thing was working just fine, then stopped. The site is http://www.shoppingwithshanda.com/shanda/shandahome.asp All 6 pages are the same code, and that part in the middle, in the yellow, is supposed to show the text that was placed in the Access database, in that one field. I have another page for each of these 6 pages so that the client can type in her info, which is updated frequently. So here's my connection code: From the main page:  From the shandadbinc.asp file:  <% strConnection ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&server.mappath(".\shanda.mdb")&";User Id=xxxxxxxx;Password=xxxxxxxx;" filePath = Server.MapPath("xx.mdb") %> Finally, here's the code for the main page, which should show the contents of the requested field: <h2>Shoppingwithshanda.com is BACK!</h2> <% strHome = Replace(Replace(strHome,"''","'"),vbCrLf,"<br>") response.write strHome %> Please note that I am aware that Access is not a good database, and I am aware that sueing adovbs.inc has problems. It has not been a problem up till this point, and if you think that one of those items is a factor for this problem, then feel free to let me know. If not, please save that discussion for another thread, please. I don't want to get sidetracked. Also, please note that I have saved the db to my Hard drive, where I have dsetermined that there is info in the fields. It is just not displaying. Tag: WMF in RFT-File Tag: 316179
  - 6
    - Unable to debug ASP.NET project Hi, i try to debug a simple ASP.NET project on a windows server2003 and i receive a msg that saya's i dont have permissions and to check if i am in a debugger group. I following the IIS (version 6.0) with the "Manage your server" from the administrative tools. i did the following: 1. make sure that the machine debug manager service running 2. the digest authentication is unCheck 3. add the IUSR_ to the debugger group in the AD (the computer is a domain controller) 4. i gave the user a full control over the wwwroot library i really dont know what else to check. Tag: WMF in RFT-File Tag: 316170
  - 7
    - Downloadable hard-coded RSS reader for ASP Site This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C5D711.97949480 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable I have a client that has asked if I can provide his users with a = downloadable rss reader that is hard-coded to his XML feed only. I'm = thinking the download should be a java applet, any suggestions? K ------=_NextPart_000_0006_01C5D711.97949480 Content-Type: text/html; charset="Windows-1252" 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=3Dwindows-1252"> <META content=3D"MSHTML 6.00.2900.2769" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I have a client that has asked if I can = provide his=20 users with a downloadable rss reader that is hard-coded to his XML feed=20 only.  I'm thinking the download should be a java applet, any=20 suggestions?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>K</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C5D711.97949480-- Tag: WMF in RFT-File Tag: 316159
  - 8
    - Compare Dynamic Field to db Entry Hi I need to compare a dynamic field in an asp page to a field in another table, if there is no match then i would like to chane the row colour ( see code below). The problem Im having is that the comparison should be one of many entries in that db field, at the moment it only compares the first field in the db. Please Help <tr <% Record = Recordset1.Fields.Item("COLL_CITY_TOWN").Value Record2 = Recordset2.Fields.Item("TOWN").Value If Record = Record2 Then strbgcolor="#FFCC66" Else strbgcolor="silver" End If %> bgcolor="<%=strbgcolor%>"> Regards Simon Tag: WMF in RFT-File Tag: 316157
  - 9
    - Falsh text if time NOW() IS < 20 MINUTES AWAY Hi I need to Flash dynamic text on ASP page if the time in the record is less than 20 minutes from NOW() time. Thanks in advance Simon Tag: WMF in RFT-File Tag: 316150
  - 10
    - Showing only part of data in dynamic field Hi I have an asp page that shows dynamic data from the db, I only want to show the first 3 letters / digits from the db on the ASP page. Thanks in advance Simon Tag: WMF in RFT-File Tag: 316149
  - 11
    - Using sql reporting services in asp Can i make us of the sql reporting services in asp? If so then how do i make a call since what i know is that sql reporting services are available as web services? Tag: WMF in RFT-File Tag: 316142
  - 12
    - Database - recursive function calls - how would you do this? .:: The Specs: MS Access 2000 (host charges extra for SQL/MySQL) MS Windows Server 2003 (prod) / MS XP SP1 (dev) .:: The setup: The database has been setup with two tables; tblDownloads tblCatagories Each "download" consists of a catagory field that corresponds to fldID in tblCatagories. Each catagory, where the catagory is a parent, has a parent field of value: 0 and each child, has a field with a value corresponding to the fldID of it's parent. So for example; ********************** fldID / fldName / fldParent ********************** 1 Multimedia 0 2 Audio 1 3 Video 1 Now, each child can have children of it's own (I've not put a drill level on it as the app I'm writing is for a friend and he's specifically asked for "no limit" on how low it can go), so for example (the following represents how tblCatagories is setup); ********************** fldID / fldName / fldParent ********************** 1 Multimedia 0 2 Audio 1 3 Video 1 4 MP3 Players 2 5 Skinnable 4 6 Add-ons 4 7 Misc 6 .:: The problem: What I'm basically needing to do, is count the downloads in the current catagory, so for example, in the case where the selected catagory was MP3 Players, it would run through "MP3 Players", "Skinnable", "Add-ons" and "Misc" and count each download from tblDownloads, that corresponds to one of those catagories. In the case where the catagory selected was null (i.e. default downloads page), it would show all downloads for Multimedia and it's children. The code I've written will get the PC (parent catagory) and it's children, but will not then progress to get the childrens children. I search several places for recursive queries (or alternate ways to do what I am needing) and unfortunately, I've thus far been unsuccessful in finding one that works for my situation (they all either assume to be working with SQL, or that there's a limit on how far down it can go, or uses INNER JOIN (assumes the values are in two different tables, which is not the case here)). Had this been VB, I could have simply used a GoTo [LABEL] where child catagories were present, unfortunately ASP does not support this. No error is returned to the server's logs or the event viewer, and no error is returned to the client browser (client debug is turned on and the browser is set to display the real error, rather than the horrid 500 error), the page (and subequently, the server) stops responding. I've been trying to figure this one out for just over 3 days now and am at my wits end (I know recursive queries work as I've used them before, so why isn't it in this case?). .:: The code: The functions involved are; IsParentCatagory (returns boolean value) HasChildren (returns boolean value) GetChildren (returns long) GetParent (returns long) GetDownloadCount (returns long) The function thats called to get the children is below. What I tried doing was, looping through the children returned (after closing the existing rs of course), and re-calling the function for each child (to then get the childrens children and so on). Unfortunately, this does not apparently want to work. Sub CountEm(lCatID) '// Init call for current catagory GetChildren lCatID '// Debugging (checked that there was actually something to process) '// Response.Write "sKids: " & sKids: Response.End arrChildren = Split(sKids, ",") For x = LBound(arrChildren) To UBound(arrChildren) '// Tried without the Call aswell, just incase Call GetChildren(arrChildren(x)) Next End Sub Function GetChildren(lID) Set oDB = Connect(DB_Downloads, 1) sSQL = "Select fldID, fldParent From tblCatagories Where fldParent = " & lID Set rRst = oDB.Execute(sSQL) If rRst.EOF Then rRst.Close: GetChildren = 0: Exit Function Do Until rRst.EOF '// The following If/End If is on one line, '// just re-wrote it here incase of linewrap If Len(sKids) = 0 Then sKids = rRst("fldID") Else sKids = sKids & "," & rRst("fldID") End If rRst.MoveNext Loop rRst.Close: Set rRst = Nothing '// Once returned, a Do/Loop is performed to run through '// the children and count their downloads using GetDownloadCount GetChildren = sKids End Function What I'm basically wanting to do is recurse to the lowest child catagories (where HasChildren = False), regardless of how far down that actually is, and return the download count for each child (upto and including the top level parent). phpBB does this with ease for their downloads catagory, so I'm almost positive this is relatively simple to do, but for the life of me, I can't figure out where I am going wrong (and can't understand PHP or would have took a look at their coding for hints). As an FYI, I also tried making the above function a sub (since sKids is a public string anyway) and that didn't help either. Does anyone have any suggestions please? -- Regards Steven Burn Ur I.T. Mate Group www.it-mate.co.uk Keeping it FREE! Tag: WMF in RFT-File Tag: 316131
  - 13
    - how to manage frames by c# code Hi, I am new user of Asp.net. I want to open a page in right frame when i click a button from left frame. this must simple but i don.t know how to this? regards omer Tag: WMF in RFT-File Tag: 316127
  - 14
    - Creating an Excel file from ASP and setting a LineFeed From ASP I create response, which is to be shown as an Excel worksheet in the user's browser (by setting the ContentType and creating a table). This works fine. Does anybody know what to do, if one of the cells should contain a multiline text? I already tried by inserting a <br> inside the <td>. But this won't work. -- Michael G. Schneider MTLookup http://www.mtlookup.com Movable Type Weblog http://www.movable-type-weblog.com/ Tag: WMF in RFT-File Tag: 316124
  - 15
    - Building Multilingual Portal Building Multilingual Portal I have been assigned a new project to build a multilingual portal using ASP and/or ASP.NET and the expected Microsoft technologies including ADO and SQL Server 2000. To date, all of my Web Solutions use ADO to access data which is stored in SQL SERVER. Given the need to develop a solution that is very easy to localize, I wonder if now I should consider instead using XML rather than SQL SERVER, or a combination of both. If anyone has experience on this subject, or could point me to some articles, suggesting alternative approaches to developing multilingual portals using XML and/or SQL Server, that would be great. Thanks. Tag: WMF in RFT-File Tag: 316121
  - 16
    - ASP: Multiple page forms, with dynamic form elements - HELP! I'm having serious issues with a page I'm developing. I just need some simple help, and was hoping someone might be able to help me out in here. I have a form, that consists of 3 pages of fields. I'd like to create a page in which all of this is stored as you move along as hidden variables, until the end, when the user submits. I can't figure out one thing: I have dynamic form elements (dropdowns), that I'd like to use instead of setting the dropdowns statically. Here's the dynamic select I'd like to use - can someone help me out? I can't just add them into the code - I keep getting an error message as soon as I do it, but I'm not sure why. Novice ASP developer here. :( Again, all I want to do is replace the <select> from the ASP page underneath with my dynamic <select>... <select name="settingOffered" id="settingOffered"> <% While (NOT rssettingOffered.EOF) %> <option value="<%=(rssettingOffered.Fields.Item("pkSettingOffered").Value)%>"> <%=(rssettingOffered.Fields.Item("settingOffered").Value)%></option> <% rssettingOffered.MoveNext() Wend If (rssettingOffered.CursorType > 0) Then rssettingOffered.MoveFirst Else rssettingOffered.Requery End If %> </select> ********************************************** And here's the page that I can't get to work: ********************************************** <% Const NUMBER_OF_PAGES = 3 Dim intPreviousPage Dim intCurrentPage Dim strItem intPreviousPage = Request.Form("page") Select Case Request.Form("navigate") Case "< Back" intCurrentPage = intPreviousPage - 1 Case "Next >" intCurrentPage = intPreviousPage + 1 Case Else intCurrentPage = 1 End Select If Request.Form("navigate") <> "Finish" Then %> <form action="<%= Request.ServerVariables("URL") %>" method="post"> <input type="hidden" name="page" value="<%= intCurrentPage %>"> <% For Each strItem In Request.Form If strItem <> "page" And strItem <> "navigate" Then If CInt(Left(strItem, 1)) <> intCurrentPage Then Response.Write("<input type=""hidden"" name=""" & strItem & """" _ & " value=""" & Request.Form(strItem) & """>" & vbCrLf) End If End If Next Select Case intCurrentPage <% Case 1 %> <table> <tr> <td><strong>Age:</strong></td> <td> <select name="3_age"> <option></option> <option<% If Request.Form("3_age") = "< 20" Then Response.Write(" selected=""selected""") %>>< 20</option> <option<% If Request.Form("3_age") = "20 - 29" Then Response.Write(" selected=""selected""") %>>20 - 29</option> </select> </td> </tr> </table> <% Case 2 %> <table> <tr> <td><strong>Age:</strong></td> <td> <select name="3_age"> <option></option> <option<% If Request.Form("3_age") = "< 20" Then Response.Write(" selected=""selected""") %>>< 20</option> <option<% If Request.Form("3_age") = "20 - 29" Then Response.Write(" selected=""selected""") %>>20 - 29</option> </select> </td> </tr> </table> <% Case 3 %> <table> <tr> <td><strong>Age:</strong></td> <td> <select name="3_age"> <option></option> <option<% If Request.Form("3_age") = "< 20" Then Response.Write(" selected=""selected""") %>>< 20</option> <option<% If Request.Form("3_age") = "20 - 29" Then Response.Write(" selected=""selected""") %>>20 - 29</option> </select> </td> </tr> </table> <% Case Else Response.Write("Error: Bad Page Number!") End Select %> <br /> <% If intCurrentPage > 1 Then %> <input type="submit" name="navigate" value="< Back"> <% End If %> <% If intCurrentPage < NUMBER_OF_PAGES Then %> <input type="submit" name="navigate" value="Next >"> <% Else %> <input type="submit" name="navigate" value="Finish"> <% End If %> </form> <% Else For Each strItem In Request.Form Response.Write(strItem & ": " & Request.Form(strItem) & "<br />" & vbCrLf) Next %> <p><strong> Here's what you entered: </strong></p> <pre> <strong>Name:</strong> <%= Request.Form("1_name") %> <strong>Email:</strong> <%= Request.Form("1_email") %> <strong>Address:</strong> <%= Request.Form("2_address") %> <strong>City:</strong> <%= Request.Form("2_city") %> <strong>State:</strong> <%= Request.Form("2_state") %> <strong>Zip:</strong> <%= Request.Form("2_zip") %> <strong>Sex:</strong> <%= Request.Form("3_sex") %> <strong>Age:</strong> <%= Request.Form("3_age") %> </pre> <p> <a href="<%= Request.ServerVariables("URL") %>">Start Again</a> </p> <% End If %> Tag: WMF in RFT-File Tag: 316119
  - 17
    - SQL Server Errors - HELP 3 workstations previously installed and able to access server. 4th workstation am able to map to server access files but when attempting to log in receive the following error. EXTERNAL DATABASE OPEN FAILURE Error: -2147467259[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist. The workstation that is unable to connect is running XP SP2, MDAC 2.7.. the difference btwn this and the others is that it is running wireless. Ruled out wirelss as being the problem because hooked LAN cable and receive the same error. Checked that TCP/IP is enabled and port is 1433 Went to Adminstrative Tools ODBC to access server and receive the following error: Connection failed SQLState: '01000' SQL Server Error: 20 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(PreLoginHandshake()). Connection failed; SQLState: '08001' SQL Server Error:20 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Encryption support on SQL Server Tried some other setting changes as well can someone help.. PLEASE !! Tag: WMF in RFT-File Tag: 316114
  - 18
    - DLL from ASP I created a simple dll. I am able to reference and use it from a vb program, but not from an asp page. This code Set o = Server.CreateObject("MyLib.MyClass") gives me this error: Server object, ASP 0177 (0x800401F3) Invalid class string I gave Full Control permission to Everyone to both my dll file and msvbvm60.dll. What is going wrong? Tag: WMF in RFT-File Tag: 316111
  - 19
    - bypassing web form hardcoding login and password I need to hide the complexity from users to access an information webpage, which is normally accessible after filling in a web form with the correct data. The address of the information webpage is like https://external.address.com/info.asp?<numeric code> where <numeric code> is a number generated by the server. This number (always different) is generated by the server only when you open the first web page in your browser, fill in the right values in 2 fields (user, password) and click Login. Any advices? Tag: WMF in RFT-File Tag: 316109
  - 20
    - is it Hidden prame issue? I have an ASP page which has 2 list boxes. When the selection changes from L1 it runs another asp page in hidden frame (hidden1), that page will do some database fetch and will set some control values on the original page. When the selection changes from listbox L2 i.e. it runs another asp page in a hidden frame (hidden2), that page will also do some database interaction and will set some control values on the original page. When these 2 actions explicitely did then they work great. Now I want to load the page initally and I have to set the default values for those 2 list boxes which will ultimately run 2 differnet pages in 2 different frames. This too works well....no issues... My question is, when initally loaded and 2 pages runs in 2 hidden frames that time I noticed that my status bar is still progressing but the values have been already processed and the pages have been procesed in the repective hidden frames. Then, why the status bar is still progressing....this is creating unnecessary confusion and people think that the page is still loading or doing something but the truth is that page is processed and stable to use..... How can I stop that the status progress bar....or any other solution!!! Thanks Tag: WMF in RFT-File Tag: 316107
  - 21
    - Cannot create a asp dot net project I have 2 developper machine running visual studio 2003 and Windows 2000. On the first machine (Machine A) I may create a new asp project without problem. On the second (Machine B) I cannot create a new project. Visual Studo create the project but not the initial files and freezes. But I may create a new project from Machine A using the web server of machine B. I have checked the access rights of both servers, the access rights on directory wwwroot and inetpub. Everything seems the same. Thank you for help Patrick Tag: WMF in RFT-File Tag: 316103
  - 22
    - classic asp byRef vs. byBal what is the default behavior of asp for passing values to a function, byRef or byVal? i was under the assumption that if you do not specify, then it defaults to passing the parameter byRef. so for example, the following function is accepting param1 and param2 as "byRef" parameters: function myFunction(param1,param2) 'do something end function am i correct? thanks, jt Tag: WMF in RFT-File Tag: 316102
  - 23
    - Replace function - error 80020009 Hello, I try to use the replace function with a very long text and I have this error : error '80020009' Exception occurred. Do you have any idee to resolve this problem ? Thanks Tag: WMF in RFT-File Tag: 316094
  - 24
    - Expired Web Page! I want to show users a custom "Page Expired" page when users go back to the previous page by clicking the "Back" button of the browser (or when he right-clicks anywhere on the current page & selects "Back" from the menu). How do I do this? Thanks, Arpan Tag: WMF in RFT-File Tag: 316085
  - 25
    - text stream going back.... I'm using file.OpenAsTextStream(ForReading, _ TristateUseDefault) and then i read some lines. Line = TextStream.readline Then when i finished reading it i need to go to the begiining and read some lines again. But i dont see how to go back to the begining. I mean, Is there a way to go back to the first line of the file if i allready read some lines How do i do that??? Tag: WMF in RFT-File Tag: 316079
- Next
  - 1
    - Randomly generated filename. How could I create a random filename for a single-use download? So, if a user was to download a file from a site it would send them a unique filename that could only be used once. That link would not be available after the download completed. Tag: WMF in RFT-File Tag: 316078
  - 2
    - ActiveX Control problem in ASP with IIS 6.0 Hi I have a custom ActiveX Control that is working fine with ASP in IIS 5.1 on WinXP. But the same ASP page is failing in Server.CreateObject of that ActiveX Control in IIS 6.0 on Win Server 2003. Do i need to change any configuration on my IIS 6.0 Thanks Tag: WMF in RFT-File Tag: 316077
  - 3
    - Delete complete folder Can't find exemple. How can i delete a complete folder including subfolders and files in the subfolders. Or do i to delete one by one ? Gérard. Tag: WMF in RFT-File Tag: 316068
  - 4
    - impersonation, LDAP, IIS6 and my brain full of knots Hi all, somehow I'm going nuts with this authentications inside IIS6, but from the beginning: We have a W2k3 Server running IIS6 with an application running as NetworkService. The Authenticationmode on this Web is integrated Microsoft. Up to now, everything worked fine, but we want to add a new function, which is getting me into problems. The function should be to get informations via SamAccountName by querying LDAP. My first start was to get it done by a serverscript. That failt, because of the NetworkService Account. So, we created a domainAccount, which we put into the IIS_WP group and set the application to run with this. Now the WEB doesn't authenticate anymore. You are prombted for the authentication and if You lookup the Sec Eventlog You see, that the server tries to Authenticate with an empty username and domain. Just the source Workstation is filled with the IP of the Client trying to connect to the Application. After struggling around with some different local policies, I quit. The next Idea was to set up a clientscript, which is started by a Button. The page loads, the user enters the SamAccountName in a field, hits a button and a VBScript-Function is started to query. but now we are running into an ActiveX Error, failt to GetObject. Now to my question. How can I get this running? Just to explain the function I want again: I have a field (NETID) and want to get the rest of the Informations from the AD. Best would be to runn this on the WebServer, which is Member of the AD. Thanks in advance for Your Help. If You need any additional Informatons, don't hesitate to ask. Carsten Tag: WMF in RFT-File Tag: 316064
  - 5
    - Request.Form returns nothing I have a long list of checkboxes and a text field is associated with each checkbox. So I created a loop that should get the value of each text field that has a marked checkbox next to it. Here's my code for each g in gildi aths = Request.Form("rok_" & g) ... next then I create a query with the value and send it. Anyway here's my problem: the aths variable gets the correct value on the first iteration but is blank every time after that. Please help, this is urgent. Tag: WMF in RFT-File Tag: 316063
  - 6
    - cannot compare dates with ASP and Access backend Help! :{ I have a simple select query in an Access database that has three parameters. Two are text, one is a date. If I run my query in Access, it prompts for the date, and two text parameters, I enter them, and they work fine. However, if I try to run the same thing in ASP, I get an error: Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. The code I am using is: Const adCmdStoredProc = &H0004 Const adParamInput = &H0001 Const adVarChar = 200 const adDate = 7 dim cmd set cmd = server.createobject("adodb.command") with cmd .ActiveConnection = "....dsn" .CommandText = "qryName" .CommandType = adCmdStoredProc .Parameters.Append .CreateParameter("strFName",adVarChar,adParamInput,40,sFirstName) .Parameters.Append .CreateParameter("strLName",adVarChar,adParamInput,40,sLastName) .Parameters.Append .CreateParameter("dteDate",adDate,adParamInput,255,cDate(tmpDate)) set rsSched = .execute end with Now, if I go into the query and set the date criteria to be: [dteDate] then it works fine. However, if I set my criteria to be: >=[dteDate] then it errors out. I originally had this as an adodb connection with a SQL string, unfortunately, some of the last names have apostrophes, so this was the only way I figured I could do it. Any ideas? Thanks! Tag: WMF in RFT-File Tag: 316054
  - 7
    - Check directory/file protection? Using ASP in a VBScript environment, how can I check the protection on a directory, or a particular file? Tag: WMF in RFT-File Tag: 316053
  - 8
    - How to build a table layout I would like some guidance as to how to proceed to build a webpage in asp or aspx. I am going to hit a SQL db needing to get the following data: SELECT ServerName,PrimaryTech FROM tblservers GROUP BY PrimaryTech,ServerName The idea is to display the data in a table format where the Column header would the PrimaryTech and under each tech would the ServerName they are responsible for. ie..... John Matt Joe Srv1 Srv3 Srv2 Srv4 Srv6 Srv14 TIA CD Tag: WMF in RFT-File Tag: 316052
  - 9
    - HTTP/1.1 500 Server Error Opening an ASP page brings up this error HTTP/1.1 500 Server Error This is from the Event Viewer: Error: ASP will not serve requests because it could not perform the first request initialization.. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Any ideas will be much appreciated. Thanks, Tag: WMF in RFT-File Tag: 316049
  - 10
    - Hanlding comma in a field in a form which takes currency values Hi, I have form where one has to input officer's salary along with other data. The officer's salary field is tied to a currency field in backend Access. Right now folks enter numbers e.g. 30000.00. However, when someone is writing 30,000.00 a error message comes which shows syntax error. The sql statement via response.write does not allow me to update the database. However, without the comma, things are fine. Is there any way to create a error message, which will not allow one to save the record, if comma is put in the salary value e.g. 40,000.00? Any help is appreciated. Thanks. Tag: WMF in RFT-File Tag: 316046
  - 11
    - The requested resource is in use Error Sorry for the multiple post but did not know where exactly this belonged. I am getting an error message - The requested resource is in use on Windows Server 2003. I have tried check and uncheck the Cache ISAPI extensions. The web server can serve up HTML pages and images. The problem is with the ASP/ ASPX pages. Any help will be much appreciated. TIA Tag: WMF in RFT-File Tag: 316044
  - 12
    - Build page based on link This may have been asked before but I couldn't find it. I'm not really an asp guy but I'm fumbling my way around. I don't have problems creating connections, recordsets etc. But the in's and out's of asp I don't really know. So.... Let's say I have access to data. Based on which links (basically view, edit, new) I want a page to build in a manner reflecting the link that was chosen. That is, if view is chosen just show associated data, if edit is chosen, add to data, etc. It seems like maybe the request object could help me out with this but I'm not sure how. Tag: WMF in RFT-File Tag: 316036
  - 13
    - Get System user name at WINNT and WIN2000 I am writing a web application to get System user name. By reading the previous post, it seems that this method works <%@ Language=VBScript %> <% Dim user, pword user = Request.ServerVariables("AUTH_USER") Response.Write user %> but I want to ask is it only work at WINNT? How about WIN2000 Server, I can get nothing when use this statement on WIN2000 Server. Besides, If I want to use Jsp, is there any methods to achieve the same thing? Thank you! Tag: WMF in RFT-File Tag: 316026
  - 14
    - Topic Completion Everyone who contributed, thank you. But I just wanted to put one final note on this topic to "round out" the real issue and goal of my original post. My real goal was to "obfuscate" the links in my web pages to graphics on an e-commerce supplier's web host. Their domain is different than mine, so I didn't want hackers or other curious types investigating my upline supplier by going to the root of the domain specified in the "img src=" tag. I get a database from them with the name of the graphic, and I have a set of "strings" in my scripts of directories for different sizes of the same graphic, etc... so I put together the URL with two parts, [URL directory "string"] & [graphic name]. When sending any text from the the buffer back to the IE browser, for the rest of all buffer flushes, it is set into a mode that will interpret binarywrites as "ascii"... so, even a small piece of html before the binarywrite will cause the browser to show a bunch of interpreted stuff on the screen... response.clear, gets rid of everything, but I wanted to intermingle the html and by binarywrite. I don't know of a contentType that would make this happen together. Furthermore, writing the file to the disk is way too intensive for just browsing my catalog pages full of graphics, BUT is great code for page scraping and saving graphics. Anyway... it dawned on me. duh. All I wanna' do is make sure they don't know the domain of the graphic source, so... I created an getImage.asp file. It gets two querystrings: Image, and Size. Image is the image name, size is a short variable denoting the directory on the web host (the complete url/[directory] that only I KNOW). From a <img src="getImage.asp?image=[blah]&size=[blah]" border=0> tag within the document one can integrate the graphic because the browser is making separate http socket connections out to the script. The script does the appropriate binarywrite of the responsebody in the img tag container. At first I thought I could "encrypt" the q-string and then that led me to see that I didn't HAVE to put the whole domain URL on the q-string. Other code in this topic would be very good for page scraping. Tag: WMF in RFT-File Tag: 316023
  - 15
    - cdo.message emails stuck in queue I'm working on a classic asp site and am having sending mails in my development environment. In attempting to use CDO.Message the emails usually (but not always) get stuck in my mail Queue folder. Any ideas? I can provide more info if that would help. Thanks. Tag: WMF in RFT-File Tag: 316022
  - 16
    - Replcae Broken Images Not sure if this can be done with ASP but I would like to find a way to detect if an image is missing and replace it with a default image instead of the dreaded RED X showing up. How can I achieve this? Thanks in Advance! Tag: WMF in RFT-File Tag: 316020
  - 17
    - Real Newbie This is a multi-part message in MIME format. ------=_NextPart_000_00A0_01C5D32A.206452A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I just installed Visual Studio.NET and now when I try to just open an = ASP page in my IE browser, it goes straight to the Visual Studio's = Microsoft Development Environment [design] page and I can't figure out = how to get it to show in a regular IE page. Like I said I am a real = newbie with ASPs and visual studio and I am sure most everyone is = laughing at this question, but before I get into reading and studying = the programs, I still need to be able to open a few asp pages that I = already use. Thanks, :-( ------=_NextPart_000_00A0_01C5D32A.206452A0 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.2900.2722" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I just installed Visual Studio.NET and = now when I=20 try to just open an ASP page in my IE browser, it goes straight to the = Visual=20 Studio's Microsoft Development Environment  [design] page and I = can't=20 figure out how to get it to show in a regular IE page.  Like I said = I am a=20 real newbie with ASPs and visual studio and I am sure most everyone is = laughing=20 at this question, but before I get into reading and studying the = programs, I=20 still need to be able to open a few asp pages that I already = use.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks,  :-( = </FONT></DIV></BODY></HTML> ------=_NextPart_000_00A0_01C5D32A.206452A0-- Tag: WMF in RFT-File Tag: 316019
  - 18
    - Recordset! Assume that an ASP page has 3 SQL queries. Can a recordset object be populated with the records of all these 3 queries at the same time? Please note that the 3 queries are distinct queries, not related to each other in any way. Also please note that I am not talking about populating the recordset with the records of the 1st query, then closing it & again opening that recordset, populating it with the records of the 2nd query so on & so forth. Thanks, Arpan Tag: WMF in RFT-File Tag: 316013
  - 19
    - Request.ClientCertificate collection type mismatch I have used simple asp pages to enumerate value/properties of the Request.ClientCertificate collection like so: For Each strKey in Request.ClientCertificate Response.Write strkey & " = " & Request.ClientCertificate(strkey) & "<BR>" Next exactly as suggested in the MSDN documentation here (under the Sample Code for VBS): http://msdn.microsoft.com/library/default.asp?url=/library/en-us/iissdk/html/2c81853d-3199-4013-9e3b-c921d64e549f.asp That worked in W2k Pro sp2 ... last year, but I recently upgraded to XP Pro sp2 and now, that simple asp enumeration throws a VBS mismatch error: Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch /cryptoasp/clientcert00.asp, line 10 I need to explicitly convert to a string to avoid the error using: CStr(Request.ClientCertificate(strkey)) When did this change occur?? Note that this explicit casting to a string using CStr is not required for collections such as Request.ServerVariables Thanks, - Mitch Gallant Tag: WMF in RFT-File Tag: 316008
  - 20
    - How can I avoid the windows authentication for viewing a report Hi: Could anyone pls let me know how can I avoid the windows authentication screen for viewing a report in Reporting Service. TIA Zahir Tag: WMF in RFT-File Tag: 316007
  - 21
    - How to split the contents of a page??? Hi, Hi, > > I have a problem in the display of the ASP screen actually i am > retrieving and displaying the data from a database when the view button > is hit.The contents for display is so long so i want to have a previous, > next link on that page so that some 100 records are displayed in each > page.Pls help me. > I am attaching my code here please help me where can i make the change > to split the display of my page. > > This is for entering the couriers that is received in an company. Here > fd=from date fm=from month td=to date tm=to month fy=from year ty=to year rpt=report and this program displays the details of the courier > received on the basis of the input fdate-from date and tdate-todate will be displayed. > Please help me > > <%@ LANGUAGE="VBSCRIPT" %> > <SCRIPT language="javascript"> > function CClr(oCmp, Num) > { > if(Num == 1) > oCmp.style.backgroundColor = "#FFFFBF" > else > oCmp.style.backgroundColor = "#FFFFFF" > } > > </SCRIPT> > <html> > <title>courier</title> > <body> > > <% > dim fd,fm,fy > dim td,tm,ty > dim rpt,stxt > dim fdate, tdate > dim branch > dim toatalrec > > > fd=Request.QueryString("fd") > fm=Request.QueryString("fm") > fy=Request.QueryString("fy") > branch=Request.QueryString("branch") > fdate=fm+"/"+fd+"/"+fy > > td=Request.QueryString("td") > tm=Request.QueryString("tm") > ty=Request.QueryString("ty") > tdate=tm+"/"+td+"/"+ty > > stxt =Request.QueryString("stxt") > number=Request.QueryString("number") > > rpt="N" > dim cn, rs > set cn = Server.Createobject("ADODB.Connection") > set rs = Server.Createobject("ADODB.Recordset") > > //cn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security > Info=False;Initial Catalog=mmpl;Data Source=mailserver", "it","it" > > cn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist > Security Info=False;Initial Catalog=mmpl;Data Source=aarServer", > "it","it" > > if stxt=VbnullString then > if branch="ALL" then > rs.Open "select * from mmpl_in_trans where rpt_date>='" & fdate & "' > and rpt_date<='" & tdate &"'", cn > > else > > rs.Open "select * from mmpl_in_trans where rpt_date>='" & fdate & "' > and rpt_date<='" & tdate &"' and in_fn='" & branch &"'", cn > > end if > > response.write("<font Face='Arial Unicode MS'><B>INWARD ENTRY <a > href='eml_in.asp'>back</a> <a href='..\mmplinout.asp'>Home > page</a></br>") > Response.Write ("<Font Face='Arial Unicode MS'><B>From : " & fdate & " > to : " & tdate &" </br>") > > rpt="Y" > > else > > rs.Open "select * from mmpl_in_trans where in_details like '%" & stxt & > "%' order by in_fn", cn > > response.write("<font Face='Arial Unicode MS'><B>INWARD entry</b> <a > href='eml_in.asp'>back</a> <a href='..\mmplinout.asp'>Home > page</a></br>") > > Response.Write ("<Font Face='Arial Unicode MS'><B>Searched for : " & > stxt &"</br>") > > rpt="Y" > > end if > > if rpt="Y" then > response.write("<table border=0 > ") > > response.write("<tr colspan=0 onblur='CClr(this, 2)' > onfocus='CClr(this, 1)'><th bgcolor=orange><Font Face='Arial Unicode MS' > size=2>DOCDT </Font></th>") > > response.write("<th height=5 bgcolor=orange><Font Face='Arial Unicode > MS' size=2> BRANCH </Font></th>") > > response.write("<th bgcolor=orange><Font Face='Arial Unicode MS' > size=2>DEPT </Font></th>") > > response.write("<th bgcolor=orange><Font Face='Arial Unicode MS' > size=2>DETAILS </Font></th>") > > response.write("<th bgcolor=orange><Font Face='Arial Unicode MS' > size=2>COU NO </Font></th>") > > response.write("<th bgcolor=orange><Font Face='Arial Unicode MS' > size=2>COU DATE </Font></th>") > > response.write("<th bgcolor=orange nowrap ><Font Face='Arial Unicode > MS' size=2> REC TIME </Font></th>") > > response.write("</tr><tr>") > > if Rs.EOF=False then > Rs.MoveFirst() > > With Rs > response.write("<td align=Center bgcolor='#A4D867'><Font face='Arial > Unicode MS' size=2 >" & .Fields("IN_DATE") &"</Font></td>") > > response.write("<td align=Center bgcolor='#A4D867'><Font face='Arial > Unicode MS' size=2 >"+.Fields("IN_FN")+"</Font></td>") > > response.write("<td align=Center bgcolor='#A4D867'><Font face='Arial > Unicode MS' size=2 >"+.Fields("IN_DP")+"</Font></td>") > > response.write("<td bgcolor='#A4D867'><Font face='Arial Unicode MS' > size=2 >"+.Fields("IN_DETAILS")+"</Font></td>") > > response.write("<td align=Center bgcolor='#A4D867'><Font face='Arial > Unicode MS' size=2 >"+.Fields("IN_CRNO")+"</Font></td>") > > response.write("<td align=Center bgcolor='#A4D867'><Font face='Arial > Unicode MS' size=2 >"&.Fields("IN_CRDATE")&"</Font></td>") > > response.write("<td align=Center bgcolor='#A4D867'><Font face='Arial > Unicode MS' size=2 >"+.Fields("ENT_TIME")+"</Font></td>") > > response.write("<tr>") > Rs.MoveNext() > > End with > next > End if > > > End if > > %> > </table> > <input type="Submit" name="submitted" value="Next"> > </Font></pre></font><form> > </BODY> > </HEAD> > </HTML> > > Thanks, > > Aarthy > *** Sent via Developersdex http://www.developersdex.com *** Tag: WMF in RFT-File Tag: 315994
  - 22
    - serving XML A site I regularly work on has, in its web root, a static XML file. This XML happens to be an ADO persisted recordset with 0 rows, all of ~3 KB in size. (Clients can open it, insert records, and then push the appended recordset back to the server for an UpdateBatch, but that's not important to this question.) Everything works, however, during an analysis of the site's IIS logs, I noticed that requests for this static XML have, on occasion, taken as long 26 seconds to be processed! The thing that's mind-numbing is that we have an ASP script that gets requested 2-3 times more often, that, when called with a certain parameter (that causes it to return last error details stored in the session) has never taken more than a sub-second to process, no matter how busy the server is! This has led me to wonder if this XML is truly as static as I'd assume, so my question is, does an xmlns attribute cause an implicit request, thus imposing a dependency on a foreign site? Specifically, does "xmlns:rs='urn:schemas-microsoft-com:rowset'" cause an http request to schemas.microsoft.com? Given that requests for ASP scripts are completing concurrently while a request for this static file is being "processed", what could cause this tiny little download to lag so badly? I'm considering changing the file to an ASP, that sets content type and then response.writes the XML from a string buffer, but I can't imagine how that could be more efficient. (The server O/S is 2K3/IIS6.) tia, Mark Tag: WMF in RFT-File Tag: 315983
  - 23
    - msxml2.serverXMLhttp and response.binarywrite Question: I get the eror listed at the bottom of the post. What can I do to make the response of the x1.send a "binary" type? Or, in general, how can I just "make this work"? <%@ Language=VBScript %> <% Response.Buffer = TRUE Response.ContentType = "image/jpg" Set x1 = Server.CreateObject("Msxml2.ServerXMLHTTP") x1.open "GET", "[http link to your favorite image.jpg]", FALSE x1.send Response.BinaryWrite x1.responsestream set x1 = nothing %> Error is returned below: 'Response object error 'ASP 0106 : 80020005' 'Type Mismatch '/scraps/getGraphic.asp, line 10 'An unhandled data type was encountered. Tag: WMF in RFT-File Tag: 315981
  - 24
    - ASP/SQL Connundrum (kinda long) Hey guys, I currently have a giant client editor form in ASP/SQL. The form is fine. The problem is that there are several sub-forms that store their data in other tables. Which gets cluttered. For example, I can't let users add data in these sub-forms until the main form is completed and an autonumbered ID is generated. We're taking a few months out of new developments to go back and fix a bunch of things (like this), and I was wondering what the best way would be (if anyone has run in to a similar issue) to allow a large editor that touches multiple tables to have one giant master "Save" button that validates everything and that doesn't make changes until it's clicked. Sadly, transactions are unable to span across multiple pages (and I don't wanna store recordsets as session objects), and they wouldn't work anyways, since in the event of new additions, I would need to wait until I have that autonumbered ID generated before I attempted to store anything in one of the smaller tables. I was thinking of perhaps session variables that corresponded with the names of the tables that I was working with that had an array of data that corresponded with {fieldName} => "Value," and then loop through it and validate it, then execute the appropriate SQL. Cliffs: In ASP/SQL, does anyone know of some industry-standard way to have one "Save" button store data collected through multiple pages, assuming that in some cases, when adding a new record, we'd need to get the value of the autogenerated "ID" field first before saving data that affects other tables? Wow... what an obnoxiously long question. If you're bored, feel free to read through :) Tag: WMF in RFT-File Tag: 315979
  - 25
    - Time Function returns Wrong Time I am writing an ASP program that includes a Form. When the Form is submitted I use the Date() and Time() functions to put the date and time into the Body part of the e-mail. The time reported is three hours earlier than the time at which the Form is actually submitted. I understand these functions are evaluated on the server so the server must be in a time zone three hours earlier than where I am . Is there any way I can get the local time at the location where the user is actually located. ?? Thanks Tag: WMF in RFT-File Tag: 315977

In my Database I stored a few Logos. so I want to generate an RTF-File witch
contains the logo and many more things.

In the Database the Value looks like this:
imgLogo
----------------------------------------------------------------------------------------------------------------------------------------------------
0xD7CDC69A000000000000FF004200570000000000FB570100090000034E1400000900FE02000000000400000003010800050000000B....

but in the RTF-File it should be like that:
0100090000034e1400000900fe02000000000400000003010800050000000b0200000000050000000c029d02fa09030000001e00030000001e00030000001e00...

How can I paste that?

Thanks in Advance!

Top